Apache OpenOffice (AOO) Bugzilla – Issue 20027
Is there a way to attach a Calc and a Write document together?
Last modified: 2003-10-09 08:54:03 UTC
Quite often I will create a spreadsheet with financial or number analysis information in it, and I would like to attach a word processing document to it with explanatory notes about the spreadsheet. It would be very useful to be able to somehow attach the documents together, perhaps placing the Writer document in one of the Calc tabs. In MS Office you can drop a spreadsheet into a MS Word document, and this would be good, but this is a little different where the Writer document gets attached to the Calc document.
Hi, this is neither a bug nor a feature request. This is a support request and therefore will be handled on the mailinglists, especially users@... Just write your text and save it. Go to Insert Object OLE Object create from File or use Insert Floating Frame. Frank
closed invalid
Are you sure about this? I am well aware of MS Office's and OOo's ability of inserting an object into a document, but for years I have been creating complicated spreadsheets and having to save a Word document in the same directory as the spreadsheet to contain detailed notes about the spreadsheet. I'm talking about several pages of information in the Word document, that can be easily edited/added to or printed out and read whilst viewing the spreadsheet on a screen. They are two distinct entities, as opposed to inserting an object into another one, where they become one file. Perhaps an alternative would be to attach a word processing document in such a way that it occupies a tab on the spreadsheet, although I understand from a programming perspective this may be quite difficult to do. I know that you can insert an object there now, but it ends up being quite messy in OOo, and somewhat cumbersome in MS Office. To keep them somehow attached to each other would be a very convenient way of storing the two documents and I have always wanted to be able to do this. I feel that may other managers would also benefit from such a feature, and it is one that MS Office doesn't have.
Hi, yes, I'm sure. What you describe is perfectly handled by the floating frame feature. have you ever tried it ? Write the comments on your spreadsheet into a writer file and save it. Go to the Spreadsheet, select an empty sheet and select Floating Frame from the Insert menu. Follow the dialogs and maybe alter the size of the frame. That's it. Frank PS What's about using notes ? Select note from the insert menu.
closed wontfix