Apache OpenOffice (AOO) Bugzilla – Issue 103381
Croatian fonts not displayed corectly
Last modified: 2013-11-26 12:10:50 UTC
The file has been created by PHP script, converted characters from UTF-8 to ANSII characters. MS Excel 2003 displays all fonts correctly Here is the list of fonts that has been replaced within the script as ASCII character. (chr means character number) "š", => chr(154) "Š",=> chr(138) "č", => chr(232) "Č", => chr(200) "đ", => chr(240) "Đ", => chr(208) "ž", => chr(158) "Ž", => chr(142) "ć", => chr(230) "Ć" => chr(198) Fonts chr(154), chr(138), chr(208), chr(158), chr(142) are displayed correctly, while others not. I've tried with Open Office 2,4 and OO 3.0, both on Ubuntu 8.04 Linux. In the attachment shall be file showing the characters (first line shall be ignored) Line no. 33 with ID - 60 is showing the appearance of characters. Instead of TEST-ŠÐÈÆŽ-šðèæž shal be TEST-SĐČĆŽ-šđčćž Maybe I shall use different character ? All the best, Franko I.
Created attachment 63411 [details] Croatian fonts not displayed correctly after export from PHP script (MS Excel displays same fonts correct)
There is no such thing as a standardised ASCII character set for anything with a codepoint > 127 (that's why Unicode had to be invented) If you want to exchange documents reliably, use UTF-8. OO.o is interpreting your file as UTF-8, the characters that work is those that have the same values in UTF-8 and in your local 8-bit encoding. Your file would probably not work in an English Excel 2003 too
Thanks for answer. Encoding is set to UTF-8, display on the screen is correct. Header looks like this: header( "Content-type: application/vnd.ms-excel; charset=UTF-8 Content-Transfer- Encoding: 8bit" ); English MS-Excel reads same document correctly. Maybe is really the problem in non reading character >127 Anyhow, if there is any other solution to get Unicode character, would be grateful.
Line 33 displayed as "instead of" string in description. AOO410m1(Build:9750) - Rev. 1539999 2013-11-09_04:08:11 - Rev. 1540252 Debian