Xlsio - GetType() of Value2 changed from DateTime to Double after changing CellStyle

[Thinh]

Hi

Before I change CellStyle, Value2 is DateTime

After that, Value2 is Double

I've just changed the style, not the data type

How to prevent that?

Best Regards.

[Konduru Keerthi Konduru Ravichandra Raju]

Hi Thinh, 

Greeting from Syncfusion. 

We are able to reproduce the reported issue and validating it currently. We will share the validation details in two business days, on September 7^th,2020. 

Kindly confirm if you are using 18.2.0.44 version of Syncfusion XlsIO. 

Regards, 

Keerthi.

[Thinh]

Hi Keerthi.

I'm using syncfusion.xlsio.net.core, version 18.2.0.55

Best Regards.

[Konduru Keerthi Konduru Ravichandra Raju]

Hi Thinh, 

Thanks for sharing the version details. 

Regards, 

Keerthi. 

[Konduru Keerthi Konduru Ravichandra Raju]

Hi Thinh, 

We deeply regret for the delay. 

We are facing complexity in finding the root cause of the issue. We will share the validation details on September 8^th,2020.  

We appreciate your patience. 

Regards, 

Keerthi. 

[Konduru Keerthi Konduru Ravichandra Raju]

Hi Thinh, 

Thanks for your patience. 

When IStyle is created the number format will be in General. So, on applying the created style to the Excel cell, the number format will change. We suggest you to set IncludeNumberFormat property available under IStyle to false, to overcome the reported issue. 

Please find the code snippet below. 

Code Snippet: 

style.IncludeNumberFormat = false; 

Kindly try this and let us know if it helps. 

Regards, 

Keerthi.

[Thinh]

It works. Thanks Keerthi.

Best wishes to you and your team.

[Konduru Keerthi Konduru Ravichandra Raju]

Hi Thinh, 

We are glad that the provided suggestion helped you. 

Kindly let us know if your need any further assistance. 

Regards, 

Keerthi.