On 07/31/2012 09:53 AM, Hylton Conacher (ZR1HPC) wrote:
Brian and Miguel, On 31/07/12 03:03, Brian Barker wrote:At 15:42 28/07/2012 +0200, Hylton Conacher wrote:I have an rainfall.ods document that has 24 tabs. Two of the tabs contain figures and the balance contain graphs of the figures. I recently experienced a problem, it would seem after my last tab addition, that prevents me from creating a PDF file of the selected sheets(12). The PDF export works fine on other files regarding `Export as PDF', why not on this file?At 18:12 29/07/2012 +0200, Hylton Conacher wrote:Further to this issue it would seem that only the last created graph is being exported (but this is NOT the last selected Tab) as when I view the exported PDF, only a single page shows, instead of approx 12.Easy - now that I've looked at the document. You have a print range defined on sheet 20 of 24 ("Ann Monthly Comp"). You may be assuming that - since this print range is set to "entire sheet" - that it will have no effect on the output, but that is not so. If you have a print range set anywhere in your document, it affects the whole document, and no other sheets will print except where they, too, have print ranges defined. And print ranges, it seems, apply equally to Export as PDF as to Print itself. Remove the print range from the rogue sheet (Format | Print Ranges > | Remove) and everything is hunky-dory.My heartfelt thanks on resolving the issue of non export of tabs in a PDF. Your solution and instructions on how to remove worked flawlessly. I have no idea how the print range got there in the first place as I have never used them and only upgraded from LO 3.3 to LO 3.4.5What made you or how did you check for print ranges i.e. what alerted you that that might be causing the problem?Thank you again and I will definitely pass this onto bug 32771 for comment #13 and others.May your keyboards always type true Regards Hylton
Are you talking about the Rainfall.ods file problems with all of those different tabs for different sheets and graphs?
I received a copy of the file and for a lack of trying anything, I saved the .ods file to and Excel 2003 .xls file than closed that document. Reopened the .xls document in Calc and it worked. When I did the Export to PDF, it created a 24 page document that has the graphs. I also made sure the page was formatted as Landscape.
I do not know why, but I thought is there was some issues in the file itself, saving it as an Excel file and then taking that file and saving it back to a Calc document might remove the problem as if it was not something that could be recognized by the other file format. Something was in the file's structure or coding that caused the error. So when it got saved to .xls, that problem was not able to be transfered to the new file format.
The .xls file was almost 10 times the size of the original .ods file and the newly saved .ods file was smaller than the original file by about 3 KBs. So maybe that process got rid of the bad coding.
Whatever it was, the Rainfall.ods file works now for printing. You can see the graphic sheets in the page preview, where I got a blank page with the original one.
-- For unsubscribe instructions e-mail to: firstname.lastname@example.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted