Mailing-List: contact dev-help@poi.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Developers List" <dev@poi.apache.org>
From: bugzilla@apache.org
To: dev@poi.apache.org
Subject: [Bug 56737] New: FormulaParseException for sheet or workbook scoped
 named ranges when evaluating xlsx formulas
Date: Thu, 17 Jul 2014 15:40:22 +0000
Message-ID: <bug-56737-47293@https.issues.apache.org/bugzilla/>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: 7bit
Auto-Submitted: auto-generated
MIME-Version: 1.0

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

            Bug ID: 56737
           Summary: FormulaParseException for sheet or workbook scoped
                    named ranges when evaluating xlsx formulas
           Product: POI
           Version: 3.11-dev
          Hardware: PC
                OS: Linux
            Status: NEW
          Severity: normal
          Priority: P2
         Component: XSSF
          Assignee: dev@poi.apache.org
          Reporter: apache@gagravarr.org

Consider a .xlsx workbook with two sheets. Sheet two "Defines" has a named
range "NR_To_A1" on it, while there's a workbook scoped named range
"NR_Global_B2". The first sheet has formulas which use it

For a sheet scoped named range reference, with a formula like 

=Defines!NR_To_A1

Evaluation will fail with org.apache.poi.ss.formula.FormulaParseException: Cell
reference expected after sheet name at index 9.

For a workbook scoped named range reference, with a formula like 

=TestFile.xlsx!NR_Global_B2

Evaluation will fail with org.apache.poi.ss.formula.FormulaParseException:
Parse error near char 0 '[' in specified formula '[0]!NR_Global_B2'. Expected
number, string, or defined name

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