test/t6504-formula.pl

   1 #!/usr/bin/perl -w
   2 # -----------------------------------------------------------------------------
   3
   4 use strict;
   5 use lib ($0 =~ m|^(.*/)| ? $1 : ".");
   6 use GnumericTest;
   7
   8 my $file = "$samples/formula-tests.gnumeric";
   9
  10 if (&subtest ("gnumeric")) {
  11     &message ("Check formula gnumeric roundtrip.");
  12     &test_roundtrip ($file,
  13                      'format' => 'Gnumeric_XmlIO:sax',
  14                      'ext' => "gnm");
  15 }
  16
  17 if (&subtest ("ods")) {
  18     &message ("Check formula ods roundtrip.");
  19     &test_roundtrip ($file,
  20                      'format' => 'Gnumeric_OpenCalc:odf',
  21                      'ext' => "ods",
  22                      'filter2' => 'std:drop_generator');
  23 }
  24
  25 if (&subtest ("biff7")) {
  26     &message ("Check formula xls/BIFF7 roundtrip.");
  27     &test_roundtrip ($file,
  28                      'format' => 'Gnumeric_Excel:excel_biff7',
  29                      'ext' => "xls",
  30                      'resize' => '16384x256',
  31                      'filter2' => 'std:drop_codepage');
  32 }
  33
  34 if (&subtest ("biff8")) {
  35     &message ("Check formula xls/BIFF8 roundtrip.");
  36     &test_roundtrip ($file,
  37                      'format' => 'Gnumeric_Excel:excel_biff8',
  38                      'ext' => "xls",
  39                      'filter2' => 'std:drop_codepage');
  40 }
  41
  42 if (&subtest ("xlsx")) {
  43     &message ("Check formula xlsx roundtrip.");
  44     &test_roundtrip ($file,
  45                      'format' => 'Gnumeric_Excel:xlsx',
  46                      'ext' => "xlsx",
  47                      'resize' => '1048576x16384');
  48 }