Calc Won't Print A Spreadsheet

English
, ,
#1

Hello, I have created a spreadsheet on libre calc which has 3 sheets, when i try to print each sheet individually it prints the first and the second sheet with no problem but when i try to print the third sheet in the print preview it shows nothing. So i have to go to Format->Print Ranges->Edit and set it to the whole sheet, to be able to print it, but if i save it and close the file when i open it again the Print range will be set back and print nothing.

Anyone has an idea what i can do to fix that ?

I know that it’s simple to define the range when i want to print it, but the spreadsheet will be mainly used by a user with no more skills than just opening the file make a change to a cell and print it.

Thanks in advance !!!

#2

What format do you use?

#3

2021-04-02 Original answer:
I have a similar problem.
We created a spreadsheet with seven sheets within.
We need to print Sheet 1 but it will only print Sheet 7.
It will only show Sheet 7 in a print preview, sheets 1 to 6 being shown in the preview box as blank.

We are running Libre Office on Linux ‘Mint’ 19 on one computer and Min 20 on another. Both exhibit exactly the same problem - only Sheet 7 can be print previewed and only Sheet 7 will print.

Can anyone help?

2021-04-06 Edit to the original answer:

Exporting it to a .pdf was not tried because the spreadsheet was only about half way completed and need it completing.

UNPROFESSIONAL SOLUTION WHICH WORKED:

  1. Open a fresh Calc spreadsheet so that there are two instances of Calc running (2 files open).

  2. Name the fresh Calc sheet with the same name as the non-printing file except append ‘v2’ to the name.

  3. In the fresh Calc file create the required number of sheets and name them as in the non-printing file.

  4. Copy the data from Sheet 1 in the non-printing file and paste it into Sheet 1 in the fresh file.

  5. Repeat the copy and paste for the other sheets. Job done.

Note:
We received a pop-up notification during the above process that we had copied ‘links’ to the new file. We did not know how they got there so we deleted them.

Calc Version: 6.0.7.3
Build ID: 1:6.0.7-0ubuntu0.18.04.10
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3;
Locale: en-GB (en_GB.UTF-8); Calc: group

#4

Do not answer a question unless it is a real answer. Comment the original one or start a new one.

#5

Not sure if this is a solution or rather a workaround (because I don’t exactly know what causes it):

If you export the file as a PDF, it should show you all pages and you can also then print the PDF instead.
If it’s a range issue, I would expect the formatting in the PDF view look weird, so it could point you to the cause of it- potentially.

#6

One solution: Clear the ‘Print Range’

Procedure:

Top toolbar > ‘Format’ > ‘Print Ranges’ > click ‘Clear’

Note: If the ‘Calc’ file has more than one ‘Sheet’ then if you move to a different ‘Sheet’ you may again not be able to print the desired ‘Page’ in that ‘Sheet’. If so the you have to repeat the above procedure for each ‘Sheet’.

#7

I know this is an old thread, but I had exactly this problem today myself. I managed to find a “closed” thread on this topic and the issue is that LibreOffice evidently does not “save” the print range associated with the “last” sheet in the workbook. Instead, it resets the range to “None” when you close the workbook.

The workaround is to add an empty “last” sheet that isn’t used. Then the previous last sheet will have its print range saved on closing the workbook.

#8

Care to submit a bug about that? Thanks.

#9

I’ll give it some thought, but I will note that this problem has been around for more than 5 years. Here’s (Spam removed) the thread I found after some digging. The workaround is buried in that thread.

I’ve found that filing a LibreOffice bug report is a painful and fruitless exercise. I spent a fair bit of time doing so for a bug I found about 18 months ago. I went through several iterations to convince the “moderators” that what I found was a indeed a bug. Having done so, it was defined as a bug and has been sitting for 18 months without any status update whatsoever. Evidently nothing has been done to fix it.

I feel like I wasted my time.

#10

Complaining on an Ask site or any forum will not fix a bug. (or only occasionally when a developer happens to drop by and feels like scratching an itch). Yes, filing a bug may take time. Fixing a bug may take even more time.

#11

Please note that I’m not complaining, just stating facts.

I’m surprised that a hyperlink to a post on this site was identified as spam and removed. My intention was simply to document where I found the workaround to this problem. Now that reference is gone.

#12

The link is still visible in the diff and certainly that page got nothing to do with LibreOffice.

#13

My apologies. I must have copied the wrong link. Here is the correct link to the page where I found the workaround.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.