--- src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFSheet.java (revision 1760223) +++ src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFSheet.java (working copy) @@ -819,11 +819,25 @@ */ @Override public XSSFHyperlink getHyperlink(CellAddress addr) { - String ref = addr.formatAsString(); + // find single-cell hyperlink at addr + final String ref = addr.formatAsString(); + final int row = addr.getRow(); + final int column = addr.getColumn(); for(XSSFHyperlink hyperlink : hyperlinks) { - if(hyperlink.getCellRef().equals(ref)) { + final String hyperRef = hyperlink.getCellRef(); + + // check if single-cell hyperlink + if (hyperRef.equals(ref)) { return hyperlink; } + + // check if multi-cell hyperlink + else if (hyperRef.contains(":")) { + final CellRangeAddress area = CellRangeAddress.valueOf(hyperRef); + if (area.isInRange(row, column)) { + return hyperlink; + } + } } return null; }