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, 24 insertions, 7 deletions

diff --git a/source/text/scalc/01/04060183.xhp b/source/text/scalc/01/04060183.xhp
index a4e5524bd8..5a13443753 100644
--- a/source/text/scalc/01/04060183.xhp
+++ b/source/text/scalc/01/04060183.xhp
@@ -19,7 +19,6 @@
  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  -->
 
-
 <meta>
 <topic id="textscalc0104060183xml" indexer="include">
 <title id="tit" xml-lang="en-US">Statistical Functions Part Three</title>
@@ -87,7 +86,6 @@
 <h2 id="hd_id2953559">CONFIDENCE.T</h2>
 <paragraph role="paragraph" id="par_id2953814" xml-lang="en-US">
     <ahelp hid="HID_FUNC_CONFIDENCE_T">Returns the (1-alpha) confidence interval for a Student's t distribution.</ahelp></paragraph>
-<embed href="text/scalc/00/avail_release.xhp#4.2"/>
 <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
 <paragraph role="code" id="par_id2947501" xml-lang="en-US">CONFIDENCE.T(Alpha; StDev; Size)</paragraph>
 <paragraph role="paragraph" id="par_id2949872" xml-lang="en-US">
@@ -99,6 +97,10 @@
 <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
 <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>
 <section id="confidencedotnorm">
 <bookmark xml-lang="en-US" branch="index" id="bm_id2853559"><bookmark_value>CONFIDENCE.NORM function</bookmark_value>
@@ -107,7 +109,6 @@
 <h2 id="hd_id2853559">CONFIDENCE.NORM</h2>
 <paragraph role="paragraph" id="par_id2853814" xml-lang="en-US">
     <ahelp hid="HID_FUNC_CONFIDENCE_N">Returns the (1-alpha) confidence interval for a normal distribution.</ahelp></paragraph>
-<embed href="text/scalc/00/avail_release.xhp#4.2"/>
 <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
 <paragraph role="code" id="par_id2847501" xml-lang="en-US">CONFIDENCE.NORM(Alpha; StDev; Size)</paragraph>
 <paragraph role="paragraph" id="par_id2849872" xml-lang="en-US">
@@ -119,6 +120,10 @@
 <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
 <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>
 <section id="correl">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3148746"><bookmark_value>CORREL function</bookmark_value>
@@ -161,13 +166,16 @@
     <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COVARIANCE_P" id="bm_id2952983" localize="false"/>
     <h2 id="hd_id2950652">COVARIANCE.P</h2>
     <paragraph role="paragraph" id="par_id2946875" xml-lang="en-US"><ahelp hid="HID_FUNC_COVARIANCE_P">Returns the covariance of the product of paired deviations, for the entire population.</ahelp></paragraph>
-    <embed href="text/scalc/00/avail_release.xhp#4.2"/>
     <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
     <paragraph role="code" id="par_id2950740" xml-lang="en-US">COVARIANCE.P(Data1; Data2)</paragraph>
     <paragraph role="paragraph" id="par_id2945827" xml-lang="en-US"><emph>Data1</emph> is the first data set.</paragraph>
     <paragraph role="paragraph" id="par_id2950465" xml-lang="en-US"><emph>Data2</emph> is the second data set.</paragraph>
     <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>
 <section id="covariancedots">
     <bookmark xml-lang="en-US" branch="index" id="bm_id280652">
@@ -176,13 +184,16 @@
     <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COVARIANCE_S" id="bm_id2852983" localize="false"/>
     <h2 id="hd_id2850652">COVARIANCE.S</h2>
     <paragraph role="paragraph" id="par_id2846875" xml-lang="en-US"><ahelp hid="HID_FUNC_COVARIANCE_S">Returns the covariance of the product of paired deviations, for a sample of the population.</ahelp></paragraph>
-    <embed href="text/scalc/00/avail_release.xhp#4.2"/>
     <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
     <paragraph role="code" id="par_id2850740" xml-lang="en-US">COVARIANCE.S(Data1; Data2)</paragraph>
     <paragraph role="paragraph" id="par_id2845827" xml-lang="en-US"><emph>Data1</emph> is the first data set.</paragraph>
     <paragraph role="paragraph" id="par_id2850465" xml-lang="en-US"><emph>Data2</emph> is the second data set.</paragraph>
     <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>
 <section id="critbinom">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3147472"><bookmark_value>CRITBINOM function</bookmark_value>
@@ -245,7 +256,6 @@
 <h2 id="hd_id2901928">LOGNORM.INV</h2>
 <paragraph role="paragraph" id="par_id2901297" xml-lang="en-US"><ahelp hid="HID_FUNC_LOGINV_MS">Returns the inverse of the lognormal distribution.</ahelp></paragraph>
 <paragraph id="par_id290122405814" role="paragraph" xml-lang="en-US">This function is identical to LOGINV and was introduced for interoperability with other office suites.</paragraph>
-<embed href="text/scalc/00/avail_release.xhp#4.3"/>
 <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
 <paragraph role="code" id="par_id2901049" xml-lang="en-US">LOGNORM.INV(Number [; Mean [; StDev]])</paragraph>
 <paragraph role="paragraph" id="par_id2901390" xml-lang="en-US">
@@ -257,6 +267,10 @@
 <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
 <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>
 <section id="lognormdist">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3158417"><bookmark_value>LOGNORMDIST function</bookmark_value>
@@ -286,7 +300,6 @@
 <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_LOGNORMDIST_MS" id="bm_id2901366" localize="false"/>
 <h2 id="hd_id2908417">LOGNORM.DIST</h2>
 <paragraph role="paragraph" id="par_id2904953" xml-lang="en-US"><ahelp hid="HID_FUNC_LOGNORMDIST_MS">Returns the values of a lognormal distribution.</ahelp></paragraph>
-<embed href="text/scalc/00/avail_release.xhp#4.3"/>
 <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
 <paragraph role="code" id="par_id2900686" xml-lang="en-US">LOGNORM.DIST(Number; Mean; StDev; Cumulative)</paragraph>
 <paragraph role="paragraph" id="par_id2904871" xml-lang="en-US">
@@ -300,6 +313,10 @@
 <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
 <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_id341670873986703" localize="false"><literal>COM.MICROSOFT.LOGNORM.DIST</literal></paragraph>
 </section>
 </sort>
 <section id="relatedtopics">