Bug 53588 - 45672 is back in 3.8
Summary: 45672 is back in 3.8
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.8-FINAL
Hardware: PC Windows Vista
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2012-07-23 10:56 UTC by Aniruddha Joag
Modified: 2012-09-08 18:37 UTC (History)
0 users

Excel File to reproduce 45672 (15.00 KB, application/vnd.ms-excel)
2012-07-23 12:00 UTC, Aniruddha Joag
Java class file to recreate the problem (6.32 KB, application/octet-stream)
2012-07-23 12:01 UTC, Aniruddha Joag

Note You need to log in before you can comment on or make changes to this bug.
Description Aniruddha Joag 2012-07-23 10:56:53 UTC
A LastCellOfRowDummyRecord is returned after encountering a formula record that results in a string value.
In particular I see this : if a formula(with string result) is encountered in the middle of a row and there is a missing cell immediately after - all cells upto the missing cells are reported as missing - probably because the LastCellOfRowDummyRecord  resets the column number back to zero.
Comment 1 Nick Burch 2012-07-23 11:02:20 UTC
Are you able to produce a unit test that shows the problem?

(Code with unit tests is much less likely to suffer accidental regressions!)
Comment 2 Aniruddha Joag 2012-07-23 12:00:49 UTC
Created attachment 29099 [details]
Excel File to reproduce 45672
Comment 3 Aniruddha Joag 2012-07-23 12:01:51 UTC
Created attachment 29100 [details]
Java class file to recreate the problem
Comment 4 Aniruddha Joag 2012-07-23 12:05:46 UTC
Apologies, something went wrong and the attachments were submitted without my comments, so here goes :
Attached a very simple excel file which has a formula at R1C3, this wrongly sets the missing columns.
Comment 5 Evgeniy Berlog 2012-09-08 18:37:35 UTC
This problem should be fixed in trunk.

Please try with a nightly build - see download links on http://poi.apache.org/
or build yourself from SVN trunk, see http://poi.apache.org/subversion.html