Posted on 2008-11-25 14:47:16-08 by dhoworth
infinite loop in normalizeSheet
I tried my script that isolates annotations on a 'real' spreadsheet. It's a megabyte with 20 or 30 worksheets. My script used up all the memory (16 GB) and died. I extracted one worksheet that only has content in (A1 .. C12) and simplified it to pure text in most cells and 1 number and a couple of simple formulas. The problem was still there. I've tracked the problem down to the call to
$doc->normalizeSheet($table, 'full');
If I substitute
$doc->normalizeSheet($table, 13, 4);
everything works fine. I haven't been able to track down the exact issue in normalizeSheet yet (lack of time) and I can't figure out how to post my test spreadsheet here?
Direct Responses: 9431 | Write a response
Perl Weekly newsletter
A free weekly newsletter for people who are busy to read all the blogs. click here to check it out.