https://issues.apache.org/bugzilla/show_bug.cgi?id=47809
--- Comment #2 from Petr.Udalau <[email protected]> 2009-09-15 05:06:58 PDT --- Created an attachment (id=24268) --> (https://issues.apache.org/bugzilla/attachment.cgi?id=24268) zip with patch and TestData There is a patch with test. Test: internal VB function and function in ToolPack. Also there is one problem with Names of Workbook: if I set value for cell inside the POI cell.setCellFormula("ISODD(1)")(function "ISODD" defined in AnalysisToolPak) error will occur: org.apache.poi.ss.formula.FormulaParser$FormulaParseException: Name 'ISODD' is completely unknown in the current workbook at org.apache.poi.ss.formula.FormulaParser.function(FormulaParser.java:932) at org.apache.poi.ss.formula.FormulaParser.parseNonRange(FormulaParser.java:570) at org.apache.poi.ss.formula.FormulaParser.parseRangeable(FormulaParser.java:442) at org.apache.poi.ss.formula.FormulaParser.parseRangeExpression(FormulaParser.java:285) at org.apache.poi.ss.formula.FormulaParser.parseSimpleFactor(FormulaParser.java:1131) at org.apache.poi.ss.formula.FormulaParser.percentFactor(FormulaParser.java:1091) at org.apache.poi.ss.formula.FormulaParser.powerFactor(FormulaParser.java:1078) at org.apache.poi.ss.formula.FormulaParser.Term(FormulaParser.java:1400) at org.apache.poi.ss.formula.FormulaParser.additiveExpression(FormulaParser.java:1500) at org.apache.poi.ss.formula.FormulaParser.concatExpression(FormulaParser.java:1484) at org.apache.poi.ss.formula.FormulaParser.comparisonExpression(FormulaParser.java:1441) at org.apache.poi.ss.formula.FormulaParser.unionExpression(FormulaParser.java:1421) at org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:1542) at org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:193) at org.apache.poi.hssf.model.HSSFFormulaParser.parse(HSSFFormulaParser.java:69) at org.apache.poi.hssf.usermodel.HSSFCell.setCellFormula(HSSFCell.java:598). Work with Names must be fixed. -- 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]
