Skip to content
This repository has been archived by the owner on Jul 31, 2019. It is now read-only.

Issue and workaround with unsigned date #16

Open
hferreira opened this issue Aug 28, 2011 · 0 comments
Open

Issue and workaround with unsigned date #16

hferreira opened this issue Aug 28, 2011 · 0 comments

Comments

@hferreira
Copy link

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.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant