https://issues.apache.org/bugzilla/show_bug.cgi?id=42564
--- Comment #10 from David Webster <[EMAIL PROTECTED]> 2008-03-17 01:18:51 PST --- Hi Nick, Thanks for looking into it. Yep, awhile back I tried what you suggested (skipping record with warning) ... the ripple was that one of the record(s) skipped contained array info. re: worksheet names/indexes, so things were a bit snafu-ed when trying to index formulas on other worksheets as POI had the completely array size. The spreadsheet in question comes from a client who has used many differing versions of Excel to open/add/save info (i.e. the spreadsheet gets circulated to different depts. who annotate it). I think extra 'junk' gets saved and transmitted on when this happens - in particular, the dubious record. My solution has been to open the spreadsheet and save it in OpenOffice. That seems to work, touch wood. Will investigate technically again when I have more time. Cheers -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
