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