| line |
true |
false |
branch |
|
227
|
8 |
1324 |
if ($self->{'_optimization'} == 1) |
|
241
|
8 |
1324 |
if ($self->{'_excel2003_style'}) |
|
270
|
8 |
948 |
if ($self->{'_optimization'} == 1) |
|
309
|
985 |
8 |
if ($self->{'_optimization'} == 0) { } |
|
323
|
8 |
985 |
if ($self->{'_excel2003_style'}) |
|
494
|
6 |
21 |
if ($password ne '') |
|
523
|
60 |
0 |
if (exists $defaults{$key}) { } |
|
590
|
188 |
1 |
if ($cell =~ /^\D/) |
|
598
|
0 |
189 |
if @data < 3 |
|
599
|
0 |
189 |
unless defined $data[0] |
|
600
|
0 |
189 |
unless defined $data[1] |
|
603
|
32 |
157 |
if $data[1] == 0 |
|
606
|
0 |
189 |
if $data[0] > $data[1] |
|
614
|
18 |
171 |
if ref $data[3] |
|
615
|
3 |
162 |
if $data[2] and $data[4] |
|
617
|
0 |
189 |
if $self->_check_dimensions(0, $data[0], $ignore_row, $ignore_col) |
|
619
|
0 |
189 |
if $self->_check_dimensions(0, $data[1], $ignore_row, $ignore_col) |
|
623
|
188 |
1 |
unless defined $data[5] |
|
624
|
0 |
189 |
if $data[5] < 0 |
|
625
|
0 |
189 |
if $data[5] > 7 |
|
627
|
1 |
188 |
if ($data[5] > $self->{'_outline_col_level'}) |
|
643
|
24 |
165 |
unless defined $width |
|
649
|
18 |
352 |
if $format |
|
667
|
0 |
36 |
unless @_ |
|
670
|
33 |
3 |
if ($_[0] =~ /^\D/) |
|
676
|
28 |
8 |
if (@_ == 2) { } |
|
|
8 |
0 |
elsif (@_ == 4) { } |
|
690
|
3 |
5 |
if ($row_first > $row_last) |
|
694
|
3 |
5 |
if ($col_first > $col_last) |
|
699
|
1 |
7 |
if ($row_first == $row_last and $col_first == $col_last) { } |
|
714
|
4 |
32 |
if $sqref eq 'A1' |
|
730
|
0 |
66 |
unless @_ |
|
733
|
10 |
56 |
if ($_[0] =~ /^\D/) |
|
813
|
0 |
2 |
defined $_[0] ? : |
|
843
|
19 |
0 |
if ($paper_size) |
|
867
|
0 |
31 |
if (length $string >= 255) |
|
872
|
1 |
30 |
if (defined $options->{'align_with_margins'}) |
|
876
|
1 |
30 |
if (defined $options->{'scale_with_doc'}) |
|
883
|
21 |
10 |
if ($options->{'image_left'}) |
|
887
|
6 |
25 |
if ($options->{'image_center'}) |
|
891
|
5 |
26 |
if ($options->{'image_right'}) |
|
898
|
0 |
31 |
if ($image_count != $placeholder_count) |
|
905
|
21 |
10 |
if ($image_count) |
|
932
|
0 |
15 |
if (length $string >= 255) |
|
937
|
1 |
14 |
if (defined $options->{'align_with_margins'}) |
|
941
|
1 |
14 |
if (defined $options->{'scale_with_doc'}) |
|
948
|
4 |
11 |
if ($options->{'image_left'}) |
|
952
|
3 |
12 |
if ($options->{'image_center'}) |
|
956
|
5 |
10 |
if ($options->{'image_right'}) |
|
963
|
0 |
15 |
if ($image_count != $placeholder_count) |
|
970
|
6 |
9 |
if ($image_count) |
|
1070
|
5 |
0 |
if (defined $margin) { } |
|
1090
|
5 |
0 |
if (defined $margin) { } |
|
1110
|
5 |
0 |
if (defined $margin) { } |
|
1131
|
5 |
0 |
if (defined $margin) { } |
|
1178
|
3 |
0 |
if ($_[0] =~ /^\D/) |
|
1215
|
9 |
0 |
if ($_[0] =~ /^\D/) |
|
1219
|
0 |
9 |
if @_ != 4 |
|
1224
|
1 |
8 |
if ($row1 == 0 and $col1 == 0 and $row2 == $self->{'_xls_rowmax'} - 1 and $col2 == $self->{'_xls_colmax'} - 1) |
|
1250
|
30 |
2 |
if ($_[0] =~ /^\D/) |
|
1254
|
0 |
32 |
if @_ != 4 |
|
1259
|
0 |
32 |
if $row2 < $row1 |
|
1260
|
0 |
32 |
if $col2 < $col1 |
|
1285
|
0 |
25 |
unless $self->{'_autofilter'} |
|
1286
|
0 |
25 |
unless @_ == 2 |
|
1291
|
24 |
1 |
if ($col =~ /^\D/) |
|
1297
|
0 |
24 |
if $col >= $self->{'_xls_colmax'} |
|
1303
|
0 |
25 |
if ($col < $col_first or $col > $col_last) |
|
1311
|
0 |
25 |
unless @tokens == 3 or @tokens == 7 |
|
1319
|
6 |
19 |
if (@tokens == 2 and $tokens[0] == 2) { } |
|
|
3 |
16 |
elsif (@tokens == 5 and $tokens[0] == 2 and $tokens[2] == 1 and $tokens[3] == 2) { } |
|
1358
|
0 |
14 |
unless $self->{'_autofilter'} |
|
1359
|
0 |
14 |
unless @tokens |
|
1363
|
5 |
9 |
if ($col =~ /^\D/) |
|
1369
|
0 |
5 |
if $col >= $self->{'_xls_colmax'} |
|
1375
|
0 |
14 |
if ($col < $col_first or $col > $col_last) |
|
1405
|
2 |
65 |
unless $expression |
|
1440
|
10 |
39 |
if (@tokens == 7) { } |
|
1444
|
5 |
5 |
if ($conditional =~ /^(and|&&)$/) { } |
|
|
5 |
0 |
elsif ($conditional =~ /^(or|\|\|)$/) { } |
|
1502
|
4 |
55 |
if ($tokens[0] =~ /^top|bottom$/i) |
|
1506
|
0 |
4 |
if ($value =~ /\D/ or $value < 1 or $value > 500) |
|
1516
|
0 |
4 |
if ($token ne 'items' and $token ne '%') |
|
1521
|
2 |
2 |
if ($tokens[0] =~ /^top$/i) { } |
|
1528
|
2 |
2 |
if ($tokens[2] eq '%') |
|
1536
|
0 |
0 |
if (not $operator and $tokens[0]) |
|
1543
|
7 |
52 |
if ($token =~ /^blanks|nonblanks$/i) |
|
1546
|
0 |
7 |
if ($operator != 2 and $operator != 5) |
|
1555
|
4 |
3 |
if ($token eq 'blanks') { } |
|
1556
|
1 |
3 |
if ($operator == 5) |
|
1561
|
1 |
2 |
if ($operator == 5) { } |
|
1575
|
3 |
56 |
if ($operator == 2 and $token =~ /[*?]/) |
|
1612
|
1 |
39 |
if ($row_num_1 == 0 and $row_num_2 == $self->{'_xls_rowmax'} - 1) { } |
|
|
1 |
38 |
elsif ($col_num_1 == 0 and $col_num_2 == $self->{'_xls_colmax'} - 1) { } |
|
1628
|
1 |
39 |
if ($range1 eq $range2 and not $row_col_only) { } |
|
1655
|
9 |
3 |
defined $_[0] ? : |
|
1658
|
5 |
7 |
if ($option == 0) { } |
|
|
4 |
3 |
elsif ($option == 1) { } |
|
1684
|
0 |
2 |
defined $_[0] ? : |
|
1686
|
2 |
0 |
if ($headers) { } |
|
1721
|
5 |
1 |
defined $_[0] ? : |
|
1722
|
4 |
2 |
defined $_[1] ? : |
|
1767
|
0 |
3 |
if ($scale < 10 or $scale > 400) |
|
1788
|
0 |
3 |
if ($scale < 10 or $scale > 400) |
|
1826
|
0 |
0 |
if (defined $_[0]) { } |
|
1845
|
0 |
2 |
defined $_[0] ? : |
|
1859
|
39 |
0 |
if defined $_[0] |
|
1873
|
0 |
1 |
defined $_[0] ? : |
|
1887
|
0 |
1 |
defined $_[0] ? : |
|
1900
|
0 |
2 |
defined $_[0] ? : |
|
1902
|
2 |
0 |
if ($page_order) { } |
|
1921
|
0 |
3 |
unless defined $_[0] |
|
1941
|
0 |
0 |
if $row > $self->{'_xls_rowmax'} |
|
1942
|
0 |
0 |
if $col > $self->{'_xls_colmax'} |
|
1959
|
0 |
0 |
unless @_ == 2 |
|
1960
|
0 |
0 |
unless ref $_[1] eq 'CODE' |
|
1980
|
1054 |
9344 |
if ($_[0] =~ /^\D/) |
|
1987
|
20 |
10378 |
unless defined $token |
|
1995
|
0 |
0 |
if ($token =~ /$re/) |
|
1997
|
0 |
0 |
if defined $match |
|
2003
|
1012 |
9386 |
if (ref $token eq 'ARRAY') { } |
|
|
0 |
9386 |
elsif ($self->{'_leading_zeros'} and $token =~ /^0\d+$/) { } |
|
|
7196 |
2190 |
elsif ($token =~ /^([+-]?)(?=[0-9]|\.[0-9])[0-9]*(\.[0-9]*)?([Ee]([+-]?[0-9]+))?$/) { } |
|
|
14 |
2176 |
elsif ($token =~ m[^[fh]tt?ps?://]) { } |
|
|
0 |
2176 |
elsif ($token =~ /^mailto:/) { } |
|
|
0 |
2176 |
elsif ($token =~ /^(?:in|ex)ternal:/) { } |
|
|
21 |
2155 |
elsif ($token =~ /^=/) { } |
|
|
2 |
2153 |
elsif ($token =~ /^{=.*}$/) { } |
|
|
29 |
2124 |
elsif ($token eq '') { } |
|
2071
|
7 |
1012 |
if ($_[0] =~ /^\D/) |
|
2076
|
0 |
1019 |
if (ref $_[2] ne 'ARRAY') |
|
2090
|
1091 |
2778 |
if (ref $token eq 'ARRAY') { } |
|
2122
|
19 |
1093 |
if ($_[0] =~ /^\D/) |
|
2127
|
0 |
1112 |
if (ref $_[2] ne 'ARRAY') |
|
2167
|
57 |
4096 |
if ($_[0] =~ /^\D/) |
|
2171
|
0 |
4153 |
if (@_ < 3) |
|
2177
|
0 |
4153 |
unless @_ % 2 |
|
2180
|
0 |
4153 |
if $self->_check_dimensions($row, $col) |
|
2207
|
0 |
7207 |
if ($_[0] =~ /^\D/) |
|
2211
|
0 |
7207 |
if (@_ < 3) |
|
2221
|
0 |
7207 |
if $self->_check_dimensions($row, $col) |
|
2224
|
2 |
7205 |
if ($self->{'_optimization'} == 1 and $row > $self->{'_previous_row'}) |
|
2251
|
45 |
2940 |
if ($_[0] =~ /^\D/) |
|
2255
|
0 |
2985 |
if (@_ < 3) |
|
2266
|
0 |
2985 |
unless defined $str |
|
2269
|
1 |
2984 |
if $self->_check_dimensions($row, $col) |
|
2272
|
0 |
2984 |
if (length $str > $self->{'_xls_strmax'}) |
|
2278
|
2694 |
290 |
if ($self->{'_optimization'} == 0) { } |
|
2286
|
278 |
2706 |
if ($self->{'_optimization'} == 1 and $row > $self->{'_previous_row'}) |
|
2315
|
28 |
1 |
if ($_[0] =~ /^\D/) |
|
2319
|
0 |
29 |
if (@_ < 3) |
|
2331
|
0 |
29 |
if $self->_check_dimensions($row, $col) |
|
2335
|
3 |
26 |
if (ref $_[-1]) |
|
2342
|
0 |
29 |
unless open my $str_fh, '>', \$str |
|
2360
|
81 |
33 |
if (not ref $token) { } |
|
2363
|
25 |
56 |
if ($last ne 'format') { } |
|
2380
|
1 |
32 |
if ($last eq 'format' and $pos > 0) |
|
2394
|
24 |
4 |
unless (ref $fragments[0]) |
|
2400
|
56 |
80 |
if (ref $token) { } |
|
2411
|
10 |
70 |
if ($token =~ /^\s/ or $token =~ /\s$/) |
|
2421
|
0 |
28 |
if ($length > $self->{'_xls_strmax'}) |
|
2427
|
20 |
8 |
if ($self->{'_optimization'} == 0) { } |
|
2435
|
8 |
20 |
if ($self->{'_optimization'} == 1 and $row > $self->{'_previous_row'}) |
|
2466
|
0 |
85 |
if ($_[0] =~ /^\D/) |
|
2471
|
0 |
85 |
if @_ < 2 |
|
2474
|
24 |
61 |
unless defined $_[2] |
|
2482
|
0 |
61 |
if $self->_check_dimensions($row, $col) |
|
2485
|
0 |
61 |
if ($self->{'_optimization'} == 1 and $row > $self->{'_previous_row'}) |
|
2512
|
21 |
93 |
if ($_[0] =~ /^\D/) |
|
2516
|
0 |
114 |
if (@_ < 3) |
|
2526
|
3 |
111 |
if ($formula =~ /^{=.*}$/) |
|
2532
|
0 |
111 |
if $self->_check_dimensions($row, $col) |
|
2538
|
0 |
111 |
if ($self->{'_optimization'} == 1 and $row > $self->{'_previous_row'}) |
|
2565
|
4 |
3 |
if ($_[0] =~ /^\D/) |
|
2569
|
0 |
7 |
if (@_ < 5) |
|
2581
|
0 |
7 |
if $row1 > $row2 |
|
2582
|
0 |
7 |
if $col1 > $col2 |
|
2586
|
0 |
7 |
if $self->_check_dimensions($row2, $col2) |
|
2592
|
4 |
3 |
if ($row1 == $row2 and $col1 == $col2) { } |
|
2608
|
0 |
7 |
if ($self->{'_optimization'} == 1 and $row > $self->{'_previous_row'}) |
|
2617
|
7 |
0 |
unless ($self->{'_optimization'}) |
|
2620
|
7 |
6 |
if $row == $row1 and $col == $col1 |
|
2644
|
4 |
0 |
if ($_[0] =~ /^\D/) |
|
2650
|
2 |
2 |
$_[2] ? : |
|
2655
|
0 |
4 |
if $self->_check_dimensions($row, $col) |
|
2658
|
0 |
4 |
if ($self->{'_optimization'} == 1 and $row > $self->{'_previous_row'}) |
|
2679
|
1 |
0 |
defined $_[0] ? : |
|
2680
|
1 |
0 |
defined $_[1] ? : |
|
2681
|
1 |
0 |
defined $_[2] ? : |
|
2697
|
1 |
97 |
if $url =~ /%[0-9a-fA-F]{2}/ |
|
2737
|
68 |
15 |
if ($_[0] =~ /^\D/) |
|
2741
|
0 |
83 |
if (@_ < 3) |
|
2748
|
13 |
70 |
if (defined $args[3] and not ref $args[3]) |
|
2763
|
69 |
14 |
unless defined $str |
|
2766
|
8 |
75 |
if ($url =~ s/^internal://) |
|
2773
|
15 |
68 |
if ($url =~ s/^external://) |
|
2784
|
0 |
83 |
if $self->_check_dimensions($row, $col) |
|
2788
|
0 |
83 |
if (length $str > $self->{'_xls_strmax'}) |
|
2798
|
75 |
8 |
if ($link_type == 1) |
|
2806
|
4 |
71 |
if ($url_str and not $external) |
|
2812
|
9 |
66 |
if ($url =~ /^\w:/ or $url =~ /^\\\\/) |
|
2824
|
1 |
82 |
if (length $url > $max_url or length $tmp_url_str > $max_url) |
|
2834
|
0 |
82 |
if ($self->{'_hlink_count'} > 65530) |
|
2842
|
0 |
82 |
if ($self->{'_optimization'} == 1 and $row > $self->{'_previous_row'}) |
|
2847
|
65 |
17 |
unless (defined $xf) |
|
2883
|
12 |
117 |
if ($_[0] =~ /^\D/) |
|
2887
|
0 |
129 |
if (@_ < 3) |
|
2897
|
0 |
129 |
if $self->_check_dimensions($row, $col) |
|
2903
|
0 |
129 |
unless (defined $date_time) |
|
2908
|
0 |
129 |
if ($self->{'_optimization'} == 1 and $row > $self->{'_previous_row'}) |
|
2956
|
1 |
767 |
if $date_time =~ /[^0-9T:\-\.Z]/ |
|
2959
|
2 |
765 |
unless $date_time =~ /\dT|T\d/ |
|
2970
|
206 |
559 |
if ($time ne '') |
|
2973
|
206 |
0 |
if ($time =~ /^(\d\d):(\d\d)(:(\d\d(\.\d+)?))?/) { } |
|
2983
|
1 |
205 |
if $hour >= 24 |
|
2984
|
1 |
204 |
if $min >= 60 |
|
2985
|
2 |
202 |
if $sec >= 60 |
|
2993
|
2 |
759 |
if $date eq '' |
|
2997
|
757 |
2 |
if ($date =~ /^(\d\d\d\d)-(\d\d)-(\d\d)$/) { } |
|
3011
|
542 |
215 |
unless ($date_1904) |
|
3012
|
104 |
438 |
if $date eq '1899-12-31' |
|
3013
|
1 |
437 |
if $date eq '1900-01-00' |
|
3014
|
1 |
436 |
if $date eq '1900-02-29' |
|
3023
|
215 |
436 |
$date_1904 ? : |
|
3024
|
215 |
436 |
$date_1904 ? : |
|
3032
|
213 |
438 |
if $year % 4 == 0 and $year % 100 or $year % 400 == 0 |
|
3033
|
213 |
438 |
if $leap |
|
3037
|
6 |
645 |
if $year < $epoch or $year > 9999 |
|
3038
|
6 |
639 |
if $month < 1 or $month > 12 |
|
3039
|
6 |
633 |
if $day < 1 or $day > $mdays[$month - 1] |
|
3052
|
423 |
210 |
if $date_1904 == 0 and $days > 59 |
|
3075
|
0 |
382 |
unless defined $row |
|
3081
|
349 |
33 |
if (defined $self->{'_dim_colmin'}) |
|
3086
|
0 |
382 |
if $self->_check_dimensions($row, $min_col) |
|
3088
|
318 |
64 |
unless defined $height |
|
3091
|
1 |
381 |
if ($height == 0) |
|
3097
|
0 |
382 |
if $level < 0 |
|
3098
|
0 |
382 |
if $level > 7 |
|
3100
|
11 |
371 |
if ($level > $self->{'_outline_row_level'}) |
|
3127
|
5 |
1 |
if ($height != $self->{'_original_row_height'}) |
|
3134
|
3 |
3 |
if ($zero_height) |
|
3152
|
12 |
8 |
if ($_[0] =~ /^\D/) |
|
3155
|
0 |
20 |
if @_ < 6 |
|
3156
|
0 |
20 |
unless ref $_[5] |
|
3167
|
0 |
20 |
if ($row_first == $row_last and $col_first == $col_last) |
|
3172
|
0 |
20 |
if $row_first > $row_last |
|
3174
|
0 |
20 |
if $col_first > $col_last |
|
3178
|
0 |
20 |
if $self->_check_dimensions($row_last, $col_last) |
|
3189
|
20 |
48 |
if $row == $row_first and $col == $col_first |
|
3208
|
7 |
0 |
if ($_[0] =~ /^\D/) |
|
3219
|
2 |
5 |
if ($type eq 'array_formula' or $type eq 'blank' or $type eq 'rich_string') { } |
|
3234
|
0 |
7 |
unless ref $format |
|
3238
|
0 |
7 |
if ($row_first == $row_last and $col_first == $col_last) |
|
3243
|
0 |
7 |
if $row_first > $row_last |
|
3245
|
0 |
7 |
if $col_first > $col_last |
|
3249
|
0 |
7 |
if $self->_check_dimensions($row_last, $col_last) |
|
3255
|
1 |
6 |
if ($type eq 'string') { } |
|
|
1 |
5 |
elsif ($type eq 'number') { } |
|
|
1 |
4 |
elsif ($type eq 'blank') { } |
|
|
1 |
3 |
elsif ($type eq 'date_time') { } |
|
|
1 |
2 |
elsif ($type eq 'rich_string') { } |
|
|
1 |
1 |
elsif ($type eq 'url') { } |
|
|
1 |
0 |
elsif ($type eq 'formula') { } |
|
|
0 |
0 |
elsif ($type eq 'array_formula') { } |
|
3286
|
7 |
7 |
if $row == $row_first and $col == $col_first |
|
3316
|
63 |
5 |
if ($_[0] =~ /^\D/) |
|
3321
|
0 |
68 |
if (@_ != 5 and @_ != 3) |
|
3328
|
63 |
5 |
unless (defined $row2) |
|
3334
|
0 |
68 |
if $self->_check_dimensions($row1, $col1, 1, 1) |
|
3335
|
0 |
68 |
if $self->_check_dimensions($row2, $col2, 1, 1) |
|
3339
|
0 |
68 |
if (ref $param ne 'HASH') |
|
3366
|
0 |
262 |
unless (exists $valid_parameter{$param_key}) |
|
3373
|
5 |
63 |
if defined $param->{'source'} |
|
3374
|
24 |
44 |
if defined $param->{'minimum'} |
|
3377
|
0 |
68 |
unless (exists $param->{'validate'}) |
|
3401
|
0 |
68 |
if (not exists $valid_type{lc $param->{'validate'}}) { } |
|
3412
|
1 |
2 |
if ($param->{'validate'} eq 'none' and not defined $param->{'input_message'} and not defined $param->{'input_title'}) |
|
3421
|
16 |
49 |
if ($param->{'validate'} eq 'none' or $param->{'validate'} eq 'list' or $param->{'validate'} eq 'custom') |
|
3430
|
0 |
67 |
unless (exists $param->{'criteria'}) |
|
3457
|
0 |
67 |
if (not exists $criteria_type{lc $param->{'criteria'}}) { } |
|
3468
|
42 |
25 |
if ($param->{'criteria'} eq 'between' or $param->{'criteria'} eq 'notBetween') { } |
|
3470
|
0 |
42 |
unless (exists $param->{'maximum'}) |
|
3489
|
65 |
2 |
if (not exists $param->{'error_type'}) { } |
|
|
0 |
2 |
elsif (not exists $error_type{lc $param->{'error_type'}}) { } |
|
3503
|
7 |
60 |
if ($param->{'validate'} eq 'date' or $param->{'validate'} eq 'time') |
|
3506
|
5 |
2 |
if (defined $date_time) |
|
3510
|
3 |
4 |
if (defined $param->{'maximum'}) |
|
3513
|
2 |
1 |
if (defined $date_time) |
|
3520
|
1 |
66 |
if ($param->{'input_title'} and length $param->{'input_title'} > 32) |
|
3527
|
0 |
66 |
if ($param->{'error_title'} and length $param->{'error_title'} > 32) |
|
3534
|
1 |
65 |
if ($param->{'input_message'} and length $param->{'input_message'} > 255) |
|
3541
|
0 |
65 |
if ($param->{'error_message'} and length $param->{'error_message'} > 255) |
|
3548
|
13 |
52 |
if ($param->{'validate'} eq 'list') |
|
3550
|
11 |
2 |
if (ref $param->{'value'} eq 'ARRAY') |
|
3553
|
1 |
10 |
if (length $formula > 255) |
|
3562
|
62 |
2 |
unless defined $param->{'ignore_blank'} |
|
3563
|
63 |
1 |
unless defined $param->{'dropdown'} |
|
3564
|
61 |
3 |
unless defined $param->{'show_input'} |
|
3565
|
62 |
2 |
unless defined $param->{'show_error'} |
|
3572
|
3 |
61 |
if (exists $param->{'other_cells'}) |
|
3604
|
149 |
0 |
if ($_[0] =~ /^\D/) |
|
3607
|
1 |
148 |
if ($_[0] =~ /,/) |
|
3622
|
74 |
75 |
unless (defined $row2) |
|
3628
|
0 |
149 |
if $self->_check_dimensions($row1, $col1, 1, 1) |
|
3629
|
0 |
149 |
if $self->_check_dimensions($row2, $col2, 1, 1) |
|
3633
|
0 |
149 |
if (ref $options ne 'HASH') |
|
3681
|
0 |
492 |
unless (exists $valid_parameter{$param_key}) |
|
3688
|
0 |
149 |
unless (exists $param->{'type'}) |
|
3718
|
0 |
149 |
if (not exists $valid_type{lc $param->{'type'}}) { } |
|
3724
|
2 |
147 |
if $param->{'type'} eq 'bottom' |
|
3763
|
53 |
96 |
if (defined $param->{'criteria'} and exists $criteria_type{lc $param->{'criteria'}}) |
|
3770
|
2 |
147 |
if ($param->{'type'} eq 'date' or $param->{'type'} eq 'time') |
|
3773
|
1 |
1 |
if (defined $param->{'value'} and $param->{'value'} =~ /T/) |
|
3776
|
0 |
1 |
if (not defined $date_time) { } |
|
3786
|
1 |
1 |
if (defined $param->{'minimum'} and $param->{'minimum'} =~ /T/) |
|
3789
|
0 |
1 |
if (not defined $date_time) { } |
|
3799
|
1 |
1 |
if (defined $param->{'maximum'} and $param->{'maximum'} =~ /T/) |
|
3802
|
0 |
1 |
if (not defined $date_time) { } |
|
3837
|
37 |
112 |
if ($param->{'type'} eq 'iconSet') |
|
3839
|
0 |
37 |
unless (defined $param->{'icon_style'}) |
|
3846
|
0 |
37 |
if (not exists $icon_set_styles{$param->{'icon_style'}}) { } |
|
3857
|
11 |
26 |
if ($param->{'icon_style'} =~ /^4/) { } |
|
|
8 |
18 |
elsif ($param->{'icon_style'} =~ /^5/) { } |
|
3874
|
0 |
149 |
if ($row1 > $row2) |
|
3878
|
0 |
149 |
if ($col1 > $col2) |
|
3883
|
74 |
75 |
if ($row1 == $row2 and $col1 == $col2) { } |
|
3893
|
1 |
148 |
if ($user_range) |
|
3898
|
27 |
122 |
if (defined $param->{'format'} and ref $param->{'format'}) |
|
3906
|
3 |
124 |
if ($self->{'_use_data_bars_2010'} or $param->{'data_bar_2010'} or $param->{'bar_solid'} or $param->{'bar_border_color'} or $param->{'bar_negative_color'} or $param->{'bar_negative_color_same'} or $param->{'bar_negative_border_color'} or $param->{'bar_negative_border_color_same'} or $param->{'bar_no_border'} or $param->{'bar_axis_position'} or $param->{'bar_axis_color'} or $param->{'bar_direction'}) |
|
3923
|
8 |
141 |
if ($param->{'type'} eq 'text') |
|
3925
|
1 |
7 |
if ($param->{'criteria'} eq 'containsText') { } |
|
|
1 |
6 |
elsif ($param->{'criteria'} eq 'notContains') { } |
|
|
3 |
3 |
elsif ($param->{'criteria'} eq 'beginsWith') { } |
|
|
3 |
0 |
elsif ($param->{'criteria'} eq 'endsWith') { } |
|
3952
|
10 |
139 |
if ($param->{'type'} eq 'timePeriod') |
|
3954
|
1 |
9 |
if ($param->{'criteria'} eq 'yesterday') { } |
|
|
1 |
8 |
elsif ($param->{'criteria'} eq 'today') { } |
|
|
1 |
7 |
elsif ($param->{'criteria'} eq 'tomorrow') { } |
|
|
1 |
6 |
elsif ($param->{'criteria'} eq 'last7Days') { } |
|
|
1 |
5 |
elsif ($param->{'criteria'} eq 'lastWeek') { } |
|
|
1 |
4 |
elsif ($param->{'criteria'} eq 'thisWeek') { } |
|
|
1 |
3 |
elsif ($param->{'criteria'} eq 'nextWeek') { } |
|
|
1 |
2 |
elsif ($param->{'criteria'} eq 'lastMonth') { } |
|
|
1 |
1 |
elsif ($param->{'criteria'} eq 'thisMonth') { } |
|
|
1 |
0 |
elsif ($param->{'criteria'} eq 'nextMonth') { } |
|
4013
|
1 |
148 |
if ($param->{'type'} eq 'containsBlanks') |
|
4017
|
1 |
148 |
if ($param->{'type'} eq 'notContainsBlanks') |
|
4021
|
1 |
148 |
if ($param->{'type'} eq 'containsErrors') |
|
4025
|
1 |
148 |
if ($param->{'type'} eq 'notContainsErrors') |
|
4031
|
1 |
148 |
if ($param->{'type'} eq '2_color_scale') |
|
4054
|
4 |
145 |
if ($param->{'type'} eq '3_color_scale') |
|
4064
|
3 |
1 |
unless defined $param->{'mid_value'} |
|
4077
|
29 |
120 |
if ($param->{'type'} eq 'dataBar') |
|
4082
|
22 |
7 |
if (not defined $param->{'min_type'}) { } |
|
4090
|
23 |
6 |
if (not defined $param->{'max_type'}) { } |
|
4131
|
25 |
124 |
if ($param->{'_is_data_bar_2010'}) |
|
4135
|
20 |
5 |
if ($param->{'min_type'} eq 'min' and $param->{'min_value'} == 0) |
|
4139
|
21 |
4 |
if ($param->{'max_type'} eq 'max' and $param->{'max_value'} == 0) |
|
4148
|
14 |
135 |
if defined $param->{'min_value'} |
|
4149
|
5 |
144 |
if defined $param->{'mid_value'} |
|
4150
|
13 |
136 |
if defined $param->{'max_value'} |
|
4179
|
18 |
19 |
if ($total_icons == 3) |
|
4184
|
11 |
26 |
if ($total_icons == 4) |
|
4190
|
8 |
29 |
if ($total_icons == 5) |
|
4198
|
13 |
24 |
if (defined $user_props) |
|
4202
|
2 |
11 |
if ($max_data >= $total_icons) |
|
4209
|
24 |
6 |
if (defined $user_props->[$i]{'value'}) |
|
4215
|
14 |
16 |
if (defined $user_props->[$i]{'type'}) |
|
4219
|
0 |
14 |
if ($type ne 'percent' and $type ne 'percentile' and $type ne 'number' and $type ne 'formula') { } |
|
4230
|
2 |
12 |
if ($props->[$i]{'type'} eq 'number') |
|
4237
|
7 |
23 |
if (defined $user_props->[$i]{'criteria'} and $user_props->[$i]{'criteria'} eq '>') |
|
4267
|
0 |
48 |
if ($self->{'_optimization'} == 1) |
|
4273
|
48 |
0 |
if (@_ and $_[0] =~ /^\D/) |
|
4278
|
0 |
48 |
if (@_ < 4) |
|
4286
|
0 |
48 |
if $self->_check_dimensions($row1, $col1, 1, 1) |
|
4287
|
0 |
48 |
if $self->_check_dimensions($row2, $col2, 1, 1) |
|
4294
|
0 |
48 |
if (ref $param ne 'HASH') |
|
4317
|
0 |
44 |
unless (exists $valid_parameter{$param_key}) |
|
4324
|
47 |
1 |
unless defined $param->{'banded_rows'} |
|
4325
|
45 |
3 |
unless defined $param->{'header_row'} |
|
4326
|
47 |
1 |
unless defined $param->{'autofilter'} |
|
4329
|
1 |
47 |
$param->{'first_column'} ? : |
|
4330
|
1 |
47 |
$param->{'last_column'} ? : |
|
4331
|
47 |
1 |
$param->{'banded_rows'} ? : |
|
4332
|
1 |
47 |
$param->{'banded_columns'} ? : |
|
4333
|
45 |
3 |
$param->{'header_row'} ? : |
|
4334
|
10 |
38 |
$param->{'total_row'} ? : |
|
4338
|
1 |
47 |
if (defined $param->{'name'}) |
|
4342
|
0 |
1 |
if (not $name =~ /^[\w\\][\w\\.]*$/ or $name =~ /^\d/) |
|
4348
|
0 |
1 |
if ($name =~ /^[a-zA-Z][a-zA-Z]?[a-dA-D]?[0-9]+$/) |
|
4354
|
0 |
1 |
if ($name =~ /^[rcRC]$/ or $name =~ /^[rcRC]\d+[rcRC]\d+$/) |
|
4363
|
3 |
45 |
if (defined $param->{'style'}) { } |
|
4375
|
0 |
48 |
if ($row1 > $row2) |
|
4379
|
0 |
48 |
if ($col1 > $col2) |
|
4387
|
45 |
3 |
if $param->{'header_row'} |
|
4388
|
10 |
38 |
if $param->{'total_row'} |
|
4397
|
3 |
45 |
unless ($param->{'header_row'}) |
|
4402
|
44 |
4 |
if ($param->{'autofilter'}) |
|
4423
|
85 |
127 |
if ($param->{'columns'}) |
|
4426
|
84 |
1 |
if (my $user_data = $param->{'columns'}[$col_id - 1]) |
|
4430
|
12 |
72 |
if $user_data->{'header'} |
|
4435
|
1 |
83 |
if (exists $seen_names{$key}) { } |
|
4447
|
3 |
80 |
if ($user_data->{'formula'}) |
|
4465
|
40 |
43 |
if ($user_data->{'total_function'}) { } |
|
|
9 |
34 |
elsif ($user_data->{'total_string'}) { } |
|
4473
|
4 |
36 |
if $function eq 'countnums' |
|
4474
|
4 |
36 |
if $function eq 'stddev' |
|
4501
|
9 |
74 |
if (defined $user_data->{'format'} and ref $user_data->{'format'}) |
|
4517
|
201 |
10 |
if ($param->{'header_row'}) |
|
4527
|
6 |
41 |
if (my $data = $param->{'data'}) |
|
4537
|
77 |
7 |
if (defined $token) |
|
4568
|
0 |
58 |
if (ref $param ne 'HASH') |
|
4605
|
0 |
212 |
unless (exists $valid_parameter{$param_key}) |
|
4612
|
0 |
58 |
unless (exists $param->{'location'}) |
|
4618
|
0 |
58 |
unless (exists $param->{'range'}) |
|
4627
|
0 |
9 |
if ($type ne 'line' and $type ne 'column' and $type ne 'win_loss') |
|
4633
|
1 |
57 |
if $type eq 'win_loss' |
|
4638
|
2 |
56 |
if (ref $param->{'location'}) { } |
|
4651
|
0 |
58 |
if ($range_count != $location_count) |
|
4673
|
54 |
5 |
unless ($range =~ /!/) |
|
4700
|
1 |
57 |
if ($empty eq 'zero') { } |
|
|
1 |
56 |
elsif ($empty eq 'connect') { } |
|
4714
|
1 |
57 |
if ($date_range and not $date_range =~ /!/) |
|
4756
|
28 |
0 |
if ($_[0] =~ /^\D/) |
|
4761
|
0 |
28 |
if (@_ < 3) |
|
4782
|
2 |
4 |
if ($vba_codemame) { } |
|
4827
|
40 |
0 |
if (exists $subtotals{$function}) { } |
|
4853
|
398 |
8 |
unless $param->{$user_color} |
|
4874
|
167 |
6 |
if ($index =~ /^#([0-9A-F]{6})$/i) |
|
4904
|
191 |
2255 |
if ($cell =~ /\$?([A-Z]{1,3}):\$?([A-Z]{1,3})/) |
|
4912
|
194 |
2061 |
if ($cell =~ /\$?([A-Z]{1,3}\$?\d+):\$?([A-Z]{1,3}\$?\d+)/) |
|
4919
|
2061 |
0 |
if ($cell =~ /\$?([A-Z]{1,3}\$?\d+)/) |
|
4948
|
2831 |
0 |
$1 eq '' ? : |
|
4950
|
2829 |
2 |
$3 eq '' ? : |
|
5003
|
1979 |
11 |
unless @_ |
|
5010
|
6 |
5 |
if $array[0] == 0 |
|
5015
|
1 |
10 |
if @array > $max_num_breaks |
|
5042
|
0 |
16086 |
unless defined $row |
|
5043
|
0 |
16086 |
if $row >= $self->{'_xls_rowmax'} |
|
5045
|
0 |
16086 |
unless defined $col |
|
5046
|
0 |
16086 |
if $col >= $self->{'_xls_colmax'} |
|
5050
|
308 |
15778 |
if (not $ignore_row || $ignore_col and $self->{'_optimization'} == 1) |
|
5051
|
1 |
307 |
if $row < $self->{'_previous_row'} |
|
5054
|
15177 |
908 |
unless ($ignore_row) |
|
5056
|
806 |
14371 |
if (not defined $self->{'_dim_rowmin'} or $row < $self->{'_dim_rowmin'}) |
|
5060
|
4539 |
10638 |
if (not defined $self->{'_dim_rowmax'} or $row > $self->{'_dim_rowmax'}) |
|
5065
|
15219 |
866 |
unless ($ignore_col) |
|
5067
|
819 |
14400 |
if (not defined $self->{'_dim_colmin'} or $col < $self->{'_dim_colmin'}) |
|
5071
|
2204 |
13015 |
if (not defined $self->{'_dim_colmax'} or $col > $self->{'_dim_colmax'}) |
|
5163
|
1 |
4704 |
if $x1 < 0 |
|
5164
|
1 |
4704 |
if $y1 < 0 |
|
5167
|
46 |
4659 |
if ($self->{'_col_size_changed'}) { } |
|
5181
|
23 |
4682 |
if ($self->{'_row_size_changed'}) { } |
|
5195
|
4704 |
1 |
if ($self->_size_col($col_start) > 0) |
|
5203
|
4701 |
4 |
if ($self->_size_row($row_start) > 0) |
|
5215
|
4704 |
1 |
if ($self->_size_col($col_start) > 0) |
|
5219
|
4701 |
4 |
if ($self->_size_row($row_start) > 0) |
|
5356
|
170 |
41334 |
if (exists $self->{'_col_sizes'}{$col}) { } |
|
5362
|
8 |
162 |
if ($hidden == 1 and $anchor != 4) { } |
|
|
0 |
162 |
elsif ($width < 1) { } |
|
5397
|
84 |
63910 |
if (exists $self->{'_row_sizes'}{$row}) { } |
|
5401
|
20 |
64 |
if ($hidden == 1 and $anchor != 4) { } |
|
5429
|
1123 |
1591 |
unless (exists ${$$self{'_str_table'};}->{$str}) |
|
5451
|
415 |
124 |
if (not defined $target) { } |
|
|
3 |
121 |
elsif (exists $self->{'_drawing_rels'}{$target}) { } |
|
5476
|
10 |
34 |
if (exists $self->{'_vml_drawing_rels'}{$target}) { } |
|
5499
|
374 |
0 |
if ($_[0] =~ /^\D/) |
|
5512
|
0 |
374 |
unless @_ >= 3 |
|
5514
|
374 |
0 |
if (ref $chart) |
|
5517
|
0 |
374 |
unless $chart->isa('Excel::Writer::XLSX::Chart') |
|
5522
|
0 |
374 |
unless $chart->{'_embedded'} |
|
5526
|
3 |
371 |
if (ref $_[3] eq 'HASH') { } |
|
5545
|
0 |
374 |
if ($chart->{'_already_inserted'} or $chart->{'_combined'} and $chart->{'_combined'}{'_already_inserted'}) { } |
|
5554
|
10 |
364 |
if ($chart->{'_combined'}) |
|
5560
|
1 |
373 |
if $chart->{'_x_scale'} != 1 |
|
5561
|
1 |
373 |
if $chart->{'_y_scale'} != 1 |
|
5562
|
1 |
373 |
if $chart->{'_x_offset'} |
|
5563
|
1 |
373 |
if $chart->{'_y_offset'} |
|
5591
|
374 |
0 |
if $chart->{'_width'} |
|
5592
|
374 |
0 |
if $chart->{'_height'} |
|
5605
|
362 |
12 |
if (not $self->{'_drawing'}) { } |
|
5649
|
0 |
1062 |
if $self->{'_optimization'} |
|
5660
|
5 |
5039 |
unless (exists $self->{'_table'}{$row_num}) |
|
5667
|
5035 |
4 |
if (my $cell = $self->{'_table'}{$row_num}{$col_num}) { } |
|
5673
|
5010 |
25 |
if ($type eq 'n') { } |
|
|
25 |
0 |
elsif ($type eq 's') { } |
|
|
0 |
0 |
elsif ($type eq 'f') { } |
|
|
0 |
0 |
elsif ($type eq 'a') { } |
|
|
0 |
0 |
elsif ($type eq 'b') { } |
|
5681
|
25 |
0 |
if ($self->{'_optimization'} == 0) { } |
|
5727
|
101 |
2 |
if ($_[0] =~ /^\D/) |
|
5742
|
24 |
79 |
if (ref $_[3] eq 'HASH') { } |
|
5762
|
0 |
103 |
unless @_ >= 3 |
|
5763
|
0 |
103 |
unless -e $image |
|
5815
|
77 |
26 |
if (not $self->{'_drawing'}) { } |
|
5842
|
21 |
82 |
if ($url) |
|
5847
|
16 |
5 |
if ($url =~ m[^[fh]tt?ps?://] or $url =~ /^mailto:/) |
|
5851
|
3 |
18 |
if ($url =~ s[^external:][file:///]) |
|
5858
|
2 |
19 |
if ($url =~ s/^internal:/#/) |
|
5864
|
0 |
21 |
if (length $target > $max_url) { } |
|
5870
|
20 |
1 |
if ($target and not exists $self->{'_drawing_rels'}{$url}) |
|
5880
|
101 |
2 |
unless (exists $self->{'_drawing_rels'}{$md5}) |
|
5911
|
34 |
10 |
unless (exists $self->{'_vml_drawing_rels'}{$md5}) |
|
5934
|
41 |
4 |
if ($_[0] =~ /^\D/) |
|
5939
|
0 |
45 |
unless @_ >= 3 |
|
5944
|
0 |
45 |
unless $shape->isa('Excel::Writer::XLSX::Shape') |
|
5955
|
1 |
44 |
if defined $_[5] |
|
5956
|
1 |
44 |
if defined $_[6] |
|
5963
|
28 |
62 |
exists $self->{'_shape_hash'}{$id} ? : |
|
5966
|
45 |
45 |
if (not $used and $id != 0) { } |
|
5982
|
45 |
0 |
if ($shape->{'_stencil'}) { } |
|
6028
|
10 |
31 |
if (not $self->{'_drawing'}) { } |
|
6096
|
12 |
33 |
$connector_shapes->{$shape_base} ? : |
|
6098
|
33 |
12 |
unless $shape->{'_connect'} |
|
6101
|
0 |
12 |
unless $shape->{'_start'} and $shape->{'_end'} |
|
6104
|
0 |
12 |
unless $shape->{'_start_side'} and $shape->{'_end_side'} |
|
6111
|
11 |
1 |
if (defined $slink_id) { } |
|
6120
|
10 |
1 |
if (defined $elink_id) { } |
|
6138
|
5 |
5 |
if ($connect_type eq 'bt') { } |
|
|
5 |
0 |
elsif ($connect_type eq 'rl') { } |
|
6150
|
3 |
2 |
$smidx < $emidx ? : |
|
6153
|
2 |
3 |
if ($sy > $ey) |
|
6158
|
1 |
1 |
if ($#{$$shape{'_adjustments'};} < 0) |
|
6174
|
1 |
4 |
if $smidx < $emidx and $smidy > $emidy |
|
6175
|
1 |
4 |
if $smidx > $emidx and $smidy < $emidy |
|
6176
|
2 |
3 |
if ($smidx > $emidx) |
|
6179
|
1 |
1 |
if ($#{$$shape{'_adjustments'};} < 0) |
|
6204
|
0 |
41 |
unless (grep /^$shape->{'_align'}$/, ('l', 'ctr', 'r', 'just')) |
|
6209
|
0 |
41 |
if (not grep(/^$shape->{'_valign'}$/, ('t', 'ctr', 'b'))) |
|
6246
|
10 |
4143 |
if ($self->{'_comments_visible'}) |
|
6247
|
8 |
2 |
unless (defined $self->{'_comments'}{$row}{$col}[4]) |
|
6253
|
4151 |
2 |
unless (defined $self->{'_comments'}{$row}{$col}[3]) |
|
6265
|
39 |
14 |
if ($self->{'_has_comments'}) |
|
6326
|
46 |
1 |
unless (defined $table->{'_name'}) |
|
6335
|
0 |
47 |
if (exists $seen->{$name}) { } |
|
6394
|
0 |
4153 |
unless $params{'width'} |
|
6395
|
0 |
4153 |
unless $params{'height'} |
|
6401
|
0 |
4153 |
if (length $string > $max_len) |
|
6410
|
0 |
4153 |
if ($color_id =~ /^#[0-9A-F]{6}$/i) { } |
|
|
4152 |
1 |
elsif ($color_id == 0) { } |
|
6432
|
0 |
4153 |
if (defined $params{'start_cell'}) |
|
6446
|
4153 |
0 |
unless (defined $params{'start_row'}) |
|
6448
|
51 |
4102 |
if ($row == 0) { } |
|
|
0 |
4102 |
elsif ($row == $row_max - 3) { } |
|
|
0 |
4102 |
elsif ($row == $row_max - 2) { } |
|
|
1 |
4101 |
elsif ($row == $row_max - 1) { } |
|
6455
|
4152 |
1 |
unless (defined $params{'y_offset'}) |
|
6457
|
51 |
4101 |
if ($row == 0) { } |
|
|
0 |
4101 |
elsif ($row == $row_max - 3) { } |
|
|
0 |
4101 |
elsif ($row == $row_max - 2) { } |
|
|
1 |
4100 |
elsif ($row == $row_max - 1) { } |
|
6464
|
4153 |
0 |
unless (defined $params{'start_col'}) |
|
6466
|
0 |
4153 |
if ($col == $col_max - 3) { } |
|
|
0 |
4153 |
elsif ($col == $col_max - 2) { } |
|
|
1 |
4152 |
elsif ($col == $col_max - 1) { } |
|
6472
|
4153 |
0 |
unless (defined $params{'x_offset'}) |
|
6474
|
0 |
4153 |
if ($col == $col_max - 3) { } |
|
|
0 |
4153 |
elsif ($col == $col_max - 2) { } |
|
|
1 |
4152 |
elsif ($col == $col_max - 1) { } |
|
6482
|
4153 |
0 |
if ($params{'x_scale'}) |
|
6486
|
4153 |
0 |
if ($params{'y_scale'}) |
|
6541
|
24 |
4 |
unless (defined $caption) |
|
6549
|
5 |
23 |
if ($params->{'macro'}) { } |
|
6560
|
27 |
1 |
unless $params->{'width'} |
|
6561
|
27 |
1 |
unless $params->{'height'} |
|
6564
|
27 |
1 |
unless $params->{'x_offset'} |
|
6565
|
27 |
1 |
unless $params->{'y_offset'} |
|
6568
|
1 |
27 |
if ($params->{'x_scale'}) |
|
6572
|
1 |
27 |
if ($params->{'y_scale'}) |
|
6614
|
1 |
0 |
if $_[0] =~ /^\D/ |
|
6617
|
0 |
1 |
if @_ < 3 |
|
6632
|
1 |
0 |
if $_[0] =~ /^\D/ |
|
6635
|
0 |
1 |
if @_ < 3 |
|
6661
|
0 |
5 |
if $_[0] =~ /^\D/ |
|
6663
|
0 |
5 |
if (@_ < 2) |
|
6673
|
0 |
5 |
if @pairs % 2 |
|
6676
|
0 |
5 |
if ref $formula_ref ne 'ARRAY' |
|
6683
|
0 |
5 |
if (@pairs and $pairs[-2] eq 'result') |
|
6694
|
6 |
10 |
if $token =~ s/$pattern/$replace/ |
|
6730
|
23 |
971 |
if ($self->{'_excel_version'} == 2010) |
|
6756
|
971 |
5 |
unless ($self->{'_fit_page'} or $self->{'_filter_on'} or $self->{'_tab_color'} or $self->{'_outline_changed'} or $self->{'_vba_codename'}) |
|
6767
|
5 |
20 |
if $codename |
|
6768
|
9 |
16 |
if $self->{'_filter_on'} |
|
6770
|
11 |
14 |
if ($self->{'_fit_page'} or $self->{'_tab_color'} or $self->{'_outline_changed'}) { } |
|
6796
|
4 |
9 |
unless $self->{'_fit_page'} |
|
6816
|
248 |
755 |
if (not defined $self->{'_dim_rowmin'} || defined $self->{'_dim_colmin'}) { } |
|
|
6 |
749 |
elsif (not defined $self->{'_dim_rowmin'} and defined $self->{'_dim_colmin'}) { } |
|
|
134 |
615 |
elsif ($self->{'_dim_rowmin'} == $self->{'_dim_rowmax'} and $self->{'_dim_colmin'} == $self->{'_dim_colmax'}) { } |
|
6827
|
3 |
3 |
if ($self->{'_dim_colmin'} == $self->{'_dim_colmax'}) { } |
|
6920
|
3 |
1070 |
unless ($gridlines) |
|
6925
|
1 |
1072 |
if ($row_col_headers) |
|
6930
|
1 |
1072 |
unless ($show_zeros) |
|
6935
|
1 |
1072 |
if ($right_to_left) |
|
6940
|
924 |
149 |
if ($tab_selected) |
|
6946
|
1 |
1072 |
unless ($self->{'_outline_on'}) |
|
6952
|
2 |
1071 |
if ($view) |
|
6957
|
2 |
1071 |
if ($zoom != 100) |
|
6958
|
2 |
0 |
unless $view |
|
6960
|
1 |
1 |
if $self->{'_zoom_scale_normal'} |
|
6965
|
69 |
1004 |
if (@{$self->{'_panes'};} or @{$self->{'_selections'};}) { } |
|
7007
|
88 |
18 |
if $pane |
|
7008
|
91 |
15 |
if $active_cell |
|
7009
|
91 |
15 |
if $sqref |
|
7032
|
4 |
990 |
if ($self->{'_default_row_height'} != $self->{'_original_row_height'}) |
|
7036
|
3 |
991 |
if ($self->{'_default_row_zeroed'}) |
|
7040
|
5 |
989 |
if $row_level |
|
7041
|
1 |
993 |
if $col_level |
|
7043
|
23 |
971 |
if ($self->{'_excel_version'} == 2010) |
|
7062
|
893 |
100 |
unless %{$self->{'_colinfo'};} |
|
7094
|
20 |
172 |
if (ref $format) |
|
7099
|
26 |
166 |
if (not defined $width) { } |
|
7100
|
17 |
9 |
if (not $hidden) { } |
|
7111
|
1 |
165 |
if ($width == 8.43) |
|
7121
|
183 |
9 |
if ($width > 0) |
|
7122
|
22 |
161 |
if ($width < 1) { } |
|
7142
|
20 |
172 |
if $xf_index |
|
7143
|
13 |
179 |
if $hidden |
|
7144
|
174 |
18 |
if $custom_width |
|
7145
|
1 |
191 |
if $level |
|
7146
|
0 |
192 |
if $collapsed |
|
7163
|
254 |
732 |
if (not defined $self->{'_dim_rowmin'}) { } |
|
7190
|
0 |
8 |
if (not defined $self->{'_dim_rowmin'}) { } |
|
7232
|
1048846 |
304 |
unless ($self->{'_set_rows'}{$row_num} or $self->{'_table'}{$row_num} or $self->{'_comments'}{$row_num}) |
|
7243
|
3610 |
366 |
if (my $row_ref = $self->{'_table'}{$row_num}) { } |
|
|
304 |
62 |
elsif ($self->{'_comments'}{$row_num}) { } |
|
7245
|
3292 |
318 |
if (not $self->{'_set_rows'}{$row_num}) { } |
|
7255
|
9797 |
16896 |
if (my $col_ref = $self->{'_table'}{$row_num}{$col_num}) |
|
7296
|
0 |
0 |
unless ($self->{'_set_rows'}{$row_num} or $self->{'_table'}{$row_num} or $self->{'_comments'}{$row_num}) |
|
7304
|
296 |
0 |
if (my $row_ref = $self->{'_table'}{$row_num}) { } |
|
7306
|
295 |
1 |
if (not $self->{'_set_rows'}{$row_num}) { } |
|
7315
|
305 |
20 |
if (my $col_ref = $self->{'_table'}{$row_num}{$col_num}) |
|
7356
|
3916 |
1049212 |
if (my $row_ref = $self->{'_table'}{$row_num}) |
|
7359
|
10103 |
21792 |
if (my $col_ref = $self->{'_table'}{$row_num}{$col_num}) |
|
7361
|
790 |
9313 |
if (not defined $span_min) { } |
|
7366
|
7 |
9306 |
if $col_num < $span_min |
|
7367
|
1419 |
7894 |
if $col_num > $span_max |
|
7374
|
310 |
1052818 |
if (defined $self->{'_comments'}{$row_num}) |
|
7377
|
4153 |
32820 |
if (defined $self->{'_comments'}{$row_num}{$col_num}) |
|
7379
|
33 |
4120 |
if (not defined $span_min) { } |
|
7384
|
0 |
4120 |
if $col_num < $span_min |
|
7385
|
263 |
3857 |
if $col_num > $span_max |
|
7391
|
66374 |
986754 |
if (($row_num + 1) % 16 == 0 or $row_num == $self->{'_dim_rowmax'}) |
|
7396
|
823 |
65551 |
if (defined $span_min) |
|
7428
|
3895 |
385 |
unless defined $height |
|
7433
|
11 |
4269 |
if (ref $format) |
|
7437
|
3952 |
328 |
if defined $spans |
|
7438
|
11 |
4269 |
if $xf_index |
|
7439
|
11 |
4269 |
if $format |
|
7441
|
67 |
4213 |
if ($height != $self->{'_original_row_height'}) |
|
7445
|
281 |
3999 |
if $hidden |
|
7447
|
67 |
4213 |
if ($height != $self->{'_original_row_height'}) |
|
7451
|
53 |
4227 |
if $level |
|
7452
|
4 |
4276 |
if $collapsed |
|
7454
|
60 |
4220 |
if ($self->{'_excel_version'} == 2010) |
|
7458
|
367 |
3913 |
if ($empty_row) { } |
|
7527
|
410 |
9697 |
if (ref $xf) |
|
7535
|
410 |
9697 |
if ($xf_index) { } |
|
|
11 |
9686 |
elsif ($self->{'_set_rows'}{$row} and $self->{'_set_rows'}{$row}[1]) { } |
|
|
17 |
9669 |
elsif ($self->{'_col_formats'}{$col}) { } |
|
7549
|
7025 |
3082 |
if ($type eq 'n') { } |
|
|
2940 |
142 |
elsif ($type eq 's') { } |
|
|
75 |
67 |
elsif ($type eq 'f') { } |
|
|
8 |
59 |
elsif ($type eq 'a') { } |
|
|
4 |
55 |
elsif ($type eq 'l') { } |
|
|
55 |
0 |
elsif ($type eq 'b') { } |
|
7557
|
2642 |
298 |
if ($self->{'_optimization'} == 0) { } |
|
7569
|
8 |
290 |
if ($string =~ /^/ and $string =~ m[$]) { } |
|
7577
|
3 |
287 |
if ($string =~ /^\s/ or $string =~ /\s$/) |
|
7591
|
17 |
58 |
if ($value and not $value =~ /^([+-]?)(?=\d|\.\d)\d*(\.\d*)?([Ee]([+-]?\d+))?$/) |
|
7594
|
2 |
15 |
if (exists $boolean{$value}) { } |
|
|
8 |
7 |
elsif (exists $error_codes{$value}) { } |
|
7645
|
13 |
0 |
defined $_[0] ? : |
|
7660
|
0 |
0 |
defined $_[0] ? : |
|
7772
|
996 |
23 |
unless $self->{'_page_setup_changed'} |
|
7775
|
19 |
4 |
if ($self->{'_paper_size'}) |
|
7780
|
3 |
20 |
if ($self->{'_print_scale'} != 100) |
|
7785
|
3 |
20 |
if ($self->{'_fit_page'} and $self->{'_fit_width'} != 1) |
|
7789
|
4 |
19 |
if ($self->{'_fit_page'} and $self->{'_fit_height'} != 1) |
|
7794
|
2 |
21 |
if ($self->{'_page_order'}) |
|
7799
|
2 |
21 |
if ($self->{'_page_start'} > 1) |
|
7804
|
2 |
21 |
if ($self->{'_orientation'} == 0) { } |
|
7812
|
1 |
22 |
if ($self->{'_black_white'}) |
|
7817
|
3 |
20 |
if ($self->{'_page_start'} != 0) |
|
7822
|
0 |
23 |
if ($self->{'_horizontal_dpi'}) |
|
7826
|
5 |
18 |
if ($self->{'_vertical_dpi'}) |
|
7847
|
982 |
14 |
unless $count |
|
7898
|
1012 |
10 |
unless $self->{'_print_options_changed'} |
|
7901
|
4 |
6 |
if ($self->{'_hcenter'}) |
|
7906
|
4 |
6 |
if ($self->{'_vcenter'}) |
|
7911
|
2 |
8 |
if ($self->{'_print_headers'}) |
|
7916
|
4 |
6 |
if ($self->{'_print_gridlines'}) |
|
7936
|
2 |
1015 |
unless ($self->{'_header_footer_scales'}) |
|
7940
|
10 |
1007 |
unless ($self->{'_header_footer_aligns'}) |
|
7944
|
32 |
985 |
if ($self->{'_header_footer_changed'}) { } |
|
|
7 |
978 |
elsif ($self->{'_excel2003_style'}) { } |
|
7946
|
29 |
3 |
if $self->{'_header'} |
|
7947
|
13 |
19 |
if $self->{'_footer'} |
|
7999
|
989 |
6 |
unless @page_breaks |
|
8029
|
990 |
5 |
unless @page_breaks |
|
8080
|
982 |
32 |
unless $ref |
|
8084
|
29 |
3 |
if ($self->{'_filter_on'}) { } |
|
8119
|
86 |
30 |
unless $self->{'_filter_cols'}{$col} |
|
8149
|
15 |
16 |
if ($type == 1) { } |
|
8178
|
4 |
14 |
if (@filters != @non_blanks) |
|
8182
|
2 |
16 |
if (@filters == 1 and @non_blanks == 0) { } |
|
8229
|
14 |
4 |
if (@tokens == 2) { } |
|
8244
|
4 |
0 |
if ($tokens[2] == 0) { } |
|
8285
|
23 |
0 |
if (defined $operators{$operator}) { } |
|
8293
|
18 |
5 |
unless $operator eq 'equal' |
|
8316
|
944 |
49 |
unless @row_nums |
|
8336
|
81 |
0 |
if ($self->{'_table'} and $self->{'_table'}{$row_num} and $self->{'_table'}{$row_num}{$col_num}) |
|
8341
|
1 |
80 |
if $cell->[0] ne 's' |
|
8345
|
74 |
8 |
if ($link_type == 1) { } |
|
8378
|
74 |
8 |
if ($type == 1) { } |
|
|
8 |
0 |
elsif ($type == 2) { } |
|
8414
|
9 |
66 |
if defined $location |
|
8415
|
1 |
74 |
if defined $display |
|
8416
|
3 |
72 |
if defined $tooltip |
|
8441
|
3 |
8 |
if defined $tooltip |
|
8459
|
17 |
66 |
unless @panes |
|
8461
|
38 |
28 |
if ($panes[4] == 2) { } |
|
8492
|
7 |
21 |
if (@{$self->{'_selections'};}) |
|
8498
|
13 |
15 |
if ($row and $col) { } |
|
|
7 |
8 |
elsif ($col) { } |
|
8521
|
25 |
3 |
if ($type == 0) { } |
|
|
3 |
0 |
elsif ($type == 1) { } |
|
8532
|
20 |
8 |
if $x_split |
|
8533
|
21 |
7 |
if $y_split |
|
8568
|
8 |
30 |
if (@{$self->{'_selections'};}) |
|
8575
|
24 |
14 |
if $y_split |
|
8576
|
24 |
14 |
if $x_split |
|
8581
|
26 |
12 |
if ($top_row == $row and $left_col == $col) |
|
8589
|
30 |
8 |
unless ($has_selection) |
|
8595
|
10 |
28 |
if ($row and $col) { } |
|
|
14 |
14 |
elsif ($col) { } |
|
8617
|
24 |
14 |
if $x_split |
|
8618
|
24 |
14 |
if $y_split |
|
8620
|
8 |
30 |
if $has_selection |
|
8642
|
0 |
24 |
if ($width < 1) { } |
|
8673
|
8 |
5 |
unless $color_index |
|
8694
|
10 |
1 |
unless $self->{'_outline_changed'} |
|
8696
|
1 |
0 |
if $self->{'_outline_style'} |
|
8697
|
1 |
0 |
unless $self->{'_outline_below'} |
|
8698
|
1 |
0 |
unless $self->{'_outline_right'} |
|
8699
|
1 |
0 |
unless $self->{'_outline_on'} |
|
8716
|
1012 |
27 |
unless $self->{'_protect'} |
|
8720
|
6 |
21 |
if $arg{'password'} |
|
8721
|
20 |
7 |
if $arg{'sheet'} |
|
8722
|
5 |
22 |
if $arg{'content'} |
|
8723
|
23 |
4 |
unless $arg{'objects'} |
|
8724
|
18 |
9 |
unless $arg{'scenarios'} |
|
8725
|
3 |
24 |
if $arg{'format_cells'} |
|
8726
|
2 |
25 |
if $arg{'format_columns'} |
|
8727
|
2 |
25 |
if $arg{'format_rows'} |
|
8728
|
2 |
25 |
if $arg{'insert_columns'} |
|
8729
|
2 |
25 |
if $arg{'insert_rows'} |
|
8730
|
2 |
25 |
if $arg{'insert_hyperlinks'} |
|
8731
|
2 |
25 |
if $arg{'delete_columns'} |
|
8732
|
2 |
25 |
if $arg{'delete_rows'} |
|
8735
|
3 |
24 |
unless $arg{'select_locked_cells'} |
|
8737
|
2 |
25 |
if $arg{'sort'} |
|
8738
|
2 |
25 |
if $arg{'autofilter'} |
|
8739
|
2 |
25 |
if $arg{'pivot_tables'} |
|
8742
|
2 |
25 |
unless $arg{'select_unlocked_cells'} |
|
8759
|
544 |
470 |
unless $self->{'_drawing'} |
|
8794
|
940 |
54 |
unless $self->{'_has_vml'} |
|
8817
|
971 |
22 |
unless $self->{'_has_header_vml'} |
|
8848
|
19 |
37 |
if $format->{'_bold'} |
|
8849
|
10 |
46 |
if $format->{'_italic'} |
|
8850
|
0 |
56 |
if $format->{'_font_strikeout'} |
|
8851
|
0 |
56 |
if $format->{'_font_outline'} |
|
8852
|
0 |
56 |
if $format->{'_font_shadow'} |
|
8855
|
0 |
56 |
if $format->{'_underline'} |
|
8857
|
0 |
56 |
if $format->{'_font_script'} == 1 |
|
8858
|
0 |
56 |
if $format->{'_font_script'} == 2 |
|
8862
|
0 |
56 |
if (my $theme = $format->{'_theme'}) { } |
|
|
1 |
55 |
elsif (my $color = $format->{'_color'}) { } |
|
8878
|
56 |
0 |
if ($format->{'_font'} eq 'Calibri' and not $format->{'_hyperlink'}) |
|
8900
|
0 |
0 |
if ($underline == 2) { } |
|
|
0 |
0 |
elsif ($underline == 33) { } |
|
|
0 |
0 |
elsif ($underline == 34) { } |
|
8970
|
987 |
62 |
unless $count |
|
9004
|
4 |
64 |
if $sqref ne '' |
|
9009
|
0 |
68 |
if ($row_first > $row_last) |
|
9013
|
0 |
68 |
if ($col_first > $col_last) |
|
9018
|
65 |
3 |
if ($row_first == $row_last and $col_first == $col_last) { } |
|
9027
|
62 |
2 |
if ($param->{'validate'} ne 'none') |
|
9031
|
26 |
36 |
if ($param->{'criteria'} ne 'between') |
|
9037
|
2 |
62 |
if ($param->{'error_type'}) |
|
9039
|
1 |
1 |
if $param->{'error_type'} == 1 |
|
9041
|
1 |
1 |
if $param->{'error_type'} == 2 |
|
9044
|
62 |
2 |
if $param->{'ignore_blank'} |
|
9045
|
1 |
63 |
unless $param->{'dropdown'} |
|
9046
|
61 |
3 |
if $param->{'show_input'} |
|
9047
|
62 |
2 |
if $param->{'show_error'} |
|
9050
|
4 |
60 |
if $param->{'error_title'} |
|
9053
|
3 |
61 |
if $param->{'error_message'} |
|
9056
|
15 |
49 |
if $param->{'input_title'} |
|
9059
|
14 |
50 |
if $param->{'input_message'} |
|
9063
|
2 |
62 |
if ($param->{'validate'} eq 'none') { } |
|
9074
|
24 |
38 |
if defined $param->{'maximum'} |
|
9093
|
10 |
52 |
if (ref $formula eq 'ARRAY') |
|
9132
|
934 |
63 |
unless scalar @ranges |
|
9180
|
27 |
122 |
if defined $param->{'format'} |
|
9185
|
5 |
144 |
if $param->{'stop_if_true'} |
|
9187
|
36 |
113 |
if ($param->{'type'} eq 'cellIs') { } |
|
|
10 |
103 |
elsif ($param->{'type'} eq 'aboveAverage') { } |
|
|
4 |
99 |
elsif ($param->{'type'} eq 'top10') { } |
|
|
1 |
98 |
elsif ($param->{'type'} eq 'duplicateValues') { } |
|
|
1 |
97 |
elsif ($param->{'type'} eq 'uniqueValues') { } |
|
|
8 |
89 |
elsif ($param->{'type'} eq 'containsText' or $param->{'type'} eq 'notContainsText' or $param->{'type'} eq 'beginsWith' or $param->{'type'} eq 'endsWith') { } |
|
|
10 |
79 |
elsif ($param->{'type'} eq 'timePeriod') { } |
|
|
4 |
75 |
elsif ($param->{'type'} eq 'containsBlanks' or $param->{'type'} eq 'notContainsBlanks' or $param->{'type'} eq 'containsErrors' or $param->{'type'} eq 'notContainsErrors') { } |
|
|
5 |
70 |
elsif ($param->{'type'} eq 'colorScale') { } |
|
|
29 |
41 |
elsif ($param->{'type'} eq 'dataBar') { } |
|
|
4 |
37 |
elsif ($param->{'type'} eq 'expression') { } |
|
|
37 |
0 |
elsif ($param->{'type'} eq 'iconSet') { } |
|
9192
|
5 |
31 |
if (defined $param->{'minimum'} and defined $param->{'maximum'}) { } |
|
9200
|
2 |
28 |
unless ($value =~ /(\$?)([A-Z]{1,3})(\$?)(\d+)/ or $value =~ /^([+-]?)(?=\d|\.\d)\d*(\.\d*)?([Ee]([+-]?\d+))?$/) |
|
9204
|
1 |
1 |
unless ($value =~ /^".*"$/) |
|
9215
|
5 |
5 |
if ($param->{'criteria'} =~ /below/) |
|
9219
|
2 |
8 |
if ($param->{'criteria'} =~ /equal/) |
|
9223
|
6 |
4 |
if ($param->{'criteria'} =~ /([123]) std dev/) |
|
9230
|
2 |
2 |
if (defined $param->{'criteria'} and $param->{'criteria'} eq '%') |
|
9234
|
2 |
2 |
if ($param->{'direction'}) |
|
9289
|
25 |
4 |
if ($param->{'_is_data_bar_2010'}) |
|
9328
|
36 |
1 |
if ($icon_style ne '3TrafficLights') |
|
9332
|
4 |
0 |
if (exists $param->{'icons_only'} and $param->{'icons_only'}) |
|
9336
|
6 |
0 |
if (exists $param->{'reverse_icons'} and $param->{'reverse_icons'}) |
|
9387
|
4 |
1 |
if (defined $param->{'mid_type'}) |
|
9395
|
4 |
1 |
if (defined $param->{'mid_color'}) |
|
9417
|
2 |
27 |
if ($data_bar->{'bar_only'}) |
|
9479
|
169 |
41 |
if (defined $value) |
|
9483
|
7 |
203 |
if ($criteria) |
|
9505
|
41 |
9 |
if ($type eq 'min' or $type eq 'max' or $type eq 'autoMin' or $type eq 'autoMax') { } |
|
9551
|
966 |
27 |
unless $count |
|
9598
|
971 |
11 |
unless ($has_data_bars or $has_sparklines) |
|
9605
|
11 |
11 |
if ($has_data_bars) |
|
9609
|
12 |
10 |
if ($has_sparklines) |
|
9678
|
24 |
1 |
unless ($data_bar->{'bar_no_border'}) |
|
9683
|
24 |
1 |
unless ($data_bar->{'bar_negative_color_same'}) |
|
9689
|
23 |
1 |
unless ($data_bar->{'bar_no_border'} or $data_bar->{'bar_negative_border_color_same'}) |
|
9697
|
24 |
1 |
if ($data_bar->{'bar_axis_position'} ne 'none') |
|
9753
|
24 |
1 |
unless ($data_bar->{'bar_no_border'}) |
|
9757
|
1 |
24 |
if ($data_bar->{'bar_solid'}) |
|
9761
|
1 |
24 |
if ($data_bar->{'bar_direction'} eq 'left') |
|
9765
|
1 |
24 |
if ($data_bar->{'bar_direction'} eq 'right') |
|
9769
|
1 |
24 |
if ($data_bar->{'bar_negative_color_same'}) |
|
9773
|
23 |
1 |
unless ($data_bar->{'bar_no_border'} or $data_bar->{'bar_negative_border_color_same'}) |
|
9779
|
1 |
24 |
if ($data_bar->{'bar_axis_position'} eq 'middle') |
|
9783
|
1 |
24 |
if ($data_bar->{'bar_axis_position'} eq 'none') |
|
9907
|
1 |
57 |
if ($sparkline->{'_date_axis'}) |
|
10027
|
4 |
54 |
if (defined $opts->{'_max'}) |
|
10029
|
2 |
2 |
if ($opts->{'_max'} eq 'group') { } |
|
10038
|
4 |
54 |
if (defined $opts->{'_min'}) |
|
10040
|
1 |
3 |
if ($opts->{'_min'} eq 'group') { } |
|
10051
|
9 |
49 |
if ($opts->{'_type'} ne 'line') |
|
10055
|
3 |
55 |
if $opts->{'_weight'} |
|
10056
|
1 |
57 |
if $opts->{'_date_axis'} |
|
10057
|
57 |
1 |
if $empty |
|
10059
|
4 |
54 |
if $opts->{'_markers'} |
|
10060
|
4 |
54 |
if $opts->{'_high'} |
|
10061
|
4 |
54 |
if $opts->{'_low'} |
|
10062
|
4 |
54 |
if $opts->{'_first'} |
|
10063
|
4 |
54 |
if $opts->{'_last'} |
|
10064
|
4 |
54 |
if $opts->{'_negative'} |
|
10065
|
1 |
57 |
if $opts->{'_axis'} |
|
10066
|
1 |
57 |
if $opts->{'_hidden'} |
|
10067
|
4 |
54 |
if $opts->{'_cust_min'} |
|
10068
|
4 |
54 |
if $opts->{'_cust_max'} |
|
10069
|
1 |
57 |
if $opts->{'_reverse'} |
|
10088
|
122 |
342 |
if defined $color->{'_rgb'} |
|
10089
|
342 |
122 |
if defined $color->{'_theme'} |
|
10090
|
229 |
235 |
if defined $color->{'_tint'} |