--- source/text/scalc/01/04060106.xhp | 10 ++++++++-- source/text/scalc/01/func_color.xhp | 4 ++++ source/text/scalc/01/func_forecastetsmult.xhp | 8 +++++--- source/text/scalc/01/func_forecastetspimult.xhp | 9 ++++++--- source/text/scalc/01/func_forecastetsstatmult.xhp | 7 +++++-- source/text/scalc/01/func_fourier.xhp | 5 ++++- source/text/scalc/01/func_rawsubtract.xhp | 5 ++++- source/text/scalc/01/func_regex.xhp | 7 +++++-- source/text/scalc/01/func_roundsig.xhp | 11 +++++++---- source/text/scalc/01/func_weeknum_ooo.xhp | 4 ++++ 10 files changed, 52 insertions(+), 18 deletions(-) (limited to 'source/text/scalc') diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp index a49299e34d..61e0355747 100644 --- a/source/text/scalc/01/04060106.xhp +++ b/source/text/scalc/01/04060106.xhp @@ -1521,13 +1521,16 @@

RANDBETWEEN.NV

Returns an non-volatile integer random number in a specified range. -

RANDBETWEEN.NV(Bottom; Top) Returns an non-volatile integer random number between integers Bottom and Top (both inclusive). A non-volatile function is not recalculated at new input events or pressing F9. However, the function is recalculated when pressing F9 with the cursor on the cell containing the function, when opening the file, and when Top or Bottom are recalculated.

=RANDBETWEEN.NV(20;30) returns a non-volatile integer between 20 and 30. =RANDBETWEEN.NV(A1;30) returns a non-volatile integer between the value of cell A1 and 30. The function is recalculated when the contents of cell A1 change. +

+ORG.LIBREOFFICE.RANDBETWEEN.NV

@@ -1566,12 +1569,15 @@

RAND.NV

Returns a non-volatile random number between 0 and 1. -

RAND.NV() This function produces a non-volatile random number on input. A non-volatile function is not recalculated at new input events. The function does not recalculate when pressing F9, except when the cursor is on the cell containing the function. The function is recalculated when opening the file.

=RAND.NV() returns a non-volatile random number between 0 and 1. +

+ORG.LIBREOFFICE.RAND.NV

diff --git a/source/text/scalc/01/func_color.xhp b/source/text/scalc/01/func_color.xhp index 2affaf6315..26b6b6722c 100644 --- a/source/text/scalc/01/func_color.xhp +++ b/source/text/scalc/01/func_color.xhp @@ -45,5 +45,9 @@ COLOR(0;0;255;255) returns 4278190335 COLOR(0;0;400;0) returns Err:502 (Invalid argument) because the blue value is greater than 255. +

+ ORG.LIBREOFFICE.COLOR diff --git a/source/text/scalc/01/func_forecastetsmult.xhp b/source/text/scalc/01/func_forecastetsmult.xhp index cc8926af18..49ea19fd57 100644 --- a/source/text/scalc/01/func_forecastetsmult.xhp +++ b/source/text/scalc/01/func_forecastetsmult.xhp @@ -23,13 +23,12 @@ FORECAST.ETS.MULT function - FORECAST.ETS.MULT Function +

FORECAST.ETS.MULT Function

Calculates the multiplicative forecast(s) (future values) based on the historical data using ETS or EDS algorithms. EDS is used when argument period_length is 0, otherwise ETS is used.

FORECAST.ETS.MULT calculates with the model

FORECAST.ETS.MULT(targets, values, timeline, [period_length], [data_completion], [aggregation])

@@ -44,7 +43,10 @@ Returns 131.71437427439, the multiplicative forecast for January 2014 based on Values and Timeline named ranges above, with one sample per period, no missing data, and AVERAGE as aggregation. =FORECAST.ETS.MULT(DATE(2014;1;1);Values;Timeline;4;TRUE();7) Returns 120.747806144882, the multiplicative forecast for January 2014 based on Values and Timeline named ranges above, with period length of 4, no missing data, and SUM as aggregation. - +

+ ORG.LIBREOFFICE.FORECAST.ETS.MULT

