Lines 819-829
Link Here
|
819 |
*/ |
819 |
*/ |
820 |
@Override |
820 |
@Override |
821 |
public XSSFHyperlink getHyperlink(CellAddress addr) { |
821 |
public XSSFHyperlink getHyperlink(CellAddress addr) { |
822 |
String ref = addr.formatAsString(); |
822 |
// find single-cell hyperlink at addr |
|
|
823 |
final String ref = addr.formatAsString(); |
824 |
final int row = addr.getRow(); |
825 |
final int column = addr.getColumn(); |
823 |
for(XSSFHyperlink hyperlink : hyperlinks) { |
826 |
for(XSSFHyperlink hyperlink : hyperlinks) { |
824 |
if(hyperlink.getCellRef().equals(ref)) { |
827 |
final String hyperRef = hyperlink.getCellRef(); |
|
|
828 |
|
829 |
// check if single-cell hyperlink |
830 |
if (hyperRef.equals(ref)) { |
825 |
return hyperlink; |
831 |
return hyperlink; |
826 |
} |
832 |
} |
|
|
833 |
|
834 |
// check if multi-cell hyperlink |
835 |
else if (hyperRef.contains(":")) { |
836 |
final CellRangeAddress area = CellRangeAddress.valueOf(hyperRef); |
837 |
if (area.isInRange(row, column)) { |
838 |
return hyperlink; |
839 |
} |
840 |
} |
827 |
} |
841 |
} |
828 |
return null; |
842 |
return null; |
829 |
} |
843 |
} |