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 46174] Unable to create references to cells in 3.2-FINAL
Date Fri, 14 Nov 2008 02:32:43 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=46174


Josh Micich <josh@gildedtree.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|WORKSFORME                  |FIXED




--- Comment #8 from Josh Micich <josh@gildedtree.com>  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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message