See also: diff --git a/source/text/scalc/01/func_forecastetspimult.xhp b/source/text/scalc/01/func_forecastetspimult.xhp index 002f8fefaa..b5d5c1eb99 100644 --- a/source/text/scalc/01/func_forecastetspimult.xhp +++ b/source/text/scalc/01/func_forecastetspimult.xhp @@ -23,13 +23,12 @@ FORECAST.ETS.PI.MULT function -FORECAST.ETS.PI.MULT function +

FORECAST.ETS.PI.MULT function

Calculates the prediction interval(s) for multiplicative forecast based on the historical data using ETS or EDS algorithms.. EDS is used when argument period_length is 0, otherwise ETS is used.

FORECAST.ETS.PI.MULT calculates with the model

FORECAST.ETS.PI.MULT(target, values, timeline, [confidence_level], [period_length], [data_completion], [aggregation])

@@ -40,7 +39,7 @@

For example, with a 90% Confidence level, a 90% prediction interval will be computed (90% of future points are to fall within this radius from forecast). -Note on prediction intervals: there is no exact mathematical way to calculate this for forecasts, there are various approximations. Prediction intervals tend to be increasingly 'over-optimistic' when increasing distance of the forecast-X from the observation data set. +Note on prediction intervals: there is no exact mathematical way to calculate this for forecasts, there are various approximations. Prediction intervals tend to be increasingly 'over-optimistic' when increasing distance of the forecast-X from the observation data set. For ETS, Calc uses an approximation based on 1000 calculations with random variations within the standard deviation of the observation data set (the historical values).

@@ -48,6 +47,10 @@ Returns 20.1040952101013, the prediction interval for multiplicative forecast for January 2014 based on Values and Timeline named ranges above, confidence level of 90% (=0.9) with one sample per period, no missing data, and AVERAGE as aggregation. =FORECAST.ETS.PI.MULT(DATE(2014;1;1);Values;Timeline;0.8;4;TRUE();7) Returns 27.5285874381574, the prediction interval for multiplicative forecast for January 2014 based on Values and Timeline named ranges above, with confidence level of 0.8, period length of 4, no missing data, and SUM as aggregation. +

+ ORG.LIBREOFFICE.FORECAST.ETS.PI.MULT

See also: diff --git a/source/text/scalc/01/func_forecastetsstatmult.xhp b/source/text/scalc/01/func_forecastetsstatmult.xhp index 7ac7d527c6..4c818cb675 100644 --- a/source/text/scalc/01/func_forecastetsstatmult.xhp +++ b/source/text/scalc/01/func_forecastetsstatmult.xhp @@ -24,13 +24,12 @@ FORECAST.ETS.STAT.MULT function -FORECAST.ETS.STAT.MULT Function +

FORECAST.ETS.STAT.MULT Function

Returns statistical value(s) that are results of the ETS/EDS algorithms.

FORECAST.ETS.STAT.MULT calculates with the model

FORECAST.ETS.STAT.MULT (values, timeline, stat_type, [period_length], [data_completion], [aggregation])

@@ -45,6 +44,10 @@ Returns 0.084073452803966, the multiplicative statistics based on Values and Timeline named ranges above, with symmetric mean absolute percentage error (SMAPE), one sample per period, no missing data, and AVERAGE as aggregation. =FORECAST.ETS.STAT.MULT(Values;Timeline;7;1;TRUE();7) Returns 15.8372533480997, the multiplicative statistics based on Values and Timeline named ranges above, with root mean squared error, no missing data, and SUM as aggregation. +

+ ORG.LIBREOFFICE.FORECAST.ETS.STAT.MULT

See also: diff --git a/source/text/scalc/01/func_fourier.xhp b/source/text/scalc/01/func_fourier.xhp index 9aad60e3de..d349109248 100644 --- a/source/text/scalc/01/func_fourier.xhp +++ b/source/text/scalc/01/func_fourier.xhp @@ -24,7 +24,6 @@

FOURIER

Computes the Discrete Fourier Transform [DFT] of an input array of complex numbers using a couple of Fast Fourier Transform (FFT) algorithms. The function is an array formula.

