Skip to content

Instantly share code, notes, and snippets.

@ru-zar
Created November 21, 2019 23:01
Show Gist options
  • Save ru-zar/3829f43cd8e8e242549b49e842aee23d to your computer and use it in GitHub Desktop.
Save ru-zar/3829f43cd8e8e242549b49e842aee23d to your computer and use it in GitHub Desktop.
OpenOffice diff between settings that evaluate excel formulas and settings that don't.
## from ~/.config/libreoffice/4/user-with-bug/registrymodifications.xcu
The first interesting part is that IterativeReference MinimumChange goes up to 0.001 from 0.0001. Some Googling on the subject reveals that some (recursive? cyclical?) Excel formulas iterate until the result becomes stable to a certain threshold. The settings change in the UI appears to raise that number, presumably for faster, less-finicky, less precise results?
5c5
< <item oor:path="/org.openoffice.Office.Calc/Calculate/IterativeReference"><prop oor:name="MinimumChange" oor:op="fuse"><value>0.0001</value></prop></item>
---
> <item oor:path="/org.openoffice.Office.Calc/Calculate/IterativeReference"><prop oor:name="MinimumChange" oor:op="fuse"><value>0.001</value></prop></item>
Ok, OOXMLRecalcMode from 0 to 1. That sounds right.
34c34
< <item oor:path="/org.openoffice.Office.Calc/Formula/Load"><prop oor:name="OOXMLRecalcMode" oor:op="fuse"><value>0</value></prop></item>
---
> <item oor:path="/org.openoffice.Office.Calc/Formula/Load"><prop oor:name="OOXMLRecalcMode" oor:op="fuse"><value>1</value></prop></item>
Disabling something called "StringRefAddressSyntax". I would guess that this is about how cells are referenced in formulas.
42c42
< <item oor:path="/org.openoffice.Office.Calc/Formula/Syntax"><prop oor:name="StringRefAddressSyntax" oor:op="fuse"><value>1</value></prop></item>
---
> <item oor:path="/org.openoffice.Office.Calc/Formula/Syntax"><prop oor:name="StringRefAddressSyntax" oor:op="fuse"><value>0</value></prop></item>
I think these ones are just cruft from moving the UI around:
532c532
< <item oor:path="/org.openoffice.Setup/Office/Factories/org.openoffice.Setup:Factory['com.sun.star.frame.StartModule']"><prop oor:name="ooSetupFactoryWindowAttributes" oor:op="fuse"><value>622,64,1297,1016;1;0,0,0,0;</value></prop></item>
---
> <item oor:path="/org.openoffice.Setup/Office/Factories/org.openoffice.Setup:Factory['com.sun.star.frame.StartModule']"><prop oor:name="ooSetupFactoryWindowAttributes" oor:op="fuse"><value>0,64,1809,984;5;0,64,2560,1376;</value></prop></item>
535c535
< <item oor:path="/org.openoffice.Setup/Office/Factories/org.openoffice.Setup:Factory['com.sun.star.sheet.SpreadsheetDocument']"><prop oor:name="ooSetupFactoryWindowAttributes" oor:op="fuse"><value>0,64,1297,1016;1;0,0,0,0;</value></prop></item>
---
> <item oor:path="/org.openoffice.Setup/Office/Factories/org.openoffice.Setup:Factory['com.sun.star.sheet.SpreadsheetDocument']"><prop oor:name="ooSetupFactoryWindowAttributes" oor:op="fuse"><value>10,37,1297,1016;1;0,0,0,0;</value></prop></item>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment