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

Free Support Forum - aspose.com

Chart formatting being lost/changed when loading and immediately saving workbook

Hi there

We are currently evaluating the Aspose product suite and we are experiencing issues when loading a Excel 2003 formatted XLS with a simple bar chart in it which has a gradient in. Depending on the format that we save in we either completely lose the gradient (in 2003) or it is changed in definition (in 2007). We are using cells version aspose-cells-2.4.1.jar. I have seen recent threads which seem to be similar to this but not for the Java version.

com.aspose.cells.Workbook workbook = new com.aspose.cells.Workbook();
FileInputStream is = new FileInputStream(“D:\templates\test.xls”);
workbook.open(is,FileFormatType.EXCEL97TO2003);
workbook.save(“D:\templates\test_out.xls”,FileFormatType.EXCEL97TO2003);
workbook.save(“D:\templates\test_out.xlsx”,FileFormatType.EXCEL2007);

I have attached the input file and the two outputs for your reference.

Am I doing something wrong is this something that is not currently supported?

Thanks
Andrew

Hi,

I have found the issue as you have mentioned by your template file and sample code.

I have logged your issue into our issue tracking system with an id: CELLSJAVA-21006. We will try to figure it out and provide you the fixed version soon.

Thank you.

The issues you have found earlier (filed as 21006) have been fixed in this update.


This message was posted using Notification2Forum from Downloads module by aspose.notifier.

Thanks for the quick response - we will test it out and get back to you.

Regards
Andrew