<div dir="ltr">I forgot to state that the sorting order of the Japense JOYO <br>kanji is based on the code point in JIS X 0208.<div><br></div><div>Regards,</div><div>Makoto</div></div><div class="gmail_extra"><br><div class="gmail_quote">2017-07-18 20:43 GMT+09:00 MURATA Makoto <span dir="ltr"><<a href="mailto:eb2m-mrt@asahi-net.or.jp" target="_blank">eb2m-mrt@asahi-net.or.jp</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div>Francis pointed out that some values of @sortMethod are<br></div><div>rewritten when we save Excel documents. So, I did more </div><div>experiments. All Excel documents are available at</div><div><a href="https://1drv.ms/f/s!An5Z79wj5AZBgfB82nx1haWv0jFfMA" target="_blank">https://1drv.ms/f/s!<wbr>An5Z79wj5AZBgfB82nx1haWv0jFfMA</a></div><div><br></div><div>First, I created an Excel document (DR 17-0009.xlsx) having two pages.</div><div><br></div><div>The first page has CJK characters in the Japanese JOYO kanji table as</div><div>well as some hiragana/katakana). The JOYO kanji table is available</div><div>at:</div><div><br></div><div><a href="https://github.com/cjkvi/cjkvi-tables/blob/master/joyo2010.txt" target="_blank">https://github.com/cjkvi/<wbr>cjkvi-tables/blob/master/<wbr>joyo2010.txt</a></div><div><br></div><div>The second page contains CJK characters in Part 1 of Table of General</div><div>Standard Chinese Characters. By mistake, I dropped some</div><div>characters in this table (sorry!).</div><div><br></div><div><a href="https://github.com/cjkvi/cjkvi-tables/blob/master/zibiao2009-1.txt" target="_blank">https://github.com/cjkvi/<wbr>cjkvi-tables/blob/master/<wbr>zibiao2009-1.txt</a>,</div><div><br></div><div>Both pages are sorted in the reverse order.</div><div><br></div><div>Then, I created three other documents by adding @sortMethod.</div><div><br></div><div>- DR 17-0009None.xlsx (sortMethod="none")</div><div>- DR 17-0009PinYin.xlsx (sortMethod="pinYin")</div><div>- DR 17-0009Stroke.xlsx (sortMethod="stroke")</div><div><br></div><div>Next, I opened these documents, applied sorting, and saved as new</div><div>documents. They are:</div><div><br></div><div>- DR 17-0009SortedAgain.xlsx</div><div>- DR 17-0009NoneSortedAgain.xlsx</div><div>- DR 17-0009PinYinSortedAgain.xlsx</div><div>- DR 17-0009StrokeSortedAgain.xlsx</div><div><br></div><div>Here are some observations.</div><div><br></div><div>1) When an Excel document is saved, sortMethod="none" is deleted</div><div>and sortMethod="pinYin" is rewritten as sortMethod="stroke".</div><div><br></div><div>2) CJK ideographic characters in the Table of General Standard Chinese</div><div>Characters are sorted always in the same order. The sortMethod</div><div>attribute is irrelevant. In particular, sortMethod="pinYin" and</div><div>sortMethod="stroke" provide no differences.</div><div><br></div><div>3) CJK ideographic characters in the Japanese JOYO kanji table are</div><div>sorted always in the same order with the excpetion of sequences of</div><div>characters. Kana characters are sorted slightly differently, although</div><div> a) no @sortMethod and @sortMethod="none" imply the same order, and</div><div> b) @sortMethod="pinYin" <-> @sortMethod="stroke" imply the same order.</div><div><br></div><div><br></div><div>Could you try the same experiment in different locales?</div><div><br></div><div><div>Pleaes open</div><div> DR 17-0009.xlsx,</div><div> DR 17-0009None.xlsx, </div><div> DR 17-0009PinYin.xlsx, and</div><div> DR 17-0009Stroke.xlsx,</div><div>apply the sort operation, and save them as</div><div> DR 17-0009SortedAgainXXX.xlsx</div><div> DR 17-0009NoneSortedAgainXXX.<wbr>xlsx,</div><div> DR 17-0009PinYinSortedAgainXXX.<wbr>xlsx, and</div><div> DR 17-0009StrokeSortedAgainXXX.<wbr>xlsx, respectively,</div><div>and send me these files. </div></div><div><br></div><div>Then, we will know whether sorting is locale-dependent or not.</div><div><br></div><div>Regards,</div><div>Makoto</div></div><div class="gmail_extra"><div><div class="h5"><br><div class="gmail_quote">2017-06-17 18:42 GMT+09:00 MURATA Makoto <span dir="ltr"><<a href="mailto:eb2m-mrt@asahi-net.or.jp" target="_blank">eb2m-mrt@asahi-net.or.jp</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div>Dear colleagues,</div><div><br></div><div>I volunteered to write down text for closing this DR. However,</div><div>I find that the current description of @sortMethod is completely </div><div>different from what MS Office 365 does. </div><div><br></div><div>In my experiment, I used all Japanese characters (as well as </div><div>some hiragana/katakana) and Chinese characters, available at:</div><div><br></div><div><a href="https://github.com/cjkvi/cjkvi-tables/blob/master/joyo2010.txt" target="_blank">https://github.com/cjkvi/cjkvi<wbr>-tables/blob/master/joyo2010.<wbr>txt</a><br></div><div><a href="https://github.com/cjkvi/cjkvi-tables/blob/master/zibiao2009-1.txt" target="_blank">https://github.com/cjkvi/cjkvi<wbr>-tables/blob/master/zibiao2009<wbr>-1.txt</a><br></div><div><br></div><div><br></div><div><div>As expected, there are no differences between sortMethod="none" and no</div><div>@sortMethod.</div><div><br></div><div>To my surprise, there are no differences between sortMethod="pinYin"</div><div>and sortMethod="stroke".</div><div><br></div><div>Again, to my surprise, there are some differnces between</div><div>sortMethod="none" and sortMethod="pinYin" as far as </div><div>Japanese characters are concerned.</div></div><div><br></div><div><br></div><div>1) no sortMethod</div><div><a href="https://1drv.ms/x/s!An5Z79wj5AZBgfBauUlWV8tto7r6DA" target="_blank">https://1drv.ms/x/s!An5Z79wj5A<wbr>ZBgfBauUlWV8tto7r6DA</a></div><div><br></div><div>2) sortMethod="none"</div><div><a href="https://1drv.ms/x/s!An5Z79wj5AZBgfBZ2kl1o9-TtJK57Q" target="_blank">https://1drv.ms/x/s!An5Z79wj5A<wbr>ZBgfBZ2kl1o9-TtJK57Q</a></div><div><br></div><div>3) sortMethod="pinYin"</div><div><a href="https://1drv.ms/x/s!An5Z79wj5AZBgfBY6twkqkV8__mRCA" target="_blank">https://1drv.ms/x/s!An5Z79wj5A<wbr>ZBgfBY6twkqkV8__mRCA</a></div><div><br></div><div>4) sortMethod="stroke"</div><div><a href="https://1drv.ms/x/s!An5Z79wj5AZBgfBXbwLId3-c6Swfg-" target="_blank">https://1drv.ms/x/s!An5Z79wj5A<wbr>ZBgfBXbwLId3-c6Swfg-</a></div><span class="m_-7476182625862820815HOEnZb"><font color="#888888"><div><br></div><div><br></div><div><br></div>-- <br><div class="m_-7476182625862820815m_-3242774470837233349gmail-m_-7630898170050725024gmail_signature">Regards,<br><br>Makoto</div>
</font></span></div>
</blockquote></div><br><br clear="all"><div><br></div></div></div><span class="HOEnZb"><font color="#888888">-- <br><div class="m_-7476182625862820815gmail_signature" data-smartmail="gmail_signature"><br>Praying for the victims of the Japan Tohoku earthquake<br><br>Makoto</div>
</font></span></div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature" data-smartmail="gmail_signature"><br>Praying for the victims of the Japan Tohoku earthquake<br><br>Makoto</div>
</div>