diff options
author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2022-01-01 08:41:22 -0300 |
---|---|---|
committer | Adolfo Jayme Barrientos <fitojb@ubuntu.com> | 2022-01-02 13:41:16 +0100 |
commit | 990e1236dc288bca7e7c8678353f505e9d1e9116 (patch) | |
tree | 6ff6003c22c94643a775c2873cc1d2fa09fc1617 | |
parent | 8d12e99d7502858285b5a0acc695036aa3b916f5 (diff) |
tdf#94537 ORG.OPENOFFICE.* namespace information
+ removed reference to other suite interoperability
Change-Id: Ide0fe6dd306e1cd3fa2e0a7377b16fb1a6e89f58
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/127839
Tested-by: Jenkins
Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
-rw-r--r-- | source/text/scalc/01/04060104.xhp | 5 | ||||
-rw-r--r-- | source/text/scalc/01/04060109.xhp | 6 | ||||
-rw-r--r-- | source/text/scalc/01/04060111.xhp | 26 | ||||
-rw-r--r-- | source/text/scalc/01/common_func.xhp | 2 | ||||
-rw-r--r-- | source/text/scalc/01/func_convert.xhp | 4 | ||||
-rw-r--r-- | source/text/scalc/01/func_eastersunday.xhp | 3 |
6 files changed, 42 insertions, 4 deletions
diff --git a/source/text/scalc/01/04060104.xhp b/source/text/scalc/01/04060104.xhp index b58ecf801d..f45da63d71 100644 --- a/source/text/scalc/01/04060104.xhp +++ b/source/text/scalc/01/04060104.xhp @@ -218,6 +218,9 @@ <paragraph id="par_id7463911" role="paragraph" xml-lang="en-US">The example returns A2 + B2 (STYLE returns 0 here). If this sum is greater than 10, the style Red is applied to the cell. See the <emph>STYLE</emph> function for more explanation.</paragraph> <paragraph id="par_id7318643" role="paragraph" xml-lang="en-US"><item type="input">="choo"&CURRENT()</item></paragraph> <paragraph id="par_id6019165" role="paragraph" xml-lang="en-US">The example returns choochoo.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id311640873986703" localize="false"><literal>ORG.OPENOFFICE.CURRENT</literal></paragraph> </section> <section id="formula"> <bookmark xml-lang="en-US" branch="index" id="bm_id3150688"> @@ -736,4 +739,4 @@ <embed href="text/scalc/01/04060100.xhp#drking"/> </section> </body> -</helpdocument>
\ No newline at end of file +</helpdocument> diff --git a/source/text/scalc/01/04060109.xhp b/source/text/scalc/01/04060109.xhp index 17fb832626..98b8020177 100644 --- a/source/text/scalc/01/04060109.xhp +++ b/source/text/scalc/01/04060109.xhp @@ -166,6 +166,9 @@ <emph>Reference</emph> contains the address of the cell in which the error occurs.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id3146904" role="paragraph">If cell A1 displays Err:518, the function <item type="input">=ERRORTYPE(A1)</item> returns the number 518.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id311640873986703" localize="false"><literal>ORG.OPENOFFICE.ERRORTYPE</literal></paragraph> </section> <section id="error_type"> <h2 id="hd_id275141466817507" localize="false"><embedvar href="text/scalc/01/func_error_type.xhp#error_type_head"/></h2> @@ -432,6 +435,9 @@ <item type="input">="Text"&T(STYLE("myStyle"))</item> </paragraph> <paragraph xml-lang="en-US" id="par_id3042085" role="paragraph">See also CURRENT() for another example.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id311644873986703" localize="false"><literal>ORG.OPENOFFICE.STYLE</literal></paragraph> </section> <section id="Section16"> <bookmark xml-lang="en-US" branch="index" id="bm_id3150430"><bookmark_value>CHOOSE function</bookmark_value> diff --git a/source/text/scalc/01/04060111.xhp b/source/text/scalc/01/04060111.xhp index 398b49b571..6b71378b5e 100644 --- a/source/text/scalc/01/04060111.xhp +++ b/source/text/scalc/01/04060111.xhp @@ -55,6 +55,9 @@ <paragraph role="paragraph" id="par_id3150786" xml-lang="en-US">=ISLEAPYEAR(A1) returns 1, if A1 contains 1968-02-29, the valid date 29th of February 1968 in your locale setting.</paragraph> <paragraph role="paragraph" id="par_idN107E7" xml-lang="en-US">You may also use =ISLEAPYEAR(DATE(1968;2;29)) or =ISLEAPYEAR("1968-02-29") giving the date string in the ISO 8601 notation.</paragraph> <paragraph role="paragraph" id="par_idN107EA" xml-lang="en-US">Never use =ISLEAPYEAR(2/29/68), because this would first evaluate 2 divided by 29 divided by 68, and then calculate the ISLEAPYEAR function from this small number as a serial date number.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id311600873986703" localize="false"><literal>ORG.OPENOFFICE.ISLEAPYEAR</literal></paragraph> </section> <section id="years"> <bookmark xml-lang="en-US" branch="index" id="bm_id3154656"><bookmark_value>YEARS function</bookmark_value> @@ -71,6 +74,9 @@ <emph>EndDate</emph> is the second date</paragraph> <paragraph role="paragraph" id="par_id3152893" xml-lang="en-US"> <emph>Type</emph> calculates the type of difference. Possible values are 0 (interval) and 1 (in calendar years).</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id311640873086703" localize="false"><literal>ORG.OPENOFFICE.YEARS</literal></paragraph> </section> <section id="months"> <bookmark xml-lang="en-US" branch="index" id="bm_id3152898"><bookmark_value>MONTHS function</bookmark_value> @@ -87,6 +93,9 @@ <emph>EndDate</emph> is the second date</paragraph> <paragraph role="paragraph" id="par_id3150111" xml-lang="en-US"> <emph>Type</emph> calculates the type of difference. Possible values include 0 (interval) and 1 (in calendar months).</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id321640873986703" localize="false"><literal>ORG.OPENOFFICE.MONTHS</literal></paragraph> </section> <section id="rot13"> <bookmark xml-lang="en-US" branch="index" id="bm_id3159094"><bookmark_value>ROT13 function</bookmark_value> @@ -101,7 +110,10 @@ <emph>Text</emph> is the character string to be encrypted. ROT13(ROT13(Text)) decrypts the code.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id151626469224135" role="paragraph"><input>=ROT13("Gur Qbphzrag Sbhaqngvba jnf sbhaqrq va Frcgrzore 2010.")</input> returns the string "The Document Foundation was founded in September 2010.". Notice how spaces, digits, and full stops are unaffected by ROT13.</paragraph> -<tip id="par_id221626469509161">Refer to the <link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/ROT13" name="ROT13_Wiki">ROT13</link> wiki page for more details about this function.</tip> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id314640873986703" localize="false"><literal>ORG.OPENOFFICE.ROT13</literal></paragraph> +<tip id="par_id221626469509161">Refer to the <link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/ROT13" name="ROT13_Wiki">ROT13</link> wiki page for more details about this function.</tip> </section> <section id="daysinyear"> <bookmark xml-lang="en-US" branch="index" id="bm_id3151300"><bookmark_value>DAYSINYEAR function</bookmark_value> @@ -116,6 +128,9 @@ <emph>Date</emph> is any date in the respective year. The Date parameter must be a valid date according to the locale settings of %PRODUCTNAME.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph role="paragraph" id="par_id3153811" xml-lang="en-US">=DAYSINYEAR(A1) returns 366 days if A1 contains 1968-02-29, a valid date for the year 1968.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id311640873586703" localize="false"><literal>ORG.OPENOFFICE.DAYSINYEAR</literal></paragraph> </section> <section id="daysinmonth"> <bookmark xml-lang="en-US" branch="index" id="bm_id3154737"><bookmark_value>DAYSINMONTH function</bookmark_value> @@ -130,6 +145,9 @@ <emph>Date</emph> is any date in the respective month of the desired year. The Date parameter must be a valid date according to the locale settings of %PRODUCTNAME.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph role="paragraph" id="par_id3155742" xml-lang="en-US">=DAYSINMONTH(A1) returns 29 days if A1 contains 1968-02-17, a valid date for February 1968.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id311640873986700" localize="false"><literal>ORG.OPENOFFICE.DAYSINMONTH</literal></paragraph> </section> <section id="weeks"> <bookmark xml-lang="en-US" branch="index" id="bm_id3149048"><bookmark_value>WEEKS function</bookmark_value> @@ -146,6 +164,9 @@ <emph>EndDate</emph> is the second date</paragraph> <paragraph role="paragraph" id="par_id3166467" xml-lang="en-US"> <emph>Type</emph> calculates the type of difference. The possible values are 0 (interval) and 1 (in numbers of weeks).</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id311640873986703" localize="false"><literal>ORG.OPENOFFICE.WEEKS</literal></paragraph> </section> <section id="weeksinyear"> <bookmark xml-lang="en-US" branch="index" id="bm_id3145237"><bookmark_value>WEEKSINYEAR function</bookmark_value> @@ -160,6 +181,9 @@ <emph>Date</emph> is any date in the respective year. The Date parameter must be a valid date according to the locale settings of %PRODUCTNAME.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph role="paragraph" id="par_id3147614" xml-lang="en-US">WEEKSINYEAR(A1) returns 53 if A1 contains 1970-02-17, a valid date for the year 1970.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id311540873986703" localize="false"><literal>ORG.OPENOFFICE.WEEKSINYEAR</literal></paragraph> </section> </sort> <h2 id="hd_id3157901">Add-ins through %PRODUCTNAME API</h2> diff --git a/source/text/scalc/01/common_func.xhp b/source/text/scalc/01/common_func.xhp index 309162d1d4..21fb6f552f 100644 --- a/source/text/scalc/01/common_func.xhp +++ b/source/text/scalc/01/common_func.xhp @@ -28,7 +28,7 @@ <h3 id="hd_id301640873452726">Technical information</h3> </section> <section id="notODFF"> - <paragraph role="paragraph" id="par_id251640873774457">This function is not part of the <emph>Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format</emph> standard and was introduced for interoperability with other office suites. The name space is</paragraph> + <paragraph role="paragraph" id="par_id251640873774457">This function is not part of the <emph>Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format</emph> standard. The name space is</paragraph> </section> <section id="datenumbersequencenote"> <note id="par_id301616845402409">This function ignores any text or empty cell within a data range. If you suspect wrong results from this function, look for text in the data ranges. To highlight text contents in a data range, use the <link href="text/scalc/01/03080000.xhp" name="value highlight">value highlighting</link> feature.</note> diff --git a/source/text/scalc/01/func_convert.xhp b/source/text/scalc/01/func_convert.xhp index 90dc06254f..382c82cad3 100644 --- a/source/text/scalc/01/func_convert.xhp +++ b/source/text/scalc/01/func_convert.xhp @@ -1733,7 +1733,9 @@ </tablecell> </tablerow> </table> - + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id311640873986703" localize="false"><literal>ORG.OPENOFFICE.CONVERT</literal></paragraph> <section id="relatedtopics"> <paragraph role="paragraph" id="par_id871621424421294"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/CONVERT">CONVERT Wiki page</link></paragraph> </section> diff --git a/source/text/scalc/01/func_eastersunday.xhp b/source/text/scalc/01/func_eastersunday.xhp index 5cb4fe7def..8227311c4f 100644 --- a/source/text/scalc/01/func_eastersunday.xhp +++ b/source/text/scalc/01/func_eastersunday.xhp @@ -40,6 +40,9 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph role="paragraph" id="par_id3154472" xml-lang="en-US"><item type="input">=EASTERSUNDAY(2000)</item> returns 2000-04-23.</paragraph> <paragraph role="paragraph" id="par_id3150940" xml-lang="en-US"><item type="input">=EASTERSUNDAY(2000)+49</item> returns the internal serial number 36688. The result is 2000-06-11. Format the serial date number as a date, for example in the format YYYY-MM-DD.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id311640873986703" localize="false"><literal>ORG.OPENOFFICE.EASTERSUNDAY</literal></paragraph> <section id="relatedtopics"> <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/> </section> |