summaryrefslogtreecommitdiffstats
path: root/t/bug-6.t
diff options
context:
space:
mode:
Diffstat (limited to 't/bug-6.t')
-rw-r--r--t/bug-6.t30
1 files changed, 30 insertions, 0 deletions
diff --git a/t/bug-6.t b/t/bug-6.t
index 503d6fa..41e6fc0 100644
--- a/t/bug-6.t
+++ b/t/bug-6.t
@@ -8,4 +8,34 @@ use Spreadsheet::ParseXLSX;
my $wb = Spreadsheet::ParseXLSX->new->parse('t/data/bug-6.xlsx');
is($wb->worksheet_count, 8);
+my %cells = (
+ 7 => {
+ 0 => 'mfg fdproc',
+ 1 => 'Tom Forsythe',
+ },
+ 8 => {
+ 0 => 'ent bartend-402 data max prodigy max 203 dpi',
+ 1 => 'Dave Levos ; Tommy Holland',
+ },
+ 9 => {
+ 0 => 'ent bartend-402 inter px4i 400 dpi rw',
+ 1 => 'Tommy Holland; Dave Levos',
+ },
+ 10 => {
+ 0 => 'opr-mfg asmb inst ro',
+ 1 => 'Chris McGee',
+ },
+);
+
+my $ws = $wb->worksheet('DSGroups');
+my ($row_min, $row_max) = $ws->row_range;
+my ($col_min, $col_max) = $ws->col_range;
+for my $row (sort { $a <=> $b } keys %cells) {
+ for my $col (sort { $a <=> $b } keys %{ $cells{$row} }) {
+ my $cell = $ws->get_cell($row, $col);
+ next unless $cell;
+ is($cell->value, $cells{$row}{$col}, "correct value for ($row, $col)");
+ }
+}
+
done_testing;