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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
