https://issues.apache.org/bugzilla/show_bug.cgi?id=46174
Josh Micich <[EMAIL PROTECTED]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|WORKSFORME |FIXED
--- Comment #8 from Josh Micich <[EMAIL PROTECTED]> 2008-11-13 18:32:42 PST ---
Fixed in svn r713909 ( https://svn.apache.org/viewcvs.cgi?view=rev&rev=713909 )
Junit added.
The problem was that NameRecord had its own reference parsing logic that didn't
distinguish between relative and absolute cell references. The easiest fix was
to replace this logic with the common formula parsing logic which has much
greater coverage of Excel formula syntax. This has the benefit of allowing POI
to support defined names with any general formula.
I renamed(deprecated) the get/setReference methods because the name is
misleading. Now you can use get/setFormula to the same effect.
Unfortunately, the formula parser does not support the union operator yet, so
there has been a slight regression in functionality. For example,
hssfName.setFormula("Sheet1!A1:B2,Sheet1!C3:D4") will fail at the moment. I'm
not sure if this functionality is of a high priority.
--
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
