GNOME.org
 

[gnumeric] use mathematical pi rather than greek pi, the latter may look unexpected depending on base font

commit ca017309819e144645b9a25b5abf5c2028eaa595
Author: Andreas J Guelzow <aguelzow pyrshep ca>
Date:   Thu Nov 17 13:06:58 2011 -0700

    use mathematical pi rather than greek pi, the latter may look unexpected depending on base font
    
    2011-11-17 Andreas J. Guelzow <aguelzow pyrshep ca>
    
    	* functions.c (help_pi): use mathematical pi rather than greek pi
    	(help_sqrtpi): use mathematical pi rather than greek pi
    
    2011-11-17  Andreas J. Guelzow <aguelzow pyrshep ca>
    
    	* analysis-statistical.xml: standardize "not yet written"
    	* data-commentNlink.xml: standardize "not yet written"
    	* data-delete.xml: standardize "not yet written"
    	* data-insert.xml: standardize "not yet written"
    	* func.defs: updated
    	* functions.xml: updated

 doc/C/ChangeLog                |    9 ++++
 doc/C/analysis-statistical.xml |   12 ++++-
 doc/C/data-commentNlink.xml    |   31 +++++---------
 doc/C/data-delete.xml          |   16 ++-----
 doc/C/data-insert.xml          |   17 ++-----
 doc/C/func.defs                |   30 +++++++++++--
 doc/C/functions.xml            |   91 +++++++++++++++++++++++++++++++++++++--
 plugins/fn-math/ChangeLog      |    5 ++
 plugins/fn-math/functions.c    |    8 ++--
 9 files changed, 159 insertions(+), 60 deletions(-)
---
diff --git a/doc/C/ChangeLog b/doc/C/ChangeLog
index d6ec025..258b199 100644
--- a/doc/C/ChangeLog
+++ b/doc/C/ChangeLog
@@ -1,3 +1,12 @@
+2011-11-17  Andreas J. Guelzow <aguelzow pyrshep ca>
+
+	* analysis-statistical.xml: standardize "not yet written"
+	* data-commentNlink.xml: standardize "not yet written"
+	* data-delete.xml: standardize "not yet written"
+	* data-insert.xml: standardize "not yet written"
+	* func.defs: updated
+	* functions.xml: updated
+
 2011-11-03  Andreas J. Guelzow <aguelzow pyrshep ca>
 
 	* ssconvert.1: add new 'paper=fit' option for pdf exporter
diff --git a/doc/C/analysis-statistical.xml b/doc/C/analysis-statistical.xml
index 7cea15b..52b8b30 100644
--- a/doc/C/analysis-statistical.xml
+++ b/doc/C/analysis-statistical.xml
@@ -3227,7 +3227,9 @@
       with a given median is in section  <xref linkend="sign-test-tool" />.
     </para>
   </note>
-      <para>This section has not yet been written</para>
+  <note>
+      <para>This section needs to be written.</para>
+  </note>
   </sect3>
   <sect3 id="two-median-wilcoxon-sign-test-tool">
       <title>Wilcoxon Signed Rank Test</title>
@@ -3243,11 +3245,15 @@
       <xref linkend="wilcoxon-sign-test-tool" />.
     </para>
   </note>
-      <para>This section has not yet been written</para>
+  <note>
+      <para>This section needs to be written.</para>
+  </note>
   </sect3>
   <sect3 id="two-median-wilcoxon-mann-whitney-test-tool">
       <title>Wilcoxon-Mann-Whitney Test</title>
-      <para>This section has not yet been written</para>
+  <note>
+      <para>This section needs to be written.</para>
+  </note>
   </sect3>
 
   </sect2>
diff --git a/doc/C/data-commentNlink.xml b/doc/C/data-commentNlink.xml
index 1f5fff3..10fcb20 100644
--- a/doc/C/data-commentNlink.xml
+++ b/doc/C/data-commentNlink.xml
@@ -1,17 +1,11 @@
 <sect1 id="sect-data-comment">
   <title>Adding a Comment to a Cell</title>
   
