FN-OP_EQUAL-001: Conjoining Hangul jamo do not compare equal to the precomposed syllable
Quirk · measured · recorded 2026-11-04
U+1100 U+1161 is canonically equivalent to the syllable U+AC00 in Unicode, but Excel's comparison says they are not equal, and the jamo sequence sorts first. The same holds with a final consonant, U+1100 U+1161 U+11A8 against U+AC01.
| Call and input route | Inputs | Excel | Correct value | Recorded in |
|---|---|---|---|---|
="가"="가"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 |
="가"<"가"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 | FALSE | — | Excel 16.0.20527.20088 Current Channel, Windows 64-bit (NT 10.0.26200), x86-64, AMD Ryzen 7 4800H, en-ZA |
Basis: 32 recorded readings on one collation sheet.
Open: Twelve further comparisons (other leading consonants, a trailing consonant, a compound vowel, compatibility jamo) were read on 2026-11-04. They are not yet in a published capture, so this note does not rest on them.
Evidence and capture sources
- DnaCalc · crates/calc-func/tests/captures/fn3_questions/oracle.capture.json eceb809985e244e9d0a20f905e58fe57b8741ed8 · sheet fn3_collation, rows 290 to 321
- DnaCalc · crates/calc-func/tests/captures/fn3_questions/oracle.capture.json eceb809985e244e9d0a20f905e58fe57b8741ed8 · sheet fn3_collation, row 290, column 4
- DnaCalc · crates/calc-func/tests/captures/fn3_questions/oracle.capture.json eceb809985e244e9d0a20f905e58fe57b8741ed8 · sheet fn3_collation, row 291, column 4
- DnaCalc · crates/calc-func/tests/captures/fn3_questions/oracle.capture.json eceb809985e244e9d0a20f905e58fe57b8741ed8 · sheet fn3_collation, row 296, column 4