You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
This repository has been archived by the owner on Jul 31, 2019. It is now read-only.
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.
The text was updated successfully, but these errors were encountered:
Sign up for freeto subscribe to this conversation on GitHub.
Already have an account?
Sign in.
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.
The text was updated successfully, but these errors were encountered: