Add conditional icons next to the text in a cell

Aspose.Cells Product Family
1

Dear Support member,


Could you please provide an example to add conditional icons next to the text in a cell?

Thanks,
Cpunji
2

Hi Cpunji,

Thanks for your posting and using Aspose.Cells.

Aspose.Cells does support conditional formatting implementation with its APIs. Please provide us your simple sample expected output file which you can create manually using Excel and post it here so that we could look into your requirement precisely.

We will investigate your expected output Excel file and provide you a sample code how to achieve your desired output with Aspose.Cells.

3

Hi Shakeel,


Attached file contains cells with conditional icon at the beginning of the cell value. I would like to have the icons placed after cell value.

Is it possible? If it is possible please provide the code sample

In one of your online docs in the below link:
Add Conditional Icons Set with the Cell Text|Documentation

It says “Sometimes, you want to add conditional icons next to the text in a cell to make data more meaningful to readers. You want to use some of the conditional formatting icon types but without applying conditional formatting to cells. Aspose.Cells supports the feature.”

4

Hi Cpunji,

Thanks for your screenshot and using Aspose.Cells.

Actually, this is not possible in MS-Excel. Aspose.Cells provides the same functionality as MS-Excel does. If some feature is not available in MS-Excel, it will also not be available in Aspose.Cells.

If you think, this feature is available in MS-Excel, then you can create a sample xls/xlsx file with your desired conditional formatting and post it here for our reference.

We will look into it and implement this feature in Aspose.Cells.