https://bugs.documentfoundation.org/show_bug.cgi?id=99996
Bug ID: 99996
Summary: Wrong formatting of numbers if a format code of
'Fraction' type is used
Product: LibreOffice
Version: 5.1.2.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: UI
Assignee: [email protected]
Reporter: [email protected]
Created attachment 125236
--> https://bugs.documentfoundation.org/attachment.cgi?id=125236&action=edit
Demo of the bug and mathematical considerations
Under specific circumstances format codes like "# ?/????" result in wrongly
displayed values even where the exact and correct result should be inside the
range of applicability.
I experienced this by accident with LibO V 5.0.2.2 (x64) release under Win 10,
UI=English(UK), locale=German(Germany). Changing the locale to English(UK) did
not change the behaviour.
Steps to reproduce:
1. Create a new Calc document.
2. Set the 'Numbers' format code for column A to "# ?/????" or "#?/????"
3. Enter 2/2016 into A1, 1/2016 into A2 and 1/1008 into A3.
4. Verify the values being displayed as 10/9999, 5/9999, and 10/9999
respectively.
5. Enter 22/2016 into A4 and verify it being displayeed as 11/1009.
The display is wrong in every case. The correct formatting should show:
In case of 3. 1/1008, 1/2016, and 1/1008 respectively.
In case of 5. 11/1008.
These examples, a series of additional examples, and some exemplified
mathematical considerations are contained in the attached file.
--
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
