Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#70 Wrong text is read from a cell

open
nobody
None
5
2010-08-21
2010-08-21
Pavel
No

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

Discussion

  • gergoe
    gergoe
    2010-11-30

    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
    Pavel
    2010-11-30

    Thanks, gergoe, it works!