-  <para>
-    This section has not yet been written...
-  </para>
-
-  <para>
-    Para...
-  </para>
-
-  <para>
-    Para...
-  </para>
+  <note>
+    <para>
+      This section needs to be written.
+    </para>
+  </note>
 
 <!--
   <sect2 id="sect-data-comment-">
@@ -33,17 +27,14 @@
 <sect1 id="sect-data-link">
   <title>Adding a Hyperlink to a Cell</title>
   
-  <para>
-    This section has not yet been written...
-  </para>
 
-  <para>
-    Para...
-  </para>
 
-  <para>
-    Para...
-  </para>
+  <note>
+    <para>
+      This section needs to be written.
+    </para>
+  </note>
+
 
 <!--
   <sect2 id="sect-data-link-">
diff --git a/doc/C/data-delete.xml b/doc/C/data-delete.xml
index 7cc0af3..3da68a8 100644
--- a/doc/C/data-delete.xml
+++ b/doc/C/data-delete.xml
@@ -1,17 +1,11 @@
 <sect1 id="sect-data-delete">
   <title>Deleting Data</title>
   
-  <para>
-    This section has not yet been written...
-  </para>
-
-  <para>
-    Para...
-  </para>
-
-  <para>
-    Para...
-  </para>
+  <note>
+    <para>
+      This section needs to be written.
+    </para>
+  </note>
 
 <!--
   <sect2 id="sect-data-delete-">
diff --git a/doc/C/data-insert.xml b/doc/C/data-insert.xml
index 826c59e..1a030b5 100644
--- a/doc/C/data-insert.xml
+++ b/doc/C/data-insert.xml
@@ -2,18 +2,11 @@
 <sect1 id="sect-data-insert">
   <title>Inserting New Data Cells</title>
   
-  <para>
-    This section has not yet been written...
-  </para>
-
-  <para>
-    Para...
-  </para>
-
-  <para>
-    Para...
-  </para>
-
+  <note>
+    <para>
+      This section needs to be written.
+    </para>
+  </note>
 
 <!--
   <sect2 id="sect-data-delete-">
diff --git a/doc/C/func.defs b/doc/C/func.defs
index 088fa3b..dfbd80d 100644
--- a/doc/C/func.defs
+++ b/doc/C/func.defs
@@ -1238,6 +1238,14 @@ If @{places} is given and @{x} is negative, @{places} is ignored.
 @SEEALSO=OCT2HEX,HEX2BIN,HEX2DEC
 
 @CATEGORY=Engineering
+ FUNCTION=HEXREP
+ SHORTDESC=hexadecimal representation of numeric value
+ SYNTAX=HEXREP(x)
+ ARGUMENTDESCRIPTION=@{x}: number
+ DESCRIPTION=HEXREP returns a hexadecimal string representation of @x.
+ NOTE=This is a function meant for debugging.  The layout of the result may change and even depend on how Gnumeric was compiled.
+
+ CATEGORY=Engineering
 @FUNCTION=INVSUMINV
 @SHORTDESC=the reciprocal of the sum of reciprocals of the arguments
 @SYNTAX=INVSUMINV(x0,x1,â)
@@ -3516,10 +3524,20 @@ The depreciation coefficient used is:
 @SEEALSO=EVEN
 
 @CATEGORY=Mathematics
+ FUNCTION=ODF SUMPRODUCT
+ SHORTDESC=multiplies components and adds the results
+ SYNTAX=ODF SUMPRODUCT(,â)
+ DESCRIPTION=Multiplies corresponding data entries in the given arrays or ranges, and then returns the sum of those products.
+ NOTE=If an entry is not numeric or logical, the value zero is used instead. If arrays or range arguments do not have the same dimensions, return #VALUE! error. This function differs from SUMPRODUCT by considering booleans.
+ EXCEL=This function is not Excel compatible. Use SUMPRODUCT instead.
+ ODF=This function is OpenFormula compatible.
+ SEEALSO=SUMPRODUCT,SUM,PRODUCT,G_PRODUCT
+
+ CATEGORY=Mathematics
 @FUNCTION=PI
