https://bugs.freedesktop.org/show_bug.cgi?id=87739
Bug ID: 87739
Summary: FILEOPEN : XLSX - formulas linked to other sheets are
not refreshed when opening file
Product: LibreOffice
Version: 4.3.5.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
Assignee: [email protected]
Reporter: [email protected]
Created attachment 111364
--> https://bugs.freedesktop.org/attachment.cgi?id=111364&action=edit
files 1.xlsx and 2.xlsx
Problem description: formulas linked to other XlSX sheets are not refreshed
when opening the file
Steps to reproduce:
1. create a new file in Excel 2013 format : c:\C:\Temp\LibreOffice\1.xlsx
2. add a value in cell A1 (sample value : 10) of file 1.xlsx and save the file
3. create a second file in Excel 2013 format : c:\C:\Temp\LibreOffice\2.xlsx
4. in cell A1 of file 2.xlsx, set value equal content of cell A1 of file 1.xlsx
and save the file file 2.xlsx. Cell A1 contains formula :
='file:///C:/Temp/LibreOffice/1.xlsx'#$Sheet1.A1 . In this case, the cell shows
the value 10
5. open file 1.xlsx, change the content of cell A1 from 10 to 15 and save the
file.
6. open file 2.xlsx. LibreOffice notifies that the spreasheet has cells with
link to other spreadsheet(s). Select YES to get the cell content updated. In
this LibreOffice version, the cell A1 in file 2.xlsx is not refreshed as
expected. It still shows the value 10 but it should display the value 15.
Current behavior: formulas linked to other sheets are not refreshed => the cell
shows the old value : 10
Expected behavior: formulas linked to other sheets are refreshed => the cell
shows the new value : 15
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
