https://bugs.freedesktop.org/show_bug.cgi?id=60645
Priority: medium
Bug ID: 60645
Assignee: [email protected]
Summary: Formulas not refreshing on document (.ods) opening
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 4.0.0.3 release
Component: Spreadsheet
Product: LibreOffice
Problem description:
I have several documents that must auto-refresh formula values on document
open, but do not do so any more.
Use case: I use a file naming convention which allows me to create a copy of an
existing proposal, rename it, and several fields in the document get updated to
reflect new proposal reference numbers etc. This no longer works.
Steps to reproduce:
1. Create document, set A1 to =CALC("filename",A1)
2. Save document as OOCalcBug.ods, close document
3. Reopen document, confirm A1 now shows filename in A1. Close document.
4. Rename document to OOCalcBug2.ods
5. Open OOCalcBug2.ods, confirm A1 shows new filename.
Current behavior:
Step 5: old filename is shown.
Expected behavior:
Step 5: new filename should be shown.
Note:
I am aware that this is a new feature when opening spreadsheets. Looking in the
options (under Calc->Formulas) there is the option to turn this off for .XLS or
.ODF but not .ODS.
--
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
