Cell lost the background color during excel sheet open and save

Aspose.Cells Product Family
1

Hi,

I am using aspose 2.2 license version.

in my project i am using following code.

Workbook workbook = new Workbook();
try {
workbook.open(excelFilePath);
workbook.save(excelFilePath);
} catch (IOException e) {
}

after saving excel file my cell color getting lost,

here i attached before and after saving excel files, pls check the third sheet name as "1". after saving my cell red color getting lost.

pleas help me.

2

Hi,


As you are using some older version of the product for which we are not sure. I have tested by opening and resaving your template file with our latest version e.g v7.3.5.x (you may download our latest official release v7.3.5 2 here: http://www.aspose.com/community/files/72/java-components/aspose.cells-for-java/entry434437.aspx), it works fine. The color is retained in the “1” sheet.

Sample code (with latest version):

Workbook workbook1 = new Workbook(“before_open_and_save.xls”);
workbook1.save(“after_open_and_save.xls”);

Thank you.