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

            Bug ID: 106253
           Summary: 'Precision as shown' does not work with thousands
                    division
           Product: LibreOffice
           Version: Inherited From OOo
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]

Description:
When 'Precision as shown' option is checked, Number format using thousands
division, such "0,", is rounded to integer, not thousand.

Steps to Reproduce:
1. Activate 'Precision as shown' option: Tools > Options > LibreOffice Calc >
Calculate
2. Enter in A1 a formula such as =4e8/7
With General format, result is displayed as 57142857.14
3. Enter in B1 formula "=A1/10"
With General format, result is displayed as 5714285.714
4. Change Number format of A1 with thousands divisions ("0,," to divide par 1
million)

Actual Results:  
A1 displays 57 (correct)
B1 displays 57142865.7 (not correct)

Expected Results:
B1 should display 5700000


Reproducible: Always

User Profile Reset: No

Additional Info:
RoundValueAsShown reads only "precision" in number format, which is set to 0 in
this case
http://opengrok.libreoffice.org/xref/core/sc/source/core/data/documen4.cxx#653


User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:51.0) Gecko/20100101
Firefox/51.0

-- 
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

Reply via email to