https://bugs.documentfoundation.org/show_bug.cgi?id=106052
Bug ID: 106052
Summary: 'Precision as shown' does not work with several
subformats
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: jumbo4...@yahoo.fr
Created attachment 131286
--> https://bugs.documentfoundation.org/attachment.cgi?id=131286&action=edit
Sample case as described in bug report
Description: With 'Precision as shown' activated, precision is taken from the
first subformat. If format is composed of 2 or 3 subformat, and they don't have
the same precision, it leads to incorrect behavior
Steps to reproduce:
1. Activate 'Precision as shown' option: Tools > Options > LibreOffice Calc >
Calculate
2. In A1, enter =-1/3
3. In A2, enter =3*A1
A2 displays '-1' as no rounding is operate with General format
4. Change number format of A1 to 0.0;-0.00 (see attached file)
Actual behavior:
A1 displays -0.30
A2 displays -0.9
Expected behavior:
A1 should display -0.33
A2 should display -0.99
Bug is located in RoundValueAsShown
http://opengrok.libreoffice.org/xref/core/sc/source/core/data/documen4.cxx#RoundValueAsShown
where precision is taken from the first subformat
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs