You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2008/05/19 22:19:00 UTC

DO NOT REPLY [Bug 45041] Invalid Formula cell reference when creating formula

https://issues.apache.org/bugzilla/show_bug.cgi?id=45041





--- Comment #1 from Andreas Goetz <cp...@gmx.de>  2008-05-19 13:18:59 PST ---
I've verified error message with 3.1b1- still existing but different:

Exception in
thread "main" org.apache.poi.hssf.model.FormulaParser$FormulaParseException:
Integer Expected
        at
org.apache.poi.hssf.model.FormulaParser.expected(FormulaParser.java:137)
        at
org.apache.poi.hssf.model.FormulaParser.parseNumber(FormulaParser.java:578)
        at
org.apache.poi.hssf.model.FormulaParser.parseSimpleFactor(FormulaParser.java:545)
        at
org.apache.poi.hssf.model.FormulaParser.percentFactor(FormulaParser.java:502)
        at
org.apache.poi.hssf.model.FormulaParser.powerFactor(FormulaParser.java:489)
        at
org.apache.poi.hssf.model.FormulaParser.Term(FormulaParser.java:703)
        at
org.apache.poi.hssf.model.FormulaParser.additiveExpression(FormulaParser.java:781)
        at
org.apache.poi.hssf.model.FormulaParser.concatExpression(FormulaParser.java:766)
        at
org.apache.poi.hssf.model.FormulaParser.comparisonExpression(FormulaParser.java:723)
        at
org.apache.poi.hssf.model.FormulaParser.Arguments(FormulaParser.java:479)
        at
org.apache.poi.hssf.model.FormulaParser.function(FormulaParser.java:326)
        at
org.apache.poi.hssf.model.FormulaParser.parseIdent(FormulaParser.java:236)
        at
org.apache.poi.hssf.model.FormulaParser.parseSimpleFactor(FormulaParser.java:542)
        at
org.apache.poi.hssf.model.FormulaParser.percentFactor(FormulaParser.java:502)
        at
org.apache.poi.hssf.model.FormulaParser.powerFactor(FormulaParser.java:489)
        at
org.apache.poi.hssf.model.FormulaParser.Term(FormulaParser.java:703)
        at
org.apache.poi.hssf.model.FormulaParser.additiveExpression(FormulaParser.java:781)
        at
org.apache.poi.hssf.model.FormulaParser.concatExpression(FormulaParser.java:766)
        at
org.apache.poi.hssf.model.FormulaParser.comparisonExpression(FormulaParser.java:723)
        at
org.apache.poi.hssf.model.FormulaParser.Arguments(FormulaParser.java:479)
        at
org.apache.poi.hssf.model.FormulaParser.function(FormulaParser.java:326)
        at
org.apache.poi.hssf.model.FormulaParser.parseIdent(FormulaParser.java:236)
        at
org.apache.poi.hssf.model.FormulaParser.parseSimpleFactor(FormulaParser.java:542)
        at
org.apache.poi.hssf.model.FormulaParser.percentFactor(FormulaParser.java:502)
        at
org.apache.poi.hssf.model.FormulaParser.powerFactor(FormulaParser.java:489)
        at
org.apache.poi.hssf.model.FormulaParser.Term(FormulaParser.java:703)
        at
org.apache.poi.hssf.model.FormulaParser.additiveExpression(FormulaParser.java:787)
        at
org.apache.poi.hssf.model.FormulaParser.concatExpression(FormulaParser.java:766)
        at
org.apache.poi.hssf.model.FormulaParser.comparisonExpression(FormulaParser.java:723)
        at
org.apache.poi.hssf.model.FormulaParser.parseSimpleFactor(FormulaParser.java:532)
        at
org.apache.poi.hssf.model.FormulaParser.percentFactor(FormulaParser.java:502)
        at
org.apache.poi.hssf.model.FormulaParser.powerFactor(FormulaParser.java:489)
        at
org.apache.poi.hssf.model.FormulaParser.Term(FormulaParser.java:703)
        at
org.apache.poi.hssf.model.FormulaParser.additiveExpression(FormulaParser.java:781)
        at
org.apache.poi.hssf.model.FormulaParser.concatExpression(FormulaParser.java:766)
        at
org.apache.poi.hssf.model.FormulaParser.comparisonExpression(FormulaParser.java:723)
        at
org.apache.poi.hssf.model.FormulaParser.parse(FormulaParser.java:820)
        at
org.apache.poi.hssf.usermodel.HSSFCell.setCellFormula(HSSFCell.java:641)


-- 
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org