This modules works well - but only sometimes - date conversions and large spreadsheets are the ones that cause it to act up!!!!!
Currently, I notice the dates are erratically being left as numbers - and converted other times to dates. When i troubleshooted the module code, I feel the problem is in this part -
This is the code
$member_styles -> contents =~ /numFmtId="$t1"
+formatCode="([^"]*)/;
my $formatCode = $1 || '';
because the regex extraction doesnt work for some date formats. I have listed the content of the numFMT tags the REGEX was trying to extract formatCode substrings from. However, I cant tell, why the regex fails. Can someone point out why the Regex would fail extracting the substring?
Many thanks in advance!
This is the data
<numFmts count="7">
<numFmt numFmtId="43" formatCode="_(* #,##0.00_);_(* \(#,##0.00\);_(*
+"-"??_);_(@_)"/>
<numFmt numFmtId="164" formatCode="[$-409]h:mm\ AM/PM;@"/>
<numFmt numFmtId="165" formatCode="m/d;@"/>
<numFmt numFmtId="166" formatCode="ddd\ mm/dd/yy"/>
<numFmt numFmtId="167" formatCode="0.0%"/>
<numFmt numFmtId="168" formatCode=""$"#,##0.00"/>
<numFmt numFmtId="169" formatCode="m/d/yy;@"/></numFmts>