Bug 125015 - Format display error in Calc
Summary: Format display error in Calc
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.2.2.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-04-29 02:41 UTC by Ed Clarke
Modified: 2019-04-30 14:26 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
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 Ed Clarke 2019-04-29 02:41:51 UTC 
Description:
I am summing a column in calc with this formula =SUM(AD2:AD778).  The result as a number is 31120.96 which formats correctly.  If I format this as currency then all that shows up is ###.  If I turn off "thousands separator" then it shows up correctly as $31120.96.  

Steps to Reproduce:
1. put a number in a cell - I used 12345.67
2. format as currency with thousands separator on and see ###
3. format as currency with thousands separator off and see $12345.67

Actual Results:
### or $12345.67

Expected Results:
$12,345.67


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 Roman Kuznetsov 2019-04-29 07:15:31 UTC 
just try to make column more wider and you should to see your numeric with currency sign
Comment 2 Timur 2019-04-30 14:26:41 UTC 
I'll mark as NotaBug. Please use http://ask.libreoffice.org/ if you have dilemma like this and do not report a bug.