Created attachment 35813 [details] Java class hyperlink.getLabel() returns null instead of display text for hyperlink. But in normally works for xls files and HSSF. See attached example that shows bug.
Created attachment 35814 [details] xls file
Created attachment 35815 [details] xlsx file
The XSSF code (for XLSX) is returning the "display" property of the underlying CT Hyperlink xml. Could you try renaming your .xlsx file to .zip, unzipping it, and looking in the XML to see what your version of Excel decided to store the label as/in?
File created in Excel 2013. Sheet looks like this: <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="x14ac" xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac"><dimension ref="A1"/><sheetViews><sheetView tabSelected="1" workbookViewId="0"/></sheetViews><sheetFormatPr defaultRowHeight="15" x14ac:dyDescent="0.25"/><sheetData><row r="1" spans="1:1" x14ac:dyDescent="0.25"><c r="A1" s="1" t="s"><v>0</v></c></row></sheetData><hyperlinks><hyperlink ref="A1" r:id="rId1"/></hyperlinks><pageMargins left="0.7" right="0.7" top="0.75" bottom="0.75" header="0.3" footer="0.3"/></worksheet> that points to hyperlynk (but there no display text): <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships"><Relationship Id="rId1" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/hyperlink" Target="pom.xml" TargetMode="External"/></Relationships> Found it ("MavenPom") in sharedStrings.xml: <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <sst xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" count="1" uniqueCount="1"><si><t>MavenPom</t></si></sst> I attached XLSX file to bug.
Also there same issue if you writing Hyperlink to Excel file. Setting address works, but label not shows in MS Excel (cell will have blank text, but style will be hyperlink and navigation will work)
What do you get if you read the column-value? I think that will return the text of the hyperlink.
Yes, string Cell velue gives display text for hyperlink (not sure that always will match hyperlynk label from hyperlink properties). But if you trying to create hyperlink from code and save it to xlsx, there no way to save Label. If you creating hyperlink with Label Excel will show blank display text\cell and setting string Cell value replacing hyperlink in cell.