Bug 122678 - EDITING Inserting/Deleting Row Does not Update Hyperlinks
Summary: EDITING Inserting/Deleting Row Does not Update Hyperlinks
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.1.4.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-01-12 18:00 UTC by Joe
Modified: 2019-03-21 12:23 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Sample Calc document (8.22 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-01-12 18:00 UTC, Joe 		Details
Example file - named range. (8.67 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-01-13 16:27 UTC, raal 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Joe 2019-01-12 18:00:10 UTC 
Created attachment 148271 [details]
Sample Calc document

Inserting/Deleting a row to/from the sheet does not update hyperlinks causing it to point to different cells after the operation. In the sample document the Hyperlink in the B3 cell points to cell C20 with text "Target". If a row is inserted, the Hyperlink does not point to cell with "Target" anymore. 

Is this the correct behavior?
Comment 1 raal 2019-01-13 16:27:53 UTC 
Created attachment 148291 [details]
Example file - named range.

You should use named range. See the example file.
Comment 2 Xisco Faulí 2019-03-21 12:23:18 UTC 
Hi raal,
thanks for the explanation.
Closing as RESOLVED NOTABUG