Bug 101240 - When printing with the 'do not display zero values' if there is a formula in the cell and the value is zero, it prints a zero. MS-excel works correctly with the same sheet,
Summary: When printing with the 'do not display zero values' if there is a formula in ...
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.1.4.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-07-31 23:54 UTC by Warren
Modified: 2016-08-01 08:58 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Sample of failing document (47.50 KB, application/x-ole-storage)
2016-08-01 00:03 UTC, Warren
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Warren 2016-07-31 23:54:43 UTC

    
Comment 1 Warren 2016-08-01 00:03:49 UTC
Created attachment 126504 [details]
Sample of failing document

The only failing column is the totals column that contains formulas.
Comment 2 m_a_riosv 2016-08-01 08:58:41 UTC
In the page style it's marked show cero values.

Double click on the status bar the sheet name (Menu/Format/Page), and on the tab disable "Zero values".

Resolved as not a bug, please if you are not agree, reopen it.