[Libreoffice-commits] core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit c88c22530eb2ef87986a7c3c8f0f21ac16e508fa Author: Steve Fanning AuthorDate: Wed Nov 10 14:22:09 2021 +0200 Commit: Gerrit Code Review CommitDate: Wed Nov 10 13:22:09 2021 +0100 Update git submodules * Update helpcontent2 from branch 'master' to 99120cbfb9b5c0c75bc1b3317fa87ecab58d170a - Update help page for Calc's Mathematical Functions to remove detail about SUM() function. Leave just a link and a one line overview. This is a follow-up to change https://gerrit.libreoffice.org/c/help/+/124696. Change-Id: I31898c9f8d1fc0dca83a7d3fc12d466a3d50928c Reviewed-on: https://gerrit.libreoffice.org/c/help/+/124865 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index 9077a2887221..99120cbfb9b5 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 9077a2887221677690282917c66c7af8e3e37121 +Subproject commit 99120cbfb9b5c0c75bc1b3317fa87ecab58d170a
[Libreoffice-commits] help.git: source/text
source/text/scalc/01/04060106.xhp | 24 +++- 1 file changed, 3 insertions(+), 21 deletions(-) New commits: commit 99120cbfb9b5c0c75bc1b3317fa87ecab58d170a Author: Steve Fanning AuthorDate: Wed Nov 10 13:14:38 2021 +0200 Commit: Olivier Hallot CommitDate: Wed Nov 10 13:22:08 2021 +0100 Update help page for Calc's Mathematical Functions to remove detail about SUM() function. Leave just a link and a one line overview. This is a follow-up to change https://gerrit.libreoffice.org/c/help/+/124696. Change-Id: I31898c9f8d1fc0dca83a7d3fc12d466a3d50928c Reviewed-on: https://gerrit.libreoffice.org/c/help/+/124865 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp index a245b9d28..c04614745 100644 --- a/source/text/scalc/01/04060106.xhp +++ b/source/text/scalc/01/04060106.xhp @@ -1017,27 +1017,9 @@ - - - SUM function - adding;numbers in cell ranges - -mw added one entry - - -SUM -Adds a set of numbers. - - -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. -Refer to the https://wiki.documentfoundation.org/Documentation/Calc_Functions/SUM; name="SUM_Wiki">SUM wiki page for more details about this function. + + +
[Libreoffice-commits] core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit b31e280b3b502ad16ac0ecf2c644a7d040710897 Author: Steve Fanning AuthorDate: Tue Nov 9 16:02:04 2021 +0200 Commit: Gerrit Code Review CommitDate: Tue Nov 9 15:02:04 2021 +0100 Update git submodules * Update helpcontent2 from branch 'master' to 9077a2887221677690282917c66c7af8e3e37121 - Improve Example section of help description for Calc's SUM() function The ability to use SUM in an array formula is important but the help description of an example array formula is uncharacteristically long. Now that the wiki has a more specific example, it is appropriate to shorten the Example section of this help topic. Also moved SUM description to its own XHP file. Change-Id: Ic062686c53a1ae8b81100e2b49781aaa79e6ee50 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/124696 Tested-by: Jenkins Reviewed-by: Eike Rathke Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index 02f148c4a848..9077a2887221 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 02f148c4a8486dcb0ceb2d2d4891a19e132821a0 +Subproject commit 9077a2887221677690282917c66c7af8e3e37121
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk |1
source/text/scalc/01/04060106.xhp | 15 +++
source/text/scalc/01/func_sum.xhp | 48 ++
3 files changed, 54 insertions(+), 10 deletions(-)
New commits:
commit 9077a2887221677690282917c66c7af8e3e37121
Author: Steve Fanning
AuthorDate: Fri Nov 5 12:28:17 2021 +0200
Commit: Olivier Hallot
CommitDate: Tue Nov 9 15:01:58 2021 +0100
Improve Example section of help description for Calc's SUM() function
The ability to use SUM in an array formula is important but the help
description of an example array formula is uncharacteristically long. Now that
the wiki has a more specific example, it is appropriate to shorten the Example
section of this help topic.
Also moved SUM description to its own XHP file.
Change-Id: Ic062686c53a1ae8b81100e2b49781aaa79e6ee50
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/124696
Tested-by: Jenkins
Reviewed-by: Eike Rathke
Reviewed-by: Olivier Hallot
diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index 0bc4bd0cd..617223bfe 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -253,6 +253,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
helpcontent2/source/text/scalc/01/func_second \
helpcontent2/source/text/scalc/01/func_skewp \
helpcontent2/source/text/scalc/01/func_searchb \
+helpcontent2/source/text/scalc/01/func_sum \
helpcontent2/source/text/scalc/01/func_sumifs \
helpcontent2/source/text/scalc/01/func_switch \
helpcontent2/source/text/scalc/01/func_textjoin \
diff --git a/source/text/scalc/01/04060106.xhp
b/source/text/scalc/01/04060106.xhp
index acd376eae..a245b9d28 100644
--- a/source/text/scalc/01/04060106.xhp
+++ b/source/text/scalc/01/04060106.xhp
@@ -1033,16 +1033,11 @@
-If you enter
the numbers 2; 3 and 4 in the Number 1; 2 and 3 text boxes, 9 will be returned
as the result.
-=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.
-Conditions
linked by AND can be used with the function SUM() in the following
manner:
-Example
assumption: You have entered invoices into a table. Column A contains the date
value of the invoice, column B the amounts. You want to find a formula that you
can use to return the total of all amounts only for a specific month, e.g. only
the amount for the period =2008-01-01 to 2008-02-01. The range with the
date values covers A1:A40, the range containing the amounts to be totaled is
B1:B40. C1 contains the start date, 2008-01-01, of
the invoices to be included and C2 the date, 2008-02-01, that is no longer included.
-Enter the
following formula as an array formula:
-=SUM((A1:A40=C1)*(A1:A40C2)*B1:B40)
-In order to
enter this as an array formula, you must press the Shift+Command
-+ Ctrl+ Enter keys
instead of simply pressing the Enter key to close the formula. The formula will
then be shown in the Formula bar enclosed in braces.
-{=SUM((A1:A40=C1)*(A1:A40C2)*B1:B40)}
-The formula is
based on the fact that the result of a comparison is 1 if the criterion is met
and 0 if it is not met. The individual comparison results will be treated as an
array and used in matrix multiplication, and at the end the individual values
will be totaled to give the result matrix.
+=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.
+Refer to the https://wiki.documentfoundation.org/Documentation/Calc_Functions/SUM;
name="SUM_Wiki">SUM wiki page for more details about this function.
diff --git a/source/text/scalc/01/func_sum.xhp
b/source/text/scalc/01/func_sum.xhp
new file mode 100644
index 0..389c0bcc4
--- /dev/null
+++ b/source/text/scalc/01/func_sum.xhp
@@ -0,0 +1,48 @@
+
+
+
+
+
+
+SUM Function
+/text/scalc/01/func_sum.xhp
+
+
+
+
+
+
+ SUM function
+ adding;numbers in cell ranges
+
+SUM
+Adds a set of
numbers.
+
+
+
+ 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
[Libreoffice-commits] core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 04d43efa04f06ed5679ed0ced584c1c008784150 Author: Steve Fanning AuthorDate: Tue Nov 2 09:05:35 2021 +0200 Commit: Gerrit Code Review CommitDate: Tue Nov 2 08:05:35 2021 +0100 Update git submodules * Update helpcontent2 from branch 'master' to 5f532332487c5c57eecb949d0d83fdf2c5f4e7ac - Update help to explain that CONVERT_OOO Change-Id: I6f981b70f98c95cef510a60f4791336446db8648 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/124193 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index 95f006af3ffb..5f532332487c 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 95f006af3ffbe256ebf095db8be2ebd1321e673e +Subproject commit 5f532332487c5c57eecb949d0d83fdf2c5f4e7ac
[Libreoffice-commits] help.git: source/text
source/text/scalc/01/04060106.xhp |7 ---
1 file changed, 4 insertions(+), 3 deletions(-)
New commits:
commit 5f532332487c5c57eecb949d0d83fdf2c5f4e7ac
Author: Steve Fanning
AuthorDate: Tue Oct 26 20:37:57 2021 +0200
Commit: Olivier Hallot
CommitDate: Tue Nov 2 08:05:33 2021 +0100
Update help to explain that CONVERT_OOO
Change-Id: I6f981b70f98c95cef510a60f4791336446db8648
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/124193
Tested-by: Jenkins
Reviewed-by: Olivier Hallot
diff --git a/source/text/scalc/01/04060106.xhp
b/source/text/scalc/01/04060106.xhp
index 389cf9d23..acd376eae 100644
--- a/source/text/scalc/01/04060106.xhp
+++ b/source/text/scalc/01/04060106.xhp
@@ -627,7 +627,7 @@
=TRUNC(1.239;2) returns 1.23. The 9 is lost.
=TRUNC(-1.234999;3) returns -1.234. All the 9s are
lost.see also INT, ROUND, ROUNDDOWN, ROUNDUP, CEILING,
FLOOR, EVEN, ODD, MROUND
-=TRUNC(-45.67) returns -45. The
default value for Count is 0.
+=TRUNC(-45.67) returns -45. The
default value for Count is 0.
Refer to the https://wiki.documentfoundation.org/Documentation/Calc_Functions/TRUNC;
name="TRUNC_Wiki">TRUNC wiki page for more details about this
function.
@@ -763,7 +763,7 @@
M
is the increment to increase N
Coefficients is a series of coefficients. For
each coefficient the series sum is extended by one section.
-=SERIESSUM(A1;
0; 1; {1; 2; 3}) calculates the value of 1+2x+3x2, where x
is the value in cell A1. If A1 contains 1, the formula returns 6; if A1
contains 2, the formula returns 17; if A1 contains 3, the formula returns 34;
and so on.
+=SERIESSUM(A1;
0; 1; {1; 2; 3}) calculates the value of 1+2x+3x2, where x
is the value in cell A1. If A1 contains 1, the formula returns 6; if A1
contains 2, the formula returns 17; if A1 contains 3, the formula returns 34;
and so on.
Refer to the https://wiki.documentfoundation.org/Documentation/Calc_Functions/SERIESSUM;
name="SERIESSUM_Wiki">SERIESSUM wiki page for more details about this
function.
@@ -1396,7 +1396,8 @@
CONVERT_OOO
Converts to euros a currency value expressed in
one of the legacy currencies of 19 member states of the European Union, and
vice versa. The conversion uses the fixed exchange rates at which the
legacy currencies entered the euro.
-We recommend using the more flexible
EUROCONVERT function for converting between these currencies. For converting
between many different units of measure, use the CONVERT function.
+
+We recommend using the more flexible
EUROCONVERT function for converting between these currencies. CONVERT_OOO is
not a standardized function and is not portable.
CONVERT_OOO(Value; "Text1"; "Text2")
[Libreoffice-commits] core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit e1646284ef5a0367c770fa27299db64eedc30cbb Author: Steve Fanning AuthorDate: Wed Oct 27 01:04:41 2021 +0200 Commit: Gerrit Code Review CommitDate: Wed Oct 27 01:04:41 2021 +0200 Update git submodules * Update helpcontent2 from branch 'master' to 7f8b84bbf7fda91426d01bab26b5fa0d148624a1 - Update help description of Calc’s TRUNC function. The help description for Calc’s TRUNC function currently does not indicate that the Count argument is optional. However, the help description for the ROUNDDOWN function does show the Count argument as optional. Since both user functions are implemented via one C++ function (ScRoundDown()), the optionality status of arguments should be the same for both functions. This was checked by confirming that the formulas =ROUNDDOWN(-45.67) and =TRUNC(-45.67) give the same return value (-45). This change updates the optionality status of Count for the TRUNC function and provides the additional example given above. Change-Id: I2078d068b870dd05f4c977a2f9909537ecf7f9ab Reviewed-on: https://gerrit.libreoffice.org/c/help/+/124190 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index c94585cd933b..7f8b84bbf7fd 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit c94585cd933b70a844719985ea63f70928e6d365 +Subproject commit 7f8b84bbf7fda91426d01bab26b5fa0d148624a1
[Libreoffice-commits] help.git: source/text
source/text/scalc/01/04060106.xhp |4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) New commits: commit 7f8b84bbf7fda91426d01bab26b5fa0d148624a1 Author: Steve Fanning AuthorDate: Tue Oct 26 12:23:07 2021 +0200 Commit: Olivier Hallot CommitDate: Wed Oct 27 01:04:38 2021 +0200 Update help description of Calc’s TRUNC function. The help description for Calc’s TRUNC function currently does not indicate that the Count argument is optional. However, the help description for the ROUNDDOWN function does show the Count argument as optional. Since both user functions are implemented via one C++ function (ScRoundDown()), the optionality status of arguments should be the same for both functions. This was checked by confirming that the formulas =ROUNDDOWN(-45.67) and =TRUNC(-45.67) give the same return value (-45). This change updates the optionality status of Count for the TRUNC function and provides the additional example given above. Change-Id: I2078d068b870dd05f4c977a2f9909537ecf7f9ab Reviewed-on: https://gerrit.libreoffice.org/c/help/+/124190 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp index f894aafd8..389cf9d23 100644 --- a/source/text/scalc/01/04060106.xhp +++ b/source/text/scalc/01/04060106.xhp @@ -618,7 +618,7 @@ Truncates a number by removing decimal places. -TRUNC(Number; Count) +TRUNC(Number[; Count]) Returns Number with at most Count decimal places. Excess decimal places are simply removed, irrespective of sign. TRUNC(Number; 0) behaves as INT(Number) for positive numbers, but effectively rounds towards zero for negative numbers. The visible decimal places of the result are specified in %PRODUCTNAME - Preferences @@ -627,6 +627,8 @@ =TRUNC(1.239;2) returns 1.23. The 9 is lost. =TRUNC(-1.234999;3) returns -1.234. All the 9s are lost.see also INT, ROUND, ROUNDDOWN, ROUNDUP, CEILING, FLOOR, EVEN, ODD, MROUND +=TRUNC(-45.67) returns -45. The default value for Count is 0. +Refer to the https://wiki.documentfoundation.org/Documentation/Calc_Functions/TRUNC; name="TRUNC_Wiki">TRUNC wiki page for more details about this function.
[Libreoffice-commits] core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit b94921fb8eecbb784a6711e36f1e5b4b1a6afaf6 Author: Steve Fanning AuthorDate: Tue Oct 26 17:42:44 2021 +0200 Commit: Gerrit Code Review CommitDate: Tue Oct 26 17:42:44 2021 +0200 Update git submodules * Update helpcontent2 from branch 'master' to c94585cd933b70a844719985ea63f70928e6d365 - Add example to help description of Calc's SERIESSUM function. Change-Id: Ie3c95990e2ec75d439405d8fb79d9fde8d852bdd Reviewed-on: https://gerrit.libreoffice.org/c/help/+/124192 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index 18465d2e19be..c94585cd933b 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 18465d2e19be235388020137629ab3ed67f103fb +Subproject commit c94585cd933b70a844719985ea63f70928e6d365
[Libreoffice-commits] help.git: source/text
source/text/scalc/01/04060106.xhp |3 +++
1 file changed, 3 insertions(+)
New commits:
commit c94585cd933b70a844719985ea63f70928e6d365
Author: Steve Fanning
AuthorDate: Tue Oct 26 12:59:51 2021 +0200
Commit: Olivier Hallot
CommitDate: Tue Oct 26 17:42:42 2021 +0200
Add example to help description of Calc's SERIESSUM function.
Change-Id: Ie3c95990e2ec75d439405d8fb79d9fde8d852bdd
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/124192
Tested-by: Jenkins
Reviewed-by: Olivier Hallot
diff --git a/source/text/scalc/01/04060106.xhp
b/source/text/scalc/01/04060106.xhp
index a23f36127..f894aafd8 100644
--- a/source/text/scalc/01/04060106.xhp
+++ b/source/text/scalc/01/04060106.xhp
@@ -760,6 +760,9 @@
N
is the initial power
M
is the increment to increase N
Coefficients is a series of coefficients. For
each coefficient the series sum is extended by one section.
+
+=SERIESSUM(A1;
0; 1; {1; 2; 3}) calculates the value of 1+2x+3x2, where x
is the value in cell A1. If A1 contains 1, the formula returns 6; if A1
contains 2, the formula returns 17; if A1 contains 3, the formula returns 34;
and so on.
+Refer to the https://wiki.documentfoundation.org/Documentation/Calc_Functions/SERIESSUM;
name="SERIESSUM_Wiki">SERIESSUM wiki page for more details about this
function.
[Libreoffice-commits] core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 49b14589e04cd6f3970b2f9c81ff574aa702bf76 Author: Steve Fanning AuthorDate: Fri Oct 1 15:05:29 2021 +0200 Commit: Gerrit Code Review CommitDate: Fri Oct 1 15:05:29 2021 +0200 Update git submodules * Update helpcontent2 from branch 'master' to b81bdbf9511ce46f4556582c0b971e35c509d468 - In CONVERT_OOO help description, add pointer to CONVERT function. Change-Id: I662c6c4dcaaa622b4e9dec1b575cd488300585a6 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/122866 Tested-by: Jenkins Reviewed-by: Eike Rathke diff --git a/helpcontent2 b/helpcontent2 index 0b9b6542a843..b81bdbf9511c 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 0b9b6542a8432d8a7bb3fc8185c0937dff0329bd +Subproject commit b81bdbf9511ce46f4556582c0b971e35c509d468
[Libreoffice-commits] help.git: source/text
source/text/scalc/01/04060106.xhp |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit b81bdbf9511ce46f4556582c0b971e35c509d468 Author: Steve Fanning AuthorDate: Fri Oct 1 14:01:33 2021 +0200 Commit: Eike Rathke CommitDate: Fri Oct 1 15:05:27 2021 +0200 In CONVERT_OOO help description, add pointer to CONVERT function. Change-Id: I662c6c4dcaaa622b4e9dec1b575cd488300585a6 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/122866 Tested-by: Jenkins Reviewed-by: Eike Rathke diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp index 92f62045b..1e37822ac 100644 --- a/source/text/scalc/01/04060106.xhp +++ b/source/text/scalc/01/04060106.xhp @@ -1391,7 +1391,7 @@ CONVERT_OOO Converts to euros a currency value expressed in one of the legacy currencies of 19 member states of the European Union, and vice versa. The conversion uses the fixed exchange rates at which the legacy currencies entered the euro. -We recommend using the more flexible EUROCONVERT function for converting between these currencies. +We recommend using the more flexible EUROCONVERT function for converting between these currencies. For converting between many different units of measure, use the CONVERT funtion. CONVERT_OOO(Value; "Text1"; "Text2")
[Libreoffice-commits] core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit e29689e279442cdcaebea582a008a86861851020 Author: Steve Fanning AuthorDate: Sun Sep 19 18:42:25 2021 +0200 Commit: Gerrit Code Review CommitDate: Sun Sep 19 18:42:25 2021 +0200 Update git submodules * Update helpcontent2 from branch 'master' to 71d1c3403820c00020d9dbe17e065eef9da13a43 - Current help description doesn't really explain what the CONVERT_OOO function does. Change-Id: I92491dc27dbadfd02b326fb01a8230f69d7e564d Reviewed-on: https://gerrit.libreoffice.org/c/help/+/122272 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index 63c0bc5d25f7..71d1c3403820 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 63c0bc5d25f744de978aefa6b8df2fc490738b3e +Subproject commit 71d1c3403820c00020d9dbe17e065eef9da13a43
[Libreoffice-commits] help.git: source/text
source/text/scalc/01/04060106.xhp | 16 +++- 1 file changed, 11 insertions(+), 5 deletions(-) New commits: commit 71d1c3403820c00020d9dbe17e065eef9da13a43 Author: Steve Fanning AuthorDate: Fri Sep 17 19:38:57 2021 +0200 Commit: Olivier Hallot CommitDate: Sun Sep 19 18:42:24 2021 +0200 Current help description doesn't really explain what the CONVERT_OOO function does. Change-Id: I92491dc27dbadfd02b326fb01a8230f69d7e564d Reviewed-on: https://gerrit.libreoffice.org/c/help/+/122272 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp index 5fd12041e..92f62045b 100644 --- a/source/text/scalc/01/04060106.xhp +++ b/source/text/scalc/01/04060106.xhp @@ -1390,15 +1390,21 @@ CONVERT_OOO -Converts a value from one unit of measurement to another unit of measurement. The conversion factors are given in a list in the configuration. -At one time the list of conversion factors included the legacy European currencies and the Euro (see examples below). We suggest using the new function EUROCONVERT for converting these currencies. +Converts to euros a currency value expressed in one of the legacy currencies of 19 member states of the European Union, and vice versa. The conversion uses the fixed exchange rates at which the legacy currencies entered the euro. +We recommend using the more flexible EUROCONVERT function for converting between these currencies. -CONVERT_OOO(value; "text"; "text") +CONVERT_OOO(Value; "Text1"; "Text2") +Value is the amount of the currency to be converted. +Text1 is a three-character string that specifies the currency to be converted from. +Text2 is a three-character string that specifies the currency to be converted to. +Text1 and Text2 must each take one of the following values: "ATS", "BEF", "CYP", "DEM", "EEK", "ESP", "EUR", "FIM", "FRF", "GRD", "IEP", "ITL", "LTL", "LUF", "LVL", "MTL", "NLG", "PTE", "SIT", and "SKK". +One, and only one, of Text1 or Text2 must be equal to "EUR". -=CONVERT_OOO(100;"ATS";"EUR") returns the Euro value of 100 Austrian Schillings. -=CONVERT_OOO(100;"EUR";"DEM") converts 100 Euros into German Marks. +=CONVERT_OOO(100;"ATS";"EUR") returns the euro value of 100 Austrian schillings. +=CONVERT_OOO(100;"EUR";"DEM") converts 100 euros into German marks. +Refer to the https://wiki.documentfoundation.org/Documentation/Calc_Functions/CONVERT_OOO; name="CONVERT_OOO Wiki">CONVERT_OOO wiki page for more details about this function.
[Libreoffice-commits] core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 6657a8714091e5acbff4ebe4ffe3a84269956a2a Author: Steve Fanning AuthorDate: Sat Jul 17 16:39:39 2021 +0200 Commit: Gerrit Code Review CommitDate: Sat Jul 17 16:39:39 2021 +0200 Update git submodules * Update helpcontent2 from branch 'master' to b31f5bed5155ffcda336c3e7a1e18e60a7382228 - Add example to help description of Calc's ROT13 function. Change-Id: I32c654dd8f86f508fce8555f033faa34b81b3e6c Reviewed-on: https://gerrit.libreoffice.org/c/help/+/119038 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index 2271ad00c7e0..b31f5bed5155 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 2271ad00c7e0312071b78706da40a778171bfb9a +Subproject commit b31f5bed5155ffcda336c3e7a1e18e60a7382228 ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: source/text
source/text/scalc/01/04060111.xhp |3 +++
1 file changed, 3 insertions(+)
New commits:
commit b31f5bed5155ffcda336c3e7a1e18e60a7382228
Author: Steve Fanning
AuthorDate: Fri Jul 16 22:59:57 2021 +0200
Commit: Olivier Hallot
CommitDate: Sat Jul 17 16:39:39 2021 +0200
Add example to help description of Calc's ROT13 function.
Change-Id: I32c654dd8f86f508fce8555f033faa34b81b3e6c
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/119038
Tested-by: Jenkins
Reviewed-by: Olivier Hallot
diff --git a/source/text/scalc/01/04060111.xhp
b/source/text/scalc/01/04060111.xhp
index eb282e1c9..398b49b57 100644
--- a/source/text/scalc/01/04060111.xhp
+++ b/source/text/scalc/01/04060111.xhp
@@ -99,6 +99,9 @@
ROT13(Text)
Text is the character string to be encrypted. ROT13(ROT13(Text))
decrypts the code.
+
+=ROT13("Gur
Qbphzrag Sbhaqngvba jnf sbhaqrq va Frcgrzore 2010.") returns the string
"The Document Foundation was founded in September 2010.". Notice how spaces,
digits, and full stops are unaffected by ROT13.
+Refer to the https://wiki.documentfoundation.org/Documentation/Calc_Functions/ROT13;
name="ROT13_Wiki">ROT13 wiki page for more details about this
function.
DAYSINYEAR function
___
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit ce609485630427ed30a8e6e4d3c6d16c4033b519 Author: Steve Fanning AuthorDate: Thu Jul 15 23:06:51 2021 +0200 Commit: Gerrit Code Review CommitDate: Thu Jul 15 23:06:51 2021 +0200 Update git submodules * Update helpcontent2 from branch 'master' to 435e1e0e429e9d743cf11d08cb10f9f25b83e3b3 - Delete erroneous statement from help description of Calc's REPT function. Change-Id: I5958f787798d309a7896ac47e1caa5fbef96 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/118926 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index 11c68842e216..435e1e0e429e 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 11c68842e216735f261fd065750a91ba98b42be1 +Subproject commit 435e1e0e429e9d743cf11d08cb10f9f25b83e3b3 ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: source/text
source/text/scalc/01/04060110.xhp |4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)
New commits:
commit 435e1e0e429e9d743cf11d08cb10f9f25b83e3b3
Author: Steve Fanning
AuthorDate: Thu Jul 15 22:37:01 2021 +0200
Commit: Olivier Hallot
CommitDate: Thu Jul 15 23:06:51 2021 +0200
Delete erroneous statement from help description of Calc's REPT function.
Change-Id: I5958f787798d309a7896ac47e1caa5fbef96
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/118926
Tested-by: Jenkins
Reviewed-by: Olivier Hallot
diff --git a/source/text/scalc/01/04060110.xhp
b/source/text/scalc/01/04060110.xhp
index cee63d9d7..55a130d20 100644
--- a/source/text/scalc/01/04060110.xhp
+++ b/source/text/scalc/01/04060110.xhp
@@ -565,11 +565,11 @@
REPT("Text";
Number)
Text is the text to be repeated.
Number is the number of repetitions.
-The result can
be a maximum of 255 characters.
=REPT("Good morning";2) returns Good morningGood
morning.
-
+
+Refer to the https://wiki.documentfoundation.org/Documentation/Calc_Functions/REPT;
name="REPT_Wiki">REPT wiki page for more details about this
function.
___
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 082599db722fc662b9c235d618d4787708c09a96 Author: Steve Fanning AuthorDate: Thu Jul 15 23:06:02 2021 +0200 Commit: Gerrit Code Review CommitDate: Thu Jul 15 23:06:02 2021 +0200 Update git submodules * Update helpcontent2 from branch 'master' to 11c68842e216735f261fd065750a91ba98b42be1 - Correct misleading descriptions of parameters passed to Calc's REPLACEB function. Change-Id: Ib145bf71a258f5f58fac4ed90a7a3e3ff509a454 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/118925 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index 5314f2bf5615..11c68842e216 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 5314f2bf56153760b4d704eb971b41638fc4c4d1 +Subproject commit 11c68842e216735f261fd065750a91ba98b42be1 ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: source/text
source/text/scalc/01/func_replaceb.xhp |8 +---
1 file changed, 5 insertions(+), 3 deletions(-)
New commits:
commit 11c68842e216735f261fd065750a91ba98b42be1
Author: Steve Fanning
AuthorDate: Thu Jul 15 22:27:11 2021 +0200
Commit: Olivier Hallot
CommitDate: Thu Jul 15 23:06:02 2021 +0200
Correct misleading descriptions of parameters passed to Calc's REPLACEB
function.
Change-Id: Ib145bf71a258f5f58fac4ed90a7a3e3ff509a454
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/118925
Tested-by: Jenkins
Reviewed-by: Olivier Hallot
diff --git a/source/text/scalc/01/func_replaceb.xhp
b/source/text/scalc/01/func_replaceb.xhp
index 52966391c..a2e85b72c 100644
--- a/source/text/scalc/01/func_replaceb.xhp
+++ b/source/text/scalc/01/func_replaceb.xhp
@@ -28,14 +28,16 @@
REPLACEB( Text ; Position ; Length ; NewText )
-Text:
A text expression or reference to a cell containing a text expression in which
the characters are to be replaced.
-Position: the character position from
which text is to be replaced.
-Length: the number of characters to be
replaced.
+Text:
A text expression or reference to a cell containing a text expression in which
the bytes are to be replaced.
+Position: the byte position from which
text is to be replaced.
+Length: the number of bytes to be
replaced.
NewText: the text to be
inserted.
=REPLACEB("ᄩᄔᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ";4;1;"ab")
returns "ᄩ abᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ" .
+Refer to the https://wiki.documentfoundation.org/Documentation/Calc_Functions/REPLACEB;
name="REPLACEB_Wiki">REPLACEB wiki page for more details about this
function.
+
___
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 261a28da833c73045080e6d29d8bf87f4542fd12 Author: Steve Fanning AuthorDate: Fri Jul 2 13:51:27 2021 +0200 Commit: Gerrit Code Review CommitDate: Fri Jul 2 13:51:27 2021 +0200 Update git submodules * Update helpcontent2 from branch 'master' to 5eac8cf1a7d652c4ab41f4a39cc1095198660808 - Fix minor typos in help descriptions of Calc's text functions. (a) Added equals sign before examples given for MIDB function, for consistency with other help topics. (b) Added statement of default value for Number argument of RIGHT and RIGHTB functions. Change-Id: I6de1b35ce1e78e4403f957bb32878f40598a7269 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/118252 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index dbd32aead45f..5eac8cf1a7d6 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit dbd32aead45fef14e81d3b1ca0a1973f1a856607 +Subproject commit 5eac8cf1a7d652c4ab41f4a39cc1095198660808 ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: source/text
source/text/scalc/01/04060110.xhp | 26 +-
1 file changed, 13 insertions(+), 13 deletions(-)
New commits:
commit 5eac8cf1a7d652c4ab41f4a39cc1095198660808
Author: Steve Fanning
AuthorDate: Thu Jul 1 20:14:32 2021 +0200
Commit: Olivier Hallot
CommitDate: Fri Jul 2 13:51:27 2021 +0200
Fix minor typos in help descriptions of Calc's text functions.
(a) Added equals sign before examples given for MIDB function, for
consistency with other help topics.
(b) Added statement of default value for Number argument of RIGHT and
RIGHTB functions.
Change-Id: I6de1b35ce1e78e4403f957bb32878f40598a7269
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/118252
Tested-by: Jenkins
Reviewed-by: Olivier Hallot
diff --git a/source/text/scalc/01/04060110.xhp
b/source/text/scalc/01/04060110.xhp
index aa7109ba8..b0f5778c7 100644
--- a/source/text/scalc/01/04060110.xhp
+++ b/source/text/scalc/01/04060110.xhp
@@ -495,17 +495,17 @@
Number_bytes specifies the number of characters
MIDB will return from text, in bytes.
-MIDB("中国";1;0) returns "" (0 bytes is always an empty
string).
-MIDB("中国";1;1) returns " " (1 byte is only half a DBCS
character and therefore the result is a space character).
-MIDB("中国";1;2) returns "中" (2 bytes constitute one complete
DBCS character).
-MIDB("中国";1;3) returns "中 " (3 bytes constitute one and a
half DBCS character; the last byte results in a space character).
-MIDB("中国";1;4) returns "中国" (4 bytes constitute two
complete DBCS characters).
-MIDB("中国";2;1) returns " " (byte position 2 is not at the
beginning of a character in a DBCS string; 1 space character is
returned).
-MIDB("中国";2;2) returns " " (byte position 2 points to the
last half of the first character in the DBCS string; the 2 bytes asked for
therefore constitutes the last half of the first character and the first half
of the second character in the string; 2 space characters are therefore
returned).
-MIDB("中国";2;3) returns " 国" (byte position 2 is not at the
beginning of a character in a DBCS string; a space character is returned for
byte position 2).
-MIDB("中国";3;1) returns " " (byte position 3 is at the
beginning of a character in a DBCS string, but 1 byte is only half a DBCS
character and a space character is therefore returned instead).
-MIDB("中国";3;2) returns "国" (byte position 3 is at the
beginning of a character in a DBCS string, and 2 bytes constitute one DBCS
character).
-MIDB("office";2;3) returns "ffi" (byte position 2 is at the
beginning of a character in a non-DBCS string, and 3 bytes of a non-DBCS string
constitute 3 characters).
+=MIDB("中国";1;0) returns "" (0 bytes is always an empty
string).
+=MIDB("中国";1;1) returns " " (1 byte is only half a DBCS
character and therefore the result is a space character).
+=MIDB("中国";1;2) returns "中" (2 bytes constitute one
complete DBCS character).
+=MIDB("中国";1;3) returns "中 " (3 bytes constitute one and a
half DBCS character; the last byte results in a space character).
+=MIDB("中国";1;4) returns "中国" (4 bytes constitute two
complete DBCS characters).
+=MIDB("中国";2;1) returns " " (byte position 2 is not at the
beginning of a character in a DBCS string; 1 space character is
returned).
+=MIDB("中国";2;2) returns " " (byte position 2 points to the
last half of the first character in the DBCS string; the 2 bytes asked for
therefore constitutes the last half of the first character and the first half
of the second character in the string; 2 space characters are therefore
returned).
+=MIDB("中国";2;3) returns " 国" (byte position 2 is not at the
beginning of a character in a DBCS string; a space character is returned for
byte position 2).
+=MIDB("中国";3;1) returns " " (byte position 3 is at the
beginning of a character in a DBCS string, but 1 byte is only half a DBCS
character and a space character is therefore returned instead).
+=MIDB("中国";3;2) returns "国" (byte position 3 is at the
beginning of a character in a DBCS string, and 2 bytes constitute one DBCS
character).
+=MIDB("office";2;3) returns "ffi" (byte position 2 is at
the beginning of a character in a non-DBCS string, and 3 bytes of a non-DBCS
string constitute 3 characters).
@@ -585,7 +585,7 @@
RIGHT("Text" [;
Number])
Text is the text of which the right part is to be
determined.
-
Number (optional) is the number of characters from the right part
of the text.
+
Number (optional) is the number of characters from the right part
of the text. If this parameter is not defined, one character is
returned.
=RIGHT("Sun";2) returns un.
@@ -604,7 +604,7 @@
RIGHTB("Text" [;
Number_bytes])
Text is the text of which the right part is to be
determined.
-Number_bytes (optional) specifies the number of
characters you want RIGHTB to extract, based on bytes.
+Number_bytes (optional) specifies the number of
characters you want RIGHTB to extract, based on bytes. If this parameter is not
defined, one byte is
[Libreoffice-commits] core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit f79a8f578ab56d138139b0de131a86dd5d773de7 Author: Steve Fanning AuthorDate: Mon Jun 28 22:33:55 2021 +0200 Commit: Gerrit Code Review CommitDate: Mon Jun 28 22:33:55 2021 +0200 Update git submodules * Update helpcontent2 from branch 'master' to 1f77c92e446c0b66656b82ae04862528d425a30e - Fix minor typos in help examples for Calc's LEFTB function. Change-Id: I5d8cdf1898f9b5823acc1e3381bbe3abb06551e3 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/118052 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index 108566a12aa3..1f77c92e446c 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 108566a12aa32429286de6f6129b63e2d3e27e94 +Subproject commit 1f77c92e446c0b66656b82ae04862528d425a30e ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: source/text
source/text/scalc/01/04060110.xhp | 10 +-
1 file changed, 5 insertions(+), 5 deletions(-)
New commits:
commit 1f77c92e446c0b66656b82ae04862528d425a30e
Author: Steve Fanning
AuthorDate: Mon Jun 28 21:35:58 2021 +0200
Commit: Olivier Hallot
CommitDate: Mon Jun 28 22:33:55 2021 +0200
Fix minor typos in help examples for Calc's LEFTB function.
Change-Id: I5d8cdf1898f9b5823acc1e3381bbe3abb06551e3
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/118052
Tested-by: Jenkins
Reviewed-by: Olivier Hallot
diff --git a/source/text/scalc/01/04060110.xhp
b/source/text/scalc/01/04060110.xhp
index 26d6abc9f..4049249c3 100644
--- a/source/text/scalc/01/04060110.xhp
+++ b/source/text/scalc/01/04060110.xhp
@@ -392,11 +392,11 @@
Number_bytes (optional) specifies the number of
characters you want LEFTB to extract, based on bytes. If this parameter is not
defined, one character is returned.
-LEFTB("中国";1) returns " " (1 byte is only half a DBCS
character and a space character is returned instead).
-LEFTB("中国";2) returns "中" (2 bytes constitute one complete
DBCS character).
-LEFTB("中国";3) returns "中 " (3 bytes constitute one DBCS
character and a half; the last character returned is therefore a space
character).
-LEFTB("中国";4) returns "中国" (4 bytes constitute two complete
DBCS characters).
-LEFTB("office";3) returns "off" (3 non-DBCS characters each
consisting of 1 byte).
+=LEFTB("中国";1) returns " " (1 byte is only half a DBCS
character and a space character is returned instead).
+=LEFTB("中国";2) returns "中" (2 bytes constitute one complete
DBCS character).
+=LEFTB("中国";3) returns "中 " (3 bytes constitute one DBCS
character and a half; the last character returned is therefore a space
character).
+=LEFTB("中国";4) returns "中国" (4 bytes constitute two
complete DBCS characters).
+=LEFTB("office";3) returns "off" (3 non-DBCS characters
each consisting of 1 byte).
___
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit d3d15db10a4d75c48c57b3026376626dbd343c4a Author: Steve Fanning AuthorDate: Wed Jun 23 16:36:46 2021 +0200 Commit: Gerrit Code Review CommitDate: Wed Jun 23 16:36:46 2021 +0200 Update git submodules * Update helpcontent2 from branch 'master' to a79ac40adfad119a8957200defabe16282ea5204 - Document how to escape double quotes in help for Calc's text functions (TDF#113976) Change-Id: I14c4afc919343dda2e1f30c49c69f434cf1104f1 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/117717 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index ecfb0b345175..a79ac40adfad 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit ecfb0b34517530a35194221909750eafd23f4314 +Subproject commit a79ac40adfad119a8957200defabe16282ea5204 ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: source/text
source/text/scalc/01/04060110.xhp | 30 +-
1 file changed, 29 insertions(+), 1 deletion(-)
New commits:
commit a79ac40adfad119a8957200defabe16282ea5204
Author: Steve Fanning
AuthorDate: Wed Jun 23 14:51:03 2021 +0200
Commit: Olivier Hallot
CommitDate: Wed Jun 23 16:36:46 2021 +0200
Document how to escape double quotes in help for Calc's text functions
(TDF#113976)
Change-Id: I14c4afc919343dda2e1f30c49c69f434cf1104f1
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/117717
Tested-by: Jenkins
Reviewed-by: Olivier Hallot
diff --git a/source/text/scalc/01/04060110.xhp
b/source/text/scalc/01/04060110.xhp
index 892c0d6c1..26d6abc9f 100644
--- a/source/text/scalc/01/04060110.xhp
+++ b/source/text/scalc/01/04060110.xhp
@@ -40,8 +40,36 @@
-
+
+
+ using double quotation marks in formulas
+ formulas; using double quotation marks
+
+
+Using double quotation marks in formulas
+
+To include a text
string in a formula, place the text string between two double quotation marks
(") and Calc takes the characters in the string without attempting to interpret
them. For example, the formula ="Hello world!" displays the text
string Hello world! in the cell, with no surrounding double
quotation marks.
+
+The more complex
formula =CONCATENATE("Life is really simple, "; "but we insist on making
it complicated "; "(Confucius).") concatenates three individual strings
in double quotation marks, outputting Life is really simple, but we
insist on making it complicated (Confucius).
+
+To place a literal
double quotation mark within a string inside a formula, two methods can be
used:
+
+
+
+You can "escape"
the double quotation mark with an additional double quotation mark, and Calc
treats the escaped double quotation mark as a literal value. For example, the
formula ="My name is ""John Doe""." outputs the string
My name is "John Doe". Another simple example is the formula
=UNICODE() which returns 34, the decimal
value of the Unicode quotation mark character (U+0022) - here the first and
fourth double quotation marks indicate the beginning and end of the string,
while the second double quotation mark escapes the third.
+
+
+You can use the
CHAR function or the UNICHAR function to insert a double quotation mark. For
example, the formula =UNICHAR(34) "The Catcher in the Rye"
UNICHAR(34) " is a famous book by J. D. Salinger." displays the
string "The Catcher in the Rye" is a famous book by J. D.
Salinger.
+
+
+
+Beware that Calc's
AutoCorrect function may modify double quotation marks. AutoCorrect should not
change the double quotation marks within formula cells but may change those
used in non-formula cells containing text. For example, if you copy a string
that is surrounded by some other form of typographical double quotation marks,
such as the left double quotation mark (U+201C) and the right double quotation
mark (U+201D), and then paste into a formula cell, an error may result. Open
the Double Quotes area of the Tools > AutoCorrect
Options > Localized Options dialog to set the characters used to
automatically correct the start and end typographical double quotation marks.
Untick the Replace toggle button to disable the
feature.
+
+
+
+
+
ARABIC function
___
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit e759f8ddab7f767d23f07e6ee5e50ee8ee51bba9 Author: Steve Fanning AuthorDate: Tue Jun 22 13:07:16 2021 +0200 Commit: Gerrit Code Review CommitDate: Tue Jun 22 13:07:16 2021 +0200 Update git submodules * Update helpcontent2 from branch 'master' to 26fad1c72fdc6a72b455c44e57b5738ee6d1a61d - Provide a correct example within the help for Calc's FINDB function. Change-Id: Ibff7dd5bf47f26c431b1ce49e6ac5250f6192176 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/117569 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index 23b0b4405155..26fad1c72fdc 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 23b0b440515592c9b9ed2fe8e64783ea55375375 +Subproject commit 26fad1c72fdc6a72b455c44e57b5738ee6d1a61d ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: source/text
source/text/scalc/01/func_findb.xhp |2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit 26fad1c72fdc6a72b455c44e57b5738ee6d1a61d
Author: Steve Fanning
AuthorDate: Mon Jun 21 21:48:01 2021 +0200
Commit: Olivier Hallot
CommitDate: Tue Jun 22 13:07:16 2021 +0200
Provide a correct example within the help for Calc's FINDB function.
Change-Id: Ibff7dd5bf47f26c431b1ce49e6ac5250f6192176
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/117569
Tested-by: Jenkins
Reviewed-by: Olivier Hallot
diff --git a/source/text/scalc/01/func_findb.xhp
b/source/text/scalc/01/func_findb.xhp
index 091d7ecc3..e28e5e971 100644
--- a/source/text/scalc/01/func_findb.xhp
+++ b/source/text/scalc/01/func_findb.xhp
@@ -32,7 +32,7 @@
Text:
the text in which the search is to be made.
Position: The position in the text
where the search starts.
-=FINDB("ᄫᄬ";"ᄩᄔᄕᄜᄝᄞᄠgᄢᄣᄫᄬᄭᄮᄯᄲᄶ";17)
returns 19.
+=FINDB("ａ";
"LibreOffice Ｃａｌｃ") returns 15. The Find Text argument is
a text string that comprises a full-width, double-byte "a" character, while the
Text argument comprises 12 single-byte characters followed by four
full-width, double-byte characters.
___
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 48f7f5d0543eedc0d8c85ccef7233b58f49beb8a Author: Steve Fanning AuthorDate: Mon May 31 14:42:48 2021 +0200 Commit: Gerrit Code Review CommitDate: Mon May 31 14:42:48 2021 +0200 Update git submodules * Update helpcontent2 from branch 'master' to 8ca38307bd81fbb37a664dd848fd1fda2c2b4181 - Clarify example in help description of Calc's DOLLAR function. Change-Id: Iab2333cbd98bd4bb13ba35a07d4dbcd66fc840a6 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/116166 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index d0fc1c870940..8ca38307bd81 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit d0fc1c87094067bc528cac5a66fd667dc41af125 +Subproject commit 8ca38307bd81fbb37a664dd848fd1fda2c2b4181 ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: source/text
source/text/scalc/01/04060110.xhp |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 8ca38307bd81fbb37a664dd848fd1fda2c2b4181 Author: Steve Fanning AuthorDate: Sun May 30 12:04:39 2021 +0200 Commit: Olivier Hallot CommitDate: Mon May 31 14:42:48 2021 +0200 Clarify example in help description of Calc's DOLLAR function. Change-Id: Iab2333cbd98bd4bb13ba35a07d4dbcd66fc840a6 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/116166 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/source/text/scalc/01/04060110.xhp b/source/text/scalc/01/04060110.xhp index 3a4ab2306..274dc2d6d 100644 --- a/source/text/scalc/01/04060110.xhp +++ b/source/text/scalc/01/04060110.xhp @@ -242,7 +242,7 @@ Decimals is the optional number of decimal places. - =DOLLAR(255) returns $255.00. + =DOLLAR(255) returns $255.00 for the English (USA) locale and USD (dollar) currency; ￥255.00 for the Japanese locale and JPY (yen) currency; or 255,00 € for the German (Germany) locale and EUR (euro) currency. =DOLLAR(367.456;2) returns $367.46. Use the decimal separator that corresponds to the current locale setting. ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 0d4e5630ac638e555a4a3261b3baa6d271cf5a70 Author: Steve Fanning AuthorDate: Sun May 30 00:02:35 2021 +0200 Commit: Gerrit Code Review CommitDate: Sun May 30 00:02:35 2021 +0200 Update git submodules * Update helpcontent2 from branch 'master' to d443ebed5df323aa13c2f5fa505b98366d8a4f9c - Fix help description for Calc's TEXTJOIN function. Change-Id: I91bb809ab41c0299c65236a0091c2da288a47b31 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/116163 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index 96e26682870d..d443ebed5df3 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 96e26682870d3032dc06ed0a580f22111998 +Subproject commit d443ebed5df323aa13c2f5fa505b98366d8a4f9c ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: source/text
source/text/scalc/01/func_textjoin.xhp |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit d443ebed5df323aa13c2f5fa505b98366d8a4f9c Author: Steve Fanning AuthorDate: Fri May 28 21:47:18 2021 +0200 Commit: Olivier Hallot CommitDate: Sun May 30 00:02:35 2021 +0200 Fix help description for Calc's TEXTJOIN function. Change-Id: I91bb809ab41c0299c65236a0091c2da288a47b31 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/116163 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/source/text/scalc/01/func_textjoin.xhp b/source/text/scalc/01/func_textjoin.xhp index ed3e13b67..b7f04904d 100644 --- a/source/text/scalc/01/func_textjoin.xhp +++ b/source/text/scalc/01/func_textjoin.xhp @@ -28,7 +28,7 @@ TEXTJOIN( delimiter, skip_empty, String 1[; String 2][; … ;[String 253]] ) delimiter is a text string and can be a range. -skip_empty is a logical (TRUE or FALSE, 1 or 0) argument. When TRUE, empty strings will be ignored. +skip_empty is a logical argument. When set to FALSE or 0, empty strings will be taken into account and this may lead to adjacent delimiters in the returned string. When set to any other value (e.g. TRUE or 1), empty strings will be ignored. String 1[; String 2][; … ;[String 253]] are strings, references to cells or to cell ranges of strings. Ranges are traversed row by row (from top to bottom). If delimiter is a range, the range need not be of the same size as the number of strings to be joined. ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit eda109d5d91e82adb675ebf6db952bf6d82b3391 Author: Steve Fanning AuthorDate: Fri May 21 01:17:43 2021 +0200 Commit: Gerrit Code Review CommitDate: Fri May 21 01:17:43 2021 +0200 Update git submodules * Update helpcontent2 from branch 'master' to ab50f2ccc57ebe577cbdad4afa29b66317b87bcc - Fix text in 2nd example given in help description of Calc's EOMONTH function. The statement that the date MUST be in ISO format is not quite correct. Also add link to updated wiki page. Change-Id: I20158373f8a67ae90cd1bfccb9fbe1d7c011077f Reviewed-on: https://gerrit.libreoffice.org/c/help/+/115838 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index 44bd3d8205dd..ab50f2ccc57e 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 44bd3d8205dd9020b9725a03518cb1316d3062fa +Subproject commit ab50f2ccc57ebe577cbdad4afa29b66317b87bcc ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: source/text
source/text/scalc/01/func_eomonth.xhp |3 ++-
1 file changed, 2 insertions(+), 1 deletion(-)
New commits:
commit ab50f2ccc57ebe577cbdad4afa29b66317b87bcc
Author: Steve Fanning
AuthorDate: Thu May 20 21:43:42 2021 +0200
Commit: Olivier Hallot
CommitDate: Fri May 21 01:17:43 2021 +0200
Fix text in 2nd example given in help description of Calc's EOMONTH
function.
The statement that the date MUST be in ISO format is not quite correct.
Also add link to updated wiki page.
Change-Id: I20158373f8a67ae90cd1bfccb9fbe1d7c011077f
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/115838
Tested-by: Jenkins
Reviewed-by: Olivier Hallot
diff --git a/source/text/scalc/01/func_eomonth.xhp
b/source/text/scalc/01/func_eomonth.xhp
index 186c4e948..74d3af592 100644
--- a/source/text/scalc/01/func_eomonth.xhp
+++ b/source/text/scalc/01/func_eomonth.xhp
@@ -40,8 +40,9 @@
What is the
last day of the month that falls 6 months after September 14 2001?
=EOMONTH(DATE(2001;9;14);6) returns the serial number
37346. Formatted as a date, this is 2002-03-31.
-=EOMONTH("2001-09-14";6) works as well. If the date is
given as string, it has to be in ISO format.
+=EOMONTH("2001-09-14";6) works as well. If you specify the
date directly, we recommend using the standard ISO 8601 format because this
should be independent of your selected locale settings.
+https://wiki.documentfoundation.org/Documentation/Calc_Functions/EOMONTH;>EOMONTH
wiki page
___
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 235f570cdc9e57d32257b5c1e599eec24f89836f Author: Steve Fanning AuthorDate: Fri May 21 01:15:09 2021 +0200 Commit: Gerrit Code Review CommitDate: Fri May 21 01:15:09 2021 +0200 Update git submodules * Update helpcontent2 from branch 'master' to 44bd3d8205dd9020b9725a03518cb1316d3062fa - Add example to help description for Calc's CLEAN function. Change-Id: Iae7a1f0b8b84be33f5f54a9a7116c0c48670f917 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/115833 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index 774b852c14a4..44bd3d8205dd 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 774b852c14a4a8df49c9ad35e609d8060b9b46a1 +Subproject commit 44bd3d8205dd9020b9725a03518cb1316d3062fa ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: source/text
source/text/scalc/01/04060110.xhp |4
1 file changed, 4 insertions(+)
New commits:
commit 44bd3d8205dd9020b9725a03518cb1316d3062fa
Author: Steve Fanning
AuthorDate: Wed May 19 22:21:04 2021 +0200
Commit: Olivier Hallot
CommitDate: Fri May 21 01:15:09 2021 +0200
Add example to help description for Calc's CLEAN function.
Change-Id: Iae7a1f0b8b84be33f5f54a9a7116c0c48670f917
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/115833
Tested-by: Jenkins
Reviewed-by: Olivier Hallot
diff --git a/source/text/scalc/01/04060110.xhp
b/source/text/scalc/01/04060110.xhp
index 59ded0137..3a4ab2306 100644
--- a/source/text/scalc/01/04060110.xhp
+++ b/source/text/scalc/01/04060110.xhp
@@ -163,6 +163,10 @@
CLEAN("Text")
Text refers to the text from which to remove all non-printable
characters.
+
+
+=LEN(CLEAN(CHAR(7) "LibreOffice Calc"
CHAR(8))) returns 16, showing that the CLEAN function removes the
non-printable Unicode U+0007 ("BEL") and U+0008 ("BS") characters at the
beginning and end of the string argument. CLEAN does not remove
spaces.
+
___
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 6e6e531b564cdc9d5b25287c215cdc5a1fcbb346 Author: Steve Fanning AuthorDate: Thu Apr 15 00:43:57 2021 +0200 Commit: Gerrit Code Review CommitDate: Thu Apr 15 00:43:57 2021 +0200 Update git submodules * Update helpcontent2 from branch 'master' to 400078d391b11c921d1069e23e357b12595c0307 - Fix order of rendering for four Bessel functions in Calc help file ../01/04060115.xhp. Also removed a couple of unnecessary spaces at the beginning of sentences. Change-Id: Iecb5cd7b6eb304114f40c843f094a27976c3 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/114005 Tested-by: Jenkins Tested-by: Olivier Hallot Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index 26e5265ade24..400078d391b1 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 26e5265ade24d7eeeaf7d120e0dbcb4cbc598fed +Subproject commit 400078d391b11c921d1069e23e357b12595c0307 ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: source/text
source/text/scalc/01/04060115.xhp |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 400078d391b11c921d1069e23e357b12595c0307 Author: Steve Fanning AuthorDate: Wed Apr 14 21:45:26 2021 +0200 Commit: Olivier Hallot CommitDate: Thu Apr 15 00:43:57 2021 +0200 Fix order of rendering for four Bessel functions in Calc help file ../01/04060115.xhp. Also removed a couple of unnecessary spaces at the beginning of sentences. Change-Id: Iecb5cd7b6eb304114f40c843f094a27976c3 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/114005 Tested-by: Jenkins Tested-by: Olivier Hallot Reviewed-by: Olivier Hallot diff --git a/source/text/scalc/01/04060115.xhp b/source/text/scalc/01/04060115.xhp index 52bcff7b6..39203961e 100644 --- a/source/text/scalc/01/04060115.xhp +++ b/source/text/scalc/01/04060115.xhp @@ -37,7 +37,7 @@ - + ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: source/text
source/text/scalc/01/04060115.xhp | 12 +++- 1 file changed, 11 insertions(+), 1 deletion(-) New commits: commit 7f3528e4c87fb7bea49c715733abb041d4e0bd52 Author: Steve Fanning AuthorDate: Tue Apr 13 00:42:12 2021 +0200 Commit: Olivier Hallot CommitDate: Tue Apr 13 15:48:43 2021 +0200 Make sure that each of Calc's four BESSEL functions appear in Help index. Also update tag on same page to specify the usual order. Change-Id: I2e214bdd6e0b865c3b27aa33d7beafc1599c4aaf Reviewed-on: https://gerrit.libreoffice.org/c/help/+/113995 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/source/text/scalc/01/04060115.xhp b/source/text/scalc/01/04060115.xhp index 1e16911f3..52bcff7b6 100644 --- a/source/text/scalc/01/04060115.xhp +++ b/source/text/scalc/01/04060115.xhp @@ -37,11 +37,12 @@ - + Bessel functions + BESSELI function @@ -61,6 +62,9 @@ + + BESSELJ function + BESSELJ @@ -78,6 +82,9 @@ + + BESSELK function + BESSELK @@ -95,6 +102,9 @@ + + BESSELY function + BESSELY ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit f01ba45e59696aa1a5e500a96c8ec7c40491da35 Author: Steve Fanning AuthorDate: Tue Apr 13 15:48:43 2021 +0200 Commit: Gerrit Code Review CommitDate: Tue Apr 13 15:48:43 2021 +0200 Update git submodules * Update helpcontent2 from branch 'master' to 7f3528e4c87fb7bea49c715733abb041d4e0bd52 - Make sure that each of Calc's four BESSEL functions appear in Help index. Also update tag on same page to specify the usual order. Change-Id: I2e214bdd6e0b865c3b27aa33d7beafc1599c4aaf Reviewed-on: https://gerrit.libreoffice.org/c/help/+/113995 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index 07dcc9868b9f..7f3528e4c87f 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 07dcc9868b9fa0bca222a9f87c4c427981b9ee2c +Subproject commit 7f3528e4c87fb7bea49c715733abb041d4e0bd52 ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 4ffe58c5be712072387a8403dca8ba3cbc1df35a Author: Steve Fanning AuthorDate: Sun Apr 11 11:09:19 2021 -0300 Commit: Gerrit Code Review CommitDate: Sun Apr 11 16:09:19 2021 +0200 Update git submodules * Update helpcontent2 from branch 'master' to d055e8d2ab5182def772050c8abdc54725a7814a - Help Pages for Calc’s “IM” Functions, Improved Equations I have recently spent some time updating the pages of the Calc Functions Wiki that relate to the processing of complex numbers. There are 25 functions in Calc’s Add-In category that have names beginning with the letters “IM” and these are all concerned with processing complex numbers of the form “a+bi”. Of these 25, there are 6 trigonometric functions (IMCOS, IMCOT, IMCSC, IMSEC, IMSIN, and IMTAN) and 4 hyperbolic functions (IMCOSH, IMCSCH, IMSECH, and IMSINH). For these 10, the current help pages include equations to assist the user’s understanding of the function’s purpose. I feel that some of these equations should be replaced with more appropriate equations that reflect how the software functions (see /core/scaddins/source/analysis/analysishelper.cxx) and these proposed changes are listed below. Change-Id: Ie0e4957e374570d60be00bcbe9b9015acab5e3a1 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/113935 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index 308ebcecc9e8..d055e8d2ab51 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 308ebcecc9e88de8422a0a44599b77ce0f2b73d9 +Subproject commit d055e8d2ab5182def772050c8abdc54725a7814a ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: Package_html_media.mk source/media source/text
Package_html_media.mk | 12 source/media/helpimg/sc_func_imcot.svg | 233 --- source/media/helpimg/sc_func_imcsc.svg | 490 --- source/media/helpimg/sc_func_imcsch.svg| 498 --- source/media/helpimg/sc_func_imsec.svg | 490 --- source/media/helpimg/sc_func_imsech.svg| 498 --- source/media/helpimg/sc_func_imtan.svg | 796 - source/media/helpimg/scalc/IMCOT_equation.svg | 449 ++ source/media/helpimg/scalc/IMCSCH_equation.svg | 553 + source/media/helpimg/scalc/IMCSC_equation.svg | 549 + source/media/helpimg/scalc/IMSECH_equation.svg | 553 + source/media/helpimg/scalc/IMSEC_equation.svg | 549 + source/media/helpimg/scalc/IMTAN_equation.svg | 449 ++ source/text/scalc/01/func_imcot.xhp|2 source/text/scalc/01/func_imcsc.xhp|2 source/text/scalc/01/func_imcsch.xhp |3 source/text/scalc/01/func_imsec.xhp|2 source/text/scalc/01/func_imsech.xhp |2 source/text/scalc/01/func_imtan.xhp|2 19 files changed, 3115 insertions(+), 3017 deletions(-) New commits: commit d055e8d2ab5182def772050c8abdc54725a7814a Author: Steve Fanning AuthorDate: Sat Apr 10 20:35:48 2021 -0300 Commit: Olivier Hallot CommitDate: Sun Apr 11 16:09:19 2021 +0200 Help Pages for Calc’s “IM” Functions, Improved Equations I have recently spent some time updating the pages of the Calc Functions Wiki that relate to the processing of complex numbers. There are 25 functions in Calc’s Add-In category that have names beginning with the letters “IM” and these are all concerned with processing complex numbers of the form “a+bi”. Of these 25, there are 6 trigonometric functions (IMCOS, IMCOT, IMCSC, IMSEC, IMSIN, and IMTAN) and 4 hyperbolic functions (IMCOSH, IMCSCH, IMSECH, and IMSINH). For these 10, the current help pages include equations to assist the user’s understanding of the function’s purpose. I feel that some of these equations should be replaced with more appropriate equations that reflect how the software functions (see /core/scaddins/source/analysis/analysishelper.cxx) and these proposed changes are listed below. Change-Id: Ie0e4957e374570d60be00bcbe9b9015acab5e3a1 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/113935 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/Package_html_media.mk b/Package_html_media.mk index 2fb33193b..625805576 100644 --- a/Package_html_media.mk +++ b/Package_html_media.mk @@ -80,14 +80,14 @@ $(eval $(call gb_Package_add_files_with_dir,helpcontent2_html_media,$(LIBO_SHARE helpimg/sc_cell_with_comment_displayed.png \ helpimg/sc_func_imcos.svg \ helpimg/sc_func_imcosh.svg \ -helpimg/sc_func_imcot.svg \ +helpimg/scalc/IMCOT_equation.svg \ helpimg/sc_func_imsin.svg \ helpimg/sc_func_imsinh.svg \ -helpimg/sc_func_imcsc.svg \ -helpimg/sc_func_imcsch.svg \ -helpimg/sc_func_imsec.svg \ -helpimg/sc_func_imsech.svg \ -helpimg/sc_func_imtan.svg \ +helpimg/scalc/IMCSC_equation.svg \ +helpimg/scalc/IMCSCH_equation.svg \ +helpimg/scalc/IMSEC_equation.svg \ +helpimg/scalc/IMSECH_equation.svg \ +helpimg/scalc/IMTAN_equation.svg \ helpimg/sc_func_opt01.svg \ helpimg/sd_drawing_with_comment.png \ helpimg/sd_PresenterConsole01.png \ diff --git a/source/media/helpimg/sc_func_imcot.svg b/source/media/helpimg/sc_func_imcot.svg deleted file mode 100644 index 642d1a7a2..0 --- a/source/media/helpimg/sc_func_imcot.svg +++ /dev/null @@ -1,233 +0,0 @@ - -https://sourceforge.net/projects/pmml2svg/; - xmlns:dc="http://purl.org/dc/elements/1.1/; - xmlns:cc="http://creativecommons.org/ns#; - xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#; - xmlns:svg="http://www.w3.org/2000/svg; - xmlns="http://www.w3.org/2000/svg; - id="svg60" - viewBox="0 0 259.194434 54.9625006" - height="54.9625006px" - width="259.194434px" - version="1.1"> - - -24.1375003 - - -image/svg+xml -http://purl.org/dc/dcmitype/StillImage; /> - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
[Libreoffice-commits] core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 30b85dd25836520c6e0f7a11887178f81d2cdc30 Author: Steve Fanning AuthorDate: Sat Mar 27 09:01:01 2021 +0100 Commit: Gerrit Code Review CommitDate: Sat Mar 27 09:01:01 2021 +0100 Update git submodules * Update helpcontent2 from branch 'master' to a502c5a5959e7c01b7769bf20778d7791876bde0 - Fix minor typo in recently-updated help file describing Calc's database functions (04060101.xhp). Change-Id: Ia7b9092a03164722fe9ddb97816195dcb3fb9d2b Reviewed-on: https://gerrit.libreoffice.org/c/help/+/113126 Tested-by: Jenkins Reviewed-by: Julien Nabet diff --git a/helpcontent2 b/helpcontent2 index a21d3cc17c69..a502c5a5959e 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit a21d3cc17c6990acb7125e24039e33bc4840b1e8 +Subproject commit a502c5a5959e7c01b7769bf20778d7791876bde0 ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: source/text
source/text/scalc/01/04060101.xhp |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit a502c5a5959e7c01b7769bf20778d7791876bde0 Author: Steve Fanning AuthorDate: Fri Mar 26 16:38:58 2021 +0100 Commit: Julien Nabet CommitDate: Sat Mar 27 09:01:01 2021 +0100 Fix minor typo in recently-updated help file describing Calc's database functions (04060101.xhp). Change-Id: Ia7b9092a03164722fe9ddb97816195dcb3fb9d2b Reviewed-on: https://gerrit.libreoffice.org/c/help/+/113126 Tested-by: Jenkins Reviewed-by: Julien Nabet diff --git a/source/text/scalc/01/04060101.xhp b/source/text/scalc/01/04060101.xhp index c68f28254..4d4054d35 100644 --- a/source/text/scalc/01/04060101.xhp +++ b/source/text/scalc/01/04060101.xhp @@ -947,7 +947,7 @@ mw added "standard deviations...;" DSTDEVP -DSTDEVP calculates the population standard deviation based on the numeric values in the cells (fields) of the specified column, for all rows (database records) that match the specified search criteri. Non-numeric values are ignored. +DSTDEVP calculates the population standard deviation based on the numeric values in the cells (fields) of the specified column, for all rows (database records) that match the specified search criteria. Non-numeric values are ignored. Returns a #NUM! error if no records match the specified search criteria, or if there are no numeric values in the cells of the specified column for the matching records. ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit ea184837a54fc85599d78baf59c83b6cf8bd0adb Author: Steve Fanning AuthorDate: Wed Mar 24 11:43:40 2021 +0100 Commit: Gerrit Code Review CommitDate: Wed Mar 24 11:43:40 2021 +0100 Update git submodules * Update helpcontent2 from branch 'master' to 1a5176e2d466ff7dddcdd6c609e85357fc6451a3 - Update to improve the Help page for Calc's 12 database functions. File affected - 04060101.xhp Change-Id: Iacc2be5f269b1e7157a1cc62b3706d84bac9985e Reviewed-on: https://gerrit.libreoffice.org/c/help/+/112517 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index a202f3a40b93..1a5176e2d466 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit a202f3a40b93e86354a32bcac95e595f5f636769 +Subproject commit 1a5176e2d466ff7dddcdd6c609e85357fc6451a3 ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: source/text
source/text/scalc/01/04060101.xhp | 1562 +++--- 1 file changed, 973 insertions(+), 589 deletions(-) New commits: commit 1a5176e2d466ff7dddcdd6c609e85357fc6451a3 Author: Steve Fanning AuthorDate: Mon Mar 15 16:39:26 2021 +0100 Commit: Olivier Hallot CommitDate: Wed Mar 24 11:43:40 2021 +0100 Update to improve the Help page for Calc's 12 database functions. File affected - 04060101.xhp Change-Id: Iacc2be5f269b1e7157a1cc62b3706d84bac9985e Reviewed-on: https://gerrit.libreoffice.org/c/help/+/112517 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/source/text/scalc/01/04060101.xhp b/source/text/scalc/01/04060101.xhp index 76e83be24..c68f28254 100644 --- a/source/text/scalc/01/04060101.xhp +++ b/source/text/scalc/01/04060101.xhp @@ -20,619 +20,1003 @@ --> - - - Database Functions - /text/scalc/01/04060101.xhp - - - -Function Wizard; databases - functions; database functions - databases; functions in $[officename] Calc + + +Database Functions +/text/scalc/01/04060101.xhp + + + + +Function Wizard; databases +functions; database functions +databases; functions in $[officename] Calc -Database Functions - This section deals with functions used with data organized as one row of data for one record. - The Database category may be confused with a database integrated in $[officename]. However, there is no connection between a database in $[officename] and the Database category in $[officename] Calc. - Example Data: - The following data will be used in some of the function description examples: - The range A1:E10 lists the children invited to Joe's birthday party. The following information is given for each entry: column A shows the name, B the grade, then age in years, distance to school in meters and weight in kilograms. - - - - - - A - - - B - - - C - - - D - - - E - - - - - 1 - - - -Name - - - - -Grade - - - - -Age - - - - -Distance to School - - - - -Weight - - - - - - 2 - - - -Andy - - - - 3 - - - 9 - - - 150 - - - 40 - - - - - 3 - - - -Betty - - - - 4 - - - 10 - - - 1000 - - - 42 - - - - - 4 - - - -Charles - - - - 3 - - - 10 - - - 300 - - - 51 - - - - - 5 - - - -Daniel - - - - 5 - - - 11 - - - 1200 - - - 48 - - - - - 6 - - - -Eva - - - - 2 - - - 8 - - - 650 - - - 33 - - - - - 7 - - - -Frank - - - - 2 - - - 7 - - - 300 - - - 42 - - - - - 8 - - - -Greta - - - - 1 - - - 7 - - - 200 - - - 36 - - - - - 9 - - - -Harry - - - - 3 - - - 9 - - -
[Libreoffice-commits] core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit e2c2f1b36f8bdd9caf523e7dab17cb6a17b9a6dd Author: Steve Fanning AuthorDate: Wed Feb 10 20:19:08 2021 +0100 Commit: Gerrit Code Review CommitDate: Wed Feb 10 20:19:08 2021 +0100 Update git submodules * Update helpcontent2 from branch 'master' to dd6644f72864fec9043739e9939df284e8505853 - Fix Examples section in Help description of Calc's HLOOKUP function. In the table of sample data, we have omitted the first column of row headings (as described in the text above the table). Also the heading of the last column should be "DO" rather than "DO4". File 04060109.xhp. Change-Id: Ib90f11f4937ba2f3283dfb96119ad5106a9e2274 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/110680 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index c36ab9284db6..dd6644f72864 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit c36ab9284db666581cb814ce6f2265107439c4ee +Subproject commit dd6644f72864fec9043739e9939df284e8505853 ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: source/text
source/text/scalc/01/04060109.xhp | 46 +++--- 1 file changed, 38 insertions(+), 8 deletions(-) New commits: commit dd6644f72864fec9043739e9939df284e8505853 Author: Steve Fanning AuthorDate: Wed Feb 10 18:25:17 2021 +0100 Commit: Olivier Hallot CommitDate: Wed Feb 10 20:19:08 2021 +0100 Fix Examples section in Help description of Calc's HLOOKUP function. In the table of sample data, we have omitted the first column of row headings (as described in the text above the table). Also the heading of the last column should be "DO" rather than "DO4". File 04060109.xhp. Change-Id: Ib90f11f4937ba2f3283dfb96119ad5106a9e2274 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/110680 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/source/text/scalc/01/04060109.xhp b/source/text/scalc/01/04060109.xhp index 0e232ea29..68b3c 100644 --- a/source/text/scalc/01/04060109.xhp +++ b/source/text/scalc/01/04060109.xhp @@ -465,22 +465,34 @@ - A + + + + A + + + B - B + C - C + D ... - DO4 + DO + + 1 + + + Element + Hydrogen @@ -497,14 +509,20 @@ Oganesson - + + + 2 + + + Symbol + H He - + Li @@ -515,10 +533,16 @@ + + 3 + + + Atomic Number + 1 - + 2 @@ -532,10 +556,16 @@ + + 4 + + + Relative Atomic Mass + 1.008 - + 4.0026 ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit e3f11200d3074ac818e27541c3976725aebde7f2 Author: Steve Fanning AuthorDate: Fri Feb 5 16:58:16 2021 +0100 Commit: Gerrit Code Review CommitDate: Fri Feb 5 16:58:16 2021 +0100 Update git submodules * Update helpcontent2 from branch 'master' to e42644369803fbcff1f1c487616dad5bf9f11801 - Clarify the Help description for Calc’s SHEET function. Remove potential ambiguity from first sentence and provide an example of using a string as an argument. Affects file 04060109.xhp. Change-Id: I3406679155b4eac512f8f64f64c8ddc930eb9048 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/110441 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index 1babc5665e75..e42644369803 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 1babc5665e751c926cd049e4784b08b0e2f26f7d +Subproject commit e42644369803fbcff1f1c487616dad5bf9f11801 ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: source/text
source/text/scalc/01/04060109.xhp |8 +---
1 file changed, 5 insertions(+), 3 deletions(-)
New commits:
commit e42644369803fbcff1f1c487616dad5bf9f11801
Author: Steve Fanning
AuthorDate: Fri Feb 5 14:25:32 2021 +0100
Commit: Olivier Hallot
CommitDate: Fri Feb 5 16:58:16 2021 +0100
Clarify the Help description for Calc’s SHEET function.
Remove potential ambiguity from first sentence and provide an example of
using a string as an argument.
Affects file 04060109.xhp.
Change-Id: I3406679155b4eac512f8f64f64c8ddc930eb9048
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/110441
Tested-by: Jenkins
Reviewed-by: Olivier Hallot
diff --git a/source/text/scalc/01/04060109.xhp
b/source/text/scalc/01/04060109.xhp
index c571dc97a..0e232ea29 100644
--- a/source/text/scalc/01/04060109.xhp
+++ b/source/text/scalc/01/04060109.xhp
@@ -300,14 +300,16 @@
SHEET
- Returns the sheet number of a
reference or a string representing a sheet name. If you do not enter
any parameters, the result is the sheet number of the spreadsheet containing
the formula.
+ Returns the sheet number of
either a reference or a string representing a sheet name. If you do not
enter any parameters, the result is the sheet number of the spreadsheet
containing the formula.
SHEET([Reference])
Reference is optional and is the reference to a cell,
an area, or a sheet name string.
-
+
-=SHEET(Sheet2.A1) returns 2 if Sheet2 is
the second sheet in the spreadsheet document.
+=SHEET(Sheet2.A1) returns 2 if Sheet2 is the second
sheet in the spreadsheet document.
+
+=SHEET("Sheet3") returns 3 if Sheet3 is the third
sheet in the spreadsheet document.
number of sheets; function
___
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit e532a6891327441577586a6ef9c347cb074c87b6 Author: Steve Fanning AuthorDate: Fri Feb 5 16:55:09 2021 +0100 Commit: Gerrit Code Review CommitDate: Fri Feb 5 16:55:09 2021 +0100 Update git submodules * Update helpcontent2 from branch 'master' to 1babc5665e751c926cd049e4784b08b0e2f26f7d - Fix example given in Help description for Calc’s XIRR function. The data as given for the example does not work because the date in A2 should be 2001-02-01 to give the correct return value. File affected is 04060118.xhp. Change-Id: Ib1fd7849557e4b27ca1579940f1a60059a5c2b6f Reviewed-on: https://gerrit.libreoffice.org/c/help/+/110370 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index f654fc362e2c..1babc5665e75 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit f654fc362e2ca75a1ff10b772f4b72065484fab2 +Subproject commit 1babc5665e751c926cd049e4784b08b0e2f26f7d ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: source/text
source/text/scalc/01/04060118.xhp | 44 +++--- 1 file changed, 22 insertions(+), 22 deletions(-) New commits: commit 1babc5665e751c926cd049e4784b08b0e2f26f7d Author: Steve Fanning AuthorDate: Thu Feb 4 21:44:22 2021 +0100 Commit: Olivier Hallot CommitDate: Fri Feb 5 16:55:09 2021 +0100 Fix example given in Help description for Calc’s XIRR function. The data as given for the example does not work because the date in A2 should be 2001-02-01 to give the correct return value. File affected is 04060118.xhp. Change-Id: Ib1fd7849557e4b27ca1579940f1a60059a5c2b6f Reviewed-on: https://gerrit.libreoffice.org/c/help/+/110370 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/source/text/scalc/01/04060118.xhp b/source/text/scalc/01/04060118.xhp index 9b87de938..1f4c8de6e 100644 --- a/source/text/scalc/01/04060118.xhp +++ b/source/text/scalc/01/04060118.xhp @@ -179,92 +179,92 @@ Guess (optional) is a guess that can be input for the internal rate of return. The default is 10%. -Calculation of the internal rate of return for the following five payments: +Calculation of the internal rate of return for the following five payments (dates are in ISO 8601 format): - A + A - B + B - C + C - 1 + 1 - 2001-01-01 + 2001-01-01 - -1 + -1 - Received + Received - 2 + 2 - 2001-01-02 + 2001-02-01 - 2000 + 2000 - Deposited + Deposited - 3 + 3 - 2001-03-15 + 2001-03-15 - 2500 + 2500 - 4 + 4 - 2001-05-12 + 2001-05-12 - 5000 + 5000 - 5 + 5 - 2001-08-10 + 2001-08-10 - 1000 + 1000 -=XIRR(B1:B5; A1:A5; 0.1) returns 0.1828. +=XIRR(B1:B5; A1:A5; 0.1) returns 0.1828 or 18.28%. ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 998bd9f4bac716a36c0feb0455183c530e4cf523 Author: Steve Fanning AuthorDate: Fri Feb 5 16:44:54 2021 +0100 Commit: Gerrit Code Review CommitDate: Fri Feb 5 16:44:54 2021 +0100 Update git submodules * Update helpcontent2 from branch 'master' to f654fc362e2ca75a1ff10b772f4b72065484fab2 - Add Examples section to Help description for Calc's HLOOKUP function. File 04060109.xhp Change-Id: If5828bba9aec04564c9eab37f41731ac4d886c1a Reviewed-on: https://gerrit.libreoffice.org/c/help/+/110364 Reviewed-by: Olivier Hallot Tested-by: Jenkins diff --git a/helpcontent2 b/helpcontent2 index 5c476f480cdd..f654fc362e2c 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 5c476f480cddb8a6dd7b0020564953b22fe0660a +Subproject commit f654fc362e2ca75a1ff10b772f4b72065484fab2 ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: source/text
source/text/scalc/01/04060109.xhp | 92 ++
1 file changed, 92 insertions(+)
New commits:
commit f654fc362e2ca75a1ff10b772f4b72065484fab2
Author: Steve Fanning
AuthorDate: Thu Feb 4 15:07:17 2021 +0100
Commit: Olivier Hallot
CommitDate: Fri Feb 5 16:44:54 2021 +0100
Add Examples section to Help description for Calc's HLOOKUP function.
File 04060109.xhp
Change-Id: If5828bba9aec04564c9eab37f41731ac4d886c1a
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/110364
Reviewed-by: Olivier Hallot
Tested-by: Jenkins
diff --git a/source/text/scalc/01/04060109.xhp
b/source/text/scalc/01/04060109.xhp
index c695e9165..c571dc97a 100644
--- a/source/text/scalc/01/04060109.xhp
+++ b/source/text/scalc/01/04060109.xhp
@@ -458,6 +458,98 @@
HLOOKUP(SearchCriterion; Array; Index [;
SortedRangeLookup])
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”.
+
+
+
+ A
+
+
+ B
+
+
+ C
+
+
+ ...
+
+
+ DO4
+
+
+
+
+ Hydrogen
+
+
+ Helium
+
+
+ Lithium
+
+
+ ...
+
+
+ Oganesson
+
+
+
+
+ H
+
+
+ He
+
+
+ Li
+
+
+ ...
+
+
+ Og
+
+
+
+
+ 1
+
+
+ 2
+
+
+ 3
+
+
+ ...
+
+
+ 118
+
+
+
+
+ 1.008
+
+
+ 4.0026
+
+
+ 6.94
+
+
+ ...
+
+
+ 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.
ROW function
___
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit b57db736998a9dd0b5bb40e5fbee2871bf520f9c Author: Steve Fanning AuthorDate: Wed Feb 3 02:58:30 2021 +0100 Commit: Gerrit Code Review CommitDate: Wed Feb 3 02:58:30 2021 +0100 Update git submodules * Update helpcontent2 from branch 'master' to e5e4bb9f487ad1b1238d69254a4103ab303d6bb2 - Correct example given in Help file for Calc's DB function. The explanation of the example given is confusing. File 04060103.xhp is affected. Change-Id: I7658d4d0497f83c68b2d56cfe14da48c1fe16b04 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/110301 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index 13b1e7bca5e5..e5e4bb9f487a 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 13b1e7bca5e5860dbf4550949f514749a64e2d54 +Subproject commit e5e4bb9f487ad1b1238d69254a4103ab303d6bb2 ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: source/text
source/text/scalc/01/04060103.xhp |5 ++--- 1 file changed, 2 insertions(+), 3 deletions(-) New commits: commit e5e4bb9f487ad1b1238d69254a4103ab303d6bb2 Author: Steve Fanning AuthorDate: Wed Feb 3 00:32:58 2021 +0100 Commit: Olivier Hallot CommitDate: Wed Feb 3 02:58:30 2021 +0100 Correct example given in Help file for Calc's DB function. The explanation of the example given is confusing. File 04060103.xhp is affected. Change-Id: I7658d4d0497f83c68b2d56cfe14da48c1fe16b04 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/110301 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/source/text/scalc/01/04060103.xhp b/source/text/scalc/01/04060103.xhp index 75bfec5ba..bfc194e17 100644 --- a/source/text/scalc/01/04060103.xhp +++ b/source/text/scalc/01/04060103.xhp @@ -680,10 +680,9 @@ Month (optional) denotes the number of months for the first year of depreciation. If an entry is not defined, 12 is used as the default. - A computer system with an initial cost of 25,000 currency units is to be depreciated over a three year period. The salvage value is to be 1,000 currency units. One period is 30 days. + A computer system with an initial cost of 25,000 currency units is to be depreciated over a three-year period. The salvage value is to be 1,000 currency units. The first period of depreciation comprises 6 months. What is the fixed-declining balance depreciation of the computer system in the second period, which is a full year starting from the end of the first six-month period? -=DB(25000;1000;36;1;6) = 1,075.00 currency units - The fixed-declining depreciation of the computer system is 1,075.00 currency units. +=DB(25000; 1000; 3; 2; 6) returns 11,037.95 currency units. IRR function ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 083d1146e22319f208f42b098d329e7fdf4c3cae Author: Steve Fanning AuthorDate: Wed Feb 3 02:58:06 2021 +0100 Commit: Gerrit Code Review CommitDate: Wed Feb 3 02:58:06 2021 +0100 Update git submodules * Update helpcontent2 from branch 'master' to 13b1e7bca5e5860dbf4550949f514749a64e2d54 - Provide examples in the Help descriptions of Calc’s AMORDEGRC and AMORLINC functions. Relevant examples might be: =AMORDEGRC(2000; "2020-02-01"; "2020-12-31"; 10; 4; 0.1; 0) returns a depreciation amount of 163 currency units. =AMORLINC(2000; "2020-02-01"; "2020-12-31"; 10; 4; 0.1; 0) returns a depreciation amount of 200 currency units. File 04060103.xhp affected. Change-Id: I9161d974c00cfc30515fb1fcbe44aff09242f422 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/110300 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index 24f765784f3a..13b1e7bca5e5 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 24f765784f3a0e4d71df778da249b1f33841e460 +Subproject commit 13b1e7bca5e5860dbf4550949f514749a64e2d54 ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: source/text
source/text/scalc/01/04060103.xhp |8 1 file changed, 8 insertions(+) New commits: commit 13b1e7bca5e5860dbf4550949f514749a64e2d54 Author: Steve Fanning AuthorDate: Tue Feb 2 21:45:25 2021 +0100 Commit: Olivier Hallot CommitDate: Wed Feb 3 02:58:06 2021 +0100 Provide examples in the Help descriptions of Calc’s AMORDEGRC and AMORLINC functions. Relevant examples might be: =AMORDEGRC(2000; "2020-02-01"; "2020-12-31"; 10; 4; 0.1; 0) returns a depreciation amount of 163 currency units. =AMORLINC(2000; "2020-02-01"; "2020-12-31"; 10; 4; 0.1; 0) returns a depreciation amount of 200 currency units. File 04060103.xhp affected. Change-Id: I9161d974c00cfc30515fb1fcbe44aff09242f422 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/110300 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/source/text/scalc/01/04060103.xhp b/source/text/scalc/01/04060103.xhp index 7145fc474..75bfec5ba 100644 --- a/source/text/scalc/01/04060103.xhp +++ b/source/text/scalc/01/04060103.xhp @@ -58,6 +58,10 @@ Rate is the rate of depreciation. + + An asset was acquired on 2020-02-01 at a cost of 2000 currency units. The end date of the first settlement period was 2020-12-31. The salvage value of the asset at the end of its depreciable life will be 10 currency units. The rate of depreciation is 0.1 (10%) and the year is calculated using the US method (Basis 0). Assuming degressive depreciation, what is the amount of depreciation in the fourth depreciation period? + +=AMORDEGRC(2000; "2020-02-01"; "2020-12-31"; 10; 4; 0.1; 0) returns a depreciation amount of 163 currency units. AMORLINC function @@ -81,6 +85,10 @@ Rate is the rate of depreciation. + + An asset was acquired on 2020-02-01 at a cost of 2000 currency units. The end date of the first settlement period was 2020-12-31. The salvage value of the asset at the end of its depreciable life will be 10 currency units. The rate of depreciation is 0.1 (10%) and the year is calculated using the US method (Basis 0). Assuming linear depreciation, what is the amount of depreciation in the fourth depreciation period? + +=AMORLINC(2000; "2020-02-01"; "2020-12-31"; 10; 4; 0.1; 0) returns a depreciation amount of 200 currency units. ACCRINT function ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 6cee751a004e854287837241846203b9f77c971b Author: Steve Fanning AuthorDate: Wed Feb 3 02:49:34 2021 +0100 Commit: Gerrit Code Review CommitDate: Wed Feb 3 02:49:34 2021 +0100 Update git submodules * Update helpcontent2 from branch 'master' to 24f765784f3a0e4d71df778da249b1f33841e460 - Clarify default values in Help description for Calc’s ACCRINTM function. Specifically, the description of the Par argument should match the corresponding description for the ACCRINT function. It should also include the pinned note that the default applied is an arbitrary value and should perhaps be avoided. File 04060103.xhp affected. Change-Id: Ieaf0d3eb23c989ee05e856146c0af3ad720a4fb2 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/110297 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index ca492b44070a..24f765784f3a 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit ca492b44070afd6338c18efd4fdf595e51155254 +Subproject commit 24f765784f3a0e4d71df778da249b1f33841e460 ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: source/text
source/text/scalc/01/04060103.xhp |3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) New commits: commit 24f765784f3a0e4d71df778da249b1f33841e460 Author: Steve Fanning AuthorDate: Tue Feb 2 21:12:44 2021 +0100 Commit: Olivier Hallot CommitDate: Wed Feb 3 02:49:34 2021 +0100 Clarify default values in Help description for Calc’s ACCRINTM function. Specifically, the description of the Par argument should match the corresponding description for the ACCRINT function. It should also include the pinned note that the default applied is an arbitrary value and should perhaps be avoided. File 04060103.xhp affected. Change-Id: Ieaf0d3eb23c989ee05e856146c0af3ad720a4fb2 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/110297 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/source/text/scalc/01/04060103.xhp b/source/text/scalc/01/04060103.xhp index c4f98fe89..7145fc474 100644 --- a/source/text/scalc/01/04060103.xhp +++ b/source/text/scalc/01/04060103.xhp @@ -127,7 +127,8 @@ Rate (required) is the annual nominal rate of interest (coupon interest rate). -Par (optional) is the par value of the security. +Par (optional) is the par value of the security. If omitted, a default value of 1000 is used. + We recommend that you always specify the value that you require for ACCRINTM’s Par argument, rather than allowing Calc to apply an arbitrary default. This will make your formula easier to understand and easier to maintain. A security is issued on 2001-04-01. The maturity date is set for 2001-06-15. The Rate is 0.1 or 10% and Par is 1000 currency units. The basis of the daily/annual calculation is the daily balance (3). How much interest has accrued? ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 51220f978347877485653dd02043cd9b166af761 Author: Steve Fanning AuthorDate: Tue Feb 2 11:49:40 2021 +0100 Commit: Gerrit Code Review CommitDate: Tue Feb 2 11:49:40 2021 +0100 Update git submodules * Update helpcontent2 from branch 'master' to 61f062fa0c0f33bb2578ebf04537d3db2129c7be - Correct errors in the Help description for Calc’s SKEWP function. Specifically, the given return value for the first two examples is wrong (should be 0.2329985562). The third and fourth examples do not describe the implemented behavior but, since the description already states that the parameters should specify at least three values, these examples should be deleted rather than corrected. The only file affected is func_skewp.xhp. Change-Id: I1951d81e3cbb52562b12defa4683ee8b65adef51 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/110292 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index a14906302a55..61f062fa0c0f 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit a14906302a559fdd49efdd22444dea1643924fda +Subproject commit 61f062fa0c0f33bb2578ebf04537d3db2129c7be ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: source/text
source/text/scalc/01/func_skewp.xhp |7 ++-
1 file changed, 2 insertions(+), 5 deletions(-)
New commits:
commit 61f062fa0c0f33bb2578ebf04537d3db2129c7be
Author: Steve Fanning
AuthorDate: Tue Feb 2 00:06:06 2021 +0100
Commit: Olivier Hallot
CommitDate: Tue Feb 2 11:49:40 2021 +0100
Correct errors in the Help description for Calc’s SKEWP function.
Specifically, the given return value for the first two examples is wrong
(should be 0.2329985562). The third and fourth examples do not describe the
implemented behavior but, since the description already states that the
parameters should specify at least three values, these examples should be
deleted rather than corrected.
The only file affected is func_skewp.xhp.
Change-Id: I1951d81e3cbb52562b12defa4683ee8b65adef51
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/110292
Tested-by: Jenkins
Reviewed-by: Olivier Hallot
diff --git a/source/text/scalc/01/func_skewp.xhp
b/source/text/scalc/01/func_skewp.xhp
index e87b514ff..23b7f93e7 100644
--- a/source/text/scalc/01/func_skewp.xhp
+++ b/source/text/scalc/01/func_skewp.xhp
@@ -41,11 +41,8 @@
The
parameters should specify at least three values.
-SKEWP(2;3;1;6;8;5) returns 0.2828158928
-
-SKEWP(A1:A6) returns 0.2828158928, when the range A1:A6
contains {2;3;1;6;8;5}
-SKEWP(Number1; Number2) always returns zero, if Number1
and Number2 results in two numbers.
-SKEWP(Number1) returns Err:502 (Invalid argument) if
Number1 results in one number, because SKEWP cannot be calculated with one
value.
+SKEWP(2;3;1;6;8;5) returns
0.2329985562
+SKEWP(A1:A6) returns 0.2329985562, when the
range A1:A6 contains {2;3;1;6;8;5}
SKEW
___
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit e8a08d5029bd8feb0007db6eb23fb836ebe40e05 Author: Steve Fanning AuthorDate: Mon Feb 1 13:32:18 2021 +0100 Commit: Gerrit Code Review CommitDate: Mon Feb 1 13:32:18 2021 +0100 Update git submodules * Update helpcontent2 from branch 'master' to 72d86f8f5095060dfc8825a0d8cbd91aca127db3 - Correct misleading statement in Help description of Calc’s GAMMA.DIST function. Specifically, the function is NOT identical to GAMMADIST. Also change name of fourth parameter from C to Cumulative to match the name used in the Function Wizard. Affects only file 04060182.xhp. Change-Id: I9133b66897ccd5d611aadf452af041b682e6d4d2 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/110225 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index c5873df9d618..72d86f8f5095 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit c5873df9d618a297c3fd0e5cbd77aed5025a22b5 +Subproject commit 72d86f8f5095060dfc8825a0d8cbd91aca127db3 ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: source/text
source/text/scalc/01/04060182.xhp |6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) New commits: commit 72d86f8f5095060dfc8825a0d8cbd91aca127db3 Author: Steve Fanning AuthorDate: Mon Feb 1 12:12:53 2021 +0100 Commit: Olivier Hallot CommitDate: Mon Feb 1 13:32:18 2021 +0100 Correct misleading statement in Help description of Calc’s GAMMA.DIST function. Specifically, the function is NOT identical to GAMMADIST. Also change name of fourth parameter from C to Cumulative to match the name used in the Function Wizard. Affects only file 04060182.xhp. Change-Id: I9133b66897ccd5d611aadf452af041b682e6d4d2 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/110225 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/source/text/scalc/01/04060182.xhp b/source/text/scalc/01/04060182.xhp index a3985e327..fea713ec0 100644 --- a/source/text/scalc/01/04060182.xhp +++ b/source/text/scalc/01/04060182.xhp @@ -306,14 +306,14 @@ GAMMA.DIST Returns the values of a Gamma distribution. The inverse function is GAMMAINV or GAMMA.INV. -This function is identical to GAMMADIST and was introduced for interoperability with other office suites. +This function is similar to GAMMADIST and was introduced for interoperability with other office suites. -GAMMA.DIST(Number; Alpha; Beta; C) +GAMMA.DIST(Number; Alpha; Beta; Cumulative) Number is the value for which the Gamma distribution is to be calculated. Alpha is the parameter Alpha of the Gamma distribution. Beta is the parameter Beta of the Gamma distribution. -C (optional) = 0 or False calculates the density function C = 1 or True calculates the distribution. +Cumulative = 0 or False calculates the probability density function; Cumulative = 1, True, or any other value calculates the cumulative distribution function. =GAMMA.DIST(2;1;1;1) yields 0.86. ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 7b1bafb54de236857d07224815b26b20db413a09 Author: Steve Fanning AuthorDate: Mon Feb 1 13:30:42 2021 +0100 Commit: Gerrit Code Review CommitDate: Mon Feb 1 13:30:42 2021 +0100 Update git submodules * Update helpcontent2 from branch 'master' to c5873df9d618a297c3fd0e5cbd77aed5025a22b5 - Fix typos in Help description of Calc’s MINIFS function. Specifically, in the section entitled “Using regular expressions and nested functions”. Affects file func_minifs.xhp. Change-Id: I843c13711c4eac7174ec3e3c500a2a52c65b9c40 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/110224 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index d0fc83f26f01..c5873df9d618 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit d0fc83f26f01b117d1ff4ef704332667834f0ae0 +Subproject commit c5873df9d618a297c3fd0e5cbd77aed5025a22b5 ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: source/text
source/text/scalc/01/func_minifs.xhp |6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) New commits: commit c5873df9d618a297c3fd0e5cbd77aed5025a22b5 Author: Steve Fanning AuthorDate: Mon Feb 1 11:46:57 2021 +0100 Commit: Olivier Hallot CommitDate: Mon Feb 1 13:30:42 2021 +0100 Fix typos in Help description of Calc’s MINIFS function. Specifically, in the section entitled “Using regular expressions and nested functions”. Affects file func_minifs.xhp. Change-Id: I843c13711c4eac7174ec3e3c500a2a52c65b9c40 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/110224 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/source/text/scalc/01/func_minifs.xhp b/source/text/scalc/01/func_minifs.xhp index 2fbb087a1..096e404fb 100644 --- a/source/text/scalc/01/func_minifs.xhp +++ b/source/text/scalc/01/func_minifs.xhp @@ -47,9 +47,9 @@ Calculates the minimum of values of the range C2:C6 that are lower than 90 and correspond to cells of the B2:B6 range with values greater than or equal to 20. Returns 190. Using regular expressions and nested functions =MINIFS(C2:C6;B2:B6;""MIN(B2:B6);B2:B6;""MAX(B2:B6)) -Calculates the minimum of values of the range C2:C6 that correspond to all values of the range B2:B6 except its minimum and minimum. Returns 65. -=MINIFS(C2:C6;A2:A6;".*book";B2:B6;"="MAX(B2:B6)) -Calculates the minimum of values of the range C2:C6 that correspond to all cells of the A2:A6 range starting with "pen" and to all cells of the B2:B6 range except its minimum. Returns 180. +Calculates the minimum of values of the range C2:C6 that correspond to all values of the range B2:B6 except its minimum and maximum. Returns 65. +=MINIFS(C2:C6;A2:A6;".*book";B2:B6;""MIN(B2:B6)) +Calculates the minimum of values of the range C2:C6 that correspond to all cells of the A2:A6 range ending with "book" and to all cells of the B2:B6 range except its minimum. Returns 190. Reference to a cell as a criterion If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of the MINIFS function. For example, the above function can be rewritten as follows: =MINIFS(C2:C6;A2:A6;".*"E2;B2:B6;""MAX(B2:B6)) ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 90453ae0656d122ca43d30eb4d21f2ba5ef9438a Author: Steve Fanning AuthorDate: Mon Feb 1 13:29:01 2021 +0100 Commit: Gerrit Code Review CommitDate: Mon Feb 1 13:29:01 2021 +0100 Update git submodules * Update helpcontent2 from branch 'master' to d0fc83f26f01b117d1ff4ef704332667834f0ae0 - Incorrect default specified for Cumulative argument in Help description of Calc’s HYPGEOMDIST function. The implemented default is value 0 (FALSE) which gives the probability mass function. This is in accordance with ODF 1.2 but contrary to the Help description. The only file affected is 04060182.xhp. Change-Id: I3da1818abcdcb71e778e914d348a4f356934f6ab Reviewed-on: https://gerrit.libreoffice.org/c/help/+/110219 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index 8073a8b88185..d0fc83f26f01 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 8073a8b8818563205779c8123ab243c8078b8708 +Subproject commit d0fc83f26f01b117d1ff4ef704332667834f0ae0 ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: source/text
source/text/scalc/01/04060182.xhp |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit d0fc83f26f01b117d1ff4ef704332667834f0ae0 Author: Steve Fanning AuthorDate: Sun Jan 31 21:46:40 2021 +0100 Commit: Olivier Hallot CommitDate: Mon Feb 1 13:29:01 2021 +0100 Incorrect default specified for Cumulative argument in Help description of Calc’s HYPGEOMDIST function. The implemented default is value 0 (FALSE) which gives the probability mass function. This is in accordance with ODF 1.2 but contrary to the Help description. The only file affected is 04060182.xhp. Change-Id: I3da1818abcdcb71e778e914d348a4f356934f6ab Reviewed-on: https://gerrit.libreoffice.org/c/help/+/110219 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/source/text/scalc/01/04060182.xhp b/source/text/scalc/01/04060182.xhp index b6a78433b..a3985e327 100644 --- a/source/text/scalc/01/04060182.xhp +++ b/source/text/scalc/01/04060182.xhp @@ -429,7 +429,7 @@ Successes is the number of possible results in the total population. NPopulation is the size of the total population. -Cumulative (optional) specifies whether to calculate the probability density function (FALSE or 0) or the cumulative distribution function (any other value). The cumulative distribution function is the default if no value is specified for this parameter. +Cumulative (optional) specifies whether to calculate the probability mass function (FALSE or 0) or the cumulative distribution function (any other value). The probability mass function is the default if no value is specified for this parameter. =HYPGEOMDIST(2;2;90;100) yields 0.81. If 90 out of 100 pieces of buttered toast fall from the table and hit the floor with the buttered side first, then if 2 pieces of buttered toast are dropped from the table, the probability is 81%, that both will strike buttered side first. ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] core.git: helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 71df6cc63efa780d7e8c710359427664c1d34239 Author: Steve Fanning AuthorDate: Sun Jan 31 22:00:56 2021 +0100 Commit: Gerrit Code Review CommitDate: Sun Jan 31 22:00:56 2021 +0100 Update git submodules * Update helpcontent2 from branch 'master' to 1da6d6d94d094a16dc9f3081b1aae879e04190c0 - Syntax given in Help file for Calc’s POISSON.DIST function is incorrect (see Bug 137747). Specifically, the third argument (“C”), whose purpose is to distinguish between the probability mass function (zero value for C) and the cumulative distribution function (non-zero value for C), is NOT optional but is required. The change affects only one file, 04060184.xhp. Change-Id: I9afbdb38b98ff2452a89861a4415ae10fa94d40e Reviewed-on: https://gerrit.libreoffice.org/c/help/+/110148 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/helpcontent2 b/helpcontent2 index 5fd683cd1c13..1da6d6d94d09 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 5fd683cd1c13cc20d0c7205c895b4e5ca1c39196 +Subproject commit 1da6d6d94d094a16dc9f3081b1aae879e04190c0 ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: source/text
source/text/scalc/01/04060184.xhp |4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) New commits: commit 1da6d6d94d094a16dc9f3081b1aae879e04190c0 Author: Steve Fanning AuthorDate: Sat Jan 30 21:35:53 2021 +0100 Commit: Olivier Hallot CommitDate: Sun Jan 31 22:00:56 2021 +0100 Syntax given in Help file for Calc’s POISSON.DIST function is incorrect (see Bug 137747). Specifically, the third argument (“C”), whose purpose is to distinguish between the probability mass function (zero value for C) and the cumulative distribution function (non-zero value for C), is NOT optional but is required. The change affects only one file, 04060184.xhp. Change-Id: I9afbdb38b98ff2452a89861a4415ae10fa94d40e Reviewed-on: https://gerrit.libreoffice.org/c/help/+/110148 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/source/text/scalc/01/04060184.xhp b/source/text/scalc/01/04060184.xhp index 8134dd9f4..4cc4f0ec5 100644 --- a/source/text/scalc/01/04060184.xhp +++ b/source/text/scalc/01/04060184.xhp @@ -365,10 +365,10 @@ Returns the Poisson distribution. -POISSON.DIST(Number; Mean [; C]) +POISSON.DIST(Number; Mean ; Cumulative) Number represents the value based on which the Poisson distribution is calculated. Mean represents the middle value of the Poisson distribution. -C (optional) = 0 or False calculates the density function; C = 1 or True calculates the distribution. When omitted, the default value True is inserted when you save the document, for best compatibility with other programs and older versions of %PRODUCTNAME. +Cumulative = 0 or False to calculate the probability mass function; Cumulative = 1, True, or any other non-zero value to calculate the cumulative distribution function. =POISSON.DIST(60;50;1) returns 0.9278398202. ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] core.git: 2 commits - helpcontent2 sw/source
helpcontent2 |2 +-
sw/source/uibase/docvw/AnnotationWin2.cxx |1 -
2 files changed, 1 insertion(+), 2 deletions(-)
New commits:
commit 8c2f1af09eff833a6c9e2a090c9d7e9c113b1803
Author: Steve Fanning
AuthorDate: Sun Jan 31 17:33:30 2021 +0100
Commit: Gerrit Code Review
CommitDate: Sun Jan 31 17:33:30 2021 +0100
Update git submodules
* Update helpcontent2 from branch 'master'
to c0f70b871b7a558f5f7de355e6e18636cd90ac93
- The syntax given in the Help file for Calc’s LOGNORM.INV function is
incorrect (see Bug 137649). Specifically, the second (“Mean”) and third
(“StDev”) arguments are optional rather than required in Calc’s current
implementation. If omitted the Mean argument defaults to 0.0 and the StDev
argument defaults to 1.0.
Note: The corresponding Excel function’s three arguments are all
required (none are optional) and so one possible outcome of Bug 137649 is for
Calc to be updated to match this behaviour for interoperability. However, we do
not know if or when this might happen and so, in the meantime, I propose to
update the Help to more accurately reflect Calc’s current behaviour.
The change affects only one file, 04060183.xhp.
Change-Id: I69934a8123d5de41007bc4dfca1cbc478ed963a6
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/110150
Tested-by: Jenkins
Reviewed-by: Olivier Hallot
diff --git a/helpcontent2 b/helpcontent2
index 237f36ae2e8a..c0f70b871b7a 16
--- a/helpcontent2
+++ b/helpcontent2
@@ -1 +1 @@
-Subproject commit 237f36ae2e8aa995f12c1227114838d8dcd42f8e
+Subproject commit c0f70b871b7a558f5f7de355e6e18636cd90ac93
commit eaa632c5c80d9cb0eec2f0f7ba92f5bac72ba50d
Author: Caolán McNamara
AuthorDate: Fri Jan 29 16:20:36 2021 +
Commit: Caolán McNamara
CommitDate: Sun Jan 31 17:33:21 2021 +0100
drop call to SetQuickHelpText() with empty string
because the QuickHelp is never set to anything non-empty.
Before commit
commit c230e962ca2c876187a028fa14426210b5746a0f
Date: Tue Jan 12 10:43:45 2010 +0100
sw33a11y01: #i88070# refactoring of sidebar window code used for
visualization of comments/annotations
SetQuickHelpText was called with a non-empty string in one branch
so SetQuickHelpText cleared it again, but now its always empty
Change-Id: If4635e899b27ce16fd0aa25254f33415142f9718
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/110165
Tested-by: Jenkins
Reviewed-by: Caolán McNamara
diff --git a/sw/source/uibase/docvw/AnnotationWin2.cxx
b/sw/source/uibase/docvw/AnnotationWin2.cxx
index 46376d0b2506..d093ed61508b 100644
--- a/sw/source/uibase/docvw/AnnotationWin2.cxx
+++ b/sw/source/uibase/docvw/AnnotationWin2.cxx
@@ -893,7 +893,6 @@ void SwAnnotationWin::DoResize()
mpMetadataAuthor->Show();
if(IsResolved()) { mpMetadataResolved->Show(); }
mpMetadataDate->Show();
-mpSidebarTextControl->SetQuickHelpText(OUString());
unsigned int numFields = GetNumFields();
if (aTextHeight > aHeight)
{ // we need vertical scrollbars and have to reduce the width
___
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: Branch 'libreoffice-7-0' - source/text
source/text/scalc/01/04060103.xhp |3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) New commits: commit 13eadf6de9cc483db44c399feb6a657fe8fde2a3 Author: Steve Fanning AuthorDate: Wed Jun 3 10:05:24 2020 +0200 Commit: Olivier Hallot CommitDate: Mon Jun 8 19:04:04 2020 +0200 Improve help information for ACCRINT() function to better explain the behaviour of the Par argument. Change-Id: Ia1fb54abe828dc9d0310e83f9552099759b96d40 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95329 Tested-by: Jenkins Reviewed-by: Olivier Hallot (cherry picked from commit e04a83713f38be33d0c51cc35d0c457919a3f213) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95739 Reviewed-by: Ilmari Lauhakangas diff --git a/source/text/scalc/01/04060103.xhp b/source/text/scalc/01/04060103.xhp index 8a8efbffb..549aba1ea 100644 --- a/source/text/scalc/01/04060103.xhp +++ b/source/text/scalc/01/04060103.xhp @@ -101,7 +101,8 @@ Rate (required) is the annual nominal rate of interest (coupon interest rate) -Par (optional) is the par value of the security. +Par (optional) is the par value of the security. If omitted, a default value of 1000 is used. + We recommend that you always specify the value that you require for ACCRINT’s Par argument, rather than allowing Calc to apply an arbitrary default. This will make your formula easier to understand and easier to maintain. Frequency (required) is the number of interest payments per year (1, 2 or 4). ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] core.git: Branch 'libreoffice-7-0' - helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 259ba438544d44914194114642bab2650c3fd49c Author: Steve Fanning AuthorDate: Mon Jun 8 19:04:04 2020 +0200 Commit: Gerrit Code Review CommitDate: Mon Jun 8 19:04:04 2020 +0200 Update git submodules * Update helpcontent2 from branch 'libreoffice-7-0' to 13eadf6de9cc483db44c399feb6a657fe8fde2a3 - Improve help information for ACCRINT() function to better explain the behaviour of the Par argument. Change-Id: Ia1fb54abe828dc9d0310e83f9552099759b96d40 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95329 Tested-by: Jenkins Reviewed-by: Olivier Hallot (cherry picked from commit e04a83713f38be33d0c51cc35d0c457919a3f213) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95739 Reviewed-by: Ilmari Lauhakangas diff --git a/helpcontent2 b/helpcontent2 index 4a23b97189fc..13eadf6de9cc 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 4a23b97189fc671c10d8ab42c1fc53946247cf8f +Subproject commit 13eadf6de9cc483db44c399feb6a657fe8fde2a3 ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: Branch 'libreoffice-7-0' - source/text
source/text/scalc/01/ful_func.xhp | 28 ++-- 1 file changed, 14 insertions(+), 14 deletions(-) New commits: commit 4a23b97189fc671c10d8ab42c1fc53946247cf8f Author: Steve Fanning AuthorDate: Mon Jun 1 17:17:05 2020 +0200 Commit: Olivier Hallot CommitDate: Mon Jun 8 19:03:43 2020 +0200 (ful_func.xhp) Update common defintions for lengthy argument lists, to contain more white space and give greater consistency across Calc functions. Change-Id: I053486715c5cb8f0687b6b02c218e470db163b8d Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95249 Tested-by: Jenkins Reviewed-by: Olivier Hallot (cherry picked from commit e10bfae45bc138b0c2351a7cb6bd3cc591bea388) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95738 Reviewed-by: Ilmari Lauhakangas diff --git a/source/text/scalc/01/ful_func.xhp b/source/text/scalc/01/ful_func.xhp index 642a2bf00..d53e5fd81 100644 --- a/source/text/scalc/01/ful_func.xhp +++ b/source/text/scalc/01/ful_func.xhp @@ -46,33 +46,33 @@ The result is presented in the string format and has the character "i" or "j" as an imaginary unit. 255 arguments -String 1[; String 2][; … ;[String 255]] +String 1 [; String 2 [; … [; String 255]]] -String 1[; String 2][; … ;[String 255]] are strings, references to cells or to cell ranges of strings. +String 1, String 2, … , String 255 are strings, references to cells or to cell ranges of strings. -Integer 1[; Integer 2][; … ;[Integer 255]] +Integer 1 [; Integer 2 [; … [; Integer 255]]] -Integer 1[; Integer 2][; … ;[Integer 255]] are integers, references to cells or to cell ranges of integers. +Integer 1, Integer 2, … , Integer 255 are integers, references to cells or to cell ranges of integers. -Number 1[; Number 2][; … ;[Number 254]] +Number 1 [; Number 2 [; … [; Number 254]]] -Number 1[; Number 2][; … ;[Number 254]] are numbers, references to cells or to cell ranges of numbers. +Number 1, Number 2, … , Number 254 are numbers, references to cells or to cell ranges of numbers. -Number 1[; Number 2][; … ;[Number 255]] +Number 1 [; Number 2 [; … [; Number 255]]] -Number 1[; Number 2][; … ;[Number 255]] are numbers, references to cells or to cell ranges of numbers. +Number 1, Number 2, … , Number 255 are numbers, references to cells or to cell ranges of numbers. -Logical 1[; Logical 2][; … ;[Logical 255]] +Logical 1 [; Logical 2 [; … [; Logical 255]]] -Logical 1[; Logical 2][; … ;[Logical 255]] are boolean values, references to cells or to cell ranges of logical values. +Logical 1, Logical 2, … , Logical 255 are boolean values, references to cells or to cell ranges of logical values. -Complex 1[; Complex 2][; … ;[Complex 255]] +Complex 1 [; Complex 2 [; … [; Complex 255]]] -Complex 1[; Complex 2][; … ;[Complex 255]] are complex numbers, references to cells or to cell ranges of complex numbers. Complex numbers are entered in the form "x+yi" or "x+yj". +Complex 1, Complex 2, … ,Complex 255 are complex numbers, references to cells or to cell ranges of complex numbers. Complex numbers are entered in the form "x+yi" or "x+yj". -Reference 1[; Reference 2][; … ;[Reference 255]] +Reference 1 [; Reference 2 [; … [; Reference 255]]] -Reference 1[; Reference 2][; … ;[Reference 255]] are references to cells. +Reference 1, Reference 2, … ,Reference 255 are references to cells. ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] core.git: Branch 'libreoffice-7-0' - helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 6ae8c8f3b4bc7306a4e90782d72f0c33d02f616b Author: Steve Fanning AuthorDate: Mon Jun 8 19:03:43 2020 +0200 Commit: Gerrit Code Review CommitDate: Mon Jun 8 19:03:43 2020 +0200 Update git submodules * Update helpcontent2 from branch 'libreoffice-7-0' to 4a23b97189fc671c10d8ab42c1fc53946247cf8f - (ful_func.xhp) Update common defintions for lengthy argument lists, to contain more white space and give greater consistency across Calc functions. Change-Id: I053486715c5cb8f0687b6b02c218e470db163b8d Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95249 Tested-by: Jenkins Reviewed-by: Olivier Hallot (cherry picked from commit e10bfae45bc138b0c2351a7cb6bd3cc591bea388) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95738 Reviewed-by: Ilmari Lauhakangas diff --git a/helpcontent2 b/helpcontent2 index bebcf798e754..4a23b97189fc 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit bebcf798e7547283a9dd5fbad44d9bfe3847ddb3 +Subproject commit 4a23b97189fc671c10d8ab42c1fc53946247cf8f ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] core.git: Branch 'libreoffice-7-0' - helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 1c2b704cf441cbe80d4cd468a41a8c9c0bda9870 Author: Steve Fanning AuthorDate: Mon Jun 8 19:02:55 2020 +0200 Commit: Gerrit Code Review CommitDate: Mon Jun 8 19:02:55 2020 +0200 Update git submodules * Update helpcontent2 from branch 'libreoffice-7-0' to a7337c9922374b225595776e7b5ab9f87c9e2856 - (04060185.xhp) Include square brackets in syntax sections to indicate optional parameters. Change-Id: I8d099d9babe118c7592b060027dd037e9fbdadaf Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95245 Tested-by: Jenkins Reviewed-by: Olivier Hallot (cherry picked from commit 79dfc48af63b0834aee096c65f92f1bc96fc1b6c) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95736 Reviewed-by: Ilmari Lauhakangas diff --git a/helpcontent2 b/helpcontent2 index 4a8b7a806112..a7337c992237 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 4a8b7a806112d636b17436bd8d74ddcdbfba +Subproject commit a7337c9922374b225595776e7b5ab9f87c9e2856 ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: Branch 'libreoffice-7-0' - source/text
source/text/scalc/01/04060185.xhp |8 1 file changed, 4 insertions(+), 4 deletions(-) New commits: commit a7337c9922374b225595776e7b5ab9f87c9e2856 Author: Steve Fanning AuthorDate: Mon Jun 1 11:47:38 2020 +0200 Commit: Olivier Hallot CommitDate: Mon Jun 8 19:02:55 2020 +0200 (04060185.xhp) Include square brackets in syntax sections to indicate optional parameters. Change-Id: I8d099d9babe118c7592b060027dd037e9fbdadaf Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95245 Tested-by: Jenkins Reviewed-by: Olivier Hallot (cherry picked from commit 79dfc48af63b0834aee096c65f92f1bc96fc1b6c) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95736 Reviewed-by: Ilmari Lauhakangas diff --git a/source/text/scalc/01/04060185.xhp b/source/text/scalc/01/04060185.xhp index 1243793dd..65bfaec40 100644 --- a/source/text/scalc/01/04060185.xhp +++ b/source/text/scalc/01/04060185.xhp @@ -38,7 +38,7 @@ RANK Returns the rank of a number in a sample. - RANK(Value; Data; Type) + RANK(Value; Data [; Type]) Value is the value, whose rank is to be determined. @@ -62,7 +62,7 @@ The difference between RANK.AVG and RANK.EQ occurs when there are duplicates in the list of values. The RANK.EQ function returns the lower rank, whereas the RANK.AVG function returns the average rank. -RANK.AVG(Value; Data; Type) +RANK.AVG(Value; Data [; Type]) Value is the value, whose rank is to be determined. Data is the array or range of data in the sample. Type (optional) is the sequence order. @@ -82,7 +82,7 @@ The difference between RANK.AVG and RANK.EQ occurs when there are duplicates in the list of values. The RANK.EQ function returns the lower rank, whereas the RANK.AVG function returns the average rank. -RANK.EQ(Value; Data; Type) +RANK.EQ(Value; Data [; Type]) Value is the value, whose rank is to be determined. Data is the array or range of data in the sample. Type (optional) is the sequence order. @@ -665,7 +665,7 @@ PROB Returns the probability that values in a range are between two limits. If there is no End value, this function calculates the probability based on the principle that the Data values are equal to the value of Start. - PROB(Data; Probability; Start; End) + PROB(Data; Probability; Start [; End]) Data is the array or range of data in the sample. ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] core.git: Branch 'libreoffice-7-0' - helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit f330a6f52f5d08f296e06b0720fbad5efc7f94b4 Author: Steve Fanning AuthorDate: Mon Jun 8 19:02:22 2020 +0200 Commit: Gerrit Code Review CommitDate: Mon Jun 8 19:02:22 2020 +0200 Update git submodules * Update helpcontent2 from branch 'libreoffice-7-0' to 4a8b7a806112d636b17436bd8d74ddcdbfba - (04060184.xhp) Include square brackets in syntax sections to indicate optional parameters. Change-Id: I20270c2acaa2d9f9957691ce3452986d35126a0e Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95243 Tested-by: Jenkins Reviewed-by: Olivier Hallot (cherry picked from commit 427ff3dd99a459af6a3f911ad5b23f94d91b4a62) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95735 Reviewed-by: Ilmari Lauhakangas diff --git a/helpcontent2 b/helpcontent2 index 7256f3ddd4b6..4a8b7a806112 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 7256f3ddd4b6a199ab32278ff727b766cf866fc5 +Subproject commit 4a8b7a806112d636b17436bd8d74ddcdbfba ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: Branch 'libreoffice-7-0' - source/text
source/text/scalc/01/04060184.xhp | 12 ++-- 1 file changed, 6 insertions(+), 6 deletions(-) New commits: commit 4a8b7a806112d636b17436bd8d74ddcdbfba Author: Steve Fanning AuthorDate: Mon Jun 1 11:39:23 2020 +0200 Commit: Olivier Hallot CommitDate: Mon Jun 8 19:02:22 2020 +0200 (04060184.xhp) Include square brackets in syntax sections to indicate optional parameters. Change-Id: I20270c2acaa2d9f9957691ce3452986d35126a0e Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95243 Tested-by: Jenkins Reviewed-by: Olivier Hallot (cherry picked from commit 427ff3dd99a459af6a3f911ad5b23f94d91b4a62) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95735 Reviewed-by: Ilmari Lauhakangas diff --git a/source/text/scalc/01/04060184.xhp b/source/text/scalc/01/04060184.xhp index c62fafdd3..8134dd9f4 100644 --- a/source/text/scalc/01/04060184.xhp +++ b/source/text/scalc/01/04060184.xhp @@ -279,7 +279,7 @@ NORMDIST Returns the density function or the normal cumulative distribution. -NORMDIST(Number; Mean; StDev; C) +NORMDIST(Number; Mean; StDev [; C]) Number is the value of the distribution based on which the normal distribution is to be calculated. Mean is the mean value of the distribution. StDev is the standard deviation of the distribution. @@ -348,7 +348,7 @@ POISSON Returns the Poisson distribution. -POISSON(Number; Mean; C) +POISSON(Number; Mean [; C]) Number represents the value based on which the Poisson distribution is calculated. Mean represents the middle value of the Poisson distribution. C (optional) = 0 or False calculates the density function; C = 1 or True calculates the distribution. When omitted, the default value True is inserted when you save the document, for best compatibility with other programs and older versions of %PRODUCTNAME. @@ -365,7 +365,7 @@ Returns the Poisson distribution. -POISSON.DIST(Number; Mean; C) +POISSON.DIST(Number; Mean [; C]) Number represents the value based on which the Poisson distribution is calculated. Mean represents the middle value of the Poisson distribution. C (optional) = 0 or False calculates the density function; C = 1 or True calculates the distribution. When omitted, the default value True is inserted when you save the document, for best compatibility with other programs and older versions of %PRODUCTNAME. @@ -424,7 +424,7 @@ PERCENTRANK Returns the percentage rank of a value in a sample. -PERCENTRANK(Data; Value; Significance) +PERCENTRANK(Data; Value [; Significance]) Data represents the array of data in the sample. Value represents the value whose percentile rank must be determined. Significance An optional argument that specifies the number of significant digits that the returned percentage value is rounded to. If omitted, a value of 3 is used. @@ -440,7 +440,7 @@ The difference between PERCENTRANK.INC and PERCENTRANK.EXC is that PERCENTRANK.INC calculates a value in the range 0 to 1 inclusive, whereas the PERCENTRANK.EXC function calculates a value in the range 0 to 1 exclusive. -PERCENTRANK.EXC(Data; Value; Significance) +PERCENTRANK.EXC(Data; Value [; Significance]) Data represents the array of data in the sample. Value represents the value whose percentile rank must be determined. Significance An optional argument that specifies the number of significant digits that the returned percentage value is rounded to. @@ -455,7 +455,7 @@ The difference between PERCENTRANK.INC and PERCENTRANK.EXC is that PERCENTRANK.INC calculates a value in the range 0 to 1 inclusive, whereas the PERCENTRANK.EXC function calculates a value in the range 0 to 1 exclusive. -PERCENTRANK.INC(Data; Value; Significance) +PERCENTRANK.INC(Data; Value [; Significance]) Data represents the array of data in the sample. Value represents the value whose percentile rank must be determined. Significance An optional argument that specifies the number of significant digits that the returned percentage value is rounded to. ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: Branch 'libreoffice-7-0' - source/text
source/text/scalc/01/04060183.xhp |4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) New commits: commit 7256f3ddd4b6a199ab32278ff727b766cf866fc5 Author: Steve Fanning AuthorDate: Mon Jun 1 11:33:26 2020 +0200 Commit: Olivier Hallot CommitDate: Mon Jun 8 18:58:23 2020 +0200 (04060183.xhp) Include square brackets in syntax sections to indicate optional parameters. Change-Id: I53c9d01dfd75cdab6bac7284b2d775d36a1d9311 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95241 Tested-by: Jenkins Reviewed-by: Olivier Hallot (cherry picked from commit 57145b91d3e06b07d714e65e00d9e19626dbca52) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95734 Reviewed-by: Ilmari Lauhakangas diff --git a/source/text/scalc/01/04060183.xhp b/source/text/scalc/01/04060183.xhp index e3cf9d24a..cc5039eef 100644 --- a/source/text/scalc/01/04060183.xhp +++ b/source/text/scalc/01/04060183.xhp @@ -223,7 +223,7 @@ LOGINV Returns the inverse of the lognormal distribution. -LOGINV(Number; Mean; StDev) +LOGINV(Number [; Mean [; StDev]]) Number is the probability value for which the inverse standard logarithmic distribution is to be calculated. @@ -263,7 +263,7 @@ LOGNORMDIST Returns the values of a lognormal distribution. -LOGNORMDIST(Number; Mean; StDev; Cumulative) +LOGNORMDIST(Number [; Mean [; StDev [; Cumulative]]]) Number is the probability value for which the standard logarithmic distribution is to be calculated. ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] core.git: Branch 'libreoffice-7-0' - helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 8857d8086728d14f14ed3a0afb34343ce2b5d2f2 Author: Steve Fanning AuthorDate: Mon Jun 8 18:57:56 2020 +0200 Commit: Gerrit Code Review CommitDate: Mon Jun 8 18:57:56 2020 +0200 Update git submodules * Update helpcontent2 from branch 'libreoffice-7-0' to a80ec77e17ca9cbf4c4e12affa4d31a7ed412677 - (04060182.xhp) Include square brackets in syntax sections to indicate optional parameters. Also updated GEOMEAN() and HARMEAN() to cater for up to 255 arguments rather than 30. Change-Id: I706f1f8426b04b3ec06064d505116151b55f2b00 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95240 Tested-by: Jenkins Reviewed-by: Olivier Hallot (cherry picked from commit 8a1427c35e2392ecfe8ecaee84ab1c24fa5b87ae) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95733 Reviewed-by: Ilmari Lauhakangas diff --git a/helpcontent2 b/helpcontent2 index 3c0f925c0367..a80ec77e17ca 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 3c0f925c0367855db0265e6785c32a1ffc2a0731 +Subproject commit a80ec77e17ca9cbf4c4e12affa4d31a7ed412677 ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] core.git: Branch 'libreoffice-7-0' - helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit e5a96a836523e14890e52d65f07a5297bd6d892e Author: Steve Fanning AuthorDate: Mon Jun 8 18:58:23 2020 +0200 Commit: Gerrit Code Review CommitDate: Mon Jun 8 18:58:23 2020 +0200 Update git submodules * Update helpcontent2 from branch 'libreoffice-7-0' to 7256f3ddd4b6a199ab32278ff727b766cf866fc5 - (04060183.xhp) Include square brackets in syntax sections to indicate optional parameters. Change-Id: I53c9d01dfd75cdab6bac7284b2d775d36a1d9311 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95241 Tested-by: Jenkins Reviewed-by: Olivier Hallot (cherry picked from commit 57145b91d3e06b07d714e65e00d9e19626dbca52) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95734 Reviewed-by: Ilmari Lauhakangas diff --git a/helpcontent2 b/helpcontent2 index a80ec77e17ca..7256f3ddd4b6 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit a80ec77e17ca9cbf4c4e12affa4d31a7ed412677 +Subproject commit 7256f3ddd4b6a199ab32278ff727b766cf866fc5 ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: Branch 'libreoffice-7-0' - source/text
source/text/scalc/01/04060182.xhp | 22 ++ 1 file changed, 10 insertions(+), 12 deletions(-) New commits: commit a80ec77e17ca9cbf4c4e12affa4d31a7ed412677 Author: Steve Fanning AuthorDate: Mon Jun 1 11:15:37 2020 +0200 Commit: Olivier Hallot CommitDate: Mon Jun 8 18:57:56 2020 +0200 (04060182.xhp) Include square brackets in syntax sections to indicate optional parameters. Also updated GEOMEAN() and HARMEAN() to cater for up to 255 arguments rather than 30. Change-Id: I706f1f8426b04b3ec06064d505116151b55f2b00 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95240 Tested-by: Jenkins Reviewed-by: Olivier Hallot (cherry picked from commit 8a1427c35e2392ecfe8ecaee84ab1c24fa5b87ae) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95733 Reviewed-by: Ilmari Lauhakangas diff --git a/source/text/scalc/01/04060182.xhp b/source/text/scalc/01/04060182.xhp index c02ddbbc0..b6a78433b 100644 --- a/source/text/scalc/01/04060182.xhp +++ b/source/text/scalc/01/04060182.xhp @@ -172,7 +172,7 @@ Calculates the values of the left tail of the F distribution. -F.DIST(Number; DegreesFreedom1; DegreesFreedom2; Cumulative) +F.DIST(Number; DegreesFreedom1; DegreesFreedom2 [; Cumulative]) Number is the value for which the F distribution is to be calculated. degreesFreedom1 is the degrees of freedom in the numerator in the F distribution. degreesFreedom2 is the degrees of freedom in the denominator in the F distribution. @@ -285,7 +285,7 @@ Returns the values of a Gamma distribution. The inverse function is GAMMAINV. - GAMMADIST(Number; Alpha; Beta; C) + GAMMADIST(Number; Alpha; Beta [; C]) Number is the value for which the Gamma distribution is to be calculated. @@ -343,9 +343,8 @@ GEOMEAN Returns the geometric mean of a sample. - GEOMEAN(Number1; Number2; ...; Number30) - -Number1, Number2, ..., Number30 are numeric arguments or ranges that represent a random sample. + GEOMEAN() + =GEOMEAN(23;46;69) = 41.79. The geometric mean value of this random sample is therefore 41.79. @@ -374,7 +373,7 @@ ZTEST Calculates the probability of observing a z-statistic greater than the one computed based on a sample. - ZTEST(Data; mu; Sigma) + ZTEST(Data; mu [; Sigma]) Data is the given sample, drawn from a normally distributed population. @@ -391,7 +390,7 @@ Calculates the probability of observing a z-statistic greater than the one computed based on a sample. -Z.TEST(Data; mu; Sigma) +Z.TEST(Data; mu [; Sigma]) Data is the given sample, drawn from a normally distributed population. mu is the known mean of the population. Sigma (optional) is the known standard deviation of the population. If omitted, the standard deviation of the given sample is used. @@ -406,10 +405,9 @@ HARMEAN Returns the harmonic mean of a data set. - HARMEAN(Number1; Number2; ...; Number30) - -Number1, Number2, ..., Number30 are up to 30 values or ranges, that can be used to calculate the harmonic mean. - + HARMEAN() + + =HARMEAN(23;46;69) = 37.64. The harmonic mean of this random sample is thus 37.64 @@ -422,7 +420,7 @@ Returns the hypergeometric distribution. - HYPGEOMDIST(X; NSample; Successes; NPopulation[; Cumulative]) + HYPGEOMDIST(X; NSample; Successes; NPopulation [; Cumulative]) X is the number of results achieved in the random sample. ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] core.git: Branch 'libreoffice-7-0' - helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 1fac359a5067e4c657af8c2095c7d5bb1ed554a2 Author: Steve Fanning AuthorDate: Mon Jun 8 18:57:24 2020 +0200 Commit: Gerrit Code Review CommitDate: Mon Jun 8 18:57:24 2020 +0200 Update git submodules * Update helpcontent2 from branch 'libreoffice-7-0' to 3c0f925c0367855db0265e6785c32a1ffc2a0731 - (04060119.xhp) Include square brackets in syntax sections to indicate optional parameters. Note: PMT() and PPMT() functions - syntax now matches ODF 1.2. Change-Id: I7c291ed84eaf875953e86996cc74c2c9a956e13c Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95235 Tested-by: Jenkins Reviewed-by: Olivier Hallot (cherry picked from commit 4b4e25cad5a6971b1be4f077bbe42fd08366b4fd) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95732 Reviewed-by: Ilmari Lauhakangas diff --git a/helpcontent2 b/helpcontent2 index d3ba25714ea9..3c0f925c0367 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit d3ba25714ea93ce282c319c0898ba66048224afa +Subproject commit 3c0f925c0367855db0265e6785c32a1ffc2a0731 ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: Branch 'libreoffice-7-0' - source/text
source/text/scalc/01/04060119.xhp | 18 +- 1 file changed, 9 insertions(+), 9 deletions(-) New commits: commit 3c0f925c0367855db0265e6785c32a1ffc2a0731 Author: Steve Fanning AuthorDate: Mon Jun 1 00:06:02 2020 +0200 Commit: Olivier Hallot CommitDate: Mon Jun 8 18:57:24 2020 +0200 (04060119.xhp) Include square brackets in syntax sections to indicate optional parameters. Note: PMT() and PPMT() functions - syntax now matches ODF 1.2. Change-Id: I7c291ed84eaf875953e86996cc74c2c9a956e13c Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95235 Tested-by: Jenkins Reviewed-by: Olivier Hallot (cherry picked from commit 4b4e25cad5a6971b1be4f077bbe42fd08366b4fd) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95732 Reviewed-by: Ilmari Lauhakangas diff --git a/source/text/scalc/01/04060119.xhp b/source/text/scalc/01/04060119.xhp index 5abb0366f..99f0d6fd5 100644 --- a/source/text/scalc/01/04060119.xhp +++ b/source/text/scalc/01/04060119.xhp @@ -41,7 +41,7 @@ PPMT Returns for a given period the payment on the principal for an investment that is based on periodic and constant payments and a constant interest rate. -PPMT(Rate; Period; NPer; PV; FV; Type) +PPMT(Rate; Period; NPer; PV [ ; FV [ ; Type ] ]) Rate is the periodic interest rate. @@ -189,7 +189,7 @@ PRICE Calculates the market value of a fixed interest security with a par value of 100 currency units as a function of the forecast yield. -PRICE(Settlement; Maturity; Rate; Yield; Redemption; Frequency; Basis) +PRICE(Settlement; Maturity; Rate; Yield; Redemption; Frequency [; Basis]) Settlement is the date of purchase of the security. @@ -216,7 +216,7 @@ PRICEDISC Calculates the price per 100 currency units of par value of a non-interest- bearing security. -PRICEDISC(Settlement; Maturity; Discount; Redemption; Basis) +PRICEDISC(Settlement; Maturity; Discount; Redemption [; Basis]) Settlement is the date of purchase of the security. @@ -238,7 +238,7 @@ PRICEMAT Calculates the price per 100 currency units of par value of a security, that pays interest on the maturity date. -PRICEMAT(Settlement; Maturity; Issue; Rate; Yield; Basis) +PRICEMAT(Settlement; Maturity; Issue; Rate; Yield [; Basis]) Settlement is the date of purchase of the security. @@ -305,7 +305,7 @@ MDURATION Calculates the modified Macauley duration of a fixed interest security in years. -MDURATION(Settlement; Maturity; Coupon; Yield; Frequency; Basis) +MDURATION(Settlement; Maturity; Coupon; Yield; Frequency [; Basis]) Settlement is the date of purchase of the security. @@ -446,7 +446,7 @@ YIELD Calculates the yield of a security. -YIELD(Settlement; Maturity; Rate; Price; Redemption; Frequency; Basis) +YIELD(Settlement; Maturity; Rate; Price; Redemption; Frequency [; Basis]) Settlement is the date of purchase of the security. @@ -472,7 +472,7 @@ YIELDDISC Calculates the annual yield of a non-interest-bearing security. -YIELDDISC(Settlement; Maturity; Price; Redemption; Basis) +YIELDDISC(Settlement; Maturity; Price; Redemption [; Basis]) Settlement is the date of purchase of the security. @@ -494,7 +494,7 @@ YIELDMAT Calculates the annual yield of a security, the interest of which is paid on the date of maturity. -YIELDMAT(Settlement; Maturity; Issue; Rate; Price; Basis) +YIELDMAT(Settlement; Maturity; Issue; Rate; Price [; Basis]) Settlement is the date of purchase of the security. @@ -519,7 +519,7 @@ PMT Returns the periodic payment for an annuity with constant interest rates. -PMT(Rate; NPer; PV; FV; Type) +PMT(Rate; NPer; PV [ ; [ FV ] [ ; Type ] ]) Rate is the periodic interest rate. ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] core.git: Branch 'libreoffice-7-0' - helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 796384c1a722ef815791607e7a7076a4035e65e2 Author: Steve Fanning AuthorDate: Mon Jun 8 18:56:53 2020 +0200 Commit: Gerrit Code Review CommitDate: Mon Jun 8 18:56:53 2020 +0200 Update git submodules * Update helpcontent2 from branch 'libreoffice-7-0' to d3ba25714ea93ce282c319c0898ba66048224afa - (04060181.xhp) Include square brackets in syntax sections to indicate optional parameters. Change-Id: Idade23cd4fd95210ecc0bd1684f30f30c9d2ccbc Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95236 Tested-by: Jenkins Reviewed-by: Olivier Hallot (cherry picked from commit 5dd2cc30687d259990a9882d1c0874993fb60747) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95731 Reviewed-by: Ilmari Lauhakangas diff --git a/helpcontent2 b/helpcontent2 index 71f706236edf..d3ba25714ea9 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 71f706236edfd8ade428215f0c850c7197a59008 +Subproject commit d3ba25714ea93ce282c319c0898ba66048224afa ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: Branch 'libreoffice-7-0' - source/text
source/text/scalc/01/04060181.xhp | 12 ++-- 1 file changed, 6 insertions(+), 6 deletions(-) New commits: commit d3ba25714ea93ce282c319c0898ba66048224afa Author: Steve Fanning AuthorDate: Mon Jun 1 00:19:48 2020 +0200 Commit: Olivier Hallot CommitDate: Mon Jun 8 18:56:53 2020 +0200 (04060181.xhp) Include square brackets in syntax sections to indicate optional parameters. Change-Id: Idade23cd4fd95210ecc0bd1684f30f30c9d2ccbc Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95236 Tested-by: Jenkins Reviewed-by: Olivier Hallot (cherry picked from commit 5dd2cc30687d259990a9882d1c0874993fb60747) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95731 Reviewed-by: Ilmari Lauhakangas diff --git a/source/text/scalc/01/04060181.xhp b/source/text/scalc/01/04060181.xhp index f51297a15..2dd591ea4 100644 --- a/source/text/scalc/01/04060181.xhp +++ b/source/text/scalc/01/04060181.xhp @@ -154,7 +154,7 @@ Returns the probability of a sample with binomial distribution. -B(Trials; SP; T1; T2) +B(Trials; SP; T1 [; T2]) Trials is the number of independent trials. SP is the probability of success on each trial. T1 defines the lower limit for the number of trials. @@ -198,7 +198,7 @@ Returns the inverse of the cumulative beta probability density function. -BETAINV(Number; Alpha; Beta; Start; End) +BETAINV(Number; Alpha; Beta [; Start [; End]]) Number is the value between Start and End at which to evaluate the function. Alpha is a parameter to the distribution. Beta is a parameter to the distribution. @@ -222,7 +222,7 @@ Returns the inverse of the cumulative beta probability density function. -BETA.INV(Number; Alpha; Beta; Start; End) +BETA.INV(Number; Alpha; Beta [; Start [; End]]) Number is the value between Start and End at which to evaluate the function. Alpha is a parameter to the distribution. Beta is a parameter to the distribution. @@ -246,7 +246,7 @@ Returns the beta function. -BETADIST(Number; Alpha; Beta; Start; End; Cumulative) +BETADIST(Number; Alpha; Beta [; Start [; End [; Cumulative]]]) Number is the value between Start and End at which to evaluate the function. Alpha is a parameter to the distribution. Beta is a parameter to the distribution. @@ -271,7 +271,7 @@ Returns the beta function. -BETA.DIST(Number; Alpha; Beta; Cumulative; Start; End) +BETA.DIST(Number; Alpha; Beta; Cumulative [; Start [; End]]) Number (required) is the value between Start and End at which to evaluate the function. Alpha (required) is a parameter to the distribution. Beta (required) is a parameter to the distribution. @@ -705,7 +705,7 @@ Returns the value of the probability density function or the cumulative distribution function for the chi-square distribution. -CHISQDIST(Number; Degrees Of Freedom; Cumulative) +CHISQDIST(Number; Degrees Of Freedom [; Cumulative]) Number is the number for which the function is to be calculated. Degrees Of Freedom is the degrees of freedom for the chi-square function. Cumulative (optional): 0 or False calculates the probability density function. Other values or True or omitted calculates the cumulative distribution function. ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] core.git: Branch 'libreoffice-7-0' - helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 5ec3bfc5de73db1956b596b2aa05e7c2520e2382 Author: Steve Fanning AuthorDate: Mon Jun 8 18:55:34 2020 +0200 Commit: Gerrit Code Review CommitDate: Mon Jun 8 18:55:34 2020 +0200 Update git submodules * Update helpcontent2 from branch 'libreoffice-7-0' to 5d3020b7cde049bfd0fa61f5d6abe660318ffbbe - (04060116.xhp) Include square brackets in syntax sections to indicate optional parameters. Change-Id: Ife2ccaeb06062c1cedaa8cba8511a0a86be1fc1a Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95209 Tested-by: Jenkins Reviewed-by: Olivier Hallot (cherry picked from commit 16b1c5d9c3ead98647e6cc816a9b81e39be48ca5) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95729 Reviewed-by: Ilmari Lauhakangas diff --git a/helpcontent2 b/helpcontent2 index 0c2b19daf2c1..5d3020b7cde0 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 0c2b19daf2c1d08c53398f82da914e87aa4373f1 +Subproject commit 5d3020b7cde049bfd0fa61f5d6abe660318ffbbe ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: Branch 'libreoffice-7-0' - source/text
source/text/scalc/01/04060116.xhp |6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) New commits: commit 5d3020b7cde049bfd0fa61f5d6abe660318ffbbe Author: Steve Fanning AuthorDate: Sun May 31 11:41:31 2020 +0200 Commit: Olivier Hallot CommitDate: Mon Jun 8 18:55:34 2020 +0200 (04060116.xhp) Include square brackets in syntax sections to indicate optional parameters. Change-Id: Ife2ccaeb06062c1cedaa8cba8511a0a86be1fc1a Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95209 Tested-by: Jenkins Reviewed-by: Olivier Hallot (cherry picked from commit 16b1c5d9c3ead98647e6cc816a9b81e39be48ca5) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95729 Reviewed-by: Ilmari Lauhakangas diff --git a/source/text/scalc/01/04060116.xhp b/source/text/scalc/01/04060116.xhp index 91ec082cc..9316d9320 100644 --- a/source/text/scalc/01/04060116.xhp +++ b/source/text/scalc/01/04060116.xhp @@ -322,7 +322,7 @@ COMPLEX The result is a complex number which is returned from a real coefficient and an imaginary coefficient. - COMPLEX(RealNum; INum; Suffix) + COMPLEX(RealNum; INum [; Suffix]) RealNum is the real coefficient of the complex number. @@ -341,7 +341,7 @@ OCT2BIN The result is the binary number for the octal number entered. - OCT2BIN(Number; Places) + OCT2BIN(Number [; Places]) Number is the octal number. The number can have a maximum of 10 places. The most significant bit is the sign bit, the following bits return the value. Negative numbers are entered as two's complement. @@ -373,7 +373,7 @@ OCT2HEX The result is the hexadecimal number for the octal number entered. - OCT2HEX(Number; Places) + OCT2HEX(Number [; Places]) Number is the octal number. The number can have a maximum of 10 places. The most significant bit is the sign bit, the following bits return the value. Negative numbers are entered as two's complement. ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: Branch 'libreoffice-7-0' - source/text
source/text/scalc/01/04060118.xhp | 34 +- 1 file changed, 17 insertions(+), 17 deletions(-) New commits: commit 0c2b19daf2c1d08c53398f82da914e87aa4373f1 Author: Steve Fanning AuthorDate: Sun May 31 11:19:59 2020 +0200 Commit: Olivier Hallot CommitDate: Mon Jun 8 18:55:07 2020 +0200 (04060118.xhp) Include square brackets in syntax sections to indicate optional parameters. ODF 1.2 used to confirm configuration of brackets for FV(), NPER(),and RATE(). Change-Id: I7b109974d3e1dbc6670c32628a5425741d882f4e Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95208 Tested-by: Jenkins Reviewed-by: Olivier Hallot (cherry picked from commit cf09e34b35c8f0803ecfb5151bdbf1a1cf1ccc68) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95728 Reviewed-by: Ilmari Lauhakangas diff --git a/source/text/scalc/01/04060118.xhp b/source/text/scalc/01/04060118.xhp index 850d2b1c8..a51d0cf6b 100644 --- a/source/text/scalc/01/04060118.xhp +++ b/source/text/scalc/01/04060118.xhp @@ -43,7 +43,7 @@ Calculates the price per 100 currency units par value of a security, if the first interest date falls irregularly. -ODDFPRICE(Settlement; Maturity; Issue; FirstCoupon; Rate; Yield; Redemption; Frequency; Basis) +ODDFPRICE(Settlement; Maturity; Issue; FirstCoupon; Rate; Yield; Redemption; Frequency [; Basis]) Settlement is the date of purchase of the security. Maturity is the date on which the security matures (expires). Issue is the date of issue of the security. @@ -66,7 +66,7 @@ Calculates the yield of a security if the first interest date falls irregularly. -ODDFYIELD(Settlement; Maturity; Issue; FirstCoupon; Rate; Price; Redemption; Frequency; Basis) +ODDFYIELD(Settlement; Maturity; Issue; FirstCoupon; Rate; Price; Redemption; Frequency [; Basis]) Settlement is the date of purchase of the security. Maturity is the date on which the security matures (expires). Issue is the date of issue of the security. @@ -89,7 +89,7 @@ Calculates the price per 100 currency units par value of a security, if the last interest date falls irregularly. -ODDLPRICE(Settlement; Maturity; LastInterest; Rate; Yield; Redemption; Frequency; Basis) +ODDLPRICE(Settlement; Maturity; LastInterest; Rate; Yield; Redemption; Frequency [; Basis]) Settlement is the date of purchase of the security. Maturity is the date on which the security matures (expires). LastInterest is the last interest date of the security. @@ -116,7 +116,7 @@ Calculates the yield of a security if the last interest date falls irregularly. -ODDLYIELD(Settlement; Maturity; LastInterest; Rate; Price; Redemption; Frequency; Basis) +ODDLYIELD(Settlement; Maturity; LastInterest; Rate; Price; Redemption; Frequency [; Basis]) Settlement is the date of purchase of the security. Maturity is the date on which the security matures (expires). LastInterest is the last interest date of the security. @@ -145,7 +145,7 @@ Returns the depreciation of an asset for a specified or partial period using a variable declining balance method. -VDB(Cost; Salvage; Life; S; End; Factor; NoSwitch) +VDB(Cost; Salvage; Life; S; End [; Factor [; NoSwitch]]) Cost is the initial value of an asset. Salvage is the value of an asset at the end of the depreciation. Life is the depreciation duration of the asset. @@ -174,7 +174,7 @@ If the payments take place at regular intervals, use the IRR function. -XIRR(Values; Dates; Guess) +XIRR(Values; Dates [; Guess]) Values and Dates refer to a series of payments and the series of associated date values. The first pair of dates defines the start of the payment plan. All other date values must be later, but need not be in any order. The series of values must contain at least one negative and one positive value (receipts and deposits). Guess (optional) is a guess that can be input for the internal rate of return. The default is 10%. @@ -324,7 +324,7 @@ Returns the constant interest rate per period of an annuity. -RATE(NPer; Pmt; PV; FV; Type; Guess) +RATE(NPer; Pmt; PV [ ; [ FV ] [ ; [ Type ] [ ; Guess ] ] ]) NPer is the total number of periods, during which payments are made (payment period). Pmt is the constant payment (annuity) paid during each period. PV is the cash value in the sequence of payments. @@ -349,7 +349,7 @@ Calculates the annual interest rate that results when a security (or other item) is purchased at an investment value and sold at a redemption value. No interest is paid. -INTRATE(Settlement; Maturity; Investment; Redemption; Basis) +INTRATE(Settlement; Maturity; Investment; Redemption [; Basis]) Settlement is the date of purchase of the security. Maturity is the date on which the security is sold. Investment is the purchase price. @@ -372,7 +372,7 @@ Returns the date of the first interest date after the settlement date. Format the result as a date.
[Libreoffice-commits] core.git: Branch 'libreoffice-7-0' - helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 46b7af9021197aaa2209c41be8f832a2c93723f9 Author: Steve Fanning AuthorDate: Mon Jun 8 18:55:07 2020 +0200 Commit: Gerrit Code Review CommitDate: Mon Jun 8 18:55:07 2020 +0200 Update git submodules * Update helpcontent2 from branch 'libreoffice-7-0' to 0c2b19daf2c1d08c53398f82da914e87aa4373f1 - (04060118.xhp) Include square brackets in syntax sections to indicate optional parameters. ODF 1.2 used to confirm configuration of brackets for FV(), NPER(),and RATE(). Change-Id: I7b109974d3e1dbc6670c32628a5425741d882f4e Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95208 Tested-by: Jenkins Reviewed-by: Olivier Hallot (cherry picked from commit cf09e34b35c8f0803ecfb5151bdbf1a1cf1ccc68) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95728 Reviewed-by: Ilmari Lauhakangas diff --git a/helpcontent2 b/helpcontent2 index 1db1f9baa638..0c2b19daf2c1 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 1db1f9baa638c1d615352a810bac549f58cd4c51 +Subproject commit 0c2b19daf2c1d08c53398f82da914e87aa4373f1 ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] core.git: Branch 'libreoffice-7-0' - helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit fb6af9b587c204625794d4a7986965b4f8acc91b Author: Steve Fanning AuthorDate: Mon Jun 8 18:54:03 2020 +0200 Commit: Gerrit Code Review CommitDate: Mon Jun 8 18:54:03 2020 +0200 Update git submodules * Update helpcontent2 from branch 'libreoffice-7-0' to d0fa91c4e334faf835820581596e8fda1ca49d0d - (func_fourier.xhp) Include square brackets in syntax section to indicate optional parameters. Change-Id: I4f5a108e6e588dd97b4501a8b2d13be628536a6d Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95205 Tested-by: Jenkins Reviewed-by: Olivier Hallot (cherry picked from commit f35181a3fb8f5db8ac323ec7537d64e693546420) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95725 Reviewed-by: Ilmari Lauhakangas diff --git a/helpcontent2 b/helpcontent2 index 25d7c849c5f6..d0fa91c4e334 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 25d7c849c5f6159cae78b11be63445c548de29eb +Subproject commit d0fa91c4e334faf835820581596e8fda1ca49d0d ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] core.git: Branch 'libreoffice-7-0' - helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit ce5719179fe1c6ece1c706a3372c3a5862a1b273 Author: Steve Fanning AuthorDate: Mon Jun 8 18:54:42 2020 +0200 Commit: Gerrit Code Review CommitDate: Mon Jun 8 18:54:42 2020 +0200 Update git submodules * Update helpcontent2 from branch 'libreoffice-7-0' to 1db1f9baa638c1d615352a810bac549f58cd4c51 - (func_color.xhp) Include square brackets in syntax section to indicate optional parameter. Change-Id: I648260ba137015b29443944c983aac16f497b7d6 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95207 Tested-by: Jenkins Reviewed-by: Olivier Hallot (cherry picked from commit 6a31cba2f22a5a7cf60c1590b1189423fed285b3) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95727 Reviewed-by: Ilmari Lauhakangas diff --git a/helpcontent2 b/helpcontent2 index ff832a2656ea..1db1f9baa638 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit ff832a2656ea178587b21b19d62207680b131c5b +Subproject commit 1db1f9baa638c1d615352a810bac549f58cd4c51 ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: Branch 'libreoffice-7-0' - source/text
source/text/scalc/01/func_fourier.xhp |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit d0fa91c4e334faf835820581596e8fda1ca49d0d Author: Steve Fanning AuthorDate: Sun May 31 10:39:03 2020 +0200 Commit: Olivier Hallot CommitDate: Mon Jun 8 18:54:03 2020 +0200 (func_fourier.xhp) Include square brackets in syntax section to indicate optional parameters. Change-Id: I4f5a108e6e588dd97b4501a8b2d13be628536a6d Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95205 Tested-by: Jenkins Reviewed-by: Olivier Hallot (cherry picked from commit f35181a3fb8f5db8ac323ec7537d64e693546420) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95725 Reviewed-by: Ilmari Lauhakangas diff --git a/source/text/scalc/01/func_fourier.xhp b/source/text/scalc/01/func_fourier.xhp index 1c6bb7d8a..9aad60e3d 100644 --- a/source/text/scalc/01/func_fourier.xhp +++ b/source/text/scalc/01/func_fourier.xhp @@ -27,7 +27,7 @@ -FOURIER(Array, GroupedByColumns, Inverse, Polar, MinimumMagnitude) +FOURIER(Array; GroupedByColumns [; Inverse [; Polar [; MinimumMagnitude]]]) Array is a 2 x N or N x 2 range representing an array of complex number to be transformed, where N is the length of the array. The array represents the real and imaginary parts of the data. GroupedByColumns is a logical (TRUE or FALSE, 1 or 0) argument. When TRUE the array is grouped by columns where the first column contains the real part of the complex number and the second columns contains the imaginary part of the complex number. When FALSE, the first row contains the real part of the complex number and the second row contains the imaginary part of the complex number. If there is only 1 column (row), the input sequence is treated as purely real. ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] core.git: Branch 'libreoffice-7-0' - helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit a88cfc920e65cc9f2100e95ea07b18c6cc15e5ae Author: Steve Fanning AuthorDate: Mon Jun 8 18:54:25 2020 +0200 Commit: Gerrit Code Review CommitDate: Mon Jun 8 18:54:25 2020 +0200 Update git submodules * Update helpcontent2 from branch 'libreoffice-7-0' to ff832a2656ea178587b21b19d62207680b131c5b - (func_findb.xhp) Include square brackets in syntax section to indicate optional parameter. Change-Id: Ib21893f9f1d61a164957a82114f9a1dc0255b9ab Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95206 Tested-by: Jenkins Reviewed-by: Olivier Hallot (cherry picked from commit cae5dda033a7b19ecdb37a8abc571f31a5b798d4) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95726 Reviewed-by: Ilmari Lauhakangas diff --git a/helpcontent2 b/helpcontent2 index d0fa91c4e334..ff832a2656ea 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit d0fa91c4e334faf835820581596e8fda1ca49d0d +Subproject commit ff832a2656ea178587b21b19d62207680b131c5b ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: Branch 'libreoffice-7-0' - source/text
source/text/scalc/01/func_findb.xhp |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit ff832a2656ea178587b21b19d62207680b131c5b Author: Steve Fanning AuthorDate: Sun May 31 10:45:04 2020 +0200 Commit: Olivier Hallot CommitDate: Mon Jun 8 18:54:25 2020 +0200 (func_findb.xhp) Include square brackets in syntax section to indicate optional parameter. Change-Id: Ib21893f9f1d61a164957a82114f9a1dc0255b9ab Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95206 Tested-by: Jenkins Reviewed-by: Olivier Hallot (cherry picked from commit cae5dda033a7b19ecdb37a8abc571f31a5b798d4) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95726 Reviewed-by: Ilmari Lauhakangas diff --git a/source/text/scalc/01/func_findb.xhp b/source/text/scalc/01/func_findb.xhp index 0ab9ead47..091d7ecc3 100644 --- a/source/text/scalc/01/func_findb.xhp +++ b/source/text/scalc/01/func_findb.xhp @@ -27,7 +27,7 @@ -FINDB( Find Text ; Text ; Position ) +FINDB(Find Text ; Text [; Position]) Find Text: The text or text expression to be found. Text: the text in which the search is to be made. Position: The position in the text where the search starts. ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: Branch 'libreoffice-7-0' - source/text
source/text/scalc/01/func_color.xhp |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 1db1f9baa638c1d615352a810bac549f58cd4c51 Author: Steve Fanning AuthorDate: Sun May 31 10:48:00 2020 +0200 Commit: Olivier Hallot CommitDate: Mon Jun 8 18:54:42 2020 +0200 (func_color.xhp) Include square brackets in syntax section to indicate optional parameter. Change-Id: I648260ba137015b29443944c983aac16f497b7d6 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95207 Tested-by: Jenkins Reviewed-by: Olivier Hallot (cherry picked from commit 6a31cba2f22a5a7cf60c1590b1189423fed285b3) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95727 Reviewed-by: Ilmari Lauhakangas diff --git a/source/text/scalc/01/func_color.xhp b/source/text/scalc/01/func_color.xhp index fced92ec0..f7c7b1358 100644 --- a/source/text/scalc/01/func_color.xhp +++ b/source/text/scalc/01/func_color.xhp @@ -36,7 +36,7 @@ Return a numeric value calculated by a combination of three colors (red, green and blue) and the alpha channel, in the RGBA color system. The result depends on the color system used by your computer. - COLOR(Red; Green; Blue; Alpha) + COLOR(Red; Green; Blue [; Alpha]) Red, Green and Blue – required arguments. The value for the red, green and blue components of the color. The values must be between 0 and 255. Zero means no color component and 255 means full color component. Alpha – optional argument. The value for the alpha channel or alpha composite. Alpha is a integer value between 0 and 255. The value of zero for alpha means the color is fully transparent, whereas a value of 255 in the alpha channel gives a fully opaque color. ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] core.git: Branch 'libreoffice-7-0' - helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit c46219e6afdb0a448393f69a69cb4e71d6d04a77 Author: Steve Fanning AuthorDate: Mon Jun 8 18:52:19 2020 +0200 Commit: Gerrit Code Review CommitDate: Mon Jun 8 18:52:19 2020 +0200 Update git submodules * Update helpcontent2 from branch 'libreoffice-7-0' to 25d7c849c5f6159cae78b11be63445c548de29eb - (func_networkdays.intl.xhp) Include square brackets in syntax section to indicate optional parameters. Note: Exact configuration of square brackets based on that for NETWORKDAYS(). Change-Id: I0f1f7100add3f50d2ba3946087cca292d7a51d65 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95204 Tested-by: Jenkins Reviewed-by: Olivier Hallot (cherry picked from commit 1637dffb6225234b599ee586c796fd6924aecf8a) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95724 Reviewed-by: Ilmari Lauhakangas diff --git a/helpcontent2 b/helpcontent2 index c1fbeca7942f..25d7c849c5f6 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit c1fbeca7942fbc48b7857e7be079de506cfd7deb +Subproject commit 25d7c849c5f6159cae78b11be63445c548de29eb ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: Branch 'libreoffice-7-0' - source/text
source/text/scalc/01/func_networkdays.intl.xhp |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 25d7c849c5f6159cae78b11be63445c548de29eb Author: Steve Fanning AuthorDate: Sun May 31 10:28:34 2020 +0200 Commit: Olivier Hallot CommitDate: Mon Jun 8 18:52:19 2020 +0200 (func_networkdays.intl.xhp) Include square brackets in syntax section to indicate optional parameters. Note: Exact configuration of square brackets based on that for NETWORKDAYS(). Change-Id: I0f1f7100add3f50d2ba3946087cca292d7a51d65 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95204 Tested-by: Jenkins Reviewed-by: Olivier Hallot (cherry picked from commit 1637dffb6225234b599ee586c796fd6924aecf8a) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95724 Reviewed-by: Ilmari Lauhakangas diff --git a/source/text/scalc/01/func_networkdays.intl.xhp b/source/text/scalc/01/func_networkdays.intl.xhp index 643387924..ed1364ba1 100644 --- a/source/text/scalc/01/func_networkdays.intl.xhp +++ b/source/text/scalc/01/func_networkdays.intl.xhp @@ -36,7 +36,7 @@ -NETWORKDAYS.INTL(StartDate; EndDate; Weekend; Holidays) +NETWORKDAYS.INTL(StartDate; EndDate [; [ Weekend ] [; Holidays ] ]) StartDate is the date from when the calculation is carried out. If the start date is a workday, the day is included in the calculation. EndDate is the date up until when the calculation is carried out. If the end date is a workday, the day is included in the calculation. ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] core.git: Branch 'libreoffice-7-0' - helpcontent2
helpcontent2 |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit d9333fb21473fd749dfbc29cb6a0481de8965d59 Author: Steve Fanning AuthorDate: Mon Jun 8 18:52:00 2020 +0200 Commit: Gerrit Code Review CommitDate: Mon Jun 8 18:52:00 2020 +0200 Update git submodules * Update helpcontent2 from branch 'libreoffice-7-0' to c1fbeca7942fbc48b7857e7be079de506cfd7deb - (func_networkdays.xhp) Include square brackets in syntax section to indicate optional parameters. Note: Exact configuration of square brackets inferred from ODF 1.2. Change-Id: Ie607da08555aac5bc3d1a46b53f8d4b5c90d33ff Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95203 Tested-by: Jenkins Reviewed-by: Olivier Hallot (cherry picked from commit 2d5a11ff0c0ce386c2e6e634b620448d9e0e4824) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95723 Reviewed-by: Ilmari Lauhakangas diff --git a/helpcontent2 b/helpcontent2 index 87cc2e79cff4..c1fbeca7942f 16 --- a/helpcontent2 +++ b/helpcontent2 @@ -1 +1 @@ -Subproject commit 87cc2e79cff4c4b6e765aede94b8e9ae19c150e4 +Subproject commit c1fbeca7942fbc48b7857e7be079de506cfd7deb ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
