chronossc/openpyxl

Inserting rows causes hyperlink targets to shift

Closed this issue · 0 comments

Make an Excel file which has a column which contains hyperlinks to files (in my case .DOCX files). Let's pick column D since that is what I have. If you insert rows from the top of the file, you will notice that the hyperlinks no longer point to the correct matching files. If you have empty rows in-between then you may even notice some URLs stop pointing to anything at all. I am guessing the fix is not too bad and my client would greatly benefit from this fix. Thank you for your time and this is an awesome library!