core.git: helpcontent2

[Olivier Hallot (via logerrit)]

 helpcontent2 |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit e9bd8614e28421d4907b06ed2e84bda9ba08e12f
Author: Olivier Hallot 
AuthorDate: Tue Jul 23 07:31:51 2024 -0300
Commit: Gerrit Code Review 
CommitDate: Tue Jul 23 12:31:51 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'master'
  to 44f0c2b1cd054a94ff7d4b3b563bc4a8674314e1
  - Fix term in TOC help page

The term "Outline" was changed to "Headings"

Change-Id: I9185775e323088a2576c76f10a8ba1eae367e6d1
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/170886
Reviewed-by: Olivier Hallot 
Tested-by: Jenkins

diff --git a/helpcontent2 b/helpcontent2
index 805241fc011c..44f0c2b1cd05 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit 805241fc011cf160c349548bcb532f487aa18e38
+Subproject commit 44f0c2b1cd054a94ff7d4b3b563bc4a8674314e1

help.git: source/text

[Olivier Hallot (via logerrit)]

 source/text/swriter/01/04120211.xhp |4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

New commits:
commit 44f0c2b1cd054a94ff7d4b3b563bc4a8674314e1
Author: Olivier Hallot 
AuthorDate: Mon Jul 22 20:28:59 2024 -0300
Commit: Olivier Hallot 
CommitDate: Tue Jul 23 12:31:50 2024 +0200

Fix term in TOC help page

The term "Outline" was changed to "Headings"

Change-Id: I9185775e323088a2576c76f10a8ba1eae367e6d1
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/170886
Reviewed-by: Olivier Hallot 
Tested-by: Jenkins

diff --git a/source/text/swriter/01/04120211.xhp 
b/source/text/swriter/01/04120211.xhp
index aebb2d5129..774a10a6e7 100644
--- a/source/text/swriter/01/04120211.xhp
+++ b/source/text/swriter/01/04120211.xhp
@@ -58,8 +58,8 @@
   Create from
   Use this area to specify 
which information to include in an index.
 
-Outline
-  Creates the index using 
outline levels. Any paragraph with an outline level less than or equal to the 
outline level specified in Include up to level is included 
in the index.
+Headings
+  Creates the index using 
headings levels. Any paragraph with a heading level less than or equal to the 
heading level specified in Include up to level is included 
in the index.
Paragraphs 
formatted with one of the predefined paragraph styles (“Heading 1–10”) have an 
outline level that corresponds to the number in the paragraph style. You can 
also assign outline levels to paragraphs in the Outline  List tab page of the 
Format - Paragraph dialog.
   
 

help.git: source/text

[Olivier Hallot (via logerrit)]

 source/text/scalc/01/04060110.xhp  |   12 
 source/text/shared/01/0211.xhp |5 +
 2 files changed, 17 insertions(+)

New commits:
commit 805241fc011cf160c349548bcb532f487aa18e38
Author: Olivier Hallot 
AuthorDate: Sun Jul 21 11:48:54 2024 -0300
Commit: Adolfo Jayme Barrientos 
CommitDate: Sun Jul 21 22:59:01 2024 +0200

tdf#144986 Blank cells vs. empty string.

Change-Id: If9c718e476625a137881805757f1011938ac9986
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/170816
Tested-by: Jenkins
Reviewed-by: Adolfo Jayme Barrientos 

diff --git a/source/text/scalc/01/04060110.xhp 
b/source/text/scalc/01/04060110.xhp
index 20bff1be7c..193380683d 100644
--- a/source/text/scalc/01/04060110.xhp
+++ b/source/text/scalc/01/04060110.xhp
@@ -67,6 +67,18 @@
 Be aware that Calc's 
AutoCorrect function may modify double quotation marks. AutoCorrect should not 
change the double quotation marks within formula cells but may change those 
used in non-formula cells containing text. For example, if you copy a string 
that is surrounded by some other form of typographical double quotation marks, 
such as the left double quotation mark (U+201C) and the right double quotation 
mark (U+201D), and then paste into a formula cell, an error may result. Open 
the Double Quotes area of the Tools - AutoCorrect 
Options - Localized Options dialog to set the characters used to 
automatically correct the start and end typographical double quotation marks. 
Uncheck the Replace toggle button to disable the 
feature.
 
 
+Empty string and blank cells
+Cells with the empty string ("") are not equivalent to blank 
cells. When searching or calculating with text, the empty string "" is the text 
with length zero.
+For example, when the 
formula in A1 returns the empty string "", the following applies:
+=ISBLANK(A1) returns FALSE. The cell 
is not blank.
+=ISFORMULA(A1) returns TRUE. The cell 
is a formula.
+=ISLOGICAL(A1) returns FALSE. Not a 
logical value.
+
+=ISNONTEXT(A1) returns FALSE. The 
cell has the empty string.
+=ISNUMBER(A1) returns FALSE. Not a 
number.
+=ISTEXT(A1) returns TRUE. The cell 
has the empty string, calculated by a formula.
+=LEN(A1) 
returns 0. The length of the empty string is 0.
+
 
 
 
diff --git a/source/text/shared/01/0211.xhp 
b/source/text/shared/01/0211.xhp
index dc184e775e..48c70d5407 100644
--- a/source/text/shared/01/0211.xhp
+++ b/source/text/shared/01/0211.xhp
@@ -40,6 +40,11 @@
 mw added "replacing;" and "tab stops;"
 List of Regular 
Expressions
 For a full list of supported metacharacters and 
syntax, see https://unicode-org.github.io/icu/userguide/strings/regexp.html#regular-expression-metacharacters;>ICU
 Regular Expressions documentation
+
+  
+
+  
+
 
   
 

core.git: helpcontent2

[Olivier Hallot (via logerrit)]

 helpcontent2 |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit ba0e0093b0ed2816a18e54eef0a92220d7b04a4d
Author: Olivier Hallot 
AuthorDate: Sun Jul 21 17:59:01 2024 -0300
Commit: Gerrit Code Review 
CommitDate: Sun Jul 21 22:59:01 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'master'
  to 805241fc011cf160c349548bcb532f487aa18e38
  - tdf#144986 Blank cells vs. empty string.

Change-Id: If9c718e476625a137881805757f1011938ac9986
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/170816
Tested-by: Jenkins
Reviewed-by: Adolfo Jayme Barrientos 

diff --git a/helpcontent2 b/helpcontent2
index 401844aa0d05..805241fc011c 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit 401844aa0d051bad2cb8861a185b9a7c0f88cf48
+Subproject commit 805241fc011cf160c349548bcb532f487aa18e38

core.git: helpcontent2

[Olivier Hallot (via logerrit)]

 helpcontent2 |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit 272f776b322cfd017506a6b67638ae7d2b83c014
Author: Olivier Hallot 
AuthorDate: Mon Jul 15 12:08:12 2024 -0300
Commit: Gerrit Code Review 
CommitDate: Mon Jul 15 17:08:12 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'master'
  to c6956d32c0cfa26e219bd2e32f66d3fe7796ad76
  - tdf#162025 Fix param separator of several functions

Change-Id: Ib4622836fbdfa5084edf38cd9fb13db815382c6d
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/170494
Reviewed-by: Olivier Hallot 
Tested-by: Jenkins

diff --git a/helpcontent2 b/helpcontent2
index 6dccce115b41..c6956d32c0cf 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit 6dccce115b41c89de6b25b6b4fbddd0a34434115
+Subproject commit c6956d32c0cfa26e219bd2e32f66d3fe7796ad76

help.git: source/text

[Olivier Hallot (via logerrit)]

 source/text/scalc/01/ful_func.xhp  |   17 ++---
 source/text/scalc/01/func_sequence.xhp |4 ++--
 source/text/scalc/01/func_sort.xhp |4 ++--
 source/text/scalc/01/func_sortby.xhp   |6 +++---
 source/text/scalc/01/func_unique.xhp   |6 +++---
 source/text/scalc/01/func_xmatch.xhp   |4 ++--
 6 files changed, 22 insertions(+), 19 deletions(-)

New commits:
commit c6956d32c0cfa26e219bd2e32f66d3fe7796ad76
Author: Olivier Hallot 
AuthorDate: Mon Jul 15 08:11:49 2024 -0300
Commit: Olivier Hallot 
CommitDate: Mon Jul 15 17:08:11 2024 +0200

tdf#162025 Fix param separator of several functions

Change-Id: Ib4622836fbdfa5084edf38cd9fb13db815382c6d
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/170494
Reviewed-by: Olivier Hallot 
Tested-by: Jenkins

diff --git a/source/text/scalc/01/ful_func.xhp 
b/source/text/scalc/01/ful_func.xhp
index 1681a65bc6..1a6ccda766 100644
--- a/source/text/scalc/01/ful_func.xhp
+++ b/source/text/scalc/01/ful_func.xhp
@@ -64,34 +64,37 @@
 255 arguments
 String 1 [; String 2 [; …  [; String 
255]]]
 
-String 1, 
String 2, … , String 255 are strings, references to cells or to cell 
ranges of strings.
+String 1; 
String 2; … ; String 255 are strings, references to cells or to cell 
ranges of strings.
 
 Integer 1 [; Integer 2 [; … [; Integer 
255]]]
 
-Integer 
1, Integer 2, … , Integer 255 are integers, references to cells or to 
cell ranges of integers.
+Integer 
1; Integer 2; … ; Integer 255 are integers, references to cells or to 
cell ranges of integers.
 
 Number 1 [; Number 2 [; … [; Number 
254]]]
 
-Number 1, 
Number 2, … , Number 254 are numbers, references to cells or to cell 
ranges of numbers.
+Number 1; 
Number 2; … ; Number 254 are numbers, references to cells or to cell 
ranges of numbers.
 
 Number 1 [; Number 2 [; … [; Number 
255]]]
 
-Number 1, 
Number 2, … , Number 255 are numbers, references to cells or to cell 
ranges of numbers.
+Number 1; 
Number 2; … ; Number 255 are numbers, references to cells or to cell 
ranges of numbers.
 
 Logical 1 [; Logical 2 [; … [; Logical 
255]]]
 
-Logical 
1, Logical 2,  … , Logical 255 are boolean values, references to cells 
or to cell ranges of logical values.
+Logical 
1; Logical 2;  … ; Logical 255 are boolean values, references to cells 
or to cell ranges of logical values.
 
 Complex 1 [; Complex 2 [; … [; Complex 
255]]]
 
-Complex 
1, Complex 2, … ,Complex 255 are complex numbers, references to cells or 
to cell ranges of complex numbers. Complex numbers are entered in the form 
"x+yi" or "x+yj". 
+Complex 
1; Complex 2; … ; Complex 255 are complex numbers, references to cells 
or to cell ranges of complex numbers. Complex numbers are entered in the form 
"x+yi" or "x+yj". 
 
 Reference 1 [; Reference 2 [; … [; Reference 
255]]]
 
-Reference 
1, Reference 2, … ,Reference 255 are references to cells.
+Reference 
1; Reference 2; … ; Reference 255 are references to cells.
 
 
 This function 
is always recalculated whenever a recalculation occurs.
 
+
+The function is always case 
insensitive, independent from the setting of Case sensitive 
checkbox in %PRODUCTNAME - 
PreferencesTools - 
Options - %PRODUCTNAME Calc - 
Calculate. You can however, use the mode modifier 
(?-i) in regular 
expressions to force search for a case-sensitive match.
+
 
 
diff --git a/source/text/scalc/01/func_sequence.xhp 
b/source/text/scalc/01/func_sequence.xhp
index d4a91e3751..00537e7516 100644
--- a/source/text/scalc/01/func_sequence.xhp
+++ b/source/text/scalc/01/func_sequence.xhp
@@ -25,7 +25,7 @@
 Generate a list of 
sequential numbers in an array.
 
 
-SEQUENCE(Rows, Columns, 
[Start], [Step])
+SEQUENCE(Rows; Columns [; 
Start [; Step ] ])
 Rows: a 
positive integer. The number of rows to return.
 Columns: a 
positive integer. The number of columns to return.
 Start: 
optional. The initial value of the sequence. If omitted, default is 
1.
@@ -34,7 +34,7 @@
 If Rows or 
Columns are references to the content of other cells, the array 
dimensions do not change when the referenced content changes. The array formula 
must be deleted and re-entered.
 The array is filled from 
the first row to the right up to the value of Columns, and then 
down to the number of rows.
 
-{=SEQUENCE(3,3,10,11)} returns the 
3-by-3 array below with an upper-left value of 10 and filling the array to the 
right and then downward in steps of 11.
+{=SEQUENCE(3; 3; 
10; 11)} returns the 3-by-3 array below with an upper-left value of 10 
and filling the array to the right and then downward in steps of 11.
 
 
 
diff --git a/source/text/scalc/01/func_sort.xhp 
b/source/text/scalc/01/func_sort.xhp
index a771ccbfa2..807860d1aa 100644
--- 

core.git: Branch 'libreoffice-24-8' - helpcontent2

[Olivier Hallot (via logerrit)]

 helpcontent2 |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit 70e64cd7a97a64094f20943e33e797bc6e0bb05c
Author: Olivier Hallot 
AuthorDate: Wed Jul 10 12:55:55 2024 -0300
Commit: Gerrit Code Review 
CommitDate: Wed Jul 10 17:55:55 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'libreoffice-24-8'
  to 3e923355a8e31b6073f140ecc1b138a99236a294
  - tdf#159596 match XLOOKUP Help terms to UI terms

Change-Id: I5c2c7739ae6e6a7413bd99a72fa448981c560b50
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/170312
Reviewed-by: Olivier Hallot 
Tested-by: Jenkins
(cherry picked from commit 1a7045ca49e06f1e84bee74cdac6d8d6a399ddd8)
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/170295

diff --git a/helpcontent2 b/helpcontent2
index 2f68941ab305..3e923355a8e3 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit 2f68941ab30515f5ae7e1bbaa2a8e119714f7489
+Subproject commit 3e923355a8e31b6073f140ecc1b138a99236a294

help.git: Branch 'libreoffice-24-8' - source/text

[Olivier Hallot (via logerrit)]

 source/text/scalc/01/func_xlookup.xhp |   34 +-
 1 file changed, 17 insertions(+), 17 deletions(-)

New commits:
commit 3e923355a8e31b6073f140ecc1b138a99236a294
Author: Olivier Hallot 
AuthorDate: Wed Jul 10 10:28:31 2024 -0300
Commit: Olivier Hallot 
CommitDate: Wed Jul 10 17:55:55 2024 +0200

tdf#159596 match XLOOKUP Help terms to UI terms

Change-Id: I5c2c7739ae6e6a7413bd99a72fa448981c560b50
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/170312
Reviewed-by: Olivier Hallot 
Tested-by: Jenkins
(cherry picked from commit 1a7045ca49e06f1e84bee74cdac6d8d6a399ddd8)
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/170295

diff --git a/source/text/scalc/01/func_xlookup.xhp 
b/source/text/scalc/01/func_xlookup.xhp
index 9c06c3e61d..ee5f5c3f63 100644
--- a/source/text/scalc/01/func_xlookup.xhp
+++ b/source/text/scalc/01/func_xlookup.xhp
@@ -28,28 +28,28 @@
 XLOOKUP function is a 
modern and flexible replacement for older functions like VLOOKUP, HLOOKUP, and LOOKUP. XLOOKUP supports 
approximate and exact matching, wildcards (* ?) or regular expressions for 
partial matches, and lookups in vertical or horizontal ranges. XLOOKUP can 
perform a reverse search and offers a fast binary search option when working 
with large datasets.
 
 
-XLOOKUP( [Lookup] ; Array ; 
Return [ ; [ NotFound ] [ ; [MatchType] [ ; SearchMode ] ] ] )
+XLOOKUP( [Search criterion] 
; Search Array ; Result Array [ ; [ Result if not found ] [ ; [Match Mode] [ ; 
Search Mode ] ] ] )
 
-Lookup: 
(optional) The value of any type to search for in Array. If 
omitted, XLOOKUP returns blank cells it finds in Array.
-Array: is 
the reference of the array to search.  Array must be a 1-dimensional array and 
must be contained in one sheet only.
-Return: is 
the reference of the array or range to return.
-If Return is a range of cells, 
the XLOOKUP function must be entered as an array 
formula.
-NotFound: 
a text or cell content to return if the Lookup value is not found. 
If a valid match is not found and NotFound is omitted, the 
function returns the #N/A error.
+Search 
criterion: (optional) The value of any type to search for in 
Array. If omitted, XLOOKUP returns blank cells it finds in 
Search Array.
+Search 
Array: is the reference of the array to search.  Array must be a 
1-dimensional array and must be contained in one sheet only.
+Result 
Array: is the reference of the array or range to return.
+If Result Array is a range of 
cells, the XLOOKUP function must be entered as an array 
formula.
+Result if not 
found: a text or cell content to return if the Lookup value 
is not found. If a valid match is not found and Result if not 
found is omitted, the function returns the #N/A error.
 
 
-MatchType: (optional) specifies the 
match type. Values can be:
+Match 
Mode: (optional) specifies the match type. Values can be:
 
 
-0: 
exact match (default). If Lookup value is not found and 
NotFound text is omitted, then return the #N/A error.
+0: 
exact match (default). If Search criterion value is not found and 
Result if not found text is omitted, then return the #N/A 
error.
 
 
--1: 
attempt exact match. If Lookup value is not found, then return the 
next smaller item.
+-1: 
attempt exact match. If Search criterion value is not found, then 
return the next smaller item.
 
 
-1: 
attempt exact match. If Lookup value is not found, then return the 
next larger item.
+1: 
attempt exact match. If Search criterion value is not found, then 
return the next larger item.
 
 
-2: 
a wildcard match where 
characters *, ?, and ~ have special meanings.
+2: 
a wildcard match where 
characters * (multiple characters), ? (single character), and ~ have special 
meanings.
 
 
 3: a 
regular expression 
match.
@@ -58,22 +58,22 @@
 
 
 
-SearchMode: (optional) specifies the 
search mode to use.
+Search 
Mode: (optional) specifies the search mode to use.
 
 
-1: 
returns the first occurrence starting from the first item of Array 
(default).
+1: 
returns the first occurrence starting from the first item of Search 
Array (default).
 
 
--1: 
reverse search. Returns the first occurrence starting from the last item of 
Array.
+-1: 
reverse search. Returns the first occurrence starting from the last item of 
Search Array.
 
 
-2: 
binary search that relies on Array being sorted in ascending 
order. If not sorted, invalid results will be returned.
+2: 
binary search that relies on Search Array being sorted in 
ascending order. If not sorted, invalid results will be returned.
 
 
--2: 
binary search that relies on Array being sorted in descending 
order. If not sorted, invalid results will be returned.
+-2: 
binary search that relies on Search Array being sorted in 
descending order. If 

core.git: helpcontent2

[Olivier Hallot (via logerrit)]

 helpcontent2 |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit 0862a12208919f0c8171a4dd4ff356d8833b9221
Author: Olivier Hallot 
AuthorDate: Wed Jul 10 11:52:05 2024 -0300
Commit: Gerrit Code Review 
CommitDate: Wed Jul 10 16:52:05 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'master'
  to 1a7045ca49e06f1e84bee74cdac6d8d6a399ddd8
  - tdf#159596 match XLOOKUP Help terms to UI terms

Change-Id: I5c2c7739ae6e6a7413bd99a72fa448981c560b50
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/170312
Reviewed-by: Olivier Hallot 
Tested-by: Jenkins

diff --git a/helpcontent2 b/helpcontent2
index 33ffaf1eaac1..1a7045ca49e0 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit 33ffaf1eaac11bb5770eadce49fac96a4ae4ba86
+Subproject commit 1a7045ca49e06f1e84bee74cdac6d8d6a399ddd8

help.git: source/text

[Olivier Hallot (via logerrit)]

 source/text/scalc/01/func_xlookup.xhp |   34 +-
 1 file changed, 17 insertions(+), 17 deletions(-)

New commits:
commit 1a7045ca49e06f1e84bee74cdac6d8d6a399ddd8
Author: Olivier Hallot 
AuthorDate: Wed Jul 10 10:28:31 2024 -0300
Commit: Olivier Hallot 
CommitDate: Wed Jul 10 16:52:04 2024 +0200

tdf#159596 match XLOOKUP Help terms to UI terms

Change-Id: I5c2c7739ae6e6a7413bd99a72fa448981c560b50
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/170312
Reviewed-by: Olivier Hallot 
Tested-by: Jenkins

diff --git a/source/text/scalc/01/func_xlookup.xhp 
b/source/text/scalc/01/func_xlookup.xhp
index 9c06c3e61d..ee5f5c3f63 100644
--- a/source/text/scalc/01/func_xlookup.xhp
+++ b/source/text/scalc/01/func_xlookup.xhp
@@ -28,28 +28,28 @@
 XLOOKUP function is a 
modern and flexible replacement for older functions like VLOOKUP, HLOOKUP, and LOOKUP. XLOOKUP supports 
approximate and exact matching, wildcards (* ?) or regular expressions for 
partial matches, and lookups in vertical or horizontal ranges. XLOOKUP can 
perform a reverse search and offers a fast binary search option when working 
with large datasets.
 
 
-XLOOKUP( [Lookup] ; Array ; 
Return [ ; [ NotFound ] [ ; [MatchType] [ ; SearchMode ] ] ] )
+XLOOKUP( [Search criterion] 
; Search Array ; Result Array [ ; [ Result if not found ] [ ; [Match Mode] [ ; 
Search Mode ] ] ] )
 
-Lookup: 
(optional) The value of any type to search for in Array. If 
omitted, XLOOKUP returns blank cells it finds in Array.
-Array: is 
the reference of the array to search.  Array must be a 1-dimensional array and 
must be contained in one sheet only.
-Return: is 
the reference of the array or range to return.
-If Return is a range of cells, 
the XLOOKUP function must be entered as an array 
formula.
-NotFound: 
a text or cell content to return if the Lookup value is not found. 
If a valid match is not found and NotFound is omitted, the 
function returns the #N/A error.
+Search 
criterion: (optional) The value of any type to search for in 
Array. If omitted, XLOOKUP returns blank cells it finds in 
Search Array.
+Search 
Array: is the reference of the array to search.  Array must be a 
1-dimensional array and must be contained in one sheet only.
+Result 
Array: is the reference of the array or range to return.
+If Result Array is a range of 
cells, the XLOOKUP function must be entered as an array 
formula.
+Result if not 
found: a text or cell content to return if the Lookup value 
is not found. If a valid match is not found and Result if not 
found is omitted, the function returns the #N/A error.
 
 
-MatchType: (optional) specifies the 
match type. Values can be:
+Match 
Mode: (optional) specifies the match type. Values can be:
 
 
-0: 
exact match (default). If Lookup value is not found and 
NotFound text is omitted, then return the #N/A error.
+0: 
exact match (default). If Search criterion value is not found and 
Result if not found text is omitted, then return the #N/A 
error.
 
 
--1: 
attempt exact match. If Lookup value is not found, then return the 
next smaller item.
+-1: 
attempt exact match. If Search criterion value is not found, then 
return the next smaller item.
 
 
-1: 
attempt exact match. If Lookup value is not found, then return the 
next larger item.
+1: 
attempt exact match. If Search criterion value is not found, then 
return the next larger item.
 
 
-2: 
a wildcard match where 
characters *, ?, and ~ have special meanings.
+2: 
a wildcard match where 
characters * (multiple characters), ? (single character), and ~ have special 
meanings.
 
 
 3: a 
regular expression 
match.
@@ -58,22 +58,22 @@
 
 
 
