pdf creation issue on a single file?

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

What is you OS?
Windows, Linux, Mac? Which version.
What version of LO are you using? Your statement of using 3.3 since 3.4.5 is confusing. Are you using 3.5.5, 3.5.4, 3.5.3?

while someone tries to figure out the issue, if you use Windows, please download doPDF - free PDF printer software. Linux - CUPS-PDF.

With the PDF printer installed print the document to the PDF printer, like you would a paper printer.

Then see if creating a PDF that way works. If it does, then it is the PDF Exporting option. If not it may be in some generic printing option or some other issue.

I tend to use a PDF printer more than Exporting to PDF, since I "print" PDFs from many different packages and "forget" to use the Export option. I have PDF printing as my default printer.

omega
  The
Omega sector
America's Last
Line of
Defense

*Don't you have the ability to print to a PDF file ? Linux gives me the choice to print the file or print to a PDF file and asks where to save it and a name for it . . You must be a windows user LOL ! I really feel sorry for windows users ROFLMAO

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

Miguel Ángel.

Windows users can get free PDF printer drivers, like doPDF. Linux users can use other options like CUPS-PDF. What are you using to print your files to PDF with?

We what to encourage Windows users, and to tell them they are stupid to use it. I know of many people who cannot use Linux due to software needs that will not run with WINE. I must keep a Windows system for both hardware and software needs. I prefer Ubuntu, but I know that most people will not switch to Linux no matter what we tell them.

We need to get more and more Windows users to get away from MSO and get them to look into FOSS as a viable option for their software needs.

For most users, Windows is a viable option over Linux. As long as they feel comfortable with it.

I know we had a thread before about not telling people that my/your OS is better than someone else's. Every user has their own needs and own ideas of what OS is better for THEM.

Right now we want to help users to see that LO is right for them, no matter which OS they use. I have it on 2 version of Windows and 2 versions of Ubuntu. We need to help users with their issues and not "joke" that there is something funny with the OS they are using. I do not find it to be funny.

If a user is having problems with the Exporting/Printing to PDF that is a part of LO, then I would say that they need to install a PDF printer options - doPDF for Windows and some option depending on the version of Linux they use. Then test the PDF output with one of those PDF printers. If they have the same issue, then it is not the Exporting to PDF that is the issue. A different poster to this thread has come up with an option for the user to test. I am not a Calc person, so I look at the Exporting/Printing part of the issue and let some one else take on the possibility of it is something to do with the setup of the file itself and not the printing part of it.

BUT
whatever we do, we should not make fun of the user, his/her OS, the system used, or even state it is all due to them using an older version of LO. Not all of us have the money to buy a better system, have access to Broadband so they can download a newer version every time one comes out. No everyone will feel comfortable to use Linux for their system, or can change their OS due to some requirement that they have no control over. Business users may not own their systems and may have a difficult time even to be allowed to use LO instead of MSO.

To be honest, we need to accept that we have a lot of Windows users that have the option to use MSO and we need to prove to them that LO is a viable option to use instead of buying another version of MSO. LO is not the default for most Linux versions. MSO is the package most Windows user know as their only office package option. We need to get the word out there to these Windows users that LO is there and we want them to try it. We do not want them to think we are stuck-up egg-headed Linux users that do not accept that there is anything wrong with them using Windows. I prefer to use Ubuntu, but I do not think most Windows users will be able to switch. I know of some Linux users who had to make one of their system run Windows due to the fact that need to use a certain type of software and Linux does not have the software they need. One young fellow needs some really good post-production video editing software. He prefers Linux for everything, but he just cannot find the software he needs for Linux.

So
LO runs on many different OSs. Then be a support to all of those different OS users for LO and not blame anything on their choice of OS. IF we do, then we might as well start telling people that their version of Linux is laughable over our version of Linux. Now where would you think that would get us? Nothing but trouble and in-fighting.

I'm running LO on Ubuntu 12.04. I've used all previous versions of LO through the present 3.5.5.3. My experience with export to pdf is that the entire file is exported. It does not work to select one page or a certain selection on a page. If I want to print just 1 page of a multipage document or print a section of a page, that needs to be done with a pdf printer, such as the one webmaster-Kracked_P_P mentioned below, and not through export to pdf.

Don't start that. I used Linux from the earliest days. (0.94 Kernel and SLS Linux). I now use W7 and there is nearly nothing I could do in Linux that I cannot do in Windows easier. I do use Firefox and Thunderbird, and OpenOffice, not MS' tools. I don't do servers.

