CHAR
Quirk foundCategory: Text · Last tested 2026-07-04
Support matrix
| Engine | Documented | Live-tested | Verdict |
|---|---|---|---|
| Excel | Yes | Not yet | n/a |
| Google Sheets | Yes | Not yet | n/a |
| LibreOffice Calc | Yes | Yes (24.2.7.2, 2026-07-04) | Quirk found |
Discovered quirks
- =CHAR(0) on LibreOffice Calc returned _x0000_, but the documented/expected result is #VALUE!. Microsoft docs: CHAR takes "A number between 1 and 255 specifying which character you want." Source: https://support.microsoft.com/en-us/office/char-function-bbd249c8-b36e-4a91-8017-1c133f9b837a; MISMATCH vs expected: expected '#VALUE!', got '_x0000_'
Executed test cases
LibreOffice Calc 24.2.7.2 (tested 2026-07-04)
| Formula | Description | Result | Expected | Verdict |
|---|---|---|---|---|
| =CHAR(65) | Basic code-to-character lookup | A | A | Matched |
| =CHAR(97) | Lowercase letter lookup | a | a | Matched |
| =CHAR(0) | 0 is outside CHAR's documented valid range of 1-255 -> #VALUE! | _x0000_ | #VALUE! Microsoft docs: CHAR takes "A number between 1 and 255 specifying which character you want." Source: https://support.microsoft.com/en-us/office/char-function-bbd249c8-b36e-4a91-8017-1c133f9b837a |
Mismatch |
| =CHAR(256) | 256 is above CHAR's documented valid range of 1-255 -> #VALUE! | #VALUE! | #VALUE! Source: https://support.microsoft.com/en-us/office/char-function-bbd249c8-b36e-4a91-8017-1c133f9b837a - valid range is 1-255; values outside it are invalid |
Matched |
Docs & syntax
- Excel: official documentation
- Google Sheets: official documentation
- LibreOffice Calc: official documentation