source/text/sbasic/shared/03/sf_calc.xhp | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-)
New commits: commit 60b9c9da98f43ba0048cadac79bb683f82c2c30d Author: Andrea Gelmini <andrea.gelm...@gelma.net> AuthorDate: Wed Jan 25 10:34:42 2023 +0100 Commit: Julien Nabet <serval2...@yahoo.fr> CommitDate: Wed Jan 25 10:42:26 2023 +0000 Fix typos Change-Id: I63a7a69b053b3ddca65a0bd41ac903ce425815a8 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/146128 Tested-by: Jenkins Reviewed-by: Julien Nabet <serval2...@yahoo.fr> diff --git a/source/text/sbasic/shared/03/sf_calc.xhp b/source/text/sbasic/shared/03/sf_calc.xhp index fb0e17a216..9f1e19ee47 100644 --- a/source/text/sbasic/shared/03/sf_calc.xhp +++ b/source/text/sbasic/shared/03/sf_calc.xhp @@ -1706,7 +1706,7 @@ <paragraph role="paragraph" id="par_id331591699082900"><emph>range</emph>: The range from which duplicates will be removed, as a string.</paragraph> <paragraph role="paragraph" id="par_id331591699082848"><emph>columns</emph>: An array containing column numbers indicating which columns will be considered to determine if a row is a duplicate or not. If this argument is left blank, then only the first column is used. Items in this array must be in the interval between 1 and the range width.</paragraph> <paragraph role="paragraph" id="par_id331591699082147"><emph>header</emph>: Specifies whether the first row is a header row (Default = <literal>False</literal>).</paragraph> - <paragraph role="paragraph" id="par_id331591699082231"><emph>casesensitive</emph>: Specifies whether string comparisons are case-senstive (Default = <literal>False</literal>).</paragraph> + <paragraph role="paragraph" id="par_id331591699082231"><emph>casesensitive</emph>: Specifies whether string comparisons are case-sensitive (Default = <literal>False</literal>).</paragraph> <paragraph role="paragraph" id="par_id331591699082446"><emph>mode</emph>: Specifies what to do with duplicate rows. If <literal>mode = "CLEAR"</literal> then duplicates are simply removed from the sheet leaving the cells blank. If <literal>mode = "COMPACT"</literal> then duplicates are removed and empty rows are compacted up (Default = <literal>"COMPACT"</literal>).</paragraph> <embed href="text/sbasic/shared/00000003.xhp#functexample"/> <embed href="text/sbasic/shared/00000003.xhp#In_Basic"/> @@ -1714,7 +1714,7 @@ <paragraph role="bascode" id="bas_id991674511267999">' Removes duplicate rows where values in column A are duplicate</paragraph> <paragraph role="bascode" id="bas_id401674511347995">' Note that all optional arguments use their default value</paragraph> <paragraph role="bascode" localize="false" id="bas_id81591699080330">oDoc.RemoveDuplicates("A1:B10")</paragraph> - <paragraph role="bascode" id="bas_id31674511325842">' Removes duplicate rows conidering that the first row contains headers</paragraph> + <paragraph role="bascode" id="bas_id31674511325842">' Removes duplicate rows considering that the first row contains headers</paragraph> <paragraph role="bascode" id="bas_id11674511430892">' Columns A and B are used to determine if a row is a duplicate</paragraph> <paragraph role="bascode" id="bas_id941674511492390">' Cells containing duplicate values are left blank</paragraph> <paragraph role="bascode" localize="false" id="bas_id601674511460422">oDoc.RemoveDuplicates("A1:D10", columns := Array(1, 2), header := True, mode := "CLEAR")</paragraph>