tdf#124204 Changes in SMALL and LARGE functions

Change-Id: I1d67dfd05419abc67b8039112c3fcd7bb0b15fbe
Reviewed-on: https://gerrit.libreoffice.org/77552
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>

1 files changed, 12 insertions, 14 deletions

diff --git a/source/text/scalc/01/04060183.xhp b/source/text/scalc/01/04060183.xhp
index 24e1893dcf..1232151f61 100644
--- a/source/text/scalc/01/04060183.xhp
+++ b/source/text/scalc/01/04060183.xhp
@@ -34,33 +34,31 @@
 <bookmark xml-lang="en-US" branch="index" id="bm_id3149530"><bookmark_value>LARGE function</bookmark_value>
 </bookmark>
 <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KGROESSTE" id="bm_id3150883" localize="false"/>
-<paragraph role="heading" id="hd_id3149530" xml-lang="en-US" level="2">LARGE</paragraph>
+<h2 id="hd_id3149530">LARGE</h2>
 <paragraph role="paragraph" id="par_id3150518" xml-lang="en-US"><ahelp hid="HID_FUNC_KGROESSTE">Returns the Rank_c-th largest value in a data set.</ahelp></paragraph>
+<embed href="text/scalc/01/ODFF.xhp#odff"/>
 <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
 <paragraph role="code" id="par_id3154372" xml-lang="en-US">LARGE(Data; RankC)</paragraph>
-<paragraph role="paragraph" id="par_id3152986" xml-lang="en-US">
-<emph>Data</emph> is the cell range of data.</paragraph>
-<paragraph role="paragraph" id="par_id3156448" xml-lang="en-US">
-<emph>RankC</emph> is the ranking of the value.</paragraph>
+<paragraph role="paragraph" id="par_id3152986" xml-lang="en-US"><emph>Data</emph> is the cell range of data.</paragraph>
+<paragraph role="paragraph" id="par_id3156448" xml-lang="en-US"><emph>RankC</emph> is the ranking of the value. If RankC is an array, the function becomes an <link href="text/scalc/01/04060107.xhp" name="array function">array function</link>.</paragraph>
 <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph role="paragraph" id="par_id3148702" xml-lang="en-US">
-<item type="input">=LARGE(A1:C50;2)</item> gives the second largest value in A1:C50.</paragraph>
+<paragraph role="paragraph" id="par_id3148702" xml-lang="en-US"><input>=LARGE(A1:C50;2)</input> gives the second largest value in A1:C50.</paragraph>
+<paragraph role="paragraph" id="par_id3248702" xml-lang="en-US"><input>=LARGE(A1:C50;B1:B5)</input> entered as an array function gives an array of the c-th largest value in A1:C50 with ranks defined in B1:B5.</paragraph>
 </section>
 <section id="small">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3154532"><bookmark_value>SMALL function</bookmark_value>
 </bookmark>
 <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KKLEINSTE" id="bm_id3148609" localize="false"/>
-<paragraph role="heading" id="hd_id3154532" xml-lang="en-US" level="2">SMALL</paragraph>
+<h2 id="hd_id3154532">SMALL</h2>
 <paragraph role="paragraph" id="par_id3157981" xml-lang="en-US"><ahelp hid="HID_FUNC_KKLEINSTE">Returns the Rank_c-th smallest value in a data set.</ahelp></paragraph>
+<embed href="text/scalc/01/ODFF.xhp#odff"/>
 <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
 <paragraph role="code" id="par_id3153974" xml-lang="en-US">SMALL(Data; RankC)</paragraph>
-<paragraph role="paragraph" id="par_id3154540" xml-lang="en-US">
-<emph>Data</emph> is the cell range of data.</paragraph>
-<paragraph role="paragraph" id="par_id3155094" xml-lang="en-US">
-<emph>RankC</emph> is the rank of the value.</paragraph>
+<paragraph role="paragraph" id="par_id3154540" xml-lang="en-US"><emph>Data</emph> is the cell range of data.</paragraph>
+<paragraph role="paragraph" id="par_id3155094" xml-lang="en-US"><emph>RankC</emph> is the rank of the value. If RankC is an array, the function becomes an <link href="text/scalc/01/04060107.xhp" name="array function">array function</link>.</paragraph>
 <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph role="paragraph" id="par_id3149897" xml-lang="en-US">
-<item type="input">=SMALL(A1:C50;2)</item> gives the second smallest value in A1:C50.</paragraph>
+<paragraph role="paragraph" id="par_id3149897" xml-lang="en-US"><input>=SMALL(A1:C50;2)</input> gives the second smallest value in A1:C50.</paragraph>
+<paragraph role="paragraph" id="par_id3249897" xml-lang="en-US"><input>=SMALL(A1:C50;B1:B5)</input> entered as an array function gives an array of the c-th smallest value in A1:C50 with ranks defined in B1:B5.</paragraph>
 </section>
 <section id="confidence">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3153559"><bookmark_value>CONFIDENCE function</bookmark_value>