After the row or column is deleted, the links become corrupt
Posted: Wed Dec 26, 2018 2:28 pm
Code: Select all
XLSReadWriteII51[0].MakeHyperlink(1, 1, 'file:///C:/Temp/Folder_1', 'folder link 1');
XLSReadWriteII51[0].MakeHyperlink(1, 2, 'file:///C:/Temp/Folder_2', 'link 2');
XLSReadWriteII51[0].MakeHyperlink(1, 3, 'file:///C:/Temp/Folder_3', 'link 3');
XLSReadWriteII51[0].MakeHyperlink(1, 4, 'file:///C:/Temp/Folder_4', 'link 4');
XLSReadWriteII51[0].MakeHyperlink(1, 5, 'file:///C:/Temp/Folder_5', 'link 5');
XLSReadWriteII51.DeleteRows(0, 4, 4);
XLSReadWriteII51.DeleteRows(0, 2, 2);
XLSReadWriteII51.DeleteRows(0, 1, 1);
XLSReadWriteII51.Write;
- The link of the "link 3" cell changes to "link 1".
- The link of the "link 4" cell changes to "link 2".