Bug #4018

OpenOffice, Excel Cyrillic Bug

Details

Submitted	2005-03-31 14:07 UTC
From	golovkov at texnika dot com dot ua
Status	No Feedback
Package	Spreadsheet_Excel_Writer
PHP Version	4.3.10
OS	FreeBSD
Roadmaps	(Not assigned)

Comments

[2005-03-31 14:07 UTC] golovkov at texnika dot com dot ua

Description:
------------
OK. I have some problems with charset support.
I've tried 2 variants: BIFF5 and BIFF8 (I've read bug #1572 and installed the patch).
My goal is to get normal XLS document with the viewable by russian text in any of these modes (BIFF5, BIFF8). I need the ability to view that document in both programs: OpenOffice and MS Excel.

1. BIFF5
Actually, 255 symbols for one cell(BIFF5) is enough for me. But in BIFF5 mode OpenOffice shows me .xls document with some funny symbols instead of russian letters. MS Excel (all versions) shows normal document with the normal russian letters view.
I've tried: $workbook->_codepage = '1251';
But nothing was changed...

2. BIFF8
Some tests with this format are good(russian text is viewable in both programs) and all seems to be OK... But another tests crushes MS Excel. I can't figure out
why it is so...

[2005-11-07 23:35 UTC] xnoguer at php dot net

do you have a sample script for the first case?
also, what version of OpenOffice are you using?