Hi,
On Mon, Apr 13, 2009 at 12:24 AM, Joe Black <[email protected]> wrote:
>
>
> I used this method to write a small program and it is working.
>
>
The sample program is using SUMIF, not SUMIFS -- that's working fine.
With SUMIFS you get:
12:06:51.655[INFO ][ ]Formula: SUMIF(K8:K29, "<>0") +
SUMIFS(I8:I29, K8:K29, "=0", I8:I29, "<>0") + SUMIFS(H8:H29, K8:K29, "=0",
I8:I29, "=0")
show error:
org.apache.poi.ss.formula.FormulaParser$FormulaParseException: Name 'SUMIFS'
is completely unknown in the current workbook
at
org.apache.poi.ss.formula.FormulaParser.function(FormulaParser.java:546)
at
org.apache.poi.ss.formula.FormulaParser.parseFunctionReferenceOrName(FormulaParser.java:324)
at
org.apache.poi.ss.formula.FormulaParser.parseSimpleFactor(FormulaParser.java:733)
at
org.apache.poi.ss.formula.FormulaParser.percentFactor(FormulaParser.java:693)
at
org.apache.poi.ss.formula.FormulaParser.powerFactor(FormulaParser.java:680)
at
org.apache.poi.ss.formula.FormulaParser.Term(FormulaParser.java:982)
at
org.apache.poi.ss.formula.FormulaParser.additiveExpression(FormulaParser.java:1099)
at
org.apache.poi.ss.formula.FormulaParser.concatExpression(FormulaParser.java:1067)
at
org.apache.poi.ss.formula.FormulaParser.comparisonExpression(FormulaParser.java:1024)
at
org.apache.poi.ss.formula.FormulaParser.unionExpression(FormulaParser.java:1003)
at
org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:1125)
at
org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:192)
at
org.apache.poi.hssf.model.HSSFFormulaParser.parse(HSSFFormulaParser.java:69)
at
org.apache.poi.hssf.usermodel.HSSFCell.setCellFormula(HSSFCell.java:605)
So either I'd need a way to disable formula parsing -or- I'd need to add
support for SUMIFS in POI.
Thanks!
- Filip
