source/text/scalc/00/00000412.xhp | 8 +++++++-
source/text/scalc/01/12060000.xhp | 25 +++++++++++++------------
2 files changed, 20 insertions(+), 13 deletions(-)
New commits:
commit ada03f41bc98b77aafbb36b45c9302993519eac2
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Wed Jan 3 20:54:47 2024 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Thu Jan 4 01:03:15 2024 +0100
tdf#155876 UI cmds Calc-Sheet menu (45)
+ Data menu for Calc, Multiple Operations commands
+ refactoring
Change-Id: I3795e10b80956fa85a2a9ec00250be7811dbbc01
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/161604
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/00/00000412.xhp
b/source/text/scalc/00/00000412.xhp
index 4f3afdd43e..75eef21a9e 100644
--- a/source/text/scalc/00/00000412.xhp
+++ b/source/text/scalc/00/00000412.xhp
@@ -311,7 +311,13 @@
<paragraph role="paragraph" id="par_id951704303538788">On the
<menuitem>Data</menuitem> menu of the <menuitem>Data</menuitem> tab, choose
<menuitem>Validity - Error - Alert</menuitem> tab.</paragraph>
</section>
- <paragraph role="paragraph" id="par_id3146978"><variable id="dnmfo">Choose
<emph>Data - Multiple Operations</emph>.</variable></paragraph>
+ <section id="mult_operations">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id3146978"><variable
id="dnmfo">Choose <emph>Data - Multiple
Operations</emph>.</variable></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id571704323996248">On the
<menuitem>Data</menuitem> menu of the <menuitem>Data</menuitem> tab, choose
<menuitem>Multiple Operations</menuitem>.</paragraph>
+ </section>
+
<paragraph role="paragraph" id="par_id3155809"><variable id="dnksd">Choose
<emph>Data - Consolidate</emph>.</variable></paragraph>
<paragraph role="paragraph" id="par_id3148701"><variable id="dngld">Choose
<emph>Data - Group and Outline</emph>.</variable></paragraph>
<paragraph role="paragraph" id="par_id3153815"><variable id="dngda">Choose
<emph>Data - Group and Outline - Hide Details</emph>.</variable></paragraph>
diff --git a/source/text/scalc/01/12060000.xhp
b/source/text/scalc/01/12060000.xhp
index 413e65a625..a04010a892 100644
--- a/source/text/scalc/01/12060000.xhp
+++ b/source/text/scalc/01/12060000.xhp
@@ -22,35 +22,36 @@
<meta>
<topic id="textscalc0112060000xml" indexer="include">
-<title id="tit" xml-lang="en-US">Multiple Operations</title>
+<title id="tit">Multiple Operations</title>
<filename>/text/scalc/01/12060000.xhp</filename>
</topic>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="hid/.uno:TableOperationDialog"
id="bm_id9116957" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/multipleoperationsdialog/MultipleOperationsDialog"
id="bm_id3151210" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/multipleoperationsdialog/@@nowidget@@"
id="bm_id3151210" localize="false"/>
+<bookmark branch="hid/.uno:TableOperationDialog" id="bm_id9116957"
localize="false"/>
+<bookmark
branch="hid/modules/scalc/ui/notebookbar/MenuData-TableOperationDialog"
id="bm_id381704323882263" localize="false"/>
+<bookmark
branch="hid/modules/scalc/ui/multipleoperationsdialog/MultipleOperationsDialog"
id="bm_id3151210" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/multipleoperationsdialog/@@nowidget@@"
id="bm_id3151210" localize="false"/>
<section id="multopheader">
<h1 id="hd_id3153381"><link href="text/scalc/01/12060000.xhp">Multiple
Operations</link></h1>
-<paragraph role="paragraph" id="par_id3154140" xml-lang="en-US"><variable
id="mehrfachoperationen"><ahelp hid=".uno:TableOperationDialog">Applies the
same formula to different cells, but with different parameter
values.</ahelp></variable></paragraph>
+<paragraph role="paragraph" id="par_id3154140"><variable
id="mehrfachoperationen"><ahelp hid=".uno:TableOperationDialog">Applies the
same formula to different cells, but with different parameter
values.</ahelp></variable></paragraph>
</section>
<section id="howtoget">
-<embed href="text/scalc/00/00000412.xhp#dnmfo"/>
+<embed href="text/scalc/00/00000412.xhp#mult_operations"/>
</section>
<embed href="text/scalc/guide/multioperation.xhp#multioperation"/>
<note id="par_id3152598">The <emph>Row</emph> or <emph>Column</emph> box must
contain a reference to the first cell of the selected range.</note>
<note id="par_id3154011">If you export a spreadsheet containing multiple
operations to Microsoft Excel, the location of the cells containing the formula
must be fully defined relative to the data range.</note>
<h2 id="hd_id3156441">Defaults</h2>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/multipleoperationsdialog/formulas"
id="bm_id3149581" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/multipleoperationsdialog/formulas"
id="bm_id3149581" localize="false"/>
<h3 id="hd_id3154492">Formulas</h3>
-<paragraph role="paragraph" id="par_id3151073" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/multipleoperationsdialog/formulas">Enter the cell
references for the cells containing the formulas that you want to use in the
multiple operation.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/multipleoperationsdialog/row" id="bm_id3156286"
localize="false"/>
+<paragraph role="paragraph" id="par_id3151073"><ahelp
hid="modules/scalc/ui/multipleoperationsdialog/formulas">Enter the cell
references for the cells containing the formulas that you want to use in the
multiple operation.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/multipleoperationsdialog/row"
id="bm_id3156286" localize="false"/>
<h3 id="hd_id3154729">Row</h3>
-<paragraph role="paragraph" id="par_id3148456" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/multipleoperationsdialog/row">Enter the input cell
reference that you want to use as a variable for the rows in the data
table.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/multipleoperationsdialog/col" id="bm_id3149123"
localize="false"/>
+<paragraph role="paragraph" id="par_id3148456"><ahelp
hid="modules/scalc/ui/multipleoperationsdialog/row">Enter the input cell
reference that you want to use as a variable for the rows in the data
table.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/multipleoperationsdialog/col"
id="bm_id3149123" localize="false"/>
<h3 id="hd_id3150718">Column</h3>
-<paragraph role="paragraph" id="par_id3150327" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/multipleoperationsdialog/col">Enter the input cell
reference that you want to use as a variable for the columns in the data
table.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3150327"><ahelp
hid="modules/scalc/ui/multipleoperationsdialog/col">Enter the input cell
reference that you want to use as a variable for the columns in the data
table.</ahelp></paragraph>
<embed href="text/shared/00/00000001.xhp#shrink_maximize"/>
</body>
</helpdocument>
