fix the row translation formula (fixes #4)

2 files changed, 22 insertions, 0 deletions

diff --git a/t/bug-4.t b/t/bug-4.t
new file mode 100644
index 0000000..e135d30
--- /dev/null
+++ b/t/bug-4.t
@@ -0,0 +1,22 @@
+#!/usr/bin/env perl
+use strict;
+use warnings;
+use Test::More;
+
+use Spreadsheet::ParseXLSX;
+
+my $parser = Spreadsheet::ParseXLSX->new;
+my $wb = $parser->parse('t/data/bug-4.xlsx');
+my $ws = $wb->worksheet(0);
+
+{
+    my $cell = $ws->get_cell(0, 0);
+    is($cell->value,'Order Number', 'cell check 1');
+}
+
+{
+    my $cell = $ws->get_cell(1, 0);
+    is($cell->value,'364968', 'cell check 2');
+}
+
+done_testing;
diff --git a/t/data/bug-4.xlsx b/t/data/bug-4.xlsx
new file mode 100644
index 0000000..cdd51c5
--- /dev/null
+++ b/t/data/bug-4.xlsx