Bug 45031 - Formula evaluator does not evaluate CHOOSE function
Summary: Formula evaluator does not evaluate CHOOSE function
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.0-dev
Hardware: All All
: P5 minor (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-05-18 18:45 UTC by Josh Micich
Modified: 2008-12-31 15:21 UTC (History)
0 users


Attachments
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 Josh Micich 2008-05-18 18:45:30 UTC 
Implementation not provided yet (as of 3.1-beta1+ svn r657702).

Another minor problem is that POI does not mark up the CHOOSE() encoding with  tAttrChoose and tAttrSkip tokens (as outlined in excelfileformat.pdf sec 3.10.5).  Excel (2007) seems to be OK with this.  The fix for this will involve similar logic as currently applied for IF() in FormulaParser.getFunction(String, int, List) etc.    This is probably not worth fixing until a real case is encountered where it is a problem.
Comment 1 Josh Micich 2008-12-31 15:21:19 UTC 
Fixed in svn r730469.

Testcases updated. Token markup changes has not been implemented yet.