|Summary:||Function evaluateAllFormulaCells doesn't work well|
|Product:||POI||Reporter:||Duc Nguyen <duc.nguyen>|
|Component:||HSSF||Assignee:||POI Developers List <dev>|
one added test spreadsheet file
Test-case spreadsheet in case formula cell containing function VALUE
Description Duc Nguyen 2008-10-22 10:35:29 UTC
POI was making a mistake of using evaluateAllFormulaCells for evaluation value of cell containing formula with LOOKUP function. For cells that contain the formulas, their formulas are evaluated, and the results are saved. In output file, although these cells remain as formula cells, their value isn't correct (e.g. cell E45, E46 in sheet 'Generator' of attached testcase) You can get data spreadsheet for test-case.
Comment 1 Duc Nguyen 2008-10-22 10:40:20 UTC
Created attachment 22765 [details] one added test spreadsheet file
Comment 2 Duc Nguyen 2008-10-23 01:40:52 UTC
Created attachment 22770 [details] Test-case spreadsheet in case formula cell containing function VALUE
Comment 3 Duc Nguyen 2008-10-23 01:43:15 UTC
More information, in case spreadsheet uses function VALUE, HSSFFormulaEvaluator doesn't update value in the cell. Attached file for test-case data.