Bug 96498 - FILESAVE Detailed Calculation Settings won't trigger file change
Summary: FILESAVE Detailed Calculation Settings won't trigger file change
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: ModifiedStatus
  Show dependency treegraph
Reported: 2015-12-15 01:56 UTC by wu.ming2
Modified: 2021-08-21 20:18 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:
Regression By:


Note You need to log in before you can comment on or make changes to this bug.
Description wu.ming2 2015-12-15 01:56:40 UTC
Preferences > Calc > Formula

Set Detailed Calculation Settings = Custom working on a existing XLS file and save the file.  Close and re-open the file.  Revert to = Default and save the file.  Trying to set back = Custom won't trigger the file change.  Re-open Preferences > Calc > Formula and Detailed Calculation Settings = Default.

In a existing ODF file Detailed Calculation Settings = Custom.  Don't know why, not set by me.  Set to = Default triggers file change. Save the file.  Close and re-open the file.  Preferences > Calc > Formula and Detailed Calculation Settings = Custom again.

In a newly-created ODF file Detailed Calculation Settings = Default.  Save and re-open the file.  Set = Custom.  Re-open Preferences > Calc >  and Formula Detailed Calculation Settings = Default looks un-changed.  Save the file with CTRL-S.  Close and re-open the file.  Now Preferences > Calc > Formula Detailed and Calculation Settings = Custom looks updated.
Comment 1 Alex Thurgood 2015-12-15 08:42:05 UTC
@wu ming : the Preferences > Calc > Formula setting should apply to LibreOffice as a whole, unless you click on the Details button and the click on the option to apply to current document. Is this what you did with your first example involving the Excel file ?

The reason I ask is that the default setting for me in my master build 5.2 alpha is for customised calculation. If I then reset the formula calculation to Default, without having changed anything else in the sheet, I can save the file to xlsx and get the usual question about whether I really want to export to xlsx blabla because I might lose formatting etc. When I re-open the file, and return to Preferences again, I see that Customised is again selected, instead of Default, so in that sense, I can reproduce your findings (only the other way around).
Comment 2 wu.ming2 2015-12-15 08:56:49 UTC
@alex: in Detailed Calculation Settings : Details don't see anything to set as per-file configuration.  I can read

- convert from text to num
- treat empty string as zero
- reference syntax for string ref
- use OpenCL for a subset of operations (default ON)
- minimum data for OpenCL use
- subset of OpCodes (with a list)

and a button to test OpenCL.  Works.

The XLS was not converted from ODF.
Comment 3 Michael Meeks 2016-06-30 11:03:08 UTC
Just to clarify - saving advanced calculation settings in an XLSX file is rather a niche feature =) I'll set this to enhancement; thanks for reporting.