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 2009/02/17 21:16:35 UTC

DO NOT REPLY [Bug 46725] New: Hyperlink to NamedRanges for HSSFWorkbook broken

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

           Summary: Hyperlink to NamedRanges for HSSFWorkbook broken
           Product: POI
           Version: 3.5-dev
          Platform: PC
        OS/Version: Windows XP
            Status: NEW
          Severity: normal
          Priority: P2
         Component: XSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: wayne.clingingsmith@trintech.com


Created an attachment (id=23269)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=23269)
Excel screen shots

POI 3.5beta4
Creating a hyperlink to a named range in a XSSFWorkbook works however creating
a hyperlink to a named range in an HSSFWorkbook is now broken.

The named range in Excel is created and looks ok, however selecting it throws
error. Looking at it using Excel/Insert/NAme/Define... it look ok and if you
select OK it is now fixed and the hyperlink works.

In our product we are using POI 3.2 which uses HSSFName.setReference and now
POI 3.5 is using HSSFName.setReferesToFormula



Noted a ToDo in source XSSFName.setRefersToFormula line 175

ptgs = FormulaParser.parse(formulaText, fpb, FormulaType.CELL); // TODO - use
type NAMEDRANGE


-- 
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 46725] Hyperlink to NamedRanges for HSSFWorkbook broken

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46725


Josh Micich <jo...@gildedtree.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|                            |FIXED




--- Comment #4 from Josh Micich <jo...@gildedtree.com>  2009-02-17 15:29:32 PST ---
Looks like this has been fixed since 3.5-beta4

You were right about the TODO. It's exactly this fix that addresses your bug. 
The relevant changelists were svn r729028 ( https://svn.apache.org/viewcvs.cgi?view=rev&rev=729028 )and svn r723392 ( https://svn.apache.org/viewcvs.cgi?view=rev&rev=723392 ).  It doesn't look
like there was a bugzilla entry for this work.


-- 
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 46725] Hyperlink to NamedRanges for HSSFWorkbook broken

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46725





--- Comment #1 from Wayne Clingingsmith <wa...@trintech.com>  2009-02-17 12:19:05 PST ---
Created an attachment (id=23270)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=23270)
Excel file with errors in hyperlinks to named ranges

Same coded used to create xls and xlsx workbooks


-- 
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 46725] Hyperlink to NamedRanges for HSSFWorkbook broken

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46725





--- Comment #3 from Wayne Clingingsmith <wa...@trintech.com>  2009-02-17 12:22:58 PST ---
(From update of attachment 23271)
Office2007 Excel workbook


-- 
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 46725] Hyperlink to NamedRanges for HSSFWorkbook broken

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46725





--- Comment #2 from Wayne Clingingsmith <wa...@trintech.com>  2009-02-17 12:21:27 PST ---
Created an attachment (id=23271)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=23271)
Excel workbook with working hyperlinks to named ranges

Same coded used to create xls and xlsx workbooks


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