Description: Calcで日本語の入力されたセルの並べ替えを行うと、『時』から始まる文字列のセルが末尾にソートされる Steps to Reproduce: 1.Calcで日本語のセルを数行作成する（『時』から始まる文字列も含める） 2.ソートで昇順で並べ替える Actual Results: 『時』から始まるセルが最後にソートされる Expected Results: 「じ」から始まる範囲に並べるべき Reproducible: Always User Profile Reset: Yes OpenGL enabled: Yes Additional Info: 複数のPCで同じ結果が得られた
バージョン: 6.4.4.2 (x64) Build ID: 3d775be2011f3886db32dfd395a6a6d1ca2630ff CPU threads: 2; OS:Windows 10.0 Build 19041; UI render: default; VCL: win; ロケール: ja-JP (ja_JP); UIの言語: ja-JP Calc: threaded
Would it be possible you attach an example file? Himajin100000: thought you might be interested in this one since it may be Japanese specific.
Reproducible. Though I don't think I have good knowledge of charset and encoding, Many website says there is 時(U+6642) between 持(U+6301 / 0x8E9D) and 次(U+6B21 / 0x8E9F) https://uic.jp/charset/compare/cp932/shift_jis/bold/ https://seiai.ed.jp/sys/text/java/shiftjis_table.html etc... but the character is missing here. https://opengrok.libreoffice.org/xref/core/i18npool/source/collator/data/ja_charset.txt?r=2c47c998 https://opengrok.libreoffice.org/xref/core/i18npool/source/collator/data/ja_phonetic_alphanumeric_first.txt?r=2c47c998 https://opengrok.libreoffice.org/xref/core/i18npool/source/collator/data/ja_phonetic_alphanumeric_last.txt?r=2c47c998
Thank you Himajin100000 for your quick feedback. So we need to have feedback from another Japanese native "fluent" with these collation rules. Takeshi: any thoughts here as a member of Japanese translation team + having contributed in LO code in last years or any idea who may help here? Eike: if you have some contacts with Japanese people who may have some idea here...
Tomoyuki Kubota committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/71f1623e9c707b2160272bd30a00e16cc3df1c69 tdf#133747 add missing character to make the sort feature work correctly It will be available in 7.1.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.
Tomoyuki Kubota committed a patch related to this issue. It has been pushed to "libreoffice-7-0": https://git.libreoffice.org/core/commit/8f464351174d4127b3a165d7e6d33e07b4569862 tdf#133747 add missing character to make the sort feature work correctly It will be available in 7.0.1. 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.