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: [email protected]
        ReportedBy: [email protected]


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: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to