poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 42564] org.apache.poi.hssf.record.RecordFormatException: Unable to construct record instance
Date Mon, 17 Mar 2008 08:18:51 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=42564





--- Comment #10 from David Webster <dave.webster@virginmedia.co.uk>  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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message