Bug 127248 - Not displaying zero after calculation
Summary: Not displaying zero after calculation
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.3.0.4 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-08-30 22:48 UTC by teddyk65
Modified: 2019-08-31 00:41 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
A 3 line spreadsheet showing the behavior (11.25 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-08-30 22:50 UTC, teddyk65 		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 teddyk65 2019-08-30 22:48:38 UTC 
Description:
When I subtract 2 values, the value should be displayed as zero.  Instead, a blank space appears in G2 and D3.

Steps to Reproduce:
1.Enter =D2-E2 in cell G2
2.Enter =G2 in cell D3
3.

Actual Results:
Blank space appears instead of 0

Expected Results:
0 should appear in cells G2 and D3


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Comment 1 teddyk65 2019-08-30 22:50:31 UTC 
Created attachment 153771 [details]
A 3 line spreadsheet showing the behavior
Comment 2 Mike Kaganski 2019-08-30 23:01:16 UTC 
Your cells G2 and D3 are formatted using "#" format code, i.e. "print this position if it's non-zero". Naturally, this code gives empty result when its data *is* exactly zero.

See more at help page [1].

Closing NOTABUG.

[1] https://help.libreoffice.org/latest/en-US/text/shared/01/05020301.html
Comment 3 teddyk65 2019-08-31 00:41:27 UTC 
Thank You.  I used the General Number format to display the zero.

I apologize for any inconvenience.