source/text/scalc/00/00000412.xhp | 2 ++
source/text/scalc/01/HandleDuplicateRecords.xhp | 6 ++++--
2 files changed, 6 insertions(+), 2 deletions(-)
New commits:
commit e143bbe99dd72ec8111c6224e6525d5fc87c5092
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Tue Mar 18 10:55:31 2025 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Tue Mar 18 21:58:49 2025 +0100
Add precision on Duplicates command fo Calc
+ Update How to get
+ Inform on effects of removing cells.
Change-Id: I69e0bfdec4139bdb6c1f151a263295e814c1432d
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/183086
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
Tested-by: Jenkins
diff --git a/source/text/scalc/00/00000412.xhp
b/source/text/scalc/00/00000412.xhp
index e98b90efca..cd73ad2b04 100644
--- a/source/text/scalc/00/00000412.xhp
+++ b/source/text/scalc/00/00000412.xhp
@@ -106,6 +106,8 @@
<section id="handleduplicaterecords">
<embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
<paragraph role="paragraph" id="par_id291725983812933"><variable
id="duplicaterecordsdlg">Choose <emph>Data -
Duplicates...</emph>.</variable></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id771742304991104">Choose
<emph>Data - Duplicates</emph>.</paragraph>
</section>
<section id="datasortascending1">
diff --git a/source/text/scalc/01/HandleDuplicateRecords.xhp
b/source/text/scalc/01/HandleDuplicateRecords.xhp
index f53aa65ef0..8a6d747369 100644
--- a/source/text/scalc/01/HandleDuplicateRecords.xhp
+++ b/source/text/scalc/01/HandleDuplicateRecords.xhp
@@ -20,8 +20,9 @@
<bookmark branch="hid/.uno:HandleDuplicateRecords" id="bm_id471726085794815"
localize="false"/>
<bookmark branch="hid/modules/scalc/ui/duplicaterecordsdlg/@@nowidget@@"
id="bm_id651726085647181" localize="false"/>
<bookmark branch="index" id="bm_id461725984310739">
- <bookmark_value>duplicate;remove</bookmark_value>
- <bookmark_value>duplicate;select</bookmark_value>
+<bookmark_value>duplicates;remove</bookmark_value>
+<bookmark_value>remove duplicated records</bookmark_value>
+<bookmark_value>duplicates;select</bookmark_value>
</bookmark>
<section id="handleduplicaterecords">
@@ -39,6 +40,7 @@
<paragraph role="paragraph" id="par_id61725963172527"><emph>Compare
by:</emph> specifies which fields to compare (and which to ignore) when
determining whether two rows or columns are duplicates or not.</paragraph>
<paragraph role="paragraph"
id="par_id741725979527610"><emph>Action:</emph> specifies whether to select or
remove the duplicate rows or columns.</paragraph>
</section>
+ <note id="par_id781742303337461">When duplicate records are removed, the
entire rows or columns in the range containing those duplicates are deleted.
This action causes the surrounding cells to shift and fill the empty spaces
left behind. If the comparison is conducted along the rows, the cells below the
removed duplicates will shift upward. Conversely, if the comparison is done
along the columns, the cells to the right of the deleted duplicates will move
leftward.</note>
</body>
</helpdocument>
