https://issues.apache.org/bugzilla/show_bug.cgi?id=44675
Summary: [patch] POI does not distinguish functions with fixed vs
variable arguments
Product: POI
Version: 3.0-dev
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [EMAIL PROTECTED]
The following test code fails because POI encodes all functions as FuncVarPtg:
Workbook book = Workbook.createWorkbook();
Ptg[] ptgs = FormulaParser.parse("countif(A1:A2, 1)", book);
assertEquals(FuncPtg.class, ptgs[2].getClass());
Excel tolerates the incorrect token FuncVarPtg for many functions like SIN()
etc, but COUNTIF() is one example where this error is visible in Excel
(#VALUE!).
--
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]