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: dev@poi.apache.org 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]