From 9be18dff1973f9701b9a7fab33d7be48d5bbdf7d Mon Sep 17 00:00:00 2001
From: Jesse Luehrs <doy@tozt.net>
Date: Wed, 9 Oct 2013 10:34:04 -0400
Subject: test for merged cells (#10)

---
 t/bug-10.t         |  99 +++++++++++++++++++++++++++++++++++++++++++++++++++++
 t/data/bug-10.xlsx | Bin 0 -> 9323 bytes
 2 files changed, 99 insertions(+)
 create mode 100644 t/bug-10.t
 create mode 100644 t/data/bug-10.xlsx

(limited to 't')

diff --git a/t/bug-10.t b/t/bug-10.t
new file mode 100644
index 0000000..5dd6737
--- /dev/null
+++ b/t/bug-10.t
@@ -0,0 +1,99 @@
+#!/usr/bin/env perl
+use strict;
+use warnings;
+use Test::More;
+
+use Spreadsheet::ParseXLSX;
+
+my $wb = Spreadsheet::ParseXLSX->new->parse('t/data/bug-10.xlsx');
+is($wb->worksheet_count, 4);
+
+{
+    my @contents = (
+        [ ['Foo01', 0], ['Bar01', 0] ],
+        [ ['Foo02', 0], ['Bar02', 0] ],
+        [ ['Foo03', 0], ['Bar03', 0] ],
+        [ ['Foo04', 0], ['Bar04', 0] ],
+    );
+    my $ws = $wb->worksheet(0);
+    for my $row (0..$#contents) {
+        for my $col (0..$#{ $contents[$row] }) {
+            my $cell = $ws->get_cell($row, $col);
+            is($cell->value, $contents[$row][$col][0]);
+            is(!!$cell->is_merged, !!$contents[$row][$col][1]);
+        }
+    }
+    is($ws->get_merged_areas, undef);
+}
+
+{
+    my @contents = (
+        [ ['Foo01', 0], ['Bar01', 0] ],
+        [ ['Foo02', 0], ['Bar02', 0] ],
+        [ ['Foo03', 0], ['Bar03', 0] ],
+        [ ['Foo04', 1], ['',      1] ],
+    );
+    my $ws = $wb->worksheet(1);
+    for my $row (0..$#contents) {
+        for my $col (0..$#{ $contents[$row] }) {
+            my $cell = $ws->get_cell($row, $col);
+            is($cell->value, $contents[$row][$col][0]);
+            is(!!$cell->is_merged, !!$contents[$row][$col][1]);
+        }
+    }
+    is_deeply(
+        $ws->get_merged_areas,
+        [ [ 3, 0, 3, 1 ] ],
+    );
+}
+
+{
+    my @contents = (
+        [ ['Foo01', 0], ['Bar01', 0] ],
+        [ ['Foo02', 0], ['Bar02', 0] ],
+        [ ['Foo03', 0], ['Bar03', 1] ],
+        [ ['Foo04', 0], ['',      1] ],
+    );
+    my $ws = $wb->worksheet(2);
+    for my $row (0..$#contents) {
+        for my $col (0..$#{ $contents[$row] }) {
+            my $cell = $ws->get_cell($row, $col);
+            is($cell->value, $contents[$row][$col][0]);
+            is(!!$cell->is_merged, !!$contents[$row][$col][1]);
+        }
+    }
+    is_deeply(
+        $ws->get_merged_areas,
+        [ [ 2, 1, 3, 1 ] ],
+    );
+}
+
+{
+    my @contents = (
+        [ ['Foo01', 0], ['Bar01', 0] ],
+        [ ['Foo02', 0], ['Bar02', 0] ],
+        [ ['Foo03', 1], ['',      1] ],
+        [ ['',      1], ['',      1] ],
+        [ ['Foo04', 0], ['Bar04', 1] ],
+        [ ['Foo05', 0], ['',      1] ],
+        [ ['Foo06', 1], ['',      1] ],
+    );
+    my $ws = $wb->worksheet(3);
+    for my $row (0..$#contents) {
+        for my $col (0..$#{ $contents[$row] }) {
+            my $cell = $ws->get_cell($row, $col);
+            is($cell->value, $contents[$row][$col][0]);
+            is(!!$cell->is_merged, !!$contents[$row][$col][1]);
+        }
+    }
+    is_deeply(
+        $ws->get_merged_areas,
+        [
+            [ 2, 0, 3, 1 ],
+            [ 4, 1, 5, 1 ],
+            [ 6, 0, 6, 1 ],
+        ],
+    );
+}
+
+done_testing;
diff --git a/t/data/bug-10.xlsx b/t/data/bug-10.xlsx
new file mode 100644
index 0000000..6e89a8c
Binary files /dev/null and b/t/data/bug-10.xlsx differ
-- 
cgit v1.2.3-54-g00ecf