source/text/scalc/01/12050200.xhp | 3 + source/text/scalc/01/solver_options.xhp | 43 +++++++++++++-------------- source/text/scalc/01/solver_options_algo.xhp | 8 +++++ 3 files changed, 32 insertions(+), 22 deletions(-)
New commits: commit f6451e798733abac6342c5fcb9da327cca905cd2 Author: Olivier Hallot <[email protected]> AuthorDate: Thu Sep 25 21:39:49 2025 -0300 Commit: Olivier Hallot <[email protected]> CommitDate: Fri Sep 26 10:26:57 2025 +0200 tdf#168552 Add sensitivity entry in Solver option page Change-Id: I425de9f277a020b47c6911f591cae7af40fd8799 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/191519 Tested-by: Jenkins Reviewed-by: Olivier Hallot <[email protected]> diff --git a/source/text/scalc/01/solver_options.xhp b/source/text/scalc/01/solver_options.xhp index 4898a0250b..67c30f6ca7 100644 --- a/source/text/scalc/01/solver_options.xhp +++ b/source/text/scalc/01/solver_options.xhp @@ -20,57 +20,56 @@ <meta> <topic id="textscalc01solver_optionsxml" indexer="include" status="PUBLISH"> - <title id="tit" xml-lang="en-US">Solver Options</title> + <title id="tit">Solver Options</title> <filename>/text/scalc/01/solver_options.xhp</filename> </topic> </meta> <body> - -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/solveroptionsdialog/SolverOptionsDialog" id="bm_id7214271" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/solveroptionsdialog/@@nowidget@@" id="bm_id7214271" localize="false"/> -<bookmark xml-lang="en-US" branch="index" id="bm_id291590166034871"> +<bookmark branch="hid/modules/scalc/ui/solveroptionsdialog/SolverOptionsDialog" id="bm_id7214271" localize="false"/> +<bookmark branch="hid/modules/scalc/ui/solveroptionsdialog/@@nowidget@@" id="bm_id7214271" localize="false"/> +<bookmark branch="index" id="bm_id291590166034871"> <bookmark_value>solver for Calc;options</bookmark_value> </bookmark> <h1 id="hd_id2794274"><variable id="solveroptionsh1"><link href="text/scalc/01/solver_options.xhp">Solver Options</link></variable></h1> -<paragraph id="par_id3163853" role="paragraph" xml-lang="en-US">Use the Options dialog to configure the solver engine.</paragraph> +<paragraph id="par_id3163853" role="paragraph">Use the Options dialog to configure the solver engine.</paragraph> <section id="howtoget"> <embed href="text/scalc/00/00000406.xhp#solver_options"/> </section> -<paragraph id="par_id9999694" role="paragraph" xml-lang="en-US">Click OK to accept the changes and to go back to the <link href="text/scalc/01/solver.xhp">Solver</link> dialog.</paragraph> +<paragraph id="par_id9999694" role="paragraph">Click OK to accept the changes and to go back to the <link href="text/scalc/01/solver.xhp">Solver</link> dialog.</paragraph> <h2 id="hd_id581589922716672">Solver engine</h2> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/solveroptionsdialog/engine" id="bm_id7214270" localize="false"/> -<paragraph id="par_id393993" role="paragraph" xml-lang="en-US"><ahelp hid=".">Select a solver engine. The listbox is disabled if only one solver engine is installed.</ahelp></paragraph> +<bookmark branch="hid/modules/scalc/ui/solveroptionsdialog/engine" id="bm_id7214270" localize="false"/> +<paragraph id="par_id393993" role="paragraph"><ahelp hid=".">Select a solver engine. The listbox is disabled if only one solver engine is installed.</ahelp></paragraph> <note id="par_id221589959855748">You can install more solver engines as extensions, if available. Open <menuitem>Tools - Extensions</menuitem> and browse to the Extensions web site to search for extensions.</note> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/solveroptionsdialog/settings" id="bm_id1331217" localize="false"/> +<bookmark branch="hid/modules/scalc/ui/solveroptionsdialog/settings" id="bm_id1331217" localize="false"/> <h2 id="hd_id711589922750833">Settings</h2> -<paragraph id="par_id130619" role="paragraph" xml-lang="en-US">Configure the current solver. In the Settings box, check all settings that you want to use for the current goal seeking operation. If the current option offers different values, the Edit button is enabled. Click <emph>Edit</emph> to open a dialog where you can change the value.</paragraph> +<paragraph id="par_id130619" role="paragraph">Configure the current solver. In the Settings box, check all settings that you want to use for the current goal seeking operation. If the current option offers different values, the Edit button is enabled. Click <emph>Edit</emph> to open a dialog where you can change the value.</paragraph> <list type="unordered"> <listitem> - <paragraph id="par_id651589925044267" role="listitem" localize="false"><embedvar href="text/scalc/01/solver_options_algo.xhp#DEPSEvolutionaryalgorithmh2"/></paragraph> + <paragraph id="par_id651589925044267" role="listitem" localize="false"><embedvar href="text/scalc/01/solver_options_algo.xhp#DEPSEvolutionaryalgorithmh2"/></paragraph> </listitem> <listitem> - <paragraph id="par_id391589925078747" role="listitem" localize="false"><embedvar href="text/scalc/01/solver_options_algo.xhp#SCOEvolutionaryAlgorithmh2"/></paragraph> + <paragraph id="par_id391589925078747" role="listitem" localize="false"><embedvar href="text/scalc/01/solver_options_algo.xhp#SCOEvolutionaryAlgorithmh2"/></paragraph> </listitem> <listitem> - <paragraph id="par_id671589925148891" role="listitem" localize="false"><embedvar href="text/scalc/01/solver_options_algo.xhp#LinearSolverh2"/></paragraph> + <paragraph id="par_id671589925148891" role="listitem" localize="false"><embedvar href="text/scalc/01/solver_options_algo.xhp#LinearSolverh2"/></paragraph> </listitem> <listitem> - <paragraph id="par_id711589925192067" role="listitem" localize="false"><embedvar href="text/scalc/01/solver_options_algo.xhp#SwarmNonLinearSolverh2"/></paragraph> + <paragraph id="par_id711589925192067" role="listitem" localize="false"><embedvar href="text/scalc/01/solver_options_algo.xhp#SwarmNonLinearSolverh2"/></paragraph> </listitem> </list> <h2 id="hd_id481589922813764">Edit</h2> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/solveroptionsdialog/edit" id="bm_id2186346" localize="false"/> -<paragraph id="par_id6531266" role="paragraph" xml-lang="en-US"><ahelp hid=".">If the current entry in the Settings listbox allows you to edit a value, you can click the Edit button. A dialog opens where you can change the value.</ahelp></paragraph> +<bookmark branch="hid/modules/scalc/ui/solveroptionsdialog/edit" id="bm_id2186346" localize="false"/> +<paragraph id="par_id6531266" role="paragraph"><ahelp hid=".">If the current entry in the Settings listbox allows you to edit a value, you can click the Edit button. A dialog opens where you can change the value.</ahelp></paragraph> <h2 id="hd_id331589923158248">Edit settings spin box</h2> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/doubledialog/DoubleDialog" id="bm_id2761315" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/doubledialog/@@nowidget@@" id="bm_id2761315" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/integerdialog/IntegerDialog" id="bm_id2761314" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/integerdialog/@@nowidget@@" id="bm_id2761314" localize="false"/> -<paragraph id="par_id3912778" role="paragraph" xml-lang="en-US"><ahelp hid=".">Enter or change the value of the selected setting.</ahelp></paragraph> +<bookmark branch="hid/modules/scalc/ui/doubledialog/DoubleDialog" id="bm_id2761315" localize="false"/> +<bookmark branch="hid/modules/scalc/ui/doubledialog/@@nowidget@@" id="bm_id2761315" localize="false"/> +<bookmark branch="hid/modules/scalc/ui/integerdialog/IntegerDialog" id="bm_id2761314" localize="false"/> +<bookmark branch="hid/modules/scalc/ui/integerdialog/@@nowidget@@" id="bm_id2761314" localize="false"/> +<paragraph id="par_id3912778" role="paragraph"><ahelp hid=".">Enter or change the value of the selected setting.</ahelp></paragraph> <section id="relatedtopics"> <embed href="text/scalc/01/solver.xhp#solver"/> <embed href="text/scalc/01/solver_options_algo.xhp#SolverAlgorithmsOptionsh1"/> diff --git a/source/text/scalc/01/solver_options_algo.xhp b/source/text/scalc/01/solver_options_algo.xhp index 59e70c2b10..5b39c42a75 100644 --- a/source/text/scalc/01/solver_options_algo.xhp +++ b/source/text/scalc/01/solver_options_algo.xhp @@ -308,6 +308,14 @@ <paragraph id="par_id861589961756408" role="tablecontent"><variable id="nonegdesc">Mark to force variables to be positive only.</variable></paragraph> </tablecell> </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id991758843652841" role="tablecontent">Generate sensitivity report</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id201758843652844" localize="false" role="tablecontent">Generates a sensitivity report in a new sheet called "Model_Sensitivity". This option has no effect with the CoinMP Linear solver.</paragraph> + </tablecell> + </tablerow> <tablerow> <tablecell> <paragraph id="par_id971589961907787" role="tablecontent">Epsilon level</paragraph> commit 72f14132d52088f555d8eb905f6bb944cd96756a Author: Olivier Hallot <[email protected]> AuthorDate: Thu Sep 25 19:54:42 2025 -0300 Commit: Olivier Hallot <[email protected]> CommitDate: Fri Sep 26 10:26:10 2025 +0200 tdf#168551 Update SUBTOTAL with summary above/below Change-Id: I4d012eaf92a2c6c57c22fb905d480bc413d6e74f Reviewed-on: https://gerrit.libreoffice.org/c/help/+/191518 Tested-by: Jenkins Reviewed-by: Olivier Hallot <[email protected]> diff --git a/source/text/scalc/01/12050200.xhp b/source/text/scalc/01/12050200.xhp index 03b9600011..9df6b2500f 100644 --- a/source/text/scalc/01/12050200.xhp +++ b/source/text/scalc/01/12050200.xhp @@ -41,6 +41,9 @@ <paragraph role="paragraph" id="par_id3153190"><ahelp hid="modules/scalc/ui/subtotaloptionspage/case">Recalculates subtotals when you change the case of a data label.</ahelp></paragraph> <bookmark branch="hid/modules/scalc/ui/subtotaloptionspage/sort" id="bm_id3152596" localize="false"/><h2 id="hd_id3151119">Pre-sort area according to groups</h2> <paragraph role="paragraph" id="par_id3149664"><ahelp hid="modules/scalc/ui/subtotaloptionspage/sort">Sorts the area that you selected in the <emph>Group by</emph> box of the Group tabs according to the columns that you selected.</ahelp></paragraph> +<bookmark branch="hid/modules/scalc/ui/subtotaloptionspage/summarybelow" id="bm_id881758840599995" localize="false"/> +<h2 id="hd_id111758840258673">Summary below data</h2> +<paragraph role="paragraph" id="par_id571758840533603">By default, the summary appears above the data. When selected, it moves below the data.</paragraph> <h2 id="hd_id3153951">Sort</h2> <bookmark branch="hid/modules/scalc/ui/subtotaloptionspage/formats" id="bm_id3147397" localize="false"/><h3 id="hd_id3145252">Include formats</h3> <paragraph role="paragraph" id="par_id3147125"><ahelp hid="modules/scalc/ui/subtotaloptionspage/formats">Considers formatting attributes when sorting.</ahelp></paragraph>
