helpers/xmlhelp.dtd | 2
source/text/scalc/01/04060106.xhp | 2
source/text/scalc/01/04060185.xhp | 8 +-
source/text/scalc/02/06030000.xhp | 132 +++++++++++++++++++++++++++++++++-----
4 files changed, 122 insertions(+), 22 deletions(-)
New commits:
commit f69f88fc6e9b18e54e664e507df5f9cb34471e4e
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Tue Sep 23 21:42:32 2025 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Wed Sep 24 10:36:28 2025 +0200
More on Select Function in formula bar
Change-Id: Iaae5db99a81979d28cdec2d23631bae7b4e81a69
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/191417
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
Tested-by: Jenkins
diff --git a/helpers/xmlhelp.dtd b/helpers/xmlhelp.dtd
index 0b2a7b9753..3416c90f6e 100644
--- a/helpers/xmlhelp.dtd
+++ b/helpers/xmlhelp.dtd
@@ -210,7 +210,7 @@ Version Nov 2018
%commonAttrs;
>
-<!ELEMENT section (section | %hn; | paragraph | table | list | comment |
bookmark | embed | switch | sort | %codeContent; | %noteContent;)*>
+<!ELEMENT section (section | %hn; | paragraph | description | table | list |
comment | bookmark | embed | switch | sort | %codeContent; | %noteContent;)*>
<!ATTLIST section
id CDATA #REQUIRED
>
diff --git a/source/text/scalc/01/04060106.xhp
b/source/text/scalc/01/04060106.xhp
index 78751f8bac..0b7010501a 100644
--- a/source/text/scalc/01/04060106.xhp
+++ b/source/text/scalc/01/04060106.xhp
@@ -763,7 +763,7 @@
<comment>mw added two entries</comment>
<bookmark branch="hid/SC_HID_FUNC_PRODUKT" id="bm_id3144397" localize="false"/>
-<h2 id="hd_id3144386">PRODUCT</h2>
+<h2 id="hd_id3144386"><variable id="product_head"><link
href="text/scalc/01/04060106.xhp#product">PRODUCT</link></variable></h2>
<paragraph id="par_id3144414" role="paragraph"><ahelp
hid="HID_FUNC_PRODUKT">Multiplies all the numbers given as arguments and
returns the product.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
diff --git a/source/text/scalc/01/04060185.xhp
b/source/text/scalc/01/04060185.xhp
index f1c1c30c88..64666e71b6 100644
--- a/source/text/scalc/01/04060185.xhp
+++ b/source/text/scalc/01/04060185.xhp
@@ -165,7 +165,7 @@
<bookmark_value>standard deviations in statistics;based on a
sample</bookmark_value>
</bookmark>
<bookmark branch="hid/SC_HID_FUNC_STABW" id="bm_id3153121" localize="false"/>
-<h2 id="hd_id3149143">STDEV</h2>
+<h2 id="hd_id3149143"><variable id="stdev_head"><link
href="text/scalc/01/04060185.xhp#stdev">STDEV</link></variable></h2>
<paragraph id="par_id3146888" role="paragraph"><ahelp
hid="HID_FUNC_STABW">Estimates the standard deviation based on a
sample.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id3149946" role="code">STDEV(<embedvar
href="text/scalc/01/ful_func.xhp#argument255_1" markup="keep"/>)</paragraph>
@@ -195,7 +195,7 @@
<bookmark_value>standard deviations in statistics;based on a
population</bookmark_value>
</bookmark>
<bookmark branch="hid/SC_HID_FUNC_STABWN" id="bm_id3146139" localize="false"/>
-<h2 id="hd_id3149734">STDEVP</h2>
+<h2 id="hd_id3149734"><variable id="stdevp_head"><link
href="text/scalc/01/04060185.xhp#stdevp">STDEVP</link></variable></h2>
<paragraph id="par_id3149187" role="paragraph"><ahelp
hid="HID_FUNC_STABWN">Calculates the standard deviation based on the entire
population.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -581,7 +581,7 @@
<bookmark_value>variances</bookmark_value>
</bookmark>
<bookmark branch="hid/SC_HID_FUNC_VARIANZ" id="bm_id3154898" localize="false"/>
-<h2 id="hd_id3153828">VAR</h2>
+<h2 id="hd_id3153828"><variable id="var"><link
href="text/scalc/01/04060185.xhp#var">VAR</link></variable></h2>
<paragraph id="par_id3159165" role="paragraph"><ahelp
hid="HID_FUNC_VARIANZ">Estimates the variance based on a
sample.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -632,7 +632,7 @@
<bookmark branch="index" id="bm_id3166441"><bookmark_value>VARP
function</bookmark_value>
</bookmark>
<bookmark branch="hid/SC_HID_FUNC_VARIANZEN" id="bm_id3152359"
localize="false"/>
-<h2 id="hd_id3166441">VARP</h2>
+<h2 id="hd_id3166441"><variable id="varp"><link
href="text/scalc/01/04060185.xhp#varp">VARP</link></variable></h2>
<paragraph id="par_id3159199" role="paragraph"><ahelp
hid="HID_FUNC_VARIANZEN">Calculates a variance based on the entire
population.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id3147282" role="code">VARP(<embedvar
href="text/scalc/01/ful_func.xhp#argument255_1" markup="keep"/>)</paragraph>
diff --git a/source/text/scalc/02/06030000.xhp
b/source/text/scalc/02/06030000.xhp
index 1f5f79fc41..81aacccc6f 100644
--- a/source/text/scalc/02/06030000.xhp
+++ b/source/text/scalc/02/06030000.xhp
@@ -27,38 +27,139 @@
</topic>
</meta>
<body>
- <section id="sum">
-<bookmark branch="index" id="bm_id3157909"><bookmark_value>functions;sum
function icon</bookmark_value>
- <bookmark_value>formula bar;sum function</bookmark_value>
- <bookmark_value>sum icon</bookmark_value>
- <bookmark_value>AutoSum button, see sum icon</bookmark_value>
+<bookmark branch="index" id="bm_id3157909">
+<bookmark_value>functions;sum function icon</bookmark_value>
+<bookmark_value>formula bar;sum function</bookmark_value>
+<bookmark_value>sum icon</bookmark_value>
+<bookmark_value>AutoSum button, see sum icon</bookmark_value>
</bookmark>
<bookmark branch="hid/SC_HID_INSWIN_SUMME" id="bm_id3151384"
localize="false"/><comment>MW inserted a cross-reference</comment>
+<section id="sum">
<h1 id="hd_id3157909"><link href="text/scalc/02/06030000.xhp">Select
Function</link></h1>
- <paragraph id="par_id3150543" role="paragraph"><ahelp
hid="HID_INSWIN_SUMME">Insert a function of a cell range into the current cell.
The function can be Sum, Average, Minimum, Maximum and Count. Click in a cell,
click this icon, select the function in the drop down list and optionally
adjust the cell range. Or select some cells into which the function value will
be inserted, then click the icon. The function result is added at the bottom of
the range.</ahelp></paragraph>
- </section>
+<description id="par_id3150543"><ahelp hid="HID_INSWIN_SUMME">Inserts a
function of a cell range into the current cell. Click in a cell, click this
icon, select the function in the drop down list and optionally adjust the cell
range.</ahelp></description>
+</section>
+<paragraph role="paragraph" id="par_id181758667998342">Alternatively, select
some cells into which the function value will be inserted, then click the icon.
The function result is added at the bottom of the range.</paragraph>
+<section id="howtoget">
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
<section id="sysum">
<table id="tbl_id3150868">
<tablerow>
<tablecell>
- <paragraph id="par_id3153770" role="paragraph">
-<image id="img_id3147434" src="cmd/sc_autosum.svg" width="1cm"
height="1cm"><alt id="alt_id3147434">Icon Select Function</alt>
- </image></paragraph>
+ <paragraph id="par_id3153770" role="paragraph"><image
id="img_id3147434" src="cmd/sc_autosum.svg" width="1cm" height="1cm"><alt
id="alt_id3147434">Icon Select Function</alt></image></paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id3152577" role="paragraph">Select
Function</paragraph>
</tablecell>
</tablerow>
</table>
-</section>
+ </section>
+</section>
+<paragraph role="paragraph" id="par_id1001758669716908">Functions for the
selected range:</paragraph>
+<table id="tab_id121758669298075">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id841758669298078"
role="tablehead">Function</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id321758669298080" role="tablehead">Inserted
function</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id261758669298085"
role="tablecontent">Sum</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id581758669298087" localize="false"
role="tablecontent">=<embedvar href="text/scalc/01/func_sum.xhp#sum_head"
markup="ignore"/>(...)</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id451758669355389"
role="tablecontent">Average</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id271758669355391" localize="false"
role="tablecontent">=<embedvar href="text/scalc/01/04060184.xhp#average_head"
markup="ignore"/>(...)</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id451758669401513"
role="tablecontent">Min</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id861758669401516" localize="false"
role="tablecontent">=<embedvar href="text/scalc/01/04060184.xhp#min_head"
markup="ignore"/>(...)</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id61758669437433"
role="tablecontent">Max</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id531758669437436" localize="false"
role="tablecontent">=<embedvar href="text/scalc/01/04060184.xhp#max_head"
markup="ignore"/>(...)</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id81758669464656"
role="tablecontent">Count</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id491758669464659" localize="false"
role="tablecontent">=<embedvar href="text/scalc/01/04060181.xhp#count_head"
markup="ignore"/>(...)</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id211758669496873"
role="tablecontent">CountA</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id721758669496876" localize="false"
role="tablecontent">=<embedvar href="text/scalc/01/04060181.xhp#counta_head"
markup="ignore"/>(...)</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id761758669529361"
role="tablecontent">Product</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id261758669529364" localize="false"
role="tablecontent">=<embedvar href="text/scalc/01/04060106.xhp#product_head"
markup="ignore"/>(...)</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id981758669561760"
role="tablecontent">Stdev</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id761758669561762" localize="false"
role="tablecontent">=<embedvar href="text/scalc/01/04060185.xhp#stdev_head"
markup="ignore"/>(...)</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id891758669614536"
role="tablecontent">StdevP</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id31758669614538" localize="false"
role="tablecontent">=<embedvar href="text/scalc/01/04060185.xhp#stdevp_head"
markup="ignore"/>(...)</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id351758669648318"
role="tablecontent">Var</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id461758669648321" localize="false"
role="tablecontent">=<embedvar href="text/scalc/01/04060185.xhp#var"
markup="ignore"/>(...)</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id321758669671495"
role="tablecontent">VarP</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id631758669671497" localize="false"
role="tablecontent">=<embedvar href="text/scalc/01/04060185.xhp#varp"
markup="ignore"/>(...)</paragraph>
+ </tablecell>
+ </tablerow>
+</table>
<h2 id="hd_id161592658402954">Select Function applied with no selected
range</h2>
<paragraph id="par_id3156444" role="paragraph">$[officename] automatically
suggests a cell range, provided that the spreadsheet contains data. If the cell
range already contains a function, you can combine it with the new one to yield
the function applied to the range data. If the range contains filters, the
Subtotal function is inserted instead of the selected function.</paragraph>
- <paragraph id="par_id3153189" role="paragraph">Click the
<emph>Accept</emph> icon to use the formula displayed in the input line or
<emph>Cancel</emph>.</paragraph>
+<paragraph id="par_id3153189" role="paragraph">Click the <emph>Accept</emph>
icon to use the formula displayed in the input line or
<emph>Cancel</emph>.</paragraph>
<table id="tab_id891592663499228">
<tablerow>
<tablecell>
- <paragraph role="image" id="par_id231592663499228">
-<image src="cmd/sc_ok.svg" id="img_id521592663499228" width="1cm"
height="1cm"><alt id="alt_id171592663499228">Accept Icon</alt></image>
+ <paragraph role="image" id="par_id231592663499228"><image
src="cmd/sc_ok.svg" id="img_id521592663499228" width="1cm" height="1cm"><alt
id="alt_id171592663499228">Accept Icon</alt></image>
</paragraph>
</tablecell>
<tablecell>
@@ -69,8 +170,7 @@
<table id="tab_id591592663828848">
<tablerow>
<tablecell>
- <paragraph role="image" id="par_id311592663828848">
-<image src="cmd/sc_cancel.svg" id="img_id641592663828848" width="1cm"
height="1cm"><alt id="alt_id111592663828848">Icon Cancel</alt></image>
+ <paragraph role="image" id="par_id311592663828848"><image
src="cmd/sc_cancel.svg" id="img_id641592663828848" width="1cm"
height="1cm"><alt id="alt_id111592663828848">Icon Cancel</alt></image>
</paragraph>
</tablecell>
<tablecell>
