Bug 53588

Summary:	45672 is back in 3.8
Product:	POI	Reporter:	Aniruddha Joag <aniruddha_joag>
Component:	HSSF	Assignee:	POI Developers List <dev>
Status:	RESOLVED FIXED
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