ShowValue Property

Gets or sets a Boolean value that specifies if the value in the cell should be displayed or not. Default value is true.
Property ShowValue As Boolean
Dim instance As IDataBar
Dim value As Boolean
instance.ShowValue = value
value = instance.ShowValue
bool ShowValue {get; set;}
When only graphical representation is enough then we can make use of ShowValue property to hide the data in the cells. By default this is set to "True". We can change it to "False" to hide the values in the cells. Here in our example we set the ShowValues property to "False" to hide the data in the cells.
using Syncfusion.XlsIO;
class Example
    static void Main()
        using (ExcelEngine excelEngine = new ExcelEngine())
            //Create a worksheet.        
            IApplication application = excelEngine.Excel;
            application.DefaultVersion = ExcelVersion.Excel2013;            
            IWorkbook workbook = application.Workbooks.Create(1);
            IWorksheet worksheet = workbook.Worksheets[0];
            //Load data to Apply Conditional Formatting.
            worksheet["A1"].Text = "DataBar";
            worksheet["A2"].Number = 10;
            worksheet["A3"].Number = 20;
            worksheet["A4"].Number = 30;
            worksheet["A5"].Number = 40;
            worksheet["A6"].Number = 50;
            worksheet["A7"].Number = 60;
            worksheet["A8"].Number = 70;
            worksheet["A9"].Number = 80;
            worksheet["A10"].Number = 90;
            worksheet["A11"].Number = 100;
            //Create instance of IConditonalFormat and IConditionalFormats.
            IConditionalFormats formats = worksheet["A2:A11"].ConditionalFormats;
            IConditionalFormat format = formats.AddCondition();
            //Set FormatType as DataBar.
            format.FormatType = ExcelCFType.DataBar;
            IDataBar dataBar = format.DataBar;
            //Set ShowValue
            dataBar.ShowValue = false;
            //Save and Dispose.

Syncfusion.XlsIO.Base: 17.1460.0.32

See Also