[Libreoffice-bugs] [Bug 130193] Japanese Traditional Numeric texts are wrong such as 1, 2, 3, 10, 1000, 10000
https://bugs.documentfoundation.org/show_bug.cgi?id=130193 Naruhiko Ogasawara changed: What|Removed |Added Ever confirmed|0 |1 Status|UNCONFIRMED |ASSIGNED Assignee|libreoffice-b...@lists.free |naru...@gmail.com |desktop.org | -- 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
[Libreoffice-bugs] [Bug 130193] Japanese Traditional Numeric texts are wrong such as 1, 2, 3, 10, 1000, 10000
https://bugs.documentfoundation.org/show_bug.cgi?id=130193 --- Comment #5 from Naruhiko Ogasawara --- Due to discussions in the Japanese community, I have decided to make major changes to the mapping between Excel (DBNum) and Calc (NatNum). This will change the specification, but will instead improve interoperability with Excel. The new mapping rules are as follows: from DBNum to NatNum (import): - DBNum1 -> NatNum4 (modern long Kanji text) - DBNum2 -> NatNum5 (traditional long Kanji text) - DBNum3 -> NatNum3 (fullwidth Arabic digits) from NatNum to DBNum (export): - NatNum1 -> DBNum1 - NatNum2 -> DBNum2 - NatNum3 -> DBNum3 - NatNum4 -> DBNum1 - NatNum5 -> DBNum2 - NatNum6 -> DBNum3 - NatNum7 -> DBNum1 - NatNum8 -> DBNum2 - NatNum9 -> (DBNum0, as Arabic) Translated with www.DeepL.com/Translator (free version) I already submit a set of patches includes unit tests. After it will get merged, I also have to update the help content. -- 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
[Libreoffice-bugs] [Bug 130193] Japanese Traditional Numeric texts are wrong such as 1, 2, 3, 10, 1000, 10000
https://bugs.documentfoundation.org/show_bug.cgi?id=130193 --- Comment #4 from Naruhiko Ogasawara --- Sorry, my bad, according to the help, this behavior might be intentional. Excel format modifier "[DBNum2]" means "Traditional Number Text" in Japanese, but in our latest help: https://help.libreoffice.org/6.4/ja/text/shared/01/05020301.html?&DbPAR=WRITER&System=WIN [DBNum2] is mapped to [NatNum4], which means "modern long Kanji text" in Calc native, not to [NatNum5], which means "traditional long Kanji text." As the Japanese native, this is Excel incompatibility and IMHO it should be fixed, but this behavior has been same since 3.3, so I guess there is some historical reason... I'm asking it to the Japanese community. -- 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
[Libreoffice-bugs] [Bug 130193] Japanese Traditional Numeric texts are wrong such as 1, 2, 3, 10, 1000, 10000
https://bugs.documentfoundation.org/show_bug.cgi?id=130193 --- Comment #3 from Naruhiko Ogasawara --- Reproduced with: Version: 6.4.3.2 Build ID: libreoffice-6.4.3.2-snap1 by following steps: Step 1. launch Calc Step 2. input numbers into cells one by one 1 2 3 5 10 1000 1 Step 4. select all cells, then Format > Cells, Numbers tab: select Number, Format code: '[DBNum2]#' Note: according to the help[1], [DBNum2] means > Japanese: traditional Kanji characters; CAL: 2/5/5 [DBNum2] and this should give us different result with [DBNum1], > Japanese: short Kanji characters [DBNum1]; CAL: 1/4/4 [DBNum1] Now these two modifier give as same results, which is the problem. [1] https://help.libreoffice.org/3.3/Common/Number_Format_Codes -- 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
[Libreoffice-bugs] [Bug 130193] Japanese Traditional Numeric texts are wrong such as 1, 2, 3, 10, 1000, 10000
https://bugs.documentfoundation.org/show_bug.cgi?id=130193 --- Comment #2 from himajin100...@gmail.com --- self-reminder: https://opengrok.libreoffice.org/xref/core/svl/source/numbers/zformat.cxx?r=055dd53e#187 Displaying Numbers Using Native Characters https://help.libreoffice.org/6.3/en-US/text/shared/01/05020301.html?DbPAR=SHARED https://opengrok.libreoffice.org/xref/core/i18npool/source/nativenumber/nativenumbersupplier.cxx?r=821bdf5f#427 -- 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
[Libreoffice-bugs] [Bug 130193] Japanese Traditional Numeric texts are wrong such as 1, 2, 3, 10, 1000, 10000
https://bugs.documentfoundation.org/show_bug.cgi?id=130193 --- Comment #1 from DaeHyun Sung --- Created attachment 157421 --> https://bugs.documentfoundation.org/attachment.cgi?id=157421&action=edit Excel 2019 CJK Number string check Excel file Excel 2019 CJK Number string check Excel file Korean - Japanese - Chinese[Mainland China and Taiwan] -- 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
[Libreoffice-bugs] [Bug 130193] Japanese Traditional Numeric texts are wrong such as 1, 2, 3, 10, 1000, 10000
https://bugs.documentfoundation.org/show_bug.cgi?id=130193 DaeHyun Sung changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=13 ||0140 -- 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
[Libreoffice-bugs] [Bug 130193] Japanese Traditional Numeric texts are wrong such as 1, 2, 3, 10, 1000, 10000
https://bugs.documentfoundation.org/show_bug.cgi?id=130193 DaeHyun Sung changed: What|Removed |Added Blocks||83066 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=83066 [Bug 83066] [META] CJK (Chinese, Japanese, Korean, and Vietnamese) language issues -- 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
[Libreoffice-bugs] [Bug 130193] Japanese Traditional Numeric texts are wrong such as 1, 2, 3, 10, 1000, 10000
https://bugs.documentfoundation.org/show_bug.cgi?id=130193 DaeHyun Sung changed: What|Removed |Added Blocks||113195 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=113195 [Bug 113195] [META] Japanese language-specific CJK issues -- 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