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