as3xls
as3xls copied to clipboard
Issue and workaround with localized portuguese date with *
The dates are correctly parsed even with localizes dates except for Portuguese (Portugal) with the * type date.
However there is a workaround.
In the method xf of the ExcelFile.as file, replace the following block of code:
case BIFFVersion.BIFF8:
font = r.data.readUnsignedShort();
format = r.data.readUnsignedShort();
break;
By this one:
case BIFFVersion.BIFF8:
font = r.data.readUnsignedShort();
format = r.data.readUnsignedShort();
if (format == 14)
format = 165;
break;