test/t6500-strings.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/string-tests.gnumeric";
   9
  10 if (&subtest ("gnumeric")) {
  11     &message ("Check string gnumeric roundtrip.");
  12     &test_roundtrip ($file,
  13                      'format' => 'Gnumeric_XmlIO:sax',
  14                      'ext' => "gnm");
  15 }
  16
  17 if (&subtest ("ods")) {
  18     &message ("Check string ods roundtrip.");
  19     &test_roundtrip ($file,
  20                      'format' => 'Gnumeric_OpenCalc:odf',
  21                      'ext' => "ods",
  22                      'filter2' => 'std:drop_generator');
  23 }
  24
  25 my $xls_greek_filter = "$PERL -p -C7 -e '1 while (s{\\b(ValueType=\"60\">Greek[ ?]+)[^ ?<]}{\$1?})'";
  26
  27 if (&subtest ("biff7")) {
  28     &message ("Check string xls/BIFF7 roundtrip.");
  29     &test_roundtrip ($file,
  30                      'format' => 'Gnumeric_Excel:excel_biff7',
  31                      'ext' => "xls",
  32                      'resize' => '16384x256',
  33                      'filter1' => $xls_greek_filter,
  34                      'filter2' => 'std:drop_codepage');
  35 }
  36
  37 if (&subtest ("biff8")) {
  38     &message ("Check string xls/BIFF8 roundtrip.");
  39     &test_roundtrip ($file,
  40                      'format' => 'Gnumeric_Excel:excel_biff8',
  41                      'ext' => "xls",
  42                      'filter2' => 'std:drop_codepage');
  43 }
  44
  45 if (&subtest ("xlsx")) {
  46     &message ("Check string xlsx roundtrip.");
  47     &test_roundtrip ($file,
  48                      'format' => 'Gnumeric_Excel:xlsx',
  49                      'ext' => "xlsx",
  50                      'resize' => '1048576x16384');
  51 }