poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 45025] New: Error in setFormula with VLOOKUP in 3. 1-beta1 and 3.1-beta2
Date Sat, 17 May 2008 20:12:17 GMT
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: dev@poi.apache.org
        ReportedBy: erudil@yahoo.com


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


Mime
View raw message