core.git: 2 commits - helpcontent2
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
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
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
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
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..845
core.git: helpcontent2
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
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
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
|binary source/media/screenshots/modules/simpress/ui/presentationdialog/si/PresentationDialog.png |binary source/media/screenshots/modules/simpress/ui/presentationdialog/sid/PresentationDialog.png |binary source/media/screenshots/modules/simpress/ui/presentationdialog/sk/PresentationDialog.png |binary source/media/screenshots/modules/simpress/ui/presentationdialog/sl/PresentationDialog.png |binary source/media/screenshots/modules/simpress/ui/presentationdialog/sq/PresentationDialog.png |binary source/media/screenshots/modules/simpress/ui/presentationdialog/sr-Latn/PresentationDialog.png |binary source/media/screenshots/modules/simpress/ui/presentationdialog/sr/PresentationDialog.png |binary source/media/screenshots/modules/simpress/ui/presentationdialog/ss/PresentationDialog.png |binary source/media/screenshots/modules/simpress/ui/presentationdialog/st/PresentationDialog.png |binary source/media/screenshots/modules/simpress/ui/presentationdialog/sv/PresentationDialog.png |binary source/media/screenshots/modules/simpress/ui/presentationdialog/sw-TZ/PresentationDialog.png |binary source/media/screenshots/modules/simpress/ui/presentationdialog/szl/PresentationDialog.png |binary source/media/screenshots/modules/simpress/ui/presentationdialog/ta/PresentationDialog.png |binary source/media/screenshots/modules/simpress/ui/presentationdialog/te/PresentationDialog.png |binary source/media/screenshots/modules/simpress/ui/presentationdialog/tg/PresentationDialog.png |binary source/media/screenshots/modules/simpress/ui/presentationdialog/th/PresentationDialog.png |binary source/media/screenshots/modules/simpress/ui/presentationdialog/tn/PresentationDialog.png |binary source/media/screenshots/modules/simpress/ui/presentationdialog/tr/PresentationDialog.png |binary source/media/screenshots/modules/simpress/ui/presentationdialog/ts/PresentationDialog.png |binary source/media/screenshots/modules/simpress/ui/presentationdialog/tt/PresentationDialog.png |binary source/media/screenshots/modules/simpress/ui/presentationdialog/ug/PresentationDialog.png |binary source/media/screenshots/modules/simpress/ui/presentationdialog/uk/PresentationDialog.png |binary source/media/screenshots/modules/simpress/ui/presentationdialog/uz/PresentationDialog.png |binary source/media/screenshots/modules/simpress/ui/presentationdialog/ve/PresentationDialog.png |binary source/media/screenshots/modules/simpress/ui/presentationdialog/vec/PresentationDialog.png |binary source/media/screenshots/modules/simpress/ui/presentationdialog/vi/PresentationDialog.png |binary source/media/screenshots/modules/simpress/ui/presentationdialog/xh/PresentationDialog.png |binary source/media/screenshots/modules/simpress/ui/presentationdialog/zh-CN/PresentationDialog.png |binary source/media/screenshots/modules/simpress/ui/presentationdialog/zh-TW/PresentationDialog.png |binary source/media/screenshots/modules/simpress/ui/presentationdialog/zu/PresentationDialog.png |binary 121 files changed New commits: commit b3ffed2bfd797c22fe28472898d2d9a72aa2ae41 Author: Olivier Hallot AuthorDate: Tue May 21 16:15:21 2024 -0300 Commit: Olivier Hallot CommitDate: Wed May 22 00:09:02 2024 +0200 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/source/media/screenshots/modules/simpress/ui/presentationdialog/PresentationDialog.png b/source/media/screenshots/modules/simpress/ui/presentationdialog/PresentationDialog.png old mode 100644 new mode 100755 index b546274bf3..646e0077cf Binary files a/source/media/screenshots/modules/simpress/ui/presentationdialog/PresentationDialog.png and b/source/media/screenshots/modules/simpress/ui/presentationdialog/PresentationDialog.png differ diff --git a/source/media/screenshots/modules/simpress/ui/presentationdialog/af/PresentationDialog.png b/source/media/screenshots/modules/simpress/ui/presentationdialog/af/PresentationDialog.png new file mode 100755 index 00..c4c5eaf99f Binary files /dev/null and b/source/media/screenshots/modules/simpress/ui/presentationdialog/af/PresentationDialog.png differ diff --git a/source/media/screenshots/modules/simpress/ui/presentationdialog/am/PresentationDialog.png b/source/media/screenshots/modules/simpress/ui/presentationdialog/am/PresentationDialog.png old mode 100644 new mode 100755 index 2bf746416b..da482e71fc Binary files a/source/media/screenshots/modules/simpress/ui/presentationdialog/am/PresentationDialog.png and b/source/media
core.git: sc/uiconfig
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
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
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
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
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
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
core.git: helpcontent2
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
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
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
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
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
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
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
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
help.git: source/text
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
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
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
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 birt
core.git: helpcontent2
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
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
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
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
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
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 a/so
core.git: helpcontent2
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
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
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
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
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
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
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
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
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
help.git: 2 commits - AllLangHelp_simpress.mk source/text
AllLangHelp_simpress.mk |1 source/text/shared/menu/style_menu.xhp| 31 ++ source/text/simpress/format_submenu_lists.xhp | 31 -- source/text/simpress/main_format.xhp | 11 +++-- 4 files changed, 26 insertions(+), 48 deletions(-) New commits: commit 8f674b960e776a70c916e508073cfa3f2e2269a1 Author: Olivier Hallot AuthorDate: Mon Apr 22 12:19:01 2024 -0300 Commit: Olivier Hallot CommitDate: Mon Apr 22 17:23:23 2024 +0200 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/source/text/shared/menu/style_menu.xhp b/source/text/shared/menu/style_menu.xhp index 4367bc3da0..4ff68262b5 100644 --- a/source/text/shared/menu/style_menu.xhp +++ b/source/text/shared/menu/style_menu.xhp @@ -68,11 +68,24 @@ Contains commands to apply, create, edit, update, load, and manage styles in a spreadsheet document. + +Contains commands to create, edit, update, and manage styles in a presentation document. + -Choose Styles. + + +Choose Format - Styles. + + +Choose Format - Styles. + + +Choose Styles. + + @@ -83,20 +96,20 @@ Cell styles entries The entries includes most common cell styles. Click on the style to apply. - - - - + + + + + You can customize the list of styles entries using menu Tools - Customize. Because custom styles belongs to the actual document, remember to store the customized menu in the document scope. - You can customize the list of styles entries using menu Tools - Customize. Because custom styles belongs to the actual document, remember to store the customized menu in the document scope. - - + + - + commit 3b3bc84641ec3c0b543682c9394789e86345e8e5 Author: Olivier Hallot AuthorDate: Thu Apr 18 14:01:38 2024 -0300 Commit: Olivier Hallot CommitDate: Mon Apr 22 17:23:15 2024 +0200 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/AllLangHelp_simpress.mk b/AllLangHelp_simpress.mk index 2d0ac32af0..e79a530b61 100644 --- a/AllLangHelp_simpress.mk +++ b/AllLangHelp_simpress.mk @@ -194,7 +194,6 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,simpress,\ helpcontent2/source/text/simpress/main0103 \ helpcontent2/source/text/simpress/main0104 \ helpcontent2/source/text/simpress/main_format \ -helpcontent2/source/text/simpress/format_submenu_lists \ helpcontent2/source/text/simpress/main0107 \ helpcontent2/source/text/simpress/main0113 \ helpcontent2/source/text/simpress/main0114 \ diff --git a/source/text/simpress/format_submenu_lists.xhp b/source/text/simpress/format_submenu_lists.xhp deleted file mode 100644 index 78bbdbdf01..00 --- a/source/text/simpress/format_submenu_lists.xhp +++ /dev/null @@ -1,31 +0,0 @@ - - - - - - -Lists -/text/simpress/format_submenu_lists.xhp - - - - - -Lists -For the selected paragraphs, adds numbering or bullets, edit the outline levels and move them up or down in the slide. - - - - - - - - - diff --git a/source/text/simpress/main_format.xhp b/source/text/simpress/main_format.xhp index 33f38ff966..288396bb67 100644 --- a/source/text/simpress/main_format.xhp +++ b/source/text/simpress/main_format.xhp @@ -19,24 +19,21 @@ - Format + Format /text/simpress/main_format.xhp - + Format - Contains commands for formatting the layout and the contents of your document. + Contains commands for formatting the layout and the contents of your document. - -Lists -Opens a submenu where you can modify the formatting of list paragraphs. - + Styles
core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 84e56a1ccfb190ce28352f946fa38999491b3086 Author: Olivier Hallot AuthorDate: Sun Apr 21 09:26:41 2024 -0300 Commit: Gerrit Code Review CommitDate: Sun Apr 21 14:26:41 2024 +0200 Update git submodules * Update helpcontent2 from branch 'master' to 183a14d99cbf6b18fa7d3d059a2ff0639520a205 - tdf#152499 Help page for Select UI dialog Help part Change-Id: I3fa18868abed3b738b699a7abcc216aaa90df12d Reviewed-on: https://gerrit.libreoffice.org/c/help/+/166196 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index 7e29cad08d81..183a14d99cbf 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 7e29cad08d812997ae5053444c86edf1c8c971d4 +Subproject commit 183a14d99cbf6b18fa7d3d059a2ff0639520a205
help.git: source/text
source/text/shared/01/notebook_bar.xhp | 15 --- 1 file changed, 8 insertions(+), 7 deletions(-) New commits: commit 183a14d99cbf6b18fa7d3d059a2ff0639520a205 Author: Olivier Hallot AuthorDate: Wed Apr 17 18:42:41 2024 -0300 Commit: Olivier Hallot CommitDate: Sun Apr 21 14:26:41 2024 +0200 tdf#152499 Help page for Select UI dialog Help part Change-Id: I3fa18868abed3b738b699a7abcc216aaa90df12d Reviewed-on: https://gerrit.libreoffice.org/c/help/+/166196 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/source/text/shared/01/notebook_bar.xhp b/source/text/shared/01/notebook_bar.xhp index 02a0533b59..abf0407faf 100644 --- a/source/text/shared/01/notebook_bar.xhp +++ b/source/text/shared/01/notebook_bar.xhp @@ -40,6 +40,7 @@ + User Interface Opens the Select Your Preferred User Interface dialog to let you choose the user interface layout for %PRODUCTNAME. @@ -56,25 +57,25 @@ User interface layouts The User Interface entry defines which user interface elements are visible. - + Standard toolbar Classic mode with two visible toolbars – standard and formatting. The sidebar is partially collapsed and shows only tabs. Intended for users who are familiar with the classic interface. - + Tabbed In this mode, the bar is divided into tabs, where each tab displays a set of icons grouped by context. The context can also change depending on the object selected in the document, for example a table or an image. The Tabbed user interface is the most similar to the Ribbons used in Microsoft Office. It organizes functions in tabs and makes the main menu obsolete. - + Tabbed compact The Tabbed Compact variant aims to be familiar with the Microsoft Office interface, yet occupying less space for smaller screens. - + Groupedbar compact The Groupedbar Compact interface provides access to functions in groups, with icons for most-frequently used features, and dropdown menus for others. This compact variant favors vertical space. - + Contextual single The Contextual Single interface shows functions in a single-line toolbar with context-dependent content. - + Single toolbar Standard user interface but with single-line toolbar. Intended for use on small screens. The sidebar is collapsed. - + Sidebar Standard user interface with expanded sidebar. Expert users who want to quickly change many different properties are advised to use this user interface.
core.git: cui/uiconfig
cui/uiconfig/ui/toolbarmodedialog.ui | 24 +++- 1 file changed, 19 insertions(+), 5 deletions(-) New commits: commit 92e567570c1ea49bc7b63fca2b0f5ad101c63471 Author: Olivier Hallot AuthorDate: Wed Apr 17 18:38:52 2024 -0300 Commit: Olivier Hallot CommitDate: Sun Apr 21 14:26:16 2024 +0200 tdf#152499 Help button for Select UI dialog Core part Change-Id: I6344c93b187ac0835faf13a06f02cd2a9fe0fcd1 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/166195 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/cui/uiconfig/ui/toolbarmodedialog.ui b/cui/uiconfig/ui/toolbarmodedialog.ui index f3f00446d16f..4428eeac1166 100644 --- a/cui/uiconfig/ui/toolbarmodedialog.ui +++ b/cui/uiconfig/ui/toolbarmodedialog.ui @@ -1,5 +1,5 @@ - + @@ -15,9 +15,6 @@ True center-on-parent dialog - - - False @@ -78,6 +75,22 @@ 2 + + +_Help +True +True +True +True +right + + +True +True +3 +True + + False @@ -344,7 +357,7 @@ 50 0 - + @@ -389,6 +402,7 @@ btnApplyAll btnApply close + help
core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 191d7d251dd350196f76f47195ff8cd998312f61 Author: Olivier Hallot AuthorDate: Thu Apr 18 11:39:18 2024 -0300 Commit: Gerrit Code Review CommitDate: Thu Apr 18 16:39:18 2024 +0200 Update git submodules * Update helpcontent2 from branch 'master' to 7e29cad08d812997ae5053444c86edf1c8c971d4 - Use svg icons in Help page Change-Id: I1418d54df7393321e79706d4885af50e6fdea59b Reviewed-on: https://gerrit.libreoffice.org/c/help/+/166249 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index 9e32990654d9..7e29cad08d81 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 9e32990654d9b4ad397f6e0d21973483b1bf47f9 +Subproject commit 7e29cad08d812997ae5053444c86edf1c8c971d4
help.git: source/text
source/text/shared/guide/digital_signatures.xhp | 15 +-- 1 file changed, 5 insertions(+), 10 deletions(-) New commits: commit 7e29cad08d812997ae5053444c86edf1c8c971d4 Author: Olivier Hallot AuthorDate: Thu Apr 18 09:05:50 2024 -0300 Commit: Olivier Hallot CommitDate: Thu Apr 18 16:39:17 2024 +0200 Use svg icons in Help page Change-Id: I1418d54df7393321e79706d4885af50e6fdea59b Reviewed-on: https://gerrit.libreoffice.org/c/help/+/166249 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/source/text/shared/guide/digital_signatures.xhp b/source/text/shared/guide/digital_signatures.xhp index c6141cb216..2e79ccc6c6 100644 --- a/source/text/shared/guide/digital_signatures.xhp +++ b/source/text/shared/guide/digital_signatures.xhp @@ -27,8 +27,8 @@ certificates - digital signatures;overview - security;digital signatures +digital signatures;overview +security;digital signatures mw moved 1 entry to digitalsign_send.xhp and made "digital signatures" a two level entry and added a new entry About Digital Signatures @@ -54,9 +54,7 @@ - -Icon - + Icon The signature is valid. @@ -64,9 +62,7 @@ - -Icon - + Icon The signature is OK, but the certificates could not be validated. @@ -76,8 +72,7 @@ -Icon - +Icon The signature is invalid.
core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit c8f2cca985e7c5328361aaa051340d6234273fc1 Author: Olivier Hallot AuthorDate: Thu Apr 18 11:38:36 2024 -0300 Commit: Gerrit Code Review CommitDate: Thu Apr 18 16:38:36 2024 +0200 Update git submodules * Update helpcontent2 from branch 'master' to 9e32990654d9b4ad397f6e0d21973483b1bf47f9 - tdf#86427 automatic label detection explanation + refactor a warning and cross-link between option pages and guide. Change-Id: I0f337c4999d41a96355422540da4d173f02b5a21 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/166252 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index 23abe6908628..9e32990654d9 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 23abe69086280eabf5e160fa0e847bbe28d3ff2a +Subproject commit 9e32990654d9b4ad397f6e0d21973483b1bf47f9
help.git: source/text
source/text/scalc/01/04070400.xhp |2 -
source/text/scalc/guide/address_auto.xhp| 26 +-
source/text/scalc/guide/value_with_name.xhp | 40 ++--
source/text/shared/optionen/01060500.xhp|8 ++---
4 files changed, 38 insertions(+), 38 deletions(-)
New commits:
commit 9e32990654d9b4ad397f6e0d21973483b1bf47f9
Author: Olivier Hallot
AuthorDate: Thu Apr 18 10:13:15 2024 -0300
Commit: Olivier Hallot
CommitDate: Thu Apr 18 16:38:36 2024 +0200
tdf#86427 automatic label detection explanation
+ refactor a warning and cross-link between option pages and guide.
Change-Id: I0f337c4999d41a96355422540da4d173f02b5a21
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/166252
Tested-by: Jenkins
Reviewed-by: Olivier Hallot
diff --git a/source/text/scalc/01/04070400.xhp
b/source/text/scalc/01/04070400.xhp
index 60fef5b4a8..781a3f465d 100644
--- a/source/text/scalc/01/04070400.xhp
+++ b/source/text/scalc/01/04070400.xhp
@@ -35,7 +35,7 @@
-Define Label
Range
+Define Label Range
Opens a dialog in which you
can define a label range.
diff --git a/source/text/scalc/guide/address_auto.xhp
b/source/text/scalc/guide/address_auto.xhp
index dfccbc2aee..f14b44d2f8 100644
--- a/source/text/scalc/guide/address_auto.xhp
+++ b/source/text/scalc/guide/address_auto.xhp
@@ -20,14 +20,13 @@
-Recognizing Names as Addressing
+Recognizing Names as Addressing
/text/scalc/guide/address_auto.xhp
-
-
+
automatic addressing in tables
natural language addressing
formulas; using row/column labels
@@ -43,18 +42,19 @@
mw changes "names;..." entry to "text in
cells;..."mw inserted three index entries from
text/shared/optionen/01060500.xhp. Changed "finding;..." entry to
"recognizing;..." entry. Adding (Calc) is no longer necessary in this
file.
Recognizing Names as
Addressing
-You can use
cells with text to refer to the rows or to the columns that contain the
cells.removed table as a workaround for issue
108715
-Example spreadsheet
-In the example
spreadsheet, you can use the string 'Column One' in
a formula to refer to the cell range B3 to B5, or 'Column Two' for the
cell range C2 to C5.
You can also use 'Row One' for the cell range B3 to D3, or 'Row Two' for the cell range B4 to D4. The result of a
formula that uses a cell name, for example, SUM('Column
One'), is 600.
-Automatically
finding labels is a legacy feature and deactivated by default as it can produce
nondeterministic behavior depending on actual document content. To turn this
function on, choose %PRODUCTNAME -
PreferencesTools -
Options - %PRODUCTNAME Calc -
Calculate and mark the Automatically find column and row
labels check box.
-Using defined
labels instead is always possible and behaves similar but in a defined
way.
-If you enter a label
name in the formula yourself, enclose the name in single quotation marks (').
If a single quotation mark appears in a name, you must double it, for example,
'Harry''s Bar'.
+You can use cells with text to
refer to the rows or to the columns that contain the
cells.removed table as a workaround for issue
108715
+If the resulting cell is
below or above another cell containing text, %PRODUCTNAME Calc assumes the text
as a row label, else %PRODUCTNAME Calc assumes the text as a column
label.
+Example
spreadsheet
+In the example spreadsheet, you
can use the string 'Column One' in a formula to
refer to the cell range B3 to B5, or 'Column Two' for the
cell range C2 to C5.
You can also use 'Row One' for the cell range B3 to D3, or 'Row Two' for the cell range B4 to D4. The result of a
formula that uses a cell name, for example, SUM('Column
One'), is 600.
+Automatically finding labels is a legacy feature
and deactivated by default as it can produce nondeterministic behavior
depending on actual document content. To turn this function on, choose
%PRODUCTNAME -
PreferencesTools -
Options - %PRODUCTNAME Calc -
Calculate and mark the Automatically find column and row
labels check box.
+Using defined labels instead is
always possible and behaves similar but in a defined way.
+If you enter a label name in the formula yourself,
enclose the name in single quotation marks ('). If a single quotation mark
appears in a name, you must double it, for example, 'Harry''s Bar'.
mw changed reference to deleted Calc
guide address_byname.xhp to refer to Calc guide
value_with_name.xhpUFI: changed embedvar links to embed
links
-
-
-
+
+
+
-
\ No newline at end of file
+
diff --git a/source/text/scalc/guide/value_with_name.xhp
b/source/text/scalc/guide/value_with_name.xhp
index 2b706ad593..e7d5017021 100644
--- a/source/text/scalc/guide/value_with_name.xhp
+++ b/source/text/scalc/guide/value_with_name.xhp
@@ -22,12 +22,12 @@
- Naming Cells
+ Naming Cells
help.git: source/text
source/text/shared/00/0401.xhp|9 +- source/text/shared/01/prop_font_embed.xhp | 44 +- 2 files changed, 34 insertions(+), 19 deletions(-) New commits: commit 23abe69086280eabf5e160fa0e847bbe28d3ff2a Author: Olivier Hallot AuthorDate: Wed Apr 17 17:33:19 2024 -0300 Commit: Olivier Hallot CommitDate: Thu Apr 18 12:33:13 2024 +0200 tdf#130185 Clarify font embedding properties. Change-Id: Ic612b41019edafe266bc324cf137b40e0f0b62bd Reviewed-on: https://gerrit.libreoffice.org/c/help/+/166190 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/source/text/shared/00/0401.xhp b/source/text/shared/00/0401.xhp index 32907160f3..f6d0c5abf6 100644 --- a/source/text/shared/00/0401.xhp +++ b/source/text/shared/00/0401.xhp @@ -443,7 +443,14 @@ Choose File - Properties - Statistics tab. Choose File - Properties - Security tab. Choose File - Properties - CMIS Properties tab. -Choose File - Properties - Font tab. + + + +Choose File - Properties - Font tab. + + +On the File menu of the File tab, choose Properties - Fonts. + diff --git a/source/text/shared/01/prop_font_embed.xhp b/source/text/shared/01/prop_font_embed.xhp index 7d63fc574d..18bf7af55d 100644 --- a/source/text/shared/01/prop_font_embed.xhp +++ b/source/text/shared/01/prop_font_embed.xhp @@ -11,13 +11,12 @@ - Embedding Fonts + Embedding Fonts /text/shared/01/prop_font_embed.xhp - - - + + embedding fonts in document file documents; embedding fonts font embedding; in documents @@ -25,19 +24,28 @@ fonts; licensing for embedding embedding; fonts embedding licensed fonts - - - - Font - Embed document fonts in the current file. - - - - - - Font embedding - Mark this box to embed document fonts into the document file, for portability between different computer systems. The document with embedded fonts has a larger size and the fonts are used on the target computer for better rendering of the document layout. - Consider embedding fonts when your document use rare or custom fonts not generally available in other computers. - Font licenses may restrict embedding fonts in documents. Font files contain flags that indicate if and how they can be embedded within a document file. %PRODUCTNAME parses these flags and determines if and how it may be embedded in a document file, and when you open a document containing embedded fonts, it will also look at these flags to determine if and how a document can be viewed or edited. + + + + + Font + Embed document fonts in the current file. + +Consider embedding fonts when your document use rare or custom fonts not generally available in other computers. + + + + +Font embedding +Embed fonts in the document +Mark this box to embed document fonts into the document file, for portability between different computer systems. All fonts referenced in styles or direct formatting are embedded, even if the style is not applied in the document. +Only embed fonts that are used in the document +Mark this box to embed fonts used in the document and filter out unused fonts. The fonts are embedded if they are used in an applied style or in direct formatting only. +The document with embedded fonts has a larger size and the fonts are used on the target computer for better rendering of the document layout. + +Font scripts to embed +Latin, Asian and Complex fonts +Mark the appropriate font script to embed in the document. +Font licenses may restrict embedding fonts in documents. Font files contain flags that indicate if and how they can be embedded within a document file. %PRODUCTNAME parses these flags and determines if and how it may be embedded in a document file, and when you open a document containing embedded fonts, it will also look at these flags to determine if and how a document can be viewed or edited.
core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 91f41cd463d8c5801f3da84c25d1cd058a1adb2a Author: Olivier Hallot AuthorDate: Thu Apr 18 07:33:13 2024 -0300 Commit: Gerrit Code Review CommitDate: Thu Apr 18 12:33:13 2024 +0200 Update git submodules * Update helpcontent2 from branch 'master' to 23abe69086280eabf5e160fa0e847bbe28d3ff2a - tdf#130185 Clarify font embedding properties. Change-Id: Ic612b41019edafe266bc324cf137b40e0f0b62bd Reviewed-on: https://gerrit.libreoffice.org/c/help/+/166190 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index 79b57de90893..23abe6908628 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 79b57de908932267b64efeec42002431417eb965 +Subproject commit 23abe69086280eabf5e160fa0e847bbe28d3ff2a
core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit d5dcc9de8ebce5d14be89ddeb6606ef0aeebf7a9 Author: Olivier Hallot AuthorDate: Wed Apr 10 18:23:58 2024 -0300 Commit: Gerrit Code Review CommitDate: Wed Apr 10 23:23:58 2024 +0200 Update git submodules * Update helpcontent2 from branch 'master' to c2b91a5c78e053498f5ff6a411c314e36eb4a859 - Stick to translatable content and simplify. * The example was locale dependent and was removed. Change-Id: I1df47fb5ba18ca4874b8b68188a6fa7514aa Reviewed-on: https://gerrit.libreoffice.org/c/help/+/165910 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index af2fc2b7c1d2..c2b91a5c78e0 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit af2fc2b7c1d2226ce628f60415fd384ffc75a342 +Subproject commit c2b91a5c78e053498f5ff6a411c314e36eb4a859
help.git: source/text
source/text/scalc/01/func_sortby.xhp | 150 ---
1 file changed, 150 deletions(-)
New commits:
commit c2b91a5c78e053498f5ff6a411c314e36eb4a859
Author: Olivier Hallot
AuthorDate: Tue Apr 9 12:38:26 2024 -0300
Commit: Olivier Hallot
CommitDate: Wed Apr 10 23:23:58 2024 +0200
Stick to translatable content and simplify.
* The example was locale dependent and was removed.
Change-Id: I1df47fb5ba18ca4874b8b68188a6fa7514aa
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/165910
Tested-by: Jenkins
Reviewed-by: Olivier Hallot
diff --git a/source/text/scalc/01/func_sortby.xhp
b/source/text/scalc/01/func_sortby.xhp
index d22710928e..332005731a 100644
--- a/source/text/scalc/01/func_sortby.xhp
+++ b/source/text/scalc/01/func_sortby.xhp
@@ -30,158 +30,8 @@
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.
-
-Consider the
following table
-
-
-
-
-
-A
-
-
-B
-
-
-C
-
-
-
-
-1
-
-
-Product Name
-
-
-Sales
-
-
-Revenue
-
-
-
-
-2
-
-
-pencil
-
-
-20
-
-
-65
-
-
-
-
-3
-
-
-pen
-
-
-35
-
-
-85
-
-
-
-
-4
-
-
-notebook
-
-
-20
-
-
-190
-
-
-
-
-5
-
-
-book
-
-
-17
-
-
-180
-
-
-
-
-6
-
-
-pencil-case
-
-
-not
-
-
-not
-
-
-
-
-7
-
-
-pen
-
-
-10
-
-
-45
-
-
-
-
-Example with ascending order and descending
order (for English locale)
{=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.
-
-
-book
-17
-180
-
-
-notebook
-20
-190
-
-
-pen
-35
-85
-
-
-pen
-10
-45
-
-
-pencil
-20
-65
-
-
-pencil-case
-not
-not
-
-
-
core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 6cd0ef58cddf40a0eb2d8cbb017136552f47704e Author: Olivier Hallot AuthorDate: Tue Apr 9 13:27:02 2024 +0100 Commit: Gerrit Code Review CommitDate: Tue Apr 9 14:27:02 2024 +0200 Update git submodules * Update helpcontent2 from branch 'master' to af2fc2b7c1d2226ce628f60415fd384ffc75a342 - Fixes in Gallery help page Change-Id: I319b4a6c3b028bf36c86752a73855e947826b271 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/165845 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index 8db831e3f0dc..af2fc2b7c1d2 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 8db831e3f0dce474924168d18e4f8d23fc29f731 +Subproject commit af2fc2b7c1d2226ce628f60415fd384ffc75a342
help.git: source/text
source/text/shared/01/gallery.xhp |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit af2fc2b7c1d2226ce628f60415fd384ffc75a342 Author: Olivier Hallot AuthorDate: Tue Apr 9 13:03:56 2024 +0100 Commit: Olivier Hallot CommitDate: Tue Apr 9 14:27:02 2024 +0200 Fixes in Gallery help page Change-Id: I319b4a6c3b028bf36c86752a73855e947826b271 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/165845 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/source/text/shared/01/gallery.xhp b/source/text/shared/01/gallery.xhp index 06d7099db3..7ab9e9b443 100644 --- a/source/text/shared/01/gallery.xhp +++ b/source/text/shared/01/gallery.xhp @@ -54,7 +54,7 @@ Choose Insert - Gallery. - Alt+3 + OptionAlt + 3
core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit ef802f7dbeee84262b56ab72079cd1c3a40784e0 Author: Olivier Hallot AuthorDate: Mon Apr 8 13:44:16 2024 -0300 Commit: Gerrit Code Review CommitDate: Mon Apr 8 18:44:16 2024 +0200 Update git submodules * Update helpcontent2 from branch 'master' to 8db831e3f0dce474924168d18e4f8d23fc29f731 - tdf#160179 Recalculate row height at load times + refactor Change-Id: I0a81e254a8c40487d6ca559860c02ec1f4f44912 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/165890 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index 4c741dd9f01c..8db831e3f0dc 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 4c741dd9f01c329e58fe6c5ae6cfcf7570c5a8c7 +Subproject commit 8db831e3f0dce474924168d18e4f8d23fc29f731
help.git: source/text
source/text/shared/optionen/01060900.xhp | 74 ++-
1 file changed, 45 insertions(+), 29 deletions(-)
New commits:
commit 8db831e3f0dce474924168d18e4f8d23fc29f731
Author: Olivier Hallot
AuthorDate: Mon Apr 8 12:49:41 2024 -0300
Commit: Olivier Hallot
CommitDate: Mon Apr 8 18:44:16 2024 +0200
tdf#160179 Recalculate row height at load times
+ refactor
Change-Id: I0a81e254a8c40487d6ca559860c02ec1f4f44912
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/165890
Tested-by: Jenkins
Reviewed-by: Olivier Hallot
diff --git a/source/text/shared/optionen/01060900.xhp
b/source/text/shared/optionen/01060900.xhp
index ae6ca2244a..56cea987cb 100644
--- a/source/text/shared/optionen/01060900.xhp
+++ b/source/text/shared/optionen/01060900.xhp
@@ -20,13 +20,13 @@
-Formula
+Formula
/text/shared/optionen/01060900.xhp
-
+
formula options;formula syntax
formula options;separators
formula options;reference syntax in string
parameters
@@ -40,67 +40,83 @@
recalculating;formula options
recalculating;large spreadsheet files
loading;large spreadsheet files
+loading;optimal row height
+optimal row height;recalculation
-
-
+
+
Formula
-Defines formula syntax options and loading options for %PRODUCTNAME
Calc.
+Defines
formula syntax options and loading options for %PRODUCTNAME
Calc.
Formula options
Formula syntax
-There are
three options. Let's see it by example. In a sample spreadsheet there are two
worksheets, Sheet1 and Sheet2. In A1 cell of Sheet1 there is a reference to C4
cell of Sheet2.
+There are three options.
Let's see it by example. In a sample spreadsheet there are two worksheets,
Sheet1 and Sheet2. In A1 cell of Sheet1 there is a reference to C4 cell of
Sheet2.
-Calc A1 - This is the default of %PRODUCTNAME
Calc. The reference will be =$Sheet2.C4
+Calc A1
- This is the default of %PRODUCTNAME Calc. The reference will be =$Sheet2.C4
-Excel A1 - This is the default of Microsoft
Excel. The reference will be =Sheet2!C4
+Excel
A1 - This is the default of Microsoft Excel. The reference will be =Sheet2!C4
-Excel R1C1 - This is the relative row/column
addressing, known from Microsoft Excel. The reference will be =Sheet2!R[3]C[2]
+Excel
R1C1 - This is the relative row/column addressing, known from Microsoft
Excel. The reference will be =Sheet2!R[3]C[2]
Use English function names
-In
%PRODUCTNAME Calc function names can be localized. By default, the check box is
off, which means the localized function names are used. Checking this check box
will swap localized function names with the English ones. This change takes
effect in all of the following areas: formula input and display, function
wizard, and formula tips. You can of course uncheck it to go back to the
localized function names.
+In %PRODUCTNAME Calc
function names can be localized. By default, the check box is off, which means
the localized function names are used. Checking this check box will swap
localized function names with the English ones. This change takes effect in all
of the following areas: formula input and display, function wizard, and formula
tips. You can of course uncheck it to go back to the localized function
names.
Separators
-This
option group lets you configure separators in your formula expressions. This
comes in handy when, for instance, you want to separate your function
parameters by commas (,) instead of semicolons (;).
-For
example, instead of =SUM(A1;B1;C1) you can type =SUM(A1,B1,C1).
-Likewise,
you can also change the column and row separators for in-line arrays.
Previously, an in-line array used semicolons (;) as the column separators and
the pipe symbols (|) as the row separators, so a typical in-line array
expression looked like this for a 5 x 2 matrix array:
-={1;2;3;4;5|6;7;8;9;10}
-By
changing the column separators to commas (,) and the row separators to
semicolons (;), the same expression will look like this:
-={1,2,3,4,5;6,7,8,9,10}
+This option group lets you
configure separators in your formula expressions. This comes in handy when, for
instance, you want to separate your function parameters by commas (,) instead
of semicolons (;).
+For example, instead of
=SUM(A1;B1;C1) you can type =SUM(A1,B1,C1).
+Likewise, you can also
change the column and row separators for in-line arrays. Previously, an in-line
array used semicolons (;) as the column separators and the pipe symbols (|) as
the row separators, so a typical in-line array expression looked like this for
a 5 x 2 matrix array:
+={1;2;3;4;5|6;7;8;9;10
Re: ESC meeting minutes: 2024-04-04
HI On 4/4/24 11:35, Miklos Vajna wrote: + Guides + WIP + xml:id (https://docs.oasis-open.org/office/OpenDocument/v1.3/os/part3-schema/OpenDocument-v1.3-os-part3-schema.html#__RefHeading__1419430_253892949) + Is it implemented/used in LO? + It's implement in Writer, but only for a fraction of the elements allowed by the schema (Michael S) + should work for and other metadata-related ones + see https://wiki.documentfoundation.org/Documentation/DevGuide/OfficeDev/RDF_metadata#RDF_metadata + bottom of the page has the details, can generate an ID using the API / by a macro + would be helpful for translation as well (Olivier) + also on the TDF wiki these days (Thorsten) One of the open issue I have is to document the page Tool -Option - Writer - Comparison. AFAIK, it was created in a GSoC project at OO.org times. Is this page related to the xml:id topic I raised in the ESC meeting? Any recollections welcome. Thanks for the advise -- Olivier Hallot LibreOffice Documentation Coordinator Rio de Janeiro - Brasil - Local Time: UTC-03:00 LibreOffice – free and open source office suite: https://www.libreoffice.org Respects your privacy, and gives you back control over your data http://tdf.io/joinus OpenPGP_0x59F8BA50F9918DE6.asc Description: OpenPGP public key OpenPGP_signature.asc Description: OpenPGP digital signature
help.git: source/text
source/text/sbasic/shared/exportasfixedformat.xhp |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 4c741dd9f01c329e58fe6c5ae6cfcf7570c5a8c7 Author: Olivier Hallot AuthorDate: Thu Apr 4 14:54:07 2024 -0300 Commit: Adolfo Jayme Barrientos CommitDate: Fri Apr 5 07:32:25 2024 +0200 Mute l10n in page title Change-Id: Id715ea5bd4b17ac866e8c5638e0f725b9aaa6b96 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/165803 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos diff --git a/source/text/sbasic/shared/exportasfixedformat.xhp b/source/text/sbasic/shared/exportasfixedformat.xhp index 2705c8c865..0259209369 100644 --- a/source/text/sbasic/shared/exportasfixedformat.xhp +++ b/source/text/sbasic/shared/exportasfixedformat.xhp @@ -11,7 +11,7 @@ -ExportAsFixedFormat +ExportAsFixedFormat /text/sbasic/shared/exportasfixedformat.xhp
core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 438f0742320a5999e5ca785d152fd14a279799e1 Author: Olivier Hallot AuthorDate: Fri Apr 5 02:32:25 2024 -0300 Commit: Gerrit Code Review CommitDate: Fri Apr 5 07:32:25 2024 +0200 Update git submodules * Update helpcontent2 from branch 'master' to 4c741dd9f01c329e58fe6c5ae6cfcf7570c5a8c7 - Mute l10n in page title Change-Id: Id715ea5bd4b17ac866e8c5638e0f725b9aaa6b96 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/165803 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos diff --git a/helpcontent2 b/helpcontent2 index c89178e82aba..4c741dd9f01c 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit c89178e82abacbb240e571fcbd9bd0f76b40642d +Subproject commit 4c741dd9f01c329e58fe6c5ae6cfcf7570c5a8c7
core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit c9c4c1f21fd13f047497f4d66952f98bdabe442f Author: Olivier Hallot AuthorDate: Wed Apr 3 07:39:31 2024 -0300 Commit: Gerrit Code Review CommitDate: Wed Apr 3 12:39:31 2024 +0200 Update git submodules * Update helpcontent2 from branch 'master' to c6fec27df9ba67681d6d1bea474557123c395d13 - Fix several "D'oh! you found a bug" + some refactor Change-Id: I496d90ea26a41bd2ddb98af1e4e80b51322720e5 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/165708 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index 336461782a58..c6fec27df9ba 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 336461782a58266eb90a0c96c6c48a5454fe6b7f +Subproject commit c6fec27df9ba67681d6d1bea474557123c395d13
help.git: source/text
source/text/scalc/main0202.xhp |4 - source/text/shared/00/00040502.xhp |6 +- source/text/shared/guide/gallery_insert.xhp| 37 + source/text/simpress/main0203.xhp |4 - source/text/swriter/guide/insert_graphic_fromchart.xhp | 25 source/text/swriter/main0202.xhp | 48 - 6 files changed, 61 insertions(+), 63 deletions(-) New commits: commit c6fec27df9ba67681d6d1bea474557123c395d13 Author: Olivier Hallot AuthorDate: Tue Apr 2 21:10:46 2024 -0300 Commit: Olivier Hallot CommitDate: Wed Apr 3 12:39:30 2024 +0200 Fix several "D'oh! you found a bug" + some refactor Change-Id: I496d90ea26a41bd2ddb98af1e4e80b51322720e5 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/165708 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/source/text/scalc/main0202.xhp b/source/text/scalc/main0202.xhp index 207ce92fbb..8077985170 100644 --- a/source/text/scalc/main0202.xhp +++ b/source/text/scalc/main0202.xhp @@ -65,9 +65,9 @@ - + - + diff --git a/source/text/shared/00/00040502.xhp b/source/text/shared/00/00040502.xhp index 04352a5302..a804c19ef3 100644 --- a/source/text/shared/00/00040502.xhp +++ b/source/text/shared/00/00040502.xhp @@ -895,6 +895,7 @@ Choose Home - Increase Indent. + @@ -905,6 +906,7 @@ + @@ -926,6 +928,7 @@ Choose Home - Decrease Indent. + @@ -935,7 +938,8 @@ Decrease Indent - + + diff --git a/source/text/shared/guide/gallery_insert.xhp b/source/text/shared/guide/gallery_insert.xhp index d2f9278970..cb64a0 100644 --- a/source/text/shared/guide/gallery_insert.xhp +++ b/source/text/shared/guide/gallery_insert.xhp @@ -1,7 +1,4 @@ - - - - - - + -Inserting Objects From the Gallery +Inserting Objects From the Gallery /text/shared/guide/gallery_insert.xhp - + Gallery; inserting pictures from pictures; inserting from Gallery inserting; from Gallery into text @@ -46,32 +41,32 @@ mw deleted "adding;" - + Inserting Objects From the Gallery - - You can insert an object from the Gallery into a text, spreadsheet, drawing or presentation document by dragging and dropping or using the Context Menu. Inserting an object creates a copy of the object so any changes to the object in your document will not affect the object in the Gallery. + + You can insert an object from the Gallery into a text, spreadsheet, drawing or presentation document by dragging and dropping or using the Context Menu. Inserting an object creates a copy of the object so any changes to the object in your document will not affect the object in the Gallery. - + Inserting an object into a document -Open the Gallery. +Open the Gallery. -Select a theme. +Select a theme. -Select an object using a single click. +Select an object using a single click. -Drag the object into the document, or right-click to open the context menu and select Insert. +Drag the object into the document, or right-click to open the context menu and select Insert. Replacing an object in a document By dragging and dropping -Open the Gallery. +Open the Gallery. Select a theme. @@ -104,16 +99,16 @@ Inserting an object as a background graphic -Open the Gallery. +Open the Gallery. -Select a theme. +Select a theme. -Select an object by a single click. +Select an object by a single click. -Open the context menu and choose Insert - Background - Page or Insert - Background - Paragraph. +Open the context menu and choose Insert - Background - Page or Insert - Background - Paragraph. The option to insert an object as a background image is only available in %PRODUCTNAME Writer. diff --git a/source/text/simpress/main0203.xhp b/source/text/simpress/main0203.xhp index 761814b446..8a3ea7d30b 100644 --- a/source/text/simpress/main0203.xhp +++ b/source/text/simpress/main0203.xhp @@ -53,9 +53,9 @@ - + - + diff --git a/source/text/swriter/guide/insert_graphic_fromchart.xhp b/source/text/swriter/guide/insert_graphic_fromchart.xhp index 649e721c55..e9c72dff27 100644 --- a/source/text/swriter/guide/insert_graphic_fromchart.xhp +++ b/source/text/swriter/guide/insert_graphic_fromchart.xhp @@ -21,40 +21,39 @@ - - In
Re: Handling text in Excel SORT/SORTBY functions recently merged
HI Balázs
Thank you for the clarification.
From an interoperability POV, the behavior is supposed to be known.
I think it deserves some notes for internationalization of the sort
function.
(may be I'm overstating)
Cheers
Olivier
On 3/27/24 05:29, Balázs Varga wrote:
Hi Olivier,
>> MS does not specify the behavior when data to sort is a mix of numbers
and text in their user support pages.
Yes, I also didn't find any official documentation which is directly
related to how those functions handle the mix data.
But after a lot of testing I realized that in Excel the SORT/SORTBY is
sorting/working the same as the basic UI Sort works in Excel.
So I based on that during the implementation. Also our UI Sorting works
the same as Excel UI Sorting, so that was the best way to
follow that. :) But everything else was implemented based on the
Official documentations.
Also we couldn't file the Oasis proposal yet, since we couldn't log in
for a while to the Oasis page. But I already wrote the draft,
which can be uploaded. Just attached to the mail.
Best,
Balázs
Olivier Hallot <mailto:olivier.hal...@libreoffice.org>> ezt írta (időpont: 2024. márc.
26., K, 20:59):
hi...
I'm testing Calc's SORT function recently merged.
MS does not specify the behavior when data to sort is a mix of numbers
and text in their user support pages.
When text is present in the array to sort, text appears to be higher
than the highest numerical value (sort descending) or lower than the
lowest numerical value (sort ascending)
In either case, text is not treated as zero or blank as many other Calc
functions. To me this is a point of attention (documentation-wise).
Anybody can point me where to confirm the way Excel treat text for SORT
(and SORTBY) functions?.
Thank you
--
Olivier Hallot
LibreOffice Documentation Coordinator
Rio de Janeiro - Brasil - Local Time: UTC-03:00
LibreOffice – free and open source office suite:
https://www.libreoffice.org <https://www.libreoffice.org>
Respects your privacy, and gives you back control over your data
http://tdf.io/joinus <http://tdf.io/joinus>
--
Olivier Hallot
LibreOffice Documentation Coordinator
Rio de Janeiro - Brasil - Local Time: UTC-03:00
LibreOffice – free and open source office suite: https://www.libreoffice.org
Respects your privacy, and gives you back control over your data
http://tdf.io/joinus
OpenPGP_0x59F8BA50F9918DE6.asc
Description: OpenPGP public key
OpenPGP_signature.asc
Description: OpenPGP digital signature
help.git: source/text
source/text/scalc/01/ex_data_stat_func.xhp | 12 +-
source/text/scalc/01/func_sort.xhp |3
source/text/scalc/01/func_sortby.xhp | 162 -
3 files changed, 167 insertions(+), 10 deletions(-)
New commits:
commit e8b0e4366701e46f775cca486ee65a1291c56456
Author: Olivier Hallot
AuthorDate: Wed Mar 27 15:26:45 2024 -0300
Commit: Olivier Hallot
CommitDate: Wed Mar 27 19:30:38 2024 +0100
tdf#159872 Help page for SORTBY function (final).
Change-Id: If3f9746d20aa60bab06c2607e5d8fce557e91f75
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/165431
Tested-by: Jenkins
Reviewed-by: Olivier Hallot
diff --git a/source/text/scalc/01/ex_data_stat_func.xhp
b/source/text/scalc/01/ex_data_stat_func.xhp
index c7898b6ea8..994116e365 100644
--- a/source/text/scalc/01/ex_data_stat_func.xhp
+++ b/source/text/scalc/01/ex_data_stat_func.xhp
@@ -42,10 +42,10 @@
Product
Name
- Sales
+ Sales
- Revenue
+ Revenue
@@ -106,16 +106,16 @@
- 6
+ 6
- pencil-case
+ pencil-case
- not
+ not
- not
+ not
diff --git a/source/text/scalc/01/func_sort.xhp
b/source/text/scalc/01/func_sort.xhp
index 7628d9b663..e0f9b694c8 100644
--- a/source/text/scalc/01/func_sort.xhp
+++ b/source/text/scalc/01/func_sort.xhp
@@ -10,7 +10,7 @@
-->
-
+
SORT function
/text/scalc/01/func_sort.xhp
@@ -161,6 +161,7 @@
COM.MICROSOFT.SORT
https://wiki.documentfoundation.org/Documentation/Calc_Functions/SORT;>SORT
wiki page.
+
diff --git a/source/text/scalc/01/func_sortby.xhp
b/source/text/scalc/01/func_sortby.xhp
index 41d272f6dd..d22710928e 100644
--- a/source/text/scalc/01/func_sortby.xhp
+++ b/source/text/scalc/01/func_sortby.xhp
@@ -18,21 +18,177 @@
-SORTBY function
+SORTBY function
SORTBY
-(...)
+Sorts the contents
of a range or array based on the values in a corresponding range or
array.
-SORTBY(...)
+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.
+
+Consider the
following table
+
+
+
+
+
+A
+
+
+B
+
+
+C
+
+
+
+
+1
+
+
+Product Name
+
+
+Sales
+
+
+Revenue
+
+
+
+
+2
+
+
+pencil
+
+
+20
+
+
+65
+
+
+
+
+3
+
+
+pen
+
+
+35
+
+
+85
+
+
+
+
+4
+
+
+notebook
+
+
+20
+
+
+190
+
+
+
+
+5
+
+
+book
+
+
+17
+
+
+180
+
+
+
+
+6
+
+
+pencil-case
+
+
+not
+
+
+not
+
+
+
+
+7
+
+
+pen
+
+
+10
+
+
+45
+
+
+
+
+Example with ascending order and descending
order (for English locale)
+{=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.
+
+
+book
+17
+180
+
+
+notebook
+20
+190
+
+
+pen
+35
+85
+
+
+pen
+10
+45
+
+
+pencil
+20
+65
+
+
+pencil-case
+not
+not
+
+
+
COM.MICROSOFT.SORTBY
https://wiki.documentfoundation.org/Documentation/Calc_Functions/SORTBY;>SORTBY
wiki page.
+
core.git: 2 commits - helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 09920926b7ee038daec5c96361c70f66ed5f7265 Author: Olivier Hallot AuthorDate: Wed Mar 27 15:30:38 2024 -0300 Commit: Gerrit Code Review CommitDate: Wed Mar 27 19:30:38 2024 +0100 Update git submodules * Update helpcontent2 from branch 'master' to e8b0e4366701e46f775cca486ee65a1291c56456 - tdf#159872 Help page for SORTBY function (final). Change-Id: If3f9746d20aa60bab06c2607e5d8fce557e91f75 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/165431 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index 9736fda4e1a2..e8b0e4366701 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 9736fda4e1a2994e1ea7377c37f61bad058f69b8 +Subproject commit e8b0e4366701e46f775cca486ee65a1291c56456 commit e27b9026e41cd3274f96bfc82c9555dbd9a204d8 Author: Olivier Hallot AuthorDate: Wed Mar 27 15:30:20 2024 -0300 Commit: Gerrit Code Review CommitDate: Wed Mar 27 19:30:20 2024 +0100 Update git submodules * Update helpcontent2 from branch 'master' to 9736fda4e1a2994e1ea7377c37f61bad058f69b8 - tdf#159872 Help page for SORT function (final). Change-Id: Ib3385327c2fab41a0a9d76bf8913e76c46864059 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/165430 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index 9f4e1983f6ed..9736fda4e1a2 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 9f4e1983f6edae8f5ce8ee2e319410d4e1e39084 +Subproject commit 9736fda4e1a2994e1ea7377c37f61bad058f69b8
help.git: source/text
source/text/scalc/01/ex_data_stat_func.xhp |2
source/text/scalc/01/func_averageifs.xhp |4
source/text/scalc/01/func_sort.xhp | 134 -
3 files changed, 135 insertions(+), 5 deletions(-)
New commits:
commit 9736fda4e1a2994e1ea7377c37f61bad058f69b8
Author: Olivier Hallot
AuthorDate: Wed Mar 27 09:47:25 2024 -0300
Commit: Olivier Hallot
CommitDate: Wed Mar 27 19:30:20 2024 +0100
tdf#159872 Help page for SORT function (final).
Change-Id: Ib3385327c2fab41a0a9d76bf8913e76c46864059
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/165430
Tested-by: Jenkins
Reviewed-by: Olivier Hallot
diff --git a/source/text/scalc/01/ex_data_stat_func.xhp
b/source/text/scalc/01/ex_data_stat_func.xhp
index fef3ee0545..c7898b6ea8 100644
--- a/source/text/scalc/01/ex_data_stat_func.xhp
+++ b/source/text/scalc/01/ex_data_stat_func.xhp
@@ -18,6 +18,7 @@
+
Consider the following
table
@@ -118,6 +119,7 @@
+
In all examples below, ranges for
calculation contain the row #6, which is ignored because it contains
text.
Func_Range; Range1; Criterion[; Range2; Criterion2][; … ; [Range127;
Criterion127]]
diff --git a/source/text/scalc/01/func_averageifs.xhp
b/source/text/scalc/01/func_averageifs.xhp
index 0da2629284..53b007c8ce 100644
--- a/source/text/scalc/01/func_averageifs.xhp
+++ b/source/text/scalc/01/func_averageifs.xhp
@@ -36,8 +36,7 @@
-
-
+
Simple usage
=AVERAGEIFS(B2:B6;B2:B6;"=20")
@@ -54,6 +53,7 @@
=AVERAGEIFS(C2:C6;A2:A6;E2".*";B2:B6;""MAX(B2:B6))
If E2 = pen, the
function returns 65, because the link to the cell is substituted with its
content.
+
https://wiki.documentfoundation.org/Documentation/Calc_Functions/AVERAGEIFS;>AVERAGEIFS
wiki page.
diff --git a/source/text/scalc/01/func_sort.xhp
b/source/text/scalc/01/func_sort.xhp
index 15d637ac43..7628d9b663 100644
--- a/source/text/scalc/01/func_sort.xhp
+++ b/source/text/scalc/01/func_sort.xhp
@@ -18,15 +18,143 @@
-SORT function
+SORT function
SORT
-(...)
+Sorts the contents
of a range or array.
+Enter the formula as an array formula.
-SORT(...)
+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.
+
+
+Example with ascending order
+{=SORT(A2:C6,2,1)}
+Sort the range A2:C6
based on the second column in ascending order (Sales).
+
+
+
+book
+
+
+17
+
+
+180
+
+
+
+
+pencil
+
+
+20
+
+
+65
+
+
+
+
+notebook
+
+
+20
+
+
+190
+
+
+
+
+pen
+
+
+35
+
+
+85
+
+
+
+
+pencil-case
+
+
+not
+
+
+not
+
+
+
+Example with descending order
+{=SORT(A2:C6,3,-1)}
+Sort the range A2:C6
based on the third column in descending order (Revenue).
+
+
+
+pencil-case
+
+
+not
+
+
+not
+
+
+
+
+notebook
+
+
+20
+
+
+190
+
+
+
+
+book
+
+
+17
+
+
+180
+
+
+
+
+pen
+
+
+35
+
+
+85
+
+
+
+
+pencil
+
+
+20
+
+
+65
+
+
+
+
core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 7a15fcf9ca348f2cc6ffb57b8bc967ea899f755a Author: Olivier Hallot AuthorDate: Wed Mar 27 15:29:55 2024 -0300 Commit: Gerrit Code Review CommitDate: Wed Mar 27 19:29:55 2024 +0100 Update git submodules * Update helpcontent2 from branch 'master' to 9f4e1983f6edae8f5ce8ee2e319410d4e1e39084 - Refactor help pages for some Calc functions Change-Id: I06a4b2da852cac91b41ac551c4f08ad78b7e3e47 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/165409 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index 093252967828..9f4e1983f6ed 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 093252967828e122a391226a7e1f0afa415f682a +Subproject commit 9f4e1983f6edae8f5ce8ee2e319410d4e1e39084
help.git: source/text
source/text/scalc/01/ex_data_stat_func.xhp | 77 ++--- source/text/scalc/01/func_averageif.xhp| 70 +- source/text/scalc/01/func_averageifs.xhp | 40 +++ source/text/scalc/01/func_countifs.xhp | 43 source/text/scalc/01/func_filter.xhp |1 source/text/scalc/01/func_maxifs.xhp | 41 +++ source/text/scalc/01/func_minifs.xhp | 41 +++ source/text/scalc/01/func_sumif.xhp|1 source/text/scalc/01/func_sumifs.xhp |1 9 files changed, 160 insertions(+), 155 deletions(-) New commits: commit 9f4e1983f6edae8f5ce8ee2e319410d4e1e39084 Author: Olivier Hallot AuthorDate: Tue Mar 26 13:11:59 2024 -0300 Commit: Olivier Hallot CommitDate: Wed Mar 27 19:29:55 2024 +0100 Refactor help pages for some Calc functions Change-Id: I06a4b2da852cac91b41ac551c4f08ad78b7e3e47 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/165409 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/source/text/scalc/01/ex_data_stat_func.xhp b/source/text/scalc/01/ex_data_stat_func.xhp index a05fad017f..fef3ee0545 100644 --- a/source/text/scalc/01/ex_data_stat_func.xhp +++ b/source/text/scalc/01/ex_data_stat_func.xhp @@ -11,135 +11,134 @@ -Examples Dataset for Statistical Functions +Examples Dataset for Statistical Functions /text/scalc/01/ex_data_stat_func.xhp - Consider the following table - A + A - B + B - C + C - 1 + 1 - Product Name + Product Name - Sales + Sales - Revenue + Revenue - 2 + 2 - pencil + pencil - 20 + 20 - 65 + 65 - 3 + 3 - pen + pen - 35 + 35 - 85 + 85 - 4 + 4 - notebook + notebook - 20 + 20 - 190 + 190 - 5 + 5 - book + book - 17 + 17 - 180 + 180 - 6 + 6 - pencil-case + pencil-case - not + not - not + not In all examples below, ranges for calculation contain the row #6, which is ignored because it contains text. -Func_Range; Range1; Criterion[; Range2; Criterion2][; … ; [Range127; Criterion127]] +Func_Range; Range1; Criterion[; Range2; Criterion2][; … ; [Range127; Criterion127]] The logical relation between criteria can be defined as logical AND (conjunction). In other words, if and only if all given criteria are met, a value from the corresponding cell of the given Func_Range is taken into calculation. -Func_Range and Range1, Range2... must have the same size, otherwise the function returns err:502 - Invalid argument. +Func_Range and Range1, Range2... must have the same size, otherwise the function returns err:502 - Invalid argument. -Range1 – required argument. It is a range of cells, a name of a named range, or a label of a column or a row, to which the corresponding criterion is to be applied. +Range1 – required argument. It is a range of cells, a name of a named range, or a label of a column or a row, to which the corresponding criterion is to be applied. Criterion: A criterion is a single cell Reference, Number or Text. It is used in comparisons with cell contents. A reference to an empty cell is interpreted as the numeric value 0. A matching expression can be: -A Number or Logical value. A matching cell content equals the Number or Logical value. +A Number or Logical value. A matching cell content equals the Number or Logical value. -A value beginning with a comparator (, =, =, , =, ). +A value beginning with a comparator (, =, =, , =, ). For =, if the value is empty it matches empty cells. For , if the value is empty it matches non-empty cells. For , if the value is not empty it matches any cell content except the value, including empty cells. @@ -147,16 +146,16 @@ For = and , if the value is not empty and can not be interpreted as a Number type or one of its subtypes and the property Search criteria = and must apply to whole cells is checked, comparison is against the entire cell contents, if unchecked, comparison is against any subpart of the field that matches the criteria. For = and , if the value is not empty and can
Handling text in Excel SORT/SORTBY functions recently merged
hi... I'm testing Calc's SORT function recently merged. MS does not specify the behavior when data to sort is a mix of numbers and text in their user support pages. When text is present in the array to sort, text appears to be higher than the highest numerical value (sort descending) or lower than the lowest numerical value (sort ascending) In either case, text is not treated as zero or blank as many other Calc functions. To me this is a point of attention (documentation-wise). Anybody can point me where to confirm the way Excel treat text for SORT (and SORTBY) functions?. Thank you -- Olivier Hallot LibreOffice Documentation Coordinator Rio de Janeiro - Brasil - Local Time: UTC-03:00 LibreOffice – free and open source office suite: https://www.libreoffice.org Respects your privacy, and gives you back control over your data http://tdf.io/joinus OpenPGP_0x59F8BA50F9918DE6.asc Description: OpenPGP public key OpenPGP_signature.asc Description: OpenPGP digital signature
core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit c58b2070f1653454e9e6e4821f9688b3d623039e Author: Olivier Hallot AuthorDate: Tue Mar 26 09:13:09 2024 -0300 Commit: Gerrit Code Review CommitDate: Tue Mar 26 13:13:09 2024 +0100 Update git submodules * Update helpcontent2 from branch 'master' to db5de3869538e6befd296b3d1595759f241e1e6a - Housekeeping on Help files Change-Id: I239231d51a785a12c35a1c609b83f8390931711a Reviewed-on: https://gerrit.libreoffice.org/c/help/+/165333 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index b39d692e34ae..db5de3869538 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit b39d692e34aec084c9ec38f2b22394ebccb54ffe +Subproject commit db5de3869538e6befd296b3d1595759f241e1e6a
help.git: source/text
source/text/shared/00/0406.xhp | 11 ++- source/text/shared/optionen/01040200.xhp | 113 ++- 2 files changed, 63 insertions(+), 61 deletions(-) New commits: commit db5de3869538e6befd296b3d1595759f241e1e6a Author: Olivier Hallot AuthorDate: Tue Mar 26 08:53:10 2024 -0300 Commit: Olivier Hallot CommitDate: Tue Mar 26 13:13:08 2024 +0100 Housekeeping on Help files Change-Id: I239231d51a785a12c35a1c609b83f8390931711a Reviewed-on: https://gerrit.libreoffice.org/c/help/+/165333 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/source/text/shared/00/0406.xhp b/source/text/shared/00/0406.xhp index c3e43e7bb4..1e42b495b1 100644 --- a/source/text/shared/00/0406.xhp +++ b/source/text/shared/00/0406.xhp @@ -323,7 +323,16 @@ Open a text document, choose %PRODUCTNAME - PreferencesTools - Options - %PRODUCTNAME Writer - General. Open a text document, choose %PRODUCTNAME - PreferencesTools - Options - %PRODUCTNAME Writer - Mail Merge Email. Open a text document, choose %PRODUCTNAME - PreferencesTools - Options - %PRODUCTNAME Writer - AutoCaption. -Open a text document, choose %PRODUCTNAME - PreferencesTools - Options - %PRODUCTNAME Writer/%PRODUCTNAME Writer/Web - View. + + +Open a text document, choose %PRODUCTNAME - PreferencesTools - Options - %PRODUCTNAME Writer/%PRODUCTNAME Writer/Web - View. + +On the top right menu (☰), choose Options +- then in the Options dialog, choose %PRODUCTNAME Writer - View or %PRODUCTNAME Writer/Web - View. + +Alt + F12 +- then in the Options dialog, choose %PRODUCTNAME Writer - View or %PRODUCTNAME Writer/Web - View. + Open a text document, choose %PRODUCTNAME - PreferencesTools - Options - %PRODUCTNAME Writer/%PRODUCTNAME Writer/Web - Formatting Aids. Choose %PRODUCTNAME - PreferencesTools - Options - %PRODUCTNAME Writer/%PRODUCTNAME Calc/%PRODUCTNAME Writer/Web - Grid. diff --git a/source/text/shared/optionen/01040200.xhp b/source/text/shared/optionen/01040200.xhp index 3bfeb3d94c..a72ea5f7b9 100644 --- a/source/text/shared/optionen/01040200.xhp +++ b/source/text/shared/optionen/01040200.xhp @@ -19,13 +19,13 @@ -View +View /text/shared/optionen/01040200.xhp - + snap lines; showing when moving frames (Writer) scrollbars; horizontal and vertical (Writer) horizontal scrollbars (Writer) @@ -44,78 +44,71 @@ controls; showing (Writer) displaying; comments in text documents - - + + View -Defines the default settings for displaying objects in your text documents and also the default settings for the window elements. +Defines the default settings for displaying objects in your text documents and also the default settings for the window elements. - - - - On the top right menu (☰), choose Options - - then in the Options dialog, choose %PRODUCTNAME Writer - View or %PRODUCTNAME Writer/Web - View. - - Alt + F12 - - then in the Options dialog, choose %PRODUCTNAME Writer - View or %PRODUCTNAME Writer/Web - View. - -Guides -Specifies settings that refer to the representation of boundaries. - -Helplines While Moving -Displays snap lines around the frames when frames are moved. You can select the Helplines While Moving option to show the exact position of the object using lineal values. -Display -Defines which document elements are displayed. - + + +Guides +Specifies settings that refer to the representation of boundaries. + +Helplines While Moving +Displays snap lines around the frames when frames are moved. You can select the Helplines While Moving option to show the exact position of the object using lineal values. +Display +Defines which document elements are displayed. + Images and objects -Specifies whether to display images and objects on the screen. +Specifies whether to display images and objects on the screen. If these elements are hidden, you will see empty frames as placeholders. -You can also control the display of graphics through the Images and Charts icon. If a text document is open, this icon is displayed on the Tools bar. +You can also control the display of graphics through the Images and Charts icon. If a text document is open, this icon is displayed on the Tools bar. If the Images and objects option is not selected, no graphics will be loaded from the Internet. Graphics within a table and without an indication of their size can cause display problems when using an older HTML standard on the browsed page. - + Tables -Displays the tables contained in your document. -To display the table boundaries, right-click any table and choose Table Boundaries, or choose Table - Table Boundaries in a Writer document. -Drawings and controls -Displays the drawings and controls contained in your document. +Displays the tables contained in your document
core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 0d859cee05aca630d013cfa8a4a6332775c95262 Author: Olivier Hallot AuthorDate: Mon Mar 25 13:14:29 2024 -0300 Commit: Gerrit Code Review CommitDate: Mon Mar 25 17:14:29 2024 +0100 Update git submodules * Update helpcontent2 from branch 'master' to 772dac9c72752c82c015bcd222655b50a6eeb9eb - tdf#160035 Remove extra Help page Page 1904.xhp was not target of nay other link Change-Id: I2b3311aaa8f6bd2616096e922b3118856c749bfe Reviewed-on: https://gerrit.libreoffice.org/c/help/+/165289 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index c8ef32e905f0..772dac9c7275 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit c8ef32e905f028ee451b3664f72c0b508c74c6c5 +Subproject commit 772dac9c72752c82c015bcd222655b50a6eeb9eb
help.git: AllLangHelp_swriter.mk source/text
AllLangHelp_swriter.mk |1 source/text/swriter/02/1904.xhp | 45 2 files changed, 46 deletions(-) New commits: commit 772dac9c72752c82c015bcd222655b50a6eeb9eb Author: Olivier Hallot AuthorDate: Mon Mar 25 11:59:22 2024 -0300 Commit: Olivier Hallot CommitDate: Mon Mar 25 17:14:29 2024 +0100 tdf#160035 Remove extra Help page Page 1904.xhp was not target of nay other link Change-Id: I2b3311aaa8f6bd2616096e922b3118856c749bfe Reviewed-on: https://gerrit.libreoffice.org/c/help/+/165289 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/AllLangHelp_swriter.mk b/AllLangHelp_swriter.mk index cc3e4c0c62..cbd647014e 100644 --- a/AllLangHelp_swriter.mk +++ b/AllLangHelp_swriter.mk @@ -270,7 +270,6 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,swriter,\ helpcontent2/source/text/swriter/02/1901 \ helpcontent2/source/text/swriter/02/1902 \ helpcontent2/source/text/swriter/02/1903 \ -helpcontent2/source/text/swriter/02/1904 \ helpcontent2/source/text/swriter/02/1905 \ helpcontent2/source/text/swriter/02/add_to_list \ helpcontent2/source/text/swriter/02/word_count_stb \ diff --git a/source/text/swriter/02/1904.xhp b/source/text/swriter/02/1904.xhp deleted file mode 100644 index 395c3e151a..00 --- a/source/text/swriter/02/1904.xhp +++ /dev/null @@ -1,45 +0,0 @@ - - - - - - - - -Insert Fields -/text/swriter/02/1904.xhp - - -Sun Microsystems, Inc. - - - -Insert Fields -Click to open the Fields dialog. Click the arrow next to the icon and select the required field from the submenu. -You can select the following functions: - - - -UFI added two lines, see #i60664 - - -Other - - -
core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit c4be391530a6a3ea2423020a7a836695b7ee9c90 Author: Olivier Hallot AuthorDate: Mon Mar 25 08:54:35 2024 -0300 Commit: Gerrit Code Review CommitDate: Mon Mar 25 12:54:35 2024 +0100 Update git submodules * Update helpcontent2 from branch 'master' to c8ef32e905f028ee451b3664f72c0b508c74c6c5 - tdf#159725 ExportAsFixedFormat Help page (WIP) Initial Help page for ExportAsFixedFormat VBA method. Missing: - Error codes related - Arguments not implemented Change-Id: I43ca670047542b29858e4384243d7e9a36a5efc0 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/165256 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index 7786ebca6185..c8ef32e905f0 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 7786ebca61858926ce0cd3894922dac725c1997b +Subproject commit c8ef32e905f028ee451b3664f72c0b508c74c6c5
help.git: AllLangHelp_sbasic.mk source/text
AllLangHelp_sbasic.mk | 19 +++ source/text/sbasic/shared/exportasfixedformat.xhp | 59 ++ source/text/sbasic/shared/special_vba_func.xhp| 23 3 files changed, 81 insertions(+), 20 deletions(-) New commits: commit c8ef32e905f028ee451b3664f72c0b508c74c6c5 Author: Olivier Hallot AuthorDate: Sun Mar 24 17:41:40 2024 -0300 Commit: Olivier Hallot CommitDate: Mon Mar 25 12:54:35 2024 +0100 tdf#159725 ExportAsFixedFormat Help page (WIP) Initial Help page for ExportAsFixedFormat VBA method. Missing: - Error codes related - Arguments not implemented Change-Id: I43ca670047542b29858e4384243d7e9a36a5efc0 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/165256 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/AllLangHelp_sbasic.mk b/AllLangHelp_sbasic.mk index c4c51f9b1a..00484ce127 100644 --- a/AllLangHelp_sbasic.mk +++ b/AllLangHelp_sbasic.mk @@ -400,8 +400,6 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,sbasic,\ helpcontent2/source/text/sbasic/shared/03170010 \ helpcontent2/source/text/sbasic/shared/03170020 \ helpcontent2/source/text/sbasic/shared/05060700 \ -helpcontent2/source/text/sbasic/shared/is_keyword \ -helpcontent2/source/text/sbasic/shared/new_keyword \ helpcontent2/source/text/sbasic/shared/calc_functions \ helpcontent2/source/text/sbasic/shared/code-stubs \ helpcontent2/source/text/sbasic/shared/CallByName \ @@ -413,23 +411,26 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,sbasic,\ helpcontent2/source/text/sbasic/shared/Compiler_options \ helpcontent2/source/text/sbasic/shared/CreateUnoSvcWithArgs \ helpcontent2/source/text/sbasic/shared/conventions \ -helpcontent2/source/text/sbasic/shared/enum \ helpcontent2/source/text/sbasic/shared/doEvents \ +helpcontent2/source/text/sbasic/shared/enum \ helpcontent2/source/text/sbasic/shared/ErrVBA \ +helpcontent2/source/text/sbasic/shared/exportasfixedformat \ helpcontent2/source/text/sbasic/shared/fragments \ -helpcontent2/source/text/sbasic/shared/partition \ -helpcontent2/source/text/sbasic/shared/property \ -helpcontent2/source/text/sbasic/shared/replace \ -helpcontent2/source/text/sbasic/shared/uno_objects \ -helpcontent2/source/text/sbasic/shared/stardesktop \ -helpcontent2/source/text/sbasic/shared/thisdbdoc \ helpcontent2/source/text/sbasic/shared/GetPathSeparator \ +helpcontent2/source/text/sbasic/shared/is_keyword \ helpcontent2/source/text/sbasic/shared/keys \ helpcontent2/source/text/sbasic/shared/main0211 \ helpcontent2/source/text/sbasic/shared/main0601 \ +helpcontent2/source/text/sbasic/shared/new_keyword \ +helpcontent2/source/text/sbasic/shared/partition \ +helpcontent2/source/text/sbasic/shared/property \ +helpcontent2/source/text/sbasic/shared/replace \ helpcontent2/source/text/sbasic/shared/Resume \ helpcontent2/source/text/sbasic/shared/special_vba_func \ +helpcontent2/source/text/sbasic/shared/stardesktop \ helpcontent2/source/text/sbasic/shared/strconv \ +helpcontent2/source/text/sbasic/shared/thisdbdoc \ +helpcontent2/source/text/sbasic/shared/uno_objects \ helpcontent2/source/text/sbasic/shared/vbasupport \ helpcontent2/source/text/sbasic/python/main \ helpcontent2/source/text/sbasic/python/python_2_basic \ diff --git a/source/text/sbasic/shared/exportasfixedformat.xhp b/source/text/sbasic/shared/exportasfixedformat.xhp new file mode 100644 index 00..2705c8c865 --- /dev/null +++ b/source/text/sbasic/shared/exportasfixedformat.xhp @@ -0,0 +1,59 @@ + + + + + + +ExportAsFixedFormat +/text/sbasic/shared/exportasfixedformat.xhp + + + + +ExportAsFixedFormat method [VBA] + + +ExportAsFixedFormat Method [VBA] +Method to export a Calc document to PDF format. + + + + + +expression.ExportAsFixedFormat (Type, Filename, Quality, IncludeDocProperties, IgnorePrintAreas, From, To, OpenAfterPublish) +Type: Integer, required. Can be either 0 or 1. 0 for "PDF" - Portable Document Format file (.pdf) and 1 for "XPS" - XPS Document (.xps) +XPS export format is not supported by %PRODUCTNAME. +Filename: String, optional. The file name of the exported file. +Quality: Integer, optional. Can be 0 or 1. 0 is for standard quality, 1 is for minimum quality. +IncludeDocProperties: Boolean, optional. Set to True to indicate that document properties should be included in the exported file, or set to False to suppress the export of document properties. +IgnorePrintAreas: Boolean, optional. If set to True, ignores any print ranges on export. If set to False, honor the print ranges on export. +From:Integer, optional. Page number of the first page to export. If omitted, export starts at the beginnin
help.git: source/text
source/text/scalc/01/func_sum.xhp| 17 +++--- source/text/scalc/01/func_sumif.xhp | 32 ++-- source/text/scalc/01/func_sumifs.xhp | 40 +-- 3 files changed, 45 insertions(+), 44 deletions(-) New commits: commit 7786ebca61858926ce0cd3894922dac725c1997b Author: Olivier Hallot AuthorDate: Sat Mar 23 10:10:10 2024 -0300 Commit: Olivier Hallot CommitDate: Sun Mar 24 10:13:24 2024 +0100 Housekeeping files on SUM/SUMIF/SUMIFS Change-Id: I07ac3a115a9b3f86ee05f75f0f3bcdd4cdf1ef69 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/165205 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/source/text/scalc/01/func_sum.xhp b/source/text/scalc/01/func_sum.xhp index ade627b857..cee32e58b9 100644 --- a/source/text/scalc/01/func_sum.xhp +++ b/source/text/scalc/01/func_sum.xhp @@ -11,14 +11,14 @@ -SUM Function +SUM Function /text/scalc/01/func_sum.xhp - - + + SUM function adding;numbers in cell ranges @@ -27,14 +27,15 @@ - SUM() + SUM() + - =SUM(2;3;4) returns 9. - =SUM(A1;A3;B5) calculates the sum of the three cells. - =SUM(A1:E10) calculates the sum of all cells in the A1 to E10 cell range. - A formula such as =SUM((A1:A40=C1)*(A1:A40C2)*B1:B40) may be entered as an array formula by pressing the Shift+Command+Ctrl+Enter keys instead of simply pressing the Enter key to finish entering the formula. The formula will then be shown in the Formula bar enclosed in braces and operates by multiplying corresponding elements of the arrays together and returning their sum. + =SUM(2;3;4) returns 9. + =SUM(A1;A3;B5) calculates the sum of the three cells. + =SUM(A1:E10) calculates the sum of all cells in the A1 to E10 cell range. + A formula such as =SUM((A1:A40=C1)*(A1:A40C2)*B1:B40) may be entered as an array formula by pressing the Shift+Command+Ctrl+Enter keys instead of simply pressing the Enter key to finish entering the formula. The formula will then be shown in the Formula bar enclosed in braces and operates by multiplying corresponding elements of the arrays together and returning their sum. https://wiki.documentfoundation.org/Documentation/Calc_Functions/SUM;>SUM wiki page. diff --git a/source/text/scalc/01/func_sumif.xhp b/source/text/scalc/01/func_sumif.xhp index b6c21457d3..5f723e6183 100644 --- a/source/text/scalc/01/func_sumif.xhp +++ b/source/text/scalc/01/func_sumif.xhp @@ -10,44 +10,44 @@ --> -SUMIF Function +SUMIF Function /text/scalc/01/func_sumif.xhp - + SUMIF function adding;specified numbers - + SUMIF - + Determines which values in a range of cells meet a specified criterion, then returns the sum of the matching values. Alternatively the function can determine which values in one range of cells meet a criterion, then return the sum of values in the corresponding cells in a second range of cells. SUMIF can only apply a single criterion to a range. Use SUMIFS if you need to apply multiple criteria. -SUMIF(Range; Criterion [;SumRange]) -Range: The range of cells to which the criterion is applied. +SUMIF(Range; Criterion [;SumRange]) +Range: The range of cells to which the criterion is applied. SUMIF supports the reference concatenation operator (~) only in the Range parameter, and only if the optional SumRange parameter is not given. -SumRange: Optional. The range of cells from which values are summed. If no SumRange is given, the values in the Range are summed. - +SumRange: Optional. The range of cells from which values are summed. If no SumRange is given, the values in the Range are summed. + Simple usage -=SUMIF(C2:C6,">=100") +=SUMIF(C2:C6,"=100") Sums only the values from range C2:C6 that are =100. Returns 370 because cells C2:C3 do not meet the criterion. The values from Range are summed because no SumRange is given. -=SUMIF(B2:B5,"=20",C2:C6) +=SUMIF(B2:B5,"=20",C2:C6) Sums values from the range B2:B6 only if the corresponding values in the range A1:A5 are =20. Returns 340 because the fifth and sixth rows do not meet the criterion. Using regular expressions =SUMIF(A2:A6,"pen",C2:C5) -Sums values from the range C2:C6 only if the corresponding range in A2:A6 exactly match the letters "pen". Returns 85 because rows A2 and A4:A6 do not meet the criterion. -=SUMIF(A2:A6,"pen*",C2:C6) -Sums the values from the range C2:C6 only if the corresponding cell in range A2:A6 contains the letters "pen". Returns the value 150 because rows A4:A5 do not meet the criterion. +Sums values from the range C2:C6 only if the corresponding
core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 04bad6534b74af0ec9d0a516e0bf0a9c5ec5568c Author: Olivier Hallot AuthorDate: Sun Mar 24 06:13:25 2024 -0300 Commit: Gerrit Code Review CommitDate: Sun Mar 24 10:13:25 2024 +0100 Update git submodules * Update helpcontent2 from branch 'master' to 7786ebca61858926ce0cd3894922dac725c1997b - Housekeeping files on SUM/SUMIF/SUMIFS Change-Id: I07ac3a115a9b3f86ee05f75f0f3bcdd4cdf1ef69 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/165205 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index 1e3c2cb1ffa5..7786ebca6185 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 1e3c2cb1ffa55b44e2b77d14ac5f5ce217630b8a +Subproject commit 7786ebca61858926ce0cd3894922dac725c1997b
core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 4f13189da07673d5c52276297afdd815db6feb98 Author: Olivier Hallot AuthorDate: Thu Mar 21 08:42:32 2024 -0300 Commit: Gerrit Code Review CommitDate: Thu Mar 21 12:42:32 2024 +0100 Update git submodules * Update helpcontent2 from branch 'master' to bed48919e5708e6c131c6b9b49c9411da0abe177 - Fix link to Styles menu Thanks to J. Nabet. Change-Id: Ic3c3fa8d3b357b15e9fdab041230e142958f51fa Reviewed-on: https://gerrit.libreoffice.org/c/help/+/165086 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index 41a513b0355e..bed48919e570 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 41a513b0355e7af1c2cde0ae95cc6fc7c23d0526 +Subproject commit bed48919e5708e6c131c6b9b49c9411da0abe177
help.git: source/auxiliary source/text
source/auxiliary/swriter.tree |2 +- source/text/shared/01/StyleUpdateByExample.xhp |2 +- source/text/swriter/01/EditStyle.xhp |2 +- 3 files changed, 3 insertions(+), 3 deletions(-) New commits: commit bed48919e5708e6c131c6b9b49c9411da0abe177 Author: Olivier Hallot AuthorDate: Wed Mar 20 20:18:01 2024 -0300 Commit: Olivier Hallot CommitDate: Thu Mar 21 12:42:32 2024 +0100 Fix link to Styles menu Thanks to J. Nabet. Change-Id: Ic3c3fa8d3b357b15e9fdab041230e142958f51fa Reviewed-on: https://gerrit.libreoffice.org/c/help/+/165086 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/source/auxiliary/swriter.tree b/source/auxiliary/swriter.tree index dbc6c616b5..bbe836d865 100644 --- a/source/auxiliary/swriter.tree +++ b/source/auxiliary/swriter.tree @@ -35,7 +35,7 @@ View Insert Format -Styles +Styles Table Form Tools diff --git a/source/text/shared/01/StyleUpdateByExample.xhp b/source/text/shared/01/StyleUpdateByExample.xhp index 44f9b11641..fbd625b52e 100644 --- a/source/text/shared/01/StyleUpdateByExample.xhp +++ b/source/text/shared/01/StyleUpdateByExample.xhp @@ -43,7 +43,7 @@ The manually formatted attributes of the text at the cursor position in the document will be added to the style that is selected in the Styles window. -Styles menu +Styles menu diff --git a/source/text/swriter/01/EditStyle.xhp b/source/text/swriter/01/EditStyle.xhp index 7609b279d7..d0149fe18e 100644 --- a/source/text/swriter/01/EditStyle.xhp +++ b/source/text/swriter/01/EditStyle.xhp @@ -64,7 +64,7 @@ -Styles menu +Styles menu
core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 2a3dfd61e32287722d6e3d36b1133aadef3645a4 Author: Olivier Hallot AuthorDate: Wed Mar 6 17:08:13 2024 +0100 Commit: Gerrit Code Review CommitDate: Wed Mar 6 17:08:13 2024 +0100 Update git submodules * Update helpcontent2 from branch 'master' to d2beb0a61359f458b5b909fba1dd3452a1d2920d - Fix error in string for TOOLS BASIC library Change-Id: Iaedecb8ab3b65df5be98aea9004f003549ede0fc Reviewed-on: https://gerrit.libreoffice.org/c/help/+/164490 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index 3eac551bbc02..d2beb0a61359 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 3eac551bbc02c2b4418b7a86eaa4f265d6854ee9 +Subproject commit d2beb0a61359f458b5b909fba1dd3452a1d2920d
help.git: source/text
source/text/sbasic/shared/03/lib_tools.xhp |3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) New commits: commit d2beb0a61359f458b5b909fba1dd3452a1d2920d Author: Olivier Hallot AuthorDate: Wed Mar 6 17:03:56 2024 +0100 Commit: Olivier Hallot CommitDate: Wed Mar 6 17:08:13 2024 +0100 Fix error in string for TOOLS BASIC library Change-Id: Iaedecb8ab3b65df5be98aea9004f003549ede0fc Reviewed-on: https://gerrit.libreoffice.org/c/help/+/164490 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/source/text/sbasic/shared/03/lib_tools.xhp b/source/text/sbasic/shared/03/lib_tools.xhp index 6ce490a599..0c1c3916fe 100644 --- a/source/text/sbasic/shared/03/lib_tools.xhp +++ b/source/text/sbasic/shared/03/lib_tools.xhp @@ -664,8 +664,7 @@ SearchValue, SearchIndex as Integer) as Integer -GetIndexForPartString_ -inMultiArray +GetIndexForPartStringinMultiArray ' Searches for a Value in multidimensial Array by querying all Searchindices of the passed dimension ' and delivers the Index where the Searchvalue is found as a part string
dev-tools.git: userguides/sanitycheck
userguides/sanitycheck/Addons.xcu | 304 userguides/sanitycheck/META-INF/manifest.xml| 16 userguides/sanitycheck/Makefile | 15 userguides/sanitycheck/Office/UI/BaseWindowState.xcu| 17 userguides/sanitycheck/Office/UI/BasicIDEWindowState.xcu| 17 userguides/sanitycheck/Office/UI/CalcWindowState.xcu| 17 userguides/sanitycheck/Office/UI/DrawWindowState.xcu| 17 userguides/sanitycheck/Office/UI/ImpressWindowState.xcu | 17 userguides/sanitycheck/Office/UI/MathWindowState.xcu| 17 userguides/sanitycheck/Office/UI/StartModuleWindowState.xcu | 17 userguides/sanitycheck/Office/UI/WriterWindowState.xcu | 17 userguides/sanitycheck/README | 11 userguides/sanitycheck/SanityCheck/Campos.xba | 188 ++ userguides/sanitycheck/SanityCheck/Comunes.xba | 322 userguides/sanitycheck/SanityCheck/DlgAsistente.xdl | 55 userguides/sanitycheck/SanityCheck/DlgCampos.xdl| 63 userguides/sanitycheck/SanityCheck/DlgEstilos.xdl | 40 userguides/sanitycheck/SanityCheck/DlgFormatos.xdl | 26 userguides/sanitycheck/SanityCheck/DlgImagenes.xdl | 69 + userguides/sanitycheck/SanityCheck/DlgRenombrar.xdl | 28 userguides/sanitycheck/SanityCheck/DlgResaltes.xdl | 33 userguides/sanitycheck/SanityCheck/DlgTablas.xdl| 40 userguides/sanitycheck/SanityCheck/Estilos.xba | 454 +++ userguides/sanitycheck/SanityCheck/Formatos.xba | 309 userguides/sanitycheck/SanityCheck/Imagenes.xba | 550 userguides/sanitycheck/SanityCheck/L10n.xba | 778 userguides/sanitycheck/SanityCheck/Renombrar.xba| 175 ++ userguides/sanitycheck/SanityCheck/Resaltes.xba | 677 ++ userguides/sanitycheck/SanityCheck/Tablas.xba | 273 userguides/sanitycheck/SanityCheck/dialog.xlb | 12 userguides/sanitycheck/SanityCheck/script.xlb | 13 userguides/sanitycheck/description.xml | 21 userguides/sanitycheck/dist/Sanitycheck-1.0.0.oxt |binary userguides/sanitycheck/icons/Image14_16.bmp |binary userguides/sanitycheck/icons/Image14_26.bmp |binary userguides/sanitycheck/icons/image11_16.bmp |binary userguides/sanitycheck/icons/image11_26.bmp |binary userguides/sanitycheck/icons/image12_16.bmp |binary userguides/sanitycheck/icons/image12_26.bmp |binary userguides/sanitycheck/icons/image13_16.bmp |binary userguides/sanitycheck/icons/image13_26.bmp |binary userguides/sanitycheck/icons/image1_16.bmp |binary userguides/sanitycheck/icons/image1_26.bmp |binary userguides/sanitycheck/icons/image2_16.bmp |binary userguides/sanitycheck/icons/image2_26.bmp |binary userguides/sanitycheck/icons/image4_16.bmp |binary userguides/sanitycheck/icons/image4_26.bmp |binary userguides/sanitycheck/icons/image5_16.bmp |binary userguides/sanitycheck/icons/image5_26.bmp |binary userguides/sanitycheck/icons/image7_16.bmp |binary userguides/sanitycheck/icons/image7_26.bmp |binary userguides/sanitycheck/icons/image8_16.bmp |binary userguides/sanitycheck/icons/image8_26.bmp |binary userguides/sanitycheck/icons/image9_16.bmp |binary userguides/sanitycheck/icons/image9_26.bmp |binary userguides/sanitycheck/pkg-desc/pkg-description.es |4 userguides/sanitycheck/pkg-desc/pkg-description.pt |4 userguides/sanitycheck/pkg-desc/pkg-description.txt |5 userguides/sanitycheck/registration/LGPLv3.0.txt| 165 ++ userguides/sanitycheck/registration/LGPLv3_es.txt | 635 + userguides/sanitycheck/registration/LGPLv3_pt-br.txt| 167 ++ 61 files changed, 5588 insertions(+) New commits: commit de15ef3b10a2ac49322a363e855a4ef63b45be02 Author: Olivier Hallot AuthorDate: Tue Mar 5 09:28:47 2024 -0300 Commit: Olivier Hallot CommitDate: Tue Mar 5 13:34:36 2024 +0100 Add User Guides sanity check scripts This extension runs several scripts in chapter of the user guides to check compliance with documentation team best practices and chapter template for the current edition. Change-Id: I006ab1ffb193ae32324c204a7423b1c4d765dcdf Reviewed-on: https://gerrit.libreoffice.org/c/dev-tools/+/164421 Tested-by: Olivier Hallot Reviewed-by: Olivier Hallot diff --git a/userguides/sanitycheck/Addons.xcu b
core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit e939685f9c6918830bd3097062790bfccbce937e Author: Olivier Hallot AuthorDate: Sun Mar 3 20:26:32 2024 -0300 Commit: Gerrit Code Review CommitDate: Mon Mar 4 00:26:32 2024 +0100 Update git submodules * Update helpcontent2 from branch 'master' to 0fb58194a0658fe83ca170a9cb8adf72371c8c3e - tdf#159872 Help page for FILTER function. Change-Id: Ie0cb1513500a1660688687fe8ac3e4b569b345a9 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/164320 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index ef6f34550555..0fb58194a065 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit ef6f345505552524570d22387543bf45ffa4f8f4 +Subproject commit 0fb58194a0658fe83ca170a9cb8adf72371c8c3e
help.git: source/text
source/text/scalc/01/func_filter.xhp | 12 +---
1 file changed, 9 insertions(+), 3 deletions(-)
New commits:
commit 0fb58194a0658fe83ca170a9cb8adf72371c8c3e
Author: Olivier Hallot
AuthorDate: Sun Mar 3 20:23:10 2024 -0300
Commit: Olivier Hallot
CommitDate: Mon Mar 4 00:26:32 2024 +0100
tdf#159872 Help page for FILTER function.
Change-Id: Ie0cb1513500a1660688687fe8ac3e4b569b345a9
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/164320
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 7e9e7a69e8..b1e1d53a34 100644
--- a/source/text/scalc/01/func_filter.xhp
+++ b/source/text/scalc/01/func_filter.xhp
@@ -18,15 +18,21 @@
-FILTER function
+FILTER function
FILTER
-(...)
+Filters a data
range or array based on conditions you specify.
-FILTER(...)
+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).
+
+{=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.
help.git: AllLangPackage_html_media_lang.mk Package_html_media.mk source/media source/text
/statistics_exposmooth.xhp |4 ++- source/text/scalc/01/statistics_movingavg.xhp|1 source/text/scalc/01/statistics_sampling.xhp |1 source/text/scalc/01/statistics_test_chisqr.xhp |1 source/text/scalc/01/statistics_test_f.xhp |5 +++- source/text/scalc/01/statistics_test_t.xhp |5 +++- source/text/scalc/01/statistics_test_z.xhp |5 +++- source/text/scalc/06/calcsamplefiles.xhp | 18 +-- 83 files changed, 37 insertions(+), 13 deletions(-) New commits: commit ef6f345505552524570d22387543bf45ffa4f8f4 Author: Olivier Hallot AuthorDate: Sun Mar 3 19:35:19 2024 -0300 Commit: Olivier Hallot CommitDate: Mon Mar 4 00:25:51 2024 +0100 Add sample file for Calc Data Statistics Change-Id: Ie417559a6c1c5f65381428a58a84d41dc7a47d1d Reviewed-on: https://gerrit.libreoffice.org/c/help/+/164319 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/AllLangPackage_html_media_lang.mk b/AllLangPackage_html_media_lang.mk index a47d2f0059..cbc5c4c08f 100644 --- a/AllLangPackage_html_media_lang.mk +++ b/AllLangPackage_html_media_lang.mk @@ -293,5 +293,6 @@ $(foreach lang,$(filter-out en-US,$(gb_HELP_LANGS)),$(eval $(call gb_AllLangPack files/scalc/$(lang)/functions_ifs.ods \ files/scalc/$(lang)/function_fourier.ods \ files/scalc/$(lang)/conditionalformatting.ods \ +files/scalc/$(lang)/statistics_data.ods \ ))) # vim: set noet sw=4 ts=4: diff --git a/Package_html_media.mk b/Package_html_media.mk index 70575875e2..ed10952193 100644 --- a/Package_html_media.mk +++ b/Package_html_media.mk @@ -21,6 +21,7 @@ $(eval $(call gb_Package_add_files_with_dir,helpcontent2_html_media,$(LIBO_SHARE files/scalc/trigon.ods \ files/scalc/functions_ifs.ods \ files/scalc/conditionalformatting.ods \ +files/scalc/statistics_data.ods \ helpimg/area1.png \ helpimg/area2.png \ helpimg/border_ca_1.png \ diff --git a/source/media/files/scalc/am/statistics_data.ods b/source/media/files/scalc/am/statistics_data.ods new file mode 100644 index 00..c115130827 Binary files /dev/null and b/source/media/files/scalc/am/statistics_data.ods differ diff --git a/source/media/files/scalc/ar/statistics_data.ods b/source/media/files/scalc/ar/statistics_data.ods new file mode 100644 index 00..c115130827 Binary files /dev/null and b/source/media/files/scalc/ar/statistics_data.ods differ diff --git a/source/media/files/scalc/ast/statistics_data.ods b/source/media/files/scalc/ast/statistics_data.ods new file mode 100644 index 00..c115130827 Binary files /dev/null and b/source/media/files/scalc/ast/statistics_data.ods differ diff --git a/source/media/files/scalc/bg/statistics_data.ods b/source/media/files/scalc/bg/statistics_data.ods new file mode 100644 index 00..c115130827 Binary files /dev/null and b/source/media/files/scalc/bg/statistics_data.ods differ diff --git a/source/media/files/scalc/bn-IN/statistics_data.ods b/source/media/files/scalc/bn-IN/statistics_data.ods new file mode 100644 index 00..c115130827 Binary files /dev/null and b/source/media/files/scalc/bn-IN/statistics_data.ods differ diff --git a/source/media/files/scalc/bn/statistics_data.ods b/source/media/files/scalc/bn/statistics_data.ods new file mode 100644 index 00..c115130827 Binary files /dev/null and b/source/media/files/scalc/bn/statistics_data.ods differ diff --git a/source/media/files/scalc/bo/statistics_data.ods b/source/media/files/scalc/bo/statistics_data.ods new file mode 100644 index 00..c115130827 Binary files /dev/null and b/source/media/files/scalc/bo/statistics_data.ods differ diff --git a/source/media/files/scalc/bs/statistics_data.ods b/source/media/files/scalc/bs/statistics_data.ods new file mode 100644 index 00..c115130827 Binary files /dev/null and b/source/media/files/scalc/bs/statistics_data.ods differ diff --git a/source/media/files/scalc/ca-valencia/statistics_data.ods b/source/media/files/scalc/ca-valencia/statistics_data.ods new file mode 100644 index 00..c115130827 Binary files /dev/null and b/source/media/files/scalc/ca-valencia/statistics_data.ods differ diff --git a/source/media/files/scalc/ca/statistics_data.ods b/source/media/files/scalc/ca/statistics_data.ods new file mode 100644 index 00..c115130827 Binary files /dev/null and b/source/media/files/scalc/ca/statistics_data.ods differ diff --git a/source/media/files/scalc/cs/statistics_data.ods b/source/media/files/scalc/cs/statistics_data.ods new file mode 100644 index 00..c115130827 Binary files /dev/null and b/source/media/files/scalc/cs/statistics_data.ods differ diff --git a/source/media/files/scalc/da/statistics_data.ods b/source/media/files/scalc/da/statistics_data.ods new file mode 100644 index 00..c115130827 Binary files /dev/null and b/source/media/files/scalc/da
core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit dc33fe966f10a8e12af0b862ca15f8a96a5c82a4 Author: Olivier Hallot AuthorDate: Sun Mar 3 20:25:52 2024 -0300 Commit: Gerrit Code Review CommitDate: Mon Mar 4 00:25:52 2024 +0100 Update git submodules * Update helpcontent2 from branch 'master' to ef6f345505552524570d22387543bf45ffa4f8f4 - Add sample file for Calc Data Statistics Change-Id: Ie417559a6c1c5f65381428a58a84d41dc7a47d1d Reviewed-on: https://gerrit.libreoffice.org/c/help/+/164319 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index 7c608b996929..ef6f34550555 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 7c608b996929e60592570bf750ea826e11bc3b4a +Subproject commit ef6f345505552524570d22387543bf45ffa4f8f4
help.git: source/text
source/text/scalc/01/statistics_covariance.xhp |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 7c608b996929e60592570bf750ea826e11bc3b4a Author: Olivier Hallot AuthorDate: Sun Mar 3 17:11:05 2024 -0300 Commit: Olivier Hallot CommitDate: Mon Mar 4 00:25:20 2024 +0100 Wrong value in example for covariance Change-Id: I8302054d8bc700fcc608e63c48dd13a19e03832d Reviewed-on: https://gerrit.libreoffice.org/c/help/+/164318 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/source/text/scalc/01/statistics_covariance.xhp b/source/text/scalc/01/statistics_covariance.xhp index 965c5ae345..9690994add 100644 --- a/source/text/scalc/01/statistics_covariance.xhp +++ b/source/text/scalc/01/statistics_covariance.xhp @@ -57,7 +57,7 @@ Column 1 -126.8099173554 +111.65
core.git: 2 commits - helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit a3a3a477a49c57da4de56a1593266a113ae741b2 Author: Olivier Hallot AuthorDate: Sun Mar 3 20:25:20 2024 -0300 Commit: Gerrit Code Review CommitDate: Mon Mar 4 00:25:20 2024 +0100 Update git submodules * Update helpcontent2 from branch 'master' to 7c608b996929e60592570bf750ea826e11bc3b4a - Wrong value in example for covariance Change-Id: I8302054d8bc700fcc608e63c48dd13a19e03832d Reviewed-on: https://gerrit.libreoffice.org/c/help/+/164318 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index efdfc42180b5..7c608b996929 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit efdfc42180b536865804f5006780061fdf268301 +Subproject commit 7c608b996929e60592570bf750ea826e11bc3b4a commit 8fd4605585653f54845f7488910df18a4cc89df6 Author: Olivier Hallot AuthorDate: Sun Mar 3 20:25:04 2024 -0300 Commit: Gerrit Code Review CommitDate: Mon Mar 4 00:25:04 2024 +0100 Update git submodules * Update helpcontent2 from branch 'master' to efdfc42180b536865804f5006780061fdf268301 - Housekeeping - no content change Change-Id: Ib5fc96e82870b94315f72de2ecacd85810698d89 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/164317 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index 53a1f8fb85cd..efdfc42180b5 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 53a1f8fb85cd85d38fbc3878bcdeb5452306c379 +Subproject commit efdfc42180b536865804f5006780061fdf268301
help.git: source/text
source/text/scalc/01/ful_func.xhp |8 source/text/scalc/01/stat_data.xhp | 352 ++--- 2 files changed, 180 insertions(+), 180 deletions(-) New commits: commit efdfc42180b536865804f5006780061fdf268301 Author: Olivier Hallot AuthorDate: Sun Mar 3 09:18:03 2024 -0300 Commit: Olivier Hallot CommitDate: Mon Mar 4 00:25:04 2024 +0100 Housekeeping - no content change Change-Id: Ib5fc96e82870b94315f72de2ecacd85810698d89 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/164317 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/source/text/scalc/01/ful_func.xhp b/source/text/scalc/01/ful_func.xhp index 846b8a5db4..1681a65bc6 100644 --- a/source/text/scalc/01/ful_func.xhp +++ b/source/text/scalc/01/ful_func.xhp @@ -8,8 +8,8 @@ * file, You can obtain one at http://mozilla.org/MPL/2.0/. --> - -Frequently Used Lexemes + +Frequently Used Lexemes /text/scalc/01/ful_func.xhp @@ -54,11 +54,11 @@ Other paragraphs - + The imaginary part is equal to zero, so it is not displayed in the result. -The result is presented in the string format and has the character "i" or "j" as an imaginary unit. +The result is presented in the string format and has the character "i" or "j" as an imaginary unit. 255 arguments diff --git a/source/text/scalc/01/stat_data.xhp b/source/text/scalc/01/stat_data.xhp index 7556d0d104..3d8a5baf55 100644 --- a/source/text/scalc/01/stat_data.xhp +++ b/source/text/scalc/01/stat_data.xhp @@ -9,8 +9,8 @@ --> - -Data + +Data /text/scalc/01/stat_data.xhp @@ -19,13 +19,13 @@ Data -Input Range: The reference of the range of the data to analyze. -Results to: The reference of the top left cell of the range where the results will be displayed. +Input Range: The reference of the range of the data to analyze. +Results to: The reference of the top left cell of the range where the results will be displayed. Grouped By -Select whether the input data has columns or rows layout. +Select whether the input data has columns or rows layout. @@ -47,181 +47,181 @@ -The following data will be used as example +The following data will be used as example -A +A -B +B -C +C -1 +1 -Maths +Maths -Physics +Physics -Biology +Biology -2 +2 -47 +47 -67 +67 -33 +33 -3 +3 -36 +36 -68 +68 -42 +42 -4 +4 -40 +40 -65 +65 -44 +44 -5 +5 -39 +39 -64 +64 -60 +60 -6 +6 -38 +38 -43 +43
Re: Help on toolbars
Hi Regina Thank you for looking at. On 2/29/24 14:57, Regina Henschel wrote: Hi Olivier, I have tested what happens, when you go to an icon in the toolbar via F6 and then tabs. When you are on an icon and then press F1, the help system gets e.g. .HelpId:textobjectbar or .HelpId:standardbar. But there exists no corresponding page and a 404 is shown. Kind regards, Regina So this is a half-way solution. Something is sent, but no specific target. I also tried the other UIs. If we set the notebook bar active, then F1 on a icon sends another bookmark based on the notebookbar.ui internals. For example, pressing F1 on Copy command in Home tab of the Calc module sends this bookmark: "modules/scalc/ui/notebookbar/LineB7" So, nothing related mnemonically to .uno:Copy. You can imagine how hard it will be to map all these bookmarks to the proper Help page. An automatic approach seems needed: For a given uno command, what toolbar/menu/shortcut/UI/ has it. Kind regards -- Olivier Hallot LibreOffice Documentation Coordinator Rio de Janeiro - Brasil - Local Time: UTC-03:00 LibreOffice – free and open source office suite: https://www.libreoffice.org Respects your privacy, and gives you back control over your data http://tdf.io/joinus OpenPGP_0x59F8BA50F9918DE6.asc Description: OpenPGP public key OpenPGP_signature.asc Description: OpenPGP digital signature
core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit da7867bbb98de03768f2212d9219023b6b854805 Author: Olivier Hallot AuthorDate: Sat Mar 2 12:26:16 2024 +0100 Commit: Gerrit Code Review CommitDate: Sat Mar 2 12:26:16 2024 +0100 Update git submodules * Update helpcontent2 from branch 'master' to 53a1f8fb85cd85d38fbc3878bcdeb5452306c379 - Typo Change-Id: Id8bdc2bf463a8ac736387f6ce2ac387c77d25e1f Reviewed-on: https://gerrit.libreoffice.org/c/help/+/164270 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index 0b58cd7c6b04..53a1f8fb85cd 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 0b58cd7c6b04583935d6a25f28ec514c1e6424ba +Subproject commit 53a1f8fb85cd85d38fbc3878bcdeb5452306c379
help.git: source/text
source/text/sdraw/01/TextAutoFitToSize.xhp |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 53a1f8fb85cd85d38fbc3878bcdeb5452306c379 Author: Olivier Hallot AuthorDate: Sat Mar 2 12:06:36 2024 +0100 Commit: Olivier Hallot CommitDate: Sat Mar 2 12:26:15 2024 +0100 Typo Change-Id: Id8bdc2bf463a8ac736387f6ce2ac387c77d25e1f Reviewed-on: https://gerrit.libreoffice.org/c/help/+/164270 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/source/text/sdraw/01/TextAutoFitToSize.xhp b/source/text/sdraw/01/TextAutoFitToSize.xhp index bda5e0149f..3111f4d224 100644 --- a/source/text/sdraw/01/TextAutoFitToSize.xhp +++ b/source/text/sdraw/01/TextAutoFitToSize.xhp @@ -19,7 +19,7 @@ shrink font;in text box -reduce font;to fit box box +reduce font;to fit box Shrink Text on Overflow
core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 14ca02e58ede263e3cfafd172e164b7fc27dda45 Author: Olivier Hallot AuthorDate: Fri Mar 1 20:05:28 2024 -0300 Commit: Gerrit Code Review CommitDate: Sat Mar 2 00:05:28 2024 +0100 Update git submodules * Update helpcontent2 from branch 'master' to 714426188f79633f1f6e4f180c13aafda4fa4a4b - tdf#94535 Corresponding Help page Change-Id: Ic73d515a570fb0a8ae9e03f9d732c733715d71e3 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/164230 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index acb79818f17b..714426188f79 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit acb79818f17b823827ff39871ea53ae3be0a9f1d +Subproject commit 714426188f79633f1f6e4f180c13aafda4fa4a4b
help.git: source/text
source/text/shared/01/0528.xhp | 255 - 1 file changed, 143 insertions(+), 112 deletions(-) New commits: commit 714426188f79633f1f6e4f180c13aafda4fa4a4b Author: Olivier Hallot AuthorDate: Fri Mar 1 16:17:29 2024 -0300 Commit: Olivier Hallot CommitDate: Sat Mar 2 00:05:27 2024 +0100 tdf#94535 Corresponding Help page Change-Id: Ic73d515a570fb0a8ae9e03f9d732c733715d71e3 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/164230 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/source/text/shared/01/0528.xhp b/source/text/shared/01/0528.xhp index 8ecaf36822..ab461ec097 100644 --- a/source/text/shared/01/0528.xhp +++ b/source/text/shared/01/0528.xhp @@ -19,7 +19,7 @@ -Fontwork +Text along Path /text/shared/01/0528.xhp @@ -28,300 +28,331 @@ - - - -Fontwork Dialog (for putting text along a curve) -Simple tool for putting text along a curve without any fancy effects.UFI: see "Fontwork_ui" spec doc. - -This Fontwork dialog is meant for making text follow a curve. Draw a curve, double-click it and type text into it. With the curve selected, you can now activate the Fontwork command. Access the dialog by choosing Format - Text Box and Shape - FontworkFirst call Tools - Customize to add a menu command or a toolbar button to open the dialog. The Fontwork command is found in the Format category of the Customize dialog. + + + +Text along Path +Simple tool for putting text along a curve without any fancy effects.UFI: see "Fontwork_ui" spec doc. + + + + +Choose Format - Text Box and Shape - Text along Path + + + + +Choose Format - Text along Path. + +Choose Text along Path. + + + +Choose Format - Text along Path. + +Choose Text along Path. + + + + + + +Icon Text along Path + + +Text along Path + + + + +This Text along Path dialog is meant for making text follow a curve. Draw a curve, double-click it and type text into it. With the curve selected, you can now activate the Text along Path command. -Alignment icons -You can make text follow any shape. Most of the custom shapes available in the Drawing toolbar need to be converted to a different type before you can use them with Fontwork. In Impress or Draw, right-click the shape and select Convert - To Curve/Polygon/Contour. If you wish, you can now copy and paste the converted shape into Writer for use with Fontwork. Shapes in the Legacy Circles and Ovals and Legacy Rectangles toolbars do not need to be converted. The Arc included in the basic shapes is also a legacy shape. +Style +You can make text follow any shape. Most of the custom shapes available in the Drawing toolbar need to be converted to a different type before you can use them with Text along Path. In Impress or Draw, right-click the shape and select Convert - To Curve/Polygon/Contour. If you wish, you can now copy and paste the converted shape into Writer for use with Text along Path. Shapes in the Legacy Circles and Ovals and Legacy Rectangles toolbars do not need to be converted. The Arc included in the basic shapes is also a legacy shape. - + Baseline Off -Removes baseline formatting. +Removes baseline formatting. - -Icon Off + +Icon Off -Baseline Off +Baseline Off - + Rotate -Uses the top or the bottom edge of the selected object as the text baseline. +Uses the top or the bottom edge of the selected object as the text baseline. - -Icon + +Icon -Rotate +Rotate - + Upright -Uses the top or the bottom edge of the selected object as the text baseline and preserves the original vertical alignment of the individual characters. +Uses the top or the bottom edge of the selected object as the text baseline and preserves the original vertical alignment of the individual characters. - -Icon Upright + +Icon Upright -Upright +Upright - + Slant Horizontal -Horizontally slants the characters in the text object. +Horizontally slants the characters in the text object. - -Icon Slant Horizontal + +Icon Slant Horizontal -Slant Horizontal +Slant Horizontal - + Slant Vertical -Vertically slants the characters in the text object. +Vertically slants the characters in the text object. - -Icon Slant Vertical + +Icon Slant Vertical -Slant Vertical +Slant Vertical - - +Adjust + Orientation -Reverses the text flow direction, and flips the text horizontally or vertically. To use this command, you must first apply a different baseline to the text. +Reverses the text flow direction, and flips the text horizontally or vertically. To use this command, y
core.git: svx/uiconfig
svx/uiconfig/ui/dockingfontwork.ui | 959 - 1 file changed, 541 insertions(+), 418 deletions(-) New commits: commit 4ed91fc7214b08112bc73844db3bdaab69f73564 Author: Olivier Hallot AuthorDate: Sun Jan 14 16:31:41 2024 -0300 Commit: Olivier Hallot CommitDate: Fri Mar 1 12:43:44 2024 +0100 tdf#94535 Improvements in Text along Path dialog Added labels to indicate the purpose of the toolbars. The dialog needs Close and Help buttons and will be considered later. Change-Id: I1926c05ebc386877007163bdea0809efe0442103 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/162056 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/svx/uiconfig/ui/dockingfontwork.ui b/svx/uiconfig/ui/dockingfontwork.ui index 797bf9527036..a70b72a15b6c 100644 --- a/svx/uiconfig/ui/dockingfontwork.ui +++ b/svx/uiconfig/ui/dockingfontwork.ui @@ -1,5 +1,5 @@ - + @@ -31,115 +31,139 @@ False vertical - - + + True False 12 - + True -True -False +False +0 +none - + True -Baseline Off -True -svx/res/fw01.png -True - - -Removes baseline formatting. +True +6 +False + + +True +False +Baseline Off +True +svx/res/fw01.png +True + + +Removes baseline formatting. + + + +False +True + - - -False -True - - - - -True -False - - -False -True - - - - -True -Rotate -True -svx/res/fw02.png -off - - -Uses the top or the bottom edge of the selected object as the text baseline. + + +True +False + +False +True + - - -False -True - - - - -True -Upright -True -svx/res/fw03.png -off - - -Uses the top or the bottom edge of the selected object as the text baseline and preserves the original vertical alignment of the individual characters. + + +True +False +Rotate +True +svx/res/fw02.png +off + + +Uses the top or the bottom edge of the selected object as the text baseline. + + + +False +True + - - -False -True - - - - -True -Slant Horizontal -True -svx/res/fw04.png -off - - -Horizontally slants the characters in the text object. + + +True +False +Upright +True +svx/res/fw03.png +off + + +Uses the top or the bottom edge of the selected object as the text baseline and preserves the original vertical alignment of the individual characters. + + + + +False +True + + + + +True +False +Slant Horizontal
core.git: include/svx officecfg/registry sd/uiconfig
include/svx/strings.hrc |2 +-
officecfg/registry/data/org/openoffice/Office/UI/GenericCommands.xcu |2 +-
sd/uiconfig/sdraw/menubar/menubar.xml|1 +
sd/uiconfig/sdraw/popupmenu/curve.xml|1 +
sd/uiconfig/simpress/menubar/menubar.xml |1 +
sd/uiconfig/simpress/popupmenu/curve.xml |1 +
6 files changed, 6 insertions(+), 2 deletions(-)
New commits:
commit 716c1c3c973f2b171efb8eca31498a29364b4548
Author: Olivier Hallot
AuthorDate: Sun Jan 14 12:07:12 2024 -0300
Commit: Olivier Hallot
CommitDate: Fri Mar 1 11:49:46 2024 +0100
tdf#94535 Change "Fontwork" to "Text along Path"
+ Applied to Draw and Impress format menu
+ Applied to Curve context menu
+ Connected to tdf#118336 Help page.
Change-Id: Ibb5d2edf7f5baccf49852b62008aed1c89409f45
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/162047
Tested-by: Jenkins
Reviewed-by: Heiko Tietze
diff --git a/include/svx/strings.hrc b/include/svx/strings.hrc
index 3813f9dfceca..f26dbe3bd558 100644
--- a/include/svx/strings.hrc
+++ b/include/svx/strings.hrc
@@ -1801,7 +1801,7 @@
#define RID_SVXSTR_PAGEDIR_LTR_VERT
NC_("RID_SVXSTR_PAGEDIR_LTR_VERT", "Left-to-right (vertical)")
#define RID_SVXSTR_PAGEDIR_LTR_BTT_VERT
NC_("RID_SVXSTR_PAGEDIR_LTR_BTT_VERT", "Bottom-to-top, left-to-right
(vertical)")
-#define RID_SVXSTR_FONTWORK
NC_("RID_SVXSTR_FONTWORK", "Fontwork")
+#define RID_SVXSTR_FONTWORK
NC_("RID_SVXSTR_FONTWORK", "Text along Path...")
#define RID_SVXSTR_SIGNATURELINE_DSIGNED_BY
NC_("RID_SVXSTR_SIGNATURELINE_DSIGNED_BY", "Digitally signed by:")
#define RID_SVXSTR_SIGNATURELINE_DATE
NC_("RID_SVXSTR_SIGNATURELINE_DATE", "Date: %1")
diff --git
a/officecfg/registry/data/org/openoffice/Office/UI/GenericCommands.xcu
b/officecfg/registry/data/org/openoffice/Office/UI/GenericCommands.xcu
index 6da4532d2687..5b438e01ffe1 100644
--- a/officecfg/registry/data/org/openoffice/Office/UI/GenericCommands.xcu
+++ b/officecfg/registry/data/org/openoffice/Office/UI/GenericCommands.xcu
@@ -3934,7 +3934,7 @@ bit 3 (0x8): #define
UICOMMANDDESCRIPTION_PROPERTIES_TOGGLEBUTTON 8
- F~ontwork
+ Text along Path
1
diff --git a/sd/uiconfig/sdraw/menubar/menubar.xml
b/sd/uiconfig/sdraw/menubar/menubar.xml
index b1058bbda973..1865877146e3 100644
--- a/sd/uiconfig/sdraw/menubar/menubar.xml
+++ b/sd/uiconfig/sdraw/menubar/menubar.xml
@@ -428,6 +428,7 @@
+
diff --git a/sd/uiconfig/sdraw/popupmenu/curve.xml
b/sd/uiconfig/sdraw/popupmenu/curve.xml
index ee57366df1c8..535a9182505f 100644
--- a/sd/uiconfig/sdraw/popupmenu/curve.xml
+++ b/sd/uiconfig/sdraw/popupmenu/curve.xml
@@ -54,6 +54,7 @@
+
diff --git a/sd/uiconfig/simpress/menubar/menubar.xml
b/sd/uiconfig/simpress/menubar/menubar.xml
index 1ee7c7011cd5..55480466b9dd 100644
--- a/sd/uiconfig/simpress/menubar/menubar.xml
+++ b/sd/uiconfig/simpress/menubar/menubar.xml
@@ -461,6 +461,7 @@
+
diff --git a/sd/uiconfig/simpress/popupmenu/curve.xml
b/sd/uiconfig/simpress/popupmenu/curve.xml
index 3c5db45de302..3d0057f74e61 100644
--- a/sd/uiconfig/simpress/popupmenu/curve.xml
+++ b/sd/uiconfig/simpress/popupmenu/curve.xml
@@ -20,6 +20,7 @@
+
core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 16e66bb1030557552e2d1ad69cbd50af03c81ab1 Author: Olivier Hallot AuthorDate: Mon Feb 26 14:17:01 2024 -0300 Commit: Gerrit Code Review CommitDate: Mon Feb 26 18:17:01 2024 +0100 Update git submodules * Update helpcontent2 from branch 'master' to 51f773f0ed635d026283ec010bbbd973813dbf4b - tdf#156397 (part) Fix bad Help page for Writer-only UNO Commands .uno:ListStyle and .uno:ParaStyle are Writer exclusive and cannot be set as entry for Impress or Calc. Bookmarks removed from wrong pages. Change-Id: I672ec313e42119a9eadc1946e64c127900ad4d01 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/163949 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index 8bab0aaea474..51f773f0ed63 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 8bab0aaea4744d600a33a8c8a1941b114f4d6881 +Subproject commit 51f773f0ed635d026283ec010bbbd973813dbf4b
help.git: source/text
source/text/scalc/01/cell_styles.xhp |3 +-- source/text/simpress/01/0510.xhp |5 + 2 files changed, 2 insertions(+), 6 deletions(-) New commits: commit 51f773f0ed635d026283ec010bbbd973813dbf4b Author: Olivier Hallot AuthorDate: Mon Feb 26 12:22:43 2024 -0300 Commit: Olivier Hallot CommitDate: Mon Feb 26 18:17:01 2024 +0100 tdf#156397 (part) Fix bad Help page for Writer-only UNO Commands .uno:ListStyle and .uno:ParaStyle are Writer exclusive and cannot be set as entry for Impress or Calc. Bookmarks removed from wrong pages. Change-Id: I672ec313e42119a9eadc1946e64c127900ad4d01 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/163949 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/source/text/scalc/01/cell_styles.xhp b/source/text/scalc/01/cell_styles.xhp index 1afbba77f8..a6ee5be680 100644 --- a/source/text/scalc/01/cell_styles.xhp +++ b/source/text/scalc/01/cell_styles.xhp @@ -11,12 +11,11 @@ -Cell Styles +Cell Styles /text/scalc/01/cell_styles.xhp - Cell Styles diff --git a/source/text/simpress/01/0510.xhp b/source/text/simpress/01/0510.xhp index 9b9413dc73..937502c2b7 100644 --- a/source/text/simpress/01/0510.xhp +++ b/source/text/simpress/01/0510.xhp @@ -43,7 +43,6 @@ When you edit a style, the changes are automatically applied to all of the elements formatted with this style in your document. If you want to ensure that the styles on a specific slide are not updated, create a new master slide for the slide. - Presentation Styles Show styles used in %PRODUCTNAME Impress AutoLayouts. You can only modify Presentation Styles. @@ -59,10 +58,8 @@ - - Graphic Styles -Show styles for formatting graphical elements, including text objects. +Show styles for formatting graphical elements, including text objects.
core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit b6adc921fe62cc49312ed679069d5b1d2fb9b83b Author: Olivier Hallot AuthorDate: Mon Feb 26 14:16:27 2024 -0300 Commit: Gerrit Code Review CommitDate: Mon Feb 26 18:16:27 2024 +0100 Update git submodules * Update helpcontent2 from branch 'master' to 8bab0aaea4744d600a33a8c8a1941b114f4d6881 - tdf#154069 Fix HID for New user index Change-Id: I578e2dca1a024dd10fafc88239fed97de5cd1f00 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/163946 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index 62e7c7b640fb..8bab0aaea474 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 62e7c7b640fb3bd3dd11207f3951f6512bea839f +Subproject commit 8bab0aaea4744d600a33a8c8a1941b114f4d6881
