Troubleshooting with Workbook Copy method

Aspose.Cells Product Family
1

Hi, I’m trying to copy a workbook to a new one but it seems that when the original document has tables with style it damage the copy file and then when we open it Excel popup a warning and has to repair the file.


I found that the original formula tables are:
=[Projected Cost]-[Actual Cost]

but the workbook copy formulas are:
=Table4[Projected Cost]-Table4[Actual Cost]

I attach a zip file with some pictures and a visual studio project showing the code and the problem.

I hope you can help me, thank you.
2

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

We were able to replicate this issue using the following code with the latest version:
Aspose.Cells
for .NET v7.3.4.1.

We have logged this issue in our database. We will look into it further and resolve it. Once the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as CELLSNET-41219.

I have also attached the source file and the output file for a reference.

C#


Workbook doc = new Workbook(“Personal Monthly Budget.xlsx”);

WorksheetCollection sheets = doc.Worksheets;


Workbook docCopy = new Workbook();

docCopy.Copy(doc);


docCopy.Save(“Copy of Personal Monthly Budget.xlsx”);

Console.WriteLine(“Personal Monthly Budget copied”);


3

Hi,

We have fixed this issue.

Please download and try this fix: Aspose.Cells for .NET v7.3.4.2 and let us know your feedback.

4

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

Hopefully, your issue is fixed. We have closed this thread now. In case you require any further assistance, please feel free to post on our forums. We will like to help you further.

Besides, we have lately done some major enhancements and added new features in our product, so you should also download and give a try to latest offline demos of Aspose.Cells which you can find from theses links.

These demos can work with Visual Studio 2005, 2008 or 2010. Please read the readme.txt file before running the demos.


5

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

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