Worksheet.Copy affecting comments appeareance (black background- incomplete content)

Aspose.Cells Product Family
1

Hi,

When using Worksheet.Copy for copying an existing worksheet to another workbook, the comments in the new workbook have incomplete content and black background when opened in Excel (see the attached image).
For reproducing the issue use the attached Excel files and the following code then open the resulted file in Excel and check the comments of “C22.00” worksheet:

var workBook = new Workbook(“testingOriginalWorkbook.xlsx”);

var workSheetName = workBook.Worksheets[0].Name;
workBook.Worksheets[0].Name = string.Format("{0}{1}", workSheetName, “_bkp”);

var newWorkbook = new Workbook(“testingNewWorkbook.xlsx”);
var newWorksheet = newWorkbook.Worksheets[0];

var copyOptions = new CopyOptions
{
CopyInvalidFormulasAsValues = false,
CopyNames = true
};

var destinationWorksheet = workBook.Worksheets.Add(newWorksheet.Name);
destinationWorksheet.Copy(newWorksheet, copyOptions);

workBook.Save(“testRestul.xlsx”);

Best regards,
Aurelian Iordache
Software Developer
IBM Romania

2

Hi Aurelian,

Thanks for your posting and using Aspose.Cells.

We were able to observe this issue after executing your provided sample code with your source Excel files using the latest version: Aspose.Cells
for .NET v8.2.2.3. Worksheet.Copy affects comments appearance (black background, incomplete content) as shown in your screenshot.

We have logged this issue in our database for investigation. We will look into it and fix this issue. 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-43163 - Worksheet.Copy affects comments appearance (black background, incomplete content)

I have also attached the output Excel file generated by the code for a reference.

3

Hi Aurelian,

Thanks for using Aspose.Cells.

We have fixed this issue.

Please download and try the latest fix: Aspose.Cells for .NET 8.3.0 and let us know your feedback.

4

Hi,

Thanks for your using Aspose.Cells.

Please download and try the latest fix: Aspose.Cells for .NET v8.3.0.2 and let us know your feedback.

5

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

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.