XLSX/Utility2007.pm

filter: Statementstmt 59.2% 314 / 530 Branchbran 57.3% 243 / 424 Conditioncond 58.0% 133 / 229 MC/DCmcdc 40.5% 45 / 111 Subroutinesub 56.2% 9 / 16 Podpod 58.3% 7 / 12 totaltotal 56.8% 751 / 1322 CC 292 SCAR 67.8
CC
292
Cov
58%
ExcelFmt
1275.5
xls2csv
462.0
LocaltimeExcel
380.0
CRAP 882.5
↑ Summary XLSX.pm »
1 # This code is adapted for Excel 2007 from:
2 # Spreadsheet::XLSX::Utility
3 # by Kawai, Takanori (Hippo2000) 2001.2.2
4 # This Program is ALPHA version.
5 #==============================================================================
6 # Spreadsheet::XLSX::Utility2007;
7 #==============================================================================
8 package Spreadsheet::XLSX::Utility2007;
9 26 ▶use strict;
Subroutine BEGIN: called CC=1 SCAR=0.0
10 26 ▶use warnings;
Subroutine BEGIN: called CC=1 SCAR=0.0
11  
12 26 require Exporter;
13 26 ▶use vars qw(@ISA @EXPORT_OK);
Subroutine BEGIN: called CC=1 SCAR=0.0
14 26 @ISA = qw(Exporter);
15 26 @EXPORT_OK = qw(ExcelFmt LocaltimeExcel ExcelLocaltime col2int int2col sheetRef xls2csv);
16 26 our $VERSION = '0.21';
17  
18 26 my $sNUMEXP = '(^[+-]?\d+(\.\d+)?$)|(^[+-]?\d+\.?(\d*)[eE][+-](\d+))$';
19  
20 #------------------------------------------------------------------------------
21 # ExcelFmt (for Spreadsheet::XLSX::Utility2007)
22 #------------------------------------------------------------------------------
23 # Treat format conditions as data. Invalid conditions select the fallback section.
24 27 ▶sub _matches_condition {
Subroutine _matches_condition: called CC=9 SCAR=22.0
25 27 my ($value, $condition) = @_;
26 27 my $number = qr/[+-]?(?:[0-9]+(?:\.[0-9]*)?|\.[0-9]+)(?:[eE][+-]?[0-9]+)?/;
27 27 ▶ return 0 unless defined($value) && $value =~ /\A\s*$number\s*\z/;
Branch: 1 branch
BranchTrueFalseTotal
unless defined $value and $value =~ /\A\s*$number\s*\z/ 1 26 27
Condition66%2/3
defined $value and $value =~ /\A\s*$number\s*\z/
!ll&&!rl&&r
0126
MC/DC50%1/2
defined $value and $value =~ /\A\s*$number\s*\z/
defined $value $value =~ /\A\s*$number\s*\z/
Truth table66%2/3
A and B
A= defined $valueB= $value =~ /\A\s*$number\s*\z/
ABresult
0X0
100
111
28 26 ▶ return 0 unless $condition =~ /\A\s*(>=|<=|<>|==|>|<|=)\s*($number)\s*\z/;
Branch: 1 branch
BranchTrueFalseTotal
unless $condition =~ /\A\s*(>=|<=|<>|==|>|<|=)\s*($number)\s*\z/ 7 19 26
29 19 my ($operator, $operand) = ($1, $2);
30 19 ▶ return $value > $operand if $operator eq '>';
Branch: 1 branch
BranchTrueFalseTotal
if $operator eq ">" 3 16 19
31 16 ▶ return $value >= $operand if $operator eq '>=';
Branch: 1 branch
BranchTrueFalseTotal
if $operator eq ">=" 3 13 16
32 13 ▶ return $value < $operand if $operator eq '<';
Branch: 1 branch
BranchTrueFalseTotal
if $operator eq "<" 2 11 13
33 11 ▶ return $value <= $operand if $operator eq '<=';
Branch: 1 branch
BranchTrueFalseTotal
if $operator eq "<=" 2 9 11
34 9 ▶ return $value != $operand if $operator eq '<>';
Branch: 1 branch
BranchTrueFalseTotal
if $operator eq "<>" 2 7 9
35 7 return $value == $operand;
36 }
37  
38 2548 ▶sub ExcelFmt {
Subroutine ExcelFmt: called CC=198 SCAR=71.5
Pod documented
39 2548 my ($sFmt, $iData, $i1904, $sType) = @_;
40 2548 my $sCond;
41 2548 my $sWkF = '';
42 2548 my $sRes = '';
43 2548 $sFmt = unescape_HTML($sFmt);
44  
45 #1. Get Condition
46 2548 ▶ if ($sFmt =~ /^\[([<>=][^\]]+)\](.*)$/) {
Branch: 1 branch
BranchTrueFalseTotal
if ($sFmt =~ /^\[([<>=][^\]]+)\](.*)$/) 27 2521 2548
47 27 $sCond = $1;
48 27 $sFmt = $2;
49 }
50 2548 $sFmt =~ s/_/ /g;
51  
52 2548 my @sFmtWk;
53 my $sFmtObj;
54 2548 my $iFmtPos = 0;
55 2548 my $iDblQ = 0;
56 2548 my $iQ = 0;
57 2548 foreach my $sWk (split //, $sFmt) {
58 7511 ▶ if ($iDblQ or $iQ) {
Branch: 1 branch
BranchTrueFalseTotal
if ($iDblQ or $iQ) 34 7477 7511
Condition100%3/3
$iDblQ or $iQ
l!l&&r!l&&!r
2777477
MC/DC100%2/2
$iDblQ or $iQ
$iDblQ $iQ
Truth table100%3/3
A or B
A= $iDblQB= $iQ
ABresult
1X1
011
000
59 34 $sFmtWk[$iFmtPos] .= $sWk;
60 34 ▶ $iDblQ = 0 if ($sWk eq '"');
Branch: 1 branch
BranchTrueFalseTotal
if $sWk eq "\"" 7 27 34
61 34 $iQ = 0;
62 34 next;
63 }
64  
65 7477 ▶ if ($sWk eq ';') {
Branch: 6 branches
BranchTrueFalseTotal
if ($sWk eq ';') { } 31 7446 7477
elsif ($sWk eq '"') { } 7 7439 7446
elsif ($sWk eq '!') { } 0 7439 7439
elsif ($sWk eq '\\') { } 7 7432 7439
elsif ($sWk eq '(') { } 0 7432 7432
elsif ($sWk eq ')') { } 0 7432 7432
66 31 $iFmtPos++;
67 31 next;
68 } elsif ($sWk eq '"') {
69 7 $iDblQ = 1;
70 } elsif ($sWk eq '!') {
71 0 $iQ = 1;
72 } elsif ($sWk eq '\\') {
73 7 $iQ = 1;
74  
75 # next;
76 } elsif ($sWk eq '(') { #Skip?
77 0 next;
78 } elsif ($sWk eq ')') { #Skip?
79 0 next;
80 }
81 7446 $sFmtWk[$iFmtPos] .= $sWk;
82 }
83  
84 #Get FmtString
85 2548 ▶ if (scalar(@sFmtWk) > 1) {
Branch: 1 branch
BranchTrueFalseTotal
if (scalar @sFmtWk > 1) { } 31 2517 2548
86 31 ▶ if ($sCond) {
Branch: 1 branch
BranchTrueFalseTotal
if ($sCond) { } 27 4 31
87 27 ▶ $sFmtObj = $sFmtWk[(_matches_condition($iData, $sCond) ? 0 : 1)];
Branch: 1 branch
BranchTrueFalseTotal
_matches_condition($iData, $sCond) ? : 12 15 27
88 } else {
89 4 ▶ my $iWk = ($iData =~ /$sNUMEXP/) ? $iData : 0;
Branch: 1 branch
BranchTrueFalseTotal
$iData =~ /$sNUMEXP/ ? : 4 0 4
90  
91 # $iData = abs($iData) if($iWk !=0);
92 4 ▶ if (scalar(@sFmtWk) == 2) {
Branch: 2 branches
BranchTrueFalseTotal
if (scalar @sFmtWk == 2) { } 4 0 4
elsif (scalar @sFmtWk == 3) { } 0 0 0
93 4 ▶ $sFmtObj = $sFmtWk[(($iWk >= 0) ? 0 : 1)];
Branch: 1 branch
BranchTrueFalseTotal
$iWk >= 0 ? : 4 0 4
94 } elsif (scalar(@sFmtWk) == 3) {
95 0 ▶ $sFmtObj = $sFmtWk[(($iWk > 0) ? 0 : (($iWk < 0) ? 1 : 2))];
Branch: 2 branches
BranchTrueFalseTotal
$iWk > 0 ? : 0 0 0
$iWk < 0 ? : 0 0 0
96 } else {
97 0 ▶ if ($iData =~ /$sNUMEXP/) {
Branch: 1 branch
BranchTrueFalseTotal
if ($iData =~ /$sNUMEXP/) { } 0 0 0
98 0 ▶ $sFmtObj = $sFmtWk[(($iWk > 0) ? 0 : (($iWk < 0) ? 1 : 2))];
Branch: 2 branches
BranchTrueFalseTotal
$iWk > 0 ? : 0 0 0
$iWk < 0 ? : 0 0 0
99 } else {
100 0 $sFmtObj = $sFmtWk[3];
101 }
102 }
103 }
104 } else {
105 2517 $sFmtObj = $sFmtWk[0];
106 }
107 2548 my $sColor;
108 2548 ▶ if ($sFmtObj =~ /^(\[[^hm\[\]]*\])/) {
Branch: 1 branch
BranchTrueFalseTotal
if ($sFmtObj =~ /^(\[[^hm\[\]]*\])/) 4 2544 2548
109 4 $sColor = $1;
110 4 $sFmtObj = substr($sFmtObj, length($sColor));
111 4 chop($sColor);
112 4 $sColor = substr($sColor, 1);
113 }
114  
115 #print "FMT:$sFmtObj Co:$sColor\n";
116  
117 #3.Build Data
118 2548 my $iFmtMode = 0; #1:Number, 2:Date
119 2548 my $i = 0;
120 2548 my $ir = 0;
121 2548 my $sFmtWk;
122 2548 my @aRep = ();
123 2548 my $sFmtRes = '';
124  
125 2548 my $iFflg = -1;
126 2548 my $iRpos = -1;
127 2548 my $iCmmCnt = 0;
128 2548 my $iBunFlg = 0;
129 2548 my $iFugouFlg = 0;
130 2548 my $iPer = 0;
131 2548 my $iAm = 0;
132 2548 my $iSt;
133  
134 2548 ▶ while ($i < length($sFmtObj)) {
Branch: 1 branch
BranchTrueFalseTotal
if ($i < length $sFmtObj) 5996 2548 8544
135 5996 $iSt = $i;
136 5996 my $sWk = substr($sFmtObj, $i, 1);
137  
138 5996 ▶ if ($sWk !~ /[#0\+\-\.\?eE\,\%]/) {
Branch: 1 branch
BranchTrueFalseTotal
unless ($sWk =~ /[#0\+\-\.\?eE\,\%]/) 1831 4165 5996
139 1831 ▶ if ($iFflg != -1) {
Branch: 1 branch
BranchTrueFalseTotal
if ($iFflg != -1) 0 1831 1831
140 0 push @aRep, [substr($sFmtObj, $iFflg, $i - $iFflg), $iRpos, $i - $iFflg];
141 0 $iFflg = -1;
142 }
143 }
144  
145 5996 ▶ if ($sWk eq '"') {
Branch: 3 branches
BranchTrueFalseTotal
if ($sWk eq '"') { } 12 5984 5996
elsif ($sWk eq '!') { } 0 5984 5984
elsif ($sWk eq '\\') { } 7 5977 5984
146 12 ▶ $iDblQ = $iDblQ ? 0 : 1;
Branch: 1 branch
BranchTrueFalseTotal
$iDblQ ? : 6 6 12
147 12 $i++;
148 12 next;
149 } elsif ($sWk eq '!') {
150 0 $iQ = 1;
151 0 $i++;
152 0 next;
153 } elsif ($sWk eq '\\') {
154 7 ▶ if ($iQ == 1) {
Branch: 1 branch
BranchTrueFalseTotal
if ($iQ == 1) { } 0 7 7
155 } else {
156 7 $iQ = 1;
157 7 $i++;
158 7 next;
159 }
160 }
161  
162 #print "WK:", ord($sWk), " $iFmtMode \n";
163 #print "DEF1: $iDblQ DEF2: $iQ\n";
164 5977 ▶ if ((defined($iDblQ) and ($iDblQ)) or (defined($iQ) and ($iQ))) {
Branch: 9 branches
BranchTrueFalseTotal
if (defined $iDblQ and $iDblQ or defined $iQ and $iQ) { } 24 5953 5977
elsif ($sWk =~ /[#0\+\.\?eE\,\%]/ or $iFmtMode != 2 and $sWk eq '-' || $sWk eq '(' || $sWk eq ')') { } 4039 1914 5953
elsif (substr($sFmtObj, $i, 5) =~ m[\Aam/pm\z]i) { } 28 1886 1914
elsif (substr($sFmtObj, $i, 3) =~ m[\Aa/p\z]i) { } 17 1869 1886
elsif ($sWk =~ /[ymdhsapg]/) { } 388 1481 1869
elsif (substr($sFmtObj, $i, 3) eq '[h]') { } 0 1481 1481
elsif (substr($sFmtObj, $i, 4) eq '[mm]') { } 0 1481 1481
elsif ($sWk eq '@') { } 1226 255 1481
elsif ($sWk eq '*') { } 0 255 255
Condition77%7/9
defined $iDblQ and $iDblQ or defined $iQ and $iQ
l!l&&r!l&&!r
1775953
defined $iDblQ and $iDblQ
!ll&&!rl&&r
0596017
defined $iQ and $iQ
!ll&&!rl&&r
059537
MC/DC50%2/4
defined $iDblQ and $iDblQ or defined $iQ and $iQ
defined $iDblQ $iDblQ defined $iQ $iQ
Truth table42%3/7
A and B or C and D
A= defined $iDblQB= $iDblQC= defined $iQD= $iQ
ABCDresult
11XX1
0X111
10111
0X0X0
0X100
100X0
10100
165 24 $iQ = 0;
166 24 ▶ if (
Branch: 1 branch
BranchTrueFalseTotal
if ($iFmtMode != 2 and substr($sFmtObj, $i, 2) eq "\201\242" || substr($sFmtObj, $i, 2) eq "\201\243" || substr($sFmtObj, $i, 2) eq "\242\244" || substr($sFmtObj, $i, 2) eq "\242\245") { } 0 24 24
Condition41%5/12
$iFmtMode != 2 and substr($sFmtObj, $i, 2) eq "\201\242" || substr($sFmtObj, $i, 2) eq "\201\243" || substr($sFmtObj, $i, 2) eq "\242\244" || substr($sFmtObj, $i, 2) eq "\242\245"
!ll&&!rl&&r
14100
substr($sFmtObj, $i, 2) eq "\201\242" or substr($sFmtObj, $i, 2) eq "\201\243" or substr($sFmtObj, $i, 2) eq "\242\244" or substr($sFmtObj, $i, 2) eq "\242\245"
l!l&&r!l&&!r
0010
substr($sFmtObj, $i, 2) eq "\201\242" or substr($sFmtObj, $i, 2) eq "\201\243" or substr($sFmtObj, $i, 2) eq "\242\244"
l!l&&r!l&&!r
0010
substr($sFmtObj, $i, 2) eq "\201\242" or substr($sFmtObj, $i, 2) eq "\201\243"
l!l&&r!l&&!r
0010
MC/DC0%0/5
$iFmtMode != 2 and substr($sFmtObj, $i, 2) eq "\201\242" || substr($sFmtObj, $i, 2) eq "\201\243" || substr($sFmtObj, $i, 2) eq "\242\244" || substr($sFmtObj, $i, 2) eq "\242\245"
$iFmtMode != 2 substr($sFmtObj, $i, 2) eq "\201\242" substr($sFmtObj, $i, 2) eq "\201\243" substr($sFmtObj, $i, 2) eq "\242\244" substr($sFmtObj, $i, 2) eq "\242\245"
Truth table33%2/6
A and B or C or D or E
A= $iFmtMode != 2B= substr($sFmtObj, $i, 2) eq "\201\242"C= substr($sFmtObj, $i, 2) eq "\201\243"D= substr($sFmtObj, $i, 2) eq "\242\244"E= substr($sFmtObj, $i, 2) eq "\242\245"
ABCDEresult
0XXXX0
100000
11XXX1
101XX1
1001X1
100011
167 ($iFmtMode != 2)
168 and ( (substr($sFmtObj, $i, 2) eq "\x81\xA2")
169 || (substr($sFmtObj, $i, 2) eq "\x81\xA3")
170 || (substr($sFmtObj, $i, 2) eq "\xA2\xA4")
171 || (substr($sFmtObj, $i, 2) eq "\xA2\xA5"))
172 ) {
173 #print "PUSH:", unpack("H*", substr($sFmtObj, $i, 2)), "\n";
174 0 push @aRep, [substr($sFmtObj, $i, 2), length($sFmtRes), 2];
175 0 $iFugouFlg = 1;
176 0 $i += 2;
177 } else {
178 24 $i++;
179 }
180 ▶ } elsif (
Condition50%6/12
$sWk =~ /[#0\+\.\?eE\,\%]/ or $iFmtMode != 2 and $sWk eq "-" || $sWk eq "(" || $sWk eq ")"
l!l&&r!l&&!r
403901914
$iFmtMode != 2 and $sWk eq "-" || $sWk eq "(" || $sWk eq ")"
!ll&&!rl&&r
51813960
$sWk eq "-" or $sWk eq "(" or $sWk eq ")"
l!l&&r!l&&!r
001396
$sWk eq "-" or $sWk eq "("
l!l&&r!l&&!r
001396
MC/DC20%1/5
$sWk =~ /[#0\+\.\?eE\,\%]/ or $iFmtMode != 2 and $sWk eq "-" || $sWk eq "(" || $sWk eq ")"
$sWk =~ /[#0\+\.\?eE\,\%]/ $iFmtMode != 2 $sWk eq "-" $sWk eq "(" $sWk eq ")"
Truth table50%3/6
A or B and C or D or E
A= $sWk =~ /[#0\+\.\?eE\,\%]/B= $iFmtMode != 2C= $sWk eq "-"D= $sWk eq "("E= $sWk eq ")"
ABCDEresult
1XXXX1
011XX1
0101X1
010011
00XXX0
010000
181 ($sWk =~ /[#0\+\.\?eE\,\%]/)
182 || ( ($iFmtMode != 2)
183 and (($sWk eq '-') || ($sWk eq '(') || ($sWk eq ')')))
184 ) {
185 4039 ▶ $iFmtMode = 1 unless ($iFmtMode);
Branch: 1 branch
BranchTrueFalseTotal
unless $iFmtMode 1151 2888 4039
186 4039 ▶ if (substr($sFmtObj, $i, 1) =~ /[#0]/) {
Branch: 3 branches
BranchTrueFalseTotal
if (substr($sFmtObj, $i, 1) =~ /[#0]/) { } 3206 833 4039
elsif (substr($sFmtObj, $i, 1) eq '?') { } 0 833 833
elsif (substr($sFmtObj, $i, 3) =~ /^[eE][\+\-][0#]$/) { } 0 833 833
187 3206 my ($number_format) = substr($sFmtObj, $i) =~ /^([#0]+[.]?[0#]*[eE][+-][0#]+)/;
188 3206 ▶ if (defined $number_format) {
Branch: 1 branch
BranchTrueFalseTotal
if (defined $number_format) { } 80 3126 3206
189 80 my $match_length = length($number_format);
190 80 push @aRep, [$number_format, $i, $match_length];
191 80 $i += $match_length;
192 } else {
193 3126 ▶ if ($iFflg == -1) {
Branch: 1 branch
BranchTrueFalseTotal
if ($iFflg == -1) 1821 1305 3126
194 1821 $iFflg = $i;
195 1821 $iRpos = length($sFmtRes);
196 }
197 }
198 } elsif (substr($sFmtObj, $i, 1) eq '?') {
199 0 ▶ if ($iFflg != -1) {
Branch: 1 branch
BranchTrueFalseTotal
if ($iFflg != -1) 0 0 0
200 0 push @aRep, [substr($sFmtObj, $iFflg, $i - $iFflg + 1), $iRpos, $i - $iFflg + 1];
201 }
202 0 $iFflg = $i;
203 0 ▶ while ($i < length($sFmtObj)) {
Branch: 1 branch
BranchTrueFalseTotal
if ($i < length $sFmtObj) 0 0 0
204 0 ▶ if (substr($sFmtObj, $i, 1) eq '/') {
Branch: 2 branches
BranchTrueFalseTotal
if (substr($sFmtObj, $i, 1) eq '/') { } 0 0 0
elsif (substr($sFmtObj, $i, 1) eq '?') { } 0 0 0
205 0 $iBunFlg = 1;
206 } elsif (substr($sFmtObj, $i, 1) eq '?') {
207 ;
208 } else {
209 0 ▶ if (($iBunFlg) && (substr($sFmtObj, $i, 1) =~ /[0-9]/)) {
Branch: 1 branch
BranchTrueFalseTotal
if ($iBunFlg and substr($sFmtObj, $i, 1) =~ /[0-9]/) { } 0 0 0
Condition0%0/3
$iBunFlg and substr($sFmtObj, $i, 1) =~ /[0-9]/
!ll&&!rl&&r
000
MC/DC0%0/2
$iBunFlg and substr($sFmtObj, $i, 1) =~ /[0-9]/
$iBunFlg substr($sFmtObj, $i, 1) =~ /[0-9]/
Truth table0%0/3
A and B
A= $iBunFlgB= substr($sFmtObj, $i, 1) =~ /[0-9]/
ABresult
0X0
100
111
210 ;
211 } else {
212 0 last;
213 }
214 }
215 0 $i++;
216 }
217 0 $i--;
218 0 push @aRep, [substr($sFmtObj, $iFflg, $i - $iFflg + 1), length($sFmtRes), $i - $iFflg + 1];
219 0 $iFflg = -1;
220 } elsif (substr($sFmtObj, $i, 3) =~ /^[eE][\+\-][0#]$/) {
221 0 my ($exponent_format) = substr($sFmtObj, $i) =~ /([eE][+-][0#]+)/;
222 0 ▶ if (defined $exponent_format) {
Branch: 1 branch
BranchTrueFalseTotal
if (defined $exponent_format) 0 0 0
223 0 my $match_length = length($exponent_format);
224 0 push @aRep, [$exponent_format, $i, $match_length];
225 0 $i += $match_length;
226 }
227 0 $iFflg = -1;
228 } else {
229 833 ▶ if ($iFflg != -1) {
Branch: 1 branch
BranchTrueFalseTotal
if ($iFflg != -1) 753 80 833
230 753 push @aRep, [substr($sFmtObj, $iFflg, $i - $iFflg), $iRpos, $i - $iFflg];
231 753 $iFflg = -1;
232 }
233 833 ▶ if (substr($sFmtObj, $i, 1) =~ /[\+\-]/) {
Branch: 5 branches
BranchTrueFalseTotal
if (substr($sFmtObj, $i, 1) =~ /[\+\-]/) { } 80 753 833
elsif (substr($sFmtObj, $i, 1) eq '.') { } 749 4 753
elsif (substr($sFmtObj, $i, 1) eq ',') { } 1 3 4
elsif (substr($sFmtObj, $i, 1) eq '%') { } 3 0 3
elsif (substr($sFmtObj, $i, 1) eq '(' or substr($sFmtObj, $i, 1) eq ')') { } 0 0 0
234 80 push @aRep, [substr($sFmtObj, $i, 1), length($sFmtRes), 1];
235 80 $iFugouFlg = 1;
236 } elsif (substr($sFmtObj, $i, 1) eq '.') {
237 749 push @aRep, [substr($sFmtObj, $i, 1), length($sFmtRes), 1];
238 } elsif (substr($sFmtObj, $i, 1) eq ',') {
239 1 $iCmmCnt++;
240 1 push @aRep, [substr($sFmtObj, $i, 1), length($sFmtRes), 1];
241 } elsif (substr($sFmtObj, $i, 1) eq '%') {
242 3 $iPer = 1;
243 ▶ } elsif ((substr($sFmtObj, $i, 1) eq '(')
Condition0%0/3
substr($sFmtObj, $i, 1) eq "(" or substr($sFmtObj, $i, 1) eq ")"
l!l&&r!l&&!r
000
MC/DC0%0/2
substr($sFmtObj, $i, 1) eq "(" or substr($sFmtObj, $i, 1) eq ")"
substr($sFmtObj, $i, 1) eq "(" substr($sFmtObj, $i, 1) eq ")"
Truth table0%0/3
A or B
A= substr($sFmtObj, $i, 1) eq "("B= substr($sFmtObj, $i, 1) eq ")"
ABresult
1X1
011
000
244 || (substr($sFmtObj, $i, 1) eq ')')) {
245 0 push @aRep, [substr($sFmtObj, $i, 1), length($sFmtRes), 1];
246 0 $iFugouFlg = 1;
247 }
248 }
249 4039 $i++;
250 } elsif (substr($sFmtObj, $i, 5) =~ /\Aam\/pm\z/i) {
251 28 ▶ $iFmtMode = 2 unless ($iFmtMode);
Branch: 1 branch
BranchTrueFalseTotal
unless $iFmtMode 3 25 28
252 28 push @aRep, ['am/pm', length($sFmtRes), 5, substr($sFmtObj, $i, 5)];
253 28 $iAm = 1;
254 28 $i += 5;
255 } elsif (substr($sFmtObj, $i, 3) =~ /\Aa\/p\z/i) {
256 17 ▶ $iFmtMode = 2 unless ($iFmtMode);
Branch: 1 branch
BranchTrueFalseTotal
unless $iFmtMode 1 16 17
257 17 push @aRep, ['a/p', length($sFmtRes), 3, substr($sFmtObj, $i, 3)];
258 17 $iAm = 1;
259 17 $i += 3;
260 } elsif ($sWk =~ /[ymdhsapg]/) {
261 388 ▶ $iFmtMode = 2 unless ($iFmtMode);
Branch: 1 branch
BranchTrueFalseTotal
unless $iFmtMode 166 222 388
262 388 ▶ if (substr($sFmtObj, $i, 5) eq 'mmmmm') {
Branch: 5 branches
BranchTrueFalseTotal
if (substr($sFmtObj, $i, 5) eq 'mmmmm') { } 0 388 388
elsif (substr($sFmtObj, $i, 4) eq 'mmmm' or substr($sFmtObj, $i, 4) eq 'dddd' or substr($sFmtObj, $i, 4) eq 'yyyy' or substr($sFmtObj, $i, 4) eq 'ggge') { } 88 300 388
elsif (substr($sFmtObj, $i, 3) eq 'mmm' or substr($sFmtObj, $i, 3) eq 'ddd' or substr($sFmtObj, $i, 3) eq 'yyy') { } 34 266 300
elsif (substr($sFmtObj, $i, 2) eq 'yy' or substr($sFmtObj, $i, 2) eq 'mm' or substr($sFmtObj, $i, 2) eq 'dd' or substr($sFmtObj, $i, 2) eq 'hh' or substr($sFmtObj, $i, 2) eq 'ss' or substr($sFmtObj, $i, 2) eq 'ge') { } 238 28 266
elsif (substr($sFmtObj, $i, 1) eq 'm' or substr($sFmtObj, $i, 1) eq 'd' or substr($sFmtObj, $i, 1) eq 'h' or substr($sFmtObj, $i, 1) eq 's') { } 28 0 28
263 0 push @aRep, ['mmmmm', length($sFmtRes), 5];
264 0 $i += 5;
265 ▶ } elsif ((substr($sFmtObj, $i, 4) eq 'mmmm')
Condition77%7/9
substr($sFmtObj, $i, 4) eq "mmmm" or substr($sFmtObj, $i, 4) eq "dddd" or substr($sFmtObj, $i, 4) eq "yyyy" or substr($sFmtObj, $i, 4) eq "ggge"
l!l&&r!l&&!r
880300
substr($sFmtObj, $i, 4) eq "mmmm" or substr($sFmtObj, $i, 4) eq "dddd" or substr($sFmtObj, $i, 4) eq "yyyy"
l!l&&r!l&&!r
3058300
substr($sFmtObj, $i, 4) eq "mmmm" or substr($sFmtObj, $i, 4) eq "dddd"
l!l&&r!l&&!r
030358
MC/DC50%2/4
substr($sFmtObj, $i, 4) eq "mmmm" or substr($sFmtObj, $i, 4) eq "dddd" or substr($sFmtObj, $i, 4) eq "yyyy" or substr($sFmtObj, $i, 4) eq "ggge"
substr($sFmtObj, $i, 4) eq "mmmm" substr($sFmtObj, $i, 4) eq "dddd" substr($sFmtObj, $i, 4) eq "yyyy" substr($sFmtObj, $i, 4) eq "ggge"
Truth table60%3/5
A or B or C or D
A= substr($sFmtObj, $i, 4) eq "mmmm"B= substr($sFmtObj, $i, 4) eq "dddd"C= substr($sFmtObj, $i, 4) eq "yyyy"D= substr($sFmtObj, $i, 4) eq "ggge"
ABCDresult
1XXX1
01XX1
001X1
00011
00000
266 || (substr($sFmtObj, $i, 4) eq 'dddd')
267 || (substr($sFmtObj, $i, 4) eq 'yyyy')
268 || (substr($sFmtObj, $i, 4) eq 'ggge')) {
269 88 push @aRep, [substr($sFmtObj, $i, 4), length($sFmtRes), 4];
270 88 $i += 4;
271 ▶ } elsif ((substr($sFmtObj, $i, 3) eq 'mmm')
Condition83%5/6
substr($sFmtObj, $i, 3) eq "mmm" or substr($sFmtObj, $i, 3) eq "ddd" or substr($sFmtObj, $i, 3) eq "yyy"
l!l&&r!l&&!r
340266
substr($sFmtObj, $i, 3) eq "mmm" or substr($sFmtObj, $i, 3) eq "ddd"
l!l&&r!l&&!r
529266
MC/DC66%2/3
substr($sFmtObj, $i, 3) eq "mmm" or substr($sFmtObj, $i, 3) eq "ddd" or substr($sFmtObj, $i, 3) eq "yyy"
substr($sFmtObj, $i, 3) eq "mmm" substr($sFmtObj, $i, 3) eq "ddd" substr($sFmtObj, $i, 3) eq "yyy"
Truth table75%3/4
A or B or C
A= substr($sFmtObj, $i, 3) eq "mmm"B= substr($sFmtObj, $i, 3) eq "ddd"C= substr($sFmtObj, $i, 3) eq "yyy"
ABCresult
1XX1
01X1
0011
0000
272 || (substr($sFmtObj, $i, 3) eq 'ddd')
273 || (substr($sFmtObj, $i, 3) eq 'yyy')) {
274 34 push @aRep, [substr($sFmtObj, $i, 3), length($sFmtRes), 3];
275 34 $i += 3;
276 ▶ } elsif ((substr($sFmtObj, $i, 2) eq 'yy')
Condition93%14/15
substr($sFmtObj, $i, 2) eq "yy" or substr($sFmtObj, $i, 2) eq "mm" or substr($sFmtObj, $i, 2) eq "dd" or substr($sFmtObj, $i, 2) eq "hh" or substr($sFmtObj, $i, 2) eq "ss" or substr($sFmtObj, $i, 2) eq "ge"
l!l&&r!l&&!r
238028
substr($sFmtObj, $i, 2) eq "yy" or substr($sFmtObj, $i, 2) eq "mm" or substr($sFmtObj, $i, 2) eq "dd" or substr($sFmtObj, $i, 2) eq "hh" or substr($sFmtObj, $i, 2) eq "ss"
l!l&&r!l&&!r
1934528
substr($sFmtObj, $i, 2) eq "yy" or substr($sFmtObj, $i, 2) eq "mm" or substr($sFmtObj, $i, 2) eq "dd" or substr($sFmtObj, $i, 2) eq "hh"
l!l&&r!l&&!r
1712273
substr($sFmtObj, $i, 2) eq "yy" or substr($sFmtObj, $i, 2) eq "mm" or substr($sFmtObj, $i, 2) eq "dd"
l!l&&r!l&&!r
1106195
substr($sFmtObj, $i, 2) eq "yy" or substr($sFmtObj, $i, 2) eq "mm"
l!l&&r!l&&!r
6104156
MC/DC83%5/6
substr($sFmtObj, $i, 2) eq "yy" or substr($sFmtObj, $i, 2) eq "mm" or substr($sFmtObj, $i, 2) eq "dd" or substr($sFmtObj, $i, 2) eq "hh" or substr($sFmtObj, $i, 2) eq "ss" or substr($sFmtObj, $i, 2) eq "ge"
substr($sFmtObj, $i, 2) eq "yy" substr($sFmtObj, $i, 2) eq "mm" substr($sFmtObj, $i, 2) eq "dd" substr($sFmtObj, $i, 2) eq "hh" substr($sFmtObj, $i, 2) eq "ss" substr($sFmtObj, $i, 2) eq "ge"
Truth table85%6/7
A or B or C or D or E or F
A= substr($sFmtObj, $i, 2) eq "yy"B= substr($sFmtObj, $i, 2) eq "mm"C= substr($sFmtObj, $i, 2) eq "dd"D= substr($sFmtObj, $i, 2) eq "hh"E= substr($sFmtObj, $i, 2) eq "ss"F= substr($sFmtObj, $i, 2) eq "ge"
ABCDEFresult
1XXXXX1
01XXXX1
001XXX1
0001XX1
00001X1
0000011
0000000
277 || (substr($sFmtObj, $i, 2) eq 'mm')
278 || (substr($sFmtObj, $i, 2) eq 'dd')
279 || (substr($sFmtObj, $i, 2) eq 'hh')
280 || (substr($sFmtObj, $i, 2) eq 'ss')
281 || (substr($sFmtObj, $i, 2) eq 'ge')) {
282 238 ▶ if ( (substr($sFmtObj, $i, 2) eq 'mm')
Branch: 1 branch
BranchTrueFalseTotal
if (substr($sFmtObj, $i, 2) eq 'mm' and $#aRep >= 0 and $aRep[$#aRep][0] eq 'h' || $aRep[$#aRep][0] eq 'hh') { } 47 191 238
Condition88%8/9
substr($sFmtObj, $i, 2) eq "mm" and $#aRep >= 0 and $aRep[$#aRep][0] eq "h" || $aRep[$#aRep][0] eq "hh"
!ll&&!rl&&r
1345747
substr($sFmtObj, $i, 2) eq "mm" and $#aRep >= 0
!ll&&!rl&&r
1340104
$aRep[$#aRep][0] eq "h" or $aRep[$#aRep][0] eq "hh"
l!l&&r!l&&!r
252257
MC/DC75%3/4
substr($sFmtObj, $i, 2) eq "mm" and $#aRep >= 0 and $aRep[$#aRep][0] eq "h" || $aRep[$#aRep][0] eq "hh"
substr($sFmtObj, $i, 2) eq "mm" $#aRep >= 0 $aRep[$#aRep][0] eq "h" $aRep[$#aRep][0] eq "hh"
Truth table80%4/5
A and B and C or D
A= substr($sFmtObj, $i, 2) eq "mm"B= $#aRep >= 0C= $aRep[$#aRep][0] eq "h"D= $aRep[$#aRep][0] eq "hh"
ABCDresult
0XXX0
10XX0
11000
111X1
11011
283 && ($#aRep >= 0)
284 && (($aRep[$#aRep]->[0] eq 'h') or ($aRep[$#aRep]->[0] eq 'hh'))) {
285 47 push @aRep, ['mm', length($sFmtRes), 2, 'min'];
286 } else {
287 191 push @aRep, [substr($sFmtObj, $i, 2), length($sFmtRes), 2];
288 }
289 238 ▶ if ((substr($sFmtObj, $i, 2) eq 'ss') && ($#aRep > 0)) {
Branch: 1 branch
BranchTrueFalseTotal
if (substr($sFmtObj, $i, 2) eq "ss" and $#aRep > 0) 45 193 238
Condition66%2/3
substr($sFmtObj, $i, 2) eq "ss" and $#aRep > 0
!ll&&!rl&&r
193045
MC/DC50%1/2
substr($sFmtObj, $i, 2) eq "ss" and $#aRep > 0
substr($sFmtObj, $i, 2) eq "ss" $#aRep > 0
Truth table66%2/3
A and B
A= substr($sFmtObj, $i, 2) eq "ss"B= $#aRep > 0
ABresult
0X0
100
111
290 45 ▶ if ( ($aRep[$#aRep - 1]->[0] eq 'm')
Branch: 1 branch
BranchTrueFalseTotal
if ($aRep[$#aRep - 1][0] eq "m" or $aRep[$#aRep - 1][0] eq "mm") 45 0 45
Condition33%1/3
$aRep[$#aRep - 1][0] eq "m" or $aRep[$#aRep - 1][0] eq "mm"
l!l&&r!l&&!r
0450
MC/DC0%0/2
$aRep[$#aRep - 1][0] eq "m" or $aRep[$#aRep - 1][0] eq "mm"
$aRep[$#aRep - 1][0] eq "m" $aRep[$#aRep - 1][0] eq "mm"
Truth table33%1/3
A or B
A= $aRep[$#aRep - 1][0] eq "m"B= $aRep[$#aRep - 1][0] eq "mm"
ABresult
1X1
011
000
291 || ($aRep[$#aRep - 1]->[0] eq 'mm')) {
292 45 push(@{$aRep[$#aRep - 1]}, 'min');
293 }
294 }
295 238 $i += 2;
296 ▶ } elsif ((substr($sFmtObj, $i, 1) eq 'm')
Condition66%6/9
substr($sFmtObj, $i, 1) eq "m" or substr($sFmtObj, $i, 1) eq "d" or substr($sFmtObj, $i, 1) eq "h" or substr($sFmtObj, $i, 1) eq "s"
l!l&&r!l&&!r
2800
substr($sFmtObj, $i, 1) eq "m" or substr($sFmtObj, $i, 1) eq "d" or substr($sFmtObj, $i, 1) eq "h"
l!l&&r!l&&!r
3250
substr($sFmtObj, $i, 1) eq "m" or substr($sFmtObj, $i, 1) eq "d"
l!l&&r!l&&!r
1225
MC/DC0%0/4
substr($sFmtObj, $i, 1) eq "m" or substr($sFmtObj, $i, 1) eq "d" or substr($sFmtObj, $i, 1) eq "h" or substr($sFmtObj, $i, 1) eq "s"
substr($sFmtObj, $i, 1) eq "m" substr($sFmtObj, $i, 1) eq "d" substr($sFmtObj, $i, 1) eq "h" substr($sFmtObj, $i, 1) eq "s"
Truth table60%3/5
A or B or C or D
A= substr($sFmtObj, $i, 1) eq "m"B= substr($sFmtObj, $i, 1) eq "d"C= substr($sFmtObj, $i, 1) eq "h"D= substr($sFmtObj, $i, 1) eq "s"
ABCDresult
1XXX1
01XX1
001X1
00011
00000
297 || (substr($sFmtObj, $i, 1) eq 'd')
298 || (substr($sFmtObj, $i, 1) eq 'h')
299 || (substr($sFmtObj, $i, 1) eq 's')) {
300 28 ▶ if ( (substr($sFmtObj, $i, 1) eq 'm')
Branch: 1 branch
BranchTrueFalseTotal
if (substr($sFmtObj, $i, 1) eq 'm' and $#aRep >= 0 and $aRep[$#aRep][0] eq 'h' || $aRep[$#aRep][0] eq 'hh') { } 0 28 28
Condition33%3/9
substr($sFmtObj, $i, 1) eq "m" and $#aRep >= 0 and $aRep[$#aRep][0] eq "h" || $aRep[$#aRep][0] eq "hh"
!ll&&!rl&&r
2800
substr($sFmtObj, $i, 1) eq "m" and $#aRep >= 0
!ll&&!rl&&r
2710
$aRep[$#aRep][0] eq "h" or $aRep[$#aRep][0] eq "hh"
l!l&&r!l&&!r
000
MC/DC0%0/4
substr($sFmtObj, $i, 1) eq "m" and $#aRep >= 0 and $aRep[$#aRep][0] eq "h" || $aRep[$#aRep][0] eq "hh"
substr($sFmtObj, $i, 1) eq "m" $#aRep >= 0 $aRep[$#aRep][0] eq "h" $aRep[$#aRep][0] eq "hh"
Truth table40%2/5
A and B and C or D
A= substr($sFmtObj, $i, 1) eq "m"B= $#aRep >= 0C= $aRep[$#aRep][0] eq "h"D= $aRep[$#aRep][0] eq "hh"
ABCDresult
0XXX0
10XX0
11000
111X1
11011
301 && ($#aRep >= 0)
302 && (($aRep[$#aRep]->[0] eq 'h') or ($aRep[$#aRep]->[0] eq 'hh'))) {
303 0 push @aRep, ['m', length($sFmtRes), 1, 'min'];
304 } else {
305 28 push @aRep, [substr($sFmtObj, $i, 1), length($sFmtRes), 1];
306 }
307 28 ▶ if ((substr($sFmtObj, $i, 1) eq 's') && ($#aRep > 0)) {
Branch: 1 branch
BranchTrueFalseTotal
if (substr($sFmtObj, $i, 1) eq "s" and $#aRep > 0) 0 28 28
Condition33%1/3
substr($sFmtObj, $i, 1) eq "s" and $#aRep > 0
!ll&&!rl&&r
2800
MC/DC0%0/2
substr($sFmtObj, $i, 1) eq "s" and $#aRep > 0
substr($sFmtObj, $i, 1) eq "s" $#aRep > 0
Truth table33%1/3
A and B
A= substr($sFmtObj, $i, 1) eq "s"B= $#aRep > 0
ABresult
0X0
100
111
308 0 ▶ if ( ($aRep[$#aRep - 1]->[0] eq 'm')
Branch: 1 branch
BranchTrueFalseTotal
if ($aRep[$#aRep - 1][0] eq "m" or $aRep[$#aRep - 1][0] eq "mm") 0 0 0
Condition0%0/3
$aRep[$#aRep - 1][0] eq "m" or $aRep[$#aRep - 1][0] eq "mm"
l!l&&r!l&&!r
000
MC/DC0%0/2
$aRep[$#aRep - 1][0] eq "m" or $aRep[$#aRep - 1][0] eq "mm"
$aRep[$#aRep - 1][0] eq "m" $aRep[$#aRep - 1][0] eq "mm"
Truth table0%0/3
A or B
A= $aRep[$#aRep - 1][0] eq "m"B= $aRep[$#aRep - 1][0] eq "mm"
ABresult
1X1
011
000
309 || ($aRep[$#aRep - 1]->[0] eq 'mm')) {
310 0 push(@{$aRep[$#aRep - 1]}, 'min');
311 }
312 }
313 28 $i += 1;
314 }
315 } elsif ((substr($sFmtObj, $i, 3) eq '[h]')) {
316 0 push @aRep, ['[h]', length($sFmtRes), 3];
317 0 $i += 3;
318 } elsif ((substr($sFmtObj, $i, 4) eq '[mm]')) {
319 0 push @aRep, ['[mm]', length($sFmtRes), 4];
320 0 $i += 4;
321 } elsif ($sWk eq '@') {
322 1226 push @aRep, ['@', length($sFmtRes), 1];
323 1226 $i++;
324 } elsif ($sWk eq '*') {
325 0 push @aRep, [substr($sFmtObj, $i, 1), length($sFmtRes), 1];
326 } else {
327 255 $i++;
328 }
329 5977 ▶ $i++ if ($i == $iSt); #No Format match
Branch: 1 branch
BranchTrueFalseTotal
if $i == $iSt 0 5977 5977
330 5977 $sFmtRes .= substr($sFmtObj, $iSt, $i - $iSt);
331 }
332  
333 #print "FMT: $iRpos ",$sFmtRes, "\n";
334 2548 ▶ if ($iFflg != -1) {
Branch: 1 branch
BranchTrueFalseTotal
if ($iFflg != -1) 1068 1480 2548
335 1068 push @aRep, [substr($sFmtObj, $iFflg, $i - $iFflg + 1), $iRpos,, $i - $iFflg + 1];
336 1068 $iFflg = 0;
337 }
338  
339 #For Date format
340 2548 ▶ $iFmtMode = 0 if (defined $sType && $sType eq 'Text'); #Not Convert Non Numeric
Branch: 1 branch
BranchTrueFalseTotal
if defined $sType and $sType eq "Text" 1225 1323 2548
Condition100%3/3
defined $sType and $sType eq "Text"
!ll&&!rl&&r
19311301225
MC/DC100%2/2
defined $sType and $sType eq "Text"
defined $sType $sType eq "Text"
Truth table100%3/3
A and B
A= defined $sTypeB= $sType eq "Text"
ABresult
0X0
100
111
341 2548 ▶ if (($iFmtMode == 2) && ($iData =~ /$sNUMEXP/)) {
Branch: 2 branches
BranchTrueFalseTotal
if ($iFmtMode == 2 and $iData =~ /$sNUMEXP/) { } 170 2378 2548
elsif ($iFmtMode == 1 and $iData =~ /$sNUMEXP/) { } 1151 1227 2378
Condition66%2/3
$iFmtMode == 2 and $iData =~ /$sNUMEXP/
!ll&&!rl&&r
23780170
MC/DC50%1/2
$iFmtMode == 2 and $iData =~ /$sNUMEXP/
$iFmtMode == 2 $iData =~ /$sNUMEXP/
Truth table66%2/3
A and B
A= $iFmtMode == 2B= $iData =~ /$sNUMEXP/
ABresult
0X0
100
111
342 170 my @aTime = ExcelLocaltime($iData, $i1904);
343 169 $aTime[4]++;
344 169 $aTime[5] += 1900;
345  
346 169 my @aMonL = qw (dum January February March April May June July
347 August September October November December );
348 169 my @aMonNm = qw (dum Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec);
349 169 my @aWeekNm = qw (Sun Mon Tue Wed Thu Fri Sat);
350 169 my @aWeekL = qw (Sunday Monday Tuesday Wednesday Thursday Friday Saturday);
351 169 my $sRep;
352 169 ▶ for (my $iIt = $#aRep ; $iIt >= 0 ; $iIt--) {
Branch: 1 branch
BranchTrueFalseTotal
if ($iIt >= 0) 430 169 599
353 430 my $rItem = $aRep[$iIt];
354 430 ▶ if (defined($rItem->[3]) && $rItem->[3] eq 'min') {
Branch: 24 branches
BranchTrueFalseTotal
if (defined $rItem->[3] and $rItem->[3] eq 'min') { } 47 383 430
elsif ($rItem->[0] eq 'yyyy') { } 57 326 383
elsif ($rItem->[0] eq 'yy') { } 6 320 326
elsif ($rItem->[0] eq 'mmmmm') { } 0 320 320
elsif ($rItem->[0] eq 'mmmm') { } 0 320 320
elsif ($rItem->[0] eq 'mmm') { } 5 315 320
elsif ($rItem->[0] eq 'mm') { } 56 259 315
elsif ($rItem->[0] eq 'm') { } 1 258 259
elsif ($rItem->[0] eq 'dddd') { } 30 228 258
elsif ($rItem->[0] eq 'ddd') { } 29 199 228
elsif ($rItem->[0] eq 'dd') { } 60 139 199
elsif ($rItem->[0] eq 'd') { } 2 137 139
elsif ($rItem->[0] eq 'hh') { } 22 115 137
elsif ($rItem->[0] eq 'h') { } 25 90 115
elsif ($rItem->[0] eq 'ss') { } 45 45 90
elsif ($rItem->[0] eq 'S') { } 0 45 45
elsif ($rItem->[0] eq 'am/pm' or $rItem->[0] eq 'a/p') { } 45 0 45
elsif ($rItem->[0] eq '.') { } 0 0 0
elsif ($rItem->[0] =~ /^(0+)$/) { } 0 0 0
elsif ($rItem->[0] eq '[h]') { } 0 0 0
elsif ($rItem->[0] eq '[mm]') { } 0 0 0
elsif ($rItem->[0] eq 'ge') { } 0 0 0
elsif ($rItem->[0] eq 'ggge') { } 0 0 0
elsif ($rItem->[0] eq '@') { } 0 0 0
Condition100%3/3
defined $rItem->[3] and $rItem->[3] eq "min"
!ll&&!rl&&r
3384547
MC/DC100%2/2
defined $rItem->[3] and $rItem->[3] eq "min"
defined $rItem->[3] $rItem->[3] eq "min"
Truth table100%3/3
A and B
A= defined $rItem->[3]B= $rItem->[3] eq "min"
ABresult
0X0
100
111
355  
356 #Min
357 47 ▶ if ($rItem->[0] eq 'mm') {
Branch: 1 branch
BranchTrueFalseTotal
if ($rItem->[0] eq 'mm') { } 47 0 47
358 47 $sRep = sprintf("%02d", $aTime[1]);
359 } else {
360 0 $sRep = sprintf("%d", $aTime[1]);
361 }
362 }
363  
364 #Year
365 elsif ($rItem->[0] eq 'yyyy') {
366 57 $sRep = sprintf('%04d', $aTime[5]);
367 } elsif ($rItem->[0] eq 'yy') {
368 6 $sRep = sprintf('%02d', $aTime[5] % 100);
369 }
370  
371 #Mon
372 elsif ($rItem->[0] eq 'mmmmm') {
373 0 $sRep = substr($aMonNm[$aTime[4]], 0, 1);
374 } elsif ($rItem->[0] eq 'mmmm') {
375 0 $sRep = $aMonL[$aTime[4]];
376 } elsif ($rItem->[0] eq 'mmm') {
377 5 $sRep = $aMonNm[$aTime[4]];
378 } elsif ($rItem->[0] eq 'mm') {
379 56 $sRep = sprintf('%02d', $aTime[4]);
380 } elsif ($rItem->[0] eq 'm') {
381 1 $sRep = sprintf('%d', $aTime[4]);
382 }
383  
384 #Day
385 elsif ($rItem->[0] eq 'dddd') {
386 30 $sRep = $aWeekL[$aTime[6]];
387 } elsif ($rItem->[0] eq 'ddd') {
388 29 $sRep = $aWeekNm[$aTime[6]];
389 } elsif ($rItem->[0] eq 'dd') {
390 60 $sRep = sprintf('%02d', $aTime[3]);
391 } elsif ($rItem->[0] eq 'd') {
392 2 $sRep = sprintf('%d', $aTime[3]);
393 }
394  
395 #Hour
396 elsif ($rItem->[0] eq 'hh') {
397 22 ▶ if ($iAm) {
Branch: 1 branch
BranchTrueFalseTotal
if ($iAm) { } 20 2 22
398 20 ▶ $sRep = sprintf('%02d', ($aTime[2] % 12) || 12);
Condition100%2/2
$aTime[2] % 12 || 12
l!l
1010
MC/DC100%1/1
$aTime[2] % 12 || 12
$aTime[2] % 12
Truth table100%2/2
A
A= $aTime[2] % 12
Aresult
11
00
399 } else {
400 2 $sRep = sprintf('%02d', $aTime[2]);
401 }
402 } elsif ($rItem->[0] eq 'h') {
403 25 ▶ if ($iAm) {
Branch: 1 branch
BranchTrueFalseTotal
if ($iAm) { } 21 4 25
404 21 ▶ $sRep = sprintf('%d', ($aTime[2] % 12) || 12);
Condition100%2/2
$aTime[2] % 12 || 12
l!l
1011
MC/DC100%1/1
$aTime[2] % 12 || 12
$aTime[2] % 12
Truth table100%2/2
A
A= $aTime[2] % 12
Aresult
11
00
405 } else {
406 4 $sRep = sprintf('%d', $aTime[2]);
407 }
408 }
409  
410 #SS
411 elsif ($rItem->[0] eq 'ss') {
412 45 $sRep = sprintf('%02d', $aTime[0]);
413 } elsif ($rItem->[0] eq 'S') {
414 0 $sRep = sprintf('%d', $aTime[0]);
415 }
416  
417 #am/pm
418 ▶ elsif ($rItem->[0] eq 'am/pm' || $rItem->[0] eq 'a/p') {
Condition66%2/3
$rItem->[0] eq "am/pm" or $rItem->[0] eq "a/p"
l!l&&r!l&&!r
28170
MC/DC0%0/2
$rItem->[0] eq "am/pm" or $rItem->[0] eq "a/p"
$rItem->[0] eq "am/pm" $rItem->[0] eq "a/p"
Truth table66%2/3
A or B
A= $rItem->[0] eq "am/pm"B= $rItem->[0] eq "a/p"
ABresult
1X1
011
000
419 45 my @periods = split '/', $rItem->[3];
420 45 ▶ $sRep = $periods[$aTime[2] >= 12 ? 1 : 0];
Branch: 1 branch
BranchTrueFalseTotal
$aTime[2] >= 12 ? : 23 22 45
421 } elsif ($rItem->[0] eq '.') {
422 0 $sRep = '.';
423 } elsif ($rItem->[0] =~ /^(0+)$/) {
424 0 my $fraction_digits = length($1);
425  
426 #print "SEC:", $aTime[7], "\n";
427 0 $sRep = substr(sprintf("%.${fraction_digits}f", $aTime[7] / 1000.0), 2, $fraction_digits);
428 } elsif ($rItem->[0] eq '[h]') {
429 0 $sRep = sprintf('%d', int($iData) * 24 + $aTime[2]);
430 } elsif ($rItem->[0] eq '[mm]') {
431 0 $sRep = sprintf('%d', (int($iData) * 24 + $aTime[2]) * 60 + $aTime[1]);
432 }
433  
434 #NENGO(Japanese)
435 elsif ($rItem->[0] eq 'ge') {
436 0 $sRep = Spreadsheet::XLSX::FmtJapan::CnvNengo(1, @aTime);
437 } elsif ($rItem->[0] eq 'ggge') {
438 0 $sRep = Spreadsheet::XLSX::FmtJapan::CnvNengo(2, @aTime);
439 } elsif ($rItem->[0] eq '@') {
440 0 $sRep = $iData;
441 }
442  
443 #print "REP:$sRep ",$rItem->[0], ":", $rItem->[1], ":" ,$rItem->[2], "\n";
444 430 substr($sFmtRes, $rItem->[1], $rItem->[2]) = $sRep;
445 }
446 ▶ } elsif (($iFmtMode == 1) && ($iData =~ /$sNUMEXP/)) {
Condition66%2/3
$iFmtMode == 1 and $iData =~ /$sNUMEXP/
!ll&&!rl&&r
122701151
MC/DC50%1/2
$iFmtMode == 1 and $iData =~ /$sNUMEXP/
$iFmtMode == 1 $iData =~ /$sNUMEXP/
Truth table66%2/3
A and B
A= $iFmtMode == 1B= $iData =~ /$sNUMEXP/
ABresult
0X0
100
111
447 1151 ▶ if ($#aRep >= 0) {
Branch: 1 branch
BranchTrueFalseTotal
if ($#aRep >= 0) 1151 0 1151
448 1151 ▶ while ($aRep[$#aRep]->[0] eq ',') {
Branch: 1 branch
BranchTrueFalseTotal
if ($aRep[$#aRep][0] eq ",") 0 1151 1151
449 0 $iCmmCnt--;
450 0 substr($sFmtRes, $aRep[$#aRep]->[1], $aRep[$#aRep]->[2]) = '';
451 0 $iData /= 1000;
452 0 pop @aRep;
453 }
454  
455 1151 my $sNumFmt = join('', map {$_->[0]} @aRep);
456 1151 my $sNumRes;
457 1151 my $iTtl = 0;
458 1151 my $iE = 0;
459 1151 my $iP = 0;
460 1151 my $iInt = 0;
461 1151 my $iAftP = undef;
462 1151 foreach my $sItem (split //, $sNumFmt) {
463 4678 ▶ if ($sItem eq '.') {
Branch: 5 branches
BranchTrueFalseTotal
if ($sItem eq '.') { } 829 3849 4678
elsif ($sItem eq 'E' or $sItem eq 'e') { } 80 3769 3849
elsif ($sItem eq '0') { } 3605 164 3769
elsif ($sItem eq '#') { } 3 161 164
elsif ($sItem eq '?') { } 0 161 161
464 829 $iTtl++;
465 829 $iP = 1;
466 ▶ } elsif (($sItem eq 'E') || ($sItem eq 'e')) {
Condition66%2/3
$sItem eq "E" or $sItem eq "e"
l!l&&r!l&&!r
8003769
MC/DC50%1/2
$sItem eq "E" or $sItem eq "e"
$sItem eq "E" $sItem eq "e"
Truth table66%2/3
A or B
A= $sItem eq "E"B= $sItem eq "e"
ABresult
1X1
011
000
467 80 $iE = 1;
468 } elsif ($sItem eq '0') {
469 3605 $iTtl++;
470 3605 ▶ $iAftP++ if ($iP);
Branch: 1 branch
BranchTrueFalseTotal
if $iP 2342 1263 3605
471 3605 $iInt = 1;
472 } elsif ($sItem eq '#') {
473  
474 #$iTtl++;
475 3 ▶ $iAftP++ if ($iP);
Branch: 1 branch
BranchTrueFalseTotal
if $iP 0 3 3
476 3 $iInt = 1;
477 } elsif ($sItem eq '?') {
478  
479 #$iTtl++;
480 0 ▶ $iAftP++ if ($iP);
Branch: 1 branch
BranchTrueFalseTotal
if $iP 0 0 0
481 }
482 }
483 1151 ▶ $iData *= 100.0 if ($iPer);
Branch: 1 branch
BranchTrueFalseTotal
if $iPer 3 1148 1151
484 1151 ▶ my $iDData = ($iFugouFlg) ? abs($iData) : $iData + 0;
Branch: 1 branch
BranchTrueFalseTotal
$iFugouFlg ? : 80 1071 1151
485 1151 ▶ if ($iBunFlg) {
Branch: 1 branch
BranchTrueFalseTotal
if ($iBunFlg) { } 0 1151 1151
486 0 $sNumRes = sprintf("%0${iTtl}d", int($iDData));
487 } else {
488 1151 ▶ if ($iP) {
Branch: 1 branch
BranchTrueFalseTotal
if ($iP) { } 829 322 1151
489 829 ▶ $sNumRes = sprintf((defined($iAftP) ? "%0${iTtl}.${iAftP}f" : "%0${iTtl}f"), $iDData);
Branch: 1 branch
BranchTrueFalseTotal
defined $iAftP ? : 829 0 829
490 } else {
491 322 $sNumRes = sprintf("%0${iTtl}.0f", $iDData);
492 }
493 }
494 1151 ▶ $sNumRes = AddComma($sNumRes) if ($iCmmCnt > 0);
Branch: 1 branch
BranchTrueFalseTotal
if $iCmmCnt > 0 1 1150 1151
495 1151 my $iLen = length($sNumRes);
496 1151 my $iPPos = -1;
497 1151 my $sRep;
498  
499 1151 ▶ for (my $iIt = $#aRep ; $iIt >= 0 ; $iIt--) {
Branch: 1 branch
BranchTrueFalseTotal
if ($iIt >= 0) 2731 1151 3882
500 2731 my $rItem = $aRep[$iIt];
501 2731 ▶ if ($rItem->[0] =~ /([#0]*)([\.]?)([0#]*)([eE])([\+\-])([0#]+)/) {
Branch: 9 branches
BranchTrueFalseTotal
if ($rItem->[0] =~ /([#0]*)([\.]?)([0#]*)([eE])([\+\-])([0#]+)/) { } 80 2651 2731
elsif ($rItem->[0] =~ m[/]) { } 0 2651 2651
elsif ($rItem->[0] eq '.') { } 749 1902 2651
elsif ($rItem->[0] eq '+') { } 80 1822 1902
elsif ($rItem->[0] eq '-') { } 0 1822 1822
elsif ($rItem->[0] eq '@') { } 0 1822 1822
elsif ($rItem->[0] eq '*') { } 0 1822 1822
elsif ($rItem->[0] eq "\242\244" or $rItem->[0] eq "\242\245" or $rItem->[0] eq "\201\242" or $rItem->[0] eq "\201\243") { } 0 1822 1822
elsif ($rItem->[0] eq '(' or $rItem->[0] eq ')') { } 0 1822 1822
502 80 substr($sFmtRes, $rItem->[1], $rItem->[2]) =
503 MakeE($rItem->[0], $iData);
504 } elsif ($rItem->[0] =~ /\//) {
505 0 substr($sFmtRes, $rItem->[1], $rItem->[2]) =
506 MakeBun($rItem->[0], $iData, $iInt);
507 } elsif ($rItem->[0] eq '.') {
508 749 $iLen--;
509 749 $iPPos = $iLen;
510 } elsif ($rItem->[0] eq '+') {
511 80 ▶ substr($sFmtRes, $rItem->[1], $rItem->[2]) =
Branch: 2 branches
BranchTrueFalseTotal
$iData > 0 ? : 0 80 80
$iData == 0 ? : 0 80 80
512 ($iData > 0) ? '+' : (($iData == 0) ? '+' : '-');
513 } elsif ($rItem->[0] eq '-') {
514 0 ▶ substr($sFmtRes, $rItem->[1], $rItem->[2]) =
Branch: 2 branches
BranchTrueFalseTotal
$iData > 0 ? : 0 0 0
$iData == 0 ? : 0 0 0
515 ($iData > 0) ? '' : (($iData == 0) ? '' : '-');
516 } elsif ($rItem->[0] eq '@') {
517 0 substr($sFmtRes, $rItem->[1], $rItem->[2]) = $iData;
518 } elsif ($rItem->[0] eq '*') {
519 0 substr($sFmtRes, $rItem->[1], $rItem->[2]) = ''; #REMOVE
520 ▶ } elsif (($rItem->[0] eq "\xA2\xA4")
Condition33%3/9
$rItem->[0] eq "\242\244" or $rItem->[0] eq "\242\245" or $rItem->[0] eq "\201\242" or $rItem->[0] eq "\201\243"
l!l&&r!l&&!r
001822
$rItem->[0] eq "\242\244" or $rItem->[0] eq "\242\245" or $rItem->[0] eq "\201\242"
l!l&&r!l&&!r
001822
$rItem->[0] eq "\242\244" or $rItem->[0] eq "\242\245"
l!l&&r!l&&!r
001822
MC/DC0%0/4
$rItem->[0] eq "\242\244" or $rItem->[0] eq "\242\245" or $rItem->[0] eq "\201\242" or $rItem->[0] eq "\201\243"
$rItem->[0] eq "\242\244" $rItem->[0] eq "\242\245" $rItem->[0] eq "\201\242" $rItem->[0] eq "\201\243"
Truth table20%1/5
A or B or C or D
A= $rItem->[0] eq "\242\244"B= $rItem->[0] eq "\242\245"C= $rItem->[0] eq "\201\242"D= $rItem->[0] eq "\201\243"
ABCDresult
1XXX1
01XX1
001X1
00011
00000
521 or ($rItem->[0] eq "\xA2\xA5")
522 or ($rItem->[0] eq "\x81\xA2")
523 or ($rItem->[0] eq "\x81\xA3")) {
524 0 substr($sFmtRes, $rItem->[1], $rItem->[2]) = $rItem->[0];
525 ▶ } elsif (($rItem->[0] eq '(') or ($rItem->[0] eq ')')) {
Condition33%1/3
$rItem->[0] eq "(" or $rItem->[0] eq ")"
l!l&&r!l&&!r
001822
MC/DC0%0/2
$rItem->[0] eq "(" or $rItem->[0] eq ")"
$rItem->[0] eq "(" $rItem->[0] eq ")"
Truth table33%1/3
A or B
A= $rItem->[0] eq "("B= $rItem->[0] eq ")"
ABresult
1X1
011
000
526 0 substr($sFmtRes, $rItem->[1], $rItem->[2]) = $rItem->[0];
527 } else {
528 1822 ▶ if ($iLen > 0) {
Branch: 1 branch
BranchTrueFalseTotal
if ($iLen > 0) { } 1822 0 1822
529 1822 ▶ if ($iIt <= 0) {
Branch: 1 branch
BranchTrueFalseTotal
if ($iIt <= 0) { } 991 831 1822
530 991 $sRep = substr($sNumRes, 0, $iLen);
531 991 $iLen = 0;
532 } else {
533 831 my $iReal = length($rItem->[0]);
534 831 ▶ if ($iPPos >= 0) {
Branch: 1 branch
BranchTrueFalseTotal
if ($iPPos >= 0) { } 2 829 831
535 2 my $sWkF = $rItem->[0];
536 2 $sWkF =~ s/^#+//;
537 2 $iReal = length($sWkF);
538 2 ▶ $iReal = ($iLen <= $iReal) ? $iLen : $iReal;
Branch: 1 branch
BranchTrueFalseTotal
$iLen <= $iReal ? : 0 2 2
539 } else {
540 829 ▶ $iReal = ($iLen <= $iReal) ? $iLen : $iReal;
Branch: 1 branch
BranchTrueFalseTotal
$iLen <= $iReal ? : 80 749 829
541 }
542 831 $sRep = substr($sNumRes, $iLen - $iReal, $iReal);
543 831 $iLen -= $iReal;
544 }
545 } else {
546 0 $sRep = '';
547 }
548 1822 substr($sFmtRes, $rItem->[1], $rItem->[2]) = "\x00" . $sRep;
549 }
550 }
551 1151 ▶ $sRep = ($iLen > 0) ? substr($sNumRes, 0, $iLen) : '';
Branch: 1 branch
BranchTrueFalseTotal
$iLen > 0 ? : 80 1071 1151
552 1151 $sFmtRes =~ s/\x00/$sRep/;
553 1151 $sFmtRes =~ s/\x00//g;
554 }
555 } else {
556 1227 my $iAtMk = 0;
557 1227 ▶ for (my $iIt = $#aRep ; $iIt >= 0 ; $iIt--) {
Branch: 1 branch
BranchTrueFalseTotal
if ($iIt >= 0) 1226 1227 2453
558 1226 my $rItem = $aRep[$iIt];
559 1226 ▶ if ($rItem->[0] eq '@') {
Branch: 1 branch
BranchTrueFalseTotal
if ($rItem->[0] eq '@') { } 1226 0 1226
560 1226 substr($sFmtRes, $rItem->[1], $rItem->[2]) = $iData;
561 1226 $iAtMk++;
562 } else {
563 0 substr($sFmtRes, $rItem->[1], $rItem->[2]) = '';
564 }
565 }
566 1227 ▶ $sFmtRes = $iData unless ($iAtMk);
Branch: 1 branch
BranchTrueFalseTotal
unless $iAtMk 1 1226 1227
567 }
568 2547 ▶ return wantarray() ? ($sFmtRes, $sColor) : $sFmtRes;
Branch: 1 branch
BranchTrueFalseTotal
wantarray ? : 0 2547 2547
569 }
570  
571 #------------------------------------------------------------------------------
572 # AddComma (for Spreadsheet::XLSX::Utility2007)
573 #------------------------------------------------------------------------------
574 1 ▶sub AddComma {
Subroutine AddComma: called CC=3 SCAR=11.2
Pod undocumented
575 1 my ($sNum) = @_;
576  
577 1 ▶ if ($sNum =~ /^([^\d]*)(\d\d\d\d+)(\.*.*)$/) {
Branch: 1 branch
BranchTrueFalseTotal
if ($sNum =~ /^([^\d]*)(\d\d\d\d+)(\.*.*)$/) { } 1 0 1
578 1 my ($sPre, $sObj, $sAft) = ($1, $2, $3);
579 1 ▶ for (my $i = length($sObj) - 3 ; $i > 0 ; $i -= 3) {
Branch: 1 branch
BranchTrueFalseTotal
if ($i > 0) 1 1 2
580 1 substr($sObj, $i, 0) = ',';
581 }
582 1 return $sPre . $sObj . $sAft;
583 } else {
584 0 return $sNum;
585 }
586 }
587  
588 #------------------------------------------------------------------------------
589 # MakeBun (for Spreadsheet::XLSX::Utility2007)
590 #------------------------------------------------------------------------------
591 0 ▶sub MakeBun {
Subroutine MakeBun: not called CC=7 SCAR=40.3
Pod undocumented
592 0 my ($sFmt, $iData, $iFlg) = @_;
593 0 my $iBunbo;
594 my $iShou;
595  
596 #1. Init
597 #print "FLG: $iFlg\n";
598 0 ▶ if ($iFlg) {
Branch: 1 branch
BranchTrueFalseTotal
if ($iFlg) { } 0 0 0
599 0 $iShou = $iData - int($iData);
600 0 ▶ return '' if ($iShou == 0);
Branch: 1 branch
BranchTrueFalseTotal
if $iShou == 0 0 0 0
601 } else {
602 0 $iShou = $iData;
603 }
604 0 $iShou = abs($iShou);
605 0 my $sSWk;
606  
607 #2.Calc BUNBO
608 #2.1 BUNBO defined
609 0 ▶ if ($sFmt =~ /\/(\d+)$/) {
Branch: 1 branch
BranchTrueFalseTotal
if ($sFmt =~ m[/(\d+)$]) { } 0 0 0
610 0 $iBunbo = $1;
611 0 return sprintf("%d/%d", $iShou * $iBunbo, $iBunbo);
612 } else {
613  
614 #2.2 Calc BUNBO
615 0 $sFmt =~ /\/(\?+)$/;
616 0 my $iKeta = length($1);
617 0 my $iSWk = 1;
618 0 my $sSWk = '';
619 0 my $iBunsi;
620 0 ▶ for (my $iBunbo = 2 ; $iBunbo < 10**$iKeta ; $iBunbo++) {
Branch: 1 branch
BranchTrueFalseTotal
if ($iBunbo < 10 ** $iKeta) 0 0 0
621 0 $iBunsi = int($iShou * $iBunbo + 0.5);
622 0 my $iCmp = abs($iShou - ($iBunsi / $iBunbo));
623 0 ▶ if ($iCmp < $iSWk) {
Branch: 1 branch
BranchTrueFalseTotal
if ($iCmp < $iSWk) 0 0 0
624 0 $iSWk = $iCmp;
625 0 $sSWk = sprintf("%d/%d", $iBunsi, $iBunbo);
626 0 ▶ last if ($iSWk == 0);
Branch: 1 branch
BranchTrueFalseTotal
if $iSWk == 0 0 0 0
627 }
628 }
629 0 return $sSWk;
630 }
631 }
632  
633 #------------------------------------------------------------------------------
634 # MakeE (for Spreadsheet::XLSX::Utility2007)
635 #------------------------------------------------------------------------------
636 80 ▶sub MakeE {
Subroutine MakeE: called CC=4 SCAR=14.1
Pod undocumented
637 80 my ($sFmt, $iData) = @_;
638  
639 80 $sFmt =~ /(([#0]*)[\.]?[#0]*)([eE])([\+\-][0#]+)/;
640 80 my ($sKari, $iKeta, $sE, $sSisu) = ($1, length($2), $3, $4);
641 80 ▶ $iKeta = 1 if ($iKeta <= 0);
Branch: 1 branch
BranchTrueFalseTotal
if $iKeta <= 0 0 80 80
642  
643 80 my $iLog10 = 0;
644 80 ▶ $iLog10 = ($iData == 0) ? 0 : (log(abs($iData)) / log(10));
Branch: 1 branch
BranchTrueFalseTotal
$iData == 0 ? : 0 80 80
645 80 ▶ $iLog10 = (int($iLog10 / $iKeta) + ((($iLog10 - int($iLog10 / $iKeta)) < 0) ? -1 : 0)) * $iKeta;
Branch: 1 branch
BranchTrueFalseTotal
$iLog10 - int($iLog10 / $iKeta) < 0 ? : 80 0 80
646  
647 80 my $sUe = ExcelFmt($sKari, $iData * (10**($iLog10 * -1)), 0);
648 80 my $sShita = ExcelFmt($sSisu, $iLog10, 0);
649 80 return $sUe . $sE . $sShita;
650 }
651  
652 #------------------------------------------------------------------------------
653 # LeapYear (for Spreadsheet::XLSX::Utility2007)
654 #------------------------------------------------------------------------------
655 0 ▶sub LeapYear {
Subroutine LeapYear: not called CC=5 SCAR=34.0
Pod undocumented
656 0 my ($iYear) = @_;
657 0 ▶ return 1 if ($iYear == 1900); #Special for Excel
Branch: 1 branch
BranchTrueFalseTotal
if $iYear == 1900 0 0 0
658 0 ▶ return ((($iYear % 4) == 0) && (($iYear % 100) || ($iYear % 400) == 0)) ? 1 : 0;
Branch: 1 branch
BranchTrueFalseTotal
$iYear % 4 == 0 && ($iYear % 100 || $iYear % 400 == 0) ? : 0 0 0
Condition0%0/6
$iYear % 4 == 0 and $iYear % 100 || $iYear % 400 == 0
!ll&&!rl&&r
000
$iYear % 100 or $iYear % 400 == 0
l!l&&r!l&&!r
000
MC/DC0%0/3
$iYear % 4 == 0 and $iYear % 100 || $iYear % 400 == 0
$iYear % 4 == 0 $iYear % 100 $iYear % 400 == 0
Truth table0%0/4
A and B or C
A= $iYear % 4 == 0B= $iYear % 100C= $iYear % 400 == 0
ABCresult
0XX0
1000
11X1
1011
659 }
660  
661 #------------------------------------------------------------------------------
662 # LocaltimeExcel (for Spreadsheet::XLSX::Utility2007)
663 #------------------------------------------------------------------------------
664 0 ▶sub LocaltimeExcel {
Subroutine LocaltimeExcel: not called CC=19 SCAR=59.4
Pod documented
665 0 my ($iSec, $iMin, $iHour, $iDay, $iMon, $iYear, $iMSec, $flg1904) = @_;
666  
667 #0. Init
668 0 $iMon++;
669 0 $iYear += 1900;
670  
671 #1. Calc Time
672 0 my $iTime;
673 0 $iTime = $iHour;
674 0 $iTime *= 60;
675 0 $iTime += $iMin;
676 0 $iTime *= 60;
677 0 $iTime += $iSec;
678 0 ▶ $iTime += $iMSec / 1000.0 if (defined($iMSec));
Branch: 1 branch
BranchTrueFalseTotal
if defined $iMSec 0 0 0
679 0 $iTime /= 86400.0; #3600*24(1day in seconds)
680 0 my $iY;
681 my $iYDays;
682  
683 #2. Calc Days
684 0 ▶ if ($flg1904) {
Branch: 1 branch
BranchTrueFalseTotal
if ($flg1904) { } 0 0 0
685 0 $iY = 1904;
686 0 $iTime--; #Start from Jan 1st
687 0 $iYDays = 366;
688 } else {
689 0 $iY = 1900;
690 0 $iYDays = 366; #In Excel 1900 is leap year (That's not TRUE!)
691 }
692 0 ▶ while ($iY < $iYear) {
Branch: 1 branch
BranchTrueFalseTotal
if ($iY < $iYear) 0 0 0
693 0 $iTime += $iYDays;
694 0 $iY++;
695 0 ▶ $iYDays = (LeapYear($iY)) ? 366 : 365;
Branch: 1 branch
BranchTrueFalseTotal
LeapYear($iY) ? : 0 0 0
696 }
697 0 ▶ for (my $iM = 1 ; $iM < $iMon ; $iM++) {
Branch: 1 branch
BranchTrueFalseTotal
if ($iM < $iMon) 0 0 0
698 0 ▶ if ( $iM == 1
Branch: 3 branches
BranchTrueFalseTotal
if ($iM == 1 or $iM == 3 or $iM == 5 or $iM == 7 or $iM == 8 or $iM == 10 or $iM == 12) { } 0 0 0
elsif ($iM == 4 or $iM == 6 or $iM == 9 or $iM == 11) { } 0 0 0
elsif ($iM == 2) { } 0 0 0
Condition0%0/18
$iM == 1 or $iM == 3 or $iM == 5 or $iM == 7 or $iM == 8 or $iM == 10 or $iM == 12
l!l&&r!l&&!r
000
$iM == 1 or $iM == 3 or $iM == 5 or $iM == 7 or $iM == 8 or $iM == 10
l!l&&r!l&&!r
000
$iM == 1 or $iM == 3 or $iM == 5 or $iM == 7 or $iM == 8
l!l&&r!l&&!r
000
$iM == 1 or $iM == 3 or $iM == 5 or $iM == 7
l!l&&r!l&&!r
000
$iM == 1 or $iM == 3 or $iM == 5
l!l&&r!l&&!r
000
$iM == 1 or $iM == 3
l!l&&r!l&&!r
000
MC/DC0%0/7
$iM == 1 or $iM == 3 or $iM == 5 or $iM == 7 or $iM == 8 or $iM == 10 or $iM == 12
$iM == 1 $iM == 3 $iM == 5 $iM == 7 $iM == 8 $iM == 10 $iM == 12
Truth table0%0/8
A or B or C or D or E or F or G
A= $iM == 1B= $iM == 3C= $iM == 5D= $iM == 7E= $iM == 8F= $iM == 10G= $iM == 12
ABCDEFGresult
1XXXXXX1
01XXXXX1
001XXXX1
0001XXX1
00001XX1
000001X1
00000011
00000000
699 || $iM == 3
700 || $iM == 5
701 || $iM == 7
702 || $iM == 8
703 || $iM == 10
704 || $iM == 12) {
705 0 $iTime += 31;
706 ▶ } elsif ($iM == 4 || $iM == 6 || $iM == 9 || $iM == 11) {
Condition0%0/9
$iM == 4 or $iM == 6 or $iM == 9 or $iM == 11
l!l&&r!l&&!r
000
$iM == 4 or $iM == 6 or $iM == 9
l!l&&r!l&&!r
000
$iM == 4 or $iM == 6
l!l&&r!l&&!r
000
MC/DC0%0/4
$iM == 4 or $iM == 6 or $iM == 9 or $iM == 11
$iM == 4 $iM == 6 $iM == 9 $iM == 11
Truth table0%0/5
A or B or C or D
A= $iM == 4B= $iM == 6C= $iM == 9D= $iM == 11
ABCDresult
1XXX1
01XX1
001X1
00011
00000
707 0 $iTime += 30;
708 } elsif ($iM == 2) {
709 0 ▶ $iTime += (LeapYear($iYear)) ? 29 : 28;
Branch: 1 branch
BranchTrueFalseTotal
LeapYear($iYear) ? : 0 0 0
710 }
711 }
712 0 $iTime += $iDay;
713 0 return $iTime;
714 }
715  
716 #------------------------------------------------------------------------------
717 # ExcelLocaltime (for Spreadsheet::XLSX::Utility2007)
718 #------------------------------------------------------------------------------
719 188 ▶sub ExcelLocaltime {
Subroutine ExcelLocaltime: called CC=26 SCAR=32.6
Pod documented
720 188 my ($dObj, $flg1904) = @_;
721 # Excel dates end on 9999-12-31; allow the fractional time on that day.
722 # Check before int() and the year loop, including numbers that overflow
723 # to infinity when converted from scientific notation.
724 188 ▶ my $limit = $flg1904 ? 2957004 : 2958466;
Branch: 1 branch
BranchTrueFalseTotal
$flg1904 ? : 40 148 188
725 188 ▶ die "Invalid or out-of-range XLSX date value\n"
Branch: 1 branch
BranchTrueFalseTotal
unless defined $dObj and $dObj =~ /\A[+-]?(?:[0-9]+(?:\.[0-9]*)?|\.[0-9]+)(?:[eE][+-]?[0-9]+)?\z/ and $dObj >= 0 and $dObj < $limit 19 169 188
Condition100%9/9
defined $dObj and $dObj =~ /\A[+-]?(?:[0-9]+(?:\.[0-9]*)?|\.[0-9]+)(?:[eE][+-]?[0-9]+)?\z/ and $dObj >= 0 and $dObj < $limit
!ll&&!rl&&r
109169
defined $dObj and $dObj =~ /\A[+-]?(?:[0-9]+(?:\.[0-9]*)?|\.[0-9]+)(?:[eE][+-]?[0-9]+)?\z/ and $dObj >= 0
!ll&&!rl&&r
82178
defined $dObj and $dObj =~ /\A[+-]?(?:[0-9]+(?:\.[0-9]*)?|\.[0-9]+)(?:[eE][+-]?[0-9]+)?\z/
!ll&&!rl&&r
26180
MC/DC100%4/4
defined $dObj and $dObj =~ /\A[+-]?(?:[0-9]+(?:\.[0-9]*)?|\.[0-9]+)(?:[eE][+-]?[0-9]+)?\z/ and $dObj >= 0 and $dObj < $limit
defined $dObj $dObj =~ /\A[+-]?(?:[0-9]+(?:\.[0-9]*)?|\.[0-9]+)(?:[eE][+-]?[0-9]+)?\z/ $dObj >= 0 $dObj < $limit
Truth table100%5/5
A and B and C and D
A= defined $dObjB= $dObj =~ /\A[+-]?(?:[0-9]+(?:\.[0-9]*)?|\.[0-9]+)(?:[eE][+-]?[0-9]+)?\z/C= $dObj >= 0D= $dObj < $limit
ABCDresult
0XXX0
10XX0
110X0
11100
11111
726 unless defined($dObj)
727 && $dObj =~ /\A[+-]?(?:[0-9]+(?:\.[0-9]*)?|\.[0-9]+)(?:[eE][+-]?[0-9]+)?\z/
728 && $dObj >= 0 && $dObj < $limit;
729 169 my ($iSec, $iMin, $iHour, $iDay, $iMon, $iYear, $iwDay, $iMSec);
730 169 my ($iDt, $iTime, $iYDays);
731  
732 169 $iDt = int($dObj);
733 169 $iTime = $dObj - $iDt;
734  
735 #1. Calc Days
736 169 ▶ if ($flg1904) {
Branch: 1 branch
BranchTrueFalseTotal
if ($flg1904) { } 31 138 169
737 31 $iYear = 1904;
738 31 $iDt++; #Start from Jan 1st
739 31 $iYDays = 366;
740 31 $iwDay = (($iDt + 4) % 7);
741 } else {
742 138 $iYear = 1900;
743 138 $iYDays = 366; #In Excel 1900 is leap year (That's not TRUE!)
744 138 $iwDay = (($iDt + 6) % 7);
745 }
746 169 ▶ while ($iDt > $iYDays) {
Branch: 1 branch
BranchTrueFalseTotal
if ($iDt > $iYDays) 45177 169 45346
747 45177 $iDt -= $iYDays;
748 45177 $iYear++;
749 45177 ▶ $iYDays =
Branch: 1 branch
BranchTrueFalseTotal
$iYear % 4 == 0 && ($iYear % 100 || $iYear % 400 == 0) ? : 11038 34139 45177
Condition100%6/6
$iYear % 4 == 0 and $iYear % 100 || $iYear % 400 == 0
!ll&&!rl&&r
3389924011038
$iYear % 100 or $iYear % 400 == 0
l!l&&r!l&&!r
10847191240
MC/DC100%3/3
$iYear % 4 == 0 and $iYear % 100 || $iYear % 400 == 0
$iYear % 4 == 0 $iYear % 100 $iYear % 400 == 0
Truth table100%4/4
A and B or C
A= $iYear % 4 == 0B= $iYear % 100C= $iYear % 400 == 0
ABCresult
0XX0
1000
11X1
1011
750 ((($iYear % 4) == 0) && (($iYear % 100) || ($iYear % 400) == 0)) ? 366 : 365;
751 }
752 169 $iYear -= 1900;
753 169 ▶ for ($iMon = 1 ; $iMon < 12 ; $iMon++) {
Branch: 1 branch
BranchTrueFalseTotal
if ($iMon < 12) 724 5 729
754 724 my $iMD;
755 724 ▶ if ( $iMon == 1
Branch: 3 branches
BranchTrueFalseTotal
if ($iMon == 1 or $iMon == 3 or $iMon == 5 or $iMon == 7 or $iMon == 8 or $iMon == 10 or $iMon == 12) { } 459 265 724
elsif ($iMon == 4 or $iMon == 6 or $iMon == 9 or $iMon == 11) { } 152 113 265
elsif ($iMon == 2) { } 113 0 113
Condition94%17/18
$iMon == 1 or $iMon == 3 or $iMon == 5 or $iMon == 7 or $iMon == 8 or $iMon == 10 or $iMon == 12
l!l&&r!l&&!r
4590265
$iMon == 1 or $iMon == 3 or $iMon == 5 or $iMon == 7 or $iMon == 8 or $iMon == 10
l!l&&r!l&&!r
4545265
$iMon == 1 or $iMon == 3 or $iMon == 5 or $iMon == 7 or $iMon == 8
l!l&&r!l&&!r
38371270
$iMon == 1 or $iMon == 3 or $iMon == 5 or $iMon == 7
l!l&&r!l&&!r
31271341
$iMon == 1 or $iMon == 3 or $iMon == 5
l!l&&r!l&&!r
24171412
$iMon == 1 or $iMon == 3
l!l&&r!l&&!r
16972483
MC/DC85%6/7
$iMon == 1 or $iMon == 3 or $iMon == 5 or $iMon == 7 or $iMon == 8 or $iMon == 10 or $iMon == 12
$iMon == 1 $iMon == 3 $iMon == 5 $iMon == 7 $iMon == 8 $iMon == 10 $iMon == 12
Truth table87%7/8
A or B or C or D or E or F or G
A= $iMon == 1B= $iMon == 3C= $iMon == 5D= $iMon == 7E= $iMon == 8F= $iMon == 10G= $iMon == 12
ABCDEFGresult
1XXXXXX1
01XXXXX1
001XXXX1
0001XXX1
00001XX1
000001X1
00000011
00000000
756 || $iMon == 3
757 || $iMon == 5
758 || $iMon == 7
759 || $iMon == 8
760 || $iMon == 10
761 || $iMon == 12) {
762 459 $iMD = 31;
763 ▶ } elsif ($iMon == 4 || $iMon == 6 || $iMon == 9 || $iMon == 11) {
Condition100%9/9
$iMon == 4 or $iMon == 6 or $iMon == 9 or $iMon == 11
l!l&&r!l&&!r
1475113
$iMon == 4 or $iMon == 6 or $iMon == 9
l!l&&r!l&&!r
1425118
$iMon == 4 or $iMon == 6
l!l&&r!l&&!r
7171123
MC/DC100%4/4
$iMon == 4 or $iMon == 6 or $iMon == 9 or $iMon == 11
$iMon == 4 $iMon == 6 $iMon == 9 $iMon == 11
Truth table100%5/5
A or B or C or D
A= $iMon == 4B= $iMon == 6C= $iMon == 9D= $iMon == 11
ABCDresult
1XXX1
01XX1
001X1
00011
00000
764 152 $iMD = 30;
765 } elsif ($iMon == 2) {
766 113 ▶ $iMD = (($iYear % 4) == 0) ? 29 : 28;
Branch: 1 branch
BranchTrueFalseTotal
$iYear % 4 == 0 ? : 102 11 113
767 }
768 724 ▶ last if ($iDt <= $iMD);
Branch: 1 branch
BranchTrueFalseTotal
if $iDt <= $iMD 164 560 724
769 560 $iDt -= $iMD;
770 }
771  
772 #2. Calc Time
773 169 $iDay = $iDt;
774 169 $iTime += (0.0005 / 86400.0);
775 169 $iTime *= 24.0;
776 169 $iHour = int($iTime);
777 169 $iTime -= $iHour;
778 169 $iTime *= 60.0;
779 169 $iMin = int($iTime);
780 169 $iTime -= $iMin;
781 169 $iTime *= 60.0;
782 169 $iSec = int($iTime);
783 169 $iTime -= $iSec;
784 169 $iTime *= 1000.0;
785 169 $iMSec = int($iTime);
786  
787 169 return ($iSec, $iMin, $iHour, $iDay, $iMon - 1, $iYear, $iwDay, $iMSec);
788 }
789  
790 # -----------------------------------------------------------------------------
791 # col2int (for Spreadsheet::XLSX::Utility2007)
792 #------------------------------------------------------------------------------
793 # converts a excel row letter into an int for use in an array
794 0 ▶sub col2int {
Subroutine col2int: not called CC=3 SCAR=24.8
Pod documented
795 0 my $result = 0;
796 0 my $str = shift;
797 0 my $incr = 0;
798  
799 0 ▶ for (my $i = length($str) ; $i > 0 ; $i--) {
Branch: 1 branch
BranchTrueFalseTotal
if ($i > 0) 0 0 0
800 0 my $char = substr($str, $i - 1);
801 0 my $curr += ord(lc($char)) - ord('a') + 1;
802 0 ▶ $curr *= $incr if ($incr);
Branch: 1 branch
BranchTrueFalseTotal
if $incr 0 0 0
803 0 $result += $curr;
804 0 $incr += 26;
805 }
806  
807 # this is one out as we range 0..x-1 not 1..x
808 0 $result--;
809  
810 0 return $result;
811 }
812  
813 # -----------------------------------------------------------------------------
814 # int2col (for Spreadsheet::XLSX::Utility2007)
815 #------------------------------------------------------------------------------
816 ### int2col
817 # convert a column number into column letters
818 # @note this is quite a brute force coarse method
819 # does not manage values over 701 (ZZ)
820 # @arg number, to convert
821 # @returns string, column name
822 #
823 0 ▶sub int2col {
Subroutine int2col: not called CC=2 SCAR=17.9
Pod documented
824 0 my $out = "";
825 0 my $val = shift;
826  
827 0 ▶ do {
Branch: 1 branch
BranchTrueFalseTotal
$val >= 0 and do { do { $out .= chr($val % 26 + 65); $val = int($val / 26) - 1 } } 0 0 0
828 0 $out .= chr(($val % 26) + ord('A'));
829 0 $val = int($val / 26) - 1;
830 } while ($val >= 0);
831  
832 0 return reverse $out;
833 }
834  
835 # -----------------------------------------------------------------------------
836 # sheetRef (for Spreadsheet::XLSX::Utility2007)
837 #------------------------------------------------------------------------------
838 # -----------------------------------------------------------------------------
839 ### sheetRef
840 # convert an excel letter-number address into a useful array address
841 # @note that also Excel uses X-Y notation, we normally use Y-X in arrays
842 # @args $str, excel coord eg. A2
843 # @returns an array - 2 elements - column, row, or undefined
844 #
845 0 ▶sub sheetRef {
Subroutine sheetRef: not called CC=4 SCAR=30.0
Pod documented
846 0 my $str = shift;
847 0 my @ret;
848  
849 0 $str =~ m/^(\D+)(\d+)$/;
850  
851 0 ▶ if ($1 && $2) {
Branch: 1 branch
BranchTrueFalseTotal
if ($1 and $2) 0 0 0
Condition0%0/3
$1 and $2
!ll&&!rl&&r
000
MC/DC0%0/2
$1 and $2
$1 $2
Truth table0%0/3
A and B
A= $1B= $2
ABresult
0X0
100
111
852 0 push(@ret, $2 - 1, col2int($1));
853 }
854 0 ▶ if ($ret[0] < 0) {
Branch: 1 branch
BranchTrueFalseTotal
if ($ret[0] < 0) 0 0 0
855 0 undef @ret;
856 }
857  
858 0 return @ret;
859 }
860  
861 # -----------------------------------------------------------------------------
862 # xls2csv (for Spreadsheet::XLSX::Utility2007)
863 #------------------------------------------------------------------------------
864 ### xls2csv
865 # convert a chunk of an excel file into csv text chunk
866 # @args $param, sheet-colrow:colrow (1-A1:B2 or A1:B2 for sheet 1
867 # @args $rotate, 0 or 1 decides if output should be rotated or not
868 # @returns string containing a chunk of csv
869 #
870 0 ▶sub xls2csv {
Subroutine xls2csv: not called CC=21 SCAR=61.4
Pod documented
871 0 my ($filename, $regions, $rotate) = @_;
872 0 my $sheet = 0;
873 0 my $output = "";
874  
875 # extract any sheet number from the region string
876 0 $regions =~ m/^(\d+)-(.*)/;
877  
878 0 ▶ if ($2) {
Branch: 1 branch
BranchTrueFalseTotal
if ($2) 0 0 0
879 0 $sheet = $1 - 1;
880 0 $regions = $2;
881 }
882  
883 # now extract the start and end regions
884 0 $regions =~ m/(.*):(.*)/;
885  
886 0 ▶ if (!$1 || !$2) {
Branch: 1 branch
BranchTrueFalseTotal
unless ($1 and $2) 0 0 0
Condition0%0/3
$1 and $2
!ll&&!rl&&r
000
MC/DC0%0/2
$1 and $2
$1 $2
Truth table0%0/3
A and B
A= $1B= $2
ABresult
0X0
100
111
887 0 print STDERR "Bad Params";
888 0 return "";
889 }
890  
891 0 my @start = sheetRef($1);
892 0 my @end = sheetRef($2);
893 0 ▶ if (!@start) {
Branch: 1 branch
BranchTrueFalseTotal
unless (@start) 0 0 0
894 0 print STDERR "Bad coorinates - $1";
895 0 return "";
896 }
897 0 ▶ if (!@end) {
Branch: 1 branch
BranchTrueFalseTotal
unless (@end) 0 0 0
898 0 print STDERR "Bad coorinates - $2";
899 0 return "";
900 }
901  
902 0 ▶ if ($start[1] > $end[1]) {
Branch: 1 branch
BranchTrueFalseTotal
if ($start[1] > $end[1]) 0 0 0
903 0 print STDERR "Bad COLUMN ordering\n";
904 0 print STDERR "Start column " . int2col($start[1]);
905 0 print STDERR " after end column " . int2col($end[1]) . "\n";
906 0 return "";
907 }
908 0 ▶ if ($start[0] > $end[0]) {
Branch: 1 branch
BranchTrueFalseTotal
if ($start[0] > $end[0]) 0 0 0
909 0 print STDERR "Bad ROW ordering\n";
910 0 print STDERR "Start row " . ($start[0] + 1);
911 0 print STDERR " after end row " . ($end[0] + 1) . "\n";
912 0 exit;
913 }
914  
915 # start the excel object now
916 0 my $oExcel = new Spreadsheet::XLSX;
917 0 my $oBook = $oExcel->Parse($filename);
918  
919 # open the sheet
920 0 my $oWkS = $oBook->{Worksheet}[$sheet];
921  
922 # now check that the region exists in the file
923 # if not trucate to the possible region
924 # output a warning msg
925 0 ▶ if ($start[1] < $oWkS->{MinCol}) {
Branch: 1 branch
BranchTrueFalseTotal
if ($start[1] < $oWkS->{"MinCol"}) 0 0 0
926 0 print STDERR int2col($start[1]) . " < min col " . int2col($oWkS->{MinCol}) . " Reseting\n";
927 0 $start[1] = $oWkS->{MinCol};
928 }
929 0 ▶ if ($end[1] > $oWkS->{MaxCol}) {
Branch: 1 branch
BranchTrueFalseTotal
if ($end[1] > $oWkS->{"MaxCol"}) 0 0 0
930 0 print STDERR int2col($end[1]) . " > max col " . int2col($oWkS->{MaxCol}) . " Reseting\n";
931 0 $end[1] = $oWkS->{MaxCol};
932 }
933 0 ▶ if ($start[0] < $oWkS->{MinRow}) {
Branch: 1 branch
BranchTrueFalseTotal
if ($start[0] < $oWkS->{"MinRow"}) 0 0 0
934 0 print STDERR "" . ($start[0] + 1) . " < min row " . ($oWkS->{MinRow} + 1) . " Reseting\n";
935 0 $start[0] = $oWkS->{MinCol};
936 }
937 0 ▶ if ($end[0] > $oWkS->{MaxRow}) {
Branch: 1 branch
BranchTrueFalseTotal
if ($end[0] > $oWkS->{"MaxRow"}) 0 0 0
938 0 print STDERR "" . ($end[0] + 1) . " > max row " . ($oWkS->{MaxRow} + 1) . " Reseting\n";
939 0 $end[0] = $oWkS->{MaxRow};
940  
941 }
942  
943 0 my $x1 = $start[1];
944 0 my $y1 = $start[0];
945 0 my $x2 = $end[1];
946 0 my $y2 = $end[0];
947  
948 0 ▶ if (!$rotate) {
Branch: 1 branch
BranchTrueFalseTotal
if (not $rotate) { } 0 0 0
949 0 ▶ for (my $y = $y1 ; $y <= $y2 ; $y++) {
Branch: 1 branch
BranchTrueFalseTotal
if ($y <= $y2) 0 0 0
950 0 ▶ for (my $x = $x1 ; $x <= $x2 ; $x++) {
Branch: 1 branch
BranchTrueFalseTotal
if ($x <= $x2) 0 0 0
951 0 my $cell = $oWkS->{Cells}[$y][$x];
952 0 ▶ $output .= $cell->Value if (defined $cell);
Branch: 1 branch
BranchTrueFalseTotal
if defined $cell 0 0 0
953 0 ▶ $output .= "," if ($x != $x2);
Branch: 1 branch
BranchTrueFalseTotal
if $x != $x2 0 0 0
954 }
955 0 $output .= "\n";
956 }
957 } else {
958 0 ▶ for (my $x = $x1 ; $x <= $x2 ; $x++) {
Branch: 1 branch
BranchTrueFalseTotal
if ($x <= $x2) 0 0 0
959 0 ▶ for (my $y = $y1 ; $y <= $y2 ; $y++) {
Branch: 1 branch
BranchTrueFalseTotal
if ($y <= $y2) 0 0 0
960 0 my $cell = $oWkS->{Cells}[$y][$x];
961 0 ▶ $output .= $cell->Value if (defined $cell);
Branch: 1 branch
BranchTrueFalseTotal
if defined $cell 0 0 0
962 0 ▶ $output .= "," if ($y != $y2);
Branch: 1 branch
BranchTrueFalseTotal
if $y != $y2 0 0 0
963 }
964 0 $output .= "\n";
965 }
966 }
967  
968 0 return $output;
969 }
970  
971 3463 ▶sub unescape_HTML {
Subroutine unescape_HTML: called CC=3 SCAR=11.0
Pod undocumented
972  
973 3463 my $string = shift;
974 3463 my %options = @_;
975  
976 3463 ▶ return $string if ($string eq '');
Branch: 1 branch
BranchTrueFalseTotal
if $string eq "" 196 3267 3463
977  
978 3267 $string =~ s/&quot;/"/g;
979 3267 $string =~ s/&rsquo;/'/g;
980 3267 $string =~ s/&amp;/&/g;
981  
982 3267 ▶ return $string if $options{textarea}; # for textboxes, we leave < and > as &lt; and &gt;
Branch: 1 branch
BranchTrueFalseTotal
if $options{"textarea"} 0 3267 3267
983 # so that people who enter "</textarea>" into
984 # our text boxes can't break forms
985  
986 3267 $string =~ s/&lt;/</g;
987 3267 $string =~ s/&gt;/>/g;
988  
989 3267 return $string;
990 }
991  
992 26 1;
993 __END__
↑ Summary XLSX.pm »