https://issues.apache.org/bugzilla/show_bug.cgi?id=46065
Summary: Function evaluateAllFormulaCells doesn't work well
Product: POI
Version: 3.2-dev
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
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.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]