I have a monthly spreadsheet to calculate expenses and VAT, even when the spreadsheet is 'empty' it prints or exports enough blank pages to cover the range of rows that contain formula. Even though the formula is not displaying a result.
I have tried the options in page formatting and calc formula but they make no difference.
Could you attach an example file (perhaps a reduced version of your monthly sheet)?
Set to NEEDINFO.
Change back to UNCONFIRMED after you have provided the document.
Created attachment 121576 [details]
Spreadsheet that exhibits this
(In reply to Duncan Bellamy from comment #2)
> Created attachment 121576 [details]
> Spreadsheet that exhibits this
So how should we test the problem? I see H has rows with OK up to row 117. Do you mean we have to delete these OKs and see, how the printing behaves in relation to columns F and G, which have formulas?
The ok column is non printing, so if you edit nothing and print preview it gives you 4 pages.
The first page has the totals info etc, the other pages just have the header and are otherwise blank.
Ok.. you have Options - Calc - View - Display - Zero values disabled for the document, so it isn't showing the 0s.
Adjusted summary and set to NEW.