as3xls icon indicating copy to clipboard operation
as3xls copied to clipboard

Issue and workaround with unsigned date

Open hferreira opened this issue 14 years ago • 0 comments

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.

hferreira avatar Aug 28 '11 15:08 hferreira