diff options
| author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2025-03-18 10:55:31 -0300 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2025-03-18 21:58:49 +0100 |
| commit | e143bbe99dd72ec8111c6224e6525d5fc87c5092 (patch) | |
| tree | d906d61543aad5685dd64c9a25d50c5f830dcb25 | |
| parent | 408530b25e361410a1a39d07733baa2ee3c0b937 (diff) | |
+ 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.hallot@libreoffice.org>
Tested-by: Jenkins
| -rw-r--r-- | source/text/scalc/00/00000412.xhp | 2 | ||||
| -rw-r--r-- | source/text/scalc/01/HandleDuplicateRecords.xhp | 6 |
2 files changed, 6 insertions, 2 deletions
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> |