Icon Sets conditional formatting - where to read the value of the Show Icon Only flag?


Please take a look at the screenshot. What api should I use to read the highlighted flag?


Thanks for your posting and using Aspose.Cells.

Please set the FormatCondition.IconSet.ShowValue as false to set this flag. Please see the following code for your reference. We have also attached the source and output files for you.


string filePath = @“F:\Shak-Data-RW\Downloads\Book1.xlsx”;

Workbook workbook = new Workbook(filePath);

Worksheet worksheet = workbook.Worksheets[0];

Cell c3 = worksheet.Cells[“C3”];

FormatConditionCollection fcc = c3.GetFormatConditions();

fcc[0].IconSet.ShowValue = false;

workbook.Save(filePath + “.out.xlsx”);