The big problem with Linux is drivers. Drivers are less of a problem with Windows unless you are trying to make new hardware work with old Windows versions, or conversely.

What I can't do in Windows is certain kinds of maintenance without resorting to outside tools.

Note that I was a RABID Linux user.

Nevertheless I am certain you have your excellent reasons for liking Linux. There is a huge amount in Linux to like. It's more work than I want to do. So please, don't poke fun at Windows users. Help them.

David Teague
Emeritus Professor Mathematics and Computer Science Western Carolina University

I do the following with my "browser printing":

Print the web page to a PDF document - since you cannot choose pages - and then open up the PDF document and choose wich page to print out.

I do that type of printing most often with ALL of my packages that can print to a printer physical printer. LO is just different since it can use its internal PDF option instead of an external PDF printer

There are some things that LO's PDF option does not do was well as CUPS-PDF or doPDF, but LO can create a landscape viewable document so you can read it properly, but CUPS-PDF makes it oriented landscape but viewed as portrait document. Not good for documents needed to be read and not printed in landscape mode.

I have used LO since 3.3.0 and went from 3.4.6 to 3.5.4, skipping .0 through .3 for that line. I now have all my working system [except one which will change soon] and will get put the stored "spare systems" and install 3.5.5 or 3.5.6 depending when I get the time to get into updating the stored XP and Ubuntu 10.04 systems. I currently run Ubuntu 10.04/GNOME [desktop], 12.04/MATE and Vista [dual boot laptop], and an XP laptop, on my "working or at least currently using" systems. Using CUPS-PDF and doPDF as the default printer is on all of my systems, working and stored.

