Bug 48751 - HSSF: Hyperlink to a textmark does not work.
Summary: HSSF: Hyperlink to a textmark does not work.
Status: RESOLVED WORKSFORME
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.6-FINAL
Hardware: PC Windows XP
: P2 major (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-02-16 13:55 UTC by Berthold Froese
Modified: 2017-09-11 18:52 UTC (History)
1 user (show)



Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Berthold Froese 2010-02-16 13:55:57 UTC
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.
Comment 1 Dominik Stadler 2017-09-11 18:52:47 UTC
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.