pdf creation issue on a single file?

users
#21

Hi Miguel,

Hi,

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?

I was using LibreOffice 3.3 and have since updated to LibreOffice 3.4.5
OOO340m1 (Build:1505). Unfortunately the newer version is unable to
`Export as PDF' on the selected TABS either!!

What could be wrong? There are no special characters in the sheet names
bar possibly a space.

I will gladly send this file to anyone who can assist as I need to
create and post to a public user mailing list a PDF at the end of the
month.

Help is much appreciated
Hylton

Thank you for commenting on the OP's initial problem, and not a Linux
Windows word flame-war that bears no relation to the subject line,
despite some valid suggestions being valid.

Verify you have not marked in the same tab the option:
Embed OpenDocument file.

How could I check this via the GUI? I recreated the last graph and made
sure there were no 'embeds' of any kind. Could non-standard fonts i.e.
not Arial, also play a part?

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.

Hylton

Hi Hylton,
sure I have not explained with the required detail.

The option is in:
Menu/File/Export as PDF/[General] - General - Embed OpenDocument file.

This option is not available on my version of LO 3.4.5 only 'Embed Standard fonts' is available, which is not selected.

If this option is enable the only chance is to export the complete
document.

This option embed the ods document in the pdf file, and if you later
open this pdf in LibreOffice the ods document is open. IMO a very
interesting option to share a document, an accurate view plus an edit
file option.

About other non related things with your question, you are right, IMHO
people would be better answer what it is asked, and if they like to
comment about other things start their own thread.
Too much blah blah blah, with few helping answers.

Thanks for the idea, but alas the problem persists.

I have Cc'd you and include the file as an attachment, that I know will be stripped by TDF for the mailing list but you should receive it. Once you open the file in Calc, select all the tabs from July to General, Choose File: Export to PDF, Choose only selection, save the file on your system and then re open it with Adobe Acrobat to check all pages exported.

If they did what version of LO are you running?

Regards
Hylton

#22

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?

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.

I trust this helps.

Brian Barker

#23

Brian and Miguel,

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?

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.5

What 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

#24

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.

#25

You have a print range defined on sheet 20 of 24 ...

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.5

What made you or how did you check for print ranges i.e. what alerted you that that might be causing the problem?

As soon as I established that only one sheet could be exported, it was an obvious possibility. Format | Print Ranges > | Remove on that sheet was not greyed out, so there had to be something there. Format

Print Ranges > | Edit... told me what it was.

Brian Barker

#26

Am 28.07.2012 15:42, Hylton Conacher (ZR1HPC) wrote:

I will gladly send this file to anyone who can assist as I need to
create and post to a public user mailing list a PDF at the end of the
month.

Yes, please.

Help is much appreciated
Hylton

Let's see what I can do for you.

#27

My thanks go to Roger Barker and Miguel Angel.

#28

Forgive me, but if you're going to post this as "solved" could you
include the solution? I didn't see it....