Issue 103381

Summary: Croatian fonts not displayed corectly
Product: Calc Reporter: resolv_25 <elcondor1008>
Component: formattingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: elish, issues, nicolas.mailhot
Version: 4.1.0-dev   
Target Milestone: ---   
Hardware: PC   
OS: Linux, all   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Croatian fonts not displayed correctly after export from PHP script (MS Excel displays same fonts correct) none

Description resolv_25 2009-07-07 12:45:12 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.
Comment 1 resolv_25 2009-07-07 12:46:33 UTC 
Created attachment 63411 [details]
Croatian fonts not displayed correctly after export from PHP script (MS Excel displays same fonts correct)
Comment 2 nmailhot 2009-07-07 20:08:58 UTC 
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
Comment 3 resolv_25 2009-07-08 13:22:47 UTC 
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.
Comment 4 Edwin Sharp 2013-11-26 12:10:50 UTC 
Line 33 displayed as "instead of" string in description.

AOO410m1(Build:9750)  -  Rev. 1539999
2013-11-09_04:08:11 - Rev. 1540252
Debian