Bug 53588

Summary: 45672 is back in 3.8
Product: POI Reporter: Aniruddha Joag <aniruddha_joag>
Component: HSSFAssignee: POI Developers List <dev>
Severity: normal    
Priority: P2    
Version: 3.8-FINAL   
Target Milestone: ---   
Hardware: PC   
OS: Windows Vista   
Attachments: Excel File to reproduce 45672
Java class file to recreate the problem

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