- SHORTDESC=the constant Ï
+ SHORTDESC=the constant ð
 @SYNTAX=PI()
- EXCEL=This function is Excel compatible, but it returns Ï with a better precision.
+ EXCEL=This function is Excel compatible, but it returns ð with a better precision.
 @SEEALSO=SQRTPI
 
 @CATEGORY=Mathematics
@@ -3674,7 +3692,7 @@ If @{d} is less than zero, @{x} is rounded away from 0 to the left of the decima
 
 @CATEGORY=Mathematics
 @FUNCTION=SQRTPI
- SHORTDESC=the square root of @{x} times Ï
+ SHORTDESC=the square root of @{x} times ð
 @SYNTAX=SQRTPI(x)
 @ARGUMENTDESCRIPTION= {x}: non-negative number
 @EXCEL=This function is Excel compatible.
@@ -3715,8 +3733,10 @@ If @{d} is less than zero, @{x} is rounded away from 0 to the left of the decima
 @SHORTDESC=multiplies components and adds the results
 @SYNTAX=SUMPRODUCT(,â)
 @DESCRIPTION=Multiplies corresponding data entries in the given arrays or ranges, and then returns the sum of those products.
- NOTE=If an entry is not numeric, the value zero is used instead. If arrays or range arguments do not have the same dimensions, return #VALUE! error. SUMPRODUCTs arguments are arrays or ranges. Attempting to use A1:A5>0 will not work, implicit intersection will kick in. Instead use --(A1:A5>0)
- SEEALSO=SUM,PRODUCT,G_PRODUCT
+ NOTE=If an entry is not numeric, the value zero is used instead. If arrays or range arguments do not have the same dimensions, return #VALUE! error. This function ignores logicals, so using SUMPRODUCT(A1:A5>0) will not work.  Instead use SUMPRODUCT(--(A1:A5>0))
+ EXCEL=This function is Excel compatible.
+ ODF=This function is not OpenFormula compatible. Use ODF.SUMPRODUCT instead.
+ SEEALSO=SUM,PRODUCT,G_PRODUCT,ODF.SUMPRODUCT
 
 @CATEGORY=Mathematics
 @FUNCTION=SUMSQ
diff --git a/doc/C/functions.xml b/doc/C/functions.xml
index 83fadd9..432bb6c 100644
--- a/doc/C/functions.xml
+++ b/doc/C/functions.xml
@@ -4316,6 +4316,36 @@
       </para>
       </refsect1>
     </refentry>
+    <refentry id="gnumeric-function-HEXREP">
+      <refmeta>
+        <refentrytitle>
+          <function>HEXREP</function>
+        </refentrytitle>
+      </refmeta>
+      <refnamediv>
+        <refname>
+          <function>HEXREP</function>
+        </refname>
+        <refpurpose>
+        hexadecimal representation of numeric value
+      </refpurpose>
+      </refnamediv>
+      <refsynopsisdiv>
+        <synopsis><function>HEXREP</function>(<parameter>x</parameter>)</synopsis>
+      </refsynopsisdiv>
+      <refsect1>
+        <title>Arguments</title>
+        <para><parameter>x</parameter>: number</para>
+      </refsect1>
+      <refsect1>
+        <title>Description</title>
+        <para><function>HEXREP</function> returns a hexadecimal string representation of <parameter>x</parameter>.</para>
+      </refsect1>
+      <refsect1>
+        <title>Note</title>
+        <para>This is a function meant for debugging.  The layout of the result may change and even depend on how Gnumeric was compiled.</para>
+      </refsect1>
+    </refentry>
     <refentry id="gnumeric-function-INVSUMINV">
       <refmeta>
         <refentrytitle>
