diff options
author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2022-01-01 09:52:45 -0300 |
---|---|---|
committer | Adolfo Jayme Barrientos <fitojb@ubuntu.com> | 2022-01-02 13:41:32 +0100 |
commit | c7e7800abe70df5f14c03c63a829ed74d403a5fd (patch) | |
tree | d313a4543c7232f59cdc3bf0a241540d96f05a8e /source | |
parent | 990e1236dc288bca7e7c8678353f505e9d1e9116 (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')
-rw-r--r-- | source/text/scalc/01/04060106.xhp | 10 | ||||
-rw-r--r-- | source/text/scalc/01/func_color.xhp | 4 | ||||
-rw-r--r-- | source/text/scalc/01/func_forecastetsmult.xhp | 8 | ||||
-rw-r--r-- | source/text/scalc/01/func_forecastetspimult.xhp | 9 | ||||
-rw-r--r-- | source/text/scalc/01/func_forecastetsstatmult.xhp | 7 | ||||
-rw-r--r-- | source/text/scalc/01/func_fourier.xhp | 5 | ||||
-rw-r--r-- | source/text/scalc/01/func_rawsubtract.xhp | 5 | ||||
-rw-r--r-- | source/text/scalc/01/func_regex.xhp | 7 | ||||
-rw-r--r-- | source/text/scalc/01/func_roundsig.xhp | 11 | ||||
-rw-r--r-- | source/text/scalc/01/func_weeknum_ooo.xhp | 4 |
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> |