Comments in HTML-Export of XLSX

Aspose.Cells Product Family
1

Hi,

saving a xlsx-document with comments as pdf or html don´t print the comments in the exports.
How can I print the comments in the exports?

I use Aspose.Cells for .NET 7.3.4.0.

2

Hi,

Thanks for your posting and using Aspose.Cells.

I am afraid, these feature are not supported. We have logged these features in our database with the following issue ids.

  • Export of comments when workbook is saved in html format. (CELLSNET-41277)
  • Export of comments when workbook is saved in pdf format. (CELLSNET-41278)


We will look into these features and implement them.

Once, we have some fix for you or we have some other update for you, we will share it with you asap.
3

Hi,

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

We could not support exporting comments in html file,we will support it later.

4

Hi again,

First of all, please accept our apologies for the delayed response regarding the ticket CELLSNET-41278.

Please note, if you check your provided sample in Excel’s print preview, you will notice that comments are not visible. In order to render the comments to PDF, you need to make them visible as well as allow printing. Please use following piece of code against the latest major release of Aspose.Cells for .NET 16.12.0.

C#

Workbook wb = new Workbook(srcFile);
foreach (Worksheet sheet in wb.Worksheets)
{
//make comment to visible.
CommentCollection comments = sheet.Comments;
foreach (Comment comment in comments)
{
comment.IsVisible = true;
}

//make comment to print.
sheet.PageSetup.PrintComments = PrintCommentsType.PrintInPlace;
}

wb.Save(outFile.pdf);
5

@Rossmanith,

This is to inform you that we have fixed your issue “CELLSNET-41277” now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

6

@Rossmanith,

Please try our latest version/fix: Aspose.Cells for .NET v19.5.7 (attached).

Your issue should be fixed in it.

Please note:

  1. We have added HtmlSaveOptions.IsExportComments property for CELLSNET-41277, so you can use the following code to test it:
    e.g
    Sample code:

    Workbook wb = new Workbook(filePath + "Input.xlsx");

    HtmlSaveOptions options = new HtmlSaveOptions();

    options.IsExportComments = true;

    wb.Save(filePath + "out.html", options);

Let us know your feedback.
Aspose.Cells19.5.7 For .Net2_AuthenticodeSigned.Zip (4.9 MB)
Aspose.Cells19.5.7 For .Net4.0.Zip (4.9 MB)

7

The issues you have found earlier (filed as CELLSNET-41277) have been fixed in Aspose.Cells for .NET v19.6. This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi