Summary: | Hyperlink to NamedRanges for HSSFWorkbook broken | ||
---|---|---|---|
Product: | POI | Reporter: | Wayne Clingingsmith <wayne.clingingsmith> |
Component: | XSSF | Assignee: | POI Developers List <dev> |
Status: | RESOLVED FIXED | ||
Severity: | normal | ||
Priority: | P2 | ||
Version: | 3.5-dev | ||
Target Milestone: | --- | ||
Hardware: | PC | ||
OS: | Windows XP | ||
Attachments: |
Excel screen shots
Excel file with errors in hyperlinks to named ranges Excel workbook with working hyperlinks to named ranges |
Created attachment 23270 [details]
Excel file with errors in hyperlinks to named ranges
Same coded used to create xls and xlsx workbooks
Created attachment 23271 [details]
Excel workbook with working hyperlinks to named ranges
Same coded used to create xls and xlsx workbooks
Comment on attachment 23271 [details]
Excel workbook with working hyperlinks to named ranges
Office2007 Excel workbook
|
Created attachment 23269 [details] 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