Free Support Forum - aspose.com

Formatting lost when file is saved

Hi, I seem to lose a lot of the cell formatting within a file when saving it. Please reference the attached file.

//set license
....
Excel excel = new Excel();
excel.Open("AsposeWorkbook.xls");
excel.Worksheets[3].Cells["D12"].PutValue("AsposeTest");
excel.Worksheets[3].Cells["I19"].PutValue(1000);
excel.CalculateFormula(false);
excel.Save(@"c:\output.xls");

After running the program and then opening the output file in excel, you'll observe many of the cells have lost their formatting. Pretty much everything on the fourth sheet, and many of the cells in the second and third sheets. Since I'm not manipulating the formatting in any way, the formatting should be preserved.

I'm using version 3.6.2.2

Thanks

I have noticed this problem and fixed it. Please try this attached fix.