https://bugs.documentfoundation.org/show_bug.cgi?id=100834
Bug ID: 100834
Summary: Fraction number format: String " " and other not
recognized as blank delimiter
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: jumbo4...@yahoo.fr
Created attachment 126148
--> https://bugs.documentfoundation.org/attachment.cgi?id=126148&action=edit
Example of fraction representation in Excel
Desciption: When Excel is using " " as blank separator between integer and
fraction, LibO does not recognize strings as separator and treats them in a
very strange manner: string is inserted inside the number representation.
Steps to reproduce:
1. In Excel (French UI), choose a fraction format or define a user format such
as:
#" plus fraction "?/???
2. Enter a value: PI() for instance. Value is displayed as:
3 plus fraction 16/113
4. Save as XLSX
5. Open file in LibreOffice (See attached file)
Actual behavior:
Cell is displayed as
35 plus fraction 5/113
because LibreOffice interprets format as ##?/??? (which should be 355/113) with
string " plus fraction " inserted between 35 and 5
Expected behavior:
LibreOffice should display as in Excel:
3 plus fraction 16/113
In my Excel 2010, French localization, for default display of fraction, Excel
inserts the blank between integer and fraction as " " and not as \_ (escape
char followed by a space), which is the way that LibreOffice expects Excel
would do. For instance, for PI() value and format
#" "?/?
LibreOffice displays
2 2/7
Which seems wrong when compared to expected display
3 1/7
--
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