On 08/17/2008 11:26 AM, Robert Farkas wrote: > *Dear OpenOffice Developer Team* [snip]
Note that this is the users list, hence you'll not find developers here (in general). > > *In the Windows version *the *Page Break Preview* option from *Open > Office Calc → View → Page Break Preview* there is a serious bug. For > short: I have created a file in Calc in *ods* format but the problem is > valid for *xls* format, too. I have created a file, namely "* > @[EMAIL PROTECTED]". I created 10 sheets within with tables and > diagrams. Note: all of the files which I mention here will be attached to > my > mail in order to give you the opportunity to study this problem. So, > normally when I want to print out the all the 10 sheets or to save them in > a > single *pdf* document by the incorporated *pdf* creator engine from Calc, > or by using a virtual printer, for exemple: PDFCreator from: > http://www.pdfforge.org/products/pdfcreator/download , to create the *pdf > * document it works. That's fine up to now. The problem starts when I > realize, that the sheets' papers are not properly arranged. For example: > when I realize that there are empty pages in the document and I want to > eliminate them, or if I observed, that some parts of the texts or objects > are spreading onto another page unnecessarily and it spoils the design or > display of the document. Normally, in MS Excel with Page Break Preview > option I am able to modify the document, even to save the document in Page > Break Preview *without loosing any data and print out all pages.* *But > unfortunately this can't be said in OpenOffice Calc.* Although it exists > the option: *Open Office Calc → View → Page Break Preview* exists, BUT if > I dare to modify something in *Page Break Preview* and save it in *Page > Break Preview* , the result will end up in total date loss except the > current sheet in which I made the save in *Page Break Preview* mode. *In > my attached example: I was implicitly in "Esenta_2005_2010" sheet, and I > swiched to Page Break Preview, I eliminated the unnecessary empty spaces, > than I saved the document. The result was that just the current sheet is > wholly printable and savable in pdf format, all the other 9 sheets are > unprintable. WHY?* * *The document is a financial analysis of a > corporation, so in this case I could have lost significant data or I have > to > redo the whole document. > > PLEASE, HELP ME! DO SOMETHING! Thank you. The difference between the 'works' and 'doesn't work' is the print range settings. If you look at: Format|Print Ranges|Edit in 'works', you'll see that there is no defined print range. If you look at it in 'doesn't work' you'll find that the print range is defined as: $A$1:$I$223 (pages 1-7). Delete the print range and you can now print all 33 pages to PDF; alternatively, define the ranges you wish to print and print those. -- You have been cc'd on this reply as you have posted to an open OOo mailing list. Please see: http://www.openoffice.org/mail_list.html for details and how to subscribe or view the archives so that you may see responses from other OOo users. Please *only* reply to [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
