Excel 2007 Chart with VBA Code Issue

Aspose.Cells Product Family
1
p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 10.0px Helvetica; color: #22a3ba} p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 10.0px Helvetica} span.s1 {color: #000000} span.s2 {color: #053df5} span.s3 {color: #b82321} span.s4 {color: #22a3ba} span.Apple-tab-span {white-space:pre}

Hello,


I am having an issue with an Excel 2007 file when it contains a Chart with VBA code

on the chart sheet. The problem happens even if the only code on the sheet

is an empty function.


When I open the Aspose output file the chart VBA code has been placed

on a new worksheet with the same name as the original Chart (this sheet does

not exist in the original template file), and the original Chart is now renamed

and not associated with the VBA code.


To test this problem I am just opening and saving the Excel file:


Workbook workbook = new Workbook(@"c:\ChartCodeIssue.xlsm", new LoadOptions(LoadFormat.Xlsx));

workbook.Save(@"c:\output.xlsm", SaveFormat.Xlsm)


This problem does not happen with an Excel 2003 file. I am using Aspose.Cells

version 5.3.1.0.


Thanks,

Brian

2
Hi Brian,

Thank you for choosing Aspose as your File Format Expert.

I have tested your scenario with your provided template file and I have found NO issues as described in your post. Attached is my Output file. I am using Aspose.Cells for .Net version 5.2.3.2 and MS Excel 2010.
I suggest you to give it a try with our latest version [v5.2.3.2 is latest], that you can download from this link.

3
Hello Babar,

Thanks for looking into this issue and sending me your output file. I have opened your output file in both Excel 2007 and 2010, and when I enable macros I get an ActiveX error. This error doesn't happen on the original template file.

I've attached a screenshot of the ActiveX error, and a before/after of the sheets in the Excel file to show how Aspose is moving the graph to a new sheet when it saves the file.

I also tried this with version 5.2.3.2 and still get the same error.

Thanks,
Brian
4

Hi Brian,

I can reproduce this problem with latest version of Aspose.Cells for .NET 5.2.3.2. Below is my code.

This issue has been logged as CELLSNET-25508.

C#


string filepath = @“F:\Downloads\issue\ChartCodeIssue.xlsm”;

Workbook workbook = new Workbook(filepath);

workbook.Save(filepath+".out.xlsm", SaveFormat.Xlsm);

5

Hi,

Please try the attached version Aspose.Cells for .NET v5.3.1.4. We have fixed the issue you
mentioned.

6

Hi,


Thank you, that fix the problem I was having.

Where can I get a version of 5.3.1.4 (or later) for .Net 1.1?
The file posted on this thead is for .Net 2.0, and it looks like the
latest post in the "Attach Minor Updates of Aspose.Cells DLLs Here"
thread has 5.3.1.5 for .Net 2.0, but not that version for .Net 1.1.

Thanks,
Brian


7

Hi,

Well, yes, normally we provide .NET 2.0 compiled fixed version of the product in the forums as most of our users are using our product on .NET2.0 or greater .NET framework versions. But, if a user needs a .NET 1.1 compiled fixed version, we can provide it for the users.

We will provide you the .NET 1.1 compiled version here soon.

thank you.

8

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

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