FN-LOWER-001: LOWER leaves letters above U+FFFF alone, and a combining mark stops the final sigma
Quirk · measured · recorded 2026-11-04
LOWER did not change the Deseret capital U+10400, a cased letter above U+FFFF, either alone or inside other text: LOWER("A𐐀Σ") is "a𐐀ς", where the Greek capital sigma at the end becomes the final form. Greek sigma depends on what follows: followed by a full stop it takes the final form ς, and followed by a combining mark, U+0300 or U+0301, it takes the medial form σ. PROPER treats a character above U+FFFF as a word boundary, so PROPER("a𐐀b") is "A𐐀B", with the B capitalised and the Deseret letter unchanged.
| Call and input route | Inputs | Excel | Correct value | Recorded in |
|---|---|---|---|---|
LOWER(A1)cell-value2 | text: 𐐀 | 𐐀 | — | Excel 16.0.20527.20088, Windows 64-bit, AMD Ryzen 7 4800H, workbook compatibility version 2 |
LOWER(A1)cell-value2 | text: A𐐀Σ | a𐐀ς | — | Excel 16.0.20527.20088, Windows 64-bit, AMD Ryzen 7 4800H, workbook compatibility version 2 |
LOWER(A1)cell-value2 | text: ΑΣ̀ | ασ̀ | — | Excel 16.0.20527.20088, Windows 64-bit, AMD Ryzen 7 4800H, workbook compatibility version 2 |
LOWER(A1)cell-value2 | text: ΑΣ. | ας. | — | Excel 16.0.20527.20088, Windows 64-bit, AMD Ryzen 7 4800H, workbook compatibility version 2 |
PROPER(A1)cell-value2 | text: a𐐀b | A𐐀B | — | Excel 16.0.20527.20088, Windows 64-bit, AMD Ryzen 7 4800H, workbook compatibility version 2 |
PROPER(A1)cell-value2 | text: aΣ́ | Aσ́ | — | Excel 16.0.20527.20088, Windows 64-bit, AMD Ryzen 7 4800H, workbook compatibility version 2 |
Basis: 6 recorded LOWER and 4 recorded PROPER readings, in a workbook at compatibility version 2.
Inferred: The readings cover one Deseret letter and two combining marks. That every letter above U+FFFF and every mark behave the same is inferred.
Open: Behaviour at compatibility version 1 has not been read for these inputs.
Evidence and capture sources
- DnaCalc · apps/dna-onecalc/tests/acceptance.rs ae13ca181bc1d5e3c9e266f26a856ba634707d8e · recorded answers pinned
- DnaCalc · crates/calc-func/tests/captures/fn3_questions/LOWER.reading.json 2d0eddcac86413014643af81d646581d54ba57bc · 6 recorded readings
- DnaCalc · crates/calc-func/tests/captures/fn3_questions/PROPER.reading.json 2d0eddcac86413014643af81d646581d54ba57bc · 4 recorded readings
- DnaCalc · crates/calc-func/tests/captures/fn3_questions/LOWER.reading.json 2d0eddcac86413014643af81d646581d54ba57bc · fn3-lower-001
- DnaCalc · crates/calc-func/tests/captures/fn3_questions/LOWER.reading.json 2d0eddcac86413014643af81d646581d54ba57bc · fn3-lower-003
- DnaCalc · crates/calc-func/tests/captures/fn3_questions/LOWER.reading.json 2d0eddcac86413014643af81d646581d54ba57bc · fn3-lower-004
- DnaCalc · crates/calc-func/tests/captures/fn3_questions/LOWER.reading.json 2d0eddcac86413014643af81d646581d54ba57bc · fn3-lower-005
- DnaCalc · crates/calc-func/tests/captures/fn3_questions/PROPER.reading.json 2d0eddcac86413014643af81d646581d54ba57bc · fn3-proper-002
- DnaCalc · crates/calc-func/tests/captures/fn3_questions/PROPER.reading.json 2d0eddcac86413014643af81d646581d54ba57bc · fn3-proper-004