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 2014/07/17 17:40:22 UTC
[Bug 56737] New: FormulaParseException for sheet or workbook scoped
named ranges when evaluating xlsx formulas
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
[Bug 56737] FormulaParseException for sheet or workbook scoped named
ranges when evaluating xlsx formulas
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=56737
--- Comment #1 from Nick Burch <ap...@gagravarr.org> ---
Created attachment 31826
--> https://issues.apache.org/bugzilla/attachment.cgi?id=31826&action=edit
Test Excel file with the described formulas and named ranges
--
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
[Bug 56737] FormulaParseException for sheet or workbook scoped named
ranges when evaluating xlsx formulas
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=56737
--- Comment #3 from Nick Burch <ap...@gagravarr.org> ---
Disabled, failing unit tests added in r1611400.
--
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
[Bug 56737] FormulaParseException for sheet or workbook scoped named
ranges when evaluating xlsx formulas
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=56737
Nick Burch <ap...@gagravarr.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |FIXED
--- Comment #4 from Nick Burch <ap...@gagravarr.org> ---
As of r1612156, this file can now be evaluated without error
--
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
[Bug 56737] FormulaParseException for sheet or workbook scoped named
ranges when evaluating xlsx formulas
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=56737
--- Comment #2 from Nick Burch <ap...@gagravarr.org> ---
Note that this is different to with .xls, where you get a different error
"java.lang.RuntimeException: Unexpected eval class
(org.apache.poi.ss.formula.eval.NameXEval)" when evaluating
--
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