FOURIER(Array; GroupedByColumns [; Inverse [; Polar [; MinimumMagnitude]]]) @@ -40,6 +39,10 @@

+ ORG.LIBREOFFICE.FOURIER

diff --git a/source/text/scalc/01/func_rawsubtract.xhp b/source/text/scalc/01/func_rawsubtract.xhp index 7152b8dbe6..55fea74dba 100644 --- a/source/text/scalc/01/func_rawsubtract.xhp +++ b/source/text/scalc/01/func_rawsubtract.xhp @@ -25,7 +25,6 @@

RAWSUBTRACT

Subtracts a set of numbers and gives the result without eliminating small roundoff errors.

RAWSUBTRACT(Minuend; Subtrahend 1[; Subtrahend 2][; … ;[ Subtrahend 254]]) Minuend is a number or a reference to a cell containing a number. @@ -35,6 +34,10 @@

=RAWSUBTRACT(0.987654321098765, 0.9876543210987) returns 6.53921361504217E-14 =RAWSUBTRACT(0.987654321098765) returns Err:511 (Missing variable) because RAWSUBTRACT requires a minimum of two numbers. +

+ ORG.LIBREOFFICE.RAWSUBTRACT diff --git a/source/text/scalc/01/func_regex.xhp b/source/text/scalc/01/func_regex.xhp index 9c48cf2194..3b29f7492b 100644 --- a/source/text/scalc/01/func_regex.xhp +++ b/source/text/scalc/01/func_regex.xhp @@ -23,10 +23,9 @@ regular expressions;extracting in spreadsheets regular expressions;REGEX function - REGEX +

REGEX

Matches and extracts or optionally replaces text using regular expressions. -

REGEX( Text ; Expression [ ; [ Replacement ] [ ; Flags|Occurrence ] ] ) Text: A text or reference to a cell where the regular expression is to be applied. @@ -40,6 +39,10 @@ =REGEX("123456ABCDEF";"[126]";"";"g") returns "345ABCDEF", where any occurrence of "1", "2" or "6" is replaced by the empty string, thus deleted. =REGEX("axbxcxd";".x";;2) returns "bx", the second match of ".x". =REGEX("axbxcxd";"(.)x";"$1y";2) returns "axbycxd", the second match of "(.)x" (i.e. "bx") replaced with the captured group of one character (i.e. "b") followed by "y". +

+ ORG.LIBREOFFICE.REGEX

List of regular expressions ICU regular expressions diff --git a/source/text/scalc/01/func_roundsig.xhp b/source/text/scalc/01/func_roundsig.xhp index 86d6cd6cf6..6e96d0a584 100644 --- a/source/text/scalc/01/func_roundsig.xhp +++ b/source/text/scalc/01/func_roundsig.xhp @@ -16,20 +16,19 @@

- + ROUNDSIG Function - ROUNDSIG +

ROUNDSIG

Returns a number rounded to a specified number of significant decimal digits of its normalized floating point notation.

ROUNDSIG( Value; Digits ) Value: the number to be rounded. Digits: the number of decimal places to round. - Digits must be an integer greater than 0. + Digits must be an integer greater than 0.

@@ -37,6 +36,10 @@ =ROUNDSIG(0.000123456789; 5) returns 0.00012346 =ROUNDSIG(123456789012345; 2) returns 1.2E14 =ROUNDSIG(123456789; 4) returns 123500000 or 123.5E6 +

+ ORG.LIBREOFFICE.ROUNDSIG

See also ROUND, MROUND, ROUNDUP, ROUNDDOWN.

diff --git a/source/text/scalc/01/func_weeknum_ooo.xhp b/source/text/scalc/01/func_weeknum_ooo.xhp index a4de840922..28519d22a4 100644 --- a/source/text/scalc/01/func_weeknum_ooo.xhp +++ b/source/text/scalc/01/func_weeknum_ooo.xhp @@ -44,6 +44,10 @@

=WEEKNUM_OOO(DATE(1995;1;1);1) returns 1 =WEEKNUM_OOO(DATE(1995;1;1);2) returns 52. Week 1 starts on Monday, 1995-01-02. +

+ORG.LIBREOFFICE.WEEKNUM_OOO

-- cgit