https://bugs.documentfoundation.org/show_bug.cgi?id=100755
Bug ID: 100755
Summary: Fraction number format: symbol '0' not allowed for
digit in fraction
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 126060
--> https://bugs.documentfoundation.org/attachment.cgi?id=126060&action=edit
XLSX file with fraction number format with zeros
Description: in number formats, digits can be defined with #, ? or 0 symbols.
But in fraction, only # and ? are allowed.
Steps to reproduce:
1. Format > Cells > Numbers. Enter user defined format:
000 000/000
Actual behavior:
This format is refused as preview remains empty.
Expected behavior:
This format should be accepted, at least to import from XLSX. See attached
file.
Value: PI
Format: 000 000/000
Expected result in Excel: 003 016/113
Actual: format is not recognized and General (Standard) format is used instead.
--
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
