as3xls icon indicating copy to clipboard operation
as3xls copied to clipboard

Issue and workaround with localized portuguese date with *

Open hferreira opened this issue 14 years ago • 0 comments

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;

hferreira avatar Aug 28 '11 14:08 hferreira