poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From KiLiCoOl <kilic...@gmail.com>
Subject Problem with IF function in FormulaControllerImpl.java
Date Fri, 09 Oct 2009 08:48:44 GMT
Hi,

I've a problem with IF Function since I use APACHE POI 3.2 version instead
of 3.0.2 VERSION

This is the error :

10:43:12 FormulaControllerImpl.java 135 => Can't set formula:
IF(AND(E12="Groupe";AD12="53789556J");AB12;AE12)
org.apache.poi.ss.formula.FormulaParser$FormulaParseException: Parse error
near char 19 ';' in specified formula
'IF(AND(E12="Groupe";AD12="53789556J");AB12;AE12)'. Expected ',' or ')'
        at
org.apache.poi.ss.formula.FormulaParser.expected(FormulaParser.java:203)
        at
org.apache.poi.ss.formula.FormulaParser.Arguments(FormulaParser.java:608)
        at
org.apache.poi.ss.formula.FormulaParser.function(FormulaParser.java:506)
        at
org.apache.poi.ss.formula.FormulaParser.parseFunctionReferenceOrName(FormulaParser.java:302)
        at
org.apache.poi.ss.formula.FormulaParser.parseSimpleFactor(FormulaParser.java:671)
        at
org.apache.poi.ss.formula.FormulaParser.percentFactor(FormulaParser.java:631)
        at
org.apache.poi.ss.formula.FormulaParser.powerFactor(FormulaParser.java:618)
        at
org.apache.poi.ss.formula.FormulaParser.Term(FormulaParser.java:920)
        at
org.apache.poi.ss.formula.FormulaParser.additiveExpression(FormulaParser.java:1001)
        at
org.apache.poi.ss.formula.FormulaParser.concatExpression(FormulaParser.java:985)
        at
org.apache.poi.ss.formula.FormulaParser.comparisonExpression(FormulaParser.java:942)
        at
org.apache.poi.ss.formula.FormulaParser.Arguments(FormulaParser.java:603)
        at
org.apache.poi.ss.formula.FormulaParser.function(FormulaParser.java:506)
        at
org.apache.poi.ss.formula.FormulaParser.parseFunctionReferenceOrName(FormulaParser.java:302)
        at
org.apache.poi.ss.formula.FormulaParser.parseSimpleFactor(FormulaParser.java:671)
        at
org.apache.poi.ss.formula.FormulaParser.percentFactor(FormulaParser.java:631)
        at
org.apache.poi.ss.formula.FormulaParser.powerFactor(FormulaParser.java:618)
        at
org.apache.poi.ss.formula.FormulaParser.Term(FormulaParser.java:920)
        at
org.apache.poi.ss.formula.FormulaParser.additiveExpression(FormulaParser.java:1001)
        at
org.apache.poi.ss.formula.FormulaParser.concatExpression(FormulaParser.java:985)
        at
org.apache.poi.ss.formula.FormulaParser.comparisonExpression(FormulaParser.java:942)
        at
org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:1043)
        at
org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:170)
        at
org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:165)
        at
org.apache.poi.hssf.model.HSSFFormulaParser.parse(HSSFFormulaParser.java:47)
        at
org.apache.poi.hssf.usermodel.HSSFCell.setCellFormula(HSSFCell.java:593)
        at
net.sf.jxls.formula.FormulaControllerImpl.writeFormulas(FormulaControllerImpl.java:133)
        at
net.sf.jxls.transformer.XLSTransformer.updateFormulas(XLSTransformer.java:443)

Somebody can help wy or tell my the reason why this worked with old 3.0.2
version and not with 3.2 ?

Best regards,
Julien

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message