as3xls
as3xls copied to clipboard
Issue and workaround with unsigned date
I have a xls file that I dont know how as created but have a date cell that appears as Portuguese (Portugal) with * but is now seems that internally its now a date !
The only workaround that I found (and tested with several date formats in separated and in the same file):
In the method loadFromByteArray of the ExcelFile.as, put:
currentSheet.formats[165] = "yyyy/mm/dd;@";
After the currentSheet = new Sheet();
This will ensure that the date format is always present in the formats array even if that format is not recognized in the excel file.