Bug 46065

Summary: Function evaluateAllFormulaCells doesn't work well
Product: POI Reporter: Duc Nguyen <duc.nguyen>
Component: HSSFAssignee: POI Developers List <dev>
Severity: normal CC: duc.nguyen, s.maratea
Priority: P2    
Version: 3.2-dev   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Attachments: 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.
Comment 4 Josh Micich 2008-10-27 11:19:04 UTC
Implementation for VALUE() added in svn r708262.

I've made an assumption that this is all that needed to be fixed for this bug.  Please reopen with more details if you still have problems.