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 2008/04/06 22:49:43 UTC
DO NOT REPLY [Bug 44762] New: XSSF FormulaEvaluator does not handle
3D refs or Name tokens
https://issues.apache.org/bugzilla/show_bug.cgi?id=44762
Summary: XSSF FormulaEvaluator does not handle 3D refs or Name
tokens
Product: POI
Version: 3.0-dev
Platform: Macintosh
OS/Version: Mac OS X 10.3
Status: NEW
Severity: blocker
Priority: P4
Component: HSSF
AssignedTo: dev@poi.apache.org
ReportedBy: josh@gildedtree.com
In HSSF, the formula evaluator passes around a hsss.model.Workbook for 2
purposes:
- resolving cross-sheet references (Ref3dPtg and Area3dPtg)
- resolving named ranges and non-built-in functions (NamePtg and NameXPtg)
A common interface could be introduced to represent this functionality. In
HSSF, the concrete class hssf.model.Workbook could implement this interface.
In XSSF, perhaps an adapter wrapping XSSFWorkbook could be written. Maybe an
adapter in both places.
--
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
DO NOT REPLY [Bug 44762] XSSF FormulaEvaluator does not handle 3D
refs or Name tokens
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=44762
Nick Burch <ni...@torchbox.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |ASSIGNED
--- Comment #1 from Nick Burch <ni...@torchbox.com> 2008-04-07 03:34:59 PST ---
I have a feeling that HSSFWorkbook / XSSFWorkbook (and hence
ss.usermodel.Workbook) will already do the named range stuff for us, so that
ought to be an easy change
Is the sheet lookup actually the "get sheet from external sheet number/ref"
stuff? If so, I think we could probably put that onto ss.usermodel.Workbook,
and have HSSFWorkbook delegate that onto the model.Workbook
I'll have a go at tweaking shortly
--
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
DO NOT REPLY [Bug 44762] XSSF FormulaEvaluator does not handle 3D
refs or Name tokens
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=44762
Nick Burch <ni...@torchbox.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|ASSIGNED |RESOLVED
Resolution| |FIXED
--- Comment #2 from Nick Burch <ni...@torchbox.com> 2008-04-16 03:40:53 PST ---
I've updated trunk to use hssf.usermodel.HSSFWorkbook, and then applied the
same thing to the branch, switched to ss.usermodel.Workbook
All the tests now pass, but there is one rather icky method I've had to put
onto ss.usermodel.Workbook:
public String resolveNameXText(int refIndex, int definedNameIndex)
We'll want to replace that with something better, once someone can figure out
what it does!
--
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