Created attachment 143855 [details] Example configuration bundle to fix the formula syntax as Calc A1 If we finalize the corresponding configuration key of Calc - Formula - Formula syntax the dropdown list is still editable in the Options window. The value set is not saved, but applied to the UI until restart. No crash is experienced. Expected behavior: the Formula syntax dropdown should be disabled.
Dear Gabor Kelemen, This bug has been in ASSIGNED status for more than 3 months without any activity. Resetting it to NEW. Please assigned it back to yourself if you're still working on this.
Created attachment 152716 [details] Example configuration bundle to finalize the settings on the Formula page I took this a bit further and added lockdown support for all options on the Formula settings page and the Detailed calculation settings window: https://gerrit.libreoffice.org/#/c/75402/ This was the example bundle I used for testing.
Gabor Kelemen committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/dc1f304de78ccf20b3264cbc904d65f78864ec63 tdf#119021 Support lock down settings of Formula tab page It will be available in 6.4.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.