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?
Which version of LibreOffice are you using? Which operating system. Sometimes bad behavior effect one platform but not another.
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.
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: Empty cell as result of formula
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.
I up-vote this so in hope someone more skillful will notice it.
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