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.
(In reply to Buovjaga from comment #3)
> (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?
This bug is about the PDF created by exporting. You would need to export (a sufficiently large part of the sheet) to PDF and open the created file i a pdf-viewer to see the bug.
Since the example attached by the reporter is huge and its relation to the problem is unclear, I would suggest you look into the sheet attached to https://ask.libreoffice.org/t/preserving-conditional-formatting-results-when-pasting-outside-of-libreoffice/68006, and export it (say sheet no 3) to PDF. Check rows 35 and down the odd rows to see the effect in a pdf reader.
Your suggestion in comment #5
> Ok.. you have Options - Calc - View - Display - Zero values disabled for the
> document, so it isn't showing the 0s.
The evil settinng
>Tools>Options>LibreOffice Calc>View>>Display>>>Zero values
isn't a soulution for, but the cause of related problems.
Since there is no hope that the option itself will be completely abandoned, a fix for this bug should actually be brought on the way.
Created attachment 174985 [details]
The spreadsheet file for demonstrtion of the bug
Created attachment 174987 [details]
The PDF made from the spreadsheet