summaryrefslogtreecommitdiff
path: root/source/text/scalc/01/HandleDuplicateRecords.xhp
diff options
context:
space:
mode:
Diffstat (limited to 'source/text/scalc/01/HandleDuplicateRecords.xhp')
-rw-r--r--source/text/scalc/01/HandleDuplicateRecords.xhp6
1 files changed, 4 insertions, 2 deletions
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>