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]