@@ -11902,6 +11932,48 @@
       </para>
       </refsect1>
     </refentry>
+    <refentry id="gnumeric-function-ODF.SUMPRODUCT">
+      <refmeta>
+        <refentrytitle>
+          <function>ODF.SUMPRODUCT</function>
+        </refentrytitle>
+      </refmeta>
+      <refnamediv>
+        <refname>
+          <function>ODF.SUMPRODUCT</function>
+        </refname>
+        <refpurpose>
+        multiplies components and adds the results
+      </refpurpose>
+      </refnamediv>
+      <refsynopsisdiv>
+        <synopsis><function>ODF.SUMPRODUCT</function>(<parameter/>,<parameter/>â)</synopsis>
+      </refsynopsisdiv>
+      <refsect1>
+        <title>Description</title>
+        <para>Multiplies corresponding data entries in the given arrays or ranges, and then returns the sum of those products.</para>
+      </refsect1>
+      <refsect1>
+        <title>Note</title>
+        <para>If an entry is not numeric or logical, the value zero is used instead. If arrays or range arguments do not have the same dimensions, return #VALUE! error. This function differs from SUMPRODUCT by considering booleans.</para>
+      </refsect1>
+      <refsect1>
+        <title>Microsoft Excel Compatibility</title>
+        <para>This function is not Excel compatible. Use SUMPRODUCT instead.</para>
+      </refsect1>
+      <refsect1>
+        <title>OpenDocument Format (ODF) Compatibility</title>
+        <para>This function is OpenFormula compatible.</para>
+      </refsect1>
+      <refsect1>
+        <title>See also</title>
+        <para><link linkend="gnumeric-function-SUMPRODUCT"><function>SUMPRODUCT</function></link>,
+        <link linkend="gnumeric-function-SUM"><function>SUM</function></link>,
+        <link linkend="gnumeric-function-PRODUCT"><function>PRODUCT</function></link>,
+        <link linkend="gnumeric-function-G_PRODUCT"><function>G_PRODUCT</function></link>.
+      </para>
+      </refsect1>
+    </refentry>
     <refentry id="gnumeric-function-PI">
       <refmeta>
         <refentrytitle>
@@ -11913,7 +11985,7 @@
           <function>PI</function>
         </refname>
         <refpurpose>
-        the constant Ï
+        the constant ð
       </refpurpose>
       </refnamediv>
       <refsynopsisdiv>
@@ -11921,7 +11993,7 @@
       </refsynopsisdiv>
       <refsect1>
         <title>Microsoft Excel Compatibility</title>
-        <para>This function is Excel compatible, but it returns Ï with a better precision.</para>
+        <para>This function is Excel compatible, but it returns ð with a better precision.</para>
       </refsect1>
       <refsect1>
         <title>See also</title>
@@ -12500,7 +12572,7 @@
           <function>SQRTPI</function>
         </refname>
         <refpurpose>
-        the square root of <parameter>x</parameter> times Ï
+        the square root of <parameter>x</parameter> times ð
       </refpurpose>
       </refnamediv>
       <refsynopsisdiv>
@@ -12655,13 +12727,22 @@
       </refsect1>
       <refsect1>
         <title>Note</title>
