[gnumeric] Tests: test sheet formatting

[Morten Welinder <mortenw src gnome org>]

commit 7508f57bb69258e9442235e9cda4d59d91033e39
Author: Morten Welinder <terra gnome org>
Date:   Wed Feb 26 11:59:15 2014 -0500

    Tests: test sheet formatting
    
    Hidden zeros, Hidden headers, no grid, left-to-right.

 samples/sheet-formatting-tests.gnumeric |  Bin 0 -> 2072 bytes
 test/Makefile.am                        |    1 +
 test/t6508-sheet-formatting.pl          |   41 +++++++++++++++++++++++++++++++
 3 files changed, 42 insertions(+), 0 deletions(-)
---
diff --git a/samples/sheet-formatting-tests.gnumeric b/samples/sheet-formatting-tests.gnumeric
new file mode 100644
index 0000000..81547a7
Binary files /dev/null and b/samples/sheet-formatting-tests.gnumeric differ
diff --git a/test/Makefile.am b/test/Makefile.am
index 82640c8..be74d1d 100644
--- a/test/Makefile.am
+++ b/test/Makefile.am
@@ -79,6 +79,7 @@ TESTS =       t1000-statfuns.pl                       \
        t6505-colrow.pl                         \
        t6506-cell-comments.pl                  \
        t6507-split-panes.pl                    \
+       t6508-sheet-formatting.pl               \
        t7000-goal-seek.pl                      \
        t7100-solver-blend.pl                   \
        t7101-solver-afiro.pl                   \
diff --git a/test/t6508-sheet-formatting.pl b/test/t6508-sheet-formatting.pl
new file mode 100755
index 0000000..a9426fc
--- /dev/null
+++ b/test/t6508-sheet-formatting.pl
@@ -0,0 +1,41 @@
+#!/usr/bin/perl -w
+# -----------------------------------------------------------------------------
+
+use strict;
+use lib ($0 =~ m|^(.*/)| ? $1 : ".");
+use GnumericTest;
+
+my $file = "$samples/sheet-formatting-tests.gnumeric";
+
+&message ("Check sheet-formatting gnumeric roundtrip.");
+&test_roundtrip ($file,
+                'format' => 'Gnumeric_XmlIO:sax',
+                'ext' => "gnm");
+
+&message ("Check sheet-formatting ods roundtrip.");
+&test_roundtrip ($file,
+                'format' => 'Gnumeric_OpenCalc:odf',
+                'ext' => "ods",
+                'filter2' => "$PERL -p -e '\$_ = \"\" if m{<meta:generator>}'",
+                'ignore_failure' => 1);
+
+my $xls_codepage_filter = "$PERL -p -e '\$_ = \"\" if m{<meta:user-defined meta:name=.msole:codepage.}'";
+
+&message ("Check sheet-formatting xls/BIFF7 roundtrip.");
+&test_roundtrip ($file,
+                'format' => 'Gnumeric_Excel:excel_biff7',
+                'ext' => "xls",
+                'resize' => '16384x256',
+                'filter2' => $xls_codepage_filter);
+
+&message ("Check sheet-formatting xls/BIFF8 roundtrip.");
+&test_roundtrip ($file,
+                'format' => 'Gnumeric_Excel:excel_biff8',
+                'ext' => "xls",
+                'filter2' => $xls_codepage_filter);
+
+&message ("Check sheet-formatting xlsx roundtrip.");
+&test_roundtrip ($file,
+                'format' => 'Gnumeric_Excel:xlsx',
+                'ext' => "xlsx",
+                'resize' => '1048576x16384');