PivotTable.ShowCellBackgroundFromOLAP PivotTable.ShowCellBackgroundFromOLAP PivotTable.ShowCellBackgroundFromOLAP Property


True if the MDX (Multidimensional Expression) that Microsoft Excel sends to the server includes the BackColor property for each cell in the data area that corresponds to a cell in the Online Analytical Processing (OLAP) data set. The default value is False. Read/write Boolean.

 property bool ShowCellBackgroundFromOLAP { bool get(); void set(bool value); };
public bool ShowCellBackgroundFromOLAP { get; set; }
Public Property ShowCellBackgroundFromOLAP As Boolean

Property Value


If the OLAP data set returns a BackColor property value, then the cell fill color is set to the nearest color in Microsoft Excel's palette for that worksheet. If the user applies cell pattern formatting to the cell manually, that will override any formatting from the OLAP data set.

Applies to