-SearchMode: (optional) specifies the 
search mode to use.
+Search 
Mode: (optional) specifies the search mode to use.
 
 
-1: 
returns the first occurrence starting from the first item of Array 
(default).
+1: 
returns the first occurrence starting from the first item of Search 
Array (default).
 
 
--1: 
reverse search. Returns the first occurrence starting from the last item of 
Array.
+-1: 
reverse search. Returns the first occurrence starting from the last item of 
Search Array.
 
 
-2: 
binary search that relies on Array being sorted in ascending 
order. If not sorted, invalid results will be returned.
+2: 
binary search that relies on Search Array being sorted in 
ascending order. If not sorted, invalid results will be returned.
 
 
--2: 
binary search that relies on Array being sorted in descending 
order. If not sorted, invalid results will be returned.
+-2: 
binary search that relies on Search Array being sorted in 
descending order. If not sorted, invalid results will be returned.
 
 
-MatchType values 2 and 3 
cannot be combined with binary search (SearchMode 

help.git: Branch 'libreoffice-24-8' - 3 commits - source/text

[Olivier Hallot (via logerrit)]

 source/text/scalc/01/ful_func.xhp |3 ---
 source/text/scalc/01/func_xlookup.xhp |8 +---
 source/text/scalc/01/func_xmatch.xhp  |5 -
 source/text/shared/01/0211.xhp|4 +++-
 4 files changed, 12 insertions(+), 8 deletions(-)

New commits:
commit 2f68941ab30515f5ae7e1bbaa2a8e119714f7489
Author: Olivier Hallot 
AuthorDate: Fri Jun 21 09:34:05 2024 -0300
Commit: Olivier Hallot 
CommitDate: Thu Jul 4 16:20:37 2024 +0200

tdf#159596 tdf#159771 Update XMATCH and XLOOKUP pages

+ Added 3 as matchtype
+ removed reference for "search-criteria-must-apply-to-whole-cell"
+ set that matchtype 2 and 3 cannot be combined with binary search.

Change-Id: I1fd2171aa92fb0a2df1c9ee85a1fb5f7f755efdb
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169334
Reviewed-by: Balazs Varga 
Reviewed-by: Olivier Hallot 
Tested-by: Jenkins
(cherry picked from commit 9acd72cd9faa94ec85826293f1e95da3e6175d35)
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169962

diff --git a/source/text/scalc/01/ful_func.xhp 
b/source/text/scalc/01/ful_func.xhp
index a2003e7a66..1681a65bc6 100644
--- a/source/text/scalc/01/ful_func.xhp
+++ b/source/text/scalc/01/ful_func.xhp
@@ -93,8 +93,5 @@
 
 This function 
is always recalculated whenever a recalculation occurs.
 
-
-  The function is always case 
insensitive, independent from the setting of Case sensitive 
checkbox in %PRODUCTNAME - 
PreferencesTools - 
Options - %PRODUCTNAME Calc - 
Calculate. You can however, use the mode modifier 
(?-i) in regular 
expressions to force search for a case-sensitive match.
-
 
 
diff --git a/source/text/scalc/01/func_xlookup.xhp 
b/source/text/scalc/01/func_xlookup.xhp
index d141816110..9c06c3e61d 100644
--- a/source/text/scalc/01/func_xlookup.xhp
+++ b/source/text/scalc/01/func_xlookup.xhp
@@ -49,14 +49,16 @@
 1: 
attempt exact match. If Lookup value is not found, then return the 
next larger item.
 
 
-2: 
a wildcard match where 
characters *, ?, and ~ have special meanings, or a match using regular expressions.
+2: 
a wildcard match where 
characters *, ?, and ~ have special meanings.
+
+
+3: a 
regular expression 
match.
 
 
 
 
 
 SearchMode: (optional) specifies the 
search mode to use.
-
 
 
 1: 
returns the first occurrence starting from the first item of Array 
(default).
@@ -71,7 +73,7 @@
 -2: 
binary search that relies on Array being sorted in descending 
order. If not sorted, invalid results will be returned.
 
 
-MatchType value 2 cannot 
be combined with binary search (SearchMode value 2 or 
-2).
+MatchType values 2 and 3 
cannot be combined with binary search (SearchMode value 
2 or -2).
 
 
 
diff --git a/source/text/scalc/01/func_xmatch.xhp 
b/source/text/scalc/01/func_xmatch.xhp
index 6e3a734dd8..8a14e52a28 100644
--- a/source/text/scalc/01/func_xmatch.xhp
+++ b/source/text/scalc/01/func_xmatch.xhp
@@ -44,7 +44,10 @@
 1: 
attempt exact match. If Lookup value is not found, then return the 
next larger item.
 
 
-2: 
a wildcard match where 
characters *, ?, and ~ have special meanings, or a match using regular expressions.
+2: 
a wildcard match where 
characters *, ?, and ~ have special meanings.
+
+
+3: a 
regular expression 
match.
 
 
 
commit ace610a82455c9fe944ce394cbb85afe813951fe
Author: Pierre F 
AuthorDate: Mon Jun 24 13:07:39 2024 +0200
Commit: Olivier Hallot 
CommitDate: Thu Jul 4 16:20:16 2024 +0200

fix typo

Change-Id: I353e1a52697f5d7ac055ad870d1415885a3b5a5a
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169439
Reviewed-by: Olivier Hallot 
Tested-by: Jenkins
(cherry picked from commit c796230a7363073c9763dff5d157fd5711ba590d)
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169961

diff --git a/source/text/shared/01/0211.xhp 
b/source/text/shared/01/0211.xhp
index ffb5b2905d..dc184e775e 100644
--- a/source/text/shared/01/0211.xhp
+++ b/source/text/shared/01/0211.xhp
@@ -271,7 +271,7 @@
   
   
 
-

+\d
 [:digit:]
 
 
commit 92a38c452c2e71463a3331431fbc24b6e3d3c6c0
Author: Pierre F 
AuthorDate: Sun Jun 23 17:53:30 2024 +0200
Commit: Olivier Hallot 
CommitDate: Thu Jul 4 16:15:20 2024 +0200

explicit \s and \d +  put the note first for full ICU spec. tdf#113975

Change-Id: Ie06115c051def1da7b94357a392796d15a21df34
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169402
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 
(cherry picked from commit ade7397aed9febc73918d93ffdf6477d3f4d4175)
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169960

diff --git a/source/text/shared/01/0211.xhp 
b/source/text/shared/01/0211.xhp
index 33925f27dc..ffb5b2905d 100644
--- a/source/text/shared/01/0211.xhp
+++ 

help.git: 6 commits - AllLangHelp_sbasic.mk source/auxiliary source/text

[Olivier Hallot (via logerrit)]

 AllLangHelp_sbasic.mk   |1 
 source/auxiliary/sbasic.tree|1 
 source/text/sbasic/shared/main0601.xhp  |1 
 source/text/sbasic/shared/vba_objects.xhp   |  178 
 source/text/scalc/01/04060118.xhp   |2 
 source/text/shared/optionen/01040200.xhp|2 
 source/text/swriter/00/0403.xhp |2 
 source/text/swriter/guide/header_pagestyles.xhp |2 
 8 files changed, 185 insertions(+), 4 deletions(-)

New commits:
commit f2bf7ec5f1192052bc00bdb113885a41e6fb901b
Author: Olivier Hallot 
AuthorDate: Sat Jul 6 23:04:21 2024 +0200
Commit: Olivier Hallot 
CommitDate: Sun Jul 7 17:08:23 2024 +0200

Fix example for COUPDAYS.

Change-Id: Id63a3d2a80aa0c829d1507185467ff575beaac3a
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/170036
Reviewed-by: Olivier Hallot 
Tested-by: Jenkins

diff --git a/source/text/scalc/01/04060118.xhp 
b/source/text/scalc/01/04060118.xhp
index 6857419ff2..d32fbc13e3 100644
--- a/source/text/scalc/01/04060118.xhp
+++ b/source/text/scalc/01/04060118.xhp
@@ -402,7 +402,7 @@
 
 
 A security is purchased on 
2001-01-25; the date of maturity is 2001-11-15. Interest is paid half-yearly 
(frequency is 2). Using daily balance interest calculation (basis 3) how many 
days are there in the interest period in which the settlement date 
falls?
-=COUPDAYS("2001-01-25"; 
"2001-11-15"; 2; 3)  returns 181.
+=COUPDAYS("2001-01-25"; 
"2001-11-15"; 2; 3)  returns 182.5.
 
 
 
commit a1ed29aa5320041c72f025e43a9eeabe3bdc2289
Author: Julien Nabet 
AuthorDate: Sun Jul 7 12:37:21 2024 +0200
Commit: Julien Nabet 
CommitDate: Sun Jul 7 14:15:10 2024 +0200

Fix dup in sbasic/shared/vba_objects.xhp

Change-Id: Ia9019ca5f5129f5d2741941df19622de5ee403eb
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/170109
Tested-by: Jenkins
Reviewed-by: Julien Nabet 

diff --git a/source/text/sbasic/shared/vba_objects.xhp 
b/source/text/sbasic/shared/vba_objects.xhp
index 1c74b2f919..02537694cc 100644
--- a/source/text/sbasic/shared/vba_objects.xhp
+++ b/source/text/sbasic/shared/vba_objects.xhp
@@ -121,7 +121,7 @@
 
 
 
-
+
 VBA Excel Model;Rows
 
 Rows
@@ -130,7 +130,7 @@
 
 
 
-
+
 VBA Excel Model;Workbook
 
 Workbook
@@ -142,7 +142,7 @@
 
 
 
-
+
 VBA Excel Model;Worksheet
 
 Worksheet
commit ce6b950180c0174cd1b73b37b9fbf7310fe56dbf
Author: Andrea Gelmini 
AuthorDate: Sun Jul 7 09:19:09 2024 +0200
Commit: Julien Nabet 
CommitDate: Sun Jul 7 10:17:00 2024 +0200

Fix typo

Change-Id: Ie15138e64d647d669a57a4cfa7c530cd43ad294a
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/170085
Tested-by: Jenkins
Reviewed-by: Julien Nabet 

diff --git a/source/text/sbasic/shared/vba_objects.xhp 
b/source/text/sbasic/shared/vba_objects.xhp
index 0fdb9637d2..1c74b2f919 100644
--- a/source/text/sbasic/shared/vba_objects.xhp
+++ b/source/text/sbasic/shared/vba_objects.xhp
@@ -23,7 +23,7 @@
 VBA Model;Supported objects
   
 VBA supported Data 
Model
-%PRODUCTNAME Basic 
adds this set of functionalies when VBA Office support is active.
+%PRODUCTNAME Basic 
adds this set of functionalities when VBA Office support is active.
 
 
 These exclusive 
%PRODUCTNAME VBA objects properties and methods are enabled when:
commit e859581bf5302296634127cd7bb6576f6e3ec932
Author: Alain Romedenne 
AuthorDate: Fri Jun 7 10:13:07 2024 +0200
Commit: Olivier Hallot 
CommitDate: Sat Jul 6 21:31:28 2024 +0200

tdf#149786 tdf#161495 VBA objects & properties & methods (WiP)

- ActiveSheet object
- (Calc).ExportAsfixedFormat method

This initiates a documentation help page intended to aggregate MSOffice VBA 
objects
features that are currently supported.
Change-Id: I679e9a64923b69fd0d1a5ac99d39651fd8353fc7
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/168530
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 
Tested-by: Olivier Hallot 

diff --git a/AllLangHelp_sbasic.mk b/AllLangHelp_sbasic.mk
index 00484ce127..7c1670d4f0 100644
--- a/AllLangHelp_sbasic.mk
+++ b/AllLangHelp_sbasic.mk
@@ -432,6 +432,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,sbasic,\
 helpcontent2/source/text/sbasic/shared/thisdbdoc \
 helpcontent2/source/text/sbasic/shared/uno_objects \
 helpcontent2/source/text/sbasic/shared/vbasupport \
+helpcontent2/source/text/sbasic/shared/vba_objects \
 helpcontent2/source/text/sbasic/python/main \
 helpcontent2/source/text/sbasic/python/python_2_basic \
 helpcontent2/source/text/sbasic/python/python_dialogs \
diff --git a/source/auxiliary/sbasic.tree b/source/auxiliary/sbasic.tree
index 679d849a15..ed9ac472c2 100644
--- a/source/auxiliary/sbasic.tree
+++ b/source/auxiliary/sbasic.tree
@@ -57,6 +57,7 @@
   UNO Objects, 
Functions and Services
   Calling 
Calc functions
   Exclusive 
VBA functions
+  VBA 

core.git: helpcontent2

[Olivier Hallot (via logerrit)]

 helpcontent2 |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit 50b982570efec6bbbd805f906729280365cb0857
Author: Olivier Hallot 
AuthorDate: Fri Jun 28 06:07:37 2024 -0300
Commit: Gerrit Code Review 
CommitDate: Fri Jun 28 11:07:37 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'master'
  to 7c187e488710f930d4d0ec5291308af2e3776a46
  - Fix broken links on Insert Table Help pages

+ refactor of the files

Change-Id: I60dbaf848250abefc80272b5885ad01536cc218f
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169652
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/helpcontent2 b/helpcontent2
index c796230a7363..7c187e488710 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit c796230a7363073c9763dff5d157fd5711ba590d
+Subproject commit 7c187e488710f930d4d0ec5291308af2e3776a46

help.git: source/text

[Olivier Hallot (via logerrit)]

 source/text/sdraw/main_insert.xhp  |7 ++---
 source/text/shared/01/insert_table.xhp |   40 +++--
 source/text/shared/main0201.xhp|   34 ++--
 source/text/shared/main0204.xhp|   20 
 source/text/simpress/02/1011.xhp   |4 +--
 source/text/simpress/main0104.xhp  |   16 +
 6 files changed, 53 insertions(+), 68 deletions(-)

New commits:
commit 7c187e488710f930d4d0ec5291308af2e3776a46
Author: Olivier Hallot 
AuthorDate: Thu Jun 27 11:55:57 2024 -0300
Commit: Olivier Hallot 
CommitDate: Fri Jun 28 11:07:37 2024 +0200

Fix broken links on Insert Table Help pages

+ refactor of the files

Change-Id: I60dbaf848250abefc80272b5885ad01536cc218f
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169652
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/source/text/sdraw/main_insert.xhp 
b/source/text/sdraw/main_insert.xhp
index 8988f26aeb..a99d3e1f6a 100644
--- a/source/text/sdraw/main_insert.xhp
+++ b/source/text/sdraw/main_insert.xhp
@@ -22,20 +22,19 @@
 
 
   
- Insert
+ Insert
  /text/sdraw/main_insert.xhp
   


   
  Insert
- This 
menu allows you to insert elements, such as graphics and guides, into Draw 
documents.
+ This menu allows you 
to insert elements, such as graphics and guides, into Draw 
documents.
   
 
   
   
-  Table
-  
+  
   
   
   Insert 
Snap Point/Line
diff --git a/source/text/shared/01/insert_table.xhp 
b/source/text/shared/01/insert_table.xhp
index e66e5892b1..993ee7864a 100644
--- a/source/text/shared/01/insert_table.xhp
+++ b/source/text/shared/01/insert_table.xhp
@@ -10,8 +10,7 @@
   -->
 
   
-
+
   Insert Table
   /text/shared/01/insert_table.xhp
 
@@ -22,27 +21,17 @@ indexer="include" status="PUBLISH">
   inserting; tables
   tables; inserting
 
-
-
-
+
+
+
 
-
-
+
+
 
 
-  Insert 
+  Insert
 Table
-  Inserts a 
new 
-table into the current slidepage
+  Inserts a new table into the 
current slidepage
 .
 
 
@@ -64,21 +53,20 @@ 
select="IMPRESS">slidepage
 
 
   Number of Columns
-  Enter the number of 
-columns to include in the new table or use the spin box to increase or 
decrease 
+  Enter the number of
+columns to include in the new table or use the spin box to increase or decrease
 the number of columns.
   
   
 Number of Rows
-Enter the number of 
-rows to include in the new table or use the spin box to increase or decrease 
the 
+Enter the number of
+rows to include in the new table or use the spin box to increase or decrease 
the
 number of rows.
   
   
 
   
-  
+  
   
 
 
@@ -92,7 +80,7 @@ id="bm_id3147226" localize="false"/>
   
   
   
-   Table 
+   Table
  (Options)
 
 
diff --git a/source/text/shared/main0201.xhp b/source/text/shared/main0201.xhp
index 43cbcbd58e..28e24b9db6 100644
--- a/source/text/shared/main0201.xhp
+++ b/source/text/shared/main0201.xhp
@@ -19,17 +19,17 @@
 
 
 
-Standard Bar
+Standard Bar
 /text/shared/main0201.xhp
 
 
 
 
-
+
 
 
 Standard 
Bar
-The Standard bar is available in every 
$[officename] application.
+The 
Standard bar is available in every $[officename] 
application.
 
 
 
@@ -39,7 +39,7 @@
 
 
 Save 
As
-
+

 
 
@@ -99,17 +99,17 @@
 
 
 Insert 
Chart
-Creates a 
chart in the current document.
+Creates a chart in the current 
document.
 
 Sort Descending 
/ Sort Ascending
-Sorts the 
selection from the highest to the lowest value, or from the lowest to the 
highest value using the column that contains the cursor.
+Sorts the selection from the 
highest to the lowest value, or from the lowest to the highest value using the 
column that contains the cursor.
 
 
 
 Chart
-Creates a chart 
in the current document.
+Creates a chart in the current 
document.
 
-
+
 
 Display 
Grid
 
@@ -117,7 +117,7 @@
 
 
 Chart
-Creates a chart 
in the current document.
+Creates a chart in the current 
document.
 
 
 
@@ -137,29 +137,29 @@
 
 
 
-
-Icon
+
+Icon
 
 
-Zoom
+Zoom
 
 
 
 
 
 
-
+
 What’s This?
-Enables extended help tips under the mouse pointer until the next 
click.
+Enables extended 
help tips under the mouse pointer until the next click.
 
 
 
 
-
-Icon “What’s 
This?”
+
+Icon “What’s 
This?”
 
 
-What’s 
This?
+What’s This?
 
 
 
diff --git a/source/text/shared/main0204.xhp b/source/text/shared/main0204.xhp
index c48a7c00c8..63d75a4d36 100644
--- a/source/text/shared/main0204.xhp
+++ b/source/text/shared/main0204.xhp
@@ -20,17 +20,17 @@
 
 
 
-Table Bar
+Table Bar
 /text/shared/main0204.xhp
 
 
 
 
-
+
 Table 
Bar
-The Table Bar contains functions you need when working 
with tables. It appears when you move the cursor into a 
table.
+The 
Table Bar contains functions you need when working with tables. It 
appears when you move the cursor into a table.
 
-
+
 
 
 
@@ -60,18 

core.git: Branch 'libreoffice-24-8' - helpcontent2

[Olivier Hallot (via logerrit)]

 helpcontent2 |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit b7bec979f2602bad759b4e018284c2779f215c00
Author: Olivier Hallot 
AuthorDate: Tue Jun 25 00:46:36 2024 +0200
Commit: Gerrit Code Review 
CommitDate: Tue Jun 25 00:46:36 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'libreoffice-24-8'
  to c13b9143a1ee11ccee89f4a87428a44eca6b82cd
  - Fix %PRODUCTNAME

Change-Id: I30533473a81ecf7bb9ca3befbe5bac75d010b16d
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169375
Reviewed-by: Olivier Hallot 
Tested-by: Jenkins
(cherry picked from commit 47eaabaeb6b90551dccb72ad5ba9f241ad7608cf)
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169495
Reviewed-by: Adolfo Jayme Barrientos 

diff --git a/helpcontent2 b/helpcontent2
index cff3696b273e..c13b9143a1ee 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit cff3696b273edfe384a652a11e654fb56b889abf
+Subproject commit c13b9143a1ee11ccee89f4a87428a44eca6b82cd

help.git: Branch 'libreoffice-24-8' - source/text

[Olivier Hallot (via logerrit)]

 source/text/shared/optionen/01010200.xhp |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit c13b9143a1ee11ccee89f4a87428a44eca6b82cd
Author: Olivier Hallot 
AuthorDate: Sun Jun 23 09:20:54 2024 +0200
Commit: Adolfo Jayme Barrientos 
CommitDate: Tue Jun 25 00:46:36 2024 +0200

Fix %PRODUCTNAME

Change-Id: I30533473a81ecf7bb9ca3befbe5bac75d010b16d
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169375
Reviewed-by: Olivier Hallot 
Tested-by: Jenkins
(cherry picked from commit 47eaabaeb6b90551dccb72ad5ba9f241ad7608cf)
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169495
Reviewed-by: Adolfo Jayme Barrientos 

diff --git a/source/text/shared/optionen/01010200.xhp 
b/source/text/shared/optionen/01010200.xhp
index 496f6c804b..eec963ff0f 100644
--- a/source/text/shared/optionen/01010200.xhp
+++ b/source/text/shared/optionen/01010200.xhp
@@ -89,7 +89,7 @@
 A timer starts for a document when it is 
first modified. AutoRecovery information is saved after the specified time 
(while %PRODUCTNAME is idle). The timer then restarts with the next 
modification in the document.
 
 Automatically save the document instead
-  Specifies that LibreOffice saves the 
modified document itself instead of creating a temporary AutoRecovery version. 
Uses the time interval specified in 
Minutes.
+  Specifies that %PRODUCTNAME saves the 
modified document itself instead of creating a temporary AutoRecovery version. 
Uses the time interval specified in 
Minutes.
 
 Edit document properties before saving
   Specifies that the Properties 
dialog will appear every time you select the Save As 
command.

help.git: source/text

[Olivier Hallot (via logerrit)]

 source/text/shared/optionen/01010200.xhp |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit 47eaabaeb6b90551dccb72ad5ba9f241ad7608cf
Author: Olivier Hallot 
AuthorDate: Sun Jun 23 09:20:54 2024 +0200
Commit: Olivier Hallot 
CommitDate: Mon Jun 24 10:53:06 2024 +0200

Fix %PRODUCTNAME

Change-Id: I30533473a81ecf7bb9ca3befbe5bac75d010b16d
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169375
Reviewed-by: Olivier Hallot 
Tested-by: Jenkins

diff --git a/source/text/shared/optionen/01010200.xhp 
b/source/text/shared/optionen/01010200.xhp
index 496f6c804b..eec963ff0f 100644
--- a/source/text/shared/optionen/01010200.xhp
+++ b/source/text/shared/optionen/01010200.xhp
@@ -89,7 +89,7 @@
 A timer starts for a document when it is 
first modified. AutoRecovery information is saved after the specified time 
(while %PRODUCTNAME is idle). The timer then restarts with the next 
modification in the document.
 
 Automatically save the document instead
-  Specifies that LibreOffice saves the 
modified document itself instead of creating a temporary AutoRecovery version. 
Uses the time interval specified in 
Minutes.
+  Specifies that %PRODUCTNAME saves the 
modified document itself instead of creating a temporary AutoRecovery version. 
Uses the time interval specified in 
Minutes.
 
 Edit document properties before saving
   Specifies that the Properties 
dialog will appear every time you select the Save As 
command.

core.git: 2 commits - helpcontent2

[Olivier Hallot (via logerrit)]

 helpcontent2 |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit fefc609559f1f81e9e88b6b2d77c1bb1f6bff31a
Author: Olivier Hallot 
AuthorDate: Mon Jun 24 10:53:06 2024 +0200
Commit: Gerrit Code Review 
CommitDate: Mon Jun 24 10:53:06 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'master'
  to 47eaabaeb6b90551dccb72ad5ba9f241ad7608cf
  - Fix %PRODUCTNAME

Change-Id: I30533473a81ecf7bb9ca3befbe5bac75d010b16d
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169375
Reviewed-by: Olivier Hallot 
Tested-by: Jenkins

diff --git a/helpcontent2 b/helpcontent2
index ade7397aed9f..47eaabaeb6b9 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit ade7397aed9febc73918d93ffdf6477d3f4d4175
+Subproject commit 47eaabaeb6b90551dccb72ad5ba9f241ad7608cf
commit b0ad1a7b51cf21e17fdeccaf32893a8012a979d6
Author: Pierre F 
AuthorDate: Mon Jun 24 10:52:51 2024 +0200
Commit: Gerrit Code Review 
CommitDate: Mon Jun 24 10:52:51 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'master'
  to ade7397aed9febc73918d93ffdf6477d3f4d4175
  - explicit \s and \d +  put the note first for full ICU spec. tdf#113975

Change-Id: Ie06115c051def1da7b94357a392796d15a21df34
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169402
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/helpcontent2 b/helpcontent2
index 9acd72cd9faa..ade7397aed9f 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit 9acd72cd9faa94ec85826293f1e95da3e6175d35
+Subproject commit ade7397aed9febc73918d93ffdf6477d3f4d4175

core.git: helpcontent2

[Olivier Hallot (via logerrit)]

 helpcontent2 |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit ecb0d08e3cfcad18006c0090b9b5b19c1c0f7b9c
Author: Olivier Hallot 
AuthorDate: Sun Jun 23 04:20:17 2024 -0300
Commit: Gerrit Code Review 
CommitDate: Sun Jun 23 09:20:17 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'master'
  to 9acd72cd9faa94ec85826293f1e95da3e6175d35
  - tdf#159596 tdf#159771 Update XMATCH and XLOOKUP pages

+ Added 3 as matchtype
+ removed reference for "search-criteria-must-apply-to-whole-cell"
+ set that matchtype 2 and 3 cannot be combined with binary search.

Change-Id: I1fd2171aa92fb0a2df1c9ee85a1fb5f7f755efdb
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169334
Reviewed-by: Balazs Varga 
Reviewed-by: Olivier Hallot 
Tested-by: Jenkins

diff --git a/helpcontent2 b/helpcontent2
index 1178a2c56453..9acd72cd9faa 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit 1178a2c5645336fa720a1fe6cc023df8a8e7895f
+Subproject commit 9acd72cd9faa94ec85826293f1e95da3e6175d35

help.git: source/text

[Olivier Hallot (via logerrit)]

 source/text/scalc/01/ful_func.xhp |3 ---
 source/text/scalc/01/func_xlookup.xhp |8 +---
 source/text/scalc/01/func_xmatch.xhp  |5 -
 3 files changed, 9 insertions(+), 7 deletions(-)

New commits:
commit 9acd72cd9faa94ec85826293f1e95da3e6175d35
Author: Olivier Hallot 
AuthorDate: Fri Jun 21 09:34:05 2024 -0300
Commit: Olivier Hallot 
CommitDate: Sun Jun 23 09:20:16 2024 +0200

tdf#159596 tdf#159771 Update XMATCH and XLOOKUP pages

+ Added 3 as matchtype
+ removed reference for "search-criteria-must-apply-to-whole-cell"
+ set that matchtype 2 and 3 cannot be combined with binary search.

Change-Id: I1fd2171aa92fb0a2df1c9ee85a1fb5f7f755efdb
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169334
Reviewed-by: Balazs Varga 
Reviewed-by: Olivier Hallot 
Tested-by: Jenkins

diff --git a/source/text/scalc/01/ful_func.xhp 
b/source/text/scalc/01/ful_func.xhp
index a2003e7a66..1681a65bc6 100644
--- a/source/text/scalc/01/ful_func.xhp
+++ b/source/text/scalc/01/ful_func.xhp
@@ -93,8 +93,5 @@
 
 This function 
is always recalculated whenever a recalculation occurs.
 
-
-  The function is always case 
insensitive, independent from the setting of Case sensitive 
checkbox in %PRODUCTNAME - 
PreferencesTools - 
Options - %PRODUCTNAME Calc - 
Calculate. You can however, use the mode modifier 
(?-i) in regular 
expressions to force search for a case-sensitive match.
-
 
 
diff --git a/source/text/scalc/01/func_xlookup.xhp 
b/source/text/scalc/01/func_xlookup.xhp
index d141816110..9c06c3e61d 100644
--- a/source/text/scalc/01/func_xlookup.xhp
+++ b/source/text/scalc/01/func_xlookup.xhp
@@ -49,14 +49,16 @@
 1: 
attempt exact match. If Lookup value is not found, then return the 
next larger item.
 
 
-2: 
a wildcard match where 
characters *, ?, and ~ have special meanings, or a match using regular expressions.
+2: 
a wildcard match where 
characters *, ?, and ~ have special meanings.
+
+
+3: a 
regular expression 
match.
 
 
 
 
 
 SearchMode: (optional) specifies the 
search mode to use.
-
 
 
 1: 
returns the first occurrence starting from the first item of Array 
(default).
@@ -71,7 +73,7 @@
 -2: 
binary search that relies on Array being sorted in descending 
order. If not sorted, invalid results will be returned.
 
 
-MatchType value 2 cannot 
be combined with binary search (SearchMode value 2 or 
-2).
+MatchType values 2 and 3 
cannot be combined with binary search (SearchMode value 
2 or -2).
 
 
 
diff --git a/source/text/scalc/01/func_xmatch.xhp 
b/source/text/scalc/01/func_xmatch.xhp
index 6e3a734dd8..8a14e52a28 100644
--- a/source/text/scalc/01/func_xmatch.xhp
+++ b/source/text/scalc/01/func_xmatch.xhp
@@ -44,7 +44,10 @@
 1: 
attempt exact match. If Lookup value is not found, then return the 
next larger item.
 
 
-2: 
a wildcard match where 
characters *, ?, and ~ have special meanings, or a match using regular expressions.
+2: 
a wildcard match where 
characters *, ?, and ~ have special meanings.
+
+
+3: a 
regular expression 
match.
 
 
 

core.git: Branch 'libreoffice-24-8' - helpcontent2

[Olivier Hallot (via logerrit)]

 helpcontent2 |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit 50bb6975fb7511e1c4073747ff82c6befb463d63
Author: Olivier Hallot 
AuthorDate: Thu Jun 20 11:07:42 2024 -0300
Commit: Gerrit Code Review 
CommitDate: Thu Jun 20 16:07:42 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'libreoffice-24-8'
  to cff3696b273edfe384a652a11e654fb56b889abf
  - Update term Organizer -> General in swriter/ pages

Change-Id: I33ac397dd8c1f831b832c9d385a14e236853a9de
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169273
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 
(cherry picked from commit 1178a2c5645336fa720a1fe6cc023df8a8e7895f)
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169149

diff --git a/helpcontent2 b/helpcontent2
index 2d73197c2134..cff3696b273e 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit 2d73197c21348cbe3d7e8d5329a6fc9e8dc5e326
+Subproject commit cff3696b273edfe384a652a11e654fb56b889abf

help.git: Branch 'libreoffice-24-8' - source/text

[Olivier Hallot (via logerrit)]

 source/text/swriter/01/05130002.xhp |6 +-
 source/text/swriter/guide/even_odd_sdw.xhp  |   38 ++---
 source/text/swriter/guide/header_pagestyles.xhp |   39 ++---
 source/text/swriter/guide/pagebackground.xhp|   52 -
 source/text/swriter/guide/pagenumbers.xhp   |   70 
 source/text/swriter/guide/pageorientation.xhp   |   58 +--
 source/text/swriter/guide/pagestyles.xhp|   46 +++
 7 files changed, 154 insertions(+), 155 deletions(-)

New commits:
commit cff3696b273edfe384a652a11e654fb56b889abf
Author: Olivier Hallot 
AuthorDate: Thu Jun 20 09:11:39 2024 -0300
Commit: Olivier Hallot 
CommitDate: Thu Jun 20 16:07:42 2024 +0200

Update term Organizer -> General in swriter/ pages

Change-Id: I33ac397dd8c1f831b832c9d385a14e236853a9de
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169273
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 
(cherry picked from commit 1178a2c5645336fa720a1fe6cc023df8a8e7895f)
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169149

diff --git a/source/text/swriter/01/05130002.xhp 
b/source/text/swriter/01/05130002.xhp
index d8aaf97d6b..ace6151acf 100644
--- a/source/text/swriter/01/05130002.xhp
+++ b/source/text/swriter/01/05130002.xhp
@@ -19,7 +19,7 @@
 
 
 
-Character Style 
+Character Style 
 /text/swriter/01/05130002.xhp
 
 
@@ -28,7 +28,7 @@
 
 
 Character 
Style
-Character 
styles provide a way to customize the formatting for individual characters. Use 
character styles to change the properties of a character, word or selected part 
of a paragraph. When you apply a character style to a text selection, the 
character style properties override the corresponding paragraph character 
properties.
+Character styles provide a way 
to customize the formatting for individual characters. Use character styles to 
change the properties of a character, word or selected part of a paragraph. 
When you apply a character style to a text selection, the character style 
properties override the corresponding paragraph character 
properties.
 For example, if you 
apply a character style with 15pt font size to a selection in a paragraph with 
character property of 12pt font size, the selection is set to 15pt, while the 
rest of the paragraph remains with 12pt font size.
 No Character Style is actually 
the set of character properties of the current paragraph style. Choose No 
Character Style to reset the character properties of the selection to those of 
the paragraph style. You cannot customize No Character Style.
 
@@ -36,7 +36,7 @@
 
 Direct formatting overrides any formatting 
provided by a character style. To remove direct formatting from a selection, 
use Format - Clear Direct Formatting (CommandCtrl+M).
 
-Use the Contains section in the 
Organizer to see the properties of the character style.
+Use the Contains section in the 
General tab to see the properties of the character style.
 
 
 
diff --git a/source/text/swriter/guide/even_odd_sdw.xhp 
b/source/text/swriter/guide/even_odd_sdw.xhp
index 3e9cd0622b..490e6933a9 100644
--- a/source/text/swriter/guide/even_odd_sdw.xhp
+++ b/source/text/swriter/guide/even_odd_sdw.xhp
@@ -20,14 +20,14 @@
 
 
   
-Alternating Page Styles on Odd and Even 
Pages
+Alternating Page Styles on Odd and Even Pages
 /text/swriter/guide/even_odd_sdw.xhp
   
 
 
 
 
-
+
   page styles; left and right pages
   blank pages with alternating page styles
   empty page with alternating page styles
@@ -46,10 +46,10 @@
 
   
 
-   Icon
+   Icon
 
 
-  $[officename] can automatically apply alternating page styles 
on even (left) and odd pages (right) in your document. For example, you can use 
page styles to display different headers and footers on even and odd pages. The 
current page style is displayed in the Status Bar at the bottom of 
the workplace.
+  $[officename] can 
automatically apply alternating page styles on even (left) and odd pages 
(right) in your document. For example, you can use page styles to display 
different headers and footers on even and odd pages. The current page style is 
displayed in the Status Bar at the bottom of the 
workplace.
 
   
 
@@ -59,48 +59,48 @@
 
 
   
-Choose 
View - Styles, and then click the Page Styles icon.
+Choose View - Styles, and then click the Page Styles icon.
   
   
-In the list 
of page styles, right-click "Left Page" and choose 
Modify.
+In the list of page styles, 
right-click "Left Page" and choose Modify.
   
   
-Click the 
Organizer tab.
+Click the 
General tab.
   
   
-Select 
"Right Page" in the Next Style box, and then click 
OK.
+Select "Right Page" in the 
Next Style box, and then click OK.
   
   
-In the list 
of page styles, right-click "Right Page" and choose 
Modify.
+In the list of page styles, 
right-click "Right Page" and choose Modify.
   
   
-

core.git: Branch 'libreoffice-24-8' - helpcontent2

[Olivier Hallot (via logerrit)]

 helpcontent2 |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit a6e7de192c54253bad228c7e07071c973363ec04
Author: Olivier Hallot 
AuthorDate: Thu Jun 20 11:07:20 2024 -0300
Commit: Gerrit Code Review 
CommitDate: Thu Jun 20 16:07:20 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'libreoffice-24-8'
  to 2d73197c21348cbe3d7e8d5329a6fc9e8dc5e326
  - Update term Organizer -> General in shared/ pages

Change-Id: I455cc5e0f115638fb1c9312db8d8cd50e7b1b0cf
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169272
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 
(cherry picked from commit b0425a000fa79d8152652b031c1be8d3d3b2af56)
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169148

diff --git a/helpcontent2 b/helpcontent2
index 83da8f2dc58d..2d73197c2134 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit 83da8f2dc58d4fefaecf204ec6fc54281c65213a
+Subproject commit 2d73197c21348cbe3d7e8d5329a6fc9e8dc5e326

help.git: Branch 'libreoffice-24-8' - source/text

[Olivier Hallot (via logerrit)]

 source/text/shared/00/0001.xhp |2 +-
 source/text/shared/00/00040500.xhp |   16 
 source/text/shared/01/05040100.xhp |4 ++--
 3 files changed, 11 insertions(+), 11 deletions(-)

New commits:
commit 2d73197c21348cbe3d7e8d5329a6fc9e8dc5e326
Author: Olivier Hallot 
AuthorDate: Thu Jun 20 08:56:32 2024 -0300
Commit: Olivier Hallot 
CommitDate: Thu Jun 20 16:07:20 2024 +0200

Update term Organizer -> General in shared/ pages

Change-Id: I455cc5e0f115638fb1c9312db8d8cd50e7b1b0cf
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169272
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 
(cherry picked from commit b0425a000fa79d8152652b031c1be8d3d3b2af56)
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169148

diff --git a/source/text/shared/00/0001.xhp 
b/source/text/shared/00/0001.xhp
index 9688e8bdfa..d370d15da8 100644
--- a/source/text/shared/00/0001.xhp
+++ b/source/text/shared/00/0001.xhp
@@ -252,7 +252,7 @@
 
 
 Reset to Parent
-Values for the current 
tab are set to those found in the corresponding tab of the style specified in 
“Inherit from” in Organizer. In all cases, also when “Inherit from” is “- None 
-”, current tab values specified in “Contains” are removed.
+Values for the current 
tab are set to those found in the corresponding tab of the style specified in 
“Inherit from” in the General tab. In all cases, also when “Inherit from” is “- 
None -”, current tab values specified in “Contains” are removed.
 
 
 This option appears 
only for Paragraph Style, Character Style, and Frame Style.
diff --git a/source/text/shared/00/00040500.xhp 
b/source/text/shared/00/00040500.xhp
index 9e8794e88d..82754a2bfd 100644
--- a/source/text/shared/00/00040500.xhp
+++ b/source/text/shared/00/00040500.xhp
@@ -483,24 +483,24 @@
 Choose Format - Cells - 
Background tab.
 
 
-Choose Format - Page 
Style - Organizer tab.
-Choose Styles - Edit 
Style - Organizer tab.
-Choose Styles 
- Manage Styles - open context menu of an entry and choose 
New/Edit Style - Organizer tab.
+Choose Format - Page 
Style - General tab.
+Choose Styles - Edit 
Style - General tab.
+Choose Styles 
- Manage Styles - open context menu of an entry and choose 
New/Edit Style - General tab.
 
 
-Choose Format - Page Style - 
Organizer tab.
-Choose Styles 
- Manage Styles - open context menu of an entry and choose 
New/Edit Style - Organizer tab.
+Choose Format - Page Style - 
General tab.
+Choose Styles 
- Manage Styles - open context menu of an entry and choose 
New/Edit Style - General tab.
 
 
-Choose Format - Styles - Edit Style - 
Organizer tab.
-Choose Format 
- Styles - Manage Styles - open context menu of an entry and choose 
New/Edit Style - Organizer tab.
+Choose Format - Styles - Edit Style - 
General tab.
+Choose Format 
- Styles - Manage Styles - open context menu of an entry and choose 
New/Edit Style - General tab.
 
 
 Choose Slide - Properties - 
Page tab.
 
 
 Choose View - 
Styles (Command+T)
-(F11) - open 
context menu of an entry and choose New/Edit Style - 
Organizer tab.
+(F11) - open 
context menu of an entry and choose New/Edit Style - 
General tab.
 
 
 
diff --git a/source/text/shared/01/05040100.xhp 
b/source/text/shared/01/05040100.xhp
index ca17e324a2..818eaeda81 100644
--- a/source/text/shared/01/05040100.xhp
+++ b/source/text/shared/01/05040100.xhp
@@ -20,7 +20,7 @@
 
 
   
- Organizer
+ General
  /text/shared/01/05040100.xhp
   

@@ -32,7 +32,7 @@
 
 
 
-Organizer
+General
 Set the options for the selected 
style.
 
   

core.git: helpcontent2

[Olivier Hallot (via logerrit)]

 helpcontent2 |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit a611a5d1078631cf49b78c7c30b3046329b503f6
Author: Olivier Hallot 
AuthorDate: Thu Jun 20 10:45:14 2024 -0300
Commit: Gerrit Code Review 
CommitDate: Thu Jun 20 15:45:14 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'master'
  to 1178a2c5645336fa720a1fe6cc023df8a8e7895f
  - Update term Organizer -> General in swriter/ pages

Change-Id: I33ac397dd8c1f831b832c9d385a14e236853a9de
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169273
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/helpcontent2 b/helpcontent2
index b0425a000fa7..1178a2c56453 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit b0425a000fa79d8152652b031c1be8d3d3b2af56
+Subproject commit 1178a2c5645336fa720a1fe6cc023df8a8e7895f

help.git: source/text

[Olivier Hallot (via logerrit)]

 source/text/swriter/01/05130002.xhp |6 +-
 source/text/swriter/guide/even_odd_sdw.xhp  |   38 ++---
 source/text/swriter/guide/header_pagestyles.xhp |   39 ++---
 source/text/swriter/guide/pagebackground.xhp|   52 -
 source/text/swriter/guide/pagenumbers.xhp   |   70 
 source/text/swriter/guide/pageorientation.xhp   |   58 +--
 source/text/swriter/guide/pagestyles.xhp|   46 +++
 7 files changed, 154 insertions(+), 155 deletions(-)

New commits:
commit 1178a2c5645336fa720a1fe6cc023df8a8e7895f
Author: Olivier Hallot 
AuthorDate: Thu Jun 20 09:11:39 2024 -0300
Commit: Olivier Hallot 
CommitDate: Thu Jun 20 15:45:14 2024 +0200

Update term Organizer -> General in swriter/ pages

Change-Id: I33ac397dd8c1f831b832c9d385a14e236853a9de
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169273
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/source/text/swriter/01/05130002.xhp 
b/source/text/swriter/01/05130002.xhp
index d8aaf97d6b..ace6151acf 100644
--- a/source/text/swriter/01/05130002.xhp
+++ b/source/text/swriter/01/05130002.xhp
@@ -19,7 +19,7 @@
 
 
 
-Character Style 
+Character Style 
 /text/swriter/01/05130002.xhp
 
 
@@ -28,7 +28,7 @@
 
 
 Character 
Style
-Character 
styles provide a way to customize the formatting for individual characters. Use 
character styles to change the properties of a character, word or selected part 
of a paragraph. When you apply a character style to a text selection, the 
character style properties override the corresponding paragraph character 
properties.
+Character styles provide a way 
to customize the formatting for individual characters. Use character styles to 
change the properties of a character, word or selected part of a paragraph. 
When you apply a character style to a text selection, the character style 
properties override the corresponding paragraph character 
properties.
 For example, if you 
apply a character style with 15pt font size to a selection in a paragraph with 
character property of 12pt font size, the selection is set to 15pt, while the 
rest of the paragraph remains with 12pt font size.
 No Character Style is actually 
the set of character properties of the current paragraph style. Choose No 
Character Style to reset the character properties of the selection to those of 
the paragraph style. You cannot customize No Character Style.
 
@@ -36,7 +36,7 @@
 
 Direct formatting overrides any formatting 
provided by a character style. To remove direct formatting from a selection, 
use Format - Clear Direct Formatting (CommandCtrl+M).
 
-Use the Contains section in the 
Organizer to see the properties of the character style.
+Use the Contains section in the 
General tab to see the properties of the character style.
 
 
 
diff --git a/source/text/swriter/guide/even_odd_sdw.xhp 
b/source/text/swriter/guide/even_odd_sdw.xhp
index 3e9cd0622b..490e6933a9 100644
--- a/source/text/swriter/guide/even_odd_sdw.xhp
+++ b/source/text/swriter/guide/even_odd_sdw.xhp
@@ -20,14 +20,14 @@
 
 
   
-Alternating Page Styles on Odd and Even 
Pages
+Alternating Page Styles on Odd and Even Pages
 /text/swriter/guide/even_odd_sdw.xhp
   
 
 
 
 
-
+
   page styles; left and right pages
   blank pages with alternating page styles
   empty page with alternating page styles
@@ -46,10 +46,10 @@
 
   
 
-   Icon
+   Icon
 
 
-  $[officename] can automatically apply alternating page styles 
on even (left) and odd pages (right) in your document. For example, you can use 
page styles to display different headers and footers on even and odd pages. The 
current page style is displayed in the Status Bar at the bottom of 
the workplace.
+  $[officename] can 
automatically apply alternating page styles on even (left) and odd pages 
(right) in your document. For example, you can use page styles to display 
different headers and footers on even and odd pages. The current page style is 
displayed in the Status Bar at the bottom of the 
workplace.
 
   
 
@@ -59,48 +59,48 @@
 
 
   
-Choose 
View - Styles, and then click the Page Styles icon.
+Choose View - Styles, and then click the Page Styles icon.
   
   
-In the list 
of page styles, right-click "Left Page" and choose 
Modify.
+In the list of page styles, 
right-click "Left Page" and choose Modify.
   
   
-Click the 
Organizer tab.
+Click the 
General tab.
   
   
-Select 
"Right Page" in the Next Style box, and then click 
OK.
+Select "Right Page" in the 
Next Style box, and then click OK.
   
   
-In the list 
of page styles, right-click "Right Page" and choose 
Modify.
+In the list of page styles, 
right-click "Right Page" and choose Modify.
   
   
-Select 
"Left Page" in the Next Style box, and then click 
OK.
+Select "Left Page" in the 
Next Style box, and then click OK.
   
   
-  

help.git: source/text

[Olivier Hallot (via logerrit)]

 source/text/shared/00/0001.xhp |2 +-
 source/text/shared/00/00040500.xhp |   16 
 source/text/shared/01/05040100.xhp |4 ++--
 3 files changed, 11 insertions(+), 11 deletions(-)

New commits:
commit b0425a000fa79d8152652b031c1be8d3d3b2af56
Author: Olivier Hallot 
AuthorDate: Thu Jun 20 08:56:32 2024 -0300
Commit: Olivier Hallot 
CommitDate: Thu Jun 20 15:44:36 2024 +0200

Update term Organizer -> General in shared/ pages

Change-Id: I455cc5e0f115638fb1c9312db8d8cd50e7b1b0cf
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169272
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/source/text/shared/00/0001.xhp 
b/source/text/shared/00/0001.xhp
index 9688e8bdfa..d370d15da8 100644
--- a/source/text/shared/00/0001.xhp
+++ b/source/text/shared/00/0001.xhp
@@ -252,7 +252,7 @@
 
 
 Reset to Parent
-Values for the current 
tab are set to those found in the corresponding tab of the style specified in 
“Inherit from” in Organizer. In all cases, also when “Inherit from” is “- None 
-”, current tab values specified in “Contains” are removed.
+Values for the current 
tab are set to those found in the corresponding tab of the style specified in 
“Inherit from” in the General tab. In all cases, also when “Inherit from” is “- 
None -”, current tab values specified in “Contains” are removed.
 
 
 This option appears 
only for Paragraph Style, Character Style, and Frame Style.
diff --git a/source/text/shared/00/00040500.xhp 
b/source/text/shared/00/00040500.xhp
index 9e8794e88d..82754a2bfd 100644
--- a/source/text/shared/00/00040500.xhp
+++ b/source/text/shared/00/00040500.xhp
@@ -483,24 +483,24 @@
 Choose Format - Cells - 
Background tab.
 
 
-Choose Format - Page 
Style - Organizer tab.
-Choose Styles - Edit 
Style - Organizer tab.
-Choose Styles 
- Manage Styles - open context menu of an entry and choose 
New/Edit Style - Organizer tab.
+Choose Format - Page 
Style - General tab.
+Choose Styles - Edit 
Style - General tab.
+Choose Styles 
- Manage Styles - open context menu of an entry and choose 
New/Edit Style - General tab.
 
 
-Choose Format - Page Style - 
Organizer tab.
-Choose Styles 
- Manage Styles - open context menu of an entry and choose 
New/Edit Style - Organizer tab.
+Choose Format - Page Style - 
General tab.
+Choose Styles 
- Manage Styles - open context menu of an entry and choose 
New/Edit Style - General tab.
 
 
-Choose Format - Styles - Edit Style - 
Organizer tab.
-Choose Format 
- Styles - Manage Styles - open context menu of an entry and choose 
New/Edit Style - Organizer tab.
+Choose Format - Styles - Edit Style - 
General tab.
+Choose Format 
- Styles - Manage Styles - open context menu of an entry and choose 
New/Edit Style - General tab.
 
 
 Choose Slide - Properties - 
Page tab.
 
 
 Choose View - 
Styles (Command+T)
-(F11) - open 
context menu of an entry and choose New/Edit Style - 
Organizer tab.
+(F11) - open 
context menu of an entry and choose New/Edit Style - 
General tab.
 
 
 
diff --git a/source/text/shared/01/05040100.xhp 
b/source/text/shared/01/05040100.xhp
index ca17e324a2..818eaeda81 100644
--- a/source/text/shared/01/05040100.xhp
+++ b/source/text/shared/01/05040100.xhp
@@ -20,7 +20,7 @@
 
 
   
- Organizer
+ General
  /text/shared/01/05040100.xhp
   

@@ -32,7 +32,7 @@
 
 
 
-Organizer
+General
 Set the options for the selected 
style.
 
   

core.git: 2 commits - dbaccess/qa helpcontent2

[Olivier Hallot (via logerrit)]

 dbaccess/qa/unit/dbtest_base.cxx|   25 +---
 dbaccess/qa/unit/embeddeddb_performancetest.cxx |   21 ++--
 helpcontent2|2 -
 3 files changed, 26 insertions(+), 22 deletions(-)

New commits:
commit 022ace59fa76a7ca6aa0e73fa276197ea569d633
Author: Olivier Hallot 
AuthorDate: Thu Jun 20 10:44:36 2024 -0300
Commit: Gerrit Code Review 
CommitDate: Thu Jun 20 15:44:36 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'master'
  to b0425a000fa79d8152652b031c1be8d3d3b2af56
  - Update term Organizer -> General in shared/ pages

Change-Id: I455cc5e0f115638fb1c9312db8d8cd50e7b1b0cf
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169272
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/helpcontent2 b/helpcontent2
index ba5e40d637b9..b0425a000fa7 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit ba5e40d637b9dac0575f982d48666bb45423c628
+Subproject commit b0425a000fa79d8152652b031c1be8d3d3b2af56
commit fb8f4b57ceaa2462cd966de7afeb0971a655f647
Author: Xisco Fauli 
AuthorDate: Thu Jun 20 14:13:18 2024 +0200
Commit: Xisco Fauli 
CommitDate: Thu Jun 20 15:44:26 2024 +0200

DBTestBase: Add createDBDocument

it can be used later on when porting the java tests
to CppUnittest

Change-Id: I17420fdf490d979392f5aeb90c3b3bfb319d7764
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/169274
Reviewed-by: Xisco Fauli 
Tested-by: Jenkins

diff --git a/dbaccess/qa/unit/dbtest_base.cxx b/dbaccess/qa/unit/dbtest_base.cxx
index 5ec6950efe03..63a3951ad7b4 100644
--- a/dbaccess/qa/unit/dbtest_base.cxx
+++ b/dbaccess/qa/unit/dbtest_base.cxx
@@ -11,15 +11,15 @@
 
 #include 
 
-#include 
-
 #include 
-#include 
+#include 
+#include 
 #include 
 #include 
 #include 
 
 using namespace ::com::sun::star;
+using namespace ::com::sun::star::beans;
 using namespace ::com::sun::star::sdb;
 using namespace ::com::sun::star::sdbc;
 using namespace ::com::sun::star::uno;
@@ -35,6 +35,8 @@ public:
 uno::Reference< XConnection >
 getConnectionForDocument(
 uno::Reference< XOfficeDatabaseDocument > const & xDocument);
+
+void createDBDocument(const OUString& rDriverURL);
 };
 
 uno::Reference DBTestBase::getDocumentForUrl(OUString 
const & url) {
@@ -55,4 +57,21 @@ uno::Reference< XConnection > 
DBTestBase::getConnectionForDocument(
 return xConnection;
 }
 
+void DBTestBase::createDBDocument(const OUString& rDriverURL)
+{
+uno::Reference< XOfficeDatabaseDocument > xDocument(
+
m_xSFactory->createInstance(u"com.sun.star.sdb.OfficeDatabaseDocument"_ustr),
+UNO_QUERY_THROW);
+uno::Reference< com::sun::star::frame::XStorable > xStorable(xDocument, 
UNO_QUERY_THROW);
+
+uno::Reference< XDataSource > xDataSource = xDocument->getDataSource();
+uno::Reference< XPropertySet > xPropertySet(xDataSource, UNO_QUERY_THROW);
+xPropertySet->setPropertyValue(u"URL"_ustr, Any(rDriverURL));
+
+xStorable->storeAsURL(maTempFile.GetURL(), uno::Sequence< 
beans::PropertyValue >());
+
+mxComponent = loadFromDesktop(maTempFile.GetURL());
+CPPUNIT_ASSERT(mxComponent);
+}
+
 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */
diff --git a/dbaccess/qa/unit/embeddeddb_performancetest.cxx 
b/dbaccess/qa/unit/embeddeddb_performancetest.cxx
index 0698690c44c0..d142580f2655 100644
--- a/dbaccess/qa/unit/embeddeddb_performancetest.cxx
+++ b/dbaccess/qa/unit/embeddeddb_performancetest.cxx
@@ -14,7 +14,6 @@
 #include 
 #include 
 #include 
-#include 
 
 #include 
 #include 
@@ -194,24 +193,10 @@ void EmbeddedDBPerformanceTest::doPerformanceTestOnODB(
 std::u16string_view rDBName,
 const bool bUsePreparedStatement)
 {
-{
-uno::Reference< XOfficeDatabaseDocument > xDocument(
-
m_xSFactory->createInstance(u"com.sun.star.sdb.OfficeDatabaseDocument"_ustr),
-UNO_QUERY_THROW);
-uno::Reference< XStorable > xStorable(xDocument, UNO_QUERY_THROW);
-
-uno::Reference< XDataSource > xDataSource = xDocument->getDataSource();
-uno::Reference< XPropertySet > xPropertySet(xDataSource, 
UNO_QUERY_THROW);
-xPropertySet->setPropertyValue(u"URL"_ustr, Any(rDriverURL));
-
-xStorable->storeAsURL(maTempFile.GetURL(), uno::Sequence< 
beans::PropertyValue >());
-}
-
-uno::Reference< XOfficeDatabaseDocument > xDocument(
-loadFromDesktop(maTempFile.GetURL()), UNO_QUERY_THROW);
+createDBDocument(rDriverURL);
+uno::Reference< XOfficeDatabaseDocument > xDocument(mxComponent, 
UNO_QUERY_THROW);
 
-uno::Reference< XConnection > xConnection =
-getConnectionForDocument(xDocument);
+uno::Reference< XConnection > xConnection = 
getConnectionForDocument(xDocument);
 
 setupTestTable(xConnection);
 

core.git: Branch 'libreoffice-24-8' - helpcontent2

[Olivier Hallot (via logerrit)]

 helpcontent2 |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit 0f06d45cd69b17583ca5e601ecb8fb3342f37501
Author: Olivier Hallot 
AuthorDate: Wed Jun 19 21:09:41 2024 -0300
Commit: Gerrit Code Review 
CommitDate: Thu Jun 20 02:09:41 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'libreoffice-24-8'
  to 83da8f2dc58d4fefaecf204ec6fc54281c65213a
  - tdf#161638 Update Calc View options Help page

+ Added images of visual features
+ reordered dialog section description

Change-Id: I8cb7158b7e88b55f686372b8e790e0165a25d8cc
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169232
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 
(cherry picked from commit ba5e40d637b9dac0575f982d48666bb45423c628)
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169138

diff --git a/helpcontent2 b/helpcontent2
index 0a850057c2fb..83da8f2dc58d 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit 0a850057c2fba0fe7e3743a507e92a929562a0d4
+Subproject commit 83da8f2dc58d4fefaecf204ec6fc54281c65213a

help.git: Branch 'libreoffice-24-8' - Package_html_media.mk source/media source/text

[Olivier Hallot (via logerrit)]

 Package_html_media.mk|8 
 source/media/helpimg/scalc/anchor.png|binary
 source/media/helpimg/scalc/comment_indicator.png |binary
 source/media/helpimg/scalc/cursor_system.png |binary
 source/media/helpimg/scalc/cursor_themed.png |binary
 source/media/helpimg/scalc/edit_highlight.png|binary
 source/media/helpimg/scalc/formula_indicator.png |binary
 source/media/helpimg/scalc/refs_in_color.png |binary
 source/media/helpimg/scalc/row_col_highlight.png |binary
 source/text/shared/optionen/01060100.xhp |  218 ---
 10 files changed, 122 insertions(+), 104 deletions(-)

New commits:
commit 83da8f2dc58d4fefaecf204ec6fc54281c65213a
Author: Olivier Hallot 
AuthorDate: Wed Jun 19 15:57:22 2024 -0300
Commit: Olivier Hallot 
CommitDate: Thu Jun 20 02:09:40 2024 +0200

tdf#161638 Update Calc View options Help page

+ Added images of visual features
+ reordered dialog section description

Change-Id: I8cb7158b7e88b55f686372b8e790e0165a25d8cc
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169232
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 
(cherry picked from commit ba5e40d637b9dac0575f982d48666bb45423c628)
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169138

diff --git a/Package_html_media.mk b/Package_html_media.mk
index 45eb612a5f..a9153bcd55 100644
--- a/Package_html_media.mk
+++ b/Package_html_media.mk
@@ -100,6 +100,14 @@ $(eval $(call 
gb_Package_add_files_with_dir,helpcontent2_html_media,$(LIBO_SHARE
 helpimg/scalc/IMSEC_equation.svg \
 helpimg/scalc/IMSECH_equation.svg \
 helpimg/scalc/IMTAN_equation.svg \
+helpimg/scalc/comment_indicator.png \
+helpimg/scalc/formula_indicator.png \
+helpimg/scalc/edit_highlight.png \
+helpimg/scalc/anchor.png \
+helpimg/scalc/row_col_highlight.png \
+helpimg/scalc/cursor_themed.png \
+helpimg/scalc/cursor_system.png \
+helpimg/scalc/refs_in_color.png \
 helpimg/sc_func_opt01.svg \
 helpimg/sd_drawing_with_comment.png \
 helpimg/sd_PresenterConsole01.png \
diff --git a/source/media/helpimg/scalc/anchor.png 
b/source/media/helpimg/scalc/anchor.png
new file mode 100644
index 00..a67c4bb789
Binary files /dev/null and b/source/media/helpimg/scalc/anchor.png differ
diff --git a/source/media/helpimg/scalc/comment_indicator.png 
b/source/media/helpimg/scalc/comment_indicator.png
new file mode 100644
index 00..04ea540469
Binary files /dev/null and b/source/media/helpimg/scalc/comment_indicator.png 
differ
diff --git a/source/media/helpimg/scalc/cursor_system.png 
b/source/media/helpimg/scalc/cursor_system.png
new file mode 100644
index 00..a825fd16f4
Binary files /dev/null and b/source/media/helpimg/scalc/cursor_system.png differ
diff --git a/source/media/helpimg/scalc/cursor_themed.png 
b/source/media/helpimg/scalc/cursor_themed.png
new file mode 100644
index 00..c9c512c326
Binary files /dev/null and b/source/media/helpimg/scalc/cursor_themed.png differ
diff --git a/source/media/helpimg/scalc/edit_highlight.png 
b/source/media/helpimg/scalc/edit_highlight.png
new file mode 100644
index 00..c7ce224837
Binary files /dev/null and b/source/media/helpimg/scalc/edit_highlight.png 
differ
diff --git a/source/media/helpimg/scalc/formula_indicator.png 
b/source/media/helpimg/scalc/formula_indicator.png
new file mode 100644
index 00..034c8ae06f
Binary files /dev/null and b/source/media/helpimg/scalc/formula_indicator.png 
differ
diff --git a/source/media/helpimg/scalc/refs_in_color.png 
b/source/media/helpimg/scalc/refs_in_color.png
new file mode 100644
index 00..245bf27e40
Binary files /dev/null and b/source/media/helpimg/scalc/refs_in_color.png differ
diff --git a/source/media/helpimg/scalc/row_col_highlight.png 
b/source/media/helpimg/scalc/row_col_highlight.png
new file mode 100644
index 00..c445e2e536
Binary files /dev/null and b/source/media/helpimg/scalc/row_col_highlight.png 
differ
diff --git a/source/text/shared/optionen/01060100.xhp 
b/source/text/shared/optionen/01060100.xhp
index 4bf85a9f0b..c6f110718a 100644
--- a/source/text/shared/optionen/01060100.xhp
+++ b/source/text/shared/optionen/01060100.xhp
@@ -57,140 +57,150 @@
   cells;formula hint
   displaying; comment authorship
   pointer;themed
-  pointer;system  
+  pointer;system
   find all;displaying search summary
   cells;highlighting
-
 
 
 
 View
 Defines which elements of the 
%PRODUCTNAME Calc main window are displayed. 
You can also show or hide highlighting of values in tables.
 
-  
-
-
-
-Choose 
Tools - Options - %PRODUCTNAME Calc - View.
-
-Press 
Alt+F12 then choose  %PRODUCTNAME Calc - 
View.
-
-Visual aids
-Specifies which lines are 
displayed.
-
-
- Grid lines
- Specifies when grid 
lines will be displayed. Default is to display grid lines only on cells that do 

core.git: helpcontent2

[Olivier Hallot (via logerrit)]

 helpcontent2 |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit cc33a630ee6eb9b9f47501c3c0cf9dbacbc214a6
Author: Olivier Hallot 
AuthorDate: Wed Jun 19 16:08:48 2024 -0300
Commit: Gerrit Code Review 
CommitDate: Wed Jun 19 21:08:48 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'master'
  to ba5e40d637b9dac0575f982d48666bb45423c628
  - tdf#161638 Update Calc View options Help page

+ Added images of visual features
+ reordered dialog section description

Change-Id: I8cb7158b7e88b55f686372b8e790e0165a25d8cc
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169232
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/helpcontent2 b/helpcontent2
index e6ef90ff763e..ba5e40d637b9 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit e6ef90ff763ee24c62f15dd4a312020a04b93655
+Subproject commit ba5e40d637b9dac0575f982d48666bb45423c628

help.git: Package_html_media.mk source/media source/text

[Olivier Hallot (via logerrit)]

 Package_html_media.mk|8 
 source/media/helpimg/scalc/anchor.png|binary
 source/media/helpimg/scalc/comment_indicator.png |binary
 source/media/helpimg/scalc/cursor_system.png |binary
 source/media/helpimg/scalc/cursor_themed.png |binary
 source/media/helpimg/scalc/edit_highlight.png|binary
 source/media/helpimg/scalc/formula_indicator.png |binary
 source/media/helpimg/scalc/refs_in_color.png |binary
 source/media/helpimg/scalc/row_col_highlight.png |binary
 source/text/shared/optionen/01060100.xhp |  218 ---
 10 files changed, 122 insertions(+), 104 deletions(-)

New commits:
commit ba5e40d637b9dac0575f982d48666bb45423c628
Author: Olivier Hallot 
AuthorDate: Wed Jun 19 15:57:22 2024 -0300
Commit: Olivier Hallot 
CommitDate: Wed Jun 19 21:08:48 2024 +0200

tdf#161638 Update Calc View options Help page

+ Added images of visual features
+ reordered dialog section description

Change-Id: I8cb7158b7e88b55f686372b8e790e0165a25d8cc
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169232
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/Package_html_media.mk b/Package_html_media.mk
index 45eb612a5f..a9153bcd55 100644
--- a/Package_html_media.mk
+++ b/Package_html_media.mk
@@ -100,6 +100,14 @@ $(eval $(call 
gb_Package_add_files_with_dir,helpcontent2_html_media,$(LIBO_SHARE
 helpimg/scalc/IMSEC_equation.svg \
 helpimg/scalc/IMSECH_equation.svg \
 helpimg/scalc/IMTAN_equation.svg \
+helpimg/scalc/comment_indicator.png \
+helpimg/scalc/formula_indicator.png \
+helpimg/scalc/edit_highlight.png \
+helpimg/scalc/anchor.png \
+helpimg/scalc/row_col_highlight.png \
+helpimg/scalc/cursor_themed.png \
+helpimg/scalc/cursor_system.png \
+helpimg/scalc/refs_in_color.png \
 helpimg/sc_func_opt01.svg \
 helpimg/sd_drawing_with_comment.png \
 helpimg/sd_PresenterConsole01.png \
diff --git a/source/media/helpimg/scalc/anchor.png 
b/source/media/helpimg/scalc/anchor.png
new file mode 100644
index 00..a67c4bb789
Binary files /dev/null and b/source/media/helpimg/scalc/anchor.png differ
diff --git a/source/media/helpimg/scalc/comment_indicator.png 
b/source/media/helpimg/scalc/comment_indicator.png
new file mode 100644
index 00..04ea540469
Binary files /dev/null and b/source/media/helpimg/scalc/comment_indicator.png 
differ
diff --git a/source/media/helpimg/scalc/cursor_system.png 
b/source/media/helpimg/scalc/cursor_system.png
new file mode 100644
index 00..a825fd16f4
Binary files /dev/null and b/source/media/helpimg/scalc/cursor_system.png differ
diff --git a/source/media/helpimg/scalc/cursor_themed.png 
b/source/media/helpimg/scalc/cursor_themed.png
new file mode 100644
index 00..c9c512c326
Binary files /dev/null and b/source/media/helpimg/scalc/cursor_themed.png differ
diff --git a/source/media/helpimg/scalc/edit_highlight.png 
b/source/media/helpimg/scalc/edit_highlight.png
new file mode 100644
index 00..c7ce224837
Binary files /dev/null and b/source/media/helpimg/scalc/edit_highlight.png 
differ
diff --git a/source/media/helpimg/scalc/formula_indicator.png 
b/source/media/helpimg/scalc/formula_indicator.png
new file mode 100644
index 00..034c8ae06f
Binary files /dev/null and b/source/media/helpimg/scalc/formula_indicator.png 
differ
diff --git a/source/media/helpimg/scalc/refs_in_color.png 
b/source/media/helpimg/scalc/refs_in_color.png
new file mode 100644
index 00..245bf27e40
Binary files /dev/null and b/source/media/helpimg/scalc/refs_in_color.png differ
diff --git a/source/media/helpimg/scalc/row_col_highlight.png 
b/source/media/helpimg/scalc/row_col_highlight.png
new file mode 100644
index 00..c445e2e536
Binary files /dev/null and b/source/media/helpimg/scalc/row_col_highlight.png 
differ
diff --git a/source/text/shared/optionen/01060100.xhp 
b/source/text/shared/optionen/01060100.xhp
index 4bf85a9f0b..c6f110718a 100644
--- a/source/text/shared/optionen/01060100.xhp
+++ b/source/text/shared/optionen/01060100.xhp
@@ -57,140 +57,150 @@
   cells;formula hint
   displaying; comment authorship
   pointer;themed
-  pointer;system  
+  pointer;system
   find all;displaying search summary
   cells;highlighting
-
 
 
 
 View
 Defines which elements of the 
%PRODUCTNAME Calc main window are displayed. 
You can also show or hide highlighting of values in tables.
 
-  
-
-
-
-Choose 
Tools - Options - %PRODUCTNAME Calc - View.
-
-Press 
Alt+F12 then choose  %PRODUCTNAME Calc - 
View.
-
-Visual aids
-Specifies which lines are 
displayed.
-
-
- Grid lines
- Specifies when grid 
lines will be displayed. Default is to display grid lines only on cells that do 
not have a background color. You can choose to also display grid lines on cells 
with background color, or to hide them. For printing, 

core.git: Branch 'libreoffice-24-8' - helpcontent2

[Olivier Hallot (via logerrit)]

 helpcontent2 |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit 2529c1e769670a1277a4df87f5fd296b459578af
Author: Olivier Hallot 
AuthorDate: Wed Jun 19 10:48:06 2024 -0300
Commit: Gerrit Code Review 
CommitDate: Wed Jun 19 15:48:06 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'libreoffice-24-8'
  to 0a850057c2fba0fe7e3743a507e92a929562a0d4
  - tdf#161579 Fix on Save options Help page

Change-Id: I58f37e50d5579b76b2b4b95a885ae2ef9e6856c2
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169126
Reviewed-by: Olivier Hallot 
Tested-by: Jenkins
(cherry picked from commit e6ef90ff763ee24c62f15dd4a312020a04b93655)
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169136

diff --git a/helpcontent2 b/helpcontent2
index 4d5d28094e2a..0a850057c2fb 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit 4d5d28094e2a3ff37d78ea6f0a58615015d663e6
+Subproject commit 0a850057c2fba0fe7e3743a507e92a929562a0d4

help.git: Branch 'libreoffice-24-8' - source/text

[Olivier Hallot (via logerrit)]

 source/text/shared/optionen/01010200.xhp |4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

New commits:
commit 0a850057c2fba0fe7e3743a507e92a929562a0d4
Author: Olivier Hallot 
AuthorDate: Tue Jun 18 17:58:05 2024 -0300
Commit: Olivier Hallot 
CommitDate: Wed Jun 19 15:48:06 2024 +0200

tdf#161579 Fix on Save options Help page

Change-Id: I58f37e50d5579b76b2b4b95a885ae2ef9e6856c2
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169126
Reviewed-by: Olivier Hallot 
Tested-by: Jenkins
(cherry picked from commit e6ef90ff763ee24c62f15dd4a312020a04b93655)
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169136

diff --git a/source/text/shared/optionen/01010200.xhp 
b/source/text/shared/optionen/01010200.xhp
index 22af063a34..496f6c804b 100644
--- a/source/text/shared/optionen/01010200.xhp
+++ b/source/text/shared/optionen/01010200.xhp
@@ -88,8 +88,8 @@
   Specifies the time interval in minutes 
before AutoRecovery information is saved for a document.
 A timer starts for a document when it is 
first modified. AutoRecovery information is saved after the specified time 
(while %PRODUCTNAME is idle). The timer then restarts with the next 
modification in the document.
 
-Automatically save the document too
-  Specifies that %PRODUCTNAME saves all 
modified documents when saving AutoRecovery information. Uses the time interval 
specified in Minutes.
+Automatically save the document instead
+  Specifies that LibreOffice saves the 
modified document itself instead of creating a temporary AutoRecovery version. 
Uses the time interval specified in 
Minutes.
 
 Edit document properties before saving
   Specifies that the Properties 
dialog will appear every time you select the Save As 
command.

core.git: Branch 'libreoffice-24-8' - helpcontent2

[Olivier Hallot (via logerrit)]

 helpcontent2 |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit ca16bbb7fb9f246ea5bf1d0922bb3ed2c55f6d44
Author: Olivier Hallot 
AuthorDate: Wed Jun 19 10:46:51 2024 -0300
Commit: Gerrit Code Review 
CommitDate: Wed Jun 19 15:46:51 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'libreoffice-24-8'
  to 4d5d28094e2a3ff37d78ea6f0a58615015d663e6
  - tdf#161639 Fix macOS command path

+ refactor
+ moved command description above how-to-get
+ added tabbed UI how-to-get for Expert config

Change-Id: I026ef0f1891c18ea50ce187b6fba35dd5a194ac9
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169119
Reviewed-by: Olivier Hallot 
Tested-by: Jenkins
(cherry picked from commit 5d0ae30d7d89219d86d263b1a31d77fb6de0)
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169130

diff --git a/helpcontent2 b/helpcontent2
index 23bbf450933f..4d5d28094e2a 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit 23bbf450933fc8c59507521165d7e1d23a7bcf86
+Subproject commit 4d5d28094e2a3ff37d78ea6f0a58615015d663e6

help.git: Branch 'libreoffice-24-8' - source/text

[Olivier Hallot (via logerrit)]

 source/text/shared/optionen/expertconfig.xhp |   55 +--
 1 file changed, 28 insertions(+), 27 deletions(-)

New commits:
commit 4d5d28094e2a3ff37d78ea6f0a58615015d663e6
Author: Olivier Hallot 
AuthorDate: Tue Jun 18 16:29:18 2024 -0300
Commit: Olivier Hallot 
CommitDate: Wed Jun 19 15:46:50 2024 +0200

tdf#161639 Fix macOS command path

+ refactor
+ moved command description above how-to-get
+ added tabbed UI how-to-get for Expert config

Change-Id: I026ef0f1891c18ea50ce187b6fba35dd5a194ac9
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169119
Reviewed-by: Olivier Hallot 
Tested-by: Jenkins
(cherry picked from commit 5d0ae30d7d89219d86d263b1a31d77fb6de0)
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169130

diff --git a/source/text/shared/optionen/expertconfig.xhp 
b/source/text/shared/optionen/expertconfig.xhp
index 8094a8eb38..2194b678c3 100644
--- a/source/text/shared/optionen/expertconfig.xhp
+++ b/source/text/shared/optionen/expertconfig.xhp
@@ -20,70 +20,71 @@
 
 
   
-Expert Configuration
+Expert Configuration
 /text/shared/optionen/expertconfig.xhp
   
 
 
 
-
-
-
-
+
+
+
+
   expert configuration;setting options
 
-
-
 Expert Configuration
-
+Opens the Expert Configuration dialog 
for advanced settings and configuration of %PRODUCTNAME. The Expert 
Configuration dialog allows user to access hundreds of %PRODUCTNAME 
configuration preferences, and most of them are not available in the user 
interface or in the options dialogs.
+The Expert Configuration dialog lets you 
access, edit and save configuration preferences that can harm your %PRODUCTNAME 
user profile. It can turn the user profile of %PRODUCTNAME unstable, 
inconsistent or even unusable. Proceed only if you know what you are 
doing.
 
-Choose Tools - Options - %PRODUCTNAME - Advanced - 
Open Expert Configuration.
+  
+  Choose %PRODUCTNAME - 
PreferencesTools - 
Options- %PRODUCTNAME - 
Advanced - Open Expert Configuration.
+  
+  On the 
Tools tab click on the Options 
button, then %PRODUCTNAME - Advanced - Open Expert 
Configuration.
 
-Opens the 
Expert Configuration dialog for advanced settings and configuration of 
%PRODUCTNAME. The Expert Configuration dialog allows user to access 
hundreds of %PRODUCTNAME configuration preferences, and most of them are not 
available in the user interface or in the options dialogs.
-The 
Expert Configuration dialog lets you access, edit and save configuration 
preferences that can harm your %PRODUCTNAME user profile. It can turn the user 
profile of %PRODUCTNAME unstable, inconsistent or even unusable. Proceed only 
if you know what you are doing.
-The expert 
configuration does not modify the %PRODUCTNAME system installation in your 
computer.
+
+The expert configuration does not modify the 
%PRODUCTNAME system installation in your computer.
 
 Text search entry area
-Type the 
preference you want to display in the text area. Then click in the 
Search button.
+Type the preference you want to 
display in the text area. Then click in the Search button.
 
 Search button
-Click to 
search your preference text in the Preferences tree.
+Click to search your preference 
text in the Preferences tree.
 
 Preferences tree
-List the 
preferences organized hierarchically in a tree layout. To open the 
branches, double click in the (+) sign. Once the preference is visible in the 
tree, you can edit it.
+List the preferences organized 
hierarchically in a tree layout. To open the branches, double click in 
the (+) sign. Once the preference is visible in the tree, you can edit 
it.
 
 Preference Name
-The 
name of the preference.
+The name of the 
preference.
 
 Property
-Shows 
the name of the property of the preference.
+Shows the name of the 
property of the preference.
 
 Type
-Defines the type of the property. Valid types are:
+Defines the type of 
the property. Valid types are:
 
 
   
-string: Alphanumeric 
values;
+string: Alphanumeric values;
   
   
-long: integer numbers;
+long: integer numbers;
   
   
-boolean: true or false 
values;
+boolean: true or false values;
   
   
-void: properties of type of void cannot be modified.
+void: properties of type of void cannot be modified.
   
 
 Value
-Current value of the property.
+Current value of the 
property.
 
 Edit
-Opens a dialog to edit the 
preference.
-Double-click in the 
preference row to edit current string and long values or toggle boolean 
types.
+Opens a dialog to edit the 
preference.
+Double-click in the preference row to edit 
current string and long values or toggle boolean types.
 
-Reset
-Undo changes done 
so far in this dialog.
+Reset
+Undo changes done so far in this 
dialog.
 
 
 

core.git: Branch 'libreoffice-24-8' - helpcontent2

[Olivier Hallot (via logerrit)]

 helpcontent2 |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit c926a526b6793f0a8f4a2c60df7dda176fd0eb8b
Author: Olivier Hallot 
AuthorDate: Wed Jun 19 10:46:16 2024 -0300
Commit: Gerrit Code Review 
CommitDate: Wed Jun 19 15:46:16 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'libreoffice-24-8'
  to 23bbf450933fc8c59507521165d7e1d23a7bcf86
  - tdf#161579 Further rework on Save options Help page

+ refactor
+ removed outdated screenshot from page
+ deleted outdated screenshot from build
+ change paragraph tag to a tip tag for better reading.

Change-Id: I8ec7330ffe501e7b68ee1ccc9591e45dbe35c05b
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169116
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 
(cherry picked from commit 840359bcb401b17e55a0370a9a0d15890a824abe)
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169109

diff --git a/helpcontent2 b/helpcontent2
index 52572824af33..23bbf450933f 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit 52572824af33a77628c57fe7f6d3e2e19c226b32
+Subproject commit 23bbf450933fc8c59507521165d7e1d23a7bcf86

help.git: Branch 'libreoffice-24-8' - AllLangPackage_html_media_lang.mk Package_html_media.mk source/media source/text

[Olivier Hallot (via logerrit)]

 AllLangPackage_html_media_lang.mk  |1 
 Package_html_media.mk  |1 
 dev/null   |binary
 source/text/shared/00/0406.xhp |9 +-
 source/text/shared/06/optionen_screenshots.xhp |   47 +--
 source/text/shared/optionen/01010200.xhp   |  101 -
 6 files changed, 79 insertions(+), 80 deletions(-)

New commits:
commit 23bbf450933fc8c59507521165d7e1d23a7bcf86
Author: Olivier Hallot 
AuthorDate: Tue Jun 18 15:41:16 2024 -0300
Commit: Olivier Hallot 
CommitDate: Wed Jun 19 15:46:15 2024 +0200

tdf#161579 Further rework on Save options Help page

+ refactor
+ removed outdated screenshot from page
+ deleted outdated screenshot from build
+ change paragraph tag to a tip tag for better reading.

Change-Id: I8ec7330ffe501e7b68ee1ccc9591e45dbe35c05b
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169116
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 
(cherry picked from commit 840359bcb401b17e55a0370a9a0d15890a824abe)
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169109

diff --git a/AllLangPackage_html_media_lang.mk 
b/AllLangPackage_html_media_lang.mk
index cbc5c4c08f..4045569937 100644
--- a/AllLangPackage_html_media_lang.mk
+++ b/AllLangPackage_html_media_lang.mk
@@ -268,7 +268,6 @@ $(foreach lang,$(filter-out en-US,$(gb_HELP_LANGS)),$(eval 
$(call gb_AllLangPack
 screenshots/cui/ui/optfltrpage/$(lang)/OptFltrPage.png \
 screenshots/cui/ui/opthtmlpage/$(lang)/OptHtmlPage.png \
 screenshots/cui/ui/optaccessibilitypage/$(lang)/OptAccessibilityPage.png \
-screenshots/cui/ui/optsavepage/$(lang)/OptSavePage.png \
 screenshots/cui/ui/optadvancedpage/$(lang)/OptAdvancedPage.png \
 screenshots/cui/ui/optasianpage/$(lang)/OptAsianPage.png \
 screenshots/cui/ui/optctlpage/$(lang)/OptCTLPage.png \
diff --git a/Package_html_media.mk b/Package_html_media.mk
index ed10952193..45eb612a5f 100644
--- a/Package_html_media.mk
+++ b/Package_html_media.mk
@@ -438,7 +438,6 @@ $(eval $(call 
gb_Package_add_files_with_dir,helpcontent2_html_media,$(LIBO_SHARE
 screenshots/cui/ui/optfltrpage/OptFltrPage.png \
 screenshots/cui/ui/opthtmlpage/OptHtmlPage.png \
 screenshots/cui/ui/optaccessibilitypage/OptAccessibilityPage.png \
-screenshots/cui/ui/optsavepage/OptSavePage.png \
 screenshots/cui/ui/optadvancedpage/OptAdvancedPage.png \
 screenshots/cui/ui/optasianpage/OptAsianPage.png \
 screenshots/cui/ui/optctlpage/OptCTLPage.png \
diff --git a/source/media/screenshots/cui/ui/optsavepage/OptSavePage.png 
b/source/media/screenshots/cui/ui/optsavepage/OptSavePage.png
deleted file mode 100644
index 76e89fbde8..00
Binary files a/source/media/screenshots/cui/ui/optsavepage/OptSavePage.png and 
/dev/null differ
diff --git a/source/media/screenshots/cui/ui/optsavepage/af/OptSavePage.png 
b/source/media/screenshots/cui/ui/optsavepage/af/OptSavePage.png
deleted file mode 100644
index fd218657c7..00
Binary files a/source/media/screenshots/cui/ui/optsavepage/af/OptSavePage.png 
and /dev/null differ
diff --git a/source/media/screenshots/cui/ui/optsavepage/am/OptSavePage.png 
b/source/media/screenshots/cui/ui/optsavepage/am/OptSavePage.png
deleted file mode 100644
index ec0cb18fb5..00
Binary files a/source/media/screenshots/cui/ui/optsavepage/am/OptSavePage.png 
and /dev/null differ
diff --git a/source/media/screenshots/cui/ui/optsavepage/ar/OptSavePage.png 
b/source/media/screenshots/cui/ui/optsavepage/ar/OptSavePage.png
deleted file mode 100644
index a5cf590d23..00
Binary files a/source/media/screenshots/cui/ui/optsavepage/ar/OptSavePage.png 
and /dev/null differ
diff --git a/source/media/screenshots/cui/ui/optsavepage/as/OptSavePage.png 
b/source/media/screenshots/cui/ui/optsavepage/as/OptSavePage.png
deleted file mode 100644
index f871edae44..00
Binary files a/source/media/screenshots/cui/ui/optsavepage/as/OptSavePage.png 
and /dev/null differ
diff --git a/source/media/screenshots/cui/ui/optsavepage/ast/OptSavePage.png 
b/source/media/screenshots/cui/ui/optsavepage/ast/OptSavePage.png
deleted file mode 100644
index 45e8d1b392..00
Binary files a/source/media/screenshots/cui/ui/optsavepage/ast/OptSavePage.png 
and /dev/null differ
diff --git a/source/media/screenshots/cui/ui/optsavepage/be/OptSavePage.png 
b/source/media/screenshots/cui/ui/optsavepage/be/OptSavePage.png
deleted file mode 100644
index 4ef306787d..00
Binary files a/source/media/screenshots/cui/ui/optsavepage/be/OptSavePage.png 
and /dev/null differ
diff --git a/source/media/screenshots/cui/ui/optsavepage/bg/OptSavePage.png 
b/source/media/screenshots/cui/ui/optsavepage/bg/OptSavePage.png
deleted file mode 100644
index baf75a96e6..00
Binary files a/source/media/screenshots/cui/ui/optsavepage/bg/OptSavePage.png 
and /dev/null differ
diff --git 

core.git: Branch 'libreoffice-24-8' - helpcontent2

[Olivier Hallot (via logerrit)]

 helpcontent2 |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit d5e490f7e9ce14ac4dbf5454a9a409c39c8615b6
Author: Olivier Hallot 
AuthorDate: Wed Jun 19 10:45:50 2024 -0300
Commit: Gerrit Code Review 
CommitDate: Wed Jun 19 15:45:50 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'libreoffice-24-8'
  to 52572824af33a77628c57fe7f6d3e2e19c226b32
  - tdf161612 Precisions for XMATCH function Help page

Change-Id: Id50a01c9c33284124f022540ac51c1f1651848e7
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169007
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 
(cherry picked from commit 9f43bf5caf95051c06f0c08f326f8d864c501d58)
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169102

diff --git a/helpcontent2 b/helpcontent2
index b80910b523d2..52572824af33 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit b80910b523d23afe7d4bb6c59a443eb429003faf
+Subproject commit 52572824af33a77628c57fe7f6d3e2e19c226b32

help.git: Branch 'libreoffice-24-8' - source/text

[Olivier Hallot (via logerrit)]

 source/text/scalc/01/common_func.xhp  |2 +-
 source/text/scalc/01/ful_func.xhp |2 +-
 source/text/scalc/01/func_xlookup.xhp |6 +++---
 source/text/scalc/01/func_xmatch.xhp  |   18 +-
 4 files changed, 22 insertions(+), 6 deletions(-)

New commits:
commit 52572824af33a77628c57fe7f6d3e2e19c226b32
Author: Olivier Hallot 
AuthorDate: Mon Jun 17 10:06:50 2024 -0300
Commit: Olivier Hallot 
CommitDate: Wed Jun 19 15:45:50 2024 +0200

tdf161612 Precisions for XMATCH function Help page

Change-Id: Id50a01c9c33284124f022540ac51c1f1651848e7
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169007
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 
(cherry picked from commit 9f43bf5caf95051c06f0c08f326f8d864c501d58)
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169102

diff --git a/source/text/scalc/01/common_func.xhp 
b/source/text/scalc/01/common_func.xhp
index 4a3ac7a323..1d8fb882e4 100644
--- a/source/text/scalc/01/common_func.xhp
+++ b/source/text/scalc/01/common_func.xhp
@@ -37,7 +37,7 @@
 This function ignores any text or 
empty cell within a data range. If you suspect wrong results from this 
function, look for text in the data ranges. To highlight text contents in a 
data range, use the value 
highlighting feature.
 
 
-Any of the optional arguments can be 
omitted. An optional argument is required to be preceded by the preceding 
separators.
+Any of the optional arguments can be 
omitted. An optional argument requires all preceding separators to be 
present.
 
 
 
diff --git a/source/text/scalc/01/ful_func.xhp 
b/source/text/scalc/01/ful_func.xhp
index c31872347b..a2003e7a66 100644
--- a/source/text/scalc/01/ful_func.xhp
+++ b/source/text/scalc/01/ful_func.xhp
@@ -94,7 +94,7 @@
 This function 
is always recalculated whenever a recalculation occurs.
 
 
-  The function is always case 
insensitive, independent from the setting of Case sensitive 
checkbox in %PRODUCTNAME - 
PreferencesTools - 
Options - %PRODUCTNAME Calc - 
Calculate.
+  The function is always case 
insensitive, independent from the setting of Case sensitive 
checkbox in %PRODUCTNAME - 
PreferencesTools - 
Options - %PRODUCTNAME Calc - 
Calculate. You can however, use the mode modifier 
(?-i) in regular 
expressions to force search for a case-sensitive match.
 
 
 
diff --git a/source/text/scalc/01/func_xlookup.xhp 
b/source/text/scalc/01/func_xlookup.xhp
index c3095969ef..d141816110 100644
--- a/source/text/scalc/01/func_xlookup.xhp
+++ b/source/text/scalc/01/func_xlookup.xhp
@@ -25,7 +25,7 @@
 XLOOKUP
 Searches for a 
value in an array and returns a reference to a cell or range of 
cells.
 
-XLOOKUP function is a 
modern and flexible replacement for older functions like VLOOKUP, HLOOKUP, and LOOKUP. XLOOKUP supports 
approximate and exact matching, wildcards (* ?) for partial matches, and 
lookups in vertical or horizontal ranges. XLOOKUP can perform a reverse search 
and offers a fast binary search option when working with large 
datasets.
+XLOOKUP function is a 
modern and flexible replacement for older functions like VLOOKUP, HLOOKUP, and LOOKUP. XLOOKUP supports 
approximate and exact matching, wildcards (* ?) or regular expressions for 
partial matches, and lookups in vertical or horizontal ranges. XLOOKUP can 
perform a reverse search and offers a fast binary search option when working 
with large datasets.
 
 
 XLOOKUP( [Lookup] ; Array ; 
Return [ ; [ NotFound ] [ ; [MatchType] [ ; SearchMode ] ] ] )
@@ -49,7 +49,7 @@
 1: 
attempt exact match. If Lookup value is not found, then return the 
next larger item.
 
 
-2: 
a wildcard match where 
characters *, ?, and ~ have special meanings.
+2: 
a wildcard match where 
characters *, ?, and ~ have special meanings, or a match using regular expressions.
 
 
 
@@ -71,8 +71,8 @@
 -2: 
binary search that relies on Array being sorted in descending 
order. If not sorted, invalid results will be returned.
 
 
+MatchType value 2 cannot 
be combined with binary search (SearchMode value 2 or 
-2).
 
-
 
 
 
diff --git a/source/text/scalc/01/func_xmatch.xhp 
b/source/text/scalc/01/func_xmatch.xhp
index 6595230a37..6e3a734dd8 100644
--- a/source/text/scalc/01/func_xmatch.xhp
+++ b/source/text/scalc/01/func_xmatch.xhp
@@ -31,9 +31,25 @@
 XMATCH(Lookup; Array [; 
MatchType [; SearchMode ] ] )
 Lookup: 
The value of any type to search for in Array.
 Array: is 
the reference of the array or range to search.
-
+
+MatchType: 
(optional) specifies the match type. Values can be:
+
+
+0: 
exact match (default). If Lookup value is not found, then return 
the #N/A error.
+
+
+-1: 
attempt exact match. If Lookup value is not found, then return the 
next smaller item.
+
+
+1: 
attempt exact match. If Lookup value is not found, then return the 
next larger item.
+   

core.git: Branch 'libreoffice-24-8' - helpcontent2

[Olivier Hallot (via logerrit)]

 helpcontent2 |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit 21b7fd309f204d8c0faf0b71eb1f925fa64a6c52
Author: Olivier Hallot 
AuthorDate: Wed Jun 19 10:45:26 2024 -0300
Commit: Gerrit Code Review 
CommitDate: Wed Jun 19 15:45:26 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'libreoffice-24-8'
  to b80910b523d23afe7d4bb6c59a443eb429003faf
  - tdf#154226 Add link to LO books on Help pages

Added a row of icons on the footer of the Help pages.

Change-Id: I40e1e697e5defa21ba3fb6f93198489ac401924b
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169033
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 
(cherry picked from commit 4c8b04c8d9d3a2367bb3205b852f2d7b75082f90)
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169101

diff --git a/helpcontent2 b/helpcontent2
index 8e4ae81a9af0..b80910b523d2 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit 8e4ae81a9af01da98b6aab160178f7f4e5b08dfe
+Subproject commit b80910b523d23afe7d4bb6c59a443eb429003faf

help.git: Branch 'libreoffice-24-8' - help3xsl/online_transform.xsl source/text

[Olivier Hallot (via logerrit)]

 help3xsl/online_transform.xsl   |   11 +++
 source/text/shared/help/browserhelp.xhp |1 +
 2 files changed, 12 insertions(+)

New commits:
commit b80910b523d23afe7d4bb6c59a443eb429003faf
Author: Olivier Hallot 
AuthorDate: Mon Jun 17 12:21:49 2024 -0300
Commit: Olivier Hallot 
CommitDate: Wed Jun 19 15:45:26 2024 +0200

tdf#154226 Add link to LO books on Help pages

Added a row of icons on the footer of the Help pages.

Change-Id: I40e1e697e5defa21ba3fb6f93198489ac401924b
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169033
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 
(cherry picked from commit 4c8b04c8d9d3a2367bb3205b852f2d7b75082f90)
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169101

diff --git a/help3xsl/online_transform.xsl b/help3xsl/online_transform.xsl
index b2f7adde01..ec47d60aa4 100644
--- a/help3xsl/online_transform.xsl
+++ b/help3xsl/online_transform.xsl
@@ -113,6 +113,7 @@
 
 
 
+
 

core.git: helpcontent2

[Olivier Hallot (via logerrit)]

 helpcontent2 |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit b344a611d7636d4fdf8cf221fb7b8bcfdcdb6824
Author: Olivier Hallot 
AuthorDate: Wed Jun 19 09:43:18 2024 -0300
Commit: Gerrit Code Review 
CommitDate: Wed Jun 19 14:43:18 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'master'
  to e6ef90ff763ee24c62f15dd4a312020a04b93655
  - tdf#161579 Fix on Save options Help page

Change-Id: I58f37e50d5579b76b2b4b95a885ae2ef9e6856c2
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169126
Reviewed-by: Olivier Hallot 
Tested-by: Jenkins

diff --git a/helpcontent2 b/helpcontent2
index 5d0ae30d..e6ef90ff763e 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit 5d0ae30d7d89219d86d263b1a31d77fb6de0
+Subproject commit e6ef90ff763ee24c62f15dd4a312020a04b93655

help.git: source/text

[Olivier Hallot (via logerrit)]

 source/text/shared/optionen/01010200.xhp |4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

New commits:
commit e6ef90ff763ee24c62f15dd4a312020a04b93655
Author: Olivier Hallot 
AuthorDate: Tue Jun 18 17:58:05 2024 -0300
Commit: Olivier Hallot 
CommitDate: Wed Jun 19 14:43:18 2024 +0200

tdf#161579 Fix on Save options Help page

Change-Id: I58f37e50d5579b76b2b4b95a885ae2ef9e6856c2
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169126
Reviewed-by: Olivier Hallot 
Tested-by: Jenkins

diff --git a/source/text/shared/optionen/01010200.xhp 
b/source/text/shared/optionen/01010200.xhp
index 22af063a34..496f6c804b 100644
--- a/source/text/shared/optionen/01010200.xhp
+++ b/source/text/shared/optionen/01010200.xhp
@@ -88,8 +88,8 @@
   Specifies the time interval in minutes 
before AutoRecovery information is saved for a document.
 A timer starts for a document when it is 
first modified. AutoRecovery information is saved after the specified time 
(while %PRODUCTNAME is idle). The timer then restarts with the next 
modification in the document.
 
-Automatically save the document too
-  Specifies that %PRODUCTNAME saves all 
modified documents when saving AutoRecovery information. Uses the time interval 
specified in Minutes.
+Automatically save the document instead
+  Specifies that LibreOffice saves the 
modified document itself instead of creating a temporary AutoRecovery version. 
Uses the time interval specified in 
Minutes.
 
 Edit document properties before saving
   Specifies that the Properties 
dialog will appear every time you select the Save As 
command.

core.git: helpcontent2

[Olivier Hallot (via logerrit)]

 helpcontent2 |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit 3909a1186cf423105c30c91136f131daf66e18c6
Author: Olivier Hallot 
AuthorDate: Tue Jun 18 17:40:23 2024 -0300
Commit: Gerrit Code Review 
CommitDate: Tue Jun 18 22:40:23 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'master'
  to 5d0ae30d7d89219d86d263b1a31d77fb6de0
  - tdf#191639 Fix macOS command path

+ refactor
+ moved command description above how-to-get
+ added tabbed UI how-to-get for Expert config

Change-Id: I026ef0f1891c18ea50ce187b6fba35dd5a194ac9
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169119
Reviewed-by: Olivier Hallot 
Tested-by: Jenkins

diff --git a/helpcontent2 b/helpcontent2
index 840359bcb401..5d0ae30d 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit 840359bcb401b17e55a0370a9a0d15890a824abe
+Subproject commit 5d0ae30d7d89219d86d263b1a31d77fb6de0

help.git: source/text

[Olivier Hallot (via logerrit)]

 source/text/shared/optionen/expertconfig.xhp |   55 +--
 1 file changed, 28 insertions(+), 27 deletions(-)

New commits:
commit 5d0ae30d7d89219d86d263b1a31d77fb6de0
Author: Olivier Hallot 
AuthorDate: Tue Jun 18 16:29:18 2024 -0300
Commit: Olivier Hallot 
CommitDate: Tue Jun 18 22:40:23 2024 +0200

tdf#191639 Fix macOS command path

+ refactor
+ moved command description above how-to-get
+ added tabbed UI how-to-get for Expert config

Change-Id: I026ef0f1891c18ea50ce187b6fba35dd5a194ac9
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169119
Reviewed-by: Olivier Hallot 
Tested-by: Jenkins

diff --git a/source/text/shared/optionen/expertconfig.xhp 
b/source/text/shared/optionen/expertconfig.xhp
index 8094a8eb38..2194b678c3 100644
--- a/source/text/shared/optionen/expertconfig.xhp
+++ b/source/text/shared/optionen/expertconfig.xhp
@@ -20,70 +20,71 @@
 
 
   
-Expert Configuration
+Expert Configuration
 /text/shared/optionen/expertconfig.xhp
   
 
 
 
-
-
-
-
+
+
+
+
   expert configuration;setting options
 
-
-
 Expert Configuration
-
+Opens the Expert Configuration dialog 
for advanced settings and configuration of %PRODUCTNAME. The Expert 
Configuration dialog allows user to access hundreds of %PRODUCTNAME 
configuration preferences, and most of them are not available in the user 
interface or in the options dialogs.
+The Expert Configuration dialog lets you 
access, edit and save configuration preferences that can harm your %PRODUCTNAME 
user profile. It can turn the user profile of %PRODUCTNAME unstable, 
inconsistent or even unusable. Proceed only if you know what you are 
doing.
 
-Choose Tools - Options - %PRODUCTNAME - Advanced - 
Open Expert Configuration.
+  
+  Choose %PRODUCTNAME - 
PreferencesTools - 
Options- %PRODUCTNAME - 
Advanced - Open Expert Configuration.
+  
+  On the 
Tools tab click on the Options 
button, then %PRODUCTNAME - Advanced - Open Expert 
Configuration.
 
-Opens the 
Expert Configuration dialog for advanced settings and configuration of 
%PRODUCTNAME. The Expert Configuration dialog allows user to access 
hundreds of %PRODUCTNAME configuration preferences, and most of them are not 
available in the user interface or in the options dialogs.
-The 
Expert Configuration dialog lets you access, edit and save configuration 
preferences that can harm your %PRODUCTNAME user profile. It can turn the user 
profile of %PRODUCTNAME unstable, inconsistent or even unusable. Proceed only 
if you know what you are doing.
-The expert 
configuration does not modify the %PRODUCTNAME system installation in your 
computer.
+
+The expert configuration does not modify the 
%PRODUCTNAME system installation in your computer.
 
 Text search entry area
-Type the 
preference you want to display in the text area. Then click in the 
Search button.
+Type the preference you want to 
display in the text area. Then click in the Search button.
 
 Search button
-Click to 
search your preference text in the Preferences tree.
+Click to search your preference 
text in the Preferences tree.
 
 Preferences tree
-List the 
preferences organized hierarchically in a tree layout. To open the 
branches, double click in the (+) sign. Once the preference is visible in the 
tree, you can edit it.
+List the preferences organized 
hierarchically in a tree layout. To open the branches, double click in 
the (+) sign. Once the preference is visible in the tree, you can edit 
it.
 
 Preference Name
-The 
name of the preference.
+The name of the 
preference.
 
 Property
-Shows 
the name of the property of the preference.
+Shows the name of the 
property of the preference.
 
 Type
-Defines the type of the property. Valid types are:
+Defines the type of 
the property. Valid types are:
 
 
   
-string: Alphanumeric 
values;
+string: Alphanumeric values;
   
   
-long: integer numbers;
+long: integer numbers;
   
   
-boolean: true or false 
values;
+boolean: true or false values;
   
   
-void: properties of type of void cannot be modified.
+void: properties of type of void cannot be modified.
   
 
 Value
-Current value of the property.
+Current value of the 
property.
 
 Edit
-Opens a dialog to edit the 
preference.
-Double-click in the 
preference row to edit current string and long values or toggle boolean 
types.
+Opens a dialog to edit the 
preference.
+Double-click in the preference row to edit 
current string and long values or toggle boolean types.
 
-Reset
-Undo changes done 
so far in this dialog.
+Reset
+Undo changes done so far in this 
dialog.
 
 
 

core.git: helpcontent2

[Olivier Hallot (via logerrit)]

 helpcontent2 |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit 996558b30209c8c43f13e247d35204bee1b48627
Author: Olivier Hallot 
AuthorDate: Tue Jun 18 17:39:15 2024 -0300
Commit: Gerrit Code Review 
CommitDate: Tue Jun 18 22:39:15 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'master'
  to 840359bcb401b17e55a0370a9a0d15890a824abe
  - tdf#161579 Further rework on Save options Help page

+ refactor
+ removed outdated screenshot from page
+ deleted outdated screenshot from build
+ change paragraph tag to a tip tag for better reading.

Change-Id: I8ec7330ffe501e7b68ee1ccc9591e45dbe35c05b
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169116
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/helpcontent2 b/helpcontent2
index 2f70c8aa2a70..840359bcb401 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit 2f70c8aa2a700cad40257f020998c8dce5ed3dda
+Subproject commit 840359bcb401b17e55a0370a9a0d15890a824abe

help.git: AllLangPackage_html_media_lang.mk Package_html_media.mk source/media source/text

[Olivier Hallot (via logerrit)]

 AllLangPackage_html_media_lang.mk  |1 
 Package_html_media.mk  |1 
 dev/null   |binary
 source/text/shared/00/0406.xhp |9 +-
 source/text/shared/06/optionen_screenshots.xhp |   47 +--
 source/text/shared/optionen/01010200.xhp   |  101 -
 6 files changed, 79 insertions(+), 80 deletions(-)

New commits:
commit 840359bcb401b17e55a0370a9a0d15890a824abe
Author: Olivier Hallot 
AuthorDate: Tue Jun 18 15:41:16 2024 -0300
Commit: Olivier Hallot 
CommitDate: Tue Jun 18 22:39:15 2024 +0200

tdf#161579 Further rework on Save options Help page

+ refactor
+ removed outdated screenshot from page
+ deleted outdated screenshot from build
+ change paragraph tag to a tip tag for better reading.

Change-Id: I8ec7330ffe501e7b68ee1ccc9591e45dbe35c05b
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169116
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/AllLangPackage_html_media_lang.mk 
b/AllLangPackage_html_media_lang.mk
index cbc5c4c08f..4045569937 100644
--- a/AllLangPackage_html_media_lang.mk
+++ b/AllLangPackage_html_media_lang.mk
@@ -268,7 +268,6 @@ $(foreach lang,$(filter-out en-US,$(gb_HELP_LANGS)),$(eval 
$(call gb_AllLangPack
 screenshots/cui/ui/optfltrpage/$(lang)/OptFltrPage.png \
 screenshots/cui/ui/opthtmlpage/$(lang)/OptHtmlPage.png \
 screenshots/cui/ui/optaccessibilitypage/$(lang)/OptAccessibilityPage.png \
-screenshots/cui/ui/optsavepage/$(lang)/OptSavePage.png \
 screenshots/cui/ui/optadvancedpage/$(lang)/OptAdvancedPage.png \
 screenshots/cui/ui/optasianpage/$(lang)/OptAsianPage.png \
 screenshots/cui/ui/optctlpage/$(lang)/OptCTLPage.png \
diff --git a/Package_html_media.mk b/Package_html_media.mk
index ed10952193..45eb612a5f 100644
--- a/Package_html_media.mk
+++ b/Package_html_media.mk
@@ -438,7 +438,6 @@ $(eval $(call 
gb_Package_add_files_with_dir,helpcontent2_html_media,$(LIBO_SHARE
 screenshots/cui/ui/optfltrpage/OptFltrPage.png \
 screenshots/cui/ui/opthtmlpage/OptHtmlPage.png \
 screenshots/cui/ui/optaccessibilitypage/OptAccessibilityPage.png \
-screenshots/cui/ui/optsavepage/OptSavePage.png \
 screenshots/cui/ui/optadvancedpage/OptAdvancedPage.png \
 screenshots/cui/ui/optasianpage/OptAsianPage.png \
 screenshots/cui/ui/optctlpage/OptCTLPage.png \
diff --git a/source/media/screenshots/cui/ui/optsavepage/OptSavePage.png 
b/source/media/screenshots/cui/ui/optsavepage/OptSavePage.png
deleted file mode 100644
index 76e89fbde8..00
Binary files a/source/media/screenshots/cui/ui/optsavepage/OptSavePage.png and 
/dev/null differ
diff --git a/source/media/screenshots/cui/ui/optsavepage/af/OptSavePage.png 
b/source/media/screenshots/cui/ui/optsavepage/af/OptSavePage.png
deleted file mode 100644
index fd218657c7..00
Binary files a/source/media/screenshots/cui/ui/optsavepage/af/OptSavePage.png 
and /dev/null differ
diff --git a/source/media/screenshots/cui/ui/optsavepage/am/OptSavePage.png 
b/source/media/screenshots/cui/ui/optsavepage/am/OptSavePage.png
deleted file mode 100644
index ec0cb18fb5..00
Binary files a/source/media/screenshots/cui/ui/optsavepage/am/OptSavePage.png 
and /dev/null differ
diff --git a/source/media/screenshots/cui/ui/optsavepage/ar/OptSavePage.png 
b/source/media/screenshots/cui/ui/optsavepage/ar/OptSavePage.png
deleted file mode 100644
index a5cf590d23..00
Binary files a/source/media/screenshots/cui/ui/optsavepage/ar/OptSavePage.png 
and /dev/null differ
diff --git a/source/media/screenshots/cui/ui/optsavepage/as/OptSavePage.png 
b/source/media/screenshots/cui/ui/optsavepage/as/OptSavePage.png
deleted file mode 100644
index f871edae44..00
Binary files a/source/media/screenshots/cui/ui/optsavepage/as/OptSavePage.png 
and /dev/null differ
diff --git a/source/media/screenshots/cui/ui/optsavepage/ast/OptSavePage.png 
b/source/media/screenshots/cui/ui/optsavepage/ast/OptSavePage.png
deleted file mode 100644
index 45e8d1b392..00
Binary files a/source/media/screenshots/cui/ui/optsavepage/ast/OptSavePage.png 
and /dev/null differ
diff --git a/source/media/screenshots/cui/ui/optsavepage/be/OptSavePage.png 
b/source/media/screenshots/cui/ui/optsavepage/be/OptSavePage.png
deleted file mode 100644
index 4ef306787d..00
Binary files a/source/media/screenshots/cui/ui/optsavepage/be/OptSavePage.png 
and /dev/null differ
diff --git a/source/media/screenshots/cui/ui/optsavepage/bg/OptSavePage.png 
b/source/media/screenshots/cui/ui/optsavepage/bg/OptSavePage.png
deleted file mode 100644
index baf75a96e6..00
Binary files a/source/media/screenshots/cui/ui/optsavepage/bg/OptSavePage.png 
and /dev/null differ
diff --git a/source/media/screenshots/cui/ui/optsavepage/bn-IN/OptSavePage.png 
b/source/media/screenshots/cui/ui/optsavepage/bn-IN/OptSavePage.png
deleted file mode 100644
index 

core.git: helpcontent2

[Olivier Hallot (via logerrit)]

 helpcontent2 |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit d399fad19d002e05a19f0acf069ae9ee1364e32a
Author: Olivier Hallot 
AuthorDate: Mon Jun 17 17:36:57 2024 -0300
Commit: Gerrit Code Review 
CommitDate: Mon Jun 17 22:36:57 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'master'
  to 4c8b04c8d9d3a2367bb3205b852f2d7b75082f90
  - tdf#154226 Add link to LO books on Help pages

Added a row of icons on the footer of the Help pages.

Change-Id: I40e1e697e5defa21ba3fb6f93198489ac401924b
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169033
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/helpcontent2 b/helpcontent2
index 9f43bf5caf95..4c8b04c8d9d3 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit 9f43bf5caf95051c06f0c08f326f8d864c501d58
+Subproject commit 4c8b04c8d9d3a2367bb3205b852f2d7b75082f90

help.git: help3xsl/online_transform.xsl source/text

[Olivier Hallot (via logerrit)]

 help3xsl/online_transform.xsl   |   11 +++
 source/text/shared/help/browserhelp.xhp |1 +
 2 files changed, 12 insertions(+)

New commits:
commit 4c8b04c8d9d3a2367bb3205b852f2d7b75082f90
Author: Olivier Hallot 
AuthorDate: Mon Jun 17 12:21:49 2024 -0300
Commit: Olivier Hallot 
CommitDate: Mon Jun 17 22:36:57 2024 +0200

tdf#154226 Add link to LO books on Help pages

Added a row of icons on the footer of the Help pages.

Change-Id: I40e1e697e5defa21ba3fb6f93198489ac401924b
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169033
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/help3xsl/online_transform.xsl b/help3xsl/online_transform.xsl
index b2f7adde01..ec47d60aa4 100644
--- a/help3xsl/online_transform.xsl
+++ b/help3xsl/online_transform.xsl
@@ -113,6 +113,7 @@
 
 
 
+
 

core.git: helpcontent2

[Olivier Hallot (via logerrit)]

 helpcontent2 |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit dbcb204bd00a91f243fce8bcd03ddf4dfc4d4298
Author: Olivier Hallot 
AuthorDate: Mon Jun 17 17:35:41 2024 -0300
Commit: Gerrit Code Review 
CommitDate: Mon Jun 17 22:35:41 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'master'
  to 9f43bf5caf95051c06f0c08f326f8d864c501d58
  - tdf161612 Precisions for XMATCH function Help page

Change-Id: Id50a01c9c33284124f022540ac51c1f1651848e7
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169007
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/helpcontent2 b/helpcontent2
index 40ce7008376b..9f43bf5caf95 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit 40ce7008376b0dd3cf9e427cf88385386aaafc73
+Subproject commit 9f43bf5caf95051c06f0c08f326f8d864c501d58

help.git: source/text

[Olivier Hallot (via logerrit)]

 source/text/scalc/01/common_func.xhp  |2 +-
 source/text/scalc/01/ful_func.xhp |2 +-
 source/text/scalc/01/func_xlookup.xhp |6 +++---
 source/text/scalc/01/func_xmatch.xhp  |   18 +-
 4 files changed, 22 insertions(+), 6 deletions(-)

New commits:
commit 9f43bf5caf95051c06f0c08f326f8d864c501d58
Author: Olivier Hallot 
AuthorDate: Mon Jun 17 10:06:50 2024 -0300
Commit: Olivier Hallot 
CommitDate: Mon Jun 17 22:35:40 2024 +0200

tdf161612 Precisions for XMATCH function Help page

Change-Id: Id50a01c9c33284124f022540ac51c1f1651848e7
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169007
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/source/text/scalc/01/common_func.xhp 
b/source/text/scalc/01/common_func.xhp
index 4a3ac7a323..1d8fb882e4 100644
--- a/source/text/scalc/01/common_func.xhp
+++ b/source/text/scalc/01/common_func.xhp
@@ -37,7 +37,7 @@
 This function ignores any text or 
empty cell within a data range. If you suspect wrong results from this 
function, look for text in the data ranges. To highlight text contents in a 
data range, use the value 
highlighting feature.
 
 
-Any of the optional arguments can be 
omitted. An optional argument is required to be preceded by the preceding 
separators.
+Any of the optional arguments can be 
omitted. An optional argument requires all preceding separators to be 
present.
 
 
 
diff --git a/source/text/scalc/01/ful_func.xhp 
b/source/text/scalc/01/ful_func.xhp
index c31872347b..a2003e7a66 100644
--- a/source/text/scalc/01/ful_func.xhp
+++ b/source/text/scalc/01/ful_func.xhp
@@ -94,7 +94,7 @@
 This function 
is always recalculated whenever a recalculation occurs.
 
 
-  The function is always case 
insensitive, independent from the setting of Case sensitive 
checkbox in %PRODUCTNAME - 
PreferencesTools - 
Options - %PRODUCTNAME Calc - 
Calculate.
+  The function is always case 
insensitive, independent from the setting of Case sensitive 
checkbox in %PRODUCTNAME - 
PreferencesTools - 
Options - %PRODUCTNAME Calc - 
Calculate. You can however, use the mode modifier 
(?-i) in regular 
expressions to force search for a case-sensitive match.
 
 
 
diff --git a/source/text/scalc/01/func_xlookup.xhp 
b/source/text/scalc/01/func_xlookup.xhp
index c3095969ef..d141816110 100644
--- a/source/text/scalc/01/func_xlookup.xhp
+++ b/source/text/scalc/01/func_xlookup.xhp
@@ -25,7 +25,7 @@
 XLOOKUP
 Searches for a 
value in an array and returns a reference to a cell or range of 
cells.
 
-XLOOKUP function is a 
modern and flexible replacement for older functions like VLOOKUP, HLOOKUP, and LOOKUP. XLOOKUP supports 
approximate and exact matching, wildcards (* ?) for partial matches, and 
lookups in vertical or horizontal ranges. XLOOKUP can perform a reverse search 
and offers a fast binary search option when working with large 
datasets.
+XLOOKUP function is a 
modern and flexible replacement for older functions like VLOOKUP, HLOOKUP, and LOOKUP. XLOOKUP supports 
approximate and exact matching, wildcards (* ?) or regular expressions for 
partial matches, and lookups in vertical or horizontal ranges. XLOOKUP can 
perform a reverse search and offers a fast binary search option when working 
with large datasets.
 
 
 XLOOKUP( [Lookup] ; Array ; 
Return [ ; [ NotFound ] [ ; [MatchType] [ ; SearchMode ] ] ] )
@@ -49,7 +49,7 @@
 1: 
attempt exact match. If Lookup value is not found, then return the 
next larger item.
 
 
-2: 
a wildcard match where 
characters *, ?, and ~ have special meanings.
+2: 
a wildcard match where 
characters *, ?, and ~ have special meanings, or a match using regular expressions.
 
 
 
@@ -71,8 +71,8 @@
 -2: 
binary search that relies on Array being sorted in descending 
order. If not sorted, invalid results will be returned.
 
 
+MatchType value 2 cannot 
be combined with binary search (SearchMode value 2 or 
-2).
 
-
 
 
 
diff --git a/source/text/scalc/01/func_xmatch.xhp 
b/source/text/scalc/01/func_xmatch.xhp
index 6595230a37..6e3a734dd8 100644
--- a/source/text/scalc/01/func_xmatch.xhp
+++ b/source/text/scalc/01/func_xmatch.xhp
@@ -31,9 +31,25 @@
 XMATCH(Lookup; Array [; 
MatchType [; SearchMode ] ] )
 Lookup: 
The value of any type to search for in Array.
 Array: is 
the reference of the array or range to search.
-
+
+MatchType: 
(optional) specifies the match type. Values can be:
+
+
+0: 
exact match (default). If Lookup value is not found, then return 
the #N/A error.
+
+
+-1: 
attempt exact match. If Lookup value is not found, then return the 
next smaller item.
+
+
+1: 
attempt exact match. If Lookup value is not found, then return the 
next larger item.
+
+
+2: 
a wildcard match where 
characters *, ?, and ~ have special meanings, or a match using regular expressions.
+
+ 

core.git: helpcontent2

[Olivier Hallot (via logerrit)]

 helpcontent2 |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit bff196c0d34f540f459ced613ac379a730f46149
Author: Olivier Hallot 
AuthorDate: Fri Jun 7 08:22:38 2024 -0300
Commit: Gerrit Code Review 
CommitDate: Fri Jun 7 13:22:38 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'master'
  to 4167f524c4718c3960cae2e4f390d04ffdb20839
  - tdf161442 Help page for Calc LET function

Change-Id: I81a5304786f626eaf7b556bb5faf6fa90f2eab34
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/168508
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/helpcontent2 b/helpcontent2
index 842cf7acf0f7..4167f524c471 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit 842cf7acf0f77bbffdb61b42fc5b935773094dcb
+Subproject commit 4167f524c4718c3960cae2e4f390d04ffdb20839

help.git: AllLangHelp_scalc.mk source/text

[Olivier Hallot (via logerrit)]

 AllLangHelp_scalc.mk  |1 
 source/text/scalc/01/func_let.xhp |   48 ++
 2 files changed, 49 insertions(+)

New commits:
commit 4167f524c4718c3960cae2e4f390d04ffdb20839
Author: Olivier Hallot 
AuthorDate: Thu Jun 6 16:44:57 2024 -0300
Commit: Olivier Hallot 
CommitDate: Fri Jun 7 13:22:38 2024 +0200

tdf161442 Help page for Calc LET function

Change-Id: I81a5304786f626eaf7b556bb5faf6fa90f2eab34
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/168508
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index 10fc142be4..d9ffdef4f7 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -245,6 +245,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
 helpcontent2/source/text/scalc/01/func_imtan \
 helpcontent2/source/text/scalc/01/func_isoweeknum \
 helpcontent2/source/text/scalc/01/func_jis \
+helpcontent2/source/text/scalc/01/func_let \
 helpcontent2/source/text/scalc/01/func_maxifs \
 helpcontent2/source/text/scalc/01/func_minifs \
 helpcontent2/source/text/scalc/01/func_minute \
diff --git a/source/text/scalc/01/func_let.xhp 
b/source/text/scalc/01/func_let.xhp
new file mode 100644
index 00..610d883248
--- /dev/null
+++ b/source/text/scalc/01/func_let.xhp
@@ -0,0 +1,48 @@
+
+
+
+
+
+
+LET function
+/text/scalc/01/func_let.xhp
+
+
+
+
+
+LET function
+
+
+LET
+Assigns names to 
calculation results. This allows storing intermediate calculations, values, or 
defining names inside a formula. These names only apply within the scope of the 
LET function.
+
+
+LET(Name1; Name_value1; 
Calculation_or_Name2; [Name_value2; Calculation_or_Name3 [; ...]])
+
+Name1: the 
first name to assign. Must start with a letter. Cannot be the output of a 
formula or conflict with range syntax.
+Name1 must follow the naming rules of %PRODUCTNAME 
Calc.
+Name_value1: the value or calculation 
to assign to Name1.
+Name2; 
Name_value2;...: (optional) same as Name1 and Name_value1, respectively. 
Name_value2 must follow Name2 and so on.
+Calculation: a formula expression that 
uses all names within the LET function.
+Calculation must be the last 
argument in the LET function.
+
+
+Calculate the molar 
mass of the water molecule knowing that the molecule has 2 hydrogen atoms and 
one oxygen atom.
+=LET(mHydro; 
HLOOKUP("Hydrogen"; $A$1:$DO$4; 4; 0); mOxy; HLOOKUP("Oxygen"; $A$1:$DO$4; 4; 
0); "The molar mass of water is "(mOxy+2*mHydro)" g/mol") 
returns "The molar mass of water is 18.015 g/mol".
+
+
+
+COM.MICROSOFT.LET
+
+https://wiki.documentfoundation.org/Documentation/Calc_Functions/LET;>LET 
wiki page.
+
+
+

core.git: solenv/gbuild

[Olivier Hallot (via logerrit)]

 solenv/gbuild/HelpTarget.mk |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit 870200f9ce451dfbb6188d4c2a024f59adb09f47
Author: Olivier Hallot 
AuthorDate: Wed Jun 5 07:52:50 2024 -0300
Commit: Olivier Hallot 
CommitDate: Wed Jun 5 17:42:16 2024 +0200

Simplify make.clean in helpcontent2 gbuild

Change-Id: I795aa46943b4433624dfc04e9962e2a40528d188
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/168470
Tested-by: Jenkins
Reviewed-by: Christian Lohmaier 

diff --git a/solenv/gbuild/HelpTarget.mk b/solenv/gbuild/HelpTarget.mk
index 7047a36d7e6d..2e6c5d9e01e7 100644
--- a/solenv/gbuild/HelpTarget.mk
+++ b/solenv/gbuild/HelpTarget.mk
@@ -71,7 +71,7 @@ $(call gb_HelpTranslatePartTarget_get_target,%) : 
$(gb_HelpTranslatePartTarget_D
 
 clear_HelpTranslatePartTarget:
$(call gb_Output_announce,clear HelpTranslatePartTarget,$(false),HPX,1)
-   rm -rf  $(call gb_HelpTranslatePartTarget_workdir)
+   rm -rf $(gb_HelpTranslatePartTarget_workdir)
 
 # Translate a set of .xhp files from one directory.
 #

core.git: solenv/gbuild

[Olivier Hallot (via logerrit)]

 solenv/gbuild/HelpTarget.mk |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit ea67891bb9a554efb93f43ae73fc6a9a58dcc040
Author: Olivier Hallot 
AuthorDate: Tue Jun 4 15:26:44 2024 -0300
Commit: Olivier Hallot 
CommitDate: Wed Jun 5 12:07:28 2024 +0200

Fix make 'clean' command in helpcontents2/

Change-Id: I1bc66a8f4a4c258983e1fa141cc106bd52c27dfe
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/168412
Reviewed-by: Olivier Hallot 
Tested-by: Jenkins

diff --git a/solenv/gbuild/HelpTarget.mk b/solenv/gbuild/HelpTarget.mk
index 2a629fcbd129..7047a36d7e6d 100644
--- a/solenv/gbuild/HelpTarget.mk
+++ b/solenv/gbuild/HelpTarget.mk
@@ -71,7 +71,7 @@ $(call gb_HelpTranslatePartTarget_get_target,%) : 
$(gb_HelpTranslatePartTarget_D
 
 clear_HelpTranslatePartTarget:
$(call gb_Output_announce,clear HelpTranslatePartTarget,$(false),HPX,1)
-   rm -rf  $(call gb_HelpTranslatePartTarget_get_workdir)
+   rm -rf  $(call gb_HelpTranslatePartTarget_workdir)
 
 # Translate a set of .xhp files from one directory.
 #

core.git: helpcontent2

[Olivier Hallot (via logerrit)]

 helpcontent2 |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit d9053bb778d3d230f2f3cf946c4823caa2e0f385
Author: Olivier Hallot 
AuthorDate: Fri May 31 17:49:20 2024 -0300
Commit: Gerrit Code Review 
CommitDate: Fri May 31 22:49:20 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'master'
  to 692e37447c9af746a7c34bfe46a1b78e0b15322d
  - Unmute translation on func_weeknum.xhp

+ refactor

Change-Id: Ibba4e057864ccb6339bf2d8a5d93899bd0744380
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/168299
Tested-by: Jenkins
Reviewed-by: Adolfo Jayme Barrientos 

diff --git a/helpcontent2 b/helpcontent2
index 3de7c68c52bf..692e37447c9a 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit 3de7c68c52bfe0beadcd791092aaea420cb43a97
+Subproject commit 692e37447c9af746a7c34bfe46a1b78e0b15322d

help.git: source/text

[Olivier Hallot (via logerrit)]

 source/text/scalc/01/func_weeknum.xhp |   90 +-
 1 file changed, 45 insertions(+), 45 deletions(-)

New commits:
commit 692e37447c9af746a7c34bfe46a1b78e0b15322d
Author: Olivier Hallot 
AuthorDate: Fri May 31 12:34:21 2024 -0300
Commit: Adolfo Jayme Barrientos 
CommitDate: Fri May 31 22:49:19 2024 +0200

Unmute translation on func_weeknum.xhp

+ refactor

Change-Id: Ibba4e057864ccb6339bf2d8a5d93899bd0744380
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/168299
Tested-by: Jenkins
Reviewed-by: Adolfo Jayme Barrientos 

diff --git a/source/text/scalc/01/func_weeknum.xhp 
b/source/text/scalc/01/func_weeknum.xhp
index 7f139d446c..340d6f96b1 100644
--- a/source/text/scalc/01/func_weeknum.xhp
+++ b/source/text/scalc/01/func_weeknum.xhp
@@ -19,165 +19,165 @@
 
 
 
-WEEKNUM
+WEEKNUM
 /text/scalc/01/func_weeknum.xhp
 
 
 
-WEEKNUM function
+WEEKNUM 
function
 
-
+
 WEEKNUM
 
-WEEKNUM calculates the week number of the year for 
the internal date value as defined in ODF OpenFormula and compatible with other 
spreadsheet applications.
-Supported are 
two week numbering systems:
+WEEKNUM calculates the week number of the year for 
the internal date value as defined in ODF OpenFormula and compatible with other 
spreadsheet applications.
+Supported are two week 
numbering systems:
 
 
 
-System
+System
 
 
-Description
+Description
 
 
 
 
-System 1
+System 
1
 
 
-The week containing January 1 is the first week of the year, 
and is numbered week 1.
+The week 
containing January 1 is the first week of the year, and is numbered week 
1.
 
 
 
 
-System 2
+System 
2
 
 
-The week containing the first Thursday of the year is the 
first week of the year, and is numbered week 1. That means that week number 1 
of any year is the week that contains January 4th. ISO 8601 defines this system 
and that the week starts on Monday.
+The week 
containing the first Thursday of the year is the first week of the year, and is 
numbered week 1. That means that week number 1 of any year is the week that 
contains January 4th. ISO 8601 defines this system and that the week starts on 
Monday.
 
 
 
 
 
-WEEKNUM(Number [; 
Mode])
-
+WEEKNUM(Number [; Mode])
+
 Number is the internal date number.
-
+
 Mode sets the start of the week and the week numbering system. 
This parameter is optional, if omitted the default value is 1.
 
 
 
-System
+System
 
 
-Mode
+Mode
 
 
-Day of the week
+Day of the 
week
 
 
 
 
-System 1
+System 
1
 
 
-1
+1
 
 
-Sunday
+Sunday
 
 
 
 
-2
+2
 
 
-Monday
+Monday
 
 
 
 
-11
+11
 
 
-Monday
+Monday
 
 
 
 
-12
+12
 
 
-Tuesday
+Tuesday
 
 
 
 
-13
+13
 
 
-Wednesday
+Wednesday
 
 
 
 
-14
+14
 
 
-Thursday
+Thursday
 
 
 
 
-15
+15
 
 
-Friday
+Friday
 
 
 
 
-16
+16
 
 
-Saturday
+Saturday
 
 
 
 
-17
+17
 
 
-Sunday
+Sunday
 
 
 
 
-System 2
+System 
2
 
 
-21
+21
 
 
-Monday (ISO 8601)
+Monday 
(ISO 8601)
 
 
 
 
-150
+150
 
 
-(ISO 8601, for interoperability with Gnumeric)
+(ISO 
8601, for interoperability with Gnumeric)
 
 
 
 
 
 
-=WEEKNUM(DATE(1995;1;1);1)  returns 1
-=WEEKNUM(DATE(1995;1;1);2)  returns 1. Using System 1, the 
week containing January 1 is the first week of the year.
-=WEEKNUM(DATE(1995;1;1);21)  returns 52. Week 1 starts on 
Monday, 1995-01-02.
-=WEEKNUM(DATE(1999;1;1);21)  returns 53. Week 1 starts on 
Monday, 1999-01-04.
+=WEEKNUM(DATE(1995;1;1);1)  returns 1
+=WEEKNUM(DATE(1995;1;1);2)  returns 1. Using System 1, the 
week containing January 1 is the first week of the year.
+=WEEKNUM(DATE(1995;1;1);21)  

core.git: 2 commits - helpcontent2

[Olivier Hallot (via logerrit)]

 helpcontent2 |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit c0593719836f6969262c7ed798ee9e528cf03e4b
Author: Olivier Hallot 
AuthorDate: Tue May 28 09:45:55 2024 -0300
Commit: Gerrit Code Review 
CommitDate: Tue May 28 14:45:55 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'master'
  to 7b824f49fb1a71b173ed318241f99aeb7320eac0
  - tdf#159872 Review Help for SORT/SORTBY function

+ Fix syntax definition

Change-Id: I9b24b25bdeb4298f6ba12f605b783324b3b921d1
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/168115
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/helpcontent2 b/helpcontent2
index 99ebed65db57..7b824f49fb1a 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit 99ebed65db57abb67aa4765f636de2c3c60c10a9
+Subproject commit 7b824f49fb1a71b173ed318241f99aeb7320eac0
commit 88aff5815c76b30ecff03891906ffc932b4ec03d
Author: Olivier Hallot 
AuthorDate: Tue May 28 09:45:41 2024 -0300
Commit: Gerrit Code Review 
CommitDate: Tue May 28 14:45:41 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'master'
  to 99ebed65db57abb67aa4765f636de2c3c60c10a9
  - tdf#159872 Review Help for RANDARRAY function

+ Fix syntax definition

Change-Id: I9acde26c9d6237409813939b1bd1c23e3d61f862
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/168110
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/helpcontent2 b/helpcontent2
index 5edd31fd783d..99ebed65db57 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit 5edd31fd783de27dec830907b18651ec8f8c9261
+Subproject commit 99ebed65db57abb67aa4765f636de2c3c60c10a9

help.git: 2 commits - source/text

[Olivier Hallot (via logerrit)]

 source/text/scalc/01/func_randarray.xhp |7 ---
 source/text/scalc/01/func_sort.xhp  |   12 ++--
 source/text/scalc/01/func_sortby.xhp|9 +
 3 files changed, 15 insertions(+), 13 deletions(-)

New commits:
commit 7b824f49fb1a71b173ed318241f99aeb7320eac0
Author: Olivier Hallot 
AuthorDate: Mon May 27 14:46:51 2024 -0300
Commit: Olivier Hallot 
CommitDate: Tue May 28 14:45:54 2024 +0200

tdf#159872 Review Help for SORT/SORTBY function

+ Fix syntax definition

Change-Id: I9b24b25bdeb4298f6ba12f605b783324b3b921d1
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/168115
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/source/text/scalc/01/func_sort.xhp 
b/source/text/scalc/01/func_sort.xhp
index e0f9b694c8..a771ccbfa2 100644
--- a/source/text/scalc/01/func_sort.xhp
+++ b/source/text/scalc/01/func_sort.xhp
@@ -26,12 +26,12 @@
 
 Enter the formula as an array formula.
 
-SORT(Range [, SortIndex[, 
SortOrder[, ByCol]]])
-Range: 
Required. The range or array to sort.
-SortIndex: 
Optional. The number indicating the row or column to sort by.
-SortOrder: 
Optional. A number indicating the desired sort order; 1 for ascending order 
(default), -1 for descending order.
-ByCol: 
Optional. A logical value indicating the desired sort direction; 
FALSE to sort by row (default), TRUE to sort by 
column.
-
+SORT(Range [; SortIndex [; 
SortOrder [; ByCol] ] ])
+Range: the 
range or array to sort.
+SortIndex: 
(optional). The number indicating the row or column to sort by.
+SortOrder: 
(optional). A number indicating the desired sort order; 1 for ascending order 
(default), -1 for descending order.
+ByCol: 
(optional). A logical value indicating the desired sort direction; 
FALSE to sort by row (default), TRUE to sort by 
column.
+
 
 
 Example with ascending order
diff --git a/source/text/scalc/01/func_sortby.xhp 
b/source/text/scalc/01/func_sortby.xhp
index 332005731a..1f0f045a47 100644
--- a/source/text/scalc/01/func_sortby.xhp
+++ b/source/text/scalc/01/func_sortby.xhp
@@ -25,12 +25,13 @@
 Sorts the contents 
of a range or array based on the values in a corresponding range or 
array.
 
 
-SORTBY(Range, SortByRange1, 
SortOrder1[, SortByRange2, SortOrder2,[...]])
+SORTBY(Range; SortByRange1; 
SortOrder1 [; SortByRange2; SortOrder2,[...] ])
 Range: The 
array or range to sort.
-SortByRange1, 
SortByRange2,... : Range 1, range 2,... are the arrays or ranges to sort 
on.
-SortOrder1, 
SortOrder2,... : Order 1, order 2,... are the orders to use for sorting. 
1 for ascending, -1 for descending. Default is ascending.
+SortByRange1, 
SortByRange2,... : range 1, range 2,... are the arrays or ranges to sort 
on.
+SortOrder1, 
SortOrder2,... : order 1, order 2,... are the orders to use for sorting. 
1 for ascending, -1 for descending. Default is ascending.
+
 
-{=SORTBY(A2:C7,A2:A7,1,C2:C7,-1)}
+{=SORTBY(A2:C7;A2:A7;1;C2:C7;-1)}
 Sort the range A2:C7 
based on the first column in ascending order and third column in descending 
order.
 
 
commit 99ebed65db57abb67aa4765f636de2c3c60c10a9
Author: Olivier Hallot 
AuthorDate: Mon May 27 13:22:38 2024 -0300
Commit: Olivier Hallot 
CommitDate: Tue May 28 14:45:40 2024 +0200

tdf#159872 Review Help for RANDARRAY function

+ Fix syntax definition

Change-Id: I9acde26c9d6237409813939b1bd1c23e3d61f862
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/168110
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/source/text/scalc/01/func_randarray.xhp 
b/source/text/scalc/01/func_randarray.xhp
index 1a746c97e0..9ec298ad44 100644
--- a/source/text/scalc/01/func_randarray.xhp
+++ b/source/text/scalc/01/func_randarray.xhp
@@ -18,14 +18,14 @@
 
 
 
-RANDARRAY function
+RANDARRAY function
 
 
 RANDARRAY
 Generates an array 
of random numbers between two limit values.
 
 
-RANDARRAY([Rows], [Columns], 
[Min], [Max], [Integers])
+RANDARRAY([Rows [; Columns 
[; Min [; Max [; Integers] ] ] ])
 Rows: 
(optional) the number of rows to return. If omitted, the value is 1.
 Columns: 
(optional) the number of columns to return. If omitted, the value is 
1.
 Min: 
(optional) The lower limit of the generated numbers. If omitted, the minimum 
value is 0.
@@ -33,8 +33,9 @@
 Integers: 
(optional) returns whole numbers (TRUE) or decimal numbers (FALSE). Default is 
FALSE.
 If Rows and Columns 
are greater than 1, the RANDARRAY function must be entered as an array 
formula.
 If Rows or 
Columns are references to the content of other cells, the array 
dimensions do not change when the referenced content changes. The array formula 
must be deleted and re-entered.
+
 
-{=RANDARRAY(10,4,10,50,1)} returns an 
array of 10 rows, 4 columns with minimum value 10 and maximum value of 50 of 
whole numbers (integers).
+{=RANDARRAY(10;4;10;50;1)} returns an 
array of 10 rows, 4 columns with minimum value 10 and maximum value of 50 of 
whole numbers (integers).
 
 
 

help.git: source/text

[Olivier Hallot (via logerrit)]

 source/text/scalc/01/func_filter.xhp |   42 ++-
 1 file changed, 37 insertions(+), 5 deletions(-)

New commits:
commit 5edd31fd783de27dec830907b18651ec8f8c9261
Author: Olivier Hallot 
AuthorDate: Mon May 27 13:00:49 2024 -0300
Commit: Olivier Hallot 
CommitDate: Tue May 28 14:45:14 2024 +0200

tdf#159872 Review Help for FILTER function

+ Fix syntax definition
+ Fix "Result not found"

Change-Id: I80a2f9adafd03c79b199e069134413df2546f124
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/168109
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/source/text/scalc/01/func_filter.xhp 
b/source/text/scalc/01/func_filter.xhp
index 35a6622ab4..2fd955f164 100644
--- a/source/text/scalc/01/func_filter.xhp
+++ b/source/text/scalc/01/func_filter.xhp
@@ -22,16 +22,48 @@
 
 
 FILTER
-Filters a data 
range or array based on conditions you specify.
+Filters a data 
range or array based on specified conditions.
 
 
-FILTER(Range, Criteria, 
Return if empty)
+FILTER( Range; Criteria [; 
Return if empty])
 Range: The 
array or range to filter.
 Criteria: 
A boolean array whose height (filtering by columns) or width (filtering by 
rows) is the same as the array, used to select data from the 
Range.
-Return if 
empty: the value to return if all values in the Include array are empty 
(filter return nothing).
+Result if 
empty: (optional) the value to return if all values in the 
Criteria array are empty (filter return nothing).
 
-{=FILTER(A2:C13,A2:A13>50)} returns 
the array {57,49,12|56,33,60|57,,} containing all grades with Maths grade above 
50. Note that this is an array formula.
-{=FILTER(A2:C13,B2:B13>90,"No 
results")}  Returns the string "No results", since no grade on Physics 
is above 90.
+{=FILTER(A2:C13;A2:A13>50)} returns 
the array containing all grades with Maths grade above 50. Note that this is an 
array 
formula.
+
+
+
+57
+
+
+49
+
+
+12
+
+
+
+
+56
+
+
+33
+
+
+60
+
+
+
+
+57
+
+
+
+
+
+{=FILTER(A2:C13;B2:B13>90;"No 
results")}  Returns the string "No results", since no grade on Physics 
is above 90.
+
 
 
 

core.git: helpcontent2

[Olivier Hallot (via logerrit)]

 helpcontent2 |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit 59104b191c386198c2c682ed8b650b2bb9a9f60f
Author: Olivier Hallot 
AuthorDate: Tue May 28 09:44:48 2024 -0300
Commit: Gerrit Code Review 
CommitDate: Tue May 28 14:44:48 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'master'
  to 390dd2b9aaf82a2d859224173364ae207c51ba62
  - tdf#159872 Review Help XLOOKUP XMATCH functions

From comments in by Regina and Ady in

https://community.documentfoundation.org/t/comments-on-help-for-new-xlookup-fucntion/12086?u=ohallot
and following.

+ Note on "case sensitive"
+ Details on array and range
+ Fix #N/A to "returns the #N/A error"
+ Reworked examples (re-use HLOOKUP table)
+ Grammar and linguistics here and there
+ Fix syntax definition
+ Fix "Not found" definition
+ Fix MatchType using verb "attempt"
+ Position of optional arguments
+ Longer user cases to be addressed in wiki

Note: the function clones Excel XLOOKUP but it is not a copy. Therefore
the name of the arguments were set to differentiate from Excel. The
Calc function arguments usual naming were mostly mnemonic and
not verbose. The current XLOOKUP names in the function wizard is
verbose and has several words. Review is needed.

Patch set 2: fix xml DTD
Patch set 3: XMATCH
+ Reworked example (re-use HLOOKUP table)
+ Link to MATCH
+ Fix function syntax
+ Refactor
Patch set 4:
+ typos
+ Fix case insensitive

Change-Id: I9f085dcadbdb013cf3a3b892791e18c729aa6431
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/168072
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/helpcontent2 b/helpcontent2
index 8cba63bac083..390dd2b9aaf8 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit 8cba63bac0833eb8af14e507c2f2123a39c4d595
+Subproject commit 390dd2b9aaf82a2d859224173364ae207c51ba62

help.git: source/text

[Olivier Hallot (via logerrit)]

 source/text/scalc/01/04060109.xhp |7 +
 source/text/scalc/01/common_func.xhp  |3 
 source/text/scalc/01/ful_func.xhp |3 
 source/text/scalc/01/func_unique.xhp  |4 
 source/text/scalc/01/func_xlookup.xhp |  156 ++
 source/text/scalc/01/func_xmatch.xhp  |   14 +--
 6 files changed, 67 insertions(+), 120 deletions(-)

New commits:
commit 390dd2b9aaf82a2d859224173364ae207c51ba62
Author: Olivier Hallot 
AuthorDate: Sun May 26 14:01:35 2024 -0300
Commit: Olivier Hallot 
CommitDate: Tue May 28 14:44:48 2024 +0200

tdf#159872 Review Help XLOOKUP XMATCH functions

From comments in by Regina and Ady in

https://community.documentfoundation.org/t/comments-on-help-for-new-xlookup-fucntion/12086?u=ohallot
and following.

+ Note on "case sensitive"
+ Details on array and range
+ Fix #N/A to "returns the #N/A error"
+ Reworked examples (re-use HLOOKUP table)
+ Grammar and linguistics here and there
+ Fix syntax definition
+ Fix "Not found" definition
+ Fix MatchType using verb "attempt"
+ Position of optional arguments
+ Longer user cases to be addressed in wiki

Note: the function clones Excel XLOOKUP but it is not a copy. Therefore
the name of the arguments were set to differentiate from Excel. The
Calc function arguments usual naming were mostly mnemonic and
not verbose. The current XLOOKUP names in the function wizard is
verbose and has several words. Review is needed.

Patch set 2: fix xml DTD
Patch set 3: XMATCH
+ Reworked example (re-use HLOOKUP table)
+ Link to MATCH
+ Fix function syntax
+ Refactor
Patch set 4:
+ typos
+ Fix case insensitive

Change-Id: I9f085dcadbdb013cf3a3b892791e18c729aa6431
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/168072
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/source/text/scalc/01/04060109.xhp 
b/source/text/scalc/01/04060109.xhp
index fe95792bbd..c0375dee07 100644
--- a/source/text/scalc/01/04060109.xhp
+++ b/source/text/scalc/01/04060109.xhp
@@ -446,7 +446,9 @@
  For an explanation on 
the parameters, see: VLOOKUP (columns and rows are 
exchanged)
  
  
- Suppose we 
have built a small database table occupying the cell range A1:DO4 and 
containing basic information about 118 chemical elements. The first column 
contains the row headings “Element”, “Symbol”, “Atomic Number”, and “Relative 
Atomic Mass”. Subsequent columns contain the relevant information for each of 
the elements, ordered left to right by atomic number. For example, cells B1:B4 
contain “Hydrogen”, “H”, “1” and “1.008”, while cells DO1:DO4 contain 
“Oganesson”, “Og”, “118”, and “294”.
+
+ 
+Suppose we have 
built a small database table occupying the cell range A1:DO4 and containing 
basic information about 118 chemical elements. The first column contains the 
row headings “Element”, “Symbol”, “Atomic Number”, and “Relative Atomic Mass”. 
Subsequent columns contain the relevant information for each of the elements, 
ordered left to right by atomic number. For example, cells B1:B4 contain 
“Hydrogen”, “H”, “1” and “1.008”, while cells DO1:DO4 contain “Oganesson”, 
“Og”, “118”, and “294”.
 


@@ -563,7 +565,8 @@
294

 
-
+
+ 
 =HLOOKUP("Lead"; $A$1:$DO$4; 2; 0) 
returns “Pb”, the symbol for lead.
  =HLOOKUP("Gold"; $A$1:$DO$4; 3; 0) 
returns 79, the atomic number for gold.
  =HLOOKUP("Carbon"; $A$1:$DO$4; 4; 0) 
returns 12.011, the relative atomic mass of carbon.
diff --git a/source/text/scalc/01/common_func.xhp 
b/source/text/scalc/01/common_func.xhp
index 8a578b4f46..4a3ac7a323 100644
--- a/source/text/scalc/01/common_func.xhp
+++ b/source/text/scalc/01/common_func.xhp
@@ -36,5 +36,8 @@
 
 This function ignores any text or 
empty cell within a data range. If you suspect wrong results from this 
function, look for text in the data ranges. To highlight text contents in a 
data range, use the value 
highlighting feature.
 
+
+Any of the optional arguments can be 
omitted. An optional argument is required to be preceded by the preceding 
separators.
+
 
 
diff --git a/source/text/scalc/01/ful_func.xhp 
b/source/text/scalc/01/ful_func.xhp
index 1681a65bc6..c31872347b 100644
--- a/source/text/scalc/01/ful_func.xhp
+++ b/source/text/scalc/01/ful_func.xhp
@@ -93,5 +93,8 @@
 
 This function 
is always recalculated whenever a recalculation occurs.
 
+
+  The function is always case 
insensitive, independent from the setting of Case sensitive 
checkbox in %PRODUCTNAME - 
PreferencesTools - 
Options - %PRODUCTNAME Calc - 
Calculate.
+
 
 
diff --git a/source/text/scalc/01/func_unique.xhp 
b/source/text/scalc/01/func_unique.xhp
index 8c709cfb44..845a64f193 100644
--- a/source/text/scalc/01/func_unique.xhp
+++ 

core.git: helpcontent2

[Olivier Hallot (via logerrit)]

 helpcontent2 |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit d44b86964353cc2e65eba6c2e06529fd9b716cc1
Author: Olivier Hallot 
AuthorDate: Wed May 22 14:29:55 2024 -0300
Commit: Gerrit Code Review 
CommitDate: Wed May 22 19:29:55 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'master'
  to 1686a72bcddf4f28d0510e02a1596baf5e6ebdc6
  - Reinstate screenshot for presentationdialog

+ Screenshot updated recently.
+ refactor

Change-Id: I840eabe97d90c7725b44c63746a3f7bd8cad800b
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/167912
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/helpcontent2 b/helpcontent2
index 74121a4068a3..1686a72bcddf 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit 74121a4068a305b871e5aa5d0aada26012bced22
+Subproject commit 1686a72bcddf4f28d0510e02a1596baf5e6ebdc6

help.git: source/text

[Olivier Hallot (via logerrit)]

 source/text/simpress/01/0608.xhp |   90 +--
 1 file changed, 45 insertions(+), 45 deletions(-)

New commits:
commit 1686a72bcddf4f28d0510e02a1596baf5e6ebdc6
Author: Olivier Hallot 
AuthorDate: Tue May 21 19:24:18 2024 -0300
Commit: Olivier Hallot 
CommitDate: Wed May 22 19:29:54 2024 +0200

Reinstate screenshot for presentationdialog

+ Screenshot updated recently.
+ refactor

Change-Id: I840eabe97d90c7725b44c63746a3f7bd8cad800b
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/167912
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/source/text/simpress/01/0608.xhp 
b/source/text/simpress/01/0608.xhp
index ae760ec4eb..5ddce7e5c8 100644
--- a/source/text/simpress/01/0608.xhp
+++ b/source/text/simpress/01/0608.xhp
@@ -20,14 +20,14 @@
 
 
   
-Slide Show Settings
+Slide Show Settings
 /text/simpress/01/0608.xhp
   
 
 
 
 
-
+
   presentations; settings for
   slide shows; settings for
   presentations; window / full screen
@@ -42,98 +42,98 @@
 presentation; navigation bar settings
 
 
-
-
-
+
+
+
 
 Slide Show Settings
-Defines settings for your 
slide show, including how to display it, which slide to start from, the way you 
advance the slides, and whether you want to use the presenter console or 
control it remotely.
+Defines settings for your slide show, including 
how to display it, which slide to start from, the way you advance the slides, 
and whether you want to use the presenter console or control it 
remotely.
 
 
 
 
-
+
 Range
-Specifies 
which slides to include in the slide show.
-
+Specifies which slides to 
include in the slide show.
+
 
 All slides
-Includes all of the 
slides in your slide show.
-
-
+Includes all of the 
slides in your slide show.
+
+
 
 From:
-Enter the number of the 
start slide.
-
-
+Enter the number of the 
start slide.
+
+
 
 Custom Slide Show
-Runs a custom 
slide show in the order that you defined in Slide Show - Custom Slide 
Show.
+Runs a custom 
slide show in the order that you defined in Slide Show - Custom Slide 
Show.
 
 Presentation Mode
-Select the 
slide show type.
-
+Select the slide show 
type.
+
 
 Full screen
-A full screen slide is 
shown.
-
+A full screen slide is 
shown.
+
 
 In a window
-Slide show runs in the 
$[officename] program window.
-
+Slide show runs in the 
$[officename] program window.
+
 
 Loop and repeat after
-Restarts the slide show after 
the pause interval you specify. A pause slide is displayed between the final 
slide and the start slide. Press the Esc key to stop the 
show.
-
+Restarts the slide show after 
the pause interval you specify. A pause slide is displayed between the final 
slide and the start slide. Press the Esc key to stop the 
show.
+
 
 Duration of pause
-Enter the duration 
of the pause before the slide show is repeated. If you enter zero, the show 
restarts immediately without showing a pause slide.
-
+Enter the duration 
of the pause before the slide show is repeated. If you enter zero, the show 
restarts immediately without showing a pause slide.
+
 
 Show logo
-Displays the 
$[officename] logo on the pause slide. The logo cannot be 
exchanged.
+Displays the 
$[officename] logo on the pause slide. The logo cannot be 
exchanged.
 
 Presentation Options
-
+
 
 Disable automatic change of slide
-Slides never change 
automatically when this box is selected.
-
+Slides never change 
automatically when this box is selected.
+
 
 Change slides by clicking on background
-Advances to 
the next slide when you click on the background of a slide.
-
+Advances to 
the next slide when you click on the background of a slide.
+
 
 Mouse pointer visible
-Shows the mouse 
pointer during a slide show.
-
+Shows the mouse 
pointer during a slide show.
+
 
 Mouse pointer as pen
-Changes the mouse 
pointer to a pen which you can use to draw on slides during the 
presentation.
+Changes the mouse 
pointer to a pen which you can use to draw on slides during the 
presentation.
 Anything you write with the pen will appear in your 
slides after exiting the slideshow. The properties of the pen can be changed by 
choosing the Pen Width or Change pen Color command in 
the context menu of the running slide show.
-
+
 
 Enable animated images
-Displays all 
frames of animated GIF files during the slide show. If this option is 
not selected, only the first frame of an animated GIF file is 
displayed.see #i63884
-
+Displays all 
frames of animated GIF files during the slide show. If this option is 
not selected, only the first frame of an animated GIF file is 
displayed.see #i63884
+
 
 Keep presentation always on top
-The $[officename] 
window remains on top during the presentation. No other program will show its 
window in front of your presentation.
+The $[officename] 
window remains on top during the presentation. No other program will show its 
window in front of your presentation.
 
-
+
 
 Live-mode slideshow 

core.git: helpcontent2

[Olivier Hallot (via logerrit)]

 helpcontent2 |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit 101b08fe1ec77ffe8c1a9b2b8f9f20884269a1ed
Author: Olivier Hallot 
AuthorDate: Tue May 21 19:09:02 2024 -0300
Commit: Gerrit Code Review 
CommitDate: Wed May 22 00:09:02 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'master'
  to b3ffed2bfd797c22fe28472898d2d9a72aa2ae41
  - Update screenshot for simpress/presentationdialog.ui

Change-Id: Ie514503c603cd1c40917486a5f5c2096301a3f94
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/167910
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/helpcontent2 b/helpcontent2
index bfc9b74f251b..b3ffed2bfd79 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit bfc9b74f251bd2aca3605732c30b61bd6715a7eb
+Subproject commit b3ffed2bfd797c22fe28472898d2d9a72aa2ae41

help.git: source/media

[Olivier Hallot (via logerrit)]

 
source/media/screenshots/modules/simpress/ui/presentationdialog/PresentationDialog.png
 |binary
 
source/media/screenshots/modules/simpress/ui/presentationdialog/af/PresentationDialog.png
  |binary
 
source/media/screenshots/modules/simpress/ui/presentationdialog/am/PresentationDialog.png
  |binary
 
source/media/screenshots/modules/simpress/ui/presentationdialog/ar/PresentationDialog.png
  |binary
 
source/media/screenshots/modules/simpress/ui/presentationdialog/as/PresentationDialog.png
  |binary
 
source/media/screenshots/modules/simpress/ui/presentationdialog/ast/PresentationDialog.png
 |binary
 
source/media/screenshots/modules/simpress/ui/presentationdialog/be/PresentationDialog.png
  |binary
 
source/media/screenshots/modules/simpress/ui/presentationdialog/bg/PresentationDialog.png
  |binary
 
source/media/screenshots/modules/simpress/ui/presentationdialog/bn-IN/PresentationDialog.png
   |binary
 
source/media/screenshots/modules/simpress/ui/presentationdialog/bn/PresentationDialog.png
  |binary
 
source/media/screenshots/modules/simpress/ui/presentationdialog/bo/PresentationDialog.png
  |binary
 
source/media/screenshots/modules/simpress/ui/presentationdialog/br/PresentationDialog.png
  |binary
 
source/media/screenshots/modules/simpress/ui/presentationdialog/brx/PresentationDialog.png
 |binary
 
source/media/screenshots/modules/simpress/ui/presentationdialog/bs/PresentationDialog.png
  |binary
 
source/media/screenshots/modules/simpress/ui/presentationdialog/ca-valencia/PresentationDialog.png
 |binary
 
source/media/screenshots/modules/simpress/ui/presentationdialog/ca/PresentationDialog.png
  |binary
 
source/media/screenshots/modules/simpress/ui/presentationdialog/ckb/PresentationDialog.png
 |binary
 
source/media/screenshots/modules/simpress/ui/presentationdialog/cs/PresentationDialog.png
  |binary
 
source/media/screenshots/modules/simpress/ui/presentationdialog/cy/PresentationDialog.png
  |binary
 
source/media/screenshots/modules/simpress/ui/presentationdialog/da/PresentationDialog.png
  |binary
 
source/media/screenshots/modules/simpress/ui/presentationdialog/de/PresentationDialog.png
  |binary
 
source/media/screenshots/modules/simpress/ui/presentationdialog/dgo/PresentationDialog.png
 |binary
 
source/media/screenshots/modules/simpress/ui/presentationdialog/dsb/PresentationDialog.png
 |binary
 
source/media/screenshots/modules/simpress/ui/presentationdialog/dz/PresentationDialog.png
  |binary
 
source/media/screenshots/modules/simpress/ui/presentationdialog/el/PresentationDialog.png
  |binary
 
source/media/screenshots/modules/simpress/ui/presentationdialog/en-GB/PresentationDialog.png
   |binary
 
source/media/screenshots/modules/simpress/ui/presentationdialog/en-ZA/PresentationDialog.png
   |binary
 
source/media/screenshots/modules/simpress/ui/presentationdialog/eo/PresentationDialog.png
  |binary
 
source/media/screenshots/modules/simpress/ui/presentationdialog/es/PresentationDialog.png
  |binary
 
source/media/screenshots/modules/simpress/ui/presentationdialog/et/PresentationDialog.png
  |binary
 
source/media/screenshots/modules/simpress/ui/presentationdialog/eu/PresentationDialog.png
  |binary
 
source/media/screenshots/modules/simpress/ui/presentationdialog/fa/PresentationDialog.png
  |binary
 
source/media/screenshots/modules/simpress/ui/presentationdialog/fi/PresentationDialog.png
  |binary
 
source/media/screenshots/modules/simpress/ui/presentationdialog/fr/PresentationDialog.png
  |binary
 
source/media/screenshots/modules/simpress/ui/presentationdialog/fur/PresentationDialog.png
 |binary
 
source/media/screenshots/modules/simpress/ui/presentationdialog/fy/PresentationDialog.png
  |binary
 
source/media/screenshots/modules/simpress/ui/presentationdialog/ga/PresentationDialog.png
  |binary
 
source/media/screenshots/modules/simpress/ui/presentationdialog/gd/PresentationDialog.png
  |binary
 
source/media/screenshots/modules/simpress/ui/presentationdialog/gl/PresentationDialog.png
  |binary
 
source/media/screenshots/modules/simpress/ui/presentationdialog/gu/PresentationDialog.png
  |binary
 
source/media/screenshots/modules/simpress/ui/presentationdialog/gug/PresentationDialog.png
 |binary
 
source/media/screenshots/modules/simpress/ui/presentationdialog/he/PresentationDialog.png
  |binary
 
source/media/screenshots/modules/simpress/ui/presentationdialog/hi/PresentationDialog.png
  |binary
 
source/media/screenshots/modules/simpress/ui/presentationdialog/hr/PresentationDialog.png
  |binary
 
source/media/screenshots/modules/simpress/ui/presentationdialog/hsb/PresentationDialog.png
 |binary
 

core.git: sc/uiconfig

[Olivier Hallot (via logerrit)]

 sc/uiconfig/scalc/ui/sparklinedialog.ui |   25 -
 1 file changed, 16 insertions(+), 9 deletions(-)

New commits:
commit 26796cc201efc7862990b814887d73ef22d368bb
Author: Olivier Hallot 
AuthorDate: Tue May 21 11:39:38 2024 -0300
Commit: Olivier Hallot 
CommitDate: Tue May 21 18:47:45 2024 +0200

Fix typos in sparklines extended tips

Change-Id: I96848ed20e9a6d3e2d18e07c5f781bb98ed72f80
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/167902
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/sc/uiconfig/scalc/ui/sparklinedialog.ui 
b/sc/uiconfig/scalc/ui/sparklinedialog.ui
index 92ead02fcc67..4196d2e8d7db 100644
--- a/sc/uiconfig/scalc/ui/sparklinedialog.ui
+++ b/sc/uiconfig/scalc/ui/sparklinedialog.ui
@@ -119,6 +119,11 @@
 
   
 
+
+  
+Shrink
+  
+
   
   
 2
@@ -139,7 +144,7 @@
 
 
   
-Enter 
the cell range of the data fopr the sparklines.
+Enter 
the cell range containing the data for the sparklines.
   
 
   
@@ -156,6 +161,11 @@
 
   
 
+
+  
+Shrink
+  
+
   
   
 2
@@ -354,7 +364,7 @@
 
 
   
-check and 
select the color for high points.
+Check and 
select the color for high points.
   
 
   
@@ -675,8 +685,7 @@
 
 
   
-Display 
empty cells as:  Gap - the missing data is not displayed. The line type 
discontinues in the gap and the column is not displayed.   Zero -  the missing 
data is displayed as value zero. Span - for line type only, draws a continuous 
line connecting the previous value to the next value.
-
+Display 
empty cells as: Gap - the missing data is not displayed. The line type 
discontinues in the gap and the column is not displayed. Zero - the missing 
data is displayed as value zero. Span - for line type only, draws a continuous 
line connecting the previous value to the next value.
   
 
   
@@ -737,8 +746,7 @@
 
 
   
-Select the 
sparkline type in the drop-down list. Choices are:Line - draws a line 
between data values.Column - draws a bar for each data value.Stacked -  
also known as win/loss. Displays equally sized bars indicating positive and 
negative values.
-
+Select the 
sparkline type in the drop-down list. Choices are: Line - draws a line between 
data values.  Column - draws a bar for each data value. Stacked - also known as 
win/loss: displays equally sized bars indicating positive and negative 
values.
   
 
   
@@ -806,8 +814,7 @@
 
 
   
- 
Individual: sets automatically the minimum value for each sparkline based on 
the sparkline data range values.Group: sets the minimum value based on the 
lower and higher values found in the group of sparklines.  Custom: enter the 
minimum value for the sparkline group.
-
+Individual: sets 
automatically the minimum value for each sparkline based on the sparkline data 
range values. Group: sets the minimum value based on the lower and higher 
values found in the group of sparklines. Custom: enter the minimum value for 
the sparkline group.
   
 
   
@@ -847,7 +854,7 @@
 
 
   
- 
Individual: sets automatically the maximum value for each sparkline based on 
the sparkline data range values.Group: sets the maximum value based on the 
lower and higher values found in the group of sparklines.  Custom: enter the 
maximum value for the sparkline group.
+Individual: sets 
automatically the maximum value for each sparkline based on the sparkline data 

core.git: helpcontent2

[Olivier Hallot (via logerrit)]

 helpcontent2 |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit ae798781ef4df7a1fdef13af0bc459bf4f6e7b4c
Author: Olivier Hallot 
AuthorDate: Mon May 20 17:25:55 2024 -0300
Commit: Gerrit Code Review 
CommitDate: Mon May 20 22:25:55 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'master'
  to 2662257ca9594a0c5fc1371c8e397f562c726f8c
  - 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 
Tested-by: Jenkins

diff --git a/helpcontent2 b/helpcontent2
index cbb8c2d8d957..2662257ca959 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit cbb8c2d8d957f8a4729b32ac098c8a88f72d797a
+Subproject commit 2662257ca9594a0c5fc1371c8e397f562c726f8c

help.git: source/text

[Olivier Hallot (via logerrit)]

 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 
AuthorDate: Thu May 16 17:07:52 2024 -0300
Commit: Olivier Hallot 
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 
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 @@
 
 Examples of Database Function Use
 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.
-
-
+
+
 
 
 
@@ -339,7 +339,8 @@
 
 
 
-
+
+
 
 The following 
six examples use the database table above, combined with different search 
criteria areas.
 
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 @@
 
 
 UNIQUE
-(...)
+Returns the array 
of unique values from a range or array of values.
 
+
+The UNIQUE function is always case sensitive, 
independent from the setting of Case sensitive checkbox in 
%PRODUCTNAME - 
PreferencesTools - 
Options - %PRODUCTNAME Calc - 
Calculate.
+
 
-UNIQUE(...)
+UNIQUE(Array, [By col], 
[Uniqueness])
+Array: the 
range or array from which to return unique values.
+By col: 
(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.
+
+Uniqueness: (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.
+The UNIQUE function must be entered as an 
array 
formula.
 
+Given the data table 
below, the examples returns unique occurrences of grades and age.
+
+Example 1
+{=UNIQUE(B1:C10,FALSE(),FALSE())} 
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.
+
+GradeAge
+39
+410
+310
+511
+28
+27
+17
+
+Example 2
+{=UNIQUE(B1:C10,FALSE(),TRUE())}, 
with Uniqueness 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.
+
+GradeAge
+410
+310
+511
+27
+17
+
+
 
 
 

core.git: sc/inc

[Olivier Hallot (via logerrit)]

 sc/inc/scfuncs.hrc |4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

New commits:
commit 0c3ba42a45c4fd7eabbad9c2a57a82486cfd9eab
Author: Olivier Hallot 
AuthorDate: Thu May 16 17:16:46 2024 -0300
Commit: Olivier Hallot 
CommitDate: Fri May 17 15:32:20 2024 +0200

Review of UNIQUE function arguments text

Feel free to consider this as suggestion.

Change-Id: Ia3addb8ee7157ab0e5c5a10230adabc5963f94d7
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/167756
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 
Reviewed-by: Balazs Varga 

diff --git a/sc/inc/scfuncs.hrc b/sc/inc/scfuncs.hrc
index 6a9c8a0bb15d..d193625cd982 100644
--- a/sc/inc/scfuncs.hrc
+++ b/sc/inc/scfuncs.hrc
@@ -4259,8 +4259,8 @@ const TranslateId SC_OPCODE_UNIQUE_ARY[] =
 NC_("SC_OPCODE_UNIQUE", "The range or array from which to return unique 
values."),
 NC_("SC_OPCODE_UNIQUE", "By col"),
 NC_("SC_OPCODE_UNIQUE", "Logical value indicating how to compare data: 
TRUE - compares data across columns. FALSE or omitted (default) - compares data 
across rows."),
-NC_("SC_OPCODE_UNIQUE", "Exactly once"),
-NC_("SC_OPCODE_UNIQUE", "Logical value that defines what values are 
considered unique: TRUE - returns values that occur only once, which is the 
database notion of unique. FALSE or omitted (default) - returns all distinct 
(different) values in the range or array.")
+NC_("SC_OPCODE_UNIQUE", "Uniqueness"),
+NC_("SC_OPCODE_UNIQUE", "Logical value that defines what values are 
considered unique: TRUE - returns values that occur only once. FALSE or omitted 
(default) - returns all distinct (different) values in the range or array.")
 };
 
 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */

core.git: helpcontent2

[Olivier Hallot (via logerrit)]

 helpcontent2 |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit 0abc01c13638f92ddce191c7ff2c29ba31d9527d
Author: Olivier Hallot 
AuthorDate: Thu May 16 10:22:18 2024 -0300
Commit: Gerrit Code Review 
CommitDate: Thu May 16 15:22:18 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'master'
  to 1b06c45742f070d204183a7e24ccb5e2386d59a7
  - tdf#159872 Link RAND* to RANDARRAY function

+ refactor

Change-Id: I54fdfca2d15f0ddca0e36a9513da011896e886cf
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/167743
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/helpcontent2 b/helpcontent2
index c42e46cb11f0..1b06c45742f0 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit c42e46cb11f0d46bf918f3cc276750e380ed4af5
+Subproject commit 1b06c45742f070d204183a7e24ccb5e2386d59a7

help.git: source/text

[Olivier Hallot (via logerrit)]

 source/text/scalc/01/04060106.xhp   | 1012 
 source/text/scalc/01/func_randarray.xhp |1 
 2 files changed, 507 insertions(+), 506 deletions(-)

New commits:
commit 1b06c45742f070d204183a7e24ccb5e2386d59a7
Author: Olivier Hallot 
AuthorDate: Thu May 16 10:19:57 2024 -0300
Commit: Olivier Hallot 
CommitDate: Thu May 16 15:22:18 2024 +0200

tdf#159872 Link RAND* to RANDARRAY function

+ refactor

Change-Id: I54fdfca2d15f0ddca0e36a9513da011896e886cf
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/167743
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/source/text/scalc/01/04060106.xhp 
b/source/text/scalc/01/04060106.xhp
index e10a68ae61..3cd61a4c23 100644
--- a/source/text/scalc/01/04060106.xhp
+++ b/source/text/scalc/01/04060106.xhp
@@ -20,14 +20,14 @@
 
 
   
-Mathematical Functions
+Mathematical Functions
 /text/scalc/01/04060106.xhp
   
 
 
 
 
-
+
   mathematical functions
   Function Wizard; mathematical
   functions; mathematical functions
@@ -36,574 +36,574 @@
 
 
 Mathematical Functions
-This category contains the Mathematical 
functions for Calc. To open the Function Wizard, choose 
Insert - 
Function.
+This category contains the Mathematical 
functions for Calc. To open the Function Wizard, choose 
Insert - 
Function.
 
 
-
+
   ABS function
   absolute values
   values;absolute
 
 mw added two entries
-
+
 
 ABS
-Returns the absolute value of a number.
+Returns the absolute value of a number.
 
 
-ABS(Number)
-Number is the number whose absolute value is to 
be calculated. The absolute value of a number is its value without the +/- 
sign.
+ABS(Number)
+Number is the 
number whose absolute value is to be calculated. The absolute value of a number 
is its value without the +/- sign.
 
 
-=ABS(-56) returns 56.
-=ABS(12) returns 12.
-=ABS(0) returns 0.see also 
SIGN
+=ABS(-56) returns 56.
+=ABS(12) returns 12.
+=ABS(0) returns 0.see also 
SIGN
 
 
 
-
+
   ACOS function
 
 
-
+
 
 ACOS
-Returns the inverse trigonometric cosine of a 
number.
+Returns the inverse trigonometric cosine of a 
number.
 
 
-ACOS(Number)
-This function 
returns the inverse trigonometric cosine of Number, that is the 
angle (in radians) whose cosine is Number. The angle returned is between 0 and 
PI.
-To return the 
angle in degrees, use the DEGREES function.
+ACOS(Number)
+This function returns the 
inverse trigonometric cosine of Number, that is the angle (in 
radians) whose cosine is Number. The angle returned is between 0 and 
PI.
+To return the angle in degrees, 
use the DEGREES function.
 
 
-=ACOS(-1) returns 3.14159265358979 (PI radians)
-=DEGREES(ACOS(0.5)) returns 60. The cosine of 60 degrees is 
0.5.see also COS, SIN, TAN, COT, ASIN, ATAN, ATAN2, 
ACOT
+=ACOS(-1) returns 3.14159265358979 (PI radians)
+=DEGREES(ACOS(0.5)) returns 60. The cosine of 60 degrees is 
0.5.see also COS, SIN, TAN, COT, ASIN, ATAN, ATAN2, 
ACOT
 
 
 
 
-
+
   ACOSH function
 
 
-
+
 
 ACOSH
-Returns the inverse hyperbolic cosine of a 
number.
+Returns the inverse hyperbolic cosine of a 
number.
 
 
-ACOSH(Number)
-This function 
returns the inverse hyperbolic cosine of Number, that is the 
number whose hyperbolic cosine is Number.
-Number must be 
greater than or equal to 1.
+ACOSH(Number)
+This function returns the 
inverse hyperbolic cosine of Number, that is the number whose 
hyperbolic cosine is Number.
+Number must be greater than or 
equal to 1.
 
 
-=ACOSH(1) returns 0.
-=ACOSH(COSH(4)) returns 4.see also 
ASINH, ATANH, ACOTH, COSH, SINH, TANH, COTH
+=ACOSH(1) returns 0.
+=ACOSH(COSH(4)) returns 4.see also 
ASINH, ATANH, ACOTH, COSH, SINH, TANH, COTH
 
 
 
 
-
+
   ACOT function
 
 
-
+
 
 ACOT
-Returns the inverse cotangent (the arccotangent) of the 
given number.
+Returns the inverse cotangent (the arccotangent) of the 
given number.
 
 
-ACOT(Number)
-This function 
returns the inverse trigonometric cotangent of Number, that is the 
angle (in radians) whose cotangent is Number. The angle returned is between 0 
and PI.
-To return the 
angle in degrees, use the DEGREES function.
+ACOT(Number)
+This function returns the 
inverse trigonometric cotangent of Number, that is the angle (in 
radians) whose cotangent is Number. The angle returned is between 0 and 
PI.
+To return the angle in degrees, 
use the DEGREES function.
 
 
-=ACOT(1) returns 0.785398163397448 (PI/4 
radians).
-=DEGREES(ACOT(1)) returns 45. The tangent of 45 degrees is 
1.see also COS, SIN, TAN, COT, ACOS, ASIN, ATAN, 
ATAN2
+=ACOT(1) returns 0.785398163397448 (PI/4 
radians).
+=DEGREES(ACOT(1)) returns 45. The tangent of 45 degrees is 
1.see also COS, SIN, TAN, COT, ACOS, ASIN, ATAN, 
ATAN2
 
 
 
 
-
+
   ACOTH function
 
 
-
+
 
 ACOTH
-Returns the inverse hyperbolic cotangent of the given 
number.
+Returns the inverse hyperbolic cotangent of the given 
number.
 
 
-ACOTH(Number)
-This function 
returns the inverse hyperbolic cotangent of Number, that is the 

core.git: helpcontent2

[Olivier Hallot (via logerrit)]

 helpcontent2 |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit 84da5e360a635d9d0f2e1e4e6ac56eb81df8b5b5
Author: Olivier Hallot 
AuthorDate: Thu May 16 01:00:12 2024 -0300
Commit: Gerrit Code Review 
CommitDate: Thu May 16 06:00:12 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'master'
  to c42e46cb11f0d46bf918f3cc276750e380ed4af5
  - tdf#159872 More precision on RANDARRAY function

after https://gerrit.libreoffice.org/c/core/+/167645

Change-Id: I1ab0d6da97e0552bdf39d3670ddb953e00f2e81f
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/167700
Reviewed-by: Adolfo Jayme Barrientos 
Tested-by: Jenkins

diff --git a/helpcontent2 b/helpcontent2
index de95bc710fa1..c42e46cb11f0 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit de95bc710fa1d7d50842da37e06063a9157d2223
+Subproject commit c42e46cb11f0d46bf918f3cc276750e380ed4af5

help.git: source/text

[Olivier Hallot (via logerrit)]

 source/text/scalc/01/func_randarray.xhp |   11 ++-
 source/text/scalc/01/func_sequence.xhp  |7 ---
 2 files changed, 10 insertions(+), 8 deletions(-)

New commits:
commit c42e46cb11f0d46bf918f3cc276750e380ed4af5
Author: Olivier Hallot 
AuthorDate: Wed May 15 13:50:52 2024 -0300
Commit: Adolfo Jayme Barrientos 
CommitDate: Thu May 16 06:00:12 2024 +0200

tdf#159872 More precision on RANDARRAY function

after https://gerrit.libreoffice.org/c/core/+/167645

Change-Id: I1ab0d6da97e0552bdf39d3670ddb953e00f2e81f
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/167700
Reviewed-by: Adolfo Jayme Barrientos 
Tested-by: Jenkins

diff --git a/source/text/scalc/01/func_randarray.xhp 
b/source/text/scalc/01/func_randarray.xhp
index b63c9219ed..6ac003e8ef 100644
--- a/source/text/scalc/01/func_randarray.xhp
+++ b/source/text/scalc/01/func_randarray.xhp
@@ -22,16 +22,17 @@
 
 
 RANDARRAY
-Generates an array 
of random numbers between two values.
+Generates an array 
of random numbers between two limit values.
 
 
-RANDARRAY(Rows, Columns, 
Min, Max, Whole number)
+RANDARRAY([Rows], [Columns], 
[Min], [Max], [Integers])
 Rows: 
(optional) the number of rows to return. If omitted, the value is 1.
 Columns: 
(optional) the number of columns to return. If omitted, the value is 
1.
-Min: 
(optional) the minimum number in the array. If omitted, the minimum value is 
0.
-Max: 
(optional) the maximum number in the array. If omitted, the maximum value is 
1.
-Whole 
number: (optional) returns whole numbers (TRUE) or decimal numbers 
(FALSE). Default is FALSE.
+Min: 
(optional) The lower limit of the generated numbers. If omitted, the minimum 
value is 0.
+Max: 
(optional) The upper limit of the generated numbers. If omitted, the maximum 
value is 1.
+Integers: 
(optional) returns whole numbers (TRUE) or decimal numbers (FALSE). Default is 
FALSE.
 If Rows and Columns 
are greater than 1, the RANDARRAY function must be entered as an array 
formula.
+If Rows or 
Columns are references to other cells content, the array 
dimensions do not change when the referenced content change. The array formula 
must be deleted and re-entered.
 
 {=RANDARRAY(10,4,10,50,1)} returns an 
array of 10 rows, 4 columns with minimum value 10 and maximum value of 50 of 
whole numbers (integers).
 
diff --git a/source/text/scalc/01/func_sequence.xhp 
b/source/text/scalc/01/func_sequence.xhp
index d49ac5870d..64ba46a249 100644
--- a/source/text/scalc/01/func_sequence.xhp
+++ b/source/text/scalc/01/func_sequence.xhp
@@ -25,15 +25,16 @@
 Generate a list of 
sequential numbers in an array.
 
 
-SEQUENCE(Rows, Columns, 
Start, Step)
+SEQUENCE(Rows, Columns, 
[Start], [Step])
 Rows: a 
positive integer. The number of rows to return.
 Columns: a 
positive integer. The number of columns to return.
 Start: 
optional. The initial value of the sequence. If omitted, default is 
1.
 Step: 
optional. The increment of each subsequent value in the array. If omitted, 
default is 1.
 If Rows and Columns 
are greater than 1, the SEQUENCE function must be entered as an array 
formula.
-The array is filled from 
the first row to the right up to the value of Columns, and then 
down to the  number of rows.
+If Rows or 
Columns are references to other cells content, the array 
dimensions do not change when the referenced content change. The array formula 
must be deleted and re-entered.
+The array is filled from 
the first row to the right up to the value of Columns, and then 
down to the number of rows.
 
-{=SEQUENCE(3,3,10,11)} returns a 3 by 
3 array below with upper right value of 10 and filling the array to the right 
and then downward.
+{=SEQUENCE(3,3,10,11)} returns the 3 
by 3 array below with upper right value of 10 and filling the array to the 
right and then downward in steps of 11.
 
 
 

core.git: helpcontent2

[Olivier Hallot (via logerrit)]

 helpcontent2 |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit 1b45ca1aa7d7cb8e7adcc07f8c60e26a413eca8c
Author: Olivier Hallot 
AuthorDate: Wed May 15 21:06:05 2024 -0300
Commit: Gerrit Code Review 
CommitDate: Thu May 16 02:06:05 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'master'
  to de95bc710fa1d7d50842da37e06063a9157d2223
  - Fix bad link in contents tree.

Change-Id: I571354d3cc458c88230cdb5b6b51f98baefa92ec
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/167701
Reviewed-by: Taichi Haradaguchi <20001...@ymail.ne.jp>
Tested-by: Jenkins

diff --git a/helpcontent2 b/helpcontent2
index fa4dcadb1517..de95bc710fa1 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit fa4dcadb1517c66282f5fc33bf5e42a6cb305609
+Subproject commit de95bc710fa1d7d50842da37e06063a9157d2223

help.git: source/auxiliary

[Olivier Hallot (via logerrit)]

 source/auxiliary/shared.tree |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit de95bc710fa1d7d50842da37e06063a9157d2223
Author: Olivier Hallot 
AuthorDate: Wed May 15 14:03:21 2024 -0300
Commit: Taichi Haradaguchi <20001...@ymail.ne.jp>
CommitDate: Thu May 16 02:06:05 2024 +0200

Fix bad link in contents tree.

Change-Id: I571354d3cc458c88230cdb5b6b51f98baefa92ec
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/167701
Reviewed-by: Taichi Haradaguchi <20001...@ymail.ne.jp>
Tested-by: Jenkins

diff --git a/source/auxiliary/shared.tree b/source/auxiliary/shared.tree
index d96471f4f0..e3df907add 100644
--- a/source/auxiliary/shared.tree
+++ b/source/auxiliary/shared.tree
@@ -129,7 +129,7 @@
 
   Copying 
Drawing Objects Into Other Documents
   Copying 
Graphics Between Documents
-  Copying Graphics From 
the Gallery
+  Copying Graphics 
From the Gallery
   Copying 
Spreadsheet Areas to Text Documents
 
 

core.git: sc/inc

[Olivier Hallot (via logerrit)]

 sc/inc/scfuncs.hrc |   12 ++--
 1 file changed, 6 insertions(+), 6 deletions(-)

New commits:
commit 81e7c91e7d55f20705855d18e6a74db8ae45057d
Author: Olivier Hallot 
AuthorDate: Tue May 14 17:20:02 2024 -0300
Commit: Olivier Hallot 
CommitDate: Wed May 15 16:40:54 2024 +0200

Review RANDARRAY arguments explanation

- As discussed in IRC, remove potential ambiguities in Min and Max
- changed "Whole number" to "Integer" to distance terms used in other
  suites
- Rephrased main RANDARRAY definition

Change-Id: I5e557f1e11ce321652df04a300f2cc4103fe1161
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/167645
Tested-by: Jenkins
Reviewed-by: Balazs Varga 
Reviewed-by: Olivier Hallot 

diff --git a/sc/inc/scfuncs.hrc b/sc/inc/scfuncs.hrc
index eaeb43326a87..6d57127f18bf 100644
--- a/sc/inc/scfuncs.hrc
+++ b/sc/inc/scfuncs.hrc
@@ -4224,7 +4224,7 @@ const TranslateId SC_OPCODE_SORTBY_ARY[] =
 // -=*# Resource for function SEQUENCE #*=-
 const TranslateId SC_OPCODE_MAT_SEQUENCE_ARY[] =
 {
-NC_("SC_OPCODE_MAT_SEQUENCE", "Allows you to generate a list of sequential 
numbers in an array, such as 1, 2, 3, 4."),
+NC_("SC_OPCODE_MAT_SEQUENCE", "Generates a list of sequential numbers in 
an array, such as 1, 2, 3, 4."),
 NC_("SC_OPCODE_MAT_SEQUENCE", "Rows"),
 NC_("SC_OPCODE_MAT_SEQUENCE", "The number of rows to return."),
 NC_("SC_OPCODE_MAT_SEQUENCE", "Columns"),
@@ -4238,17 +4238,17 @@ const TranslateId SC_OPCODE_MAT_SEQUENCE_ARY[] =
 // -=*# Resource for function RANDARRAY #*=-
 const TranslateId SC_OPCODE_RANDARRAY_ARY[] =
 {
-NC_("SC_OPCODE_RANDARRAY", "RANDARRAY function generates an array of 
random numbers between two values."),
+NC_("SC_OPCODE_RANDARRAY", "Generates an array of random numbers between 
two limit values."),
 NC_("SC_OPCODE_RANDARRAY", "Rows"),
 NC_("SC_OPCODE_RANDARRAY", "The number of rows to return."),
 NC_("SC_OPCODE_RANDARRAY", "Columns"),
 NC_("SC_OPCODE_RANDARRAY", "The number of columns to return."),
 NC_("SC_OPCODE_RANDARRAY", "Min"),
-NC_("SC_OPCODE_RANDARRAY", "The minimum number you would like returned."),
+NC_("SC_OPCODE_RANDARRAY", "The lower limit of the generated numbers."),
 NC_("SC_OPCODE_RANDARRAY", "Max"),
-NC_("SC_OPCODE_RANDARRAY", "The maximum number you would like returned."),
-NC_("SC_OPCODE_RANDARRAY", "Whole number"),
-NC_("SC_OPCODE_RANDARRAY", "Return a whole number or a decimal value.")
+NC_("SC_OPCODE_RANDARRAY", "The upper limit of the generated numbers."),
+NC_("SC_OPCODE_RANDARRAY", "Integers"),
+NC_("SC_OPCODE_RANDARRAY", "Return whole numbers (TRUE) or decimal values 
(FALSE).")
 };
 
 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */

core.git: 2 commits - helpcontent2

[Olivier Hallot (via logerrit)]

 helpcontent2 |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit 194e5bfaf79c0a15fee07bfe8326c3f3ceb783b8
Author: Olivier Hallot 
AuthorDate: Tue May 14 07:43:51 2024 -0300
Commit: Gerrit Code Review 
CommitDate: Tue May 14 12:43:51 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'master'
  to fa4dcadb1517c66282f5fc33bf5e42a6cb305609
  - tdf#159279 On page numbering

Added link to Title Page feature

Change-Id: If802ebc475caee266dce5257d46662ecc7a0a515
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/167610
Reviewed-by: Olivier Hallot 
Tested-by: Jenkins

diff --git a/helpcontent2 b/helpcontent2
index 8c31e6a31040..fa4dcadb1517 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit 8c31e6a310406bf57c7c9dbdc06b0466b46593d3
+Subproject commit fa4dcadb1517c66282f5fc33bf5e42a6cb305609
commit 2eb5a202bb5c20658aa8ef030f811b626709a6f0
Author: Olivier Hallot 
AuthorDate: Tue May 14 07:43:39 2024 -0300
Commit: Gerrit Code Review 
CommitDate: Tue May 14 12:43:39 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'master'
  to 8c31e6a310406bf57c7c9dbdc06b0466b46593d3
  - tdf#159872 Help for RANDARRAY function

Change-Id: I5ee6dba1f757bf2ab2c4659cc9a151e4210cf97d
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/167608
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/helpcontent2 b/helpcontent2
index bc1435efdd13..8c31e6a31040 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit bc1435efdd13fb2f2b6cf78e946c7836db54d9c8
+Subproject commit 8c31e6a310406bf57c7c9dbdc06b0466b46593d3

help.git: 2 commits - source/text

[Olivier Hallot (via logerrit)]

 source/text/scalc/01/func_randarray.xhp |   11 +--
 source/text/swriter/guide/footer_pagenumber.xhp |   22 +++---
 2 files changed, 20 insertions(+), 13 deletions(-)

New commits:
commit fa4dcadb1517c66282f5fc33bf5e42a6cb305609
Author: Olivier Hallot 
AuthorDate: Mon May 13 16:41:14 2024 -0300
Commit: Olivier Hallot 
CommitDate: Tue May 14 12:43:50 2024 +0200

tdf#159279 On page numbering

Added link to Title Page feature

Change-Id: If802ebc475caee266dce5257d46662ecc7a0a515
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/167610
Reviewed-by: Olivier Hallot 
Tested-by: Jenkins

diff --git a/source/text/swriter/guide/footer_pagenumber.xhp 
b/source/text/swriter/guide/footer_pagenumber.xhp
index 34eaeab11e..4d3b90985f 100644
--- a/source/text/swriter/guide/footer_pagenumber.xhp
+++ b/source/text/swriter/guide/footer_pagenumber.xhp
@@ -22,39 +22,39 @@
 
 
   
- Inserting Page Numbers in 
Footers
+ Inserting Page Numbers in Footers
  /text/swriter/guide/footer_pagenumber.xhp
   


-footers; with page numbers
+footers; with page 
numbers
   pages; numbers and count of
   page numbers; footers
   numbering;pages
 
-Inserting Page Numbers in 
Footers
-
-  You can 
easily insert a page number field in the footer of your document. You can also 
add a page count to the footer, for example, in the form "Page 9 of 
12"
+Inserting Page Numbers in 
Footers
+  You can easily insert a 
page number field in the footer of your document. You can also add a page count 
to the footer, for example, in the form "Page 9 of 12"
   To Insert a Page Number
   
  
-Choose Insert - Header and Footer - Footer and 
select the page style that you want to add the footer to.
+Choose Insert 
- Header and Footer - Footer and select the page style that you want to 
add the footer to.
  
  
-Choose Insert - Field - Page Number.
+Choose Insert 
- Field - Page Number.
  
   
-  If you 
want, you can align the page number field as you would text.
+  If you want, you can 
align the page number field as you would text.
   To Additionally Add a Page Count
   
  
-Click in front of the page number field, type Page and enter a space; click after the field, enter a 
space and then type of and enter another 
space.
+Click in front of 
the page number field, type Page and enter a space; 
click after the field, enter a space and then type of and enter another space.
  
  
-Choose Insert - Field - Page Count.
+Choose Insert 
- Field - Page Count.
  
   
-
+  
+  Title pages 
provides common ways to create documents with different page numbering 
schemes.
 
   
   
commit 8c31e6a310406bf57c7c9dbdc06b0466b46593d3
Author: Olivier Hallot 
AuthorDate: Mon May 13 13:12:17 2024 -0300
Commit: Olivier Hallot 
CommitDate: Tue May 14 12:43:38 2024 +0200

tdf#159872 Help for RANDARRAY function

Change-Id: I5ee6dba1f757bf2ab2c4659cc9a151e4210cf97d
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/167608
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/source/text/scalc/01/func_randarray.xhp 
b/source/text/scalc/01/func_randarray.xhp
index b3b9a5c1e1..b63c9219ed 100644
--- a/source/text/scalc/01/func_randarray.xhp
+++ b/source/text/scalc/01/func_randarray.xhp
@@ -22,11 +22,18 @@
 
 
 RANDARRAY
-(...)
+Generates an array 
of random numbers between two values.
 
 
-RANDARRAY(...)
+RANDARRAY(Rows, Columns, 
Min, Max, Whole number)
+Rows: 
(optional) the number of rows to return. If omitted, the value is 1.
+Columns: 
(optional) the number of columns to return. If omitted, the value is 
1.
+Min: 
(optional) the minimum number in the array. If omitted, the minimum value is 
0.
+Max: 
(optional) the maximum number in the array. If omitted, the maximum value is 
1.
+Whole 
number: (optional) returns whole numbers (TRUE) or decimal numbers 
(FALSE). Default is FALSE.
+If Rows and Columns 
are greater than 1, the RANDARRAY function must be entered as an array 
formula.
 
+{=RANDARRAY(10,4,10,50,1)} returns an 
array of 10 rows, 4 columns with minimum value 10 and maximum value of 50 of 
whole numbers (integers).
 
 
 

help.git: source/text

[Olivier Hallot (via logerrit)]

 source/text/scalc/01/func_day.xhp|   19 ++-
 source/text/scalc/01/func_hour.xhp   |   17 +
 source/text/scalc/01/func_minute.xhp |   19 ++-
 source/text/scalc/01/func_month.xhp  |   19 ++-
 source/text/scalc/01/func_second.xhp |   17 +
 source/text/scalc/01/func_year.xhp   |   19 ++-
 6 files changed, 58 insertions(+), 52 deletions(-)

New commits:
commit bc1435efdd13fb2f2b6cf78e946c7836db54d9c8
Author: Olivier Hallot 
AuthorDate: Mon May 13 12:06:07 2024 -0300
Commit: Olivier Hallot 
CommitDate: Tue May 14 12:42:57 2024 +0200

tdf#127477 Description of date & time functions in the help

Add precision on rounding and trunking of date and time values

SECOND() rounds value to nearest integer
MINUTE, HOUR, DAY, MONTH, YEAR truncates to integer part.

Change-Id: I115557dd85a9328185b197abfcd233b62b0beb78
reference: https://bugs.documentfoundation.org/show_bug.cgi?id=127476#c9
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/167605
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/source/text/scalc/01/func_day.xhp 
b/source/text/scalc/01/func_day.xhp
index 434f5bae47..94242055a9 100644
--- a/source/text/scalc/01/func_day.xhp
+++ b/source/text/scalc/01/func_day.xhp
@@ -19,26 +19,27 @@
 
 
 
-DAY 
+DAY 
 /text/scalc/01/func_day.xhp
 
 
 
-DAY function
+DAY 
function
 
-DAY
+DAY
 
-Returns the day of given date value. The day is 
returned as an integer between 1 and 31. You can also enter a negative 
date/time value.
+Returns the day of given date value. The day is 
returned as an integer between 1 and 31. You can also enter a negative 
date/time value.
 
 
-DAY(Number)
-Number is the internal date number.
+DAY(Number)
+Number is the 
internal date number.
+DAY() returns the integer part of the 
day.
 
 
 
-=DAY(1)  returns 31 (since $[officename] starts counting at 
zero from December 30, 1899)
-=DAY(NOW())  returns the current day.
-=DAY(C4)  returns 5 if you enter 1901-08-05 in cell C4 (the 
date value might get formatted differently after you press Enter).
+=DAY(1)  returns 31 (since $[officename] starts counting at 
zero from December 30, 1899)
+=DAY(NOW())  returns the current day.
+=DAY(C4)  returns 5 if you enter 1901-08-05 in cell C4 (the 
date value might get formatted differently after you press Enter).
 
 https://wiki.documentfoundation.org/Documentation/Calc_Functions/DAY;>DAY 
wiki page.
 
diff --git a/source/text/scalc/01/func_hour.xhp 
b/source/text/scalc/01/func_hour.xhp
index 90f4afec5b..89af023368 100644
--- a/source/text/scalc/01/func_hour.xhp
+++ b/source/text/scalc/01/func_hour.xhp
@@ -19,26 +19,27 @@
 
 
 
-HOUR 
+HOUR 
 /text/scalc/01/func_hour.xhp
 
 
 
-HOUR function
+HOUR 
function
 
-
+
 HOUR
 
-Returns the hour for a given time value. The hour 
is returned as an integer between 0 and 23.
+Returns the hour for a given time value. The hour 
is returned as an integer between 0 and 23.
 
 
-HOUR(Number)
-
+HOUR(Number)
+
 Number, as a time value, is a decimal, for which the hour is to 
be returned.
+HOUR() returns the integer part of the 
hour.
 
-
+
 =HOUR(NOW()) returns the current hour
-
+
 =HOUR(C4) returns 17 if the contents of C4 = 17:20:00.
 
 https://wiki.documentfoundation.org/Documentation/Calc_Functions/HOUR;>HOUR
 wiki page.
diff --git a/source/text/scalc/01/func_minute.xhp 
b/source/text/scalc/01/func_minute.xhp
index 3c1b5275cf..8b5021dba0 100644
--- a/source/text/scalc/01/func_minute.xhp
+++ b/source/text/scalc/01/func_minute.xhp
@@ -19,28 +19,29 @@
 
 
 
-MINUTE
+MINUTE
 /text/scalc/01/func_minute.xhp
 
 
 
-MINUTE function
+MINUTE 
function
 
-
+
 MINUTE
 
-Calculates the minute for an internal time value. 
The minute is returned as a number between 0 and 59.
+Calculates the minute for an internal time value. 
The minute is returned as a number between 0 and 59.
 
 
-MINUTE(Number)
-
+MINUTE(Number)
+
 Number, as a time value, is a decimal number where the number of 
the minute is to be returned.
+MINUTE() returns the integer part of the 
minute.
 
-
+
 =MINUTE(8.999) returns 58
-
+
 =MINUTE(8.) returns 59
-
+
 =MINUTE(NOW()) returns the current minute 
value.
 
 https://wiki.documentfoundation.org/Documentation/Calc_Functions/MINUTE;>MINUTE
 wiki page.
diff --git a/source/text/scalc/01/func_month.xhp 
b/source/text/scalc/01/func_month.xhp
index efba950ddc..0213a7981c 100644
--- a/source/text/scalc/01/func_month.xhp
+++ b/source/text/scalc/01/func_month.xhp
@@ -19,27 +19,28 @@
 
 
 
-MONTH 
+MONTH 
 /text/scalc/01/func_month.xhp
 
 
 
-MONTH function
+MONTH 
function
 
-
+
 MONTH
 
-Returns the month for the given date value. The 
month is returned as an integer between 1 and 12.
+Returns the month for the given date value. The 
month is returned as an integer between 1 and 12.
 
 
-MONTH(Number)
-
-Number is the internal date number.
+MONTH(Number)
+
+Number is the internal 

help.git: source/text

[Olivier Hallot (via logerrit)]

 source/text/scalc/01/02120100.xhp |6 +-
 1 file changed, 5 insertions(+), 1 deletion(-)

New commits:
commit 71a04be1be73ec7cd27e14e152c01521b3c4b33e
Author: Olivier Hallot 
AuthorDate: Fri May 10 11:59:26 2024 -0300
Commit: Olivier Hallot 
CommitDate: Mon May 13 13:24:16 2024 +0200

tdf#160057 Help update for first and rest page style in Calc

Change-Id: I728452dac691507e0aa2651dac8bcc9908eca70e
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/167482
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/source/text/scalc/01/02120100.xhp 
b/source/text/scalc/01/02120100.xhp
index fa2fc6431c..c51216b28b 100644
--- a/source/text/scalc/01/02120100.xhp
+++ b/source/text/scalc/01/02120100.xhp
@@ -40,14 +40,18 @@
 
 
 Headers and 
Footers
-   Defines or 
formats a header or footer for the page style in use.
+   Defines or 
formats a header or footer for the page style in use. You can define separate 
settings for the first page and the remaining pages.
 
 

 
+Header or Footer (first and rest)
+Defines the header or 
footer settings for the first page or the remaining pages.
+The first page and 
remaining pages distinction depends on the choice of Same content on 
first page in Page Header and Footer.
 
 Left Area
   Enter the text to 
be displayed at the left side of the header or footer.
+  When Same content on first 
page above is not selected, the left area is not available 
on first page.
 
 Center Area
   Enter the 
text to be displayed at the center of the header or footer.

core.git: sc/uiconfig

[Olivier Hallot (via logerrit)]

 sc/uiconfig/scalc/ui/sparklinedialog.ui |  139 +---
 1 file changed, 130 insertions(+), 9 deletions(-)

New commits:
commit bd9cd4365efd03223d619e0044fbeda0e687b0d9
Author: Olivier Hallot 
AuthorDate: Mon May 6 15:10:06 2024 -0300
Commit: Olivier Hallot 
CommitDate: Tue May 7 12:42:46 2024 +0200

tdf#149252 Add extended tips to sparklines dialog

Change-Id: I62487894a2e507b9f63f88745e1ce54ce471e863
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/167246
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/sc/uiconfig/scalc/ui/sparklinedialog.ui 
b/sc/uiconfig/scalc/ui/sparklinedialog.ui
index 40d817b8bea8..92ead02fcc67 100644
--- a/sc/uiconfig/scalc/ui/sparklinedialog.ui
+++ b/sc/uiconfig/scalc/ui/sparklinedialog.ui
@@ -1,5 +1,5 @@
 
-
+
 
   
   
@@ -137,6 +137,11 @@
 
   
 
+
+  
+Enter 
the cell range of the data fopr the sparklines.
+  
+
   
   
 1
@@ -169,6 +174,11 @@
 
   
 
+
+  
+Select 
the cell range to receive the sparkline.
+  
+
   
   
 1
@@ -261,7 +271,6 @@
 
 
   
-
 True
 True
 False
@@ -274,6 +283,11 @@
 
   
 
+
+  
+Select the 
main color for the sparklines.
+  
+
   
   
 1
@@ -291,6 +305,11 @@
 
   
 
+
+  
+Check and 
select the color for negative points.
+  
+
   
   
 0
@@ -299,7 +318,6 @@
 
 
   
-
 True
 True
 False
@@ -312,6 +330,11 @@
 
   
 
+
+  
+Select 
the color for the negative points.
+  
+
   
   
 1
@@ -329,6 +352,11 @@
 
   
 
+
+  
+check and 
select the color for high points.
+  
+
   
   
 0
@@ -337,7 +365,6 @@
 
 
   
-
 True
 True
 False
@@ -350,6 +377,11 @@
 
   
 
+
+  
+Select the 
color for the high point.
+  
+
   
   
 1
@@ -367,6 +399,11 @@
 
   
 
+
+  
+Check and 
select the color for low points.
+  
+
   
   
 0
@@ -375,7 +412,6 @@
 
 
   
-
 True
 True
 False
@@ -388,6 +424,11 @@
 
   
 
+
+  
+Select the 
color for the low point.
+  
+
   
   
 1
@@ -405,6 +446,11 @@
 
   
 
+

core.git: helpcontent2

[Olivier Hallot (via logerrit)]

 helpcontent2 |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit 7d508c60ef15dd867139b2a03cd143327c161480
Author: Olivier Hallot 
AuthorDate: Sun May 5 11:45:44 2024 -0300
Commit: Gerrit Code Review 
CommitDate: Sun May 5 16:45:44 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'master'
  to 5217d34ba89beaa113bb30e4eb76b6c2c0a7ee26
  - tdf#160903 Advanced Filter help page needs description of "criteria" 
syntax

+ refactor

Change-Id: Ib60247386284d9041136dc3cda0f1fef174b2051
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/167104
Reviewed-by: Olivier Hallot 
Tested-by: Jenkins

diff --git a/helpcontent2 b/helpcontent2
index 0d4e6c574519..5217d34ba89b 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit 0d4e6c5745193e2a265e6561dbc25151763d61f5
+Subproject commit 5217d34ba89beaa113bb30e4eb76b6c2c0a7ee26

help.git: source/text

[Olivier Hallot (via logerrit)]

 source/text/scalc/01/04060101.xhp  |  333 ++---
 source/text/scalc/01/12040300.xhp  |1 
 source/text/scalc/01/ex_data_stat_func.xhp |   48 ++--
 3 files changed, 192 insertions(+), 190 deletions(-)

New commits:
commit 5217d34ba89beaa113bb30e4eb76b6c2c0a7ee26
Author: Olivier Hallot 
AuthorDate: Fri May 3 18:32:48 2024 -0300
Commit: Olivier Hallot 
CommitDate: Sun May 5 16:45:44 2024 +0200

tdf#160903 Advanced Filter help page needs description of "criteria" syntax

+ refactor

Change-Id: Ib60247386284d9041136dc3cda0f1fef174b2051
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/167104
Reviewed-by: Olivier Hallot 
Tested-by: Jenkins

diff --git a/source/text/scalc/01/04060101.xhp 
b/source/text/scalc/01/04060101.xhp
index 3e460b4e69..bd0864fb72 100644
--- a/source/text/scalc/01/04060101.xhp
+++ b/source/text/scalc/01/04060101.xhp
@@ -22,12 +22,12 @@
 
 
 
-Database Functions
+Database Functions
 /text/scalc/01/04060101.xhp
 
 
 
-
+
 Function Wizard; databases
 functions; database functions
 databases; functions in $[officename] Calc
@@ -35,7 +35,7 @@
 
 Database Functions
 Overview
-The twelve functions in the 
Database category help you to analyze a simple database that occupies a 
rectangular spreadsheet area comprising columns and rows, with the data 
organized as one row for each record. The header cell of each column 
displays the name of the column and that name usually reflects the contents of 
each cell in that column.
+The twelve functions in the Database category help you to 
analyze a simple database that occupies a rectangular spreadsheet area 
comprising columns and rows, with the data organized as one row for each 
record. The header cell of each column displays the name of the 
column and that name usually reflects the contents of each cell in that 
column.
 The functions 
in the Database category take three arguments as follows:
 
 
@@ -84,13 +84,12 @@
 
 SearchCriteria argument
 SearchCriteria specifies the range of 
cells containing search criteria. Like Database, its first row is 
also field names, and subsequent rows are conditions for related fields. The 
Database and SearchCriteria areas need not be 
adjacent, or even on the same sheet.
+
 One way 
of defining the range of cells is to enter the cell reference for the upper 
left-hand cell, followed by a colon (:), and then the lower right-hand cell 
reference. For example, A13:B14. The cell range may also be specified by 
passing the name of a defined named range or database range. If the name does 
not match the name of a defined range, Calc reports a #NAME? error.
 Err:504 
(error in parameter list) may also be reported as a result of an invalid 
SearchCriteria argument.
 The 
contents of the SearchCriteria area are described in more detail 
in the next section.
 
-
 
-
 Defining Search Criteria
 The number of 
columns occupied by the SearchCriteria area need not be the same 
as the width of the Database area. All headings that appear in the 
first row of SearchCriteria must be identical to headings in the 
first row of Database. However, not all headings in 
Database need appear in the first row of 
SearchCriteria, while a heading in Database can 
appear multiple times in the first row of 
SearchCriteria.
 Search criteria 
are entered into the cells of the second and subsequent rows of the 
SearchCriteria area, below the row containing headings. Blank 
cells within the SearchCriteria area are ignored.
@@ -104,230 +103,230 @@
 Another setting 
that affects how the search criteria are handled is the Search 
criteria = and  must apply to whole cells  option on the 
%PRODUCTNAME - 
PreferencesTools - 
Options - %PRODUCTNAME Calc 
- Calculate dialog. This option controls whether the search 
criteria you set for the Database functions must match the whole cell exactly. 
When interoperability with Microsoft Excel is important for your spreadsheet, 
this option should be enabled.
 
 Examples of Database Function Use
-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.
+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 

core.git: helpcontent2

[Olivier Hallot (via logerrit)]

 helpcontent2 |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit 510e6224951ef492d8d957a8894044276dd8b9c9
Author: Olivier Hallot 
AuthorDate: Fri May 3 10:32:39 2024 -0300
Commit: Gerrit Code Review 
CommitDate: Fri May 3 15:32:39 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'master'
  to d5d56e1d29b65749978ae5e9801531200477761b
  - tdf#150760 Missing link for Column Width in Base.

+ refactor

Change-Id: I30052dc59c9ec6de6f398b9052739b64396be3a6
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/166878
Reviewed-by: Olivier Hallot 
Tested-by: Jenkins

diff --git a/helpcontent2 b/helpcontent2
index 92ee035a864b..d5d56e1d29b6 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit 92ee035a864bdd5691a589704a0b8cb609f2b0bb
+Subproject commit d5d56e1d29b65749978ae5e9801531200477761b

help.git: source/text

[Olivier Hallot (via logerrit)]

 source/text/shared/01/05340200.xhp |   29 ++---
 1 file changed, 14 insertions(+), 15 deletions(-)

New commits:
commit d5d56e1d29b65749978ae5e9801531200477761b
Author: Olivier Hallot 
AuthorDate: Mon Apr 29 17:42:05 2024 -0300
Commit: Olivier Hallot 
CommitDate: Fri May 3 15:32:39 2024 +0200

tdf#150760 Missing link for Column Width in Base.

+ refactor

Change-Id: I30052dc59c9ec6de6f398b9052739b64396be3a6
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/166878
Reviewed-by: Olivier Hallot 
Tested-by: Jenkins

diff --git a/source/text/shared/01/05340200.xhp 
b/source/text/shared/01/05340200.xhp
index 340a12b2b9..25383ef83c 100644
--- a/source/text/shared/01/05340200.xhp
+++ b/source/text/shared/01/05340200.xhp
@@ -1,6 +1,4 @@
 
-
-
 
-
 
 
 
-Column width
+Column width
 /text/shared/01/05340200.xhp
 
 
@@ -30,19 +27,21 @@
 
 
 
-
-
-  
-  
-Column width
-  Changes the width of the current column, or the selected 
columns.
+
+
+
+
+
+
+Column width
+  Changes the width of the current column, or the selected 
columns.
   
   
 
-  You can also 
change the width of a column by dragging the divider beside the column 
header.  To fit the 
column width to the cell contents, double-click the divider. 

-  Width
-  Enter the 
column width that you want to use.
-   Default value 
Automatic 
-  Automatically adjusts the column width based on the 
current font.
+  You can also change the width 
of a column by dragging the divider beside the column header.  To fit the column width to the cell 
contents, double-click the divider. 
+  Width
+  Enter the 
column width that you want to use.
+   
Default value 
Automatic 
+  Automatically adjusts the column width based on the 
current font.
  
 

core.git: helpcontent2

[Olivier Hallot (via logerrit)]

 helpcontent2 |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit 694f63d27fdd915239ec5f1d4cccd9b85bfff787
Author: Olivier Hallot 
AuthorDate: Thu May 2 10:43:39 2024 -0300
Commit: Gerrit Code Review 
CommitDate: Thu May 2 15:43:39 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'master'
  to 92ee035a864bdd5691a589704a0b8cb609f2b0bb
  - tdf#159872 Help page for SEQUENCE Calc function.

Change-Id: I7644490320b2c774298f058c263fa30af51e
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/166987
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/helpcontent2 b/helpcontent2
index 0d4e0c045234..92ee035a864b 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit 0d4e0c0452346d797ae5eda7e3c1c61d73f6eb3c
+Subproject commit 92ee035a864bdd5691a589704a0b8cb609f2b0bb

help.git: source/text

[Olivier Hallot (via logerrit)]

 source/text/scalc/01/func_sequence.xhp |   46 +++--
 1 file changed, 44 insertions(+), 2 deletions(-)

New commits:
commit 92ee035a864bdd5691a589704a0b8cb609f2b0bb
Author: Olivier Hallot 
AuthorDate: Wed May 1 18:02:05 2024 -0300
Commit: Olivier Hallot 
CommitDate: Thu May 2 15:43:38 2024 +0200

tdf#159872 Help page for SEQUENCE Calc function.

Change-Id: I7644490320b2c774298f058c263fa30af51e
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/166987
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/source/text/scalc/01/func_sequence.xhp 
b/source/text/scalc/01/func_sequence.xhp
index bd53b346ec..d49ac5870d 100644
--- a/source/text/scalc/01/func_sequence.xhp
+++ b/source/text/scalc/01/func_sequence.xhp
@@ -22,11 +22,53 @@
 
 
 SEQUENCE
-(...)
+Generate a list of 
sequential numbers in an array.
 
 
-SEQUENCE(...)
+SEQUENCE(Rows, Columns, 
Start, Step)
+Rows: a 
positive integer. The number of rows to return.
+Columns: a 
positive integer. The number of columns to return.
+Start: 
optional. The initial value of the sequence. If omitted, default is 
1.
+Step: 
optional. The increment of each subsequent value in the array. If omitted, 
default is 1.
+If Rows and Columns 
are greater than 1, the SEQUENCE function must be entered as an array 
formula.
+The array is filled from 
the first row to the right up to the value of Columns, and then 
down to the  number of rows.
 
+{=SEQUENCE(3,3,10,11)} returns a 3 by 
3 array below with upper right value of 10 and filling the array to the right 
and then downward.
+
+
+
+10
+
+
+21
+
+
+32
+
+
+
+
+43
+
+
+54
+
+
+65
+
+
+
+
+76
+
+
+87
+
+
+98
+
+
+
 
 
 

core.git: helpcontent2

[Olivier Hallot (via logerrit)]

 helpcontent2 |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit 9bc04a380016c7537850b3f929afab21448eac03
Author: Olivier Hallot 
AuthorDate: Mon Apr 29 15:51:44 2024 -0300
Commit: Gerrit Code Review 
CommitDate: Mon Apr 29 20:51:44 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'master'
  to 0d4e0c0452346d797ae5eda7e3c1c61d73f6eb3c
  - Fix indexer="include" in  Help files.

+ refactor

Change-Id: Ia0dfdc0f88f40776042ca0b745e26dc9e0cd479f
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/166874
Reviewed-by: Olivier Hallot 
Tested-by: Jenkins

diff --git a/helpcontent2 b/helpcontent2
index 3fa70de3d05c..0d4e0c045234 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit 3fa70de3d05c43e190a2d2718a43667bda3ff5f1
+Subproject commit 0d4e0c0452346d797ae5eda7e3c1c61d73f6eb3c

help.git: 2 commits - source/text

[Olivier Hallot (via logerrit)]

 source/text/sdatabase/0202.xhp|   20 
 source/text/sdatabase/02010100.xhp|  524 +-
 source/text/sdatabase/0400.xhp|   14 
 source/text/sdatabase/0403.xhp|   22 -
 source/text/sdatabase/0500.xhp|8 
 source/text/sdatabase/0501.xhp|   10 
 source/text/sdatabase/0501.xhp|   64 +--
 source/text/sdatabase/05020100.xhp|   44 +-
 source/text/sdatabase/05030200.xhp|   28 -
 source/text/sdatabase/05030300.xhp|   42 +-
 source/text/sdatabase/05030400.xhp|   34 -
 source/text/sdatabase/0504.xhp|4 
 source/text/sdatabase/05040200.xhp|6 
 source/text/sdatabase/1102.xhp|   46 +-
 source/text/sdatabase/1103.xhp|   24 -
 source/text/sdatabase/1109.xhp|   10 
 source/text/shared/01/0528.xhp|2 
 source/text/shared/01/05340500.xhp|8 
 source/text/shared/01/05340600.xhp|8 
 source/text/shared/02/1210.xhp|8 
 source/text/shared/02/2010.xhp|8 
 source/text/shared/autokorr/0100.xhp  |   13 
 source/text/shared/autokorr/0200.xhp  |   13 
 source/text/shared/autokorr/0300.xhp  |   11 
 source/text/shared/autokorr/0400.xhp  |   15 
 source/text/shared/autokorr/0500.xhp  |9 
 source/text/shared/autokorr/0600.xhp  |   11 
 source/text/shared/autokorr/0700.xhp  |   11 
 source/text/shared/autokorr/0800.xhp  |   11 
 source/text/shared/autokorr/0900.xhp  |   11 
 source/text/shared/autokorr/1000.xhp  |   11 
 source/text/shared/autokorr/1200.xhp  |   15 
 source/text/shared/autokorr/1300.xhp  |   11 
 source/text/shared/optionen/01020300.xhp  |   25 -
 source/text/simpress/01/0305.xhp  |2 
 source/text/swriter/02/0609.xhp   |2 
 source/text/swriter/guide/autocorr_except.xhp |   24 -
 37 files changed, 543 insertions(+), 586 deletions(-)

New commits:
commit 0d4e0c0452346d797ae5eda7e3c1c61d73f6eb3c
Author: Olivier Hallot 
AuthorDate: Mon Apr 29 14:05:11 2024 -0300
Commit: Olivier Hallot 
CommitDate: Mon Apr 29 20:51:44 2024 +0200

Fix indexer="include" in  Help files.

+ refactor

Change-Id: Ia0dfdc0f88f40776042ca0b745e26dc9e0cd479f
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/166874
Reviewed-by: Olivier Hallot 
Tested-by: Jenkins

diff --git a/source/text/shared/01/0528.xhp 
b/source/text/shared/01/0528.xhp
index 31d3e262dd..0d99c2e0e6 100644
--- a/source/text/shared/01/0528.xhp
+++ b/source/text/shared/01/0528.xhp
@@ -18,7 +18,7 @@
  -->
 
 
-
+
 Text along Path
 /text/shared/01/0528.xhp
 
diff --git a/source/text/shared/01/05340500.xhp 
b/source/text/shared/01/05340500.xhp
index e60ea8482e..54a27f5037 100644
--- a/source/text/shared/01/05340500.xhp
+++ b/source/text/shared/01/05340500.xhp
@@ -20,11 +20,11 @@
  -->
 
 
-   
+
 
 
-
-Hide Columns
+
+Hide Columns
 /text/shared/01/05340500.xhp
 
 
@@ -34,7 +34,7 @@
 
 
 Hide 
Columns
-Hides the selected column(s). To display hidden columns, right-click 
any column header, and then choose Show 
Columns.
+Hides the 
selected column(s). To display hidden columns, right-click any column header, 
and then choose Show Columns.
 
 
 
diff --git a/source/text/shared/01/05340600.xhp 
b/source/text/shared/01/05340600.xhp
index 094e5171e7..d02be5ee49 100644
--- a/source/text/shared/01/05340600.xhp
+++ b/source/text/shared/01/05340600.xhp
@@ -20,11 +20,11 @@
  -->
 
 
-   
+
 
 
-
-Show Columns
+
+Show Columns
 /text/shared/01/05340600.xhp
 
 
@@ -34,7 +34,7 @@
 
 
 Show 
Columns
-Displays hidden columns. Choose the column that you want to display 
from the list, or click All to display all of the hidden 
columns.
+Displays hidden 
columns. Choose the column that you want to display from the list, or click 
All to display all of the hidden columns.
 
 
 
diff --git a/source/text/shared/02/1210.xhp 
b/source/text/shared/02/1210.xhp
index 94805185e2..6a7ab0cd8c 100644
--- a/source/text/shared/02/1210.xhp
+++ b/source/text/shared/02/1210.xhp
@@ -19,8 +19,8 @@
  -->
 
 
-  
-Sort Order
+  
+Sort Order
 /text/shared/02/1210.xhp
   
   
@@ -32,10 +32,10 @@
 
   
 
-  Icon Sort Order
+  Icon Sort Order
 
 
-  Sort 
Order
+  Sort Order
 
   
 
diff --git a/source/text/shared/02/2010.xhp 
b/source/text/shared/02/2010.xhp
index 489588e429..14a3486ee5 100644
--- a/source/text/shared/02/2010.xhp
+++ b/source/text/shared/02/2010.xhp
@@ -19,8 +19,8 @@
  -->
 
 
-  
-Date
+  
+Date
 /text/shared/02/2010.xhp
   
   
@@ -28,8 +28,8 @@
   
 
 
-
+
 Date
-Displays the current 
date.
+Displays the current date.
 
 
diff --git 

core.git: helpcontent2

[Olivier Hallot (via logerrit)]

 helpcontent2 |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit 6818bf2638fe5d51623908a15a4bf423d21977bd
Author: Olivier Hallot 
AuthorDate: Mon Apr 29 15:51:32 2024 -0300
Commit: Gerrit Code Review 
CommitDate: Mon Apr 29 20:51:32 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'master'
  to 3fa70de3d05c43e190a2d2718a43667bda3ff5f1
  - Fix indexer="include" in database Help files.

+ refactor

Change-Id: Iacaffc96aac85e7b06348372da16449c1206e2de
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/166873
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/helpcontent2 b/helpcontent2
index db688bf5d40a..3fa70de3d05c 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit db688bf5d40a94939f8e6ab35744c267d35b39ab
+Subproject commit 3fa70de3d05c43e190a2d2718a43667bda3ff5f1

help.git: AllLangHelp_shared.mk source/text

[Olivier Hallot (via logerrit)]

 AllLangHelp_shared.mk  |1 
 source/text/shared/01/0502.xhp |2 
 source/text/shared/01/05020400.xhp |  143 -
 3 files changed, 146 deletions(-)

New commits:
commit db688bf5d40a94939f8e6ab35744c267d35b39ab
Author: Olivier Hallot 
AuthorDate: Thu Apr 25 13:09:28 2024 -0300
Commit: Olivier Hallot 
CommitDate: Thu Apr 25 18:23:34 2024 +0200

tdf#132253 Hyperlink tab in Characters is gone.

Change-Id: Ic146695c24e488fc5c0d0cebce2e43769ac37a7a
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/166640
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/AllLangHelp_shared.mk b/AllLangHelp_shared.mk
index f2085103e0..f8b46c1e10 100644
--- a/AllLangHelp_shared.mk
+++ b/AllLangHelp_shared.mk
@@ -165,7 +165,6 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,shared,\
 helpcontent2/source/text/shared/01/05020200 \
 helpcontent2/source/text/shared/01/05020300 \
 helpcontent2/source/text/shared/01/05020301 \
-helpcontent2/source/text/shared/01/05020400 \
 helpcontent2/source/text/shared/01/05020500 \
 helpcontent2/source/text/shared/01/05020600 \
 helpcontent2/source/text/shared/01/05020700 \
diff --git a/source/text/shared/01/0502.xhp 
b/source/text/shared/01/0502.xhp
index d7f5f2c31f..47ec078ec3 100644
--- a/source/text/shared/01/0502.xhp
+++ b/source/text/shared/01/0502.xhp
@@ -55,8 +55,6 @@
 
 
 
-Hyperlink
-
 
 
 
diff --git a/source/text/shared/01/05020400.xhp 
b/source/text/shared/01/05020400.xhp
deleted file mode 100644
index a81ec1668f..00
--- a/source/text/shared/01/05020400.xhp
+++ /dev/null
@@ -1,143 +0,0 @@
-
-
-
-
-
-  
-Hyperlink
-/text/shared/01/05020400.xhp
-  
-  
-Sun Microsystems, Inc.
-  
-
-
-formatting; hyperlinks
-characters; hyperlinks
-hyperlinks; character formats
-text;hyperlinks
-links; character formats
-
-
-
-
-Hyperlink
-Assigns a new hyperlink 
or edits the selected hyperlink.
- A hyperlink is a link to a file on the Internet or on your local 
system.
-
-
-You can also 
assign or edit a named HTML anchor, or Bookmark, that refers to a specific 
place in a document.
-
-
-
-  
-
-Hyperlink
-Specify the 
properties for the hyperlink.
-
-URL
-Enter a URL for the file that you want to 
open when you click the hyperlink. If you do not specify a target 
frame, the file opens in the current document or frame.
-
-
-Browse
-Locate the file that you want to 
link to, and then click Open.
-
-Reference
-Enter the text that you want to 
display for the hyperlink.
-
-Events
-Specify an event that triggers 
when you click the hyperlink.
-
-Name
-
-Enter a name for the 
hyperlink. $[officename] inserts a NAME tag in the 
hyperlink:
-A 
HREF="http://www.example.com/; NAME="Nametext" 
TARGET="_blank"Note/A
-
-
-Frame
-
-Enter 
the name of the frame that you want the linked file to open in, or select a 
predefined frame from the list. If you leave this box blank, the linked 
file opens in the current browser window.
-
-
-
-
-
-
-Name of 
Frame
-
-
-Definition
-
-
-
-
-Named 
entries
-
-
-File opens 
in a named frame in the current HTML document.
-
-
-
-
-_self
-
-
-File opens 
in the current frame.
-
-
-
-
-_blank
-
-
-File opens 
in a new page.
-
-
-
-
-_parent
-
-
-File opens 
in the parent frame of the current frame. If there is no parent frame, the 
current frame is used.
-
-
-
-
-_top
-
-
-File opens 
in the topmost frame in the hierarchy.
-
-
-
-
-Character Styles
-Specify the 
formatting options for the hyperlink.
-
-Visited links
-Select a formatting style to use 
for visited links from the list. To add or modify a style in this list, close 
this dialog, and click the Styles icon on the 
Formatting toolbar.
-
-Unvisited links
-Select a formatting style to 
use for unvisited links from the list. To add or modify a style in this list, 
close this dialog, and click the Styles icon on the 
Formatting toolbar.
-
-Hyperlink dialog
-Assign macro
-
-
-

core.git: helpcontent2

[Olivier Hallot (via logerrit)]

 helpcontent2 |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit e9e09e60355f454e51ea7a8af9f12dca29f9e407
Author: Olivier Hallot 
AuthorDate: Tue Apr 23 07:36:51 2024 -0300
Commit: Gerrit Code Review 
CommitDate: Tue Apr 23 12:36:51 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'master'
  to d50121f44bc54b22ccc603093cf5fd0b75f26155
  - tdf#102265 More work on Impress format menu (5)

Change-Id: Ia1eb00e126f8609091464599a364f0da4e8dd38a
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/166471
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/helpcontent2 b/helpcontent2
index 75545d298523..d50121f44bc5 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit 75545d298523dc4a83e98703b9666d35b0f2cb56
+Subproject commit d50121f44bc54b22ccc603093cf5fd0b75f26155

help.git: source/text

[Olivier Hallot (via logerrit)]

 source/text/shared/01/DeleteColumns.xhp   |2 
 source/text/shared/01/DeleteRows.xhp  |2 
 source/text/shared/01/DeleteTable.xhp |2 
 source/text/shared/01/SelectTable.xhp |2 
 source/text/shared/01/SetOptimalRowHeight.xhp |5 -
 source/text/swriter/00/0405.xhp   |   37 +++--
 source/text/swriter/01/05120400.xhp   |7 +
 source/text/swriter/main0110.xhp  |  104 ++
 8 files changed, 115 insertions(+), 46 deletions(-)

New commits:
commit d50121f44bc54b22ccc603093cf5fd0b75f26155
Author: Olivier Hallot 
AuthorDate: Mon Apr 22 17:10:39 2024 -0300
Commit: Olivier Hallot 
CommitDate: Tue Apr 23 12:36:51 2024 +0200

tdf#102265 More work on Impress format menu (5)

Change-Id: Ia1eb00e126f8609091464599a364f0da4e8dd38a
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/166471
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/source/text/shared/01/DeleteColumns.xhp 
b/source/text/shared/01/DeleteColumns.xhp
index 6ffcdf36c6..ab1e8901cd 100644
--- a/source/text/shared/01/DeleteColumns.xhp
+++ b/source/text/shared/01/DeleteColumns.xhp
@@ -18,7 +18,7 @@
 
 
 
-ColumnsDelete 
Columns
+ColumnsDelete 
Columns
 Deletes the selected 
columns.
 
 
diff --git a/source/text/shared/01/DeleteRows.xhp 
b/source/text/shared/01/DeleteRows.xhp
index 2075f8e195..54f03c2854 100644
--- a/source/text/shared/01/DeleteRows.xhp
+++ b/source/text/shared/01/DeleteRows.xhp
@@ -18,7 +18,7 @@
 
 
 
-RowsDelete 
Rows
+RowsDelete 
Rows
 Deletes the selected 
rows.
 
 
diff --git a/source/text/shared/01/DeleteTable.xhp 
b/source/text/shared/01/DeleteTable.xhp
index 810b877043..a47587de93 100644
--- a/source/text/shared/01/DeleteTable.xhp
+++ b/source/text/shared/01/DeleteTable.xhp
@@ -18,7 +18,7 @@
 
 
 
-Table
+Delete Table
 Deletes the current 
table.
 
 
diff --git a/source/text/shared/01/SelectTable.xhp 
b/source/text/shared/01/SelectTable.xhp
index 0441953354..7c9327a113 100644
--- a/source/text/shared/01/SelectTable.xhp
+++ b/source/text/shared/01/SelectTable.xhp
@@ -18,7 +18,7 @@
 
 
 
-Table
+Select Table
 Selects the current 
table.
 
 
diff --git a/source/text/shared/01/SetOptimalRowHeight.xhp 
b/source/text/shared/01/SetOptimalRowHeight.xhp
index 18174368b6..bdc56accf4 100644
--- a/source/text/shared/01/SetOptimalRowHeight.xhp
+++ b/source/text/shared/01/SetOptimalRowHeight.xhp
@@ -35,11 +35,8 @@
 
 Determines the optimal row 
height for the selected rows. The optimal row height depends 
on the font size of the largest character in the row. You can use various units of 
measure.
 
-
-
-
-
 
+Set row 
height for selected table rows so that each row has the same height as the row 
with the tallest content.
 
 
 
diff --git a/source/text/swriter/00/0405.xhp 
b/source/text/swriter/00/0405.xhp
index ee90827495..614ba11745 100644
--- a/source/text/swriter/00/0405.xhp
+++ b/source/text/swriter/00/0405.xhp
@@ -519,7 +519,15 @@
   
   
  
- Choose 
Table - Select - Table.
+ 
+
+   Choose 
Table - Select - Table.
+
+
+
+   Choose 
Format - Table - Select.
+
+ 
  
  Choose 
Table - Select Table.
  
@@ -535,8 +543,12 @@

 
  
- 
- Choose 
Properties - Table - Table.
+ 
+
+   
+   Choose 
Properties - Table - Table.
+
+ 
   
 
   
@@ -572,7 +584,15 @@
 
   
  
- Choose 
Table - Delete - Table.
+ 
+
+   Choose 
Table - Delete - Table.
+
+
+
+   Choose 
Format - Table - Delete Table.
+
+ 
  
  Choose 
Delete - Table.
  
@@ -586,9 +606,14 @@

 
  
- 
- Choose 
Properties - Table - Delete Table.
+ 
+
+   
+   Choose 
Properties - Table - Delete Table.
+
+ 
   
+
   
  
  Choose 
Table - Delete.
diff --git a/source/text/swriter/01/05120400.xhp 
b/source/text/swriter/01/05120400.xhp
index a43577550d..2bea4c5486 100644
--- a/source/text/swriter/01/05120400.xhp
+++ b/source/text/swriter/01/05120400.xhp
@@ -31,9 +31,12 @@
 Inserts a row into the table.
 
 Inserts a column into the table.
-Insert Columns/Rows
+
+
+  Insert Columns/Rows
 Inserts a row or column into the table. This command is only 
available when the cursor is in a table.
-
+
+

core.git: helpcontent2

[Olivier Hallot (via logerrit)]

 helpcontent2 |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit af9ae41d6766d9103199f7c41380789ee7740224
Author: Olivier Hallot 
AuthorDate: Mon Apr 22 12:29:39 2024 -0300
Commit: Gerrit Code Review 
CommitDate: Mon Apr 22 17:29:39 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'master'
  to 341704f9e4ce2dc4aa82a8d92f3b6d2e8db648e7
  - tdf#102265 More work on Impress format menu (4)

Change-Id: Ib88aa1b88c6e3220aa0fb87510b3e736cf61b1c5
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/166464
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/helpcontent2 b/helpcontent2
index 54b758c1d735..341704f9e4ce 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit 54b758c1d7357d3a63fc9991c911d40c11d0
+Subproject commit 341704f9e4ce2dc4aa82a8d92f3b6d2e8db648e7

help.git: source/text

[Olivier Hallot (via logerrit)]

 source/text/swriter/01/0415.xhp |5 ++---
 source/text/swriter/main0110.xhp|   17 -
 2 files changed, 14 insertions(+), 8 deletions(-)

New commits:
commit 341704f9e4ce2dc4aa82a8d92f3b6d2e8db648e7
Author: Olivier Hallot 
AuthorDate: Mon Apr 22 12:28:37 2024 -0300
Commit: Olivier Hallot 
CommitDate: Mon Apr 22 17:29:39 2024 +0200

tdf#102265 More work on Impress format menu (4)

Change-Id: Ib88aa1b88c6e3220aa0fb87510b3e736cf61b1c5
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/166464
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/source/text/swriter/01/0415.xhp 
b/source/text/swriter/01/0415.xhp
index a216f40a62..425b295ad5 100644
--- a/source/text/swriter/01/0415.xhp
+++ b/source/text/swriter/01/0415.xhp
@@ -25,14 +25,13 @@
 
 
 
-
 
 
 
 
+
 Insert 
Table
-Inserts a table into 
the document. You can also click the arrow, drag to select the number of rows 
and columns to include in the table, and then click in the last cell.
-
+Inserts a table into the document. You can also 
click the arrow, drag to select the number of rows and columns to include in 
the table, and then click in the last cell.
 
 
   
diff --git a/source/text/swriter/main0110.xhp b/source/text/swriter/main0110.xhp
index 50e057799d..63e8bbfb98 100644
--- a/source/text/swriter/main0110.xhp
+++ b/source/text/swriter/main0110.xhp
@@ -27,18 +27,25 @@
 
 
 
-
 
+
 Table
 Shows commands to 
insert, edit, and delete a table and its elements inside a text 
document.
 
+
 
   
-  Choose 
Table.
+  
+
+  Choose 
Table.
+
+
+
+  Choose 
Format - Table.
+
+  
 
-
-Insert 
Table
-Inserts a new table.
+
 
 
 

core.git: helpcontent2

[Olivier Hallot (via logerrit)]

 helpcontent2 |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit 08141d993f489e041e631e8bce4d200134c2e326
Author: Olivier Hallot 
AuthorDate: Mon Apr 22 12:26:28 2024 -0300
Commit: Gerrit Code Review 
CommitDate: Mon Apr 22 17:26:28 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'master'
  to 54b758c1d7357d3a63fc9991c911d40c11d0
  - tdf#102265 More work on Impress format menu (3)

Change-Id: Ie14e0364d2a8ddb9d9d50288fb7a7e28f7cc6a80
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/166463
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/helpcontent2 b/helpcontent2
index 8f674b960e77..54b758c1d735 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit 8f674b960e776a70c916e508073cfa3f2e2269a1
+Subproject commit 54b758c1d7357d3a63fc9991c911d40c11d0

help.git: source/text

[Olivier Hallot (via logerrit)]

 source/text/simpress/main_format.xhp |   16 +---
 1 file changed, 5 insertions(+), 11 deletions(-)

New commits:
commit 54b758c1d7357d3a63fc9991c911d40c11d0
Author: Olivier Hallot 
AuthorDate: Mon Apr 22 12:23:59 2024 -0300
Commit: Olivier Hallot 
CommitDate: Mon Apr 22 17:26:27 2024 +0200

tdf#102265 More work on Impress format menu (3)

Change-Id: Ie14e0364d2a8ddb9d9d50288fb7a7e28f7cc6a80
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/166463
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/source/text/simpress/main_format.xhp 
b/source/text/simpress/main_format.xhp
index 288396bb67..cfbcb1e3e6 100644
--- a/source/text/simpress/main_format.xhp
+++ b/source/text/simpress/main_format.xhp
@@ -36,17 +36,11 @@
 
 
 
-Styles
-Shows commands to 
edit, update, create, and manage styles.Needs a submenu 
page
-
-Character
-
-
-Paragraph
-
-
-Bullets and 
Numbering
-
+
+
+
+
+
 
 Table
 Shows commands to 
format, edit, and delete a table and its elements.Needs a 
submenu page

core.git: 2 commits - helpcontent2

[Olivier Hallot (via logerrit)]

 helpcontent2 |2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit 7346373d8e4b8c4465ee22b77ec78334f384b92c
Author: Olivier Hallot 
AuthorDate: Mon Apr 22 12:23:24 2024 -0300
Commit: Gerrit Code Review 
CommitDate: Mon Apr 22 17:23:24 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'master'
  to 8f674b960e776a70c916e508073cfa3f2e2269a1
  - tdf#102265 More work on Impress format menu (2)

Change-Id: I165dccf3662a98a0d4d945c3541f5d6d24ae8c86
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/166462
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/helpcontent2 b/helpcontent2
index 3b3bc84641ec..8f674b960e77 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit 3b3bc84641ec3c0b543682c9394789e86345e8e5
+Subproject commit 8f674b960e776a70c916e508073cfa3f2e2269a1
commit 226544bfed764441a4545f3ff41f977fa5d71c72
Author: Olivier Hallot 
AuthorDate: Mon Apr 22 12:23:15 2024 -0300
Commit: Gerrit Code Review 
CommitDate: Mon Apr 22 17:23:15 2024 +0200

Update git submodules

* Update helpcontent2 from branch 'master'
  to 3b3bc84641ec3c0b543682c9394789e86345e8e5
  - tdf#102265 More work on Impress format menu

Change-Id: I7edb4893d9f65eb05694f777a0ef730454851101
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/166461
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/helpcontent2 b/helpcontent2
index b066c7f1008c..3b3bc84641ec 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit b066c7f1008ce7d433683324dc9ef441478c832c
+Subproject commit 3b3bc84641ec3c0b543682c9394789e86345e8e5