<large cut>
For everybody who needs to use for some reason Windows:
use VMware (or VirtualBox) under Linux(ubuntu or whatever version) and run (preferably Windows XP) for your Windows stuff. No need for dual booting. Simply have one desktop with Linux and a second with virtual XP. Switching is as easy as using CTRL-left arrow or CTRL Fn (where n is the desktop number. Most distributions come with 4 desktops.
Hope this make life a little easier for you,
Joep

David,
As I said the few tasks you need to have done for which developers didn't make Open Source (Linux) versions can easily accomplished in
in a virtual Windows XP using VMware or VirtualBox. Nuch more stable and no virus nightmares.
Dr. J.L. Blom retired Neuroscientist TNO the Netherlands

omega
  The
Omega sector
America's Last
Line of
Defense

*I dump it off to a HP Laser jet 1522 something and it prints like crazy has fax, Printer. copier, and scanner all in one thing
I got it for free seems the office has windows and the driver got lost and the printer would not work any more AWW GEE ! I pugged it in and turned it on and started printing

So they got another one ( same as this one ) and I got this one with a NEW printer cartridge in it . . standing in right spot a right time I guess
It Says I can go thru about 10 of the 500 sheets per package things from Walmart or Staples and so far I have only used it for about 1 package of paper stil got about 30 in the printer and 50 or so left in the package so Next month I splurge and get another package of paper

Replies below

What is you OS?
Windows, Linux, Mac? Which version.
What version of LO are you using? Your statement of using 3.3 since
3.4.5 is confusing. Are you using 3.5.5, 3.5.4, 3.5.3?

while someone tries to figure out the issue, if you use Windows, please
download doPDF - free PDF printer software. Linux - CUPS-PDF.

With the PDF printer installed print the document to the PDF printer,
like you would a paper printer.

Then see if creating a PDF that way works. If it does, then it is the
PDF Exporting option. If not it may be in some generic printing option
or some other issue.

I tend to use a PDF printer more than Exporting to PDF, since I "print"
PDFs from many different packages and "forget" to use the Export
option. I have PDF printing as my default printer.

The OS is openSuSe 11.2
LibreOffice version is as stated i.e. LibreOffice 3.4.5 OOO340m1 (Build:1505)

A newer edition of LO has not appeared via my Yast software manager, despite there being a few updates.

I am sorry, but I can not help with this issue - however I did find it
helpful for a similar sort of problem that I have. 
 
My problem is that I am trying to copy data from PDFs into a
spreadsheet - but all the conversion software that I have found does not
seem to handle PDFLITE which is what doPDF and several other such
packages seem to produce.
 
Any solutions anybody?  How do I get data from a PDFLITE into a
spreadsheet?

I was told that there are "Security issues" with 3.4.6.

I download my version[s] of LO directly from LO's download pages, since it usually has the newest version[s] there well before the repositories do. For older distros of Linux, for me Ubuntu 10.04, you might never see anything newer than the 3.4.x line. I currently use 3.5.5 and have installed it on all of my systems that are not in storage.

Maybe you might want to see about downloading 3.5.5 and give it a try. You do not need to, but the 3.5.x line works better than 3.4.6, or at least for me it is.

I'm running LO on Ubuntu 12.04. I've used all previous versions of LO
through the present 3.5.5.3. My experience with export to pdf is that
the entire file is exported. It does not work to select one page or a
certain selection on a page. If I want to print just 1 page of a
multipage document or print a section of a page, that needs to be done
with a pdf printer, such as the one webmaster-Kracked_P_P mentioned
below, and not through export to pdf.

Don and Kracked and maybe Lynne,

I am running openSuSe 11.2 which I will agree is not the latest and greatest but it has worked for me. I will more than likely be upgrading to 12.2 when it is released.

I am an EX-Windows user all the way from 3.11 to Win XP.

I make no excuses that I am a KDE GUI user and have to admit whilst the cli seems far more capable in terms of package installation and dependencies, I do not know or understand the syntax and procedures i.e. to update to LO 3.5.5, without breaking anything on my current production system.

The current version of LO in use here on Win is 3.3 and on Linux is 3.4.5. I had thought that perhaps 3.3 was a little dated and hoped that a newer version would assist for PDF creation, alas it did not.

The 'Export to PDF' used to work on 3.3, even for a select number of Tabs in a Calc file, as I can do so for at least two other files, HOWEVER,

The main problem is that it has stopped being able to be completed on this one file, and I do not know why.

The export to PDF of only a selection of Tabs in Calc in certainly possible by holding down the Ctrl key and selecting the Tabs. Choosing File: Export as PDF brings up a menu box that you need to specify to make a PDF of 'the selection' as opposed to the whole file. There are other options i.t.o. recipients view, image compression etc.

Confirming brings up a file manager window so you can select the location of the exported PDF file and also to name it in said location.

I have LO installed on my Win 7 laptop and can access said file via SAMBA however I cannot write the PDF file from this specific Calc file onto the host file-system, even though no errors where found in a recent fsck on reboot?

I'll send the file to anyone privately to sort this out.

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

I started out on mainframes when a small computer was the size of a refrigerator. Then I bought my first computer as a kit and ran PC DOS on it. So I have seen the PCs from their start.

For Windows, I started using doPDF PDF printing software for maybe 8 or 10 years. I do not remember but I started using it on an XP laptop. I just printed the document as a PDF file instead to a physical paper printer. That was the best free option for PDF creation that I had found when I was using Windows. Now that I use Ubuntu 10.04 and 12.04, I use CUPS-PDF for my "default printer". I do not remember when Export-to-PDF came in LO, but I started using it with 3.3.0, the first version.

To be honest, doPDF and CUPS-PDF printing does everything I ask it to for portrait documents. For landscape docs that are to be viewed as a PDF file and not printed later, I need to use LO's PDF options. CUPS-PDF makes the PDF file formatted for printing portrait pages, with the text sideways in landscape mode. Not good if you want to read the PDF file with the default PDF reader package.

I would like to look at the file and see if I can create a PDF file, properly, from it. I can try Win XP and Vista, along with Ubuntu. I can try Exporting to PDF and try doPDF and CUPS-PDF printing. It has to work some way. I do not have Win7, yet, but I want to upgrade the Vista part of a dual booting laptop to Win7 sometime this year.

webmaster@krackedpress.com [email used for the lists]
or
webmaster@libreoffice-na.us [LO related email off the list]

omega
  The
Omega sector
America's Last
Line of
Defense

*Can you copy and paste the contents of the PDF file to a text program like office word and save it as such ( doc ) re open the doc and then copy and paste into the file (spreadsheet file)

Lynne,
If you use Linux then pdf2ps translates pdf to postscript and that can be manipulated. If you use Windows, I can't help.
Joep

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.

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.

Miguel Ángel.

  * Inglés - detectado
  * Inglés
  * Español
  * Gallego
  * Italiano

  * Inglés
  * Español
  * Gallego
  * Italiano

  <javascript:void(0);>