From 58e422a18e68ed948a791ffba824fd67689d02df Mon Sep 17 00:00:00 2001 From: Jesse Luehrs Date: Wed, 29 Jan 2014 15:01:05 -0500 Subject: support locked and hidden cells (#15) --- t/bug-15.t | 25 +++++++++++++++++++++++++ t/data/bug-15.xlsx | Bin 0 -> 13602 bytes 2 files changed, 25 insertions(+) create mode 100644 t/bug-15.t create mode 100644 t/data/bug-15.xlsx (limited to 't') diff --git a/t/bug-15.t b/t/bug-15.t new file mode 100644 index 0000000..5ec62b2 --- /dev/null +++ b/t/bug-15.t @@ -0,0 +1,25 @@ +#!/usr/bin/env perl +use strict; +use warnings; +use Test::More; + +use Spreadsheet::ParseXLSX; + +my $wb = Spreadsheet::ParseXLSX->new->parse('t/data/bug-15.xlsx'); +my $ws = $wb->worksheet(1); + +my $b2 = $ws->get_cell(1, 1); +ok(exists $b2->get_format->{Hidden}); +ok(exists $b2->get_format->{Lock}); +ok(!$b2->get_format->{IgnoreProtection}); +ok(!$b2->get_format->{Hidden}); +ok(!$b2->get_format->{Lock}); + +my $b4 = $ws->get_cell(3, 1); +ok(exists $b4->get_format->{Hidden}); +ok(exists $b4->get_format->{Lock}); +ok(!$b4->get_format->{IgnoreProtection}); +ok($b4->get_format->{Hidden}); +ok(!$b4->get_format->{Lock}); + +done_testing; diff --git a/t/data/bug-15.xlsx b/t/data/bug-15.xlsx new file mode 100644 index 0000000..d31d1dd Binary files /dev/null and b/t/data/bug-15.xlsx differ -- cgit v1.2.3-54-g00ecf