https://issues.apache.org/bugzilla/show_bug.cgi?id=45025
Summary: Error in setFormula with VLOOKUP in 3.1-beta1 and 3.1-
beta2
Product: POI
Version: 3.0-dev
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [EMAIL PROTECTED]
When using setFormula in a HSSFCell with an inner VLOOKUP function as:
dailyCost.setCellFormula("VLOOKUP(\""+t.getRol()+"\";'Tarifas venta
personal'!$D$12:$E$30;2;false)");
I receive the following exception:
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:602)
at
org.apache.poi.hssf.model.FormulaParser.parseSimpleFactor(FormulaParser.java:569)
at
org.apache.poi.hssf.model.FormulaParser.percentFactor(FormulaParser.java:526)
at
org.apache.poi.hssf.model.FormulaParser.powerFactor(FormulaParser.java:513)
at org.apache.poi.hssf.model.FormulaParser.Term(FormulaParser.java:727)
at
org.apache.poi.hssf.model.FormulaParser.additiveExpression(FormulaParser.java:805)
at
org.apache.poi.hssf.model.FormulaParser.concatExpression(FormulaParser.java:790)
at
org.apache.poi.hssf.model.FormulaParser.comparisonExpression(FormulaParser.java:747)
at
org.apache.poi.hssf.model.FormulaParser.Arguments(FormulaParser.java:503)
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:566)
at
org.apache.poi.hssf.model.FormulaParser.percentFactor(FormulaParser.java:526)
at
org.apache.poi.hssf.model.FormulaParser.powerFactor(FormulaParser.java:513)
at org.apache.poi.hssf.model.FormulaParser.Term(FormulaParser.java:727)
at
org.apache.poi.hssf.model.FormulaParser.additiveExpression(FormulaParser.java:805)
at
org.apache.poi.hssf.model.FormulaParser.concatExpression(FormulaParser.java:790)
at
org.apache.poi.hssf.model.FormulaParser.comparisonExpression(FormulaParser.java:747)
at
org.apache.poi.hssf.model.FormulaParser.parse(FormulaParser.java:844)
at
org.apache.poi.hssf.usermodel.HSSFCell.setCellFormula(HSSFCell.java:641)
This problem doesn't happen in 3.0 final release, I'm trying to use 3.1 since I
need VLOOKUP function working with a reference in the first argument instead of
a literal.
--
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]
