I have a Calc document containing 9 sheets. Attempting to export sheet 8 as pdf actually exports sheet 7. Exporting sheet 7 (or any others I have tried) is correct. Sheet 8 prints to printer (including a pdfmaker printer) correctly, and is correct in Print Preview.
Couldn't reproduce in 3.5.6.2 on Windows Vista, nor on master. Could you possibly attach a sample document where this happens and/or provide steps to reliably reproduce the issue?
Created attachment 67213 [details] Cut down file which shows the problem I have cut back the document and anonymised the data, and I attach a document which shows the problem. There are two sheets "Contact List" and "Contact List Display". Exporting "Contact List Display" as PDF produces a file which actually shows the data from "Contact List". I am running under Windows 7.
Hello I do not reproduce with Version 3.6.2.1 (Build ID: ba822cc) & windows 7 64bits Note: the program requests the range to export. One of the options is "Pages", does not mean "Sheet" (a sheet can take several pages). Could you provide step by step how you select the sheet to be exported ? For example: 1. File> Open the attached spreadsheet 2. Click on tab "Contact List Display" to select this sheet 3. Select A1:D19 4. File> Export as PDF 5. Tab General, Range: Selection 6. Export Regards Pierre-Yves
(In reply to comment #3) > Hello > > I do not reproduce with Version 3.6.2.1 (Build ID: ba822cc) & windows 7 64bits > > Note: the program requests the range to export. One of the options is "Pages", > does not mean "Sheet" (a sheet can take several pages). > > Could you provide step by step how you select the sheet to be exported ? > > For example: > > 1. File> Open the attached spreadsheet > 2. Click on tab "Contact List Display" to select this sheet > 3. Select A1:D19 > 4. File> Export as PDF > 5. Tab General, Range: Selection > 6. Export > > Regards > Pierre-Yves
(In reply to comment #3) > Hello > > I do not reproduce with Version 3.6.2.1 (Build ID: ba822cc) & windows 7 64bits > > Note: the program requests the range to export. One of the options is "Pages", > does not mean "Sheet" (a sheet can take several pages). > > Could you provide step by step how you select the sheet to be exported ? > > For example: > > 1. File> Open the attached spreadsheet > 2. Click on tab "Contact List Display" to select this sheet > 3. Select A1:D19 > 4. File> Export as PDF > 5. Tab General, Range: Selection > 6. Export > > Regards > Pierre-Yves Pierre-Yves, Thanks for the suggestions. I have done some more tests. When "Selection" is selected, the export seems to be correct, either exporting the selected range (if there is one), or the whole sheet (if not). When I look more closely, I see that exporting as "All" actually includes both the sheets in the test file, implying that "All" means "All Sheets", rather than "The whole of the current sheet" - is this correct? However, when I export from "Contact List Display" to "All" in the original file with many more sheets, it only exports "Contact List" and "Contact List Display", and not any of the other 6 sheets in the file. Attached is an anonymised file which shows this behaviour. Roger
Created attachment 67243 [details] FIle showing problem with more than 2 sheets
(In reply to comment #5) > Thanks for the suggestions. You're welcome > When "Selection" is selected, the export seems to be correct, either exporting > the selected range (if there is one), or the whole sheet (if not). Ok > When I look more closely, I see that exporting as "All" actually includes both > the sheets in the test file, implying that "All" means "All Sheets", rather > than "The whole of the current sheet" - is this correct? All Sheets... having a print range defined, yes > However, when I export from "Contact List Display" to "All" in the original > file with many more sheets, it only exports "Contact List" and "Contact List > Display", and not any of the other 6 sheets in the file. One possible explanation is that the sheets not exported have no print area defined. To check: Format> Print ranges> Edit. Parameters may be set to "none" > Attached is an anonymised file which shows this behaviour. The attached file crashes my LibreOffice... Regards Pierre-Yves
Created attachment 67505 [details] attachment-15253-0.html (In reply to comment #7) > All Sheets... having a print range defined, yes Ah! I had not appreciated that a Print Range was required to export - I don't think it is always required to print... I am satisfied that there is not a bug, but rather a lack of understanding on my part as to the operation of Export as PDF. I've changed the status to Resolved/Invalid> Thank you for your support. > > The attached file crashes my LibreOffice... > Sorry about that - it doesn't crash mine. Regards, Roger
Pierre-Yves, Thanks for the suggestions. I have done some more tests. When "Selection" is selected, the export seems to be correct, either exporting the selected range (if there is one), or the whole sheet (if not). When I look more closely, I see that exporting as "All" actually includes both the sheets in the test file, implying that "All" means "All Sheets", rather than "The whole of the current sheet" - is this correct? However, when I export from "Contact List Display" to "All" in the original file with many more sheets, it only exports "Contact List" and "Contact List Display", and not any of the other 6 sheets in the file. Attached is an anonymised file which shows this behaviour. Roger On 16/09/2012 13:25, bugzilla-daemon@freedesktop.org wrote: > https://bugs.freedesktop.org/show_bug.cgi?id=54818 > > --- Comment #3 from pierre-yves samyn <pierre-yves.samyn@laposte.net> 2012-09-16 12:25:00 UTC --- > Hello > > I do not reproduce with Version 3.6.2.1 (Build ID: ba822cc) & windows 7 64bits > > Note: the program requests the range to export. One of the options is "Pages", > does not mean "Sheet" (a sheet can take several pages). > > Could you provide step by step how you select the sheet to be exported ? > > For example: > > 1. File> Open the attached spreadsheet > 2. Click on tab "Contact List Display" to select this sheet > 3. Select A1:D19 > 4. File> Export as PDF > 5. Tab General, Range: Selection > 6. Export > > Regards > Pierre-Yves >
Created attachment 67506 [details] attachment-15253-1.dat
Created attachment 67507 [details] pdfDemo2.ods
(In reply to comment #9) > When I look more closely, I see that exporting as "All" actually > includes both the sheets in the test file, implying that "All" means > "All Sheets", rather than "The whole of the current sheet" - is this > correct? As already said, all sheets... having a print range defined, yes > However, when I export from "Contact List Display" to "All" in the > original file with many more sheets, it only exports "Contact List" and > "Contact List Display", and not any of the other 6 sheets in the file. > Attached is an anonymised file which shows this behaviour. Verified in pdfDemo2.ods : other sheets have no print range defined... Regards Pierre-Yves