Libre Calc - don't print pages with only blank values

asked 2018-04-23 10:36:49 +0100

toemke gravatar image

I've made a spreadsheet at work to automatically fill out some forms we regularly use. The number of forms we need varies from 1 to 10, so I used formulas to automatically fill out these forms depending on our parameters. If we only need 1 page, the result of all the other formulas is blank ("" to be exact), so the other 9 pages are completely empty. Even with the option "suppress the output of empty pages" is enabled, these pages are printed (the printer just pulls the pages through without actually printing on them). Is there a way to fix this?

edit retag flag offensive close merge delete

Comments

Which version of LibreOffice are you using? Which operating system. Sometimes bad behavior effect one platform but not another.

Kruno gravatar imageKruno ( 2018-04-23 20:40:50 +0100 )edit

I'm on 6.0.2.1 on both linux and windows and I have the issue on both systems (and earlier versions as well). I suspect that the pages are not suppressed because the pages are technically not empty, but have formulas that return "" as value.

toemke gravatar imagetoemke ( 2018-04-24 17:38:29 +0100 )edit

Maybe this will give you a hint about what can be done. Not sure is your 'empty cell' problem is same as this one but here it is: https://ask.libreoffice.org/en/questi...

Kruno gravatar imageKruno ( 2018-04-25 09:10:39 +0100 )edit

Thank you. It probably would work, but I'd like to avoid extra steps and macros (for my colleagues sake). Currently we set to print only the number of necessary pages, but it would be way better if we wouldn't even need that.

toemke gravatar imagetoemke ( 2018-04-26 08:54:28 +0100 )edit

I up-vote this so in hope someone more skillful will notice it.

Kruno gravatar imageKruno ( 2018-04-27 22:57:57 +0100 )edit

I'm also in need of such an function. In Excel it's possible to set printing area with an OFFSET function, but it's not possible in CALC

abrj gravatar imageabrj ( 2018-12-23 10:09:28 +0100 )edit