Date cell issue

[nda_tech]

Hi,
I'm facing this problem:
When reading a cell formatted as Date, the property HasDateTime seem to be resetted while the HasNumber property is setted.
In the attached file , you can find two cells A1 is formatted as date when a non default format and when reading it isn't recognized as DateTime (HasDateTime is resetted) while the B1 cell is date formatted with the excel default value and that's correctly recognized ad DateTime.

The same effect when the cell content results from a formula

Thank you

[Brian.Li]

Hello,

Thanks for your inquiry.
For the data in the cell "A2" of the file you provided, we are sorry to tell you that our Spire.XLS does not support this type of date format. But there is an alternative solution, you can refer to the following code to determine whether the data is a date. Feel free to contact us if you have further questions.

Code: Select all

            Workbook wb = new Workbook();
            wb.LoadFromFile("datetime.xlsm");
            CellRange cellRangeB = wb.Worksheets[0].Range["A2"];
            String dateTimeValue = cellRangeB.DisplayedText;         
            DateTime date = new DateTime();
            bool result = DateTime.TryParse(dateTimeValue, out date);

Sincerely,
Brian
E-iceblue support team

[nda_tech]

Hi
thank you for the feedback
The problem with my application is that i don't know which type of cell I'm dealing with , i.e. I don't have a fixed excel format , the dateformat cell may be in any cell
Anyway my workaround is to examine the numbeformat string
Thanks anyway

Ncola

[Brian.Li]

Hello Ncola,

Thanks for your response.

Anyway, I’m glad to hear that you found the workaround.

Besides, we will consider adding a new feature to our further upgrade list to support this type of data format. If it can be achieved in the future, we will let you know.

Sincerely,
Brian
E-iceblue support team

[Brian.Li]

Hello Ncola,

Glad to inform you that we just released Spire.XLS Pack(Hotfix) Version:11.2.6 which fixes your issue, please download it from the following links to test on your side. Looking forward to your testing result.
Website link: https://www.e-iceblue.com/Download/down ... t-now.html
Nuget link: https://www.nuget.org/packages/Spire.XLS/11.2.6

Sincerely,
Brian
E-iceblue support team

[Brian.Li]

Hello Ncola,

Greetings from E-iceblue.
Does this hotfix solve your issue? Could you please give us some feedback at your convenience?

Sincerely,
Brian
E-iceblue support team

[nda_tech]

Hi,
thank you for the fix, but I'm using FreeSpire , so I cannot test the patch.
Sincerly
Nicola

[Brian.Li]

Hello Nicola,

Thanks for your reply.
I am sorry that we currently only fixed the issue in our latest commercial version. We only upgrade the free version irregularly. Apologize for the inconvenience caused.

Sincerely,
Brian
E-iceblue support team