We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Changing the Value of a cell affects it's formating

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

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.