tdf#94537 COM.MICROSOFT.* namespace information

+ Covered all COM.MICROSOFT namespace of wiki page in the bug report.
+ refactor of other info such as release number availability.
+ Muted l10N in a table and drop duplication.

Change-Id: Id77f9657f164193d5e672e9edf82a2170b5f4040
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/127817
Tested-by: Jenkins
Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>

1 files changed, 13 insertions, 4 deletions

diff --git a/source/text/scalc/01/func_floor.xhp b/source/text/scalc/01/func_floor.xhp
index 922bad3359..044fee3e2b 100644
--- a/source/text/scalc/01/func_floor.xhp
+++ b/source/text/scalc/01/func_floor.xhp
@@ -54,7 +54,6 @@
 <h2 id="hd_id1001586287279297"><variable id="FLOOR.MATHh1"><link href="text/scalc/01/func_floor.xhp#floormath" name="FLOOR.MATH">FLOOR.MATH</link></variable></h2>
         <paragraph role="paragraph" id="par_id721586287302689">Rounds a number to the nearest multiple of a significance value.</paragraph>
         <paragraph role="paragraph" id="par_id311586287323417">For a positive number the function rounds down (towards zero). For a negative number, the direction of rounding is determined by the value of a mode parameter. The sign of the significance value is ignored.</paragraph>
-        <embed href="text/scalc/00/avail_release.xhp#5.0"/>
         <warning id="par_id851586287535879">This function exists for interoperability with Microsoft Excel 2013 or newer.</warning>
         <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
         <paragraph role="code" id="par_id161586287421523">FLOOR.MATH(Number[; Significance[; Mode]])</paragraph>
@@ -67,6 +66,10 @@
         <paragraph role="paragraph" id="par_id981586287632392"><input>=FLOOR.MATH(-1.234)</input> returns -2.</paragraph>
         <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>
 
     <section id="floorprecise">
@@ -81,16 +84,19 @@
         <h2 id="hd_id2957404"><variable id="FLOOR.PRECISEh1"><link href="text/scalc/01/func_floor.xhp#floorprecise" name="FLOOR.PRECISE">FLOOR.PRECISE</link></variable></h2>
         <paragraph id="par_id2957432" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_FLOOR_MS">Rounds a number down to the nearest multiple of a significance value.</ahelp></paragraph>
         <paragraph role="paragraph" id="par_id261586641501175">For a positive number the function rounds down (towards zero). For a negative number, the function rounds down (away form zero). The sign of the significance value is ignored.</paragraph>
-        <embed href="text/scalc/00/avail_release.xhp#4.3"/>
       <embed href="text/scalc/01/func_floor.xhp#floor_warn"/>
         <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
         <paragraph id="par_id2957464" role="code" xml-lang="en-US">FLOOR.PRECISE(Number[; Significance])</paragraph>
         <embed href="text/scalc/01/func_floor.xhp#argnumber"/>
         <paragraph id="par_id2957497" role="paragraph" xml-lang="en-US"><emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to 1.</paragraph>
-        
+
         <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
         <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>
     </section>
 
@@ -101,7 +107,6 @@
 <h2 id="hd_id791586291468176"><variable id="FLOOR.XCLh1"><link href="text/scalc/01/func_floor.xhp#floorxcl" name="FLOOR.XCL">FLOOR.XCL</link></variable></h2>
         <paragraph role="paragraph" id="par_id521586291476023">Rounds a number to the nearest multiple of a significance value.</paragraph>
         <paragraph role="paragraph" id="par_id401586291488768">For a positive number and a positive significance value, the function rounds down (towards zero). For a negative number and a positive significance value, the function rounds down (away from zero). For a negative number and a negative significance value, the function rounds up (towards zero). The function returns an error if the number is positive and the significance value is negative.</paragraph>
-        <embed href="text/scalc/00/avail_release.xhp#5.0"/>
         <warning id="par_id231586291503319">This function exists for interoperability with Microsoft Excel 2007 or older. If a Calc spreadsheet is exported to Microsoft Excel, references to Calc’s FLOOR.XCL function are exported as references to Excel’s FLOOR function, which is compatible with all Excel versions. If a Microsoft Excel spreadsheet is imported into Calc, references to Excel’s FLOOR function are imported as references to Calc’s FLOOR.XCL function.</warning>
         <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
         <paragraph role="code" id="par_id491586291532177">FLOOR.XCL(Number; Significance)</paragraph>
@@ -111,6 +116,10 @@
         <paragraph role="paragraph" id="par_id531586291622306"><input>=FLOOR.XCL(3.45,2)</input> returns 2.</paragraph>
         <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>
     <section id="relatedtopics">
         <embed href="text/scalc/01/func_ceiling.xhp#CEILINGh1"/>