source/text/scalc/01/04060104.xhp | 5 +++-
source/text/scalc/01/04060106.xhp | 10 ++++++--
source/text/scalc/01/04060109.xhp | 6 +++++
source/text/scalc/01/04060111.xhp | 26 +++++++++++++++++++++-
source/text/scalc/01/common_func.xhp | 2 -
source/text/scalc/01/func_color.xhp | 4 +++
source/text/scalc/01/func_convert.xhp | 4 ++-
source/text/scalc/01/func_eastersunday.xhp | 3 ++
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 +++
16 files changed, 94 insertions(+), 22 deletions(-)
New commits:
commit c7e7800abe70df5f14c03c63a829ed74d403a5fd
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Sat Jan 1 09:52:45 2022 -0300
Commit: Adolfo Jayme Barrientos <fit...@ubuntu.com>
CommitDate: Sun Jan 2 13:41:32 2022 +0100
tdf#94537 ORG.LIBREOFFICE.* namespace information
Change-Id: Ide646195514d45dec1b4b386890b1d64ae3b3138
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/127840
Tested-by: Jenkins
Reviewed-by: Adolfo Jayme Barrientos <fit...@ubuntu.com>
diff --git a/source/text/scalc/01/04060106.xhp
b/source/text/scalc/01/04060106.xhp
index a49299e34..61e035574 100644
--- a/source/text/scalc/01/04060106.xhp
+++ b/source/text/scalc/01/04060106.xhp
@@ -1521,13 +1521,16 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_RANDBETWEEN_NV"
id="bm_id601590240409484" localize="false"/>
<h2 id="hd_id171590240366277">RANDBETWEEN.NV</h2>
<paragraph role="paragraph" id="par_id391590240473510"><ahelp
hid="HID_FUNC_RANDBETWEEN_NV">Returns an non-volatile integer random number in
a specified range.</ahelp></paragraph>
-<embed href="text/scalc/00/avail_release.xhp#7.0"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id181590240522012">RANDBETWEEN.NV(Bottom;
Top)</paragraph>
<paragraph role="paragraph" id="par_id91590242400917">Returns an non-volatile
integer random number between integers <emph>Bottom</emph> and <emph>Top</emph>
(both inclusive). A non-volatile function is not recalculated at new input
events or pressing <keycode>F9</keycode>. However, the function is recalculated
when pressing <keycode>F9</keycode> with the cursor on the cell containing the
function, when opening the file, and when <emph>Top</emph> or
<emph>Bottom</emph> are recalculated.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph"
id="par_id151590240999839"><input>=RANDBETWEEN.NV(20;30)</input> returns a
non-volatile integer between 20 and 30.</paragraph>
<paragraph role="paragraph"
id="par_id1001590241005601"><input>=RANDBETWEEN.NV(A1;30)</input> returns a
non-volatile integer between the value of cell A1 and 30. The function is
recalculated when the contents of cell A1 change.</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+<embed href="text/scalc/00/avail_release.xhp#7.0"/>
+<embed href="text/scalc/01/common_func.xhp#notODFF"/>
+<paragraph role="paragraph" id="par_id311650873986703"
localize="false"><literal>ORG.LIBREOFFICE.RANDBETWEEN.NV</literal></paragraph>
</section>
<section id="Section3">
@@ -1566,12 +1569,15 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_RAND_NV"
id="bm_id111590240232198" localize="false"/>
<h2 id="hd_id71590238179170">RAND.NV</h2>
<paragraph role="paragraph" id="par_id101590238875834"><ahelp
hid="HID_FUNC_RAND_NV">Returns a non-volatile random number between 0 and
1.</ahelp></paragraph>
-<embed href="text/scalc/00/avail_release.xhp#7.0"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id391590238945182">RAND.NV()</paragraph>
<paragraph role="paragraph" id="par_id271590239748534">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 <keycode>F9</keycode>, except when the cursor is on the cell
containing the function. The function is recalculated when opening the
file.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph"
id="par_id191590241215013"><input>=RAND.NV()</input> returns a non-volatile
random number between 0 and 1.</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+<embed href="text/scalc/00/avail_release.xhp#7.0"/>
+<embed href="text/scalc/01/common_func.xhp#notODFF"/>
+<paragraph role="paragraph" id="par_id311640873986703"
localize="false"><literal>ORG.LIBREOFFICE.RAND.NV</literal></paragraph>
</section>
</sort>
diff --git a/source/text/scalc/01/func_color.xhp
b/source/text/scalc/01/func_color.xhp
index 2affaf631..26b6b6722 100644
--- a/source/text/scalc/01/func_color.xhp
+++ b/source/text/scalc/01/func_color.xhp
@@ -45,5 +45,9 @@
<paragraph id="par_id1102201618185326" role="paragraph"
xml-lang="en-US"><item type="input">COLOR(0;0;255;255)</item> returns
4278190335 </paragraph>
<paragraph id="par_id1102201618188326" role="paragraph"
xml-lang="en-US"><item type="input">COLOR(0;0;400;0)</item> returns Err:502
(Invalid argument) because the blue value is greater than 255.
</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+ <embed href="text/scalc/00/avail_release.xhp#4.4"/>
+ <embed href="text/scalc/01/common_func.xhp#notODFF"/>
+ <paragraph role="paragraph" id="par_id311640873986703"
localize="false"><literal>ORG.LIBREOFFICE.COLOR</literal></paragraph>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_forecastetsmult.xhp
b/source/text/scalc/01/func_forecastetsmult.xhp
index cc8926af1..49ea19fd5 100644
--- a/source/text/scalc/01/func_forecastetsmult.xhp
+++ b/source/text/scalc/01/func_forecastetsmult.xhp
@@ -23,13 +23,12 @@
<bookmark_value>FORECAST.ETS.MULT function</bookmark_value>
</bookmark>
-<paragraph id="hd_id0603201610022291" role="heading" level="1"
xml-lang="en-US"><link href="text/scalc/01/func_forecastetsmult.xhp">
FORECAST.ETS.MULT Function</link></paragraph>
+<h1 id="hd_id0603201610022291"><link
href="text/scalc/01/func_forecastetsmult.xhp">FORECAST.ETS.MULT
Function</link></h1>
<paragraph id="par_id0603201610023949" role="paragraph"
xml-lang="en-US"><ahelp hid="HID_FUNC_FORECAST_ETS_MULT">Calculates the
multiplicative forecast(s) (future values) based on the historical data using
ETS or EDS algorithms</ahelp>. EDS is used when argument
<emph>period_length</emph> is 0, otherwise ETS is used.</paragraph>
<embed href="text/scalc/01/exponsmooth_embd.xhp#intro"/>
<paragraph id="par_id0603201608440530" role="paragraph"
xml-lang="en-US">FORECAST.ETS.MULT calculates with the model </paragraph>
<embed href="text/scalc/01/exponsmooth_embd.xhp#etsmult"/>
-<embed href="text/scalc/00/avail_release.xhp#5.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id0403201618594544" role="code"
xml-lang="en-US">FORECAST.ETS.MULT(targets, values, timeline, [period_length],
[data_completion], [aggregation]) </paragraph>
<embed href="text/scalc/01/exponsmooth_embd.xhp#target"/>
@@ -44,7 +43,10 @@
<paragraph id="hd_id04032016112394554" role="paragraph"
xml-lang="en-US">Returns 131.71437427439, the multiplicative forecast for
January 2014 based on <emph>Values</emph> and <emph>Timeline</emph> named
ranges above, with one sample per period, no missing data, and AVERAGE as
aggregation.</paragraph>
<paragraph id="hd_id04032123185123" role="code"
xml-lang="en-US">=FORECAST.ETS.MULT(DATE(2014;1;1);Values;Timeline;4;TRUE();7)</paragraph>
<paragraph id="hd_id040312316112394554" role="paragraph"
xml-lang="en-US">Returns 120.747806144882, the multiplicative forecast for
January 2014 based on <emph>Values</emph> and <emph>Timeline</emph> named
ranges above, with period length of 4, no missing data, and SUM as
aggregation.</paragraph>
-
+ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+ <embed href="text/scalc/00/avail_release.xhp#5.2"/>
+ <embed href="text/scalc/01/common_func.xhp#notODFF"/>
+ <paragraph role="paragraph" id="par_id311640873986703"
localize="false"><literal>ORG.LIBREOFFICE.FORECAST.ETS.MULT</literal></paragraph>
</section>
<section id="relatedtopics">
<paragraph id="par_id0603201619261276" role="paragraph" xml-lang="en-US">See
also:
diff --git a/source/text/scalc/01/func_forecastetspimult.xhp
b/source/text/scalc/01/func_forecastetspimult.xhp
index 002f8fefa..b5d5c1eb9 100644
--- a/source/text/scalc/01/func_forecastetspimult.xhp
+++ b/source/text/scalc/01/func_forecastetspimult.xhp
@@ -23,13 +23,12 @@
<bookmark_value>FORECAST.ETS.PI.MULT function</bookmark_value>
</bookmark>
-<paragraph id="hd_id0603201617134175" role="heading" level="1"
xml-lang="en-US"><link
href="text/scalc/01/func_forecastetspimult.xhp">FORECAST.ETS.PI.MULT
function</link></paragraph>
+<h1 id="hd_id0603201617134175"><link
href="text/scalc/01/func_forecastetspimult.xhp">FORECAST.ETS.PI.MULT
function</link></h1>
<paragraph id="par_id0603201617141750" role="paragraph"
xml-lang="en-US"><ahelp hid="HID_FUNC_FORECAST_ETS_PIM">Calculates the
prediction interval(s) for multiplicative forecast based on the historical data
using ETS or EDS algorithms.</ahelp>. EDS is used when argument
<emph>period_length</emph> is 0, otherwise ETS is used.</paragraph>
<embed href="text/scalc/01/exponsmooth_embd.xhp#intro"/>
<paragraph id="par_id0603201610005998" role="paragraph"
xml-lang="en-US">FORECAST.ETS.PI.MULT calculates with the model</paragraph>
<embed href="text/scalc/01/exponsmooth_embd.xhp#etsmult"/>
-<embed href="text/scalc/00/avail_release.xhp#5.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id0603201610010044" role="code"
xml-lang="en-US">FORECAST.ETS.PI.MULT(target, values, timeline,
[confidence_level], [period_length], [data_completion],
[aggregation])</paragraph>
<embed href="text/scalc/01/exponsmooth_embd.xhp#target"/>
@@ -40,7 +39,7 @@
<embed href="text/scalc/01/exponsmooth_embd.xhp#datacompletion"/>
<embed href="text/scalc/01/exponsmooth_embd.xhp#aggregation"/>
<paragraph id="par_id0403201618595126" role="paragraph" xml-lang="en-US">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).
</paragraph>
-<paragraph id="par_id0403201618595143" role="note" xml-lang="en-US">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.</paragraph>
+<note id="par_id0403201618595143">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>
<paragraph id="par_id0403201618595150" role="paragraph" xml-lang="en-US">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).</paragraph>
<embed href="text/scalc/01/exponsmooth_embd.xhp#exampledata"/>
@@ -48,6 +47,10 @@
<paragraph id="hd_id04032016112394554" role="paragraph"
xml-lang="en-US">Returns 20.1040952101013, the prediction interval for
multiplicative forecast for January 2014 based on <emph>Values</emph> and
<emph>Timeline</emph> named ranges above, confidence level of 90% (=0.9) with
one sample per period, no missing data, and AVERAGE as aggregation.</paragraph>
<paragraph id="hd_id04032123185123" role="code"
xml-lang="en-US">=FORECAST.ETS.PI.MULT(DATE(2014;1;1);Values;Timeline;0.8;4;TRUE();7)</paragraph>
<paragraph id="hd_id040312316112394554" role="paragraph"
xml-lang="en-US">Returns 27.5285874381574, the prediction interval for
multiplicative forecast for January 2014 based on <emph>Values</emph> and
<emph>Timeline</emph> named ranges above, with confidence level of 0.8, period
length of 4, no missing data, and SUM as aggregation.</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+ <embed href="text/scalc/00/avail_release.xhp#5.2"/>
+ <embed href="text/scalc/01/common_func.xhp#notODFF"/>
+ <paragraph role="paragraph" id="par_id311640873986703"
localize="false"><literal>ORG.LIBREOFFICE.FORECAST.ETS.PI.MULT</literal></paragraph>
</section>
<section id="relatedtopics">
<paragraph id="par_id0603201619261276" role="paragraph" xml-lang="en-US">See
also:
diff --git a/source/text/scalc/01/func_forecastetsstatmult.xhp
b/source/text/scalc/01/func_forecastetsstatmult.xhp
index 7ac7d527c..4c818cb67 100644
--- a/source/text/scalc/01/func_forecastetsstatmult.xhp
+++ b/source/text/scalc/01/func_forecastetsstatmult.xhp
@@ -24,13 +24,12 @@
<bookmark_value>FORECAST.ETS.STAT.MULT function</bookmark_value>
</bookmark>
-<paragraph id="hd_id0603201615483251" role="heading" level="1"
xml-lang="en-US"><link
href="text/scalc/01/func_forecastetsstatmult.xhp">FORECAST.ETS.STAT.MULT
Function</link></paragraph>
+<h1 id="hd_id0603201615483251"><link
href="text/scalc/01/func_forecastetsstatmult.xhp">FORECAST.ETS.STAT.MULT
Function</link></h1>
<paragraph id="par_id0603201615485387" role="paragraph"
xml-lang="en-US"><ahelp hid="HID_FUNC_FORECAST_ETS_STM">Returns statistical
value(s) that are results of the ETS/EDS algorithms.</ahelp></paragraph>
<embed href="text/scalc/01/exponsmooth_embd.xhp#intro"/>
<paragraph id="par_id0603201608440530" role="paragraph"
xml-lang="en-US">FORECAST.ETS.STAT.MULT calculates with the model </paragraph>
<embed href="text/scalc/01/exponsmooth_embd.xhp#etsmult"/>
-<embed href="text/scalc/00/avail_release.xhp#5.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id0603201610005728" role="code"
xml-lang="en-US">FORECAST.ETS.STAT.MULT (values, timeline, stat_type,
[period_length], [data_completion], [aggregation])</paragraph>
<embed href="text/scalc/01/exponsmooth_embd.xhp#values"/>
@@ -45,6 +44,10 @@
<paragraph id="hd_id04032016112394554" role="paragraph"
xml-lang="en-US">Returns 0.084073452803966, the multiplicative statistics based
on <emph>Values</emph> and <emph>Timeline</emph> named ranges above, with
symmetric mean absolute percentage error (SMAPE), one sample per period, no
missing data, and AVERAGE as aggregation.</paragraph>
<paragraph id="hd_id04032123185123" role="code"
xml-lang="en-US">=FORECAST.ETS.STAT.MULT(Values;Timeline;7;1;TRUE();7)</paragraph>
<paragraph id="hd_id040312316112394554" role="paragraph"
xml-lang="en-US">Returns 15.8372533480997, the multiplicative statistics based
on <emph>Values</emph> and <emph>Timeline</emph> named ranges above, with root
mean squared error, no missing data, and SUM as aggregation.</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+ <embed href="text/scalc/00/avail_release.xhp#5.2"/>
+ <embed href="text/scalc/01/common_func.xhp#notODFF"/>
+ <paragraph role="paragraph" id="par_id311640873986703"
localize="false"><literal>ORG.LIBREOFFICE.FORECAST.ETS.STAT.MULT</literal></paragraph>
</section>
<section id="relatedtopics">
<paragraph id="par_id0603201619261276" role="paragraph" xml-lang="en-US">See
also:
diff --git a/source/text/scalc/01/func_fourier.xhp
b/source/text/scalc/01/func_fourier.xhp
index 9aad60e3d..d34910924 100644
--- a/source/text/scalc/01/func_fourier.xhp
+++ b/source/text/scalc/01/func_fourier.xhp
@@ -24,7 +24,6 @@
<h2 id="hd_id551556227727946"><variable id="fourierfunct"><link
href="text/scalc/01/func_fourier.xhp"
name="fourierfunction">FOURIER</link></variable></h2>
<paragraph id="par_id121556227727948" role="paragraph"><variable
id="textjoinfunction"><ahelp hid=".">Computes the Discrete Fourier Transform
[DFT] of an input array of complex numbers using a couple of Fast Fourier
Transform (FFT) algorithms.</ahelp></variable> The function is an <link
href="text/scalc/01/04060107.xhp" name="array formula">array
formula</link>.</paragraph>
</section>
- <embed href="text/scalc/00/avail_release.xhp#6.3"/>
<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
<paragraph role="code" id="par_id541556228253979">FOURIER(Array;
GroupedByColumns [; Inverse [; Polar [; MinimumMagnitude]]])</paragraph>
@@ -40,6 +39,10 @@
<embed href="text/scalc/01/ful_func.xhp#func_head_example"/>
<embed href="text/scalc/01/stat_data.xhp#fourierdata"/>
<embed href="text/scalc/06/calcsamplefiles.xhp#func_fourier"/>
+ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+ <embed href="text/scalc/00/avail_release.xhp#6.3"/>
+ <embed href="text/scalc/01/common_func.xhp#notODFF"/>
+ <paragraph role="paragraph" id="par_id311640873986703"
localize="false"><literal>ORG.LIBREOFFICE.FOURIER</literal></paragraph>
<section id="relatedtopics">
<embed href="text/scalc/01/statistics_fourier.xhp#fourieranalysysh1"/>
<embed href="text/scalc/01/04060107.xhp#arrayfunctit"/>
diff --git a/source/text/scalc/01/func_rawsubtract.xhp
b/source/text/scalc/01/func_rawsubtract.xhp
index 7152b8dbe..55fea74db 100644
--- a/source/text/scalc/01/func_rawsubtract.xhp
+++ b/source/text/scalc/01/func_rawsubtract.xhp
@@ -25,7 +25,6 @@
<h1 id="hd_2016112109231"><link
href="text/scalc/01/func_rawsubtract.xhp">RAWSUBTRACT</link></h1>
<paragraph id="par_2016112109232" role="paragraph"
xml-lang="en-US"><ahelp hid=".">Subtracts a set of numbers and gives the result
without eliminating small roundoff errors.</ahelp></paragraph>
</section>
- <embed href="text/scalc/00/avail_release.xhp#5.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_2016112109233" role="code"
xml-lang="en-US">RAWSUBTRACT(Minuend; Subtrahend 1[; Subtrahend 2][; … ;[
Subtrahend 254]])</paragraph>
<paragraph id="par_2016112109234" role="paragraph"
xml-lang="en-US"><emph>Minuend</emph> is a number or a reference to a cell
containing a number.</paragraph>
@@ -35,6 +34,10 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_2016112109236" role="paragraph"
xml-lang="en-US"><input>=RAWSUBTRACT(0.987654321098765,
0.9876543210987)</input> returns 6.53921361504217E-14</paragraph>
<paragraph id="par_2016112109237" role="paragraph"
xml-lang="en-US"><input>=RAWSUBTRACT(0.987654321098765)</input> returns Err:511
(Missing variable) because RAWSUBTRACT requires a minimum of two numbers.
</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+ <embed href="text/scalc/00/avail_release.xhp#5.2"/>
+ <embed href="text/scalc/01/common_func.xhp#notODFF"/>
+ <paragraph role="paragraph" id="par_id311640873986703"
localize="false"><literal>ORG.LIBREOFFICE.RAWSUBTRACT</literal></paragraph>
</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_regex.xhp
b/source/text/scalc/01/func_regex.xhp
index 9c48cf219..3b29f7492 100644
--- a/source/text/scalc/01/func_regex.xhp
+++ b/source/text/scalc/01/func_regex.xhp
@@ -23,10 +23,9 @@
<bookmark_value>regular expressions;extracting in
spreadsheets</bookmark_value>
<bookmark_value>regular expressions;REGEX function</bookmark_value>
</bookmark>
- <paragraph id="hd_id961542230672100" role="heading" level="1"
xml-lang="en-US"><link href="text/scalc/01/func_regex.xhp" name="function
REGEX">REGEX</link></paragraph>
+ <h1 id="hd_id961542230672100"><link
href="text/scalc/01/func_regex.xhp" name="function REGEX">REGEX</link></h1>
<paragraph id="par_id541542230672101" role="paragraph"
xml-lang="en-US"><variable id="func_regex_desc"><ahelp hid=".">Matches and
extracts or optionally replaces text using regular
expressions.</ahelp></variable></paragraph>
</section>
- <embed href="text/scalc/00/avail_release.xhp#6.2"/>
<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
<paragraph role="code" id="par_id701542231253817" xml-lang="en-US">REGEX(
Text ; Expression [ ; [ Replacement ] [ ; Flags|Occurrence ] ] )</paragraph>
<paragraph role="paragraph" id="par_id621542232197446"
xml-lang="en-US"><emph>Text</emph>: A text or reference to a cell where the
regular expression is to be applied.</paragraph>
@@ -40,6 +39,10 @@
<paragraph role="paragraph" id="par_id21542291705695"
xml-lang="en-US"><item
type="input">=REGEX("123456ABCDEF";"[126]";"";"g")</item> returns "345ABCDEF",
where any occurrence of "1", "2" or "6" is replaced by the empty string, thus
deleted. </paragraph>
<paragraph role="paragraph" id="par_id371542291684177"
xml-lang="en-US"><item type="input">=REGEX("axbxcxd";".x";;2)</item> returns
"bx", the second match of ".x".</paragraph>
<paragraph role="paragraph" id="par_id371542291684178"
xml-lang="en-US"><item type="input">=REGEX("axbxcxd";"(.)x";"$1y";2)</item>
returns "axbycxd", the second match of "(.)x" (i.e. "bx") replaced with the
captured group of one character (i.e. "b") followed by "y".</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+ <embed href="text/scalc/00/avail_release.xhp#6.2"/>
+ <embed href="text/scalc/01/common_func.xhp#notODFF"/>
+ <paragraph role="paragraph" id="par_id311640873986703"
localize="false"><literal>ORG.LIBREOFFICE.REGEX</literal></paragraph>
<section id="relatedtopics">
<paragraph role="paragraph" id="par_id711542233602553"
xml-lang="en-US"><link href="text/shared/01/02100001.xhp" name="regex
lists">List of regular expressions</link></paragraph>
<paragraph role="paragraph" id="par_id431542233650614"
xml-lang="en-US"><link
href="https://unicode-org.github.io/icu/userguide/strings/regexp.html";
name="ICU REGEXP">ICU regular expressions</link></paragraph>
diff --git a/source/text/scalc/01/func_roundsig.xhp
b/source/text/scalc/01/func_roundsig.xhp
index 86d6cd6cf..6e96d0a58 100644
--- a/source/text/scalc/01/func_roundsig.xhp
+++ b/source/text/scalc/01/func_roundsig.xhp
@@ -16,20 +16,19 @@
</meta>
<body>
<section id="roundsig">
- <bookmark id="bm_id391519154702177" xml-lang="en-US"
branch="hid/SC_HID_FUNC_ROUNDSIG" localize="false"/>
+ <bookmark id="bm_id391519154702177" xml-lang="en-US"
branch="hid/SC_HID_FUNC_ROUNDSIG" localize="false"/>
<bookmark xml-lang="en-US" branch="index" id="bm_id151519154954070">
<bookmark_value>ROUNDSIG Function</bookmark_value>
</bookmark>
- <paragraph id="hd_id351519154702177" role="heading" level="1"
xml-lang="en-US"><link href="text/scalc/01/func_roundsig.xhp" name="command
name">ROUNDSIG</link></paragraph>
+ <h1 id="hd_id351519154702177"><link
href="text/scalc/01/func_roundsig.xhp" name="function
roundsig">ROUNDSIG</link></h1>
<paragraph id="par_id921519154702177" role="paragraph"
xml-lang="en-US"><variable id="roundsig"><ahelp hid="HID_FUNC_ROUNDSIG">Returns
a number rounded to a specified number of significant decimal digits of its
normalized floating point notation.</ahelp></variable></paragraph>
</section>
- <embed href="text/scalc/00/avail_release.xhp#5.4"/>
<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
<paragraph role="code" id="par_id291519155534115"
xml-lang="en-US">ROUNDSIG( Value; Digits )</paragraph>
<paragraph role="paragraph" id="par_id51519155217204"
xml-lang="en-US"><emph>Value</emph>: the number to be rounded.</paragraph>
<paragraph role="paragraph" id="par_id321519155209912"
xml-lang="en-US"><emph>Digits</emph>: the number of decimal places to
round.</paragraph>
- <paragraph role="warning" id="par_id371519155264297"
xml-lang="en-US"><emph>Digits</emph> must be an integer greater than
0.</paragraph>
+ <warning id="par_id371519155264297"><emph>Digits</emph> must be an integer
greater than 0.</warning>
<embed href="text/scalc/01/ful_func.xhp#func_head_example"/>
@@ -37,6 +36,10 @@
<paragraph role="paragraph" id="par_id821519155475673"
xml-lang="en-US"><item type="input">=ROUNDSIG(0.000123456789; 5)</item> returns
0.00012346</paragraph>
<paragraph role="paragraph" id="par_id381519155481234"
xml-lang="en-US"><item type="input">=ROUNDSIG(123456789012345; 2)</item>
returns 1.2E14</paragraph>
<paragraph role="paragraph" id="par_id231519155486155"
xml-lang="en-US"><item type="input">=ROUNDSIG(123456789; 4)</item> returns
123500000 or 123.5E6</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+ <embed href="text/scalc/00/avail_release.xhp#5.4"/>
+ <embed href="text/scalc/01/common_func.xhp#notODFF"/>
+ <paragraph role="paragraph" id="par_id311640873986703"
localize="false"><literal>ORG.LIBREOFFICE.ROUNDSIG</literal></paragraph>
<section id="relatedtopics">
<paragraph role="paragraph" id="par_id51519156941987"
xml-lang="en-US">See also <link href="text/scalc/01/04060106.xhp#Section21"
name="ROUND function">ROUND</link>, <link
href="text/scalc/01/04060106.xhp#Section7" name="MROUND
function">MROUND</link>, <link href="text/scalc/01/04060106.xhp#Section19"
name="ROUNDUP function">ROUNDUP</link>, <link
href="text/scalc/01/04060106.xhp#Section20" name="ROUNDDOWN
function">ROUNDDOWN</link>.</paragraph>
</section>
diff --git a/source/text/scalc/01/func_weeknum_ooo.xhp
b/source/text/scalc/01/func_weeknum_ooo.xhp
index a4de84092..28519d22a 100644
--- a/source/text/scalc/01/func_weeknum_ooo.xhp
+++ b/source/text/scalc/01/func_weeknum_ooo.xhp
@@ -44,6 +44,10 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph" id="par_id3150704" xml-lang="en-US"><item
type="input">=WEEKNUM_OOO(DATE(1995;1;1);1)</item> returns 1</paragraph>
<paragraph role="paragraph" id="par_id3149792" xml-lang="en-US"><item
type="input">=WEEKNUM_OOO(DATE(1995;1;1);2)</item> returns 52. Week 1 starts
on Monday, 1995-01-02.</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+<embed href="text/scalc/00/avail_release.xhp#5.1"/>
+<embed href="text/scalc/01/common_func.xhp#notODFF"/>
+<paragraph role="paragraph" id="par_id311640873986703"
localize="false"><literal>ORG.LIBREOFFICE.WEEKNUM_OOO</literal></paragraph>
<section id="relatedtopics">
<embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
</section>
commit 990e1236dc288bca7e7c8678353f505e9d1e9116
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Sat Jan 1 08:41:22 2022 -0300
Commit: Adolfo Jayme Barrientos <fit...@ubuntu.com>
CommitDate: Sun Jan 2 13:41:16 2022 +0100
tdf#94537 ORG.OPENOFFICE.* namespace information
+ removed reference to other suite interoperability
Change-Id: Ide0fe6dd306e1cd3fa2e0a7377b16fb1a6e89f58
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/127839
Tested-by: Jenkins
Reviewed-by: Adolfo Jayme Barrientos <fit...@ubuntu.com>
diff --git a/source/text/scalc/01/04060104.xhp
b/source/text/scalc/01/04060104.xhp
index b58ecf801..f45da63d7 100644
--- a/source/text/scalc/01/04060104.xhp
+++ b/source/text/scalc/01/04060104.xhp
@@ -218,6 +218,9 @@
<paragraph id="par_id7463911" role="paragraph" xml-lang="en-US">The example
returns A2 + B2 (STYLE returns 0 here). If this sum is greater than 10, the
style Red is applied to the cell. See the <emph>STYLE</emph> function for more
explanation.</paragraph>
<paragraph id="par_id7318643" role="paragraph" xml-lang="en-US"><item
type="input">="choo"&CURRENT()</item></paragraph>
<paragraph id="par_id6019165" role="paragraph" xml-lang="en-US">The example
returns choochoo.</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+<embed href="text/scalc/01/common_func.xhp#notODFF"/>
+<paragraph role="paragraph" id="par_id311640873986703"
localize="false"><literal>ORG.OPENOFFICE.CURRENT</literal></paragraph>
</section>
<section id="formula">
<bookmark xml-lang="en-US" branch="index" id="bm_id3150688">
@@ -736,4 +739,4 @@
<embed href="text/scalc/01/04060100.xhp#drking"/>
</section>
</body>
-</helpdocument>
\ No newline at end of file
+</helpdocument>
diff --git a/source/text/scalc/01/04060109.xhp
b/source/text/scalc/01/04060109.xhp
index 17fb83262..98b802017 100644
--- a/source/text/scalc/01/04060109.xhp
+++ b/source/text/scalc/01/04060109.xhp
@@ -166,6 +166,9 @@
<emph>Reference</emph> contains the address of the cell in which
the error occurs.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3146904" role="paragraph">If
cell A1 displays Err:518, the function <item type="input">=ERRORTYPE(A1)</item>
returns the number 518.</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+ <embed href="text/scalc/01/common_func.xhp#notODFF"/>
+ <paragraph role="paragraph" id="par_id311640873986703"
localize="false"><literal>ORG.OPENOFFICE.ERRORTYPE</literal></paragraph>
</section>
<section id="error_type">
<h2 id="hd_id275141466817507" localize="false"><embedvar
href="text/scalc/01/func_error_type.xhp#error_type_head"/></h2>
@@ -432,6 +435,9 @@
<item type="input">="Text"&T(STYLE("myStyle"))</item>
</paragraph>
<paragraph xml-lang="en-US" id="par_id3042085" role="paragraph">See
also CURRENT() for another example.</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+ <embed href="text/scalc/01/common_func.xhp#notODFF"/>
+ <paragraph role="paragraph" id="par_id311644873986703"
localize="false"><literal>ORG.OPENOFFICE.STYLE</literal></paragraph>
</section>
<section id="Section16">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3150430"><bookmark_value>CHOOSE function</bookmark_value>
diff --git a/source/text/scalc/01/04060111.xhp
b/source/text/scalc/01/04060111.xhp
index 398b49b57..6b71378b5 100644
--- a/source/text/scalc/01/04060111.xhp
+++ b/source/text/scalc/01/04060111.xhp
@@ -55,6 +55,9 @@
<paragraph role="paragraph" id="par_id3150786"
xml-lang="en-US">=ISLEAPYEAR(A1) returns 1, if A1 contains 1968-02-29, the
valid date 29th of February 1968 in your locale setting.</paragraph>
<paragraph role="paragraph" id="par_idN107E7" xml-lang="en-US">You may also
use =ISLEAPYEAR(DATE(1968;2;29)) or =ISLEAPYEAR("1968-02-29") giving the date
string in the ISO 8601 notation.</paragraph>
<paragraph role="paragraph" id="par_idN107EA" xml-lang="en-US">Never use
=ISLEAPYEAR(2/29/68), because this would first evaluate 2 divided by 29 divided
by 68, and then calculate the ISLEAPYEAR function from this small number as a
serial date number.</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+<embed href="text/scalc/01/common_func.xhp#notODFF"/>
+<paragraph role="paragraph" id="par_id311600873986703"
localize="false"><literal>ORG.OPENOFFICE.ISLEAPYEAR</literal></paragraph>
</section>
<section id="years">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3154656"><bookmark_value>YEARS function</bookmark_value>
@@ -71,6 +74,9 @@
<emph>EndDate</emph> is the second date</paragraph>
<paragraph role="paragraph" id="par_id3152893" xml-lang="en-US">
<emph>Type</emph> calculates the type of difference. Possible values are 0
(interval) and 1 (in calendar years).</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+<embed href="text/scalc/01/common_func.xhp#notODFF"/>
+<paragraph role="paragraph" id="par_id311640873086703"
localize="false"><literal>ORG.OPENOFFICE.YEARS</literal></paragraph>
</section>
<section id="months">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3152898"><bookmark_value>MONTHS function</bookmark_value>
@@ -87,6 +93,9 @@
<emph>EndDate</emph> is the second date</paragraph>
<paragraph role="paragraph" id="par_id3150111" xml-lang="en-US">
<emph>Type</emph> calculates the type of difference. Possible values include 0
(interval) and 1 (in calendar months).</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+<embed href="text/scalc/01/common_func.xhp#notODFF"/>
+<paragraph role="paragraph" id="par_id321640873986703"
localize="false"><literal>ORG.OPENOFFICE.MONTHS</literal></paragraph>
</section>
<section id="rot13">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3159094"><bookmark_value>ROT13 function</bookmark_value>
@@ -101,7 +110,10 @@
<emph>Text</emph> is the character string to be encrypted. ROT13(ROT13(Text))
decrypts the code.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id151626469224135" role="paragraph"><input>=ROT13("Gur
Qbphzrag Sbhaqngvba jnf sbhaqrq va Frcgrzore 2010.")</input> returns the string
"The Document Foundation was founded in September 2010.". Notice how spaces,
digits, and full stops are unaffected by ROT13.</paragraph>
-<tip id="par_id221626469509161">Refer to the <link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/ROT13";
name="ROT13_Wiki">ROT13</link> wiki page for more details about this
function.</tip>
+<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+<embed href="text/scalc/01/common_func.xhp#notODFF"/>
+<paragraph role="paragraph" id="par_id314640873986703"
localize="false"><literal>ORG.OPENOFFICE.ROT13</literal></paragraph>
+<tip id="par_id221626469509161">Refer to the <link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/ROT13";
name="ROT13_Wiki">ROT13</link> wiki page for more details about this
function.</tip>
</section>
<section id="daysinyear">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3151300"><bookmark_value>DAYSINYEAR function</bookmark_value>
@@ -116,6 +128,9 @@
<emph>Date</emph> is any date in the respective year. The Date parameter must
be a valid date according to the locale settings of %PRODUCTNAME.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph" id="par_id3153811"
xml-lang="en-US">=DAYSINYEAR(A1) returns 366 days if A1 contains 1968-02-29, a
valid date for the year 1968.</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+<embed href="text/scalc/01/common_func.xhp#notODFF"/>
+<paragraph role="paragraph" id="par_id311640873586703"
localize="false"><literal>ORG.OPENOFFICE.DAYSINYEAR</literal></paragraph>
</section>
<section id="daysinmonth">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3154737"><bookmark_value>DAYSINMONTH function</bookmark_value>
@@ -130,6 +145,9 @@
<emph>Date</emph> is any date in the respective month of the desired year. The
Date parameter must be a valid date according to the locale settings of
%PRODUCTNAME.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph" id="par_id3155742"
xml-lang="en-US">=DAYSINMONTH(A1) returns 29 days if A1 contains 1968-02-17, a
valid date for February 1968.</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+<embed href="text/scalc/01/common_func.xhp#notODFF"/>
+<paragraph role="paragraph" id="par_id311640873986700"
localize="false"><literal>ORG.OPENOFFICE.DAYSINMONTH</literal></paragraph>
</section>
<section id="weeks">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3149048"><bookmark_value>WEEKS function</bookmark_value>
@@ -146,6 +164,9 @@
<emph>EndDate</emph> is the second date</paragraph>
<paragraph role="paragraph" id="par_id3166467" xml-lang="en-US">
<emph>Type</emph> calculates the type of difference. The possible values are 0
(interval) and 1 (in numbers of weeks).</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+<embed href="text/scalc/01/common_func.xhp#notODFF"/>
+<paragraph role="paragraph" id="par_id311640873986703"
localize="false"><literal>ORG.OPENOFFICE.WEEKS</literal></paragraph>
</section>
<section id="weeksinyear">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3145237"><bookmark_value>WEEKSINYEAR function</bookmark_value>
@@ -160,6 +181,9 @@
<emph>Date</emph> is any date in the respective year. The Date parameter must
be a valid date according to the locale settings of %PRODUCTNAME.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph" id="par_id3147614"
xml-lang="en-US">WEEKSINYEAR(A1) returns 53 if A1 contains 1970-02-17, a valid
date for the year 1970.</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+<embed href="text/scalc/01/common_func.xhp#notODFF"/>
+<paragraph role="paragraph" id="par_id311540873986703"
localize="false"><literal>ORG.OPENOFFICE.WEEKSINYEAR</literal></paragraph>
</section>
</sort>
<h2 id="hd_id3157901">Add-ins through %PRODUCTNAME API</h2>
diff --git a/source/text/scalc/01/common_func.xhp
b/source/text/scalc/01/common_func.xhp
index 309162d1d..21fb6f552 100644
--- a/source/text/scalc/01/common_func.xhp
+++ b/source/text/scalc/01/common_func.xhp
@@ -28,7 +28,7 @@
<h3 id="hd_id301640873452726">Technical information</h3>
</section>
<section id="notODFF">
- <paragraph role="paragraph" id="par_id251640873774457">This function
is not part of the <emph>Open Document Format for Office Applications
(OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula)
Format</emph> standard and was introduced for interoperability with other
office suites. The name space is</paragraph>
+ <paragraph role="paragraph" id="par_id251640873774457">This function
is not part of the <emph>Open Document Format for Office Applications
(OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula)
Format</emph> standard. The name space is</paragraph>
</section>
<section id="datenumbersequencenote">
<note id="par_id301616845402409">This function ignores any text or
empty cell within a data range. If you suspect wrong results from this
function, look for text in the data ranges. To highlight text contents in a
data range, use the <link href="text/scalc/01/03080000.xhp" name="value
highlight">value highlighting</link> feature.</note>
diff --git a/source/text/scalc/01/func_convert.xhp
b/source/text/scalc/01/func_convert.xhp
index 90dc06254..382c82cad 100644
--- a/source/text/scalc/01/func_convert.xhp
+++ b/source/text/scalc/01/func_convert.xhp
@@ -1733,7 +1733,9 @@
</tablecell>
</tablerow>
</table>
-
+ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+ <embed href="text/scalc/01/common_func.xhp#notODFF"/>
+ <paragraph role="paragraph" id="par_id311640873986703"
localize="false"><literal>ORG.OPENOFFICE.CONVERT</literal></paragraph>
<section id="relatedtopics">
<paragraph role="paragraph" id="par_id871621424421294"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/CONVERT";>CONVERT
Wiki page</link></paragraph>
</section>
diff --git a/source/text/scalc/01/func_eastersunday.xhp
b/source/text/scalc/01/func_eastersunday.xhp
index 5cb4fe7de..8227311c4 100644
--- a/source/text/scalc/01/func_eastersunday.xhp
+++ b/source/text/scalc/01/func_eastersunday.xhp
@@ -40,6 +40,9 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph" id="par_id3154472" xml-lang="en-US"><item
type="input">=EASTERSUNDAY(2000)</item> returns 2000-04-23.</paragraph>
<paragraph role="paragraph" id="par_id3150940" xml-lang="en-US"><item
type="input">=EASTERSUNDAY(2000)+49</item> returns the internal serial number
36688. The result is 2000-06-11. Format the serial date number as a date, for
example in the format YYYY-MM-DD.</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+<embed href="text/scalc/01/common_func.xhp#notODFF"/>
+<paragraph role="paragraph" id="par_id311640873986703"
localize="false"><literal>ORG.OPENOFFICE.EASTERSUNDAY</literal></paragraph>
<section id="relatedtopics">
<embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
</section>
