Created attachment 126060 [details] 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.
Version: 5.1.4.2 Build ID: f99d75f39f1c57ebdd7ffc5f42867c12031db97a CPU Threads: 2; OS Version: Linux 3.16; UI Render: default; Locale: en-US (en_US.UTF-8) For me when I put in 000 000/000 it turns into "user defined" and the preview shows blank. Confirmed
Laurent Balland-Poirier committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=d32dab699f6584a13eb10fc1eb2801423ef52fb2 tdf#100755 Allow '0' for denominator symbol It will be available in 5.3.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Laurent Balland-Poirier committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=aab21302fa7ec76772456ad0cd8729a16e2a11e0 tdf#100755 Extend ODF to allow 0 in fraction It will be available in 5.3.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/ccbd6b4592cbc688122feafda64b10353da7264c tdf#100755: svl_qa_cppunit: Add unittest It will be available in 7.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Verified as fixed in: Version: 6.2.5.2 Build ID: 1ec314fa52f458adc18c4f025c545a4e8b22c159 CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3; Locale: en-AU (en_AU.UTF-8); UI-Language: en-US Calc: threaded