https://bz.apache.org/bugzilla/show_bug.cgi?id=65490

            Bug ID: 65490
           Summary: Can't remove Hyperlinks that are used in multiple
                    cells
           Product: POI
           Version: 5.0.0-FINAL
          Hardware: PC
            Status: NEW
          Severity: normal
          Priority: P2
         Component: XSSF
          Assignee: dev@poi.apache.org
          Reporter: joanpu...@gmail.com
  Target Milestone: ---

In case a hyperlink is used in a cell range (for example B2:B4) it can't be
deleted.
Because although it can be retrieved with `sheet.getHyperlinkList()` it can't
be deleted because currently available method
org.apache.poi.xssf.usermodel.XSSFSheet#removeHyperlink` only match a single
cell.

You can easily create one of that cells with copy-paste using a cell with a
hyperlink and paste it into a selection of several cells.

If you have one of those cells with hyperlinks, operations like
`sheet.shiftRows` fail without being able to process the file and not being
able to work around by deleting the links.

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

Reply via email to