GrapeCity.Documents.Excel.IPivotTable.DisplayNullString

DisplayNullString Property

DisplayNullString

Gets or sets whether the PivotTable report displays a custom string in cells that contain null values.

When this property is true, the PivotTable uses the string specified by NullString for cells that contain null values. The default value is true.

Declaration

bool DisplayNullString { get; set; }

Property DisplayNullString As Boolean

Examples

worksheet.Range["A1:B4"].Value = new object[,] {
    {"Name", "Value"},
    {"A", 100},
    {"B", null},
    {"A", 200}
};
IPivotCache pivotCache = workbook.PivotCaches.Create(worksheet.Range["A1:B4"]);
IPivotTable pivotTable = worksheet.PivotTables.Add(pivotCache, worksheet.Range["D1"], "PivotTable1");
bool displayNullstring = pivotTable.DisplayNullString;