Free Support Forum - aspose.com

Excel chart loosing some formating when open and save it with aspose cells

Hi,

Excel chart loosing some formatting when open and save it with aspose cells.

We have tested these formatting which are lost after open and save with aspose cells:
- Border Styles: Width, Compound type, Cap type and Join type Settings
- All Shadow Settings
- All 3-D Format Settings


here is the sample code and sample excel file you can use to reproduce it:

[Test]
public void Aspose_Chart_Loosing_Formatting_Test()
{
const string excelFile = @“C:\Users\mpatel\Desktop\FSR Test Workbooks\BrokerGraphs.xls”;
const string excelFile1 = @“C:\Users\mpatel\Desktop\FSR Test Workbooks\BrokerGraphs1.xls”;

var wb = new Workbook(excelFile);
wb.Save(excelFile1, SaveFormat.Excel97To2003);
}

If I open it and save it using excel it self it’s working.

Hi,

Thanks for your info. We have found the issue of the file.

The template xls file must be generated by MS Excel 2007 or above version, so there are some additional records in the file since Excel 2007.

We do not support them now. We will look into it later.

And you will get different view in Excel 2003 or Excel2007 too.

Hi Simon,

So this is aspose issue or something in excel file itself?

I am not clear what you are trying to explain here.

Hi,


We have logged a ticket for the issue with an id: CELLSNET-29620. We will figure it out soon.

Thank you.

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


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

Hi,

We have fixed this issue. Please download: Aspose.Cells for .NET v7.0.0.1