Created attachment 100088 [details] XLSX file in which cell A1 is formatted as "[DBNum2]" Description: The attached xlsx file has cell A1 formatted as "[DBNum2]" number format. When open with libreoffice calc, this number format is not shown correctly. Steps: 1. Open the attached xlsx file with calc. Current Behaviour: Cell A1 is showing "120". Expected: Cell A1 should show "壹佰贰拾"(which means ONE HUNDRED AND TWENTY). This bug may be a duplicate of Bug 79398, but I am filing with different bug report. Also, you may notice that when open the file, grid lines may be massed up, which is reported in bug 79395.
Reproducible with OS:Fedora 20 x86_64 Version: 4.2.4.2 Build ID: 4.2.4.2-8.fc20 OS:Fedora 20 x86_64 Version: 4.3.0.0.beta1 Build ID: 2e39c7e59c8fc8b16a54c3d981dceef27fb0c07f OS:Windows XP SP3 Version: 4.2.4.2 Build ID: 63150712c6d317d27ce2db16eb94c2f3d7b699f8
Please note: In order for A1 to show as "壹佰贰拾", your OS should have zh_CN locale installed, because [NatNumX] and [DBNumX] are locale related.
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (4.4.3 or later) https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results; 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for your help! -- The LibreOffice QA Team This NEW Message was generated on: 2015-06-08
(In reply to QA Administrators from comment #3) Bug still exists in Version: 5.0.0.1 Build ID: 9a0b23dd0ab9652e0965484934309f2d49a7758e Locale: zh-CN (zh_CN)
(In reply to Kevin Suo from comment #0) > This bug may be a duplicate of Bug 79398, but I am filing with different bug > report. No, both bugs are different: this bug concerns import of DBNumX code which is a regression version 4.0.3 Bug 79398 concerns export of DBNumX code XL formats, which seems to never have been working
Laurent Balland-Poirier committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=b1ce5db192750210b1546417494664f91759719d tdf#101462 tdf#79399 lcl_matchKeywordAndGetNumber returns integer 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.
*** Bug 101462 has been marked as a duplicate of this bug. ***
Laurent Balland-Poirier committed a patch related to this issue. It has been pushed to "libreoffice-5-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=3deb5fed775290540611cde158051a647bb5e317&h=libreoffice-5-2 tdf#101462 tdf#79399 lcl_matchKeywordAndGetNumber returns integer It will be available in 5.2.2. 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=502574cb4f1c081b55445fd4b47de6693ef293e2 tdf#79399 tdf#101462 Add qa unit test 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.