Summary: |
FILEOPEN : XLSX - formulas linked to other sheets are not refreshed when opening file (hard recalc needed) |
Product: |
LibreOffice
|
Reporter: |
dpierret |
Component: |
Spreadsheet | Assignee: |
Not Assigned <libreoffice-bugs> |
Status: |
NEW
---
|
QA Contact: |
|
Severity: |
normal
|
|
|
Priority: |
medium
|
CC: |
raal
|
Version: |
4.3.5.2 release | |
|
Hardware: |
x86-64 (AMD64) | |
|
OS: |
Windows (All) | |
|
Whiteboard: |
|
i915 platform:
|
|
i915 features:
|
|
Attachments: |
files 1.xlsx and 2.xlsx
|
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.
Created attachment 111364 [details] 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