AllLangHelp_sbasic.mk | 1 AllLangHelp_scalc.mk | 1 source/text/sbasic/shared/03/avail_release.xhp | 52 ---------- source/text/scalc/00/avail_release.xhp | 111 ---------------------- source/text/scalc/01/04060104.xhp | 2 source/text/scalc/01/04060105.xhp | 1 source/text/scalc/01/04060106.xhp | 6 - source/text/scalc/01/04060115.xhp | 2 source/text/scalc/01/04060120.xhp | 5 source/text/scalc/01/04060181.xhp | 10 - source/text/scalc/01/04060182.xhp | 10 - source/text/scalc/01/04060183.xhp | 6 - source/text/scalc/01/04060184.xhp | 12 -- source/text/scalc/01/04060185.xhp | 15 -- source/text/scalc/01/func_aggregate.xhp | 1 source/text/scalc/01/func_averageif.xhp | 1 source/text/scalc/01/func_averageifs.xhp | 1 source/text/scalc/01/func_ceiling.xhp | 4 source/text/scalc/01/func_choosecols.xhp | 1 source/text/scalc/01/func_chooserows.xhp | 1 source/text/scalc/01/func_color.xhp | 1 source/text/scalc/01/func_concat.xhp | 1 source/text/scalc/01/func_countifs.xhp | 1 source/text/scalc/01/func_datedif.xhp | 1 source/text/scalc/01/func_drop.xhp | 1 source/text/scalc/01/func_error_type.xhp | 1 source/text/scalc/01/func_expand.xhp | 1 source/text/scalc/01/func_filter.xhp | 1 source/text/scalc/01/func_findb.xhp | 1 source/text/scalc/01/func_floor.xhp | 3 source/text/scalc/01/func_forecastetsadd.xhp | 1 source/text/scalc/01/func_forecastetsmult.xhp | 1 source/text/scalc/01/func_forecastetspiadd.xhp | 1 source/text/scalc/01/func_forecastetspimult.xhp | 1 source/text/scalc/01/func_forecastetsseason.xhp | 1 source/text/scalc/01/func_forecastetsstatadd.xhp | 1 source/text/scalc/01/func_forecastetsstatmult.xhp | 1 source/text/scalc/01/func_fourier.xhp | 1 source/text/scalc/01/func_hstack.xhp | 1 source/text/scalc/01/func_ifs.xhp | 1 source/text/scalc/01/func_imcosh.xhp | 1 source/text/scalc/01/func_imcot.xhp | 1 source/text/scalc/01/func_imcsc.xhp | 1 source/text/scalc/01/func_imcsch.xhp | 1 source/text/scalc/01/func_imsec.xhp | 1 source/text/scalc/01/func_imsech.xhp | 1 source/text/scalc/01/func_imsinh.xhp | 1 source/text/scalc/01/func_imtan.xhp | 1 source/text/scalc/01/func_isoweeknum.xhp | 1 source/text/scalc/01/func_leftb.xhp | 1 source/text/scalc/01/func_lenb.xhp | 1 source/text/scalc/01/func_let.xhp | 1 source/text/scalc/01/func_maxifs.xhp | 1 source/text/scalc/01/func_midb.xhp | 1 source/text/scalc/01/func_minifs.xhp | 1 source/text/scalc/01/func_networkdays.intl.xhp | 1 source/text/scalc/01/func_numbervalue.xhp | 1 source/text/scalc/01/func_opt_barrier.xhp | 1 source/text/scalc/01/func_opt_prob_hit.xhp | 1 source/text/scalc/01/func_opt_prob_inmoney.xhp | 1 source/text/scalc/01/func_opt_touch.xhp | 1 source/text/scalc/01/func_randarray.xhp | 1 source/text/scalc/01/func_rawsubtract.xhp | 1 source/text/scalc/01/func_regex.xhp | 1 source/text/scalc/01/func_replaceb.xhp | 1 source/text/scalc/01/func_rightb.xhp | 1 source/text/scalc/01/func_roundsig.xhp | 1 source/text/scalc/01/func_searchb.xhp | 1 source/text/scalc/01/func_sequence.xhp | 1 source/text/scalc/01/func_skewp.xhp | 1 source/text/scalc/01/func_sort.xhp | 1 source/text/scalc/01/func_sortby.xhp | 1 source/text/scalc/01/func_sumifs.xhp | 1 source/text/scalc/01/func_switch.xhp | 1 source/text/scalc/01/func_take.xhp | 1 source/text/scalc/01/func_textafter.xhp | 1 source/text/scalc/01/func_textbefore.xhp | 1 source/text/scalc/01/func_textjoin.xhp | 1 source/text/scalc/01/func_textsplit.xhp | 1 source/text/scalc/01/func_tocol.xhp | 1 source/text/scalc/01/func_torow.xhp | 1 source/text/scalc/01/func_unique.xhp | 1 source/text/scalc/01/func_vstack.xhp | 1 source/text/scalc/01/func_webservice.xhp | 3 source/text/scalc/01/func_weeknum_ooo.xhp | 1 source/text/scalc/01/func_workday.intl.xhp | 1 source/text/scalc/01/func_wrapcols.xhp | 1 source/text/scalc/01/func_wraprows.xhp | 1 source/text/scalc/01/func_xlookup.xhp | 1 source/text/scalc/01/func_xmatch.xhp | 1 90 files changed, 317 deletions(-)
New commits: commit f008fbf8547b1d9376af9bf3640ec1a7edfc8ee2 Author: Andras Timar <[email protected]> AuthorDate: Thu Mar 5 16:12:30 2026 +0100 Commit: Andras Timar <[email protected]> CommitDate: Thu Mar 5 16:12:30 2026 +0100 Cleanup "This function is available since %PRODUCTNAME x.y" messages Collabora Office has different version numbers than LibreOffice, and Collabora Office has more features than the LibreOffice it is based on. So these remarks are confusing and unnecessary. Change-Id: I3c18e356da41b695d3fa8ede1b5285c72a0d0818 diff --git a/AllLangHelp_sbasic.mk b/AllLangHelp_sbasic.mk index 6dd1f616b2..8a03aaa0c3 100644 --- a/AllLangHelp_sbasic.mk +++ b/AllLangHelp_sbasic.mk @@ -71,7 +71,6 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,sbasic,\ helpcontent2/source/text/sbasic/shared/02/11180000 \ helpcontent2/source/text/sbasic/shared/02/11190000 \ helpcontent2/source/text/sbasic/shared/02/20000000 \ - helpcontent2/source/text/sbasic/shared/03/avail_release \ helpcontent2/source/text/sbasic/shared/03/lib_tools \ helpcontent2/source/text/sbasic/shared/03/lib_euro \ helpcontent2/source/text/sbasic/shared/03/lib_depot \ diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 2bef9cf1da..ea245b9863 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -26,7 +26,6 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/00/00000407 \ helpcontent2/source/text/scalc/00/00000412 \ helpcontent2/source/text/scalc/00/sheet_menu \ - helpcontent2/source/text/scalc/00/avail_release \ helpcontent2/source/text/scalc/01/02110000 \ helpcontent2/source/text/scalc/01/02120100 \ helpcontent2/source/text/scalc/01/02140000 \ diff --git a/source/text/sbasic/shared/03/avail_release.xhp b/source/text/sbasic/shared/03/avail_release.xhp deleted file mode 100644 index 019363a957..0000000000 --- a/source/text/sbasic/shared/03/avail_release.xhp +++ /dev/null @@ -1,52 +0,0 @@ -<?xml version="1.0" encoding="UTF-8"?> -<helpdocument version="1.0"> - <!-- - * This file is part of the LibreOffice project. - * - * This Source Code Form is subject to the terms of the Mozilla Public - * License, v. 2.0. If a copy of the MPL was not distributed with this - * file, You can obtain one at http://mozilla.org/MPL/2.0/. - * - --> - <meta> - <topic id="availablerelease" indexer="include" status="PUBLISH"> - <title id="tit" xml-lang="en-US">(Un)Available since release</title> - <filename>/text/sbasic/shared/03/avail_release.xhp</filename> - </topic> - </meta> - <body> - <section id="UnAvailBasicMethod"><note id="not_BasMeth">This method is not available in Basic.</note></section> - <section id="UnAvailBasicProperty"><note id="not_BasProp">This property is not available in Basic.</note></section> - <section id="UnAvailPythonMethod"><note id="not_PycMeth">This method is not available in Python.</note></section> - <section id="UnAvailPythonProperty"><note id="not_PycProp">This property is not available in Python.</note></section> - <comment> Tags for LibreOffice 7.3 </comment> - <section id="7.3.service"> - <note id="par_id811631775671311">This service is available from %PRODUCTNAME 7.3 onwards.</note> - </section> - <section id="7.3.method"> - <note id="par_id291613654389793">This method is available from %PRODUCTNAME 7.3 onwards.</note> - </section> - <section id="7.3.property"> - <note id="par_id201613654593537">This property is available from %PRODUCTNAME 7.3 onwards.</note> - </section> - <comment> Tags for LibreOffice 7.2 </comment> - <section id="7.2.service"> - <note id="par_id651551701041690">This service is available from %PRODUCTNAME 7.2 onwards.</note> - </section> - <section id="7.2.methods"> - <note id="par_id281613660174140">These methods are available from %PRODUCTNAME 7.2 onwards.</note> - </section> - <section id="7.2.method"> - <note id="par_id291613654389792">This method is available from %PRODUCTNAME 7.2 onwards.</note> - </section> - <section id="7.2.control"> - <note id="par_id981613655373210">This control is available from %PRODUCTNAME 7.2 onwards.</note> - </section> - <section id="7.2.events"> - <note id="par_id831613654401663">These event properties are available from %PRODUCTNAME 7.2 onwards.</note> - </section> - <section id="7.2.property"> - <note id="par_id201613654395537">This property is available from %PRODUCTNAME 7.2 onwards.</note> - </section> -</body> -</helpdocument> \ No newline at end of file diff --git a/source/text/scalc/00/avail_release.xhp b/source/text/scalc/00/avail_release.xhp deleted file mode 100644 index a764e90b20..0000000000 --- a/source/text/scalc/00/avail_release.xhp +++ /dev/null @@ -1,111 +0,0 @@ -<?xml version="1.0" encoding="UTF-8"?> -<helpdocument version="1.0"> - <!-- - * This file is part of the LibreOffice project. - * - * This Source Code Form is subject to the terms of the Mozilla Public - * License, v. 2.0. If a copy of the MPL was not distributed with this - * file, You can obtain one at http://mozilla.org/MPL/2.0/. - * - --> - - <meta> - <topic id="availablerelease" indexer="exclude" status="PUBLISH"> - <title id="tit" xml-lang="en-US">Available since release</title> - <filename>/text/scalc/00/avail_release.xhp</filename> - </topic> - </meta> - - <body> - <section id="3.3"> - <tip id="par_id651551701041690">This function is available since %PRODUCTNAME 3.3.</tip> - </section> - <section id="3.4"> - <tip id="par_id651551401041690">This function is available since %PRODUCTNAME 3.4.</tip> - </section> - <section id="3.5"> - <tip id="par_id651551401041635">This function is available since %PRODUCTNAME 3.5.</tip> - </section> - <section id="3.6"> - <tip id="par_id651551401041636">This function is available since %PRODUCTNAME 3.6.</tip> - </section> - <section id="4.0"> - <tip id="par_id651551401041640">This function is available since %PRODUCTNAME 4.0.</tip> - </section> - <section id="4.1"> - <tip id="par_id651551401041641">This function is available since %PRODUCTNAME 4.1.</tip> - </section> - <section id="4.2"> - <tip id="par_id651551401041642">This function is available since %PRODUCTNAME 4.2.</tip> - </section> - <section id="4.3"> - <tip id="par_id651551401041643">This function is available since %PRODUCTNAME 4.3.</tip> - </section> - <section id="4.4"> - <tip id="par_id651551401041644">This function is available since %PRODUCTNAME 4.4.</tip> - </section> - <section id="5.0"> - <tip id="par_id651551401041650">This function is available since %PRODUCTNAME 5.0.</tip> - </section> - <section id="5.1"> - <tip id="par_id651551401041651">This function is available since %PRODUCTNAME 5.1.</tip> - </section> - <section id="5.2"> - <tip id="par_id651551401041652">This function is available since %PRODUCTNAME 5.2.</tip> - </section> - <section id="5.3"> - <tip id="par_id651551401041653">This function is available since %PRODUCTNAME 5.3.</tip> - </section> - <section id="5.4"> - <tip id="par_id651551401041654">This function is available since %PRODUCTNAME 5.4.</tip> - </section> - <section id="6.0"> - <tip id="par_id651551401041660">This function is available since %PRODUCTNAME 6.0.</tip> - </section> - <section id="6.1"> - <tip id="par_id651551401041661">This function is available since %PRODUCTNAME 6.1.</tip> - </section> - <section id="6.2"> - <tip id="par_id651551401041662">This function is available since %PRODUCTNAME 6.2.</tip> - </section> - <section id="6.3"> - <tip id="par_id651551401041663">This function is available since %PRODUCTNAME 6.3.</tip> - </section> - <section id="6.4"> - <tip id="par_id651551401041664">This function is available since %PRODUCTNAME 6.4.</tip> - </section> - <section id="7.0"> - <tip id="par_id651551401041665">This function is available since %PRODUCTNAME 7.0.</tip> - </section> - <section id="7.1"> - <tip id="par_id651551401041666">This function is available since %PRODUCTNAME 7.1.</tip> - </section> - <section id="7.2"> - <tip id="par_id651551401041667">This function is available since %PRODUCTNAME 7.2.</tip> - </section> - <section id="7.3"> - <tip id="par_id651551401041668">This function is available since %PRODUCTNAME 7.3.</tip> - </section> - <section id="7.4"> - <tip id="par_id651551401041669">This function is available since %PRODUCTNAME 7.4.</tip> - </section> - <section id="7.5"> - <tip id="par_id651551401041670">This function is available since %PRODUCTNAME 7.5.</tip> - </section> - <section id="7.6"> - <tip id="par_id581708280759954">This function is available since %PRODUCTNAME 7.6.</tip> - </section> - <section id="24.2"> - <tip id="par_id81708280763167">This function is available since %PRODUCTNAME 24.2.</tip> - </section> - <section id="24.8"> - <tip id="par_id491708280768121">This function is available since %PRODUCTNAME 24.8.</tip> - </section> - <section id="25.2"> - <tip id="par_id491708380768121">This function is available since %PRODUCTNAME 25.2.</tip> - </section> - <section id="25.8"> - <tip id="par_id491738280768121">This function is available since %PRODUCTNAME 25.8.</tip> - </section> -</body> -</helpdocument> diff --git a/source/text/scalc/01/04060104.xhp b/source/text/scalc/01/04060104.xhp index f4454429e1..759dac6419 100644 --- a/source/text/scalc/01/04060104.xhp +++ b/source/text/scalc/01/04060104.xhp @@ -306,7 +306,6 @@ <bookmark branch="hid/SC_HID_FUNC_IFERROR" id="bm_id31452061" localize="false"/> <h2 id="hd_id31470811">IFERROR</h2> <paragraph id="par_id31563161" role="paragraph"><ahelp hid="HID_FUNC_IFERROR">Returns the value if the cell does not contain an error value, or the alternative value if it does.</ahelp></paragraph> -<embed href="text/scalc/00/avail_release.xhp#4.0"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id31531551" role="code">IFERROR(Value; Alternate_value)</paragraph> <paragraph id="par_id31540471" role="paragraph"><emph>Value</emph> is the value or expression to be returned if it is not equal or results in an error.</paragraph> @@ -442,7 +441,6 @@ <bookmark branch="hid/SC_HID_FUNC_IFNA" id="bm_id3159273" localize="false"/> <h2 id="hd_id31536851">IFNA</h2> <paragraph id="par_id31491051" role="paragraph"><ahelp hid="HID_FUNC_IFNA">Returns the value if the cell does not contain the #N/A (value not available) error value, or the alternative value if it does.</ahelp></paragraph> -<embed href="text/scalc/00/avail_release.xhp#4.0"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id31537481" role="code">IFNA(Value; Alternate_value)</paragraph> <paragraph id="par_id31528841" role="paragraph"><emph>Value</emph> is the value or expression to be returned if it is not equal or results in an #N/A error.</paragraph> diff --git a/source/text/scalc/01/04060105.xhp b/source/text/scalc/01/04060105.xhp index 6283c38eba..6c44fdb0d3 100644 --- a/source/text/scalc/01/04060105.xhp +++ b/source/text/scalc/01/04060105.xhp @@ -182,7 +182,6 @@ <h2 id="hd_id3156257">XOR</h2> <paragraph id="par_id3155987" role="paragraph"><ahelp hid="HID_FUNC_XOR">Returns true if an odd number of arguments evaluates to TRUE.</ahelp></paragraph> <paragraph id="par_id3148772" role="paragraph">The arguments are either logical expressions themselves (TRUE, 1<5, 2+3=7, B8<10) that return logical values, or arrays (A1:C3) containing logical values.</paragraph> - <embed href="text/scalc/00/avail_release.xhp#4.0"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3150469" role="code">XOR(<embedvar href="text/scalc/01/ful_func.xhp#logical255_1" markup="keep"/>)</paragraph> <embed href="text/scalc/01/ful_func.xhp#logical255"/> diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp index 78751f8bac..53a04d7b10 100644 --- a/source/text/scalc/01/04060106.xhp +++ b/source/text/scalc/01/04060106.xhp @@ -354,7 +354,6 @@ <h2 id="hd_id9523234">CSC</h2> <paragraph id="par_id4896433" role="paragraph"><ahelp hid="HID_FUNC_COSECANT">Returns the cosecant of the given angle (in radians). The cosecant of an angle is equivalent to 1 divided by the sine of that angle</ahelp></paragraph> -<embed href="text/scalc/00/avail_release.xhp#3.5"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id4571344" role="code">CSC(Number)</paragraph> <paragraph id="par_id9859164" role="paragraph">Returns the (trigonometric) cosecant of <emph>Number</emph>, the angle in radians.</paragraph> @@ -375,7 +374,6 @@ <h2 id="hd_id4325650">CSCH</h2> <paragraph id="par_id579916" role="paragraph"><ahelp hid="HID_FUNC_COSECANTHYP">Returns the hyperbolic cosecant of a number.</ahelp></paragraph> -<embed href="text/scalc/00/avail_release.xhp#3.5"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3108851" role="code">CSCH(Number)</paragraph> <paragraph id="par_id1394188" role="paragraph">Returns the hyperbolic cosecant of <emph>Number</emph>.</paragraph> @@ -916,7 +914,6 @@ <h2 id="hd_id5187204">SEC</h2> <paragraph id="par_id9954962" role="paragraph"><ahelp hid="HID_FUNC_SECANT">Returns the secant of the given angle (in radians). The secant of an angle is equivalent to 1 divided by the cosine of that angle</ahelp></paragraph> -<embed href="text/scalc/00/avail_release.xhp#3.5"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id2055913" role="code">SEC(Number)</paragraph> <paragraph id="par_id9568170" role="paragraph">Returns the (trigonometric) secant of <emph>Number</emph>, the angle in radians.</paragraph> @@ -937,7 +934,6 @@ <h2 id="hd_id8661934">SECH</h2> <paragraph id="par_id408174" role="paragraph"><ahelp hid="HID_FUNC_SECANTHYP">Returns the hyperbolic secant of a number.</ahelp></paragraph> -<embed href="text/scalc/00/avail_release.xhp#3.5"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id4985391" role="code">SECH(Number)</paragraph> <paragraph id="par_id1952124" role="paragraph">Returns the hyperbolic secant of <emph>Number</emph>.</paragraph> @@ -1479,7 +1475,6 @@ <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> @@ -1527,7 +1522,6 @@ <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> diff --git a/source/text/scalc/01/04060115.xhp b/source/text/scalc/01/04060115.xhp index 132158c5b4..685328351a 100644 --- a/source/text/scalc/01/04060115.xhp +++ b/source/text/scalc/01/04060115.xhp @@ -295,7 +295,6 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id2952974" role="paragraph" xml-lang="en-US"> <item type="input">=ERF.PRECISE(1)</item> returns 0.842701.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> -<embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id351640873986703" localize="false"><literal>COM.MICROSOFT.ERF.PRECISE</literal></paragraph> </section> @@ -334,7 +333,6 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id2956102" role="paragraph" xml-lang="en-US"> <item type="input">=ERFC.PRECISE(1)</item> returns 0.157299.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> -<embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640853986703" localize="false"><literal>COM.MICROSOFT.ERFC.PRECISE</literal></paragraph> </section> diff --git a/source/text/scalc/01/04060120.xhp b/source/text/scalc/01/04060120.xhp index b5e805053a..5778859548 100644 --- a/source/text/scalc/01/04060120.xhp +++ b/source/text/scalc/01/04060120.xhp @@ -49,7 +49,6 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_BITAND" id="bm_id4145827" localize="false"/> <h2 id="hd_id4150026">BITAND</h2> <paragraph role="paragraph" id="par_id4146942" xml-lang="en-US"><ahelp hid="HID_FUNC_BITAND">Returns a bitwise logical "and" of the parameters.</ahelp></paragraph> -<embed href="text/scalc/00/avail_release.xhp#3.5"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id4146878" xml-lang="en-US">BITAND(number1; number2)</paragraph> <paragraph role="paragraph" id="par_id4151228" xml-lang="en-US"> @@ -64,7 +63,6 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_BITOR" id="bm_id4148754" localize="false"/> <h2 id="hd_id4146139">BITOR</h2> <paragraph role="paragraph" id="par_id4150140" xml-lang="en-US"><ahelp hid="HID_FUNC_BITOR">Returns a bitwise logical "or" of the parameters.</ahelp></paragraph> -<embed href="text/scalc/00/avail_release.xhp#3.5"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id4148733" xml-lang="en-US">BITOR(number1; number2)</paragraph> <paragraph role="paragraph" id="par_id4150864" xml-lang="en-US"> @@ -78,7 +76,6 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_BITXOR" id="bm_id4154330" localize="false"/> <h2 id="hd_id4150019">BITXOR</h2> <paragraph role="paragraph" id="par_id4145246" xml-lang="en-US"><ahelp hid="HID_FUNC_BITXOR">Returns a bitwise logical "exclusive or" of the parameters.</ahelp></paragraph> -<embed href="text/scalc/00/avail_release.xhp#3.5"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id4157970" xml-lang="en-US">BITXOR(number1; number2)</paragraph> <paragraph role="paragraph" id="par_id4145302" xml-lang="en-US"> @@ -93,7 +90,6 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_BITLSHIFT" id="bm_id4148593" localize="false"/> <h2 id="hd_id4155370">BITLSHIFT</h2> <paragraph role="paragraph" id="par_id4158411" xml-lang="en-US"><ahelp hid="HID_FUNC_BITLSHIFT">Shifts a number left by n bits.</ahelp></paragraph> -<embed href="text/scalc/00/avail_release.xhp#3.5"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id4147536" xml-lang="en-US">BITLSHIFT(number; shift)</paragraph> <paragraph role="paragraph" id="par_id4150475" xml-lang="en-US"> @@ -110,7 +106,6 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_BITRSHIFT" id="bm_id4154312" localize="false"/> <h2 id="hd_id4083280">BITRSHIFT</h2> <paragraph role="paragraph" id="par_id4152482" xml-lang="en-US"><ahelp hid="HID_FUNC_BITRSHIFT">Shifts a number right by n bits.</ahelp></paragraph> -<embed href="text/scalc/00/avail_release.xhp#3.5"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id4145087" xml-lang="en-US">BITRSHIFT(number; shift)</paragraph> <paragraph role="paragraph" id="par_id4149277" xml-lang="en-US"> diff --git a/source/text/scalc/01/04060181.xhp b/source/text/scalc/01/04060181.xhp index c2c24850d4..e42c8ca765 100644 --- a/source/text/scalc/01/04060181.xhp +++ b/source/text/scalc/01/04060181.xhp @@ -231,7 +231,6 @@ <paragraph id="par_id2946859" role="paragraph" xml-lang="en-US"><input>=BETA.INV(0.5;5;10)</input> returns the value 0.3257511553.</paragraph> <paragraph role="paragraph" id="par_id841621424421294"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/BETA.INV";>BETA.INV Wiki page</link></paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> -<embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id311640873986703" localize="false"><literal>COM.MICROSOFT.BETA.INV</literal></paragraph> </section> @@ -271,7 +270,6 @@ <h2 id="hd_id2956096">BETA.DIST</h2> <paragraph id="par_id2950880" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_BETADIST_MS">Returns the beta function.</ahelp></paragraph> -<embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id2947571" role="code" xml-lang="en-US">BETA.DIST(Number; Alpha; Beta; Cumulative [; Start [; End]])</paragraph> <paragraph id="par_id2956317" role="paragraph" xml-lang="en-US"><emph>Number</emph> (required) is the value between <emph>Start</emph> and <emph>End</emph> at which to evaluate the function.</paragraph> @@ -332,7 +330,6 @@ <paragraph id="par_id295666" role="paragraph" xml-lang="en-US"><item type="input">=BINOM.DIST(A1;12;0.5;0)</item> shows (if the values <item type="input">0</item> to <item type="input">12</item> are entered in A1) the probabilities for 12 flips of a coin that <emph>Heads</emph> will come up exactly the number of times entered in A1.</paragraph> <paragraph id="par_id290120" role="paragraph" xml-lang="en-US"><item type="input">=BINOM.DIST(A1;12;0.5;1)</item> shows the cumulative probabilities for the same series. For example, if A1 = <item type="input">4</item>, the cumulative probability of the series is 0, 1, 2, 3 or 4 times <emph>Heads</emph> (non-exclusive OR).</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> -<embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640873786703" localize="false"><literal>COM.MICROSOFT.BINOM.DIST</literal></paragraph> </section> @@ -355,7 +352,6 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id285666" role="paragraph" xml-lang="en-US"><item type="input">=BINOM.INV(8;0.6;0.9)</item> returns 7, the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> -<embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640873986706" localize="false"><literal>COM.MICROSOFT.BINOM.INV</literal></paragraph> </section> @@ -391,7 +387,6 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id275666" role="paragraph" xml-lang="en-US"><item type="input">=CHISQ.INV(0,5;1)</item> returns 0.4549364231.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> -<embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640873986753" localize="false"><literal>COM.MICROSOFT.CHISQ.INV</literal></paragraph> </section> @@ -442,7 +437,6 @@ <paragraph id="par_id2959142" role="paragraph" xml-lang="en-US"><item type="input">=CHISQ.INV.RT(0.02;5)</item> returns 13.388222599.</paragraph> <paragraph id="par_id2958401" role="paragraph" xml-lang="en-US">If the probability of error is 5%, the die is not true. If the probability of error is 2%, there is no reason to believe it is fixed.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> -<embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640873983703" localize="false"><literal>COM.MICROSOFT.CHISQ.INV.RT</literal></paragraph> </section> @@ -568,7 +562,6 @@ </section> <paragraph id="par_id2949481" role="paragraph" xml-lang="en-US"><item type="input">=CHISQ.TEST(A1:A6;B1:B6)</item> equals 0.0209708029. This is the probability which suffices the observed data of the theoretical Chi-square distribution.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> -<embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640873989703" localize="false"><literal>COM.MICROSOFT.CHISQ.TEST</literal></paragraph> </section> @@ -613,7 +606,6 @@ <paragraph id="par_id2845774" role="paragraph" xml-lang="en-US"><item type="input">=CHISQ.DIST(3; 2; 0) </item>equals 0.1115650801, the probability density function with 2 degrees of freedom, at x = 3.</paragraph> <paragraph id="par_id2745774" role="paragraph" xml-lang="en-US"><item type="input">=CHISQ.DIST(3; 2; 1) </item>equals 0.7768698399, the cumulative chi-square distribution with 2 degrees of freedom, at the value x = 3.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> -<embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640873984703" localize="false"><literal>COM.MICROSOFT.CHISQ.DIST</literal></paragraph> </section> @@ -637,7 +629,6 @@ <paragraph id="par_id2945774" role="paragraph" xml-lang="en-US"><item type="input">=CHISQ.DIST.RT(13.27; 5)</item> equals 0.0209757694.</paragraph> <paragraph id="par_id2956141" role="paragraph" xml-lang="en-US">If the Chi square value of the random sample is 13.27 and if the experiment has 5 degrees of freedom, then the hypothesis is assured with a probability of error of 2%.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> -<embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id343640873986703" localize="false"><literal>COM.MICROSOFT.CHISQ.DIST.RT</literal></paragraph> </section> @@ -700,7 +691,6 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id2950357" role="paragraph" xml-lang="en-US"><item type="input">=EXPON.DIST(3;0.5;1)</item> returns 0.7768698399.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> -<embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341660873986703" localize="false"><literal>COM.MICROSOFT.EXPON.DIST</literal></paragraph> </section> diff --git a/source/text/scalc/01/04060182.xhp b/source/text/scalc/01/04060182.xhp index b9dae0e791..a0377399ab 100644 --- a/source/text/scalc/01/04060182.xhp +++ b/source/text/scalc/01/04060182.xhp @@ -64,7 +64,6 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2945073" role="paragraph"><item type="input">=F.INV(0.5;5;10)</item> yields 0.9319331609.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> - <embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640873984703" localize="false"><literal>COM.MICROSOFT.F.INV</literal></paragraph> </section> @@ -85,7 +84,6 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2845073" role="paragraph"><item type="input">=F.INV.RT(0.5;5;10)</item> yields 0.9319331609.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> - <embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341660873986703" localize="false"><literal>COM.MICROSOFT.F.INV.RT</literal></paragraph> </section> @@ -149,7 +147,6 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2959126" role="paragraph"><item type="input">=F.TEST(A1:A30;B1:B12)</item> calculates whether the two data sets are different in their variance and returns the probability that both sets could have come from the same total population.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> - <embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640273986703" localize="false"><literal>COM.MICROSOFT.F.TEST</literal></paragraph> </section> @@ -188,7 +185,6 @@ <paragraph xml-lang="en-US" id="par_id2950696" role="paragraph"><item type="input">=F.DIST(0.8;8;12;0)</item> yields 0.7095282499.</paragraph> <paragraph xml-lang="en-US" id="par_id2950697" role="paragraph"><item type="input">=F.DIST(0.8;8;12;1)</item> yields 0.3856603563.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> - <embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640873986707" localize="false"><literal>COM.MICROSOFT.F.DIST</literal></paragraph> </section> @@ -207,7 +203,6 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2850696" role="paragraph"><item type="input">=F.DIST.RT(0.8;8;12)</item> yields 0.6143396437.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> - <embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640873986763" localize="false"><literal>COM.MICROSOFT.F.DIST.RT</literal></paragraph> </section> @@ -259,7 +254,6 @@ <paragraph xml-lang="en-US" id="par_id2913331" role="paragraph"> <item type="input">=GAMMA.INV(0.8;1;1)</item> yields 1.61.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> - <embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341630873986703" localize="false"><literal>COM.MICROSOFT.GAMMA.INV</literal></paragraph> </section> @@ -293,7 +287,6 @@ <paragraph xml-lang="en-US" id="par_id2913730" role="paragraph"> <item type="input">=GAMMALN.PRECISE(2)</item> yields 0.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> - <embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id541640873986703" localize="false"><literal>COM.MICROSOFT.GAMMALN.PRECISE</literal></paragraph> </section> @@ -336,7 +329,6 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id2406201422392251" role="paragraph" xml-lang="en-US"><item type="input">=GAMMA.DIST(2;1;1;1)</item> yields 0.86.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> -<embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640273086703" localize="false"><literal>COM.MICROSOFT.GAMMA.DIST</literal></paragraph> </section> @@ -422,7 +414,6 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2948770" role="paragraph"><item type="input">=Z.TEST(A2:A20; 9; 2)</item> returns the result of a z-test on a sample A2:A20 drawn from a population with known mean 9 and known standard deviation 2.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> -<embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640873986700" localize="false"><literal>COM.MICROSOFT.Z.TEST</literal></paragraph> </section> @@ -484,7 +475,6 @@ <paragraph xml-lang="en-US" id="par_id2954904" role="paragraph"><item type="input">=HYPGEOM.DIST(2;2;90;100;0)</item> yields 0.8090909091. If 90 out of 100 pieces of buttered toast fall from the table and hit the floor with the buttered side first, then if 2 pieces of buttered toast are dropped from the table, the probability is 81%, that both will strike buttered side first.</paragraph> <paragraph xml-lang="en-US" id="par_id2954905" role="paragraph"><item type="input">=HYPGEOM.DIST(2;2;90;100;1)</item> yields 1.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> - <embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640873986704" localize="false"><literal>COM.MICROSOFT.HYPGEOM.DIST</literal></paragraph> </section> diff --git a/source/text/scalc/01/04060183.xhp b/source/text/scalc/01/04060183.xhp index b0c96d5c13..a18c1ffef2 100644 --- a/source/text/scalc/01/04060183.xhp +++ b/source/text/scalc/01/04060183.xhp @@ -98,7 +98,6 @@ <paragraph role="paragraph" id="par_id2953335" xml-lang="en-US"> <item type="input">=CONFIDENCE.T(0.05;1.5;100)</item> gives 0.2976325427.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> -<embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640973986703" localize="false"><literal>COM.MICROSOFT.CONFIDENCE.T</literal></paragraph> </section> @@ -121,7 +120,6 @@ <paragraph role="paragraph" id="par_id2853335" xml-lang="en-US"> <item type="input">=CONFIDENCE.NORM(0.05;1.5;100)</item> gives 0.2939945977.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> -<embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341340873986703" localize="false"><literal>COM.MICROSOFT.CONFIDENCE.NORM</literal></paragraph> </section> @@ -173,7 +171,6 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph role="paragraph" id="par_id2944748" xml-lang="en-US"><item type="input">=COVARIANCE.P(A1:A30;B1:B30)</item></paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> - <embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id641640873986703" localize="false"><literal>COM.MICROSOFT.COVARIANCE.P</literal></paragraph> </section> @@ -191,7 +188,6 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph role="paragraph" id="par_id2844748" xml-lang="en-US"><item type="input">=COVARIANCE.S(A1:A30;B1:B30)</item></paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> - <embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341670873986703" localize="false"><literal>COM.MICROSOFT.COVARIANCE.S</literal></paragraph> </section> @@ -268,7 +264,6 @@ <paragraph role="paragraph" id="par_id2901623" xml-lang="en-US"> <item type="input">=LOGNORM.INV(0.05;0;1)</item> returns 0.1930408167.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> -<embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640873906703" localize="false"><literal>COM.MICROSOFT.LOGNORM.INV</literal></paragraph> </section> @@ -314,7 +309,6 @@ <paragraph role="paragraph" id="par_id2909778" xml-lang="en-US"> <item type="input">=LOGNORM.DIST(0.1;0;1;1)</item> returns 0.0106510993.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> -<embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341670873986704" localize="false"><literal>COM.MICROSOFT.LOGNORM.DIST</literal></paragraph> </section> diff --git a/source/text/scalc/01/04060184.xhp b/source/text/scalc/01/04060184.xhp index e34e8a336c..3b42221837 100644 --- a/source/text/scalc/01/04060184.xhp +++ b/source/text/scalc/01/04060184.xhp @@ -189,7 +189,6 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id2953733" role="paragraph"><item type="input">=MODE.SNGL(A1:A50)</item></paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> -<embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341540873986703" localize="false"><literal>COM.MICROSOFT.MODE.SNGL</literal></paragraph> </section> @@ -207,7 +206,6 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id2853733" role="paragraph"><item type="input">=MODE.MULT(A1:A50)</item></paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> -<embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640875986703" localize="false"><literal>COM.MICROSOFT.MODE.MULT</literal></paragraph> </section> @@ -244,7 +242,6 @@ <paragraph id="par_id2948770" role="paragraph"><item type="input">=NEGBINOM.DIST(1;1;0.5;0)</item> returns 0.25.</paragraph> <paragraph id="par_id2948771" role="paragraph"><item type="input">=NEGBINOM.DIST(1;1;0.5;1)</item> returns 0.75.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> -<embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640873985703" localize="false"><literal>COM.MICROSOFT.NEGBINOM.DIST</literal></paragraph> </section> @@ -280,7 +277,6 @@ <paragraph id="par_id2953921" role="paragraph"> <item type="input">=NORM.INV(0.9;63;5)</item> returns 69.4077578277. If the average egg weighs 63 grams with a standard deviation of 5, then there will be 90% probability that the egg will not be heavier than 69.41g grams.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> -<embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640873966703" localize="false"><literal>COM.MICROSOFT.NORM.INV</literal></paragraph> </section> @@ -322,7 +318,6 @@ <paragraph id="par_id2919448" role="paragraph"> <item type="input">=NORM.DIST(70;63;5;1)</item> returns 0.9192433408.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> -<embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640373986703" localize="false"><literal>COM.MICROSOFT.NORM.DIST</literal></paragraph> </section> @@ -392,7 +387,6 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id2950113" role="paragraph"><item type="input">=POISSON.DIST(60;50;1)</item> returns 0.9278398202.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> - <embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341630873986703" localize="false"><literal>COM.MICROSOFT.POISSON.DIST</literal></paragraph> </section> @@ -426,7 +420,6 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id2859147" role="paragraph"><item type="input">=PERCENTILE.EXC(A1:A50;10%)</item> represents the value in the data set, which equals 10% of the total data scale in A1:A50.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> -<embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id342640873986703" localize="false"><literal>COM.MICROSOFT.PERCENTILE.EXC</literal></paragraph> </section> @@ -444,7 +437,6 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id2959147" role="paragraph"><item type="input">=PERCENTILE.INC(A1:A50;0.1)</item> represents the value in the data set, which equals 10% of the total data scale in A1:A50.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> -<embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341340873986703" localize="false"><literal>COM.MICROSOFT.PERCENTILE.INC</literal></paragraph> </section> @@ -478,7 +470,6 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id2849163" role="paragraph"><item type="input">=PERCENTRANK.EXC(A1:A50;50)</item> returns the percentage rank of the value 50 from the total range of all values found in A1:A50. If 50 falls outside the total range, an error message will appear.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> -<embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640878986703" localize="false"><literal>COM.MICROSOFT.PERCENTRANK.EXC</literal></paragraph> </section> @@ -496,7 +487,6 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id2949163" role="paragraph"><item type="input">=PERCENTRANK.INC(A1:A50;50)</item> returns the percentage rank of the value 50 from the total range of all values found in A1:A50. If 50 falls outside the total range, an error message will appear.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> -<embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640873086703" localize="false"><literal>COM.MICROSOFT.PERCENTRANK.INC</literal></paragraph> </section> @@ -530,7 +520,6 @@ <paragraph id="par_id2859276" role="paragraph"> <item type="input">=QUARTILE.EXC(A1:A50;2)</item> returns the value of which 50% of the scale corresponds to the lowest to highest values in the range A1:A50.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> -<embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640873986700" localize="false"><literal>COM.MICROSOFT.QUARTILE.EXC</literal></paragraph> </section> @@ -549,7 +538,6 @@ <paragraph id="par_id2959276" role="paragraph"> <item type="input">=QUARTILE.INC(A1:A50;2)</item> returns the value of which 50% of the scale corresponds to the lowest to highest values in the range A1:A50.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> -<embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640873986707" localize="false"><literal>COM.MICROSOFT.QUARTILE.INC</literal></paragraph> </section> diff --git a/source/text/scalc/01/04060185.xhp b/source/text/scalc/01/04060185.xhp index fa3662d734..ff0cf6e98b 100644 --- a/source/text/scalc/01/04060185.xhp +++ b/source/text/scalc/01/04060185.xhp @@ -71,7 +71,6 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2955919" role="paragraph"><item type="input">=RANK.AVG(A10;A1:A50)</item> returns the ranking of the value in A10 in value range A1:A50. If <item type="literal">Value</item> does not exist within the range an error message is displayed.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> -<embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640873886703" localize="false"><literal>COM.MICROSOFT.RANK.AVG</literal></paragraph> </section> @@ -94,7 +93,6 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2855919" role="paragraph"><item type="input">=RANK.EQ(A10;A1:A50)</item> returns the ranking of the value in A10 in value range A1:A50. If <item type="literal">Value</item> does not exist within the range an error message is displayed.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> -<embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341040873966703" localize="false"><literal>COM.MICROSOFT.RANK.EQ</literal></paragraph> </section> @@ -221,7 +219,6 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2953933" role="paragraph"><item type="input">=STDEV.P(A1:A50)</item> returns a standard deviation of the data referenced.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> - <embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640873986700" localize="false"><literal>COM.MICROSOFT.STDEV.P</literal></paragraph> </section> @@ -241,7 +238,6 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2853933" role="paragraph"><item type="input">=STDEV.S(A1:A50)</item> returns a standard deviation of the data referenced.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> - <embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id301640873986703" localize="false"><literal>COM.MICROSOFT.STDEV.S</literal></paragraph> </section> @@ -308,7 +304,6 @@ <paragraph xml-lang="en-US" id="par_id2949030" role="paragraph"> <item type="input">=NORM.S.INV(0.908789)</item> returns 1.333334673.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> - <embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341000873986703" localize="false"><literal>COM.MICROSOFT.NORM.S.INV</literal></paragraph> </section> @@ -347,7 +342,6 @@ <paragraph xml-lang="en-US" id="par_id2955985" role="paragraph"> <item type="input">=NORM.S.DIST(1;1)</item> returns 0.8413447461. The area below the standard normal distribution curve to the left of X value 1 is 84% of the total area.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> - <embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640873980003" localize="false"><literal>COM.MICROSOFT.NORM.S.DIST</literal></paragraph> </section> @@ -434,7 +428,6 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2956010" role="paragraph"><item type="input">=T.INV(0.1;6)</item> returns -1.4397557473.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> - <embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341000873986704" localize="false"><literal>COM.MICROSOFT.T.INV</literal></paragraph> </section> @@ -453,7 +446,6 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2856010" role="paragraph"><item type="input">=T.INV.2T(0.25; 10)</item> returns 1.221255395.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> - <embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640873986003" localize="false"><literal>COM.MICROSOFT.T.INV.2T</literal></paragraph> </section> @@ -494,7 +486,6 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2950119" role="paragraph"><item type="input">=T.TEST(A1:A50;B1:B50;2;2)</item></paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> - <embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640844986703" localize="false"><literal>COM.MICROSOFT.T.TEST</literal></paragraph> </section> @@ -534,7 +525,6 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2949773" role="paragraph"><item type="input">=T.DIST(1; 10; TRUE)</item> returns 0.8295534338</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> - <embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341330873986703" localize="false"><literal>COM.MICROSOFT.T.DIST</literal></paragraph> </section> @@ -553,7 +543,6 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2849773" role="paragraph"><item type="input">=T.DIST.2T(1; 10)</item> returns 0.3408931323.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> - <embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341655873986703" localize="false"><literal>COM.MICROSOFT.T.DIST.2T</literal></paragraph> </section> @@ -572,7 +561,6 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2749773" role="paragraph"><item type="input">=T.DIST.RT(1; 10)</item> returns 0.1704465662.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> - <embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640873911703" localize="false"><literal>COM.MICROSOFT.T.DIST.RT</literal></paragraph> </section> @@ -609,7 +597,6 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2953575" role="paragraph"><item type="input">=VAR.S(A1:A50)</item></paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> - <embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id111640873986703" localize="false"><literal>COM.MICROSOFT.VAR.S</literal></paragraph> </section> @@ -656,7 +643,6 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2953385" role="paragraph"><item type="input">=VAR.P(A1:A50)</item></paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> - <embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640873933703" localize="false"><literal>COM.MICROSOFT.VAR.P</literal></paragraph> </section> @@ -773,7 +759,6 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2946077" role="paragraph"><item type="input">=WEIBULL.DIST(2;1;1;1)</item> returns 0.8646647168.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> - <embed href="text/scalc/00/avail_release.xhp#4.2"/> <paragraph xml-lang="en-US" id="par_id2905200911372899" role="paragraph">See also the <link href="https://wiki.documentfoundation.org/Documentation/How_Tos/Calc:_WEIBULL_function";>Wiki page</link>.</paragraph> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640873977703" localize="false"><literal>COM.MICROSOFT.WEIBULL.DIST</literal></paragraph> diff --git a/source/text/scalc/01/func_aggregate.xhp b/source/text/scalc/01/func_aggregate.xhp index d4bd97c1c7..d2091d1242 100644 --- a/source/text/scalc/01/func_aggregate.xhp +++ b/source/text/scalc/01/func_aggregate.xhp @@ -429,7 +429,6 @@ <paragraph id="par_id2309201520395365" role="paragraph" xml-lang="en-US">You can use reference to a cell or a range for every argument in the formula. The following example shows how it works. Besides, it shows that you can use column labels to specify an array.</paragraph> <paragraph id="par_id2309201520395380" role="paragraph" xml-lang="en-US"><item type="input">=AGGREGATE(E3;E5;'ColumnOne')</item><br/>If E3 = 13 and E5 = 5, the function returns mode of the first column = 10.</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_id341640873986703" localize="false"><literal>COM.MICROSOFT.AGGREGATE</literal></paragraph> <section id="relatedtopics"> diff --git a/source/text/scalc/01/func_averageif.xhp b/source/text/scalc/01/func_averageif.xhp index 9334626f56..513e4f3a66 100644 --- a/source/text/scalc/01/func_averageif.xhp +++ b/source/text/scalc/01/func_averageif.xhp @@ -26,7 +26,6 @@ <h1 id="hd_id16852304621982"><variable id="averageif_head"><link href="text/scalc/01/func_averageif.xhp">AVERAGEIF</link></variable> function</h1> <paragraph id="par_id7281266615152" role="paragraph"><ahelp hid="."><variable id="averageif_des">Returns the arithmetic mean of all cells in a range that satisfy a given condition. The AVERAGEIF function sums up all the results that match the logical test and divides this sum by the quantity of selected values.</variable></ahelp></paragraph> </section> -<embed href="text/scalc/00/avail_release.xhp#4.0"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id200801176228491" role="code">AVERAGEIF(Range; Criterion [; Average_Range ])</paragraph> <paragraph id="par_id15226321619829" role="paragraph"><emph>Range</emph> – required argument. An array, a name of named range or a label of a column or a row containing numbers for averaging or numbers or text for the condition.</paragraph> diff --git a/source/text/scalc/01/func_averageifs.xhp b/source/text/scalc/01/func_averageifs.xhp index 53b007c8ce..f56348e2bc 100644 --- a/source/text/scalc/01/func_averageifs.xhp +++ b/source/text/scalc/01/func_averageifs.xhp @@ -26,7 +26,6 @@ <h1 id="hd_id537445374453744"><variable id="averageifs_head"><link href="text/scalc/01/func_averageifs.xhp">AVERAGEIFS</link></variable> function</h1> <paragraph id="par_id538405384053840" role="paragraph"><ahelp hid="."><variable id="averageifs_des">Returns the arithmetic mean of all cells in a range that satisfy given multiple criteria. The AVERAGEIFS function sums up all the results that match the logical tests and divides this sum by the quantity of selected values.</variable></ahelp></paragraph> </section> -<embed href="text/scalc/00/avail_release.xhp#4.0"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id21050267713178" role="code">AVERAGEIFS(<embedvar href="text/scalc/01/ex_data_stat_func.xhp#args" markup="ignore"/>)</paragraph> <paragraph id="par_id165832700711773" role="paragraph"><emph>Func_range</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for calculating the mean.</paragraph> diff --git a/source/text/scalc/01/func_ceiling.xhp b/source/text/scalc/01/func_ceiling.xhp index 548c6d745f..c3d3c3ac76 100644 --- a/source/text/scalc/01/func_ceiling.xhp +++ b/source/text/scalc/01/func_ceiling.xhp @@ -62,7 +62,6 @@ <paragraph role="paragraph" id="par_id201586213398634"><input>=CEILING.PRECISE(3.45)</input> returns 4.</paragraph> <paragraph role="paragraph" id="par_id651586213406243"><input>=CEILING.PRECISE(-45.67; 2)</input> returns -44.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> - <embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640373986703" localize="false"><literal>COM.MICROSOFT.CEILING.PRECISE</literal></paragraph> <comment>see also FLOOR, EVEN, ODD, MROUND, INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP</comment> @@ -89,7 +88,6 @@ <paragraph role="paragraph" id="par_id151586208604536"><input>=CEILING.MATH(-45.67; -2; 0)</input> returns -44.</paragraph> <paragraph role="paragraph" id="par_id971586208611345"><input>=CEILING.MATH(-45.67; +2; 1)</input> returns -46.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> - <embed href="text/scalc/00/avail_release.xhp#5.0"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341646873986703" localize="false"><literal>COM.MICROSOFT.CEILING.MATH</literal></paragraph> </section> @@ -111,7 +109,6 @@ <paragraph role="paragraph" id="par_id651586214132234"><input>=CEILING.XCL(-45.67; 2)</input> returns -44.</paragraph> <paragraph role="paragraph" id="par_id811586214136666"><input>=CEILING.XCL(-45.67; -2)</input> returns -46.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> - <embed href="text/scalc/00/avail_release.xhp#5.0"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640873786703" localize="false"><literal>COM.MICROSOFT.CEILING</literal></paragraph> </section> @@ -135,7 +132,6 @@ <paragraph role="paragraph" id="par_id801586214431463"><input>=ISO.CEILING(3.45)</input> returns 4.</paragraph> <paragraph role="paragraph" id="par_id181586214438808"><input>=ISO.CEILING(-45.67; 2)</input> returns -44.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> - <embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640873989703" localize="false"><literal>COM.MICROSOFT.ISO.CEILING</literal></paragraph> <comment>see also FLOOR, EVEN, ODD, MROUND, INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP</comment> diff --git a/source/text/scalc/01/func_choosecols.xhp b/source/text/scalc/01/func_choosecols.xhp index bb443da766..620e0e5e9d 100644 --- a/source/text/scalc/01/func_choosecols.xhp +++ b/source/text/scalc/01/func_choosecols.xhp @@ -72,7 +72,6 @@ <tip id="par_id481738974778935">Use the function CHOOSECOLS to reorder the columns of an array. You can also replicate columns by repeating the column index.</tip> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> -<embed href="text/scalc/00/avail_release.xhp#25.8"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640870986703" localize="false"><literal>COM.MICROSOFT.CHOOSECOLS</literal></paragraph> <section id="relatedtopics"> diff --git a/source/text/scalc/01/func_chooserows.xhp b/source/text/scalc/01/func_chooserows.xhp index 2ba53cba4f..38d0fdd132 100644 --- a/source/text/scalc/01/func_chooserows.xhp +++ b/source/text/scalc/01/func_chooserows.xhp @@ -73,7 +73,6 @@ <tip id="par_id481738974778935">Use the function CHOOSEROWS to reorder the rows of an array. You can also replicate rows by repeating the row index.</tip> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> -<embed href="text/scalc/00/avail_release.xhp#25.8"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640870986703" localize="false"><literal>COM.MICROSOFT.CHOOSEROWS</literal></paragraph> <section id="relatedtopics"> diff --git a/source/text/scalc/01/func_color.xhp b/source/text/scalc/01/func_color.xhp index 16634b1062..091e44280b 100644 --- a/source/text/scalc/01/func_color.xhp +++ b/source/text/scalc/01/func_color.xhp @@ -46,7 +46,6 @@ <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> <section id="relatedtopics"> diff --git a/source/text/scalc/01/func_concat.xhp b/source/text/scalc/01/func_concat.xhp index 734f68264e..545f19b6e2 100644 --- a/source/text/scalc/01/func_concat.xhp +++ b/source/text/scalc/01/func_concat.xhp @@ -32,7 +32,6 @@ <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph role="paragraph" id="par_id531556227248228"><input>=CONCAT("Hello ", A1:C3)</input> concatenates the string "Hello" with all strings in range <literal>A1:C3</literal>.</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_id341640873986703" localize="false"><literal>COM.MICROSOFT.CONCAT</literal></paragraph> <section id="relatedtopics"> diff --git a/source/text/scalc/01/func_countifs.xhp b/source/text/scalc/01/func_countifs.xhp index 02a0c07151..00ec23a8b3 100644 --- a/source/text/scalc/01/func_countifs.xhp +++ b/source/text/scalc/01/func_countifs.xhp @@ -27,7 +27,6 @@ <h1 id="hd_id456845684568"><variable id="countifs_head"><link href="text/scalc/01/func_countifs.xhp">COUNTIFS</link></variable></h1> <paragraph id="par_id462646264626" role="paragraph"><ahelp hid="."><variable id="countifs_des">Returns the count of cells that meet criteria in multiple ranges.</variable></ahelp></paragraph> </section> -<embed href="text/scalc/00/avail_release.xhp#4.0"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id27421466710275" role="code">COUNTIFS(Range; Criterion[; Range2; Criterion2][; ... ; [Range127; Criterion127]])</paragraph> diff --git a/source/text/scalc/01/func_datedif.xhp b/source/text/scalc/01/func_datedif.xhp index 1e2c6fc385..e7bfddcff4 100644 --- a/source/text/scalc/01/func_datedif.xhp +++ b/source/text/scalc/01/func_datedif.xhp @@ -20,7 +20,6 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DATEDIF" id="bm_id3149022" localize="false"/> <h1 id="hd_id3155511"><variable id="datedif"><link href="text/scalc/01/func_datedif.xhp">DATEDIF</link></variable></h1> <paragraph role="paragraph" id="par_id3153551" xml-lang="en-US"><ahelp hid="HID_FUNC_DATEDIF">This function returns the number of whole days, months or years between Start date and End date.</ahelp></paragraph> -<embed href="text/scalc/00/avail_release.xhp#3.6"/> <embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="paragraph" id="par_id531642776283977"> diff --git a/source/text/scalc/01/func_drop.xhp b/source/text/scalc/01/func_drop.xhp index 02edc3d751..b30b6395f0 100644 --- a/source/text/scalc/01/func_drop.xhp +++ b/source/text/scalc/01/func_drop.xhp @@ -59,7 +59,6 @@ </table> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> -<embed href="text/scalc/00/avail_release.xhp#25.8"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640870986703" localize="false"><literal>COM.MICROSOFT.DROP</literal></paragraph> <section id="relatedtopics"> diff --git a/source/text/scalc/01/func_error_type.xhp b/source/text/scalc/01/func_error_type.xhp index 0844ded1de..2bcc2359bf 100644 --- a/source/text/scalc/01/func_error_type.xhp +++ b/source/text/scalc/01/func_error_type.xhp @@ -28,7 +28,6 @@ <h1 id="hd_id348223482234822"><variable id="error_type_head"><link href="text/scalc/01/func_error_type.xhp">ERROR.TYPE</link></variable> function</h1> <paragraph id="par_id350283502835028" role="paragraph" xml-lang="en-US"><ahelp hid="."><variable id="error_type_des">Returns a number representing a specific Error type, or the error value #N/A, if there is no error. </variable></ahelp></paragraph> </section> -<embed href="text/scalc/00/avail_release.xhp#5.0"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id1861223540440" role="code" xml-lang="en-US">ERROR.TYPE(Error_value)</paragraph> <paragraph id="par_id217737315" role="paragraph" xml-lang="en-US"><emph>Error_value</emph> – required argument. The error value or a reference to a cell, whose value needs to be processed.</paragraph> diff --git a/source/text/scalc/01/func_expand.xhp b/source/text/scalc/01/func_expand.xhp index 8058c054c3..c32a4a9cc7 100644 --- a/source/text/scalc/01/func_expand.xhp +++ b/source/text/scalc/01/func_expand.xhp @@ -76,7 +76,6 @@ </table> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> -<embed href="text/scalc/00/avail_release.xhp#25.8"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640870986703" localize="false"><literal>COM.MICROSOFT.EXPAND</literal></paragraph> <section id="relatedtopics"> diff --git a/source/text/scalc/01/func_filter.xhp b/source/text/scalc/01/func_filter.xhp index 2fd955f164..51ecddfcbf 100644 --- a/source/text/scalc/01/func_filter.xhp +++ b/source/text/scalc/01/func_filter.xhp @@ -65,7 +65,6 @@ <paragraph role="paragraph" id="par_id561709507935610"><input>{=FILTER(A2:C13;B2:B13>90;"No results")}</input> Returns the string "No results", since no grade on Physics is above 90.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> -<embed href="text/scalc/00/avail_release.xhp#24.8"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640870986703" localize="false"><literal>COM.MICROSOFT.FILTER</literal></paragraph> <section id="relatedtopics"> diff --git a/source/text/scalc/01/func_findb.xhp b/source/text/scalc/01/func_findb.xhp index eb74621a38..c83f6e2556 100644 --- a/source/text/scalc/01/func_findb.xhp +++ b/source/text/scalc/01/func_findb.xhp @@ -25,7 +25,6 @@ <h1 id="hd_id771573508637966"><variable id="findb"><link href="text/scalc/01/func_findb.xhp">FINDB</link></variable></h1> <paragraph id="par_id831573508637970" role="paragraph" xml-lang="en-US"><variable id="variable name"><ahelp hid=".">Returns the starting position of a given text, using byte positions. FINDB is case sensitive.</ahelp></variable></paragraph> </section> - <embed href="text/scalc/00/avail_release.xhp#6.0"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="code" id="par_id221573517641172">FINDB(Find Text ; Text [; Position])</paragraph> <paragraph role="paragraph" id="par_id241573517292388"><emph>Find Text</emph>: The text or text expression to be found.</paragraph> diff --git a/source/text/scalc/01/func_floor.xhp b/source/text/scalc/01/func_floor.xhp index 745a27e600..90a3a82db8 100644 --- a/source/text/scalc/01/func_floor.xhp +++ b/source/text/scalc/01/func_floor.xhp @@ -67,7 +67,6 @@ <paragraph role="paragraph" id="par_id631586287637256"><input>=FLOOR.MATH(-45.67,-2, 0)</input> returns -46.</paragraph> <paragraph role="paragraph" id="par_id371586287641888"><input>=FLOOR.MATH(-45.67,+2, 1)</input> returns -44.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> - <embed href="text/scalc/00/avail_release.xhp#5.0"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id541640873986703" localize="false"><literal>COM.MICROSOFT.FLOOR.MATH</literal></paragraph> </section> @@ -94,7 +93,6 @@ <paragraph role="paragraph" id="par_id981586291388900"><input>=FLOOR.PRECISE(3.45)</input> returns 3.</paragraph> <paragraph role="paragraph" id="par_id831586291395477"><input>=FLOOR.PRECISE(-45.67,2)</input> returns -46.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> - <embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341650873986703" localize="false"><literal>COM.MICROSOFT.FLOOR.PRECISE</literal></paragraph> <comment>see also CEILING, EVEN, ODD, MROUND,INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP</comment> @@ -117,7 +115,6 @@ <paragraph role="paragraph" id="par_id361586291628003"><input>=FLOOR.XCL(-45.67,2)</input> returns -46.</paragraph> <paragraph role="paragraph" id="par_id801586291641099"><input>=FLOOR.XCL(-45.67,-2)</input> returns -44.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> - <embed href="text/scalc/00/avail_release.xhp#5.0"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640873978703" localize="false"><literal>COM.MICROSOFT.FLOOR</literal></paragraph> </section> diff --git a/source/text/scalc/01/func_forecastetsadd.xhp b/source/text/scalc/01/func_forecastetsadd.xhp index 23cefca05a..9fbad454cc 100644 --- a/source/text/scalc/01/func_forecastetsadd.xhp +++ b/source/text/scalc/01/func_forecastetsadd.xhp @@ -43,7 +43,6 @@ <paragraph id="hd_id04032123185123" role="code" xml-lang="en-US">=FORECAST.ETS.ADD(DATE(2014;1;1);Values;Timeline;4;TRUE();7)</paragraph> <paragraph id="hd_id040312316112394554" role="paragraph" xml-lang="en-US">Returns 113.251442038722, the additive 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_id341640873986703" localize="false"><literal>COM.MICROSOFT.FORECAST.ETS</literal></paragraph> </section> diff --git a/source/text/scalc/01/func_forecastetsmult.xhp b/source/text/scalc/01/func_forecastetsmult.xhp index 87c4f1a479..c5f90517c4 100644 --- a/source/text/scalc/01/func_forecastetsmult.xhp +++ b/source/text/scalc/01/func_forecastetsmult.xhp @@ -44,7 +44,6 @@ <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> diff --git a/source/text/scalc/01/func_forecastetspiadd.xhp b/source/text/scalc/01/func_forecastetspiadd.xhp index 15233d5bd9..24f496c76b 100644 --- a/source/text/scalc/01/func_forecastetspiadd.xhp +++ b/source/text/scalc/01/func_forecastetspiadd.xhp @@ -48,7 +48,6 @@ <paragraph id="hd_id04032123185123" role="code" xml-lang="en-US">=FORECAST.ETS.PI.ADD(DATE(2014;1;1);Values;Timeline;0.8;4;TRUE();7)</paragraph> <paragraph id="hd_id040312316112394554" role="paragraph" xml-lang="en-US">Returns 23.4416821953741, the prediction interval for additive 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_id341640873986703" localize="false"><literal>COM.MICROSOFT.FORECAST.ETS.COFINT</literal></paragraph> </section> diff --git a/source/text/scalc/01/func_forecastetspimult.xhp b/source/text/scalc/01/func_forecastetspimult.xhp index aa8bc8d5e5..1d4ec87e1d 100644 --- a/source/text/scalc/01/func_forecastetspimult.xhp +++ b/source/text/scalc/01/func_forecastetspimult.xhp @@ -48,7 +48,6 @@ <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> diff --git a/source/text/scalc/01/func_forecastetsseason.xhp b/source/text/scalc/01/func_forecastetsseason.xhp index 37af7cd53e..b5183b6126 100644 --- a/source/text/scalc/01/func_forecastetsseason.xhp +++ b/source/text/scalc/01/func_forecastetsseason.xhp @@ -39,7 +39,6 @@ <paragraph id="hd_id04032016185123" role="code" xml-lang="en-US">=FORECAST.ETS.SEASONALITY(Values;Timeline;TRUE();1)</paragraph> <paragraph id="hd_id04032016112394554" role="paragraph" xml-lang="en-US">Returns 6, the number of samples in period based on <emph>Values</emph> and <emph>Timeline</emph> named ranges above, no missing data, and AVERAGE 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_id341640873986703" localize="false"><literal>COM.MICROSOFT.FORECAST.ETS.SEASONALITY</literal></paragraph> </section> diff --git a/source/text/scalc/01/func_forecastetsstatadd.xhp b/source/text/scalc/01/func_forecastetsstatadd.xhp index 671ba5f40d..e079427fa3 100644 --- a/source/text/scalc/01/func_forecastetsstatadd.xhp +++ b/source/text/scalc/01/func_forecastetsstatadd.xhp @@ -46,7 +46,6 @@ <paragraph id="hd_id04032123185123" role="code" xml-lang="en-US">=FORECAST.ETS.STAT.ADD(Values;Timeline;2;1;TRUE();7)</paragraph> <paragraph id="hd_id040312316112394554" role="paragraph" xml-lang="en-US">Returns 0.0615234375, the additive statistics based on <emph>Values</emph> and <emph>Timeline</emph> named ranges above, with gamma smoothing, 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_id341640873986703" localize="false"><literal>COM.MICROSOFT.FORECAST.ETS.STAT</literal></paragraph> </section> diff --git a/source/text/scalc/01/func_forecastetsstatmult.xhp b/source/text/scalc/01/func_forecastetsstatmult.xhp index a32d8c0ccf..eaf72761ae 100644 --- a/source/text/scalc/01/func_forecastetsstatmult.xhp +++ b/source/text/scalc/01/func_forecastetsstatmult.xhp @@ -45,7 +45,6 @@ <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> diff --git a/source/text/scalc/01/func_fourier.xhp b/source/text/scalc/01/func_fourier.xhp index a9ff9ce563..70e81d8716 100644 --- a/source/text/scalc/01/func_fourier.xhp +++ b/source/text/scalc/01/func_fourier.xhp @@ -40,7 +40,6 @@ <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"> diff --git a/source/text/scalc/01/func_hstack.xhp b/source/text/scalc/01/func_hstack.xhp index e13c90056d..a7d6247c20 100644 --- a/source/text/scalc/01/func_hstack.xhp +++ b/source/text/scalc/01/func_hstack.xhp @@ -86,7 +86,6 @@ </table> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> -<embed href="text/scalc/00/avail_release.xhp#25.8"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640870986703" localize="false"><literal>COM.MICROSOFT.HSTACK</literal></paragraph> <section id="relatedtopics"> diff --git a/source/text/scalc/01/func_ifs.xhp b/source/text/scalc/01/func_ifs.xhp index 6b4eb761b7..163a8a7496 100644 --- a/source/text/scalc/01/func_ifs.xhp +++ b/source/text/scalc/01/func_ifs.xhp @@ -40,7 +40,6 @@ <paragraph role="paragraph" id="par_id541556235771022">If there is a result missing for an expression or is no expression is TRUE, a #N/A error is returned.</paragraph> <paragraph role="paragraph" id="par_id181556235788473">If expression is neither TRUE or FALSE, a #VALUE error is returned.</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_id341640873986703" localize="false"><literal>COM.MICROSOFT.IFS</literal></paragraph> <section id="relatedtopics"> diff --git a/source/text/scalc/01/func_imcosh.xhp b/source/text/scalc/01/func_imcosh.xhp index 9a97a7a627..069ff12b00 100644 --- a/source/text/scalc/01/func_imcosh.xhp +++ b/source/text/scalc/01/func_imcosh.xhp @@ -36,7 +36,6 @@ </paragraph> <embed href="text/scalc/01/ful_func.xhp#func_im_des"/> <embed href="text/scalc/01/ODFF.xhp#odff"/> - <embed href="text/scalc/00/avail_release.xhp#3.6"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id16051131322110" role="code" xml-lang="en-US"> IMCOSH(Complex_number) diff --git a/source/text/scalc/01/func_imcot.xhp b/source/text/scalc/01/func_imcot.xhp index 6d32744fc9..d4b0dfe7c1 100644 --- a/source/text/scalc/01/func_imcot.xhp +++ b/source/text/scalc/01/func_imcot.xhp @@ -36,7 +36,6 @@ </paragraph> <embed href="text/scalc/01/ful_func.xhp#func_im_des"/> <embed href="text/scalc/01/ODFF.xhp#odff"/> - <embed href="text/scalc/00/avail_release.xhp#3.6"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id16051131322110" role="code" xml-lang="en-US"> IMCOT(Complex_number) diff --git a/source/text/scalc/01/func_imcsc.xhp b/source/text/scalc/01/func_imcsc.xhp index 76564689d4..e6adb4eda0 100644 --- a/source/text/scalc/01/func_imcsc.xhp +++ b/source/text/scalc/01/func_imcsc.xhp @@ -36,7 +36,6 @@ </paragraph> <embed href="text/scalc/01/ful_func.xhp#func_im_des"/> <embed href="text/scalc/01/ODFF.xhp#odff"/> - <embed href="text/scalc/00/avail_release.xhp#3.6"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id30461169611909" role="code" xml-lang="en-US"> IMCSC(Complex_number) diff --git a/source/text/scalc/01/func_imcsch.xhp b/source/text/scalc/01/func_imcsch.xhp index 4b8329b1c1..e3b14425a1 100644 --- a/source/text/scalc/01/func_imcsch.xhp +++ b/source/text/scalc/01/func_imcsch.xhp @@ -36,7 +36,6 @@ </paragraph> <embed href="text/scalc/01/ful_func.xhp#func_im_des"/> <embed href="text/scalc/01/ODFF.xhp#odff"/> - <embed href="text/scalc/00/avail_release.xhp#3.6"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id30461169611909" role="code" xml-lang="en-US"> IMCSCH(Complex_number) diff --git a/source/text/scalc/01/func_imsec.xhp b/source/text/scalc/01/func_imsec.xhp index 805207426f..2aed9900ad 100644 --- a/source/text/scalc/01/func_imsec.xhp +++ b/source/text/scalc/01/func_imsec.xhp @@ -36,7 +36,6 @@ </paragraph> <embed href="text/scalc/01/ful_func.xhp#func_im_des"/> <embed href="text/scalc/01/ODFF.xhp#odff"/> - <embed href="text/scalc/00/avail_release.xhp#3.6"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id66061624115094" role="code" xml-lang="en-US"> IMSEC(Complex_number) diff --git a/source/text/scalc/01/func_imsech.xhp b/source/text/scalc/01/func_imsech.xhp index 2e1828b5f2..9cf2a53d3e 100644 --- a/source/text/scalc/01/func_imsech.xhp +++ b/source/text/scalc/01/func_imsech.xhp @@ -36,7 +36,6 @@ </paragraph> <embed href="text/scalc/01/ful_func.xhp#func_im_des"/> <embed href="text/scalc/01/ODFF.xhp#odff"/> - <embed href="text/scalc/00/avail_release.xhp#3.6"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id17253876723855" role="code" xml-lang="en-US"> IMSECH(Complex_number) diff --git a/source/text/scalc/01/func_imsinh.xhp b/source/text/scalc/01/func_imsinh.xhp index 378b1609b7..d0f8ec16b3 100644 --- a/source/text/scalc/01/func_imsinh.xhp +++ b/source/text/scalc/01/func_imsinh.xhp @@ -36,7 +36,6 @@ </paragraph> <embed href="text/scalc/01/ful_func.xhp#func_im_des"/> <embed href="text/scalc/01/ODFF.xhp#odff"/> - <embed href="text/scalc/00/avail_release.xhp#3.6"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id284611113926520" role="code" xml-lang="en-US"> IMSINH(Complex_number) diff --git a/source/text/scalc/01/func_imtan.xhp b/source/text/scalc/01/func_imtan.xhp index 7462487fe4..79a3d013cc 100644 --- a/source/text/scalc/01/func_imtan.xhp +++ b/source/text/scalc/01/func_imtan.xhp @@ -36,7 +36,6 @@ </paragraph> <embed href="text/scalc/01/ful_func.xhp#func_im_des"/> <embed href="text/scalc/01/ODFF.xhp#odff"/> - <embed href="text/scalc/00/avail_release.xhp#3.6"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph id="par_id23219159944377" role="code" xml-lang="en-US"> IMTAN(Complex_number) diff --git a/source/text/scalc/01/func_isoweeknum.xhp b/source/text/scalc/01/func_isoweeknum.xhp index e5392b93ff..16bcf5f918 100644 --- a/source/text/scalc/01/func_isoweeknum.xhp +++ b/source/text/scalc/01/func_isoweeknum.xhp @@ -31,7 +31,6 @@ </variable></h1> <paragraph role="paragraph" id="par_id3149770" xml-lang="en-US"><ahelp hid="HID_FUNC_ISOWEEKNUM">ISOWEEKNUM calculates the week number of the year for the internal date value.</ahelp></paragraph> <note id="par_idN105E4">The International Standard ISO 8601 has decreed that Monday shall be the first day of the week. A week that lies partly in one year and partly in another is assigned a number in the year in which most of its days lie. That means that week number 1 of any year is the week that contains the January 4th.</note> -<embed href="text/scalc/00/avail_release.xhp#5.1"/> <embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="code" id="par_id3147236" xml-lang="en-US">ISOWEEKNUM(Number)</paragraph> diff --git a/source/text/scalc/01/func_leftb.xhp b/source/text/scalc/01/func_leftb.xhp index 674d15752a..d5c62f7603 100644 --- a/source/text/scalc/01/func_leftb.xhp +++ b/source/text/scalc/01/func_leftb.xhp @@ -25,7 +25,6 @@ <h1 id="hd_id2947083"><variable id="leftbvar"><link href="text/scalc/01/func_leftb.xhp">LEFTB</link></variable></h1> <paragraph id="par_id2953622" role="paragraph"><ahelp hid="HID_FUNC_LEFTB">Returns the first characters of a DBCS text.</ahelp></paragraph> </section> -<embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id2946786" role="code">LEFTB("Text" [; Number_bytes])</paragraph> <paragraph id="par_id2947274" role="paragraph"><emph>Text</emph> is the text where the initial partial words are to be determined.</paragraph> diff --git a/source/text/scalc/01/func_lenb.xhp b/source/text/scalc/01/func_lenb.xhp index ebf0a71c84..4a64ffc6e4 100644 --- a/source/text/scalc/01/func_lenb.xhp +++ b/source/text/scalc/01/func_lenb.xhp @@ -26,7 +26,6 @@ <h1 id="hd_id2956110"><variable id="lenbvar"><link href="text/scalc/01/func_lenb.xhp">LENB</link></variable></h1> <paragraph id="par_id2950147" role="paragraph"><ahelp hid="HID_FUNC_LENB">For double-byte character set (DBCS) languages, returns the number of bytes used to represent the characters in a text string.</ahelp></paragraph> </section> -<embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id2954063" role="code">LENB("Text")</paragraph> <paragraph id="par_id2946894" role="paragraph"><emph>Text</emph> is the text whose length is to be determined.</paragraph> diff --git a/source/text/scalc/01/func_let.xhp b/source/text/scalc/01/func_let.xhp index 610d883248..e90be35fa8 100644 --- a/source/text/scalc/01/func_let.xhp +++ b/source/text/scalc/01/func_let.xhp @@ -38,7 +38,6 @@ <paragraph role="paragraph" id="par_id121717701196975">Calculate the molar mass of the water molecule knowing that the molecule has 2 hydrogen atoms and one oxygen atom.</paragraph> <paragraph role="paragraph" id="par_id311717701158800"><input>=LET(mHydro; HLOOKUP("Hydrogen"; $A$1:$DO$4; 4; 0); mOxy; HLOOKUP("Oxygen"; $A$1:$DO$4; 4; 0); "The molar mass of water is "&(mOxy+2*mHydro)&" g/mol")</input> returns "The molar mass of water is 18.015 g/mol".</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> -<embed href="text/scalc/00/avail_release.xhp#24.8"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640870986703" localize="false"><literal>COM.MICROSOFT.LET</literal></paragraph> <section id="relatedtopics"> diff --git a/source/text/scalc/01/func_maxifs.xhp b/source/text/scalc/01/func_maxifs.xhp index 1da5e07ac2..2902ca8701 100644 --- a/source/text/scalc/01/func_maxifs.xhp +++ b/source/text/scalc/01/func_maxifs.xhp @@ -55,7 +55,6 @@ <paragraph id="par_id30574750215839" role="paragraph">If E2 = "pen", the function returns 65, because the reference to the cell is substituted with its content.</paragraph> <embed href="text/scalc/06/calcsamplefiles.xhp#func_ifs"/> <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_id341640873986703" localize="false"><literal>COM.MICROSOFT.MAXIFS</literal></paragraph> <section id="relatedtopics"> diff --git a/source/text/scalc/01/func_midb.xhp b/source/text/scalc/01/func_midb.xhp index 0e9b97ff9b..7bddbefdc9 100644 --- a/source/text/scalc/01/func_midb.xhp +++ b/source/text/scalc/01/func_midb.xhp @@ -26,7 +26,6 @@ <h1 id="hd_id2954589"><variable id="midbvar"><link href="text/scalc/01/func_midb.xhp">MIDB</link></variable></h1> <paragraph id="par_id2954938" role="paragraph"><ahelp hid="HID_FUNC_MIDB">Returns a text string of a DBCS text. The parameters specify the starting position and the number of characters.</ahelp></paragraph> </section> -<embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id2950526" role="code">MIDB("Text"; Start; Number_bytes)</paragraph> <paragraph id="par_id2948820" role="paragraph"><emph>Text</emph> is the text containing the characters to extract.</paragraph> diff --git a/source/text/scalc/01/func_minifs.xhp b/source/text/scalc/01/func_minifs.xhp index 4f0fc46e66..5228946815 100644 --- a/source/text/scalc/01/func_minifs.xhp +++ b/source/text/scalc/01/func_minifs.xhp @@ -55,7 +55,6 @@ <paragraph id="par_id30574750215839" role="paragraph">If E2 = "book", the function returns 180, because the reference to the cell is substituted with its content.</paragraph> <embed href="text/scalc/06/calcsamplefiles.xhp#func_ifs"/> <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_id341640873986703" localize="false"><literal>COM.MICROSOFT.MINIFS</literal></paragraph> <section id="relatedtopics"> diff --git a/source/text/scalc/01/func_networkdays.intl.xhp b/source/text/scalc/01/func_networkdays.intl.xhp index cfd87b74a5..8b5cd0dc8a 100644 --- a/source/text/scalc/01/func_networkdays.intl.xhp +++ b/source/text/scalc/01/func_networkdays.intl.xhp @@ -51,7 +51,6 @@ <paragraph id="par_id231020162249556946" role="paragraph">The function can be used without the two optional parameters – weekday and holidays – by leaving them out:</paragraph> <paragraph id="par_id23102016224955931" role="paragraph"><item type="input">=NETWORKDAYS.INTL(C3;D3)</item> gives 22 working days.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> -<embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640873986703" localize="false"><literal>COM.MICROSOFT.NETWORKDAYS.INTL</literal></paragraph> <section id="relatedtopics"> diff --git a/source/text/scalc/01/func_numbervalue.xhp b/source/text/scalc/01/func_numbervalue.xhp index 7ee68a675a..ff19bce48b 100644 --- a/source/text/scalc/01/func_numbervalue.xhp +++ b/source/text/scalc/01/func_numbervalue.xhp @@ -33,7 +33,6 @@ <paragraph xml-lang="en-US" id="par_id3145087" role="paragraph"> <ahelp hid="HID_FUNC_NUMBERVALUE">Converts the string representation of a number into a locale-independent numeric value.</ahelp> </paragraph> - <embed href="text/scalc/00/avail_release.xhp#4.1"/> <paragraph xml-lang="en-US" id="par_id3149281" role="paragraph">The input text may be in a locale-dependent or other bespoke format.</paragraph> <paragraph role="paragraph" id="par_id381625600941159">The output number is formatted as a valid floating point value and shown using the current cell's number format.</paragraph> <tip id="par_id351625601754290">Refer to the <link href="text/shared/01/05020300.xhp">Numbers / Format</link> help page to learn how to change the format of numbers in a cell.</tip> diff --git a/source/text/scalc/01/func_opt_barrier.xhp b/source/text/scalc/01/func_opt_barrier.xhp index 19cc456c43..03806b50c2 100644 --- a/source/text/scalc/01/func_opt_barrier.xhp +++ b/source/text/scalc/01/func_opt_barrier.xhp @@ -44,7 +44,6 @@ <paragraph role="paragraph" id="par_id651575073773761"><input>=OPT_BARRIER(30;0.2;0.06;0;1;40;25;0;0;"c";"o";"c")</input> returns the value 0.4243.</paragraph> <paragraph role="paragraph" id="par_id401575073777593"><input>=OPT_BARRIER(50;0.4;0.05;0;0.5;65;0;80;0;"p";"o";"c";"e")</input> returns the value 10.1585.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> - <embed href="text/scalc/00/avail_release.xhp#4.0"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640873986703" localize="false"><literal>COM.SUN.STAR.SHEET.ADDIN.PRICINGFUNCTIONS.GETOPTBARRIER</literal></paragraph> <section id="relatedtopics"> diff --git a/source/text/scalc/01/func_opt_prob_hit.xhp b/source/text/scalc/01/func_opt_prob_hit.xhp index 43c6aeaa30..bc1ba49708 100644 --- a/source/text/scalc/01/func_opt_prob_hit.xhp +++ b/source/text/scalc/01/func_opt_prob_hit.xhp @@ -42,7 +42,6 @@ <paragraph role="paragraph" id="par_id971575074431070"><input>=OPT_PROB_HIT(30;0.2;0.3;1;0;40)</input> returns the value 0.6119.</paragraph> <paragraph role="paragraph" id="par_id171575074434932"><input>=OPT_PROB_HIT(70;0.3;0.1;0.5;60;0)</input> returns the value 0.4239.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> - <embed href="text/scalc/00/avail_release.xhp#4.0"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640873986703" localize="false"><literal>COM.SUN.STAR.SHEET.ADDIN.PRICINGFUNCTIONS.GETOPTPROBHIT</literal></paragraph> <section id="relatedtopics"> diff --git a/source/text/scalc/01/func_opt_prob_inmoney.xhp b/source/text/scalc/01/func_opt_prob_inmoney.xhp index 58293feaf3..7d512ba562 100644 --- a/source/text/scalc/01/func_opt_prob_inmoney.xhp +++ b/source/text/scalc/01/func_opt_prob_inmoney.xhp @@ -51,7 +51,6 @@ <paragraph role="paragraph" id="par_id601575074993334"><input>=OPT_PROB_INMONEY(30;0.2;0.1;1;0;50)</input> returns the value 0.9844.</paragraph> <paragraph role="paragraph" id="par_id261575074997216"><input>=OPT_PROB_INMONEY(70;0.3;0.15;1;60;0;80;"p")</input> returns the value 0.3440.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> - <embed href="text/scalc/00/avail_release.xhp#4.0"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640873986703" localize="false"><literal>COM.SUN.STAR.SHEET.ADDIN.PRICINGFUNCTIONS.GETOPTPROBINMONEY</literal></paragraph> <section id="relatedtopics"> diff --git a/source/text/scalc/01/func_opt_touch.xhp b/source/text/scalc/01/func_opt_touch.xhp index 05e0e9168b..06b7880399 100644 --- a/source/text/scalc/01/func_opt_touch.xhp +++ b/source/text/scalc/01/func_opt_touch.xhp @@ -74,7 +74,6 @@ <paragraph role="paragraph" id="par_id181575063666675"><input>=OPT_TOUCH(50;0.25;0.05;0;1;0;55;"d";"i";"c")</input> returns the value 0.6876.</paragraph> <paragraph role="paragraph" id="par_id811575063677250"><input>=OPT_TOUCH(80;0.2;0.05;0;0.5;60;0;"f";"o";"c";"r")</input> returns the value 15.5516.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> - <embed href="text/scalc/00/avail_release.xhp#4.0"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640873986703" localize="false"><literal>COM.SUN.STAR.SHEET.ADDIN.PRICINGFUNCTIONS.GETOPTTOUCH</literal></paragraph> <section id="relatedtopics"> diff --git a/source/text/scalc/01/func_randarray.xhp b/source/text/scalc/01/func_randarray.xhp index 9ec298ad44..318f32e05a 100644 --- a/source/text/scalc/01/func_randarray.xhp +++ b/source/text/scalc/01/func_randarray.xhp @@ -37,7 +37,6 @@ <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph role="paragraph" id="par_id521715616457946"><input>{=RANDARRAY(10;4;10;50;1)}</input> returns an array of 10 rows, 4 columns with minimum value 10 and maximum value of 50 of whole numbers (integers).</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> -<embed href="text/scalc/00/avail_release.xhp#24.8"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640870986703" localize="false"><literal>COM.MICROSOFT.RANDARRAY</literal></paragraph> <section id="relatedtopics"> diff --git a/source/text/scalc/01/func_rawsubtract.xhp b/source/text/scalc/01/func_rawsubtract.xhp index cfa4bdbdfa..c4010634ad 100644 --- a/source/text/scalc/01/func_rawsubtract.xhp +++ b/source/text/scalc/01/func_rawsubtract.xhp @@ -35,7 +35,6 @@ <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> diff --git a/source/text/scalc/01/func_regex.xhp b/source/text/scalc/01/func_regex.xhp index 924664708d..3f5b56b34f 100644 --- a/source/text/scalc/01/func_regex.xhp +++ b/source/text/scalc/01/func_regex.xhp @@ -40,7 +40,6 @@ <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"> diff --git a/source/text/scalc/01/func_replaceb.xhp b/source/text/scalc/01/func_replaceb.xhp index d9c61cf31b..7b810e291f 100644 --- a/source/text/scalc/01/func_replaceb.xhp +++ b/source/text/scalc/01/func_replaceb.xhp @@ -25,7 +25,6 @@ <h1 id="hd_id771573508637966"><variable id="replaceb"><link href="text/scalc/01/func_replaceb.xhp">REPLACEB</link></variable></h1> -e ... etc. - the rest is truncated
