line |
true |
false |
branch |
233
|
10 |
1408 |
if ($self->{'_optimization'} == 1)
|
247
|
8 |
1410 |
if ($self->{'_excel2003_style'})
|
276
|
10 |
1031 |
if ($self->{'_optimization'} == 1)
|
315
|
1068 |
10 |
if ($self->{'_optimization'} == 0) { }
|
332
|
8 |
1070 |
if ($self->{'_excel2003_style'})
|
509
|
6 |
24 |
if ($password ne "")
|
538
|
60 |
0 |
if (exists $defaults{$key}) { }
|
566
|
0 |
9 |
if (not defined $range) { }
|
577
|
7 |
2 |
unless (defined $range_name)
|
581
|
2 |
7 |
if (defined $password)
|
641
|
190 |
45 |
if ($cell =~ /^\D/)
|
650
|
0 |
235 |
if @data < 3
|
660
|
0 |
235 |
unless defined $first_col
|
661
|
0 |
235 |
unless defined $last_col
|
664
|
33 |
202 |
if $last_col == 0
|
667
|
1 |
234 |
if $first_col > $last_col
|
675
|
18 |
217 |
if ref $format
|
676
|
6 |
229 |
if $width and $hidden
|
678
|
0 |
235 |
if $self->_check_dimensions(0, $first_col, $ignore_row, $ignore_col)
|
680
|
2 |
233 |
if $self->_check_dimensions(0, $last_col, $ignore_row, $ignore_col)
|
684
|
232 |
1 |
unless defined $level
|
685
|
0 |
233 |
if $level < 0
|
686
|
0 |
233 |
if $level > 7
|
688
|
1 |
232 |
if ($level > $self->{'_outline_col_level'})
|
700
|
28 |
205 |
unless defined $width
|
704
|
18 |
398 |
if $format
|
722
|
33 |
0 |
if ($cell =~ /^\D/)
|
731
|
0 |
33 |
if @data < 3
|
741
|
32 |
1 |
if ($pixels)
|
763
|
0 |
36 |
unless @_
|
766
|
33 |
3 |
if ($_[0] =~ /^\D/)
|
772
|
28 |
8 |
if (@_ == 2) { }
|
|
8 |
0 |
elsif (@_ == 4) { }
|
786
|
3 |
5 |
if ($row_first > $row_last)
|
790
|
3 |
5 |
if ($col_first > $col_last)
|
804
|
4 |
32 |
if $sqref eq "A1"
|
820
|
0 |
66 |
unless @_
|
823
|
10 |
56 |
if ($_[0] =~ /^\D/)
|
903
|
0 |
2 |
defined $_[0] ? :
|
933
|
19 |
0 |
if ($paper_size)
|
957
|
0 |
34 |
if (length $string > 255)
|
963
|
1 |
33 |
if (defined $options->{'align_with_margins'})
|
967
|
1 |
33 |
if (defined $options->{'scale_with_doc'})
|
974
|
21 |
13 |
if ($options->{'image_left'})
|
978
|
8 |
26 |
if ($options->{'image_center'})
|
982
|
5 |
29 |
if ($options->{'image_right'})
|
989
|
0 |
34 |
if ($image_count != $placeholder_count)
|
996
|
23 |
11 |
if ($image_count)
|
1023
|
0 |
15 |
if (length $string > 255)
|
1029
|
1 |
14 |
if (defined $options->{'align_with_margins'})
|
1033
|
1 |
14 |
if (defined $options->{'scale_with_doc'})
|
1040
|
4 |
11 |
if ($options->{'image_left'})
|
1044
|
3 |
12 |
if ($options->{'image_center'})
|
1048
|
5 |
10 |
if ($options->{'image_right'})
|
1055
|
0 |
15 |
if ($image_count != $placeholder_count)
|
1062
|
6 |
9 |
if ($image_count)
|
1162
|
5 |
0 |
if (defined $margin) { }
|
1182
|
5 |
0 |
if (defined $margin) { }
|
1202
|
5 |
0 |
if (defined $margin) { }
|
1223
|
5 |
0 |
if (defined $margin) { }
|
1270
|
3 |
0 |
if ($_[0] =~ /^\D/)
|
1307
|
9 |
0 |
if ($_[0] =~ /^\D/)
|
1311
|
0 |
9 |
if @_ != 4
|
1316
|
1 |
8 |
if ($row1 == 0 and $col1 == 0 and $row2 == $self->{'_xls_rowmax'} - 1 and $col2 == $self->{'_xls_colmax'} - 1)
|
1342
|
30 |
2 |
if ($_[0] =~ /^\D/)
|
1346
|
0 |
32 |
if @_ != 4
|
1351
|
0 |
32 |
if $row2 < $row1
|
1352
|
0 |
32 |
if $col2 < $col1
|
1377
|
0 |
25 |
unless $self->{'_autofilter'}
|
1378
|
0 |
25 |
unless @_ == 2
|
1383
|
24 |
1 |
if ($col =~ /^\D/)
|
1389
|
0 |
24 |
if $col >= $self->{'_xls_colmax'}
|
1395
|
0 |
25 |
if ($col < $col_first or $col > $col_last)
|
1403
|
0 |
25 |
unless @tokens == 3 or @tokens == 7
|
1411
|
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) { }
|
1450
|
0 |
14 |
unless $self->{'_autofilter'}
|
1451
|
0 |
14 |
unless @tokens
|
1455
|
5 |
9 |
if ($col =~ /^\D/)
|
1461
|
0 |
5 |
if $col >= $self->{'_xls_colmax'}
|
1467
|
0 |
14 |
if ($col < $col_first or $col > $col_last)
|
1497
|
2 |
65 |
unless $expression
|
1532
|
10 |
39 |
if (@tokens == 7) { }
|
1536
|
5 |
5 |
if ($conditional =~ /^(and|&&)$/) { }
|
|
5 |
0 |
elsif ($conditional =~ /^(or|\|\|)$/) { }
|
1594
|
4 |
55 |
if ($tokens[0] =~ /^top|bottom$/i)
|
1598
|
0 |
4 |
if ($value =~ /\D/ or $value < 1 or $value > 500)
|
1608
|
0 |
4 |
if ($token ne "items" and $token ne "%")
|
1613
|
2 |
2 |
if ($tokens[0] =~ /^top$/i) { }
|
1620
|
2 |
2 |
if ($tokens[2] eq "%")
|
1628
|
0 |
0 |
if (not $operator and $tokens[0])
|
1635
|
7 |
52 |
if ($token =~ /^blanks|nonblanks$/i)
|
1638
|
0 |
7 |
if ($operator != 2 and $operator != 5)
|
1647
|
4 |
3 |
if ($token eq 'blanks') { }
|
1648
|
1 |
3 |
if ($operator == 5)
|
1653
|
1 |
2 |
if ($operator == 5) { }
|
1667
|
3 |
56 |
if ($operator == 2 and $token =~ /[*?]/)
|
1704
|
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) { }
|
1720
|
1 |
39 |
if ($range1 eq $range2 and not $row_col_only) { }
|
1747
|
9 |
3 |
defined $_[0] ? :
|
1750
|
5 |
7 |
if ($option == 0) { }
|
|
4 |
3 |
elsif ($option == 1) { }
|
1776
|
0 |
2 |
defined $_[0] ? :
|
1778
|
2 |
0 |
if ($headers) { }
|
1813
|
5 |
1 |
defined $_[0] ? :
|
1814
|
4 |
2 |
defined $_[1] ? :
|
1859
|
0 |
3 |
if ($scale < 10 or $scale > 400)
|
1880
|
0 |
3 |
if ($scale < 10 or $scale > 400)
|
1918
|
0 |
0 |
if (defined $_[0]) { }
|
1937
|
0 |
2 |
defined $_[0] ? :
|
1951
|
44 |
0 |
if defined $_[0]
|
1965
|
0 |
1 |
defined $_[0] ? :
|
1979
|
0 |
1 |
defined $_[0] ? :
|
1992
|
0 |
2 |
defined $_[0] ? :
|
1994
|
2 |
0 |
if ($page_order) { }
|
2013
|
0 |
3 |
unless defined $_[0]
|
2033
|
0 |
0 |
if $row > $self->{'_xls_rowmax'}
|
2034
|
0 |
0 |
if $col > $self->{'_xls_colmax'}
|
2051
|
0 |
0 |
unless @_ == 2
|
2052
|
0 |
0 |
unless ref $_[1] eq "CODE"
|
2072
|
1112 |
9876 |
if ($_[0] =~ /^\D/)
|
2079
|
20 |
10968 |
unless defined $token
|
2087
|
0 |
0 |
if ($token =~ /$re/)
|
2089
|
0 |
0 |
if defined $match
|
2095
|
1044 |
9944 |
if (ref $token eq 'ARRAY') { }
|
|
0 |
9944 |
elsif ($self->{'_leading_zeros'} and $token =~ /^0\d+$/) { }
|
|
7736 |
2208 |
elsif ($token =~ /^([+-]?)(?=[0-9]|\.[0-9])[0-9]*(\.[0-9]*)?([Ee]([+-]?[0-9]+))?$/) { }
|
|
14 |
2194 |
elsif ($token =~ m[^[fh]tt?ps?://]) { }
|
|
0 |
2194 |
elsif ($token =~ /^mailto:/) { }
|
|
0 |
2194 |
elsif ($token =~ /^(?:in|ex)ternal:/) { }
|
|
21 |
2173 |
elsif ($token =~ /^=/) { }
|
|
2 |
2171 |
elsif ($token =~ /^{=.*}$/) { }
|
|
31 |
2140 |
elsif ($token eq '') { }
|
2163
|
7 |
1044 |
if ($_[0] =~ /^\D/)
|
2168
|
0 |
1051 |
if (ref $_[2] ne "ARRAY")
|
2182
|
1198 |
2778 |
if (ref $token eq 'ARRAY') { }
|
2214
|
19 |
1200 |
if ($_[0] =~ /^\D/)
|
2219
|
0 |
1219 |
if (ref $_[2] ne "ARRAY")
|
2259
|
70 |
4096 |
if ($_[0] =~ /^\D/)
|
2263
|
0 |
4166 |
if (@_ < 3)
|
2269
|
0 |
4166 |
unless @_ % 2
|
2272
|
4 |
4162 |
if $self->_check_dimensions($row, $col)
|
2299
|
0 |
7752 |
if ($_[0] =~ /^\D/)
|
2303
|
0 |
7752 |
if (@_ < 3)
|
2313
|
3 |
7749 |
if $self->_check_dimensions($row, $col)
|
2316
|
2 |
7747 |
if ($self->{'_optimization'} == 1 and $row > $self->{'_previous_row'})
|
2343
|
51 |
2971 |
if ($_[0] =~ /^\D/)
|
2347
|
0 |
3022 |
if (@_ < 3)
|
2358
|
0 |
3022 |
unless defined $str
|
2361
|
4 |
3018 |
if $self->_check_dimensions($row, $col)
|
2364
|
0 |
3018 |
if (length $str > $self->{'_xls_strmax'})
|
2370
|
2724 |
294 |
if ($self->{'_optimization'} == 0) { }
|
2378
|
280 |
2738 |
if ($self->{'_optimization'} == 1 and $row > $self->{'_previous_row'})
|
2407
|
28 |
1 |
if ($_[0] =~ /^\D/)
|
2411
|
0 |
29 |
if (@_ < 3)
|
2423
|
0 |
29 |
if $self->_check_dimensions($row, $col)
|
2427
|
3 |
26 |
if (ref $_[-1])
|
2434
|
0 |
29 |
unless open my $str_fh, ">", \$str
|
2452
|
81 |
33 |
if (not ref $token) { }
|
2455
|
25 |
56 |
if ($last ne 'format') { }
|
2472
|
1 |
32 |
if ($last eq "format" and $pos > 0)
|
2486
|
24 |
4 |
unless (ref $fragments[0])
|
2492
|
56 |
80 |
if (ref $token) { }
|
2503
|
10 |
70 |
if ($token =~ /^\s/ or $token =~ /\s$/)
|
2513
|
0 |
28 |
if ($length > $self->{'_xls_strmax'})
|
2519
|
20 |
8 |
if ($self->{'_optimization'} == 0) { }
|
2527
|
8 |
20 |
if ($self->{'_optimization'} == 1 and $row > $self->{'_previous_row'})
|
2558
|
0 |
90 |
if ($_[0] =~ /^\D/)
|
2563
|
0 |
90 |
if @_ < 2
|
2566
|
24 |
66 |
unless defined $_[2]
|
2574
|
3 |
63 |
if $self->_check_dimensions($row, $col)
|
2577
|
0 |
63 |
if ($self->{'_optimization'} == 1 and $row > $self->{'_previous_row'})
|
2604
|
25 |
96 |
if ($_[0] =~ /^\D/)
|
2608
|
0 |
121 |
if (@_ < 3)
|
2618
|
3 |
118 |
if ($formula =~ /^{=.*}$/)
|
2624
|
3 |
115 |
if $self->_check_dimensions($row, $col)
|
2630
|
0 |
115 |
if ($self->{'_optimization'} == 1 and $row > $self->{'_previous_row'})
|
2646
|
6 |
8 |
if ($_[0] =~ /^\D/)
|
2650
|
0 |
14 |
if (@_ < 5)
|
2662
|
1 |
13 |
if $row1 > $row2
|
2663
|
1 |
13 |
if $col1 > $col2
|
2666
|
2 |
12 |
if $self->_check_dimensions($row1, $col1)
|
2667
|
3 |
9 |
if $self->_check_dimensions($row2, $col2)
|
2672
|
5 |
4 |
if ($row1 == $row2 and $col1 == $col2) { }
|
2688
|
0 |
9 |
if ($self->{'_optimization'} == 1 and $row > $self->{'_previous_row'})
|
2697
|
9 |
0 |
unless ($self->{'_optimization'})
|
2700
|
9 |
8 |
if $row == $row1 and $col == $col1
|
2749
|
1 |
0 |
if ($error == 0)
|
2771
|
4 |
0 |
if ($_[0] =~ /^\D/)
|
2777
|
2 |
2 |
$_[2] ? :
|
2782
|
0 |
4 |
if $self->_check_dimensions($row, $col)
|
2785
|
0 |
4 |
if ($self->{'_optimization'} == 1 and $row > $self->{'_previous_row'})
|
2806
|
1 |
0 |
defined $_[0] ? :
|
2807
|
1 |
0 |
defined $_[1] ? :
|
2808
|
1 |
0 |
defined $_[2] ? :
|
2824
|
1 |
102 |
if $url =~ /%[0-9a-fA-F]{2}/
|
2864
|
68 |
15 |
if ($_[0] =~ /^\D/)
|
2868
|
0 |
83 |
if (@_ < 3)
|
2875
|
13 |
70 |
if (defined $args[3] and not ref $args[3])
|
2890
|
69 |
14 |
unless defined $str
|
2893
|
8 |
75 |
if ($url =~ s/^internal://)
|
2900
|
15 |
68 |
if ($url =~ s/^external://)
|
2911
|
0 |
83 |
if $self->_check_dimensions($row, $col)
|
2915
|
0 |
83 |
if (length $str > $self->{'_xls_strmax'})
|
2925
|
75 |
8 |
if ($link_type == 1)
|
2933
|
4 |
71 |
if ($url_str and not $external)
|
2939
|
9 |
66 |
if ($url =~ /^\w:/ or $url =~ /^\\\\/)
|
2951
|
1 |
82 |
if (length $url > $max_url or length $tmp_url_str > $max_url)
|
2961
|
0 |
82 |
if ($self->{'_hlink_count'} > 65530)
|
2969
|
0 |
82 |
if ($self->{'_optimization'} == 1 and $row > $self->{'_previous_row'})
|
2974
|
65 |
17 |
unless (defined $xf)
|
3010
|
12 |
117 |
if ($_[0] =~ /^\D/)
|
3014
|
0 |
129 |
if (@_ < 3)
|
3024
|
0 |
129 |
if $self->_check_dimensions($row, $col)
|
3030
|
0 |
129 |
unless (defined $date_time)
|
3035
|
0 |
129 |
if ($self->{'_optimization'} == 1 and $row > $self->{'_previous_row'})
|
3083
|
1 |
767 |
if $date_time =~ /[^0-9T:\-\.Z]/
|
3086
|
2 |
765 |
unless $date_time =~ /\dT|T\d/
|
3097
|
206 |
559 |
if ($time ne "")
|
3100
|
206 |
0 |
if ($time =~ /^(\d\d):(\d\d)(:(\d\d(\.\d+)?))?/) { }
|
3110
|
1 |
205 |
if $hour >= 24
|
3111
|
1 |
204 |
if $min >= 60
|
3112
|
2 |
202 |
if $sec >= 60
|
3120
|
2 |
759 |
if $date eq ""
|
3124
|
757 |
2 |
if ($date =~ /^(\d\d\d\d)-(\d\d)-(\d\d)$/) { }
|
3138
|
542 |
215 |
unless ($date_1904)
|
3139
|
104 |
438 |
if $date eq "1899-12-31"
|
3140
|
1 |
437 |
if $date eq "1900-01-00"
|
3141
|
1 |
436 |
if $date eq "1900-02-29"
|
3150
|
215 |
436 |
$date_1904 ? :
|
3151
|
215 |
436 |
$date_1904 ? :
|
3159
|
213 |
438 |
if $year % 4 == 0 and $year % 100 or $year % 400 == 0
|
3160
|
213 |
438 |
if $leap
|
3164
|
6 |
645 |
if $year < $epoch or $year > 9999
|
3165
|
6 |
639 |
if $month < 1 or $month > 12
|
3166
|
6 |
633 |
if $day < 1 or $day > $mdays[$month - 1]
|
3179
|
423 |
210 |
if $date_1904 == 0 and $days > 59
|
3202
|
0 |
427 |
unless defined $row
|
3208
|
390 |
37 |
if (defined $self->{'_dim_colmin'})
|
3213
|
0 |
427 |
if $self->_check_dimensions($row, $min_col)
|
3215
|
319 |
108 |
unless defined $height
|
3218
|
1 |
426 |
if ($height == 0)
|
3224
|
0 |
427 |
if $level < 0
|
3225
|
0 |
427 |
if $level > 7
|
3227
|
11 |
416 |
if ($level > $self->{'_outline_row_level'})
|
3256
|
22 |
1 |
if ($height)
|
3276
|
5 |
1 |
if ($height != $self->{'_original_row_height'})
|
3283
|
3 |
3 |
if ($zero_height)
|
3301
|
12 |
12 |
if ($_[0] =~ /^\D/)
|
3304
|
0 |
24 |
if @_ < 6
|
3305
|
0 |
24 |
unless ref $_[5]
|
3316
|
0 |
24 |
if ($row_first == $row_last and $col_first == $col_last)
|
3321
|
1 |
23 |
if $row_first > $row_last
|
3323
|
1 |
23 |
if $col_first > $col_last
|
3327
|
0 |
24 |
if $self->_check_dimensions($row_first, $col_first)
|
3328
|
4 |
20 |
if $self->_check_dimensions($row_last, $col_last)
|
3339
|
20 |
48 |
if $row == $row_first and $col == $col_first
|
3358
|
7 |
0 |
if ($_[0] =~ /^\D/)
|
3369
|
2 |
5 |
if ($type eq 'array_formula' or $type eq 'blank' or $type eq 'rich_string') { }
|
3384
|
0 |
7 |
unless ref $format
|
3388
|
0 |
7 |
if ($row_first == $row_last and $col_first == $col_last)
|
3393
|
0 |
7 |
if $row_first > $row_last
|
3395
|
0 |
7 |
if $col_first > $col_last
|
3399
|
0 |
7 |
if $self->_check_dimensions($row_first, $col_first)
|
3400
|
0 |
7 |
if $self->_check_dimensions($row_last, $col_last)
|
3406
|
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') { }
|
3437
|
7 |
7 |
if $row == $row_first and $col == $col_first
|
3467
|
63 |
5 |
if ($_[0] =~ /^\D/)
|
3472
|
0 |
68 |
if (@_ != 5 and @_ != 3)
|
3479
|
63 |
5 |
unless (defined $row2)
|
3485
|
0 |
68 |
if $self->_check_dimensions($row1, $col1, 1, 1)
|
3486
|
0 |
68 |
if $self->_check_dimensions($row2, $col2, 1, 1)
|
3489
|
0 |
68 |
if (ref $options ne "HASH")
|
3519
|
0 |
262 |
unless (exists $valid_parameter{$param_key})
|
3526
|
5 |
63 |
if defined $param->{'source'}
|
3527
|
24 |
44 |
if defined $param->{'minimum'}
|
3530
|
0 |
68 |
unless (exists $param->{'validate'})
|
3554
|
0 |
68 |
if (not exists $valid_type{lc $param->{'validate'}}) { }
|
3565
|
1 |
2 |
if ($param->{'validate'} eq "none" and not defined $param->{'input_message'} and not defined $param->{'input_title'})
|
3574
|
16 |
49 |
if ($param->{'validate'} eq "none" or $param->{'validate'} eq "list" or $param->{'validate'} eq "custom")
|
3583
|
0 |
67 |
unless (exists $param->{'criteria'})
|
3610
|
0 |
67 |
if (not exists $criteria_type{lc $param->{'criteria'}}) { }
|
3621
|
42 |
25 |
if ($param->{'criteria'} eq 'between' or $param->{'criteria'} eq 'notBetween') { }
|
3623
|
0 |
42 |
unless (exists $param->{'maximum'})
|
3642
|
65 |
2 |
if (not exists $param->{'error_type'}) { }
|
|
0 |
2 |
elsif (not exists $error_type{lc $param->{'error_type'}}) { }
|
3656
|
7 |
60 |
if ($param->{'validate'} eq "date" or $param->{'validate'} eq "time")
|
3659
|
5 |
2 |
if (defined $date_time)
|
3663
|
3 |
4 |
if (defined $param->{'maximum'})
|
3666
|
2 |
1 |
if (defined $date_time)
|
3673
|
1 |
66 |
if ($param->{'input_title'} and length $param->{'input_title'} > 32)
|
3680
|
0 |
66 |
if ($param->{'error_title'} and length $param->{'error_title'} > 32)
|
3687
|
1 |
65 |
if ($param->{'input_message'} and length $param->{'input_message'} > 255)
|
3694
|
0 |
65 |
if ($param->{'error_message'} and length $param->{'error_message'} > 255)
|
3701
|
13 |
52 |
if ($param->{'validate'} eq "list")
|
3703
|
11 |
2 |
if (ref $param->{'value'} eq "ARRAY")
|
3706
|
1 |
10 |
if (length $formula > 255)
|
3715
|
62 |
2 |
unless defined $param->{'ignore_blank'}
|
3716
|
63 |
1 |
unless defined $param->{'dropdown'}
|
3717
|
61 |
3 |
unless defined $param->{'show_input'}
|
3718
|
62 |
2 |
unless defined $param->{'show_error'}
|
3725
|
3 |
61 |
if (exists $param->{'other_cells'})
|
3757
|
149 |
0 |
if ($_[0] =~ /^\D/)
|
3760
|
1 |
148 |
if ($_[0] =~ /,/)
|
3775
|
74 |
75 |
unless (defined $row2)
|
3781
|
0 |
149 |
if $self->_check_dimensions($row1, $col1, 1, 1)
|
3782
|
0 |
149 |
if $self->_check_dimensions($row2, $col2, 1, 1)
|
3785
|
0 |
149 |
if (ref $options ne "HASH")
|
3832
|
0 |
492 |
unless (exists $valid_parameter{$param_key})
|
3839
|
0 |
149 |
unless (exists $param->{'type'})
|
3869
|
0 |
149 |
if (not exists $valid_type{lc $param->{'type'}}) { }
|
3875
|
2 |
147 |
if $param->{'type'} eq "bottom"
|
3914
|
53 |
96 |
if (defined $param->{'criteria'} and exists $criteria_type{lc $param->{'criteria'}})
|
3921
|
2 |
147 |
if ($param->{'type'} eq "date" or $param->{'type'} eq "time")
|
3924
|
1 |
1 |
if (defined $param->{'value'} and $param->{'value'} =~ /T/)
|
3927
|
0 |
1 |
if (not defined $date_time) { }
|
3937
|
1 |
1 |
if (defined $param->{'minimum'} and $param->{'minimum'} =~ /T/)
|
3940
|
0 |
1 |
if (not defined $date_time) { }
|
3950
|
1 |
1 |
if (defined $param->{'maximum'} and $param->{'maximum'} =~ /T/)
|
3953
|
0 |
1 |
if (not defined $date_time) { }
|
3988
|
37 |
112 |
if ($param->{'type'} eq "iconSet")
|
3990
|
0 |
37 |
unless (defined $param->{'icon_style'})
|
3997
|
0 |
37 |
if (not exists $icon_set_styles{$param->{'icon_style'}}) { }
|
4008
|
11 |
26 |
if ($param->{'icon_style'} =~ /^4/) { }
|
|
8 |
18 |
elsif ($param->{'icon_style'} =~ /^5/) { }
|
4025
|
0 |
149 |
if ($row1 > $row2)
|
4029
|
0 |
149 |
if ($col1 > $col2)
|
4037
|
1 |
148 |
if ($user_range)
|
4042
|
27 |
122 |
if (defined $param->{'format'} and ref $param->{'format'})
|
4050
|
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'})
|
4067
|
8 |
141 |
if ($param->{'type'} eq "text")
|
4069
|
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') { }
|
4096
|
10 |
139 |
if ($param->{'type'} eq "timePeriod")
|
4098
|
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') { }
|
4157
|
1 |
148 |
if ($param->{'type'} eq "containsBlanks")
|
4161
|
1 |
148 |
if ($param->{'type'} eq "notContainsBlanks")
|
4165
|
1 |
148 |
if ($param->{'type'} eq "containsErrors")
|
4169
|
1 |
148 |
if ($param->{'type'} eq "notContainsErrors")
|
4175
|
1 |
148 |
if ($param->{'type'} eq "2_color_scale")
|
4198
|
4 |
145 |
if ($param->{'type'} eq "3_color_scale")
|
4208
|
3 |
1 |
unless defined $param->{'mid_value'}
|
4221
|
29 |
120 |
if ($param->{'type'} eq "dataBar")
|
4226
|
22 |
7 |
if (not defined $param->{'min_type'}) { }
|
4234
|
23 |
6 |
if (not defined $param->{'max_type'}) { }
|
4275
|
25 |
124 |
if ($param->{'_is_data_bar_2010'})
|
4279
|
20 |
5 |
if ($param->{'min_type'} eq "min" and $param->{'min_value'} == 0)
|
4283
|
21 |
4 |
if ($param->{'max_type'} eq "max" and $param->{'max_value'} == 0)
|
4292
|
14 |
135 |
if defined $param->{'min_value'}
|
4293
|
5 |
144 |
if defined $param->{'mid_value'}
|
4294
|
13 |
136 |
if defined $param->{'max_value'}
|
4323
|
18 |
19 |
if ($total_icons == 3)
|
4328
|
11 |
26 |
if ($total_icons == 4)
|
4334
|
8 |
29 |
if ($total_icons == 5)
|
4342
|
13 |
24 |
if (defined $user_props)
|
4346
|
2 |
11 |
if ($max_data >= $total_icons)
|
4353
|
24 |
6 |
if (defined $user_props->[$i]{'value'})
|
4359
|
14 |
16 |
if (defined $user_props->[$i]{'type'})
|
4363
|
0 |
14 |
if ($type ne 'percent' and $type ne 'percentile' and $type ne 'number' and $type ne 'formula') { }
|
4374
|
2 |
12 |
if ($props->[$i]{'type'} eq "number")
|
4381
|
7 |
23 |
if (defined $user_props->[$i]{'criteria'} and $user_props->[$i]{'criteria'} eq ">")
|
4411
|
0 |
52 |
if ($self->{'_optimization'} == 1)
|
4417
|
52 |
0 |
if (@_ and $_[0] =~ /^\D/)
|
4422
|
0 |
52 |
if (@_ < 4)
|
4430
|
0 |
52 |
if $self->_check_dimensions($row1, $col1, 1, 1)
|
4431
|
0 |
52 |
if $self->_check_dimensions($row2, $col2, 1, 1)
|
4434
|
0 |
52 |
if ($row1 > $row2)
|
4438
|
0 |
52 |
if ($col1 > $col2)
|
4446
|
0 |
52 |
if (ref $param ne "HASH")
|
4469
|
0 |
46 |
unless (exists $valid_parameter{$param_key})
|
4476
|
51 |
1 |
unless defined $param->{'banded_rows'}
|
4477
|
47 |
5 |
unless defined $param->{'header_row'}
|
4478
|
51 |
1 |
unless defined $param->{'autofilter'}
|
4482
|
48 |
4 |
if $param->{'header_row'}
|
4484
|
2 |
50 |
if ($num_rows < 0)
|
4490
|
1 |
49 |
$param->{'first_column'} ? :
|
4491
|
1 |
49 |
$param->{'last_column'} ? :
|
4492
|
49 |
1 |
$param->{'banded_rows'} ? :
|
4493
|
1 |
49 |
$param->{'banded_columns'} ? :
|
4494
|
46 |
4 |
$param->{'header_row'} ? :
|
4495
|
10 |
40 |
$param->{'total_row'} ? :
|
4499
|
1 |
49 |
if (defined $param->{'name'})
|
4503
|
0 |
1 |
if (not $name =~ /^[\w\\][\w\\.]*$/ or $name =~ /^\d/)
|
4509
|
0 |
1 |
if ($name =~ /^[a-zA-Z][a-zA-Z]?[a-dA-D]?[0-9]+$/)
|
4515
|
0 |
1 |
if ($name =~ /^[rcRC]$/ or $name =~ /^[rcRC]\d+[rcRC]\d+$/)
|
4524
|
3 |
47 |
if (defined $param->{'style'}) { }
|
4538
|
46 |
4 |
if $param->{'header_row'}
|
4539
|
10 |
40 |
if $param->{'total_row'}
|
4548
|
4 |
46 |
unless ($param->{'header_row'})
|
4553
|
45 |
5 |
if ($param->{'autofilter'})
|
4574
|
85 |
131 |
if ($param->{'columns'})
|
4577
|
84 |
1 |
if (my $user_data = $param->{'columns'}[$col_id - 1])
|
4581
|
12 |
72 |
if $user_data->{'header'}
|
4586
|
1 |
83 |
if (exists $seen_names{$key}) { }
|
4598
|
3 |
80 |
if ($user_data->{'formula'})
|
4616
|
40 |
43 |
if ($user_data->{'total_function'}) { }
|
|
9 |
34 |
elsif ($user_data->{'total_string'}) { }
|
4624
|
4 |
36 |
if $function eq "countnums"
|
4625
|
4 |
36 |
if $function eq "stddev"
|
4652
|
9 |
74 |
if (defined $user_data->{'format'} and ref $user_data->{'format'})
|
4668
|
203 |
12 |
if ($param->{'header_row'})
|
4678
|
6 |
43 |
if (my $data = $param->{'data'})
|
4688
|
77 |
7 |
if (defined $token)
|
4719
|
0 |
58 |
if (ref $param ne "HASH")
|
4756
|
0 |
212 |
unless (exists $valid_parameter{$param_key})
|
4763
|
0 |
58 |
unless (exists $param->{'location'})
|
4769
|
0 |
58 |
unless (exists $param->{'range'})
|
4778
|
0 |
9 |
if ($type ne "line" and $type ne "column" and $type ne "win_loss")
|
4784
|
1 |
57 |
if $type eq "win_loss"
|
4789
|
2 |
56 |
if (ref $param->{'location'}) { }
|
4802
|
0 |
58 |
if ($range_count != $location_count)
|
4824
|
54 |
5 |
unless ($range =~ /!/)
|
4851
|
1 |
57 |
if ($empty eq 'zero') { }
|
|
1 |
56 |
elsif ($empty eq 'connect') { }
|
4865
|
1 |
57 |
if ($date_range and not $date_range =~ /!/)
|
4907
|
28 |
0 |
if ($_[0] =~ /^\D/)
|
4912
|
0 |
28 |
if (@_ < 3)
|
4933
|
2 |
5 |
if ($vba_codename) { }
|
4968
|
0 |
6 |
unless (exists $valid_parameter{$param_key})
|
5014
|
40 |
0 |
if (exists $subtotals{$function}) { }
|
5040
|
398 |
8 |
unless $param->{$user_color}
|
5061
|
167 |
6 |
if ($index =~ /^#([0-9A-F]{6})$/i)
|
5091
|
226 |
2397 |
if ($cell =~ /\$?([A-Z]{1,3}):\$?([A-Z]{1,3})/)
|
5099
|
200 |
2197 |
if ($cell =~ /\$?([A-Z]{1,3}\$?\d+):\$?([A-Z]{1,3}\$?\d+)/)
|
5106
|
2197 |
0 |
if ($cell =~ /\$?([A-Z]{1,3}\$?\d+)/)
|
5135
|
3049 |
0 |
$1 eq '' ? :
|
5137
|
3047 |
2 |
$3 eq '' ? :
|
5190
|
2149 |
11 |
unless @_
|
5197
|
6 |
5 |
if $array[0] == 0
|
5202
|
1 |
10 |
if @array > $max_num_breaks
|
5229
|
0 |
16892 |
unless defined $row
|
5230
|
13 |
16879 |
if $row >= $self->{'_xls_rowmax'}
|
5232
|
0 |
16879 |
unless defined $col
|
5233
|
10 |
16869 |
if $col >= $self->{'_xls_colmax'}
|
5237
|
318 |
16551 |
if (not $ignore_row || $ignore_col and $self->{'_optimization'} == 1)
|
5238
|
5 |
313 |
if $row < $self->{'_previous_row'}
|
5241
|
15858 |
1006 |
unless ($ignore_row)
|
5243
|
859 |
14999 |
if (not defined $self->{'_dim_rowmin'} or $row < $self->{'_dim_rowmin'})
|
5247
|
4799 |
11059 |
if (not defined $self->{'_dim_rowmax'} or $row > $self->{'_dim_rowmax'})
|
5252
|
15906 |
958 |
unless ($ignore_col)
|
5254
|
866 |
15040 |
if (not defined $self->{'_dim_colmin'} or $col < $self->{'_dim_colmin'})
|
5258
|
2366 |
13540 |
if (not defined $self->{'_dim_colmax'} or $col > $self->{'_dim_colmax'})
|
5350
|
1 |
4768 |
if $x1 < 0
|
5351
|
1 |
4768 |
if $y1 < 0
|
5354
|
56 |
4713 |
if ($self->{'_col_size_changed'}) { }
|
5368
|
24 |
4745 |
if ($self->{'_row_size_changed'}) { }
|
5397
|
4769 |
0 |
if ($self->_size_col($col_start, $anchor) > 0)
|
5401
|
4769 |
0 |
if ($self->_size_row($row_start, $anchor) > 0)
|
5538
|
177 |
37392 |
if (exists $self->{'_col_sizes'}{$col}) { }
|
5544
|
18 |
159 |
if ($hidden == 1 and $anchor != 4) { }
|
|
0 |
159 |
elsif ($width < 1) { }
|
5578
|
74 |
60453 |
if (exists $self->{'_row_sizes'}{$row}) { }
|
5582
|
10 |
64 |
if ($hidden == 1 and $anchor != 4) { }
|
5610
|
25 |
1798 |
if ($pixels <= 12) { }
|
5648
|
1141 |
1603 |
unless (exists ${$$self{"_str_table"};}->{$str})
|
5670
|
447 |
152 |
if (not defined $target) { }
|
|
4 |
148 |
elsif (exists $self->{'_drawing_rels'}{$target}) { }
|
5695
|
10 |
36 |
if (exists $self->{'_vml_drawing_rels'}{$target}) { }
|
5718
|
406 |
0 |
if ($_[0] =~ /^\D/)
|
5731
|
0 |
406 |
unless @_ >= 3
|
5733
|
406 |
0 |
if (ref $chart)
|
5736
|
0 |
406 |
unless $chart->isa("Excel::Writer::XLSX::Chart")
|
5741
|
0 |
406 |
unless $chart->{'_embedded'}
|
5745
|
3 |
403 |
if (ref $_[3] eq 'HASH') { }
|
5764
|
0 |
406 |
if ($chart->{'_already_inserted'} or $chart->{'_combined'} and $chart->{'_combined'}{'_already_inserted'}) { }
|
5773
|
10 |
396 |
if ($chart->{'_combined'})
|
5779
|
1 |
405 |
if $chart->{'_x_scale'} != 1
|
5780
|
1 |
405 |
if $chart->{'_y_scale'} != 1
|
5781
|
1 |
405 |
if $chart->{'_x_offset'}
|
5782
|
1 |
405 |
if $chart->{'_y_offset'}
|
5810
|
406 |
0 |
if $chart->{'_width'}
|
5811
|
406 |
0 |
if $chart->{'_height'}
|
5824
|
394 |
12 |
if (not $self->{'_drawing'}) { }
|
5869
|
0 |
1167 |
if $self->{'_optimization'}
|
5880
|
5 |
5520 |
unless (exists $self->{'_table'}{$row_num})
|
5887
|
5516 |
4 |
if (my $cell = $self->{'_table'}{$row_num}{$col_num}) { }
|
5893
|
5488 |
28 |
if ($type eq 'n') { }
|
|
28 |
0 |
elsif ($type eq 's') { }
|
|
0 |
0 |
elsif ($type eq 'f') { }
|
|
0 |
0 |
elsif ($type eq 'a' or $type eq 'd') { }
|
|
0 |
0 |
elsif ($type eq 'b') { }
|
5901
|
28 |
0 |
if ($self->{'_optimization'} == 0) { }
|
5947
|
124 |
2 |
if ($_[0] =~ /^\D/)
|
5964
|
40 |
86 |
if (ref $_[3] eq 'HASH') { }
|
5986
|
0 |
126 |
unless @_ >= 3
|
5987
|
0 |
126 |
unless -e $image
|
6041
|
99 |
27 |
if (not $self->{'_drawing'}) { }
|
6068
|
2 |
124 |
if (defined $description)
|
6072
|
26 |
100 |
if ($url)
|
6077
|
19 |
7 |
if ($url =~ m[^[fh]tt?ps?://] or $url =~ /^mailto:/)
|
6082
|
5 |
21 |
if ($url =~ s/^external://)
|
6089
|
4 |
1 |
if ($target =~ /^\w:/ or $target =~ /^\\\\/) { }
|
6097
|
2 |
24 |
if ($url =~ s/^internal:/#/)
|
6103
|
0 |
26 |
if (length $target > $max_url) { }
|
6109
|
25 |
1 |
if ($target and not exists $self->{'_drawing_rels'}{$url})
|
6119
|
123 |
3 |
unless (exists $self->{'_drawing_rels'}{$md5})
|
6150
|
36 |
10 |
unless (exists $self->{'_vml_drawing_rels'}{$md5})
|
6173
|
0 |
8 |
unless -e $image
|
6207
|
41 |
4 |
if ($_[0] =~ /^\D/)
|
6212
|
0 |
45 |
unless @_ >= 3
|
6217
|
0 |
45 |
unless $shape->isa("Excel::Writer::XLSX::Shape")
|
6228
|
1 |
44 |
if defined $_[5]
|
6229
|
1 |
44 |
if defined $_[6]
|
6236
|
28 |
62 |
exists $self->{'_shape_hash'}{$id} ? :
|
6239
|
45 |
45 |
if (not $used and $id != 0) { }
|
6255
|
45 |
0 |
if ($shape->{'_stencil'}) { }
|
6301
|
10 |
31 |
if (not $self->{'_drawing'}) { }
|
6370
|
12 |
33 |
$connector_shapes->{$shape_base} ? :
|
6372
|
33 |
12 |
unless $shape->{'_connect'}
|
6375
|
0 |
12 |
unless $shape->{'_start'} and $shape->{'_end'}
|
6378
|
0 |
12 |
unless $shape->{'_start_side'} and $shape->{'_end_side'}
|
6385
|
11 |
1 |
if (defined $slink_id) { }
|
6394
|
10 |
1 |
if (defined $elink_id) { }
|
6412
|
5 |
5 |
if ($connect_type eq 'bt') { }
|
|
5 |
0 |
elsif ($connect_type eq 'rl') { }
|
6424
|
3 |
2 |
$smidx < $emidx ? :
|
6427
|
2 |
3 |
if ($sy > $ey)
|
6432
|
1 |
1 |
if ($#{$$shape{"_adjustments"};} < 0)
|
6448
|
1 |
4 |
if $smidx < $emidx and $smidy > $emidy
|
6449
|
1 |
4 |
if $smidx > $emidx and $smidy < $emidy
|
6450
|
2 |
3 |
if ($smidx > $emidx)
|
6453
|
1 |
1 |
if ($#{$$shape{"_adjustments"};} < 0)
|
6478
|
0 |
41 |
unless (grep /^$shape->{'_align'}$/, ("l", "ctr", "r", "just"))
|
6483
|
0 |
41 |
if (not grep(/^$shape->{'_valign'}$/, ("t", "ctr", "b")))
|
6520
|
10 |
4152 |
if ($self->{'_comments_visible'})
|
6521
|
8 |
2 |
unless (defined $self->{'_comments'}{$row}{$col}[4])
|
6527
|
4160 |
2 |
unless (defined $self->{'_comments'}{$row}{$col}[3])
|
6539
|
44 |
14 |
if ($self->{'_has_comments'})
|
6600
|
48 |
1 |
unless (defined $table->{'_name'})
|
6609
|
0 |
49 |
if (exists $seen->{$name}) { }
|
6668
|
0 |
4162 |
unless $params{'width'}
|
6669
|
0 |
4162 |
unless $params{'height'}
|
6675
|
0 |
4162 |
if (length $string > $max_len)
|
6684
|
0 |
4162 |
if ($color_id =~ /^#[0-9A-F]{6}$/i) { }
|
|
4161 |
1 |
elsif ($color_id == 0) { }
|
6706
|
0 |
4162 |
if (defined $params{'start_cell'})
|
6720
|
4162 |
0 |
unless (defined $params{'start_row'})
|
6722
|
53 |
4109 |
if ($row == 0) { }
|
|
0 |
4109 |
elsif ($row == $row_max - 3) { }
|
|
0 |
4109 |
elsif ($row == $row_max - 2) { }
|
|
1 |
4108 |
elsif ($row == $row_max - 1) { }
|
6729
|
4161 |
1 |
unless (defined $params{'y_offset'})
|
6731
|
53 |
4108 |
if ($row == 0) { }
|
|
0 |
4108 |
elsif ($row == $row_max - 3) { }
|
|
0 |
4108 |
elsif ($row == $row_max - 2) { }
|
|
1 |
4107 |
elsif ($row == $row_max - 1) { }
|
6738
|
4162 |
0 |
unless (defined $params{'start_col'})
|
6740
|
0 |
4162 |
if ($col == $col_max - 3) { }
|
|
0 |
4162 |
elsif ($col == $col_max - 2) { }
|
|
1 |
4161 |
elsif ($col == $col_max - 1) { }
|
6746
|
4162 |
0 |
unless (defined $params{'x_offset'})
|
6748
|
0 |
4162 |
if ($col == $col_max - 3) { }
|
|
0 |
4162 |
elsif ($col == $col_max - 2) { }
|
|
1 |
4161 |
elsif ($col == $col_max - 1) { }
|
6756
|
4162 |
0 |
if ($params{'x_scale'})
|
6760
|
4162 |
0 |
if ($params{'y_scale'})
|
6815
|
24 |
4 |
unless (defined $caption)
|
6823
|
5 |
23 |
if ($params->{'macro'}) { }
|
6834
|
27 |
1 |
unless $params->{'width'}
|
6835
|
27 |
1 |
unless $params->{'height'}
|
6838
|
27 |
1 |
unless $params->{'x_offset'}
|
6839
|
27 |
1 |
unless $params->{'y_offset'}
|
6842
|
1 |
27 |
if ($params->{'x_scale'})
|
6846
|
1 |
27 |
if ($params->{'y_scale'})
|
6888
|
1 |
0 |
if $_[0] =~ /^\D/
|
6891
|
0 |
1 |
if @_ < 3
|
6906
|
1 |
0 |
if $_[0] =~ /^\D/
|
6909
|
0 |
1 |
if @_ < 3
|
6935
|
0 |
5 |
if $_[0] =~ /^\D/
|
6937
|
0 |
5 |
if (@_ < 2)
|
6947
|
0 |
5 |
if @pairs % 2
|
6950
|
0 |
5 |
if ref $formula_ref ne "ARRAY"
|
6957
|
0 |
5 |
if (@pairs and $pairs[-2] eq "result")
|
6968
|
6 |
10 |
if $token =~ s/$pattern/$replace/
|
7004
|
23 |
1056 |
if ($self->{'_excel_version'} == 2010)
|
7030
|
1055 |
6 |
unless ($self->{'_fit_page'} or $self->{'_filter_on'} or $self->{'_tab_color'} or $self->{'_outline_changed'} or $self->{'_vba_codename'})
|
7041
|
6 |
20 |
if $codename
|
7042
|
9 |
17 |
if $self->{'_filter_on'}
|
7044
|
11 |
15 |
if ($self->{'_fit_page'} or $self->{'_tab_color'} or $self->{'_outline_changed'}) { }
|
7070
|
4 |
9 |
unless $self->{'_fit_page'}
|
7090
|
274 |
814 |
if (not defined $self->{'_dim_rowmin'} || defined $self->{'_dim_colmin'}) { }
|
|
9 |
805 |
elsif (not defined $self->{'_dim_rowmin'} and defined $self->{'_dim_colmin'}) { }
|
|
139 |
666 |
elsif ($self->{'_dim_rowmin'} == $self->{'_dim_rowmax'} and $self->{'_dim_colmin'} == $self->{'_dim_colmax'}) { }
|
7101
|
6 |
3 |
if ($self->{'_dim_colmin'} == $self->{'_dim_colmax'}) { }
|
7194
|
3 |
1155 |
unless ($gridlines)
|
7199
|
1 |
1157 |
if ($row_col_headers)
|
7204
|
1 |
1157 |
unless ($show_zeros)
|
7209
|
1 |
1157 |
if ($right_to_left)
|
7214
|
1007 |
151 |
if ($tab_selected)
|
7220
|
1 |
1157 |
unless ($self->{'_outline_on'})
|
7226
|
2 |
1156 |
if ($view)
|
7231
|
2 |
1156 |
if ($zoom != 100)
|
7232
|
2 |
0 |
unless $view
|
7234
|
1 |
1 |
if $self->{'_zoom_scale_normal'}
|
7239
|
69 |
1089 |
if (@{$self->{'_panes'};} or @{$self->{'_selections'};}) { }
|
7281
|
88 |
18 |
if $pane
|
7282
|
91 |
15 |
if $active_cell
|
7283
|
91 |
15 |
if $sqref
|
7306
|
4 |
1075 |
if ($self->{'_default_row_height'} != $self->{'_original_row_height'})
|
7310
|
3 |
1076 |
if ($self->{'_default_row_zeroed'})
|
7314
|
5 |
1074 |
if $row_level
|
7315
|
1 |
1078 |
if $col_level
|
7317
|
23 |
1056 |
if ($self->{'_excel_version'} == 2010)
|
7336
|
966 |
112 |
unless %{$self->{'_colinfo'};}
|
7368
|
20 |
216 |
if (ref $format)
|
7373
|
30 |
206 |
if (not defined $width) { }
|
7374
|
17 |
13 |
if (not $hidden) { }
|
7385
|
1 |
205 |
if ($width == "8.43")
|
7395
|
223 |
13 |
if ($width > 0)
|
7396
|
33 |
190 |
if ($width < 1) { }
|
7416
|
20 |
216 |
if $xf_index
|
7417
|
20 |
216 |
if $hidden
|
7418
|
218 |
18 |
if $custom_width
|
7419
|
1 |
235 |
if $level
|
7420
|
0 |
236 |
if $collapsed
|
7437
|
283 |
786 |
if (not defined $self->{'_dim_rowmin'}) { }
|
7464
|
0 |
10 |
if (not defined $self->{'_dim_rowmin'}) { }
|
7506
|
1048908 |
307 |
unless ($self->{'_set_rows'}{$row_num} or $self->{'_table'}{$row_num} or $self->{'_comments'}{$row_num})
|
7517
|
3814 |
414 |
if (my $row_ref = $self->{'_table'}{$row_num}) { }
|
|
307 |
107 |
elsif ($self->{'_comments'}{$row_num}) { }
|
7519
|
3496 |
318 |
if (not $self->{'_set_rows'}{$row_num}) { }
|
7529
|
10377 |
16937 |
if (my $col_ref = $self->{'_table'}{$row_num}{$col_num})
|
7570
|
0 |
0 |
unless ($self->{'_set_rows'}{$row_num} or $self->{'_table'}{$row_num} or $self->{'_comments'}{$row_num})
|
7578
|
300 |
0 |
if (my $row_ref = $self->{'_table'}{$row_num}) { }
|
7580
|
299 |
1 |
if (not $self->{'_set_rows'}{$row_num}) { }
|
7589
|
309 |
35 |
if (my $col_ref = $self->{'_table'}{$row_num}{$col_num})
|
7630
|
4120 |
1049322 |
if (my $row_ref = $self->{'_table'}{$row_num})
|
7633
|
10683 |
21833 |
if (my $col_ref = $self->{'_table'}{$row_num}{$col_num})
|
7635
|
840 |
9843 |
if (not defined $span_min) { }
|
7640
|
7 |
9836 |
if $col_num < $span_min
|
7641
|
1500 |
8343 |
if $col_num > $span_max
|
7648
|
316 |
1053126 |
if (defined $self->{'_comments'}{$row_num})
|
7651
|
4160 |
32845 |
if (defined $self->{'_comments'}{$row_num}{$col_num})
|
7653
|
33 |
4127 |
if (not defined $span_min) { }
|
7658
|
0 |
4127 |
if $col_num < $span_min
|
7659
|
267 |
3860 |
if $col_num > $span_max
|
7665
|
66432 |
987010 |
if (($row_num + 1) % 16 == 0 or $row_num == $self->{'_dim_rowmax'})
|
7670
|
873 |
65559 |
if (defined $span_min)
|
7702
|
4106 |
430 |
unless defined $height
|
7707
|
11 |
4525 |
if (ref $format)
|
7711
|
4160 |
376 |
if defined $spans
|
7712
|
11 |
4525 |
if $xf_index
|
7713
|
11 |
4525 |
if $format
|
7715
|
111 |
4425 |
if ($height != $self->{'_original_row_height'})
|
7719
|
284 |
4252 |
if $hidden
|
7721
|
111 |
4425 |
if ($height != $self->{'_original_row_height'})
|
7725
|
53 |
4483 |
if $level
|
7726
|
4 |
4532 |
if $collapsed
|
7728
|
60 |
4476 |
if ($self->{'_excel_version'} == 2010)
|
7732
|
415 |
4121 |
if ($empty_row) { }
|
7801
|
421 |
10270 |
if (ref $xf)
|
7809
|
421 |
10270 |
if ($xf_index) { }
|
|
11 |
10259 |
elsif ($self->{'_set_rows'}{$row} and $self->{'_set_rows'}{$row}[1]) { }
|
|
17 |
10242 |
elsif ($self->{'_col_formats'}{$col}) { }
|
7823
|
7567 |
3124 |
if ($type eq 'n') { }
|
|
2974 |
150 |
elsif ($type eq 's') { }
|
|
79 |
71 |
elsif ($type eq 'f') { }
|
|
10 |
61 |
elsif ($type eq 'a' or $type eq 'd') { }
|
|
4 |
57 |
elsif ($type eq 'l') { }
|
|
57 |
0 |
elsif ($type eq 'b') { }
|
7831
|
2672 |
302 |
if ($self->{'_optimization'} == 0) { }
|
7843
|
8 |
294 |
if ($string =~ /^<r>/ and $string =~ m[</r>$]) { }
|
7851
|
3 |
291 |
if ($string =~ /^\s/ or $string =~ /\s$/)
|
7864
|
7 |
72 |
unless defined $value
|
7867
|
18 |
61 |
if ($value and not $value =~ /^([+-]?)(?=\d|\.\d)\d*(\.\d*)?([Ee]([+-]?\d+))?$/)
|
7870
|
2 |
16 |
if (exists $boolean{$value}) { }
|
|
9 |
7 |
elsif (exists $error_codes{$value}) { }
|
7890
|
1 |
9 |
if ($type eq "d")
|
7926
|
15 |
0 |
defined $_[0] ? :
|
7941
|
0 |
0 |
defined $_[0] ? :
|
8053
|
1081 |
23 |
unless $self->{'_page_setup_changed'}
|
8056
|
19 |
4 |
if ($self->{'_paper_size'})
|
8061
|
3 |
20 |
if ($self->{'_print_scale'} != 100)
|
8066
|
3 |
20 |
if ($self->{'_fit_page'} and $self->{'_fit_width'} != 1)
|
8070
|
4 |
19 |
if ($self->{'_fit_page'} and $self->{'_fit_height'} != 1)
|
8075
|
2 |
21 |
if ($self->{'_page_order'})
|
8080
|
2 |
21 |
if ($self->{'_page_start'} > 1)
|
8085
|
2 |
21 |
if ($self->{'_orientation'} == 0) { }
|
8093
|
1 |
22 |
if ($self->{'_black_white'})
|
8098
|
3 |
20 |
if ($self->{'_page_start'} != 0)
|
8103
|
0 |
23 |
if ($self->{'_horizontal_dpi'})
|
8107
|
5 |
18 |
if ($self->{'_vertical_dpi'})
|
8128
|
1067 |
14 |
unless $count
|
8179
|
1097 |
10 |
unless $self->{'_print_options_changed'}
|
8182
|
4 |
6 |
if ($self->{'_hcenter'})
|
8187
|
4 |
6 |
if ($self->{'_vcenter'})
|
8192
|
2 |
8 |
if ($self->{'_print_headers'})
|
8197
|
4 |
6 |
if ($self->{'_print_gridlines'})
|
8217
|
2 |
1100 |
unless ($self->{'_header_footer_scales'})
|
8221
|
10 |
1092 |
unless ($self->{'_header_footer_aligns'})
|
8225
|
35 |
1067 |
if ($self->{'_header_footer_changed'}) { }
|
|
7 |
1060 |
elsif ($self->{'_excel2003_style'}) { }
|
8227
|
32 |
3 |
if $self->{'_header'}
|
8228
|
13 |
22 |
if $self->{'_footer'}
|
8280
|
1074 |
6 |
unless @page_breaks
|
8310
|
1075 |
5 |
unless @page_breaks
|
8361
|
1067 |
32 |
unless $ref
|
8365
|
29 |
3 |
if ($self->{'_filter_on'}) { }
|
8400
|
86 |
30 |
unless $self->{'_filter_cols'}{$col}
|
8430
|
15 |
16 |
if ($type == 1) { }
|
8459
|
4 |
14 |
if (@filters != @non_blanks)
|
8463
|
2 |
16 |
if (@filters == 1 and @non_blanks == 0) { }
|
8510
|
14 |
4 |
if (@tokens == 2) { }
|
8525
|
4 |
0 |
if ($tokens[2] == 0) { }
|
8566
|
23 |
0 |
if (defined $operators{$operator}) { }
|
8574
|
18 |
5 |
unless $operator eq "equal"
|
8597
|
1029 |
49 |
unless @row_nums
|
8617
|
81 |
0 |
if ($self->{'_table'} and $self->{'_table'}{$row_num} and $self->{'_table'}{$row_num}{$col_num})
|
8622
|
1 |
80 |
if $cell->[0] ne "s"
|
8626
|
74 |
8 |
if ($link_type == 1) { }
|
8659
|
74 |
8 |
if ($type == 1) { }
|
|
8 |
0 |
elsif ($type == 2) { }
|
8695
|
9 |
66 |
if defined $location
|
8696
|
1 |
74 |
if defined $display
|
8697
|
3 |
72 |
if defined $tooltip
|
8722
|
3 |
8 |
if defined $tooltip
|
8740
|
17 |
66 |
unless @panes
|
8742
|
38 |
28 |
if ($panes[4] == 2) { }
|
8773
|
7 |
21 |
if (@{$self->{'_selections'};})
|
8779
|
13 |
15 |
if ($row and $col) { }
|
|
7 |
8 |
elsif ($col) { }
|
8802
|
25 |
3 |
if ($type == 0) { }
|
|
3 |
0 |
elsif ($type == 1) { }
|
8813
|
20 |
8 |
if $x_split
|
8814
|
21 |
7 |
if $y_split
|
8849
|
8 |
30 |
if (@{$self->{'_selections'};})
|
8856
|
24 |
14 |
if $y_split
|
8857
|
24 |
14 |
if $x_split
|
8862
|
26 |
12 |
if ($top_row == $row and $left_col == $col)
|
8870
|
30 |
8 |
unless ($has_selection)
|
8876
|
10 |
28 |
if ($row and $col) { }
|
|
14 |
14 |
elsif ($col) { }
|
8898
|
24 |
14 |
if $x_split
|
8899
|
24 |
14 |
if $y_split
|
8901
|
8 |
30 |
if $has_selection
|
8923
|
0 |
24 |
if ($width < 1) { }
|
8954
|
8 |
5 |
unless $color_index
|
8975
|
10 |
1 |
unless $self->{'_outline_changed'}
|
8977
|
1 |
0 |
if $self->{'_outline_style'}
|
8978
|
1 |
0 |
unless $self->{'_outline_below'}
|
8979
|
1 |
0 |
unless $self->{'_outline_right'}
|
8980
|
1 |
0 |
unless $self->{'_outline_on'}
|
8997
|
1094 |
30 |
unless $self->{'_protect'}
|
9001
|
6 |
24 |
if $arg{'password'}
|
9002
|
23 |
7 |
if $arg{'sheet'}
|
9003
|
5 |
25 |
if $arg{'content'}
|
9004
|
26 |
4 |
unless $arg{'objects'}
|
9005
|
21 |
9 |
unless $arg{'scenarios'}
|
9006
|
3 |
27 |
if $arg{'format_cells'}
|
9007
|
2 |
28 |
if $arg{'format_columns'}
|
9008
|
2 |
28 |
if $arg{'format_rows'}
|
9009
|
2 |
28 |
if $arg{'insert_columns'}
|
9010
|
2 |
28 |
if $arg{'insert_rows'}
|
9011
|
2 |
28 |
if $arg{'insert_hyperlinks'}
|
9012
|
2 |
28 |
if $arg{'delete_columns'}
|
9013
|
2 |
28 |
if $arg{'delete_rows'}
|
9016
|
3 |
27 |
unless $arg{'select_locked_cells'}
|
9018
|
2 |
28 |
if $arg{'sort'}
|
9019
|
2 |
28 |
if $arg{'autofilter'}
|
9020
|
2 |
28 |
if $arg{'pivot_tables'}
|
9023
|
2 |
28 |
unless $arg{'select_unlocked_cells'}
|
9040
|
1075 |
3 |
if $self->{'_num_protected_ranges'} == 0
|
9067
|
2 |
7 |
if $password
|
9085
|
575 |
524 |
unless $self->{'_drawing'}
|
9120
|
1020 |
59 |
unless $self->{'_has_vml'}
|
9142
|
1054 |
24 |
unless $self->{'_has_header_vml'}
|
9164
|
1070 |
8 |
unless $self->{'_background_image'}
|
9195
|
19 |
37 |
if $format->{'_bold'}
|
9196
|
10 |
46 |
if $format->{'_italic'}
|
9197
|
0 |
56 |
if $format->{'_font_strikeout'}
|
9198
|
0 |
56 |
if $format->{'_font_outline'}
|
9199
|
0 |
56 |
if $format->{'_font_shadow'}
|
9202
|
0 |
56 |
if $format->{'_underline'}
|
9204
|
0 |
56 |
if $format->{'_font_script'} == 1
|
9205
|
0 |
56 |
if $format->{'_font_script'} == 2
|
9209
|
0 |
56 |
if (my $theme = $format->{'_theme'}) { }
|
|
1 |
55 |
elsif (my $color = $format->{'_color'}) { }
|
9225
|
56 |
0 |
if ($format->{'_font'} eq "Calibri" and not $format->{'_hyperlink'})
|
9247
|
0 |
0 |
if ($underline == 2) { }
|
|
0 |
0 |
elsif ($underline == 33) { }
|
|
0 |
0 |
elsif ($underline == 34) { }
|
9317
|
1072 |
62 |
unless $count
|
9351
|
4 |
64 |
if $sqref ne ""
|
9356
|
0 |
68 |
if ($row_first > $row_last)
|
9360
|
0 |
68 |
if ($col_first > $col_last)
|
9368
|
62 |
2 |
if ($param->{'validate'} ne "none")
|
9372
|
26 |
36 |
if ($param->{'criteria'} ne "between")
|
9378
|
2 |
62 |
if ($param->{'error_type'})
|
9380
|
1 |
1 |
if $param->{'error_type'} == 1
|
9382
|
1 |
1 |
if $param->{'error_type'} == 2
|
9385
|
62 |
2 |
if $param->{'ignore_blank'}
|
9386
|
1 |
63 |
unless $param->{'dropdown'}
|
9387
|
61 |
3 |
if $param->{'show_input'}
|
9388
|
62 |
2 |
if $param->{'show_error'}
|
9391
|
4 |
60 |
if $param->{'error_title'}
|
9394
|
3 |
61 |
if $param->{'error_message'}
|
9397
|
15 |
49 |
if $param->{'input_title'}
|
9400
|
14 |
50 |
if $param->{'input_message'}
|
9404
|
2 |
62 |
if ($param->{'validate'} eq 'none') { }
|
9415
|
24 |
38 |
if defined $param->{'maximum'}
|
9434
|
10 |
52 |
if (ref $formula eq "ARRAY")
|
9473
|
1019 |
63 |
unless scalar @ranges
|
9521
|
27 |
122 |
if defined $param->{'format'}
|
9526
|
5 |
144 |
if $param->{'stop_if_true'}
|
9528
|
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') { }
|
9533
|
5 |
31 |
if (defined $param->{'minimum'} and defined $param->{'maximum'}) { }
|
9541
|
2 |
28 |
unless ($value =~ /(\$?)([A-Z]{1,3})(\$?)(\d+)/ or $value =~ /^([+-]?)(?=\d|\.\d)\d*(\.\d*)?([Ee]([+-]?\d+))?$/)
|
9545
|
1 |
1 |
unless ($value =~ /^".*"$/)
|
9556
|
5 |
5 |
if ($param->{'criteria'} =~ /below/)
|
9560
|
2 |
8 |
if ($param->{'criteria'} =~ /equal/)
|
9564
|
6 |
4 |
if ($param->{'criteria'} =~ /([123]) std dev/)
|
9571
|
2 |
2 |
if (defined $param->{'criteria'} and $param->{'criteria'} eq "%")
|
9575
|
2 |
2 |
if ($param->{'direction'})
|
9630
|
25 |
4 |
if ($param->{'_is_data_bar_2010'})
|
9669
|
36 |
1 |
if ($icon_style ne "3TrafficLights")
|
9673
|
4 |
0 |
if (exists $param->{'icons_only'} and $param->{'icons_only'})
|
9677
|
6 |
0 |
if (exists $param->{'reverse_icons'} and $param->{'reverse_icons'})
|
9728
|
4 |
1 |
if (defined $param->{'mid_type'})
|
9736
|
4 |
1 |
if (defined $param->{'mid_color'})
|
9758
|
2 |
27 |
if ($data_bar->{'bar_only'})
|
9820
|
169 |
41 |
if (defined $value)
|
9824
|
7 |
203 |
if ($criteria)
|
9846
|
41 |
9 |
if ($type eq 'min' or $type eq 'max' or $type eq 'autoMin' or $type eq 'autoMax') { }
|
9892
|
1050 |
28 |
unless $count
|
9939
|
1056 |
11 |
unless ($has_data_bars or $has_sparklines)
|
9946
|
11 |
11 |
if ($has_data_bars)
|
9950
|
12 |
10 |
if ($has_sparklines)
|
10019
|
24 |
1 |
unless ($data_bar->{'bar_no_border'})
|
10024
|
24 |
1 |
unless ($data_bar->{'bar_negative_color_same'})
|
10030
|
23 |
1 |
unless ($data_bar->{'bar_no_border'} or $data_bar->{'bar_negative_border_color_same'})
|
10038
|
24 |
1 |
if ($data_bar->{'bar_axis_position'} ne "none")
|
10094
|
24 |
1 |
unless ($data_bar->{'bar_no_border'})
|
10098
|
1 |
24 |
if ($data_bar->{'bar_solid'})
|
10102
|
1 |
24 |
if ($data_bar->{'bar_direction'} eq "left")
|
10106
|
1 |
24 |
if ($data_bar->{'bar_direction'} eq "right")
|
10110
|
1 |
24 |
if ($data_bar->{'bar_negative_color_same'})
|
10114
|
23 |
1 |
unless ($data_bar->{'bar_no_border'} or $data_bar->{'bar_negative_border_color_same'})
|
10120
|
1 |
24 |
if ($data_bar->{'bar_axis_position'} eq "middle")
|
10124
|
1 |
24 |
if ($data_bar->{'bar_axis_position'} eq "none")
|
10248
|
1 |
57 |
if ($sparkline->{'_date_axis'})
|
10368
|
4 |
54 |
if (defined $opts->{'_max'})
|
10370
|
2 |
2 |
if ($opts->{'_max'} eq 'group') { }
|
10379
|
4 |
54 |
if (defined $opts->{'_min'})
|
10381
|
1 |
3 |
if ($opts->{'_min'} eq 'group') { }
|
10392
|
9 |
49 |
if ($opts->{'_type'} ne "line")
|
10396
|
3 |
55 |
if $opts->{'_weight'}
|
10397
|
1 |
57 |
if $opts->{'_date_axis'}
|
10398
|
57 |
1 |
if $empty
|
10400
|
4 |
54 |
if $opts->{'_markers'}
|
10401
|
4 |
54 |
if $opts->{'_high'}
|
10402
|
4 |
54 |
if $opts->{'_low'}
|
10403
|
4 |
54 |
if $opts->{'_first'}
|
10404
|
4 |
54 |
if $opts->{'_last'}
|
10405
|
4 |
54 |
if $opts->{'_negative'}
|
10406
|
1 |
57 |
if $opts->{'_axis'}
|
10407
|
1 |
57 |
if $opts->{'_hidden'}
|
10408
|
4 |
54 |
if $opts->{'_cust_min'}
|
10409
|
4 |
54 |
if $opts->{'_cust_max'}
|
10410
|
1 |
57 |
if $opts->{'_reverse'}
|
10429
|
122 |
342 |
if defined $color->{'_rgb'}
|
10430
|
342 |
122 |
if defined $color->{'_theme'}
|
10431
|
229 |
235 |
if defined $color->{'_tint'}
|
10560
|
1073 |
5 |
unless (defined $ignore)
|
10566
|
4 |
1 |
if (exists $ignore->{'number_stored_as_text'})
|
10571
|
1 |
4 |
if (exists $ignore->{'eval_error'})
|
10576
|
1 |
4 |
if (exists $ignore->{'formula_differs'})
|
10581
|
0 |
5 |
if (exists $ignore->{'formula_range'})
|
10586
|
0 |
5 |
if (exists $ignore->{'formula_unlocked'})
|
10591
|
0 |
5 |
if (exists $ignore->{'empty_cell_reference'})
|
10596
|
0 |
5 |
if (exists $ignore->{'list_data_validation'})
|
10601
|
0 |
5 |
if (exists $ignore->{'calculated_column'})
|
10606
|
0 |
5 |
if (exists $ignore->{'two_digit_text_year'})
|