[gnumeric] add note to sumif



commit fb98b5c26829cf6e7f83801c3cf763a25728f412
Author: Andreas J Guelzow <aguelzow pyrshep ca>
Date:   Wed Jun 8 10:16:40 2011 -0600

    add note to sumif
    
    2011-06-08 Andreas J. Guelzow <aguelzow pyrshep ca>
    
    	* functions.c (help_sumif): add note
    
    2011-06-08  Andreas J. Guelzow <aguelzow pyrshep ca>
    
    	* developer/odf-foreign.txt: update

 doc/ChangeLog                 |    4 +++
 doc/developer/odf-foreign.txt |   44 ++++++++++++++++++++++++++++------------
 plugins/fn-math/ChangeLog     |    4 +++
 plugins/fn-math/functions.c   |    5 ++++
 4 files changed, 44 insertions(+), 13 deletions(-)
---
diff --git a/doc/ChangeLog b/doc/ChangeLog
index 15b2b53..7658d40 100644
--- a/doc/ChangeLog
+++ b/doc/ChangeLog
@@ -1,3 +1,7 @@
+2011-06-08  Andreas J. Guelzow <aguelzow pyrshep ca>
+
+	* developer/odf-foreign.txt: update
+
 2011-05-21  Morten Welinder <terra gnome org>
 
 	* Release 1.10.15
diff --git a/doc/developer/odf-foreign.txt b/doc/developer/odf-foreign.txt
index 97958f7..372b51f 100644
--- a/doc/developer/odf-foreign.txt
+++ b/doc/developer/odf-foreign.txt
@@ -1,5 +1,36 @@
 Due to the limitations of the ODF file format we occasionally add foreign elements and attributes to those files. This text documents those elements and attributes.
 
+Note: Any reference to ODF 1.3 refers tot eh current work-in-progress in the OASIS ODF TC. 
+
+Part 1: In ODF 1.0 and 1.1 files only.
+
+1) Attributes added by Gnumeric:
+
+gnm:reverse-direction
+gnm:automatic-content
+gnm:display-equation
+gnm:display-r-square
+used instead of the ODF1.2 attribute chart:...
+
+Part 2: In ODF 1.0, 1.1 and ODF 1.2 files only.
+
+1) Elements and attributes added by goffice:
+
+gnm:engineering   
+An attribute to <number:scientific-number>. A value of "true" indicates that the exponent will always be a multiple of 3.
+(In ODF 1.3 to be replaced by number:exponent-base=1 ("false") or =3 ("true") resp.)
+
+2) Attribute _values_ added by Gnumeric. 
+Since these are not eleemnts or new attributes they are used in all ODF exports.
+
+gnm:step-start          in ODF1.3: step-end
+gnm:step-end		in ODF1.3: step-start
+gnm:step-center-x	in ODF1.3: step-center-x
+gnm:step-center-y	in ODF1.3: step-center-y
+various attribute values specifying chart:interpolation types
+
+Part 3: In any ODF files:
+
 1) Elements and attributes added by goffice:
 
 gnm:format-magic
@@ -14,9 +45,6 @@ An attribute to <number:fraction> giving the maximum number of denominator digit
 gnm:no-integer-part
 An attribute to <number:fraction> determining whether an integer portion is shown or not. Defaults to "false" (i.e. an integer part is shown.)
 
-gnm:engineering
-An attribute to <number:scientific-number>. A value of "true" indicates that the exponent will always be a multiple of 3.
-
 
 2) Elements and attributes added by Gnumeric:
 
@@ -70,12 +98,6 @@ plot property
 gnm:show-negatives
 property of bubble plots
 
-gnm:reverse-direction
-gnm:automatic-content
-gnm:display-equation
-gnm:display-r-square
-used instead of the ODF1.2 attribute chart:...
-
 gnm:regression-affine
 whether a given regression is affine or not
 
@@ -98,10 +120,6 @@ gnm:closed-spline
 gnm:parabolic-cspline
 gnm:cubic-cspline
 gnm:clamped-cspline
-gnm:step-start
-gnm:step-end
-gnm:step-center-x
-gnm:step-center-y
 various attribute values specifying chart:interpolation types
 
 gnm:polynomial
diff --git a/plugins/fn-math/ChangeLog b/plugins/fn-math/ChangeLog
index c5a91f7..fd03bdb 100644
--- a/plugins/fn-math/ChangeLog
+++ b/plugins/fn-math/ChangeLog
@@ -1,3 +1,7 @@
+2011-06-08 Andreas J. Guelzow <aguelzow pyrshep ca>
+
+	* functions.c (help_sumif): add note
+
 2011-05-21  Morten Welinder <terra gnome org>
 
 	* Release 1.10.15
diff --git a/plugins/fn-math/functions.c b/plugins/fn-math/functions.c
index 702eb14..14fe637 100644
--- a/plugins/fn-math/functions.c
+++ b/plugins/fn-math/functions.c
@@ -549,6 +549,11 @@ static GnmFuncHelp const help_sumif[] = {
         { GNM_FUNC_HELP_ARG, F_("range:cell area")},
         { GNM_FUNC_HELP_ARG, F_("criteria:condition for a cell to be summed")},
         { GNM_FUNC_HELP_ARG, F_("actual_range:cell area, defaults to @{range}")},
+	{ GNM_FUNC_HELP_NOTE, F_("If the @{actual_range} has a size that "
+				 "differs"
+				 " from the size of @{range}, @{actual_range} "
+				 "is resized (retaining the top-left corner)"
+				 " to match the size of @{range}.")},
 	{ GNM_FUNC_HELP_EXCEL, F_("This function is Excel compatible.") },
         { GNM_FUNC_HELP_SEEALSO, "SUM,COUNTIF"},
         { GNM_FUNC_HELP_END}



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]