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
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
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 and svn r723392 . It doesn't look like there was a bugzilla entry for this work.