2 ms·
It's like there should be an encoding which specifies the intent. Unless the Arabic percent sign (which looks like ANSI but flipped?) has some other semantics,
by MichaelGG 13y ago
It's like there should be an encoding which specifies the intent. Unless the Arabic percent sign (which looks like ANSI but flipped?) has some other semantics, why shouldn't Excel handle both of them? Other than that there could be 100 different percent signs.
- sheetjs 13y agoThe strings are encoded based on the specified codepage, and code page 864 cannot represent the standard percent symbol "%". Excel itself can handle it because they have their own implementation of codepages, but other implementations are not necessarily correct (many iconv implementations make the same mistake). Keep in mind that Unicode only emerged in the 1990s and Excel predates unicode by about a decade.
- MichaelGG 13y agoRight, I'm wondering why Unicode doesn't offer some sort of meaning-equivalent API (or does it)? Like a way to know Arabic and standard percent have the same meaning. Or that fullwidth 'A' is equivalent in meaning to 'A'.