[gnumeric] CELL: a bit of investigation into what "color" is supposed to do.



commit d1519d3ea3c5463f258e563c06baa2f9bf2cc69b
Author: Morten Welinder <terra gnome org>
Date:   Thu May 3 16:07:38 2018 -0400

    CELL: a bit of investigation into what "color" is supposed to do.

 plugins/fn-info/functions.c |    6 ++++++
 1 files changed, 6 insertions(+), 0 deletions(-)
---
diff --git a/plugins/fn-info/functions.c b/plugins/fn-info/functions.c
index e01175c..3ab6f7c 100644
--- a/plugins/fn-info/functions.c
+++ b/plugins/fn-info/functions.c
@@ -229,6 +229,12 @@ gnumeric_cell (GnmFuncEvalInfo *ei, GnmValue const * const *argv)
         * in the number format, e.g., 1 for format "[Black]0;-0;0" but not
         * for format "0;-0;[Green]0"
         * Another place where Excel doesn't conform to its documentation!
+        *
+        * 20180503: and even the above isn't right.  What appears to be test
+        * is this:
+        * (a) The format must be conditional; "[Red]0" won't do
+        * (b) One of the first two conditional formats must have a color
+        *     specified.
         */
        } else if (!g_ascii_strcasecmp (info_type, "color")) {
                /* See 1.7.6 for old version.  */


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