Bug 96597 - Respect disabled setting "display zero values" when printing and pdf export
Summary: Respect disabled setting "display zero values" when printing and pdf export
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Keywords: filter:pdf
Depends on:
Blocks: PDF-Export
  Show dependency treegraph
Reported: 2015-12-19 14:30 UTC by Duncan Bellamy
Modified: 2017-02-16 21:00 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Spreadsheet that exhibits this (63.14 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-12-28 13:27 UTC, Duncan Bellamy

Note You need to log in before you can comment on or make changes to this bug.
Description Duncan Bellamy 2015-12-19 14:30:52 UTC
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.
Comment 1 Buovjaga 2015-12-22 21:29:55 UTC
Could you attach an example file (perhaps a reduced version of your monthly sheet)?

Change back to UNCONFIRMED after you have provided the document.
Comment 2 Duncan Bellamy 2015-12-28 13:27:44 UTC
Created attachment 121576 [details]
Spreadsheet that exhibits this
Comment 3 Buovjaga 2015-12-29 14:22:08 UTC
(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?
Comment 4 Duncan Bellamy 2015-12-29 19:18:57 UTC
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.
Comment 5 Buovjaga 2015-12-29 19:45:47 UTC
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.