| Summary: | HSSF: Hyperlink to a textmark does not work. | ||
|---|---|---|---|
| Product: | POI | Reporter: | Berthold Froese <Berthold.Froese> |
| Component: | HSSF | Assignee: | POI Developers List <dev> |
| Status: | RESOLVED WORKSFORME | ||
| Severity: | major | CC: | Berthold.Froese |
| Priority: | P2 | ||
| Version: | 3.6-FINAL | ||
| Target Milestone: | --- | ||
| Hardware: | PC | ||
| OS: | Windows XP | ||
I think this is not an issue any more since a long time, therefore I am closing this here, please reopen of report a new bug entry if you still have trouble with hyperlinks. |
Here the failure description: - Create an Excel cell - Append a hyperlink to the Excel cell. Example: HSSFSheet sheet = wb.getSheet("Hyperlinks"); HSSFRow hssfRow = sheet.createRow(20); HSSFCell cell = hssfRow.createCell(1); cell.setCellValue("Zelle B21"); link.setAddress("excelTest.xls.orig.xls"); link.setLabel("ZelleA11"); link.setTextMark("ZelleA11"); cell.setHyperlink(link); - If you perform a system output of the cell hyperlink values they are are available for this cell. - Store the workbook to a new excel file. - Open this file via Excel - The hyperlink is broken. The textmark is NOT available for the cell. if you read the new file vio POI you get the following values for this cell: cell.getStringCellValue(): Zelle B21 Address: excelTest.xls.orig.xls Label: file ShortFilename: excelTest.xls.orig.xls Hyperlink Type: 0 TextMark: null If you need more information please let me know.