Ask Your Question
0

Calc Won't Print A Spreadsheet

asked 2020-08-07 09:10:17 +0200

kik94 gravatar image

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 !!!

edit retag flag offensive close merge delete

Comments

What format do you use?

gabix gravatar imagegabix ( 2020-08-07 09:46:28 +0200 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2021-04-02 23:12:16 +0200

MS Escapee gravatar image

updated 2021-04-06 12:46:28 +0200

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

edit flag offensive delete link more

Comments

1

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

gabix gravatar imagegabix ( 2021-04-03 08:10:47 +0200 )edit
0

answered 2021-04-03 16:48:45 +0200

McP gravatar image

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2020-08-07 09:10:17 +0200

Seen: 210 times

Last updated: Apr 06