FN-OP_LESS_THAN-001: Punctuation before a Japanese repeat mark sorts one way after a Latin letter, the other after Han
Quirk · measured · recorded 2026-11-04
Comparing a string with punctuation before a repeat or prolonged-sound mark against the same string without the punctuation, the order depends on the character at the start. After a Latin letter the punctuated string is smaller: "a-ゝx" < "aゝx". After a Han character it is larger: "時-ゝx" > "時ゝx". This held for every pair read, with the marks ゝ, 々 and ー and with hyphen-minus, U+2212 and U+2019 as the punctuation. In all 66 readings the two strings are never equal, and a string with the mark added sorts after the string without it, after Latin and after Han alike: "a−ゝ" > "a−".
| Call and input route | Inputs | Excel | Correct value | Recorded in |
|---|---|---|---|---|
="a-ゝx"<"aゝx"formula-literal | As typed | TRUE | — | Excel 16.0.20527.20088 Current Channel, Windows 64-bit (NT 10.0.26200), x86-64, AMD Ryzen 7 4800H, en-ZA |
="a-ゝx">"aゝx"formula-literal | As typed | FALSE | — | Excel 16.0.20527.20088 Current Channel, Windows 64-bit (NT 10.0.26200), x86-64, AMD Ryzen 7 4800H, en-ZA |
="時-ゝx"<"時ゝx"formula-literal | As typed | FALSE | — | Excel 16.0.20527.20088 Current Channel, Windows 64-bit (NT 10.0.26200), x86-64, AMD Ryzen 7 4800H, en-ZA |
="時-ゝx">"時ゝx"formula-literal | As typed | TRUE | — | Excel 16.0.20527.20088 Current Channel, Windows 64-bit (NT 10.0.26200), x86-64, AMD Ryzen 7 4800H, en-ZA |
="a−ゝ"<"aゝ"formula-literal | As typed | TRUE | — | Excel 16.0.20527.20088 Current Channel, Windows 64-bit (NT 10.0.26200), x86-64, AMD Ryzen 7 4800H, en-ZA |
="時−ゝ">"時ゝ"formula-literal | As typed | TRUE | — | Excel 16.0.20527.20088 Current Channel, Windows 64-bit (NT 10.0.26200), x86-64, AMD Ryzen 7 4800H, en-ZA |
="a−ゝ">"a−"formula-literal | As typed | TRUE | — | Excel 16.0.20527.20088 Current Channel, Windows 64-bit (NT 10.0.26200), x86-64, AMD Ryzen 7 4800H, en-ZA |
="時−ゝ">"時−"formula-literal | As typed | TRUE | — | Excel 16.0.20527.20088 Current Channel, Windows 64-bit (NT 10.0.26200), x86-64, AMD Ryzen 7 4800H, en-ZA |
Basis: 66 recorded readings of =, < and > on 22 pairs of strings, 11 pairs after 時 and 11 after a.
Open: The collation rule behind this is not identified, and none is claimed here.
Evidence and capture sources
- DnaCalc · crates/calc-func/tests/captures/fn4_questions/functions-fn4.capture.json 2d0eddcac86413014643af81d646581d54ba57bc · sheets q001 to q066 66 recorded readings
- DnaCalc · crates/calc-func/tests/captures/fn4_questions/functions-fn4.capture.json 2d0eddcac86413014643af81d646581d54ba57bc · sheet q059, row 20, column 10
- DnaCalc · crates/calc-func/tests/captures/fn4_questions/functions-fn4.capture.json 2d0eddcac86413014643af81d646581d54ba57bc · sheet q060, row 20, column 10
- DnaCalc · crates/calc-func/tests/captures/fn4_questions/functions-fn4.capture.json 2d0eddcac86413014643af81d646581d54ba57bc · sheet q050, row 20, column 10
- DnaCalc · crates/calc-func/tests/captures/fn4_questions/functions-fn4.capture.json 2d0eddcac86413014643af81d646581d54ba57bc · sheet q051, row 20, column 10
- DnaCalc · crates/calc-func/tests/captures/fn4_questions/functions-fn4.capture.json 2d0eddcac86413014643af81d646581d54ba57bc · sheet q029, row 20, column 10
- DnaCalc · crates/calc-func/tests/captures/fn4_questions/functions-fn4.capture.json 2d0eddcac86413014643af81d646581d54ba57bc · sheet q006, row 20, column 10
- DnaCalc · crates/calc-func/tests/captures/fn4_questions/functions-fn4.capture.json 2d0eddcac86413014643af81d646581d54ba57bc · sheet q027, row 20, column 10
- DnaCalc · crates/calc-func/tests/captures/fn4_questions/functions-fn4.capture.json 2d0eddcac86413014643af81d646581d54ba57bc · sheet q003, row 20, column 10