Changing the Value of a cell affects it's formating

Aspose.Cells Product Family
1

Hi,

When I import an Excel file with some cells formatted as Currency, the format persists. But if I insert/replace the value of the cell the format is gone…

Can I change this? I want the format to persist!!

Thanks

2

Hi,

Well, when you update any cell's value or insert a new value to a cell, the data will be in general format. You do need to explicitly set the format on updating a cell.

E.g.,

cell = cells["B2"];

cell.NumberType = NumberType.Currency3;

Thank you.