Bug 90280 - Can't suppress unwanted zeroes in computed fields (protected sheet)
Summary: Can't suppress unwanted zeroes in computed fields (protected sheet)
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
4.3.1.2 release
Hardware: x86 (IA32) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-03-27 12:14 UTC by usna1one
Modified: 2015-03-27 13:06 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
A daily report computing hours, labor and equipment on a state highway project (27.68 KB, application/zip)
2015-03-27 12:14 UTC, usna1one 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description usna1one 2015-03-27 12:14:31 UTC 
Created attachment 114401 [details]
A daily report computing hours, labor and equipment on a state highway project

The file is password-protected for "Protect Sheet."  The file displays computed fields as blank cells on the monitor, but when printed, the computed fields in the remainder of the column print an unwanted "0" in each cell.  Printer is a Xerox WorkCentre 7220.
Comment 1 raal 2015-03-27 13:06:16 UTC 
Hello,
You can off this feature by Format/Page/Sheet
untick Zero values

btw. use actual version, https://www.libreoffice.org/download/