Bug 46065 - Function evaluateAllFormulaCells doesn't work well
Summary: Function evaluateAllFormulaCells doesn't work well
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.2-dev
Hardware: PC Windows XP
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-10-22 10:35 UTC by Duc Nguyen
Modified: 2008-10-27 11:19 UTC (History)
2 users (show)


Attachments
one added test spreadsheet file (533.57 KB, application/zip)
2008-10-22 10:40 UTC, Duc Nguyen 		Details
Test-case spreadsheet in case formula cell containing function VALUE (13.50 KB, application/vnd.ms-excel)
2008-10-23 01:40 UTC, Duc Nguyen 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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.