Issue 103381 - Croatian fonts not displayed corectly
Summary: Croatian fonts not displayed corectly
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: 4.1.0-dev
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2009-07-07 12:45 UTC by resolv_25
Modified: 2013-11-26 12:10 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Croatian fonts not displayed correctly after export from PHP script (MS Excel displays same fonts correct) (1.21 KB, text/plain)
2009-07-07 12:46 UTC, resolv_25
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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 
(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 
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/; 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 
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