-        <para>If an entry is not numeric, the value zero is used instead. If arrays or range arguments do not have the same dimensions, return #VALUE! error. SUMPRODUCTs arguments are arrays or ranges. Attempting to use A1:A5&gt;0 will not work, implicit intersection will kick in. Instead use --(A1:A5&gt;0)</para>
+        <para>If an entry is not numeric, the value zero is used instead. If arrays or range arguments do not have the same dimensions, return #VALUE! error. This function ignores logicals, so using <function>SUMPRODUCT</function>(A1:A5&gt;0) will not work.  Instead use <function>SUMPRODUCT</function>(--(A1:A5&gt;0))</para>
+      </refsect1>
+      <refsect1>
+        <title>Microsoft Excel Compatibility</title>
+        <para>This function is Excel compatible.</para>
+      </refsect1>
+      <refsect1>
+        <title>OpenDocument Format (ODF) Compatibility</title>
+        <para>This function is not OpenFormula compatible. Use ODF.<function>SUMPRODUCT</function> instead.</para>
       </refsect1>
       <refsect1>
         <title>See also</title>
         <para><link linkend="gnumeric-function-SUM"><function>SUM</function></link>,
         <link linkend="gnumeric-function-PRODUCT"><function>PRODUCT</function></link>,
-        <link linkend="gnumeric-function-G_PRODUCT"><function>G_PRODUCT</function></link>.
+        <link linkend="gnumeric-function-G_PRODUCT"><function>G_PRODUCT</function></link>,
+        <link linkend="gnumeric-function-ODF.SUMPRODUCT"><function>ODF.SUMPRODUCT</function></link>.
       </para>
       </refsect1>
     </refentry>
diff --git a/plugins/fn-math/ChangeLog b/plugins/fn-math/ChangeLog
index 2f413e5..c6e49ca 100644
--- a/plugins/fn-math/ChangeLog
+++ b/plugins/fn-math/ChangeLog
@@ -1,3 +1,8 @@
+2011-11-17 Andreas J. Guelzow <aguelzow pyrshep ca>
+
+	* functions.c (help_pi): use mathematical pi rather than greek pi
+	(help_sqrtpi): use mathematical pi rather than greek pi
+
 2011-10-31 Andreas J. Guelzow <aguelzow pyrshep ca>
 
 	* functions.c (help_sumproduct): add compatibility statement
diff --git a/plugins/fn-math/functions.c b/plugins/fn-math/functions.c
index ddbb10e..108541a 100644
--- a/plugins/fn-math/functions.c
+++ b/plugins/fn-math/functions.c
@@ -42,7 +42,7 @@
 #include <math.h>
 #include <string.h>
 
-#define UNICODE_PI "\xcf\x80"
+#define UNICODE_PI "\360\235\234\213"
 #define UNICODE_MINUS "\xe2\x88\x92"
 
 GNM_PLUGIN_MODULE_HEADER;
@@ -1618,9 +1618,9 @@ gnumeric_tanh (GnmFuncEvalInfo *ei, GnmValue const * const *argv)
 /***************************************************************************/
 
 static GnmFuncHelp const help_pi[] = {
-        { GNM_FUNC_HELP_NAME, F_("PI:the constant " "\xcf\x80")},
+        { GNM_FUNC_HELP_NAME, F_("PI:the constant " "\360\235\234\213")},
 	{ GNM_FUNC_HELP_EXCEL, F_("This function is Excel compatible, but it "
-				  "returns " "\xcf\x80" " with a better "
+				  "returns " "\360\235\234\213" " with a better "
 				  "precision.") },
 	{ GNM_FUNC_HELP_EXAMPLES, "=PI()" },
         { GNM_FUNC_HELP_SEEALSO, "SQRTPI"},
@@ -1876,7 +1876,7 @@ gnumeric_sign (GnmFuncEvalInfo *ei, GnmValue const * const *argv)
 
 static GnmFuncHelp const help_sqrtpi[] = {
         { GNM_FUNC_HELP_NAME, F_("SQRTPI:the square root of @{x} times "
-				 "\xcf\x80")},
+				 "\360\235\234\213")},
 	{ GNM_FUNC_HELP_ARG, F_("x:non-negative number")},
 	{ GNM_FUNC_HELP_EXCEL, F_("This function is Excel compatible.") },
 	{ GNM_FUNC_HELP_EXAMPLES, "=SQRTPI(2)"},
[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]