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.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property ShowCellBackgroundFromOLAP As Boolean
Get
Set
'Usage
Dim instance As PivotTable
Dim value As Boolean
value = instance.ShowCellBackgroundFromOLAP
instance.ShowCellBackgroundFromOLAP = value
bool ShowCellBackgroundFromOLAP { get; set; }
Property Value
Type: System.Boolean
Remarks
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.