PivotTable.ShowCellBackgroundFromOLAP Property

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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.

public:
 property bool ShowCellBackgroundFromOLAP { bool get(); void set(bool value); };

public bool ShowCellBackgroundFromOLAP { get; set; }

Public Property ShowCellBackgroundFromOLAP As Boolean

Property Value

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.

Applies to