summaryrefslogtreecommitdiff
path: root/source/text/scalc
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@libreoffice.org>2022-01-01 09:52:45 -0300
committerAdolfo Jayme Barrientos <fitojb@ubuntu.com>2022-01-02 13:41:32 +0100
commitc7e7800abe70df5f14c03c63a829ed74d403a5fd (patch)
treed313a4543c7232f59cdc3bf0a241540d96f05a8e /source/text/scalc
parent990e1236dc288bca7e7c8678353f505e9d1e9116 (diff)
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 <fitojb@ubuntu.com>
Diffstat (limited to 'source/text/scalc')
-rw-r--r--source/text/scalc/01/04060106.xhp10
-rw-r--r--source/text/scalc/01/func_color.xhp4
-rw-r--r--source/text/scalc/01/func_forecastetsmult.xhp8
-rw-r--r--source/text/scalc/01/func_forecastetspimult.xhp9
-rw-r--r--source/text/scalc/01/func_forecastetsstatmult.xhp7
-rw-r--r--source/text/scalc/01/func_fourier.xhp5
-rw-r--r--source/text/scalc/01/func_rawsubtract.xhp5
-rw-r--r--source/text/scalc/01/func_regex.xhp7
-rw-r--r--source/text/scalc/01/func_roundsig.xhp11
-rw-r--r--source/text/scalc/01/func_weeknum_ooo.xhp4
10 files changed, 52 insertions, 18 deletions
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 @@
<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 2affaf6315..26b6b6722c 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 cc8926af18..49ea19fd57 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 002f8fefaa..b5d5c1eb99 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 7ac7d527c6..4c818cb675 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 9aad60e3de..d349109248 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 7152b8dbe6..55fea74dba 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 9c48cf2194..3b29f7492b 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 86d6cd6cf6..6e96d0a584 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 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 @@
<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>