Description:
In LibreOffice Calc, it is possible to insert links to Named Ranges in external files, which can then be updated when the file is opened or updated on demand.

This functionality was working in versions 4.2.5.2 through to at least 5.0.6.3.

From at least Calc version 5.3.0.1 (not able to determine from which version  the problem started), the linked ranges (can be seen using Navigator <F5>-->Linked Ranges) are being incorrectly stated, leading to overwriting of data from other links.

This functionality was being used to consolidate Time Sheets of 35 employees, but with a recent upgrade of LibreOffice to version 6.0.2.1, we are unable to get the correct data as many employees time data is overwritten by ranges containing other employees time data.

Steps to Reproduce:
1. Take the files (File1.ods to File6.ods and Conso.ods) sent with this bug report and copy them to a folder
2. Open the file Conso.ods
3. DO NOT update the links when the dialog appears
4. Click on Menu: Edit-->Links (version 5.3) or Links to External files.. (version 6.0)
5. You will see 6 files to be updated (Screenshot1).
6. Select all files, using the Shift key
7. Click Update

Actual Results:  
1. After update, only 4 files will show in the dialog box
2. Link to Files 3 and 4 have disappeared
3. Data of Files 3, 4 has been completely overwritten and data of File5 has only 2 lines.  File 6 data has come in, but at the wrong position.

The Linked Ranges have changed after the saving of the file.

Thus, the Linked Ranges show as:

1. For File1: A2:B3001 (incorrect)
2. For File2: A4001:B10999 (incorrect)
3. For File3: A8001:B18999 (incorrect)
4. For File4: A12001:B26999 (incorrect)
5. For File5: A16001:B34999 (incorrect)
6. For File6: A20001:B42999 (incorrect)

Expected Results:
In each of the files File1.ods to File6.ods, the range "Data" covers lines A2:B3000 (2999 lines).

The linked ranges are as follows:
1. Cell A2: Link to File1.ods (Range "Data")
2. Cell A4001: Link to File2.ods (Range "Data")
3. Cell A8001: Link to File3.ods (Range "Data")
4. Cell A12001: Link to File4.ods (Range "Data")
5. Cell A16001: Link to File5.ods (Range "Data")
6. Cell A20001: Link to File6.ods (Range "Data")

In "Navigator" <F5>, double clicking on the "Data" of each of the Linked Ranges should show the starting and ending cells as given in the enclosed file "CellRanges.ods".

Thus, Linked Ranges show as:

1. For File1: A2:B3000
2. For File2: A4001:B6999
3. For File3: A8001:B10999
4. For File4: A12001:B14999
and so on for File5 and File6


Reproducible: Always


User Profile Reset: No



Additional Info:
Appears to be similar to Bug Report 106074 and 76047, though this problem is restricted to link to .ods files and the destination file is also a .ods file

What appears to be happening is that the Linked Ranges are re-defined during the Save File process and the LAST row of the Linked range becomes:

"Starting Range Row number" + "Starting Range Row number" + "Rows of the Imported Range" - 2:
e.g. 
For the first range (File1), this becomes:
2 + 2 + 2999 -2 = 3003 -2 = 3001
Thus, the range becomes:
A2:B(3003-2) i.e. A2:B3001

For the second range (File2), this becomes:
4001 + 4001 + 2999 -2 = 11001 -2 = 10999
Thus, the range becomes:
A4001:B(11001-2) i.e. A4001:B10999

For the third range (File3), this becomes:
8001 + 8001 + 2999 -2 = 18999
Thus, the range becomes:
A8001:B(19001-2) i.e. A8001:B18999

and so on...

This can be seen by double-clicking on the File "ConsoOnFirstSave.ods" and going to the Linked Ranges (Navigator or <F5>) and selecting each of the ranges.



User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.139 Safari/537.36