#70 Wrong text is read from a cell

[Pavel]

We have noticed a very strange bug. Our customer sent us an order in Excel form and one of the cells is read incorrectly, more exactly first part of the text is truncated. The correct text is "'P2i1869378=154118693780020003=254=33 Санкт-Петербург=exist.ru" and what reader gets is "3 Санкт-Петербург=exist.ru".

I don't want to upload the order here for public access, but I can send it to you if you contact me via email or somehow else.
My email is register at bazanov dothere net
s-k-y-p-e is megosuyaya

[Pavel]

I have just posted more information about this problem here:
http://code.google.com/p/php-excel-reader/issues/detail?id=98&sort=-id

[gergoe]

Change
$newstr = $retstr[$j].chr(0);
into
$newstr .= $retstr[$j].chr(0);
around line 547 in reader.php, that should solve the problem. It happens when your excel's SST record exceeds the BIFF record size (which may happen if you have more than 8kbyte of unique texts in cells), and a CONTINUE is inserted in the middle of a string.

[Pavel]

Thanks, gergoe, it works!