Ask Your Question

Calc won't export all sheets

asked 2021-04-12 18:56:24 +0200

astavely gravatar image

I have an .ods file containing 12 sheets. I created it in 2017 and have returned to it every year since. It works fine, except that Calc has always refused to export (to PDF) or print all 12 sheets. It gives me only 4, arbitrarily selected as far as I can tell, always the same four. The same thing happens whether I export or print, and whether I specify all, a page range or a selection (when I've tried to select all sheets). It only happens with this file -- older, similar files work fine. If the file is corrupted, how can I tell, and can I fix it?

edit retag flag offensive close merge delete



Try to select all sheets (click the first sheet tab and hold down the Shift key while clicking the last sheet tab). Now choose Format - Print Ranges - Clear and try export again

JohnSUN gravatar imageJohnSUN ( 2021-04-12 19:03:31 +0200 )edit


Please consider reposting this as an answer, since OP states that it solves their problem.

BigRAl gravatar imageBigRAl ( 2021-04-13 18:16:52 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2021-04-13 19:02:23 +0200

JohnSUN gravatar image

To print or export to PDF individual parts of your large spreadsheet, select each of them and choose Format - Print Ranges - Add.

If after a while you need to print other parts, add them to Print Ranges too, or - much easier - clear the previously added (use Format - Print Ranges - Clear for each sheet or for all at once).

edit flag offensive delete link more

answered 2021-04-12 19:13:08 +0200

astavely gravatar image

Ah, that helps! Many thanks! Export works correctly now. I didn't know about Format - Print Ranges - Clear. What exactly does that do? Doesn't look like it should be necessary, if I use the obvious controls to export or print.

edit flag offensive delete link more


You can use print ranges to print only a part of the page or only the sheet with the results, not the 200 pages of raw data.

If your printer is at your place you can stop the job, but if your big, loud and quick printer is in another room, there will always be somebody to print the whole file.


Wanderer gravatar imageWanderer ( 2021-04-13 21:40:31 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2021-04-12 18:56:24 +0200

Seen: 34 times

Last updated: Apr 13