source/text/scalc/01/04060101.xhp | 7 +++---
source/text/scalc/01/func_unique.xhp | 37 +++++++++++++++++++++++++++++++++--
2 files changed, 39 insertions(+), 5 deletions(-)
New commits:
commit 2662257ca9594a0c5fc1371c8e397f562c726f8c
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Thu May 16 17:07:52 2024 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Mon May 20 22:25:55 2024 +0200
tdf#159872 UNIQUE function help page
- Attempt to address issues raised by Regina.
Change-Id: I85892d15a5bf8bb798f733cd4fddc309e5906894
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/167755
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
Tested-by: Jenkins
diff --git a/source/text/scalc/01/04060101.xhp
b/source/text/scalc/01/04060101.xhp
index bd0864fb72..d68e5ec716 100644
--- a/source/text/scalc/01/04060101.xhp
+++ b/source/text/scalc/01/04060101.xhp
@@ -104,8 +104,8 @@
<h3 id="hd_id3150329">Examples of Database Function Use</h3>
<paragraph id="par_id3153713" role="paragraph">The following table
provides an example database table that is utilized to demonstrate how to use
the functions in the Database category. The cell range A1:E10 contains
fictitious information about the guests invited to Joe's birthday party. The
following information is given for each guest - name, school grade, age in
years, distance to school in meters, and weight in kilograms.</paragraph>
-
- <table id="tbl_id3159264">
+<section id="tbl_database_sample">
+ <table id="tbl_711715981358741">
<tablerow>
<tablecell/>
<tablecell>
@@ -339,7 +339,8 @@
<tablecell>
</tablecell>
</tablerow>
- </table>
+ </table>
+ </section>
<paragraph role="paragraph" id="par_id221616245476190">The following
six examples use the database table above, combined with different search
criteria areas.</paragraph>
diff --git a/source/text/scalc/01/func_unique.xhp
b/source/text/scalc/01/func_unique.xhp
index 0d7025e841..8c709cfb44 100644
--- a/source/text/scalc/01/func_unique.xhp
+++ b/source/text/scalc/01/func_unique.xhp
@@ -22,11 +22,44 @@
</bookmark>
<section id="unique">
<h1 id="hd_id901708806478126"><variable id="h1"><link
href="text/scalc/01/func_unique.xhp">UNIQUE</link></variable></h1>
- <paragraph id="par_id771708806478128" role="paragraph">(...)</paragraph>
+ <paragraph id="par_id771708806478128" role="paragraph">Returns the array
of unique values from a range or array of values.</paragraph>
</section>
+
+<note id="par_id711715953325962">The UNIQUE function is always case sensitive,
independent from the setting of <emph>Case sensitive</emph> checkbox in
<switchinline select="sys"><caseinline select="MAC"><menuitem>%PRODUCTNAME -
Preferences</menuitem></caseinline><defaultinline><menuitem>Tools -
Options</menuitem></defaultinline></switchinline> - <link
href="text/shared/optionen/01060500.xhp"><menuitem>%PRODUCTNAME Calc -
Calculate</menuitem></link>.</note>
+
<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
-<paragraph role="code" id="par_id211708281649651">UNIQUE(...)</paragraph>
+<paragraph role="code" id="par_id211708281649651">UNIQUE(Array, [By col],
[Uniqueness])</paragraph>
+<paragraph role="paragraph" id="par_id381715698113514"><emph>Array</emph>: the
range or array from which to return unique values.</paragraph>
+<paragraph role="paragraph" id="par_id311715698119400"><emph>By col</emph>:
(optional) a logical value that indicates how to compare data: TRUE - compares
data horizontally for a match of all cells in each column, across all columns.
FALSE or omitted (default) - compares data vertically, for a match of all cells
of each row, across all rows.</paragraph>
+
+<paragraph role="paragraph"
id="par_id531715698124705"><emph>Uniqueness</emph>: (optional) A logical value
that defines which values are considered unique. TRUE returns values that occur
only once. The default is FALSE or omitted, which returns all distinct values
in the range or array.</paragraph>
+<note id="par_id501715889339407">The UNIQUE function must be entered as an
<link href="text/scalc/01/04060107.xhp#creating_array_formulas">array
formula</link>.</note>
<embed href="text/scalc/01/ful_func.xhp#func_head_example"/>
+<paragraph role="paragraph" id="par_id471715980557106">Given the data table
below, the examples returns unique occurrences of grades and age.</paragraph>
+<embed href="text/scalc/01/04060101.xhp#tbl_database_sample"/>
+<h3 id="hd_id931715984553129">Example 1</h3>
+<paragraph role="paragraph"
id="par_id641715980827372"><input>{=UNIQUE(B1:C10,FALSE(),FALSE())}</input>
returns the array below. The grades and ages of the rows with name Andy and
Harry are returned only once. The same for rows with name Eva and
Irene.</paragraph>
+<table id="sample1">
+ <tablerow><tablecell><paragraph role="paragraph"
id="par_id641715983343641"><emph>Grade</emph></paragraph></tablecell><tablecell><paragraph
role="paragraph"
id="par_id511715983350731"><emph>Age</emph></paragraph></tablecell></tablerow>
+ <tablerow><tablecell><paragraph role="paragraph"
id="par_id751715983361251"
localize="false">3</paragraph></tablecell><tablecell><paragraph
role="paragraph" id="par_id51715983367115"
localize="false">9</paragraph></tablecell></tablerow>
+ <tablerow><tablecell><paragraph role="paragraph"
id="par_id791715983372155"
localize="false">4</paragraph></tablecell><tablecell><paragraph
role="paragraph" id="par_id301715983377588"
localize="false">10</paragraph></tablecell></tablerow>
+ <tablerow><tablecell><paragraph role="paragraph"
id="par_id521715983383178"
localize="false">3</paragraph></tablecell><tablecell><paragraph
role="paragraph" id="par_id881715983388786"
localize="false">10</paragraph></tablecell></tablerow>
+ <tablerow><tablecell><paragraph role="paragraph"
id="par_id1001715983394307"
localize="false">5</paragraph></tablecell><tablecell><paragraph
role="paragraph" id="par_id451715983399066"
localize="false">11</paragraph></tablecell></tablerow>
+ <tablerow><tablecell><paragraph role="paragraph"
id="par_id451715983403906"
localize="false">2</paragraph></tablecell><tablecell><paragraph
role="paragraph" id="par_id191715983413378"
localize="false">8</paragraph></tablecell></tablerow>
+ <tablerow><tablecell><paragraph role="paragraph"
id="par_id641715983418937"
localize="false">2</paragraph></tablecell><tablecell><paragraph
role="paragraph" id="par_id311715983438778"
localize="false">7</paragraph></tablecell></tablerow>
+ <tablerow><tablecell><paragraph role="paragraph"
id="par_id391715983424898"
localize="false">1</paragraph></tablecell><tablecell><paragraph
role="paragraph" id="par_id951715983443729"
localize="false">7</paragraph></tablecell></tablerow>
+</table>
+<h3 id="hd_id981715984567844">Example 2</h3>
+<paragraph role="paragraph"
id="par_id801715981230387"><input>{=UNIQUE(B1:C10,FALSE(),TRUE())}</input>,
with <emph>Uniqueness</emph> as TRUE. Returns the array below with the rows of
Andy, Harry, Eva and Irene omitted because their combined grades and ages are
not unique.</paragraph>
+<table id="sample2">
+ <tablerow><tablecell><paragraph role="paragraph"
id="par_id501715983764524"><emph>Grade</emph></paragraph></tablecell><tablecell><paragraph
role="paragraph"
id="par_id31715983773608"><emph>Age</emph></paragraph></tablecell></tablerow>
+ <tablerow><tablecell><paragraph role="paragraph"
id="par_id611715983782594"
localize="false">4</paragraph></tablecell><tablecell><paragraph
role="paragraph" id="par_id671715983787993"
localize="false">10</paragraph></tablecell></tablerow>
+ <tablerow><tablecell><paragraph role="paragraph" id="par_id11715983792601"
localize="false">3</paragraph></tablecell><tablecell><paragraph
role="paragraph" id="par_id441715983798113"
localize="false">10</paragraph></tablecell></tablerow>
+ <tablerow><tablecell><paragraph role="paragraph"
id="par_id311715983802580"
localize="false">5</paragraph></tablecell><tablecell><paragraph
role="paragraph" id="par_id611715983807760"
localize="false">11</paragraph></tablecell></tablerow>
+ <tablerow><tablecell><paragraph role="paragraph"
id="par_id591715983811913"
localize="false">2</paragraph></tablecell><tablecell><paragraph
role="paragraph" id="par_id971715983820239"
localize="false">7</paragraph></tablecell></tablerow>
+ <tablerow><tablecell><paragraph role="paragraph"
id="par_id551715983827423"
localize="false">1</paragraph></tablecell><tablecell><paragraph
role="paragraph" id="par_id171715983833462"
localize="false">7</paragraph></tablecell></tablerow>
+</table>
+
<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
<embed href="text/scalc/00/avail_release.xhp#24.8"/>
<embed href="text/scalc/01/common_func.xhp#notODFF"/>
