diff options
| author | Balazs Varga <balazs.varga.extern@allotropia.de> | 2024-02-14 22:34:10 +0100 |
|---|---|---|
| committer | Thorsten Behrens <thorsten.behrens@allotropia.de> | 2024-04-30 11:20:47 +0200 |
| commit | ebfe1850599bbb4d8e529787940511aae18b00ee (patch) | |
| tree | 78fe31b2736bbffd2d671debab7ced519ee75423 /officecfg | |
| parent | e721d87b18f199e09e493e80d8f1d4861de5b409 (diff) | |
tdf#124098 sc add global config setting "RecalcOptimalRowHeightMode"
to optimal row height recalculation for optimal document loading.
If the "RecalcOptimalRowHeightMode" is set to "Recalc always" we always
recalculate the optimal row heights at load time, without any warning dialog.
If the "RecalcOptimalRowHeightMode" is set to "Recalc" we never recalculate
the optimal row heights at load time, without any warning dialog.
If the "RecalcOptimalRowHeightMode" is set to "Ask before Recalc" we ask the user
if want to recalculate the optimal row heights at load time or not.
The default value is the same what we are doing now: "Recalc always"
This option was necessary, since optimal row height calculation depending on also
the result of the conditional formatted formulas and it takes a lot of time to calculate
the optimal row heights and load the document. Because we allow a lot of text/cell format
attribute which are effect on the cell size, therefor it is necessary to evaluate all
the formulas. Also if we have 20 condition for a cell range we need to evaluate all
the 20 formulas for all the cells and it is very expensive at load time.
Change-Id: I9288d11dd2f061f85fa36292a909402a6bb89ea9
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/163421
Tested-by: Jenkins
Reviewed-by: Balazs Varga <balazs.varga.extern@allotropia.de>
Diffstat (limited to 'officecfg')
| -rw-r--r-- | officecfg/registry/schema/org/openoffice/Office/Calc.xcs | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/officecfg/registry/schema/org/openoffice/Office/Calc.xcs b/officecfg/registry/schema/org/openoffice/Office/Calc.xcs index d54b092eca66..a8830ab1ba19 100644 --- a/officecfg/registry/schema/org/openoffice/Office/Calc.xcs +++ b/officecfg/registry/schema/org/openoffice/Office/Calc.xcs @@ -1532,6 +1532,30 @@ </constraints> <value>1</value> </prop> + <prop oor:name="RecalcOptimalRowHeightMode" oor:type="xs:int" oor:nillable="false"> + <!-- UIHint: Tools - Options - Spreadsheet - Formula --> + <info> + <desc>Specifies whether to force a hard recalc after load on optimal row heights.</desc> + </info> + <constraints> + <enumeration oor:value="0"> + <info> + <desc>Recalc always</desc> + </info> + </enumeration> + <enumeration oor:value="1"> + <info> + <desc>Recalc never</desc> + </info> + </enumeration> + <enumeration oor:value="2"> + <info> + <desc>Ask before Recalc</desc> + </info> + </enumeration> + </constraints> + <value>0</value> + </prop> </group> </group> <group oor:name="Revision"> |