Bug 146658 - Libreoffice calc breaks file links when copy Spreadsheet to another folder
Summary: Libreoffice calc breaks file links when copy Spreadsheet to another folder
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.2.4.1 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-01-08 19:56 UTC by fred4u
Modified: 2022-01-08 20:02 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description fred4u 2022-01-08 19:56:30 UTC
Description:
Libreoffice calc breaks file links when copy Spreadsheet to another folder
When linking to other spreadsheets, LO Calc stores something that seem like absolute path to the file.
After I copy the Spreadsheet to other folder, and open the spreadsheet in a different location, the link seem broken.

Created a simple test case:
x:\LibO_test\Somefolder\Datasource\datasource.ods is my linked data source

x:\LibO_test\Somefolder\Somespreadsheet.ods is my work spreadsheet where I do a database lookup. The URL is 'file:///X:/LibO_test/Somefolder/Datasource/datasource.ods'

Now when I copy the Somespreadsheet.ods to x:\LibO_test\Somespreadsheet.ods , and open it in new location (x:\LibO_test instead of x:\LibO_test\Somefolder) I get broken URL: 'file:///X:/LibO_test/Datasource/datasource.ods'

(note the missing "/Somefolder" in the path)



Steps to Reproduce:
1. Detailed in description
2.
3.

Actual Results:
Result in broken file URL

Expected Results:
Expect to not break absolute file URLs


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.2.4.1 (x64) / LibreOffice Community
Build ID: 27d75539669ac387bb498e35313b970b7fe9c4f9
CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: pl-PL (pl_PL); UI: pl-PL
Calc: threaded
Comment 1 fred4u 2022-01-08 20:02:47 UTC
Although the path seemed absolute, the option was set to keep path relative.