We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Condtional Commenting

Hi Team,

Is it possible to add comments to the cells based on some conditions.
Eg:
If($A2>0) // Fromula
Then add comments to a cell
Else
No Comments

@GeP

Thanks for considering Aspose APIs.

Aspose.Cells is a subset of Microsoft Excel in terms of its features. So, if such a feature (as you have shared in your post) is supported by Microsoft Excel, then it might also be supported by Aspose.Cells.

Please create such an Excel file manually using Microsoft Excel and provide it to us. We will then look into it and create a similar Excel file using Aspose.Cells and provide you a sample code.

By the way, Conditional Formatting itself is supported by Aspose.Cells and all types of Conditional Formatting (e.g. Data Bars, Icon Sets, Color Scale etc.) is supported by Aspose.Cells.

Here is an Online Document for your reference.

Hi,

Can you please confirm from your team that such feature is available in excel or not?
It will be very helpful if you do so. Meanwhile we will check at our end.

@GeP,

After initial investigation, we think, this feature is not supported. However, if you know some Excel function that could insert comment inside the cell than we think, your requirements are achievable. So, please find some function like =InsertComment() or =AddComment() etc. Please take your time and research it and let us know your findings.