Corrupted cell colouring after worksheet copying

Aspose.Cells Product Family
1

Hello, Aspose team!

Thank you for all your assistance. We have new issue.

Take a look at 2 attached files. First one “Good Report” is good. This what you got just after building the file.
After copying worksheet from one workbook to another, you get corrupted coloring (see “Corrupted report” file)
Here is the sample code:

var wrk = workbook after building;
var sourceWorksheet = wrk.Worksheets[0];
string name = sourceWorksheet.Name;
var destWorksheet = _workbook.Worksheets.Add(name);
destWorksheet.Copy(sourceWorksheet);

Could you please review this issue and fix it in upcoming versions of Apose.Cells library?

Thank You in advance,
Denis

2

Hi,

Please download and try the latest version:
Aspose.Cells
for .NET v7.1.2.3
and let us know your feedback

I have tested your problem and found the latest verison is working fine. Please see the code below. I have attached the output file for your reference.

C#


string filePath = @“F:\Shak-Data-RW\Downloads\Good+Report.xls”;


var _workbook = new Workbook(filePath);


var wrk = new Workbook();

var sourceWorksheet = wrk.Worksheets[0];

string name = sourceWorksheet.Name;

var destWorksheet = _workbook.Worksheets.Add(name);

destWorksheet.Copy(sourceWorksheet);


_workbook.Save(filePath + “.out.xls”);


3
Hi,

I have tested your issue (regarding Copying Worksheets) with the following changed code using your attached template file and I am able to reproduce the issue as you mentioned. The "Historical Comparison" table below has wrong cell shading/fill color as we can see.

Sample code:
string filePath = @"e:\test2\Good+Report.xls";


var _workbook = new Workbook(filePath);


var wrk = new Workbook();

var destWorksheet = wrk.Worksheets[0];
var sourceWorksheet = _workbook.Worksheets[0];

string name = sourceWorksheet.Name;
destWorksheet.Name = name;
destWorksheet.Copy(sourceWorksheet);


wrk.Save(filePath + ".out1.xls");

I have also attached the output file.

I have logged a ticket with an id: CELLSNET-40509. We will look into it to figure it out soon.

Thank you.
4

Great Thank You!
Looking forward for fix!

Thank You for such quick and thorough work!

With Best Regards,
Denis

5

Hi,

Please download and try this fix: Aspose.Cells for .NET v7.1.2.4

We have fixed this issue.

6

Hi!
Yes, I’ve checked - this issue is really fixed!

Thank You for your hard work!

With Best Regards,
Denis

7

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

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