Detlef Grittner schrieb: > I thought, well, maybe Writer is the better app for my purpose and > linked the Calc spreadsheet into a Text document with my comments. > Unfortunately the Calc table now spread over several pages and it is not > possible to paginate it in Writer. That is you can put the OLE object on > one page and select a part of the Calc contents, which is viewed, but I > want to show all contents spread over several pages. Exactly as tables > in Writer do it, but when I imported the spreadsheet as table, I lost > the formulas of the calculations of course.
You could set Writer into "WebLayout" and then insert the spreadsheet as an OLE object. This way it can be bigger than a page. Won't help for printing admittedly. > Not to mention what happened when I tried the same with MS Office, > frankly speaking I turned the output into a piece of modern art with it. > Although I am aware that it is not so easy to implement OLE > functionality that allows Writer to paginate Calc spreadsheets, this > would be a feature, which currently no office suite seems to implement. The OLE implementation of MSOffice always was very bad, it was bad on Win3.1 (the first time I had to work with it) and it still is. It only works reliably with MSOffice applications. > What would be needed is: > - Paginate OLE Calc spreadsheet tables like tables in Writer. If you are in the print layout you can't do anything as OLE object views can't be bigger than a page. So what comes as close as possible would be an insertion of multiple objects, each one containing a view to a part of the same spreadsheet. Basically doable but quite some effort. > - Resize cells in Calc containing OLE Writer documents automatically to > the size of the document. OLE objects are not inserted into cells, they are bound to the drawing page that lies behind the cells. So no way for this. > - Paginate OLE Writer document in Calc together with the cells, without > overlap. I'm not sure if I understand. The limitation to page boundaries for OLE objects is true for Calc also, though you will not see it in the "regular" layout, only the page layout will show this. > Combine the functionality of Calc and Writer into one application. Then > you have a worksheet and simply put text or tables on demand onto it. Yes, that's what I described (more or less). But that would be completely new application. Ciao, Mathias -- Mathias Bauer (mba) - Project Lead OpenOffice.org Writer OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't reply to "[EMAIL PROTECTED]". I use it for the OOo lists and only rarely read other mails sent to it. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
