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 46951] New: Cannot parse range expressions with non-cell ref operands
Date Wed, 01 Apr 2009 19:26:37 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=46951

           Summary: Cannot parse range expressions with non-cell ref
                    operands
           Product: POI
           Version: 3.5-dev
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: normal
          Priority: P5
         Component: HSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: josh@gildedtree.com


The following code:
cell.setCellFormula("SUM(C1:OFFSET(C1,0,B1))");

fails with this exception:
org.apache.poi.ss.formula.FormulaParser$FormulaParseException: Specified named
range 'OFFSET' does not exist in the current workbook.


This bug was noticed while fixing bug 46948 , which is concerned about
evaluation of the corresponding Ptg array (pre-parsed by Excel).

-- 
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