GrapeCity.Documents.Excel.IRange.DefaultValue

DefaultValue Property

Gets or sets the default value of the cell, it can be the value data or the formula string. It works when the cell has no data.

object DefaultValue { get; set; }

Property DefaultValue As Object

IRange range = worksheet.Range["A1"];
range.DefaultValue = "Not entered";
object value = range.Value;