test/t6506-cell-comments.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/cell-comment-tests.gnumeric";
   9
  10 if (&subtest ("gnumeric")) {
  11     &message ("Check cell-comment gnumeric roundtrip.");
  12     &test_roundtrip ($file,
  13                      'format' => 'Gnumeric_XmlIO:sax',
  14                      'ext' => "gnm");
  15 }
  16
  17 if (&subtest ("ods")) {
  18     &message ("Check cell-comment 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(Text=\"Greek[ ?]+)[^ ?\"]}{\$1?})'";
  26
  27 if (&subtest ("biff7")) {
  28     &message ("Check cell-comment xls/BIFF7 roundtrip.");
  29     &test_roundtrip ($file,
  30                      'format' => 'Gnumeric_Excel:excel_biff7',
  31                      'ext' => "xls",
  32                      'resize' => '16384x256',
  33                      'filter1' => "$xls_greek_filter | std:no_author",
  34                      'filter2' => 'std:drop_codepage');
  35 }
  36
  37 if (&subtest ("biff8")) {
  38     &message ("Check cell-comment 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 cell-comment xlsx roundtrip.");
  47     &test_roundtrip ($file,
  48                      'format' => 'Gnumeric_Excel:xlsx',
  49                      'ext' => "xlsx",
  50                      'resize' => '1048576x16384');
  51 }