https://bugs.documentfoundation.org/show_bug.cgi?id=143225
Bug ID: 143225
Summary: External references to cells in other files disappear
when copying sheet to another workbook, even when
directly importing the relevant sheet into the other
workbook.
Product: LibreOffice
Version: 7.1.3.2 release
Hardware: Other
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: libreoff...@famantic.net
Description:
I created a sheet that fetches data from a different workbook. The sheet does
some manipulation and is made flexible so that it is of use in other workbooks
when copied into those by changing certain text. However the file references
disappear when copied (or moved) using the sheet's tab functionality.
Trying from the other end to use 'Sheet > Insert Sheet from File...' yields the
same bad result. Same thing when using 'Sheet > Insert Sheet...' and choosing
the file option.
At one point the file references did not completely disappear, but instead they
were all changed into the file path from which I inserted the relevant sheet
rather than the original file path to where the information actually is
located. But it only happened once and I have not been able to get that
behavior again. Mostly the references just disappear altogether.
E.g.:
The sheet that does the import (that I want to use in many places) has a
formula like this:
```
=IF(F6>0;'file:///home/nenant/HOST/Dropbox/ekonomi/AB/avtal/Export_GCal_to_GSheet.202106.ods'#$Sheet1.B5;"")
```
When received in the workbook where I want a copy the formula instead ends up
like this:
```
=IF(F6>0;;"")
```
Except that one time when instead the file reference had been changed into:
```
=IF(F6>0;'file:///home/nenant/HOST/Dropbox/ekonomi/AB/avtal/kunder/ASIH-Vallentuna/Fakturaunderlag
2021.ASIH Vallentuna.ods'#$Sheet1.B5;"")
```
Which is completely wrong.
The import sheet that is supposed to be reused in other workbooks has MANY
external references, ~ 240 (if that has anything to do with it?)
I am running Libreoffice 7.1.3.2 on Linux (OpenSUSE 15.2) in VMWare Fusion on a
Macbook Pro.
On the Mac host I have Libreoffice 7.0.3.1 and the same set of files do not
exhibit this problem.
Steps to Reproduce:
1. Create a sheet with (possibly many) external cell references to a different
workbook.
2. Use tab menu to copy the sheet to another workbook, OR...
3. From a third workbook use 'Sheet > Insert Sheet from File...' to copy the
the sheet with all the external references.
Actual Results:
External references disappear in the copied sheet
Expected Results:
All external references should remain intact and still point to the correct
cells in the workbook containing the relevant data.
Reproducible: Always
User Profile Reset: No
OpenGL enabled: Yes
Additional Info:
I can provide the actual sheets to test the defunct behavior.
-
Version: 7.1.3.2 / LibreOffice Community
Build ID: 10(Build:2)
CPU threads: 5; OS: Linux 5.3; UI render: default; VCL: kf5
Locale: sv-SE (en_US.UTF-8); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
