[Libreoffice-bugs] [Bug 125015] New: Format display error in Calc

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=125015

            Bug ID: 125015
           Summary: Format display error in Calc
           Product: LibreOffice
           Version: 6.2.2.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: clarke at cilia.org

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:

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190429/5379b93a/attachment.html>