Wrong reading of special characters for a Excel95 (BIFF7)

Open pvalin opened this issue 4 years ago • 2 comments

Cell B1 of first sheet : test_pv_95.xls I get : &�?��?????? Instead of : &é?¥®™?????? (Excel 2003 to 95 lost arabic and hebrew characters, I shoud have had &é₤¥®™≠بةائӨ)

I think we are near of the issue https://github.com/shuchkin/simplexls/issues/10

I put an utf8_encode() and it works but I don't know if it can generates side effects.

Sep 21 '21 12:09 pvalin

During those tests, I see we pass into parseSubstreamHeader() several times (1 time for the document and 1 time for each sheet). In my test document, the document is BIFF7 and each sheet become BIFF8. I don't know if it's normal. :s

Sep 21 '21 12:09 pvalin

Just a side note... utf8_encode() and utf8_decode() functions are being deprecated in PHP 8.2.

Aug 31 '22 18:08 ConnectGrid