[gnumeric] Export autofilter conditions to ECMA 367 (xlsx). [part of 725460]

[Andreas J. Guelzow <guelzow src gnome org>]

commit 0285c8e944cf8efd193fe4c3604b77dba31cd68b
Author: Andreas J. Guelzow <aguelzow pyrshep ca>
Date:   Sun Mar 2 20:34:25 2014 -0700

    Export autofilter conditions to ECMA 367 (xlsx). [part of 725460]
    
    2014-03-02  Andreas J. Guelzow <aguelzow pyrshep ca>
    
        * xlsx-write.c (xlsx_write_customfilter): new
        (xlsx_write_autofilters): write filter info

 NEWS                         |    2 +-
 plugins/excel/ChangeLog      |    4 ++++
 plugins/excel/xlsx-write.c   |    7 +++++--
 plugins/openoffice/ChangeLog |    2 +-
 4 files changed, 11 insertions(+), 4 deletions(-)
---
diff --git a/NEWS b/NEWS
index 0423b3b..2918480 100644
--- a/NEWS
+++ b/NEWS
@@ -13,7 +13,7 @@ Andreas:
        * Export frozen panes info to and import from ODF. [#725228]
        * Export and import more sheet properties to/from ODF. [#725258]
        * Fix validation import from ODF. [#725321]
-       * Fix autofilter condition export to ODF. [part of #725458]
+       * Fix autofilter condition export to ODF. [#725458]
 
 Jean:
        * Fix persistence of hyperlinks tips. [see #724108]
diff --git a/plugins/excel/ChangeLog b/plugins/excel/ChangeLog
index add6c0c..c3be039 100644
--- a/plugins/excel/ChangeLog
+++ b/plugins/excel/ChangeLog
@@ -1,3 +1,7 @@
+2014-03-02  Andreas J. Guelzow <aguelzow pyrshep ca>
+
+       * xlsx-write.c (xlsx_write_autofilters): write blank filter info
+
 2014-03-01  Morten Welinder  <terra gnome org>
 
        * xlsx-write.c (xlsx_write_autofilters): First stab at writing
diff --git a/plugins/excel/xlsx-write.c b/plugins/excel/xlsx-write.c
index f2c8292..5b8e6cd 100644
--- a/plugins/excel/xlsx-write.c
+++ b/plugins/excel/xlsx-write.c
@@ -1748,8 +1748,11 @@ xlsx_write_autofilters (XLSXWriteState *state, GsfXMLOut *xml)
                        break;
                }
 
-               case GNM_FILTER_OP_BLANKS:
-               case GNM_FILTER_OP_NON_BLANKS:
+               case GNM_FILTER_OP_BLANKS :
+               case GNM_FILTER_OP_NON_BLANKS :
+                       gsf_xml_out_start_element (xml, "filters");
+                       xlsx_add_bool (xml, "blanks", cond->op[0] == GNM_FILTER_OP_BLANKS);
+                       gsf_xml_out_end_element (xml); /* </filters> */
                        break;
 
                case GNM_FILTER_OP_TOP_N:
diff --git a/plugins/openoffice/ChangeLog b/plugins/openoffice/ChangeLog
index 3a872b0..43fb7bf 100644
--- a/plugins/openoffice/ChangeLog
+++ b/plugins/openoffice/ChangeLog
@@ -14,7 +14,7 @@
 2014-03-01  Andreas J. Guelzow <aguelzow pyrshep ca>
 
        * openoffice-read.c (odf_validation_new_single_expr): only force
-       explicit sheet namees if the base address is on a different sheet
+       explicit sheet names if the base address is on a different sheet
        (odf_validation_new_pair_expr): ditto
        (odf_validations_analyze): also strip parentheses