FormatAppearance.BackColor Property (ExPivot)

The BackColor property defines the background color to be applied. This property supports solid colors or EBN colors. The last 7 bits in the high significant byte of the color to indicates the identifier of the skin being used. Use the Add method to add new skins to the control. If you need to remove the skin appearance from a part of the control you need to reset the last 7 bits in the high significant byte of the color being applied to the background's part. The ForeColor property defines the foreground color to be applied on the objects ( columns/rows ).

How can I display the total with a solid background color?
How can I display the total with a different background color/ebn?

How can I display the total with a solid background color?

VBA (MS Access, Excell...)

With Pivot1
	.FormatAppearances.Add("back").BackColor = RGB(240,240,240)
	.Import "C:\Program Files\Exontrol\ExPivot\Sample\data.txt"
	.PivotRows = "0"
	.PivotColumns = "sum(5)"
	.PivotTotals = "sum[back]"
End With

VB6

With Pivot1
	.FormatAppearances.Add("back").BackColor = RGB(240,240,240)
	.Import "C:\Program Files\Exontrol\ExPivot\Sample\data.txt"
	.PivotRows = "0"
	.PivotColumns = "sum(5)"
	.PivotTotals = "sum[back]"
End With

VB.NET

With Expivot1
	.FormatAppearances.Add("back").BackColor = Color.FromArgb(240,240,240)
	.Import("C:\Program Files\Exontrol\ExPivot\Sample\data.txt")
	.PivotRows = "0"
	.PivotColumns = "sum(5)"
	.PivotTotals = "sum[back]"
End With

VB.NET for /COM

With AxPivot1
	.FormatAppearances.Add("back").BackColor = RGB(240,240,240)
	.Import("C:\Program Files\Exontrol\ExPivot\Sample\data.txt")
	.PivotRows = "0"
	.PivotColumns = "sum(5)"
	.PivotTotals = "sum[back]"
End With

C++

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXPIVOTLib' for the library: 'ExPivot 1.0 Control Library'

	#import <ExPivot.dll>
	using namespace EXPIVOTLib;
*/
EXPIVOTLib::IPivotPtr spPivot1 = GetDlgItem(IDC_PIVOT1)->GetControlUnknown();
spPivot1->GetFormatAppearances()->Add(L"back",vtMissing)->PutBackColor(RGB(240,240,240));
spPivot1->Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",vtMissing);
spPivot1->PutPivotRows(L"0");
spPivot1->PutPivotColumns(L"sum(5)");
spPivot1->PutPivotTotals(L"sum[back]");

C++ Builder

Pivot1->FormatAppearances->Add(L"back",TNoParam())->BackColor = RGB(240,240,240);
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"sum(5)";
Pivot1->PivotTotals = L"sum[back]";

expivot1.FormatAppearances.Add("back",null).BackColor = Color.FromArgb(240,240,240);
expivot1.Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",null);
expivot1.PivotRows = "0";
expivot1.PivotColumns = "sum(5)";
expivot1.PivotTotals = "sum[back]";

JavaScript

<OBJECT classid="clsid:5C9DF3D3-81B1-42C4-BED6-658F17748686" id="Pivot1"></OBJECT>

<SCRIPT LANGUAGE="JScript">
	Pivot1.FormatAppearances.Add("back",null).BackColor = 15790320;
	Pivot1.Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",null);
	Pivot1.PivotRows = "0";
	Pivot1.PivotColumns = "sum(5)";
	Pivot1.PivotTotals = "sum[back]";
</SCRIPT>

C# for /COM

axPivot1.FormatAppearances.Add("back",null).BackColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(240,240,240));
axPivot1.Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt",null);
axPivot1.PivotRows = "0";
axPivot1.PivotColumns = "sum(5)";
axPivot1.PivotTotals = "sum[back]";

X++ (Dynamics Ax 2009)

public void init()
{
	COM com_FormatAppearance;
	anytype var_FormatAppearance;
	;

	super();

	var_FormatAppearance = COM::createFromObject(expivot1.FormatAppearances()).Add("back"); com_FormatAppearance = var_FormatAppearance;
	com_FormatAppearance.BackColor(WinApi::RGB2int(240,240,240));
	expivot1.Import("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt");
	expivot1.PivotRows("0");
	expivot1.PivotColumns("sum(5)");
	expivot1.PivotTotals("sum[back]");
}

Delphi 8 (.NET only)

with AxPivot1 do
begin
	FormatAppearances.Add('back',Nil).BackColor := $f0f0f0;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '0';
	PivotColumns := 'sum(5)';
	PivotTotals := 'sum[back]';
end

Delphi (standard)

with Pivot1 do
begin
	FormatAppearances.Add('back',Null).BackColor := $f0f0f0;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	PivotColumns := 'sum(5)';
	PivotTotals := 'sum[back]';
end

VFP

with thisform.Pivot1
	.FormatAppearances.Add("back").BackColor = RGB(240,240,240)
	.Import("C:\Program Files\Exontrol\ExPivot\Sample\data.txt")
	.PivotRows = "0"
	.PivotColumns = "sum(5)"
	.PivotTotals = "sum[back]"
endwith

dBASE Plus

local oPivot,var_FormatAppearance

oPivot = form.Activex1.nativeObject
// oPivot.FormatAppearances.Add("back").BackColor = 0xf0f0f0
var_FormatAppearance = oPivot.FormatAppearances.Add("back")
with (oPivot)
	TemplateDef = [Dim var_FormatAppearance]
	TemplateDef = var_FormatAppearance
	Template = [var_FormatAppearance.BackColor = 0xf0f0f0]
endwith
oPivot.Import("C:\Program Files\Exontrol\ExPivot\Sample\data.txt")
oPivot.PivotRows = "0"
oPivot.PivotColumns = "sum(5)"
oPivot.PivotTotals = "sum[back]"

XBasic (Alpha Five)

Dim oPivot as P
Dim var_FormatAppearance as P

oPivot = topparent:CONTROL_ACTIVEX1.activex
' oPivot.FormatAppearances.Add("back").BackColor = 15790320
var_FormatAppearance = oPivot.FormatAppearances.Add("back")
oPivot.TemplateDef = "Dim var_FormatAppearance"
oPivot.TemplateDef = var_FormatAppearance
oPivot.Template = "var_FormatAppearance.BackColor = 15790320"

oPivot.Import("C:\Program Files\Exontrol\ExPivot\Sample\data.txt")
oPivot.PivotRows = "0"
oPivot.PivotColumns = "sum(5)"
oPivot.PivotTotals = "sum[back]"

Visual Objects


oDCOCX_Exontrol1:FormatAppearances:Add("back",nil):BackColor := RGB(240,240,240)
oDCOCX_Exontrol1:Import("C:\Program Files\Exontrol\ExPivot\Sample\data.txt",nil)
oDCOCX_Exontrol1:PivotRows := "0"
oDCOCX_Exontrol1:PivotColumns := "sum(5)"
oDCOCX_Exontrol1:PivotTotals := "sum[back]"

PowerBuilder

OleObject oPivot

oPivot = ole_1.Object
oPivot.FormatAppearances.Add("back").BackColor = RGB(240,240,240)
oPivot.Import("C:\Program Files\Exontrol\ExPivot\Sample\data.txt")
oPivot.PivotRows = "0"
oPivot.PivotColumns = "sum(5)"
oPivot.PivotTotals = "sum[back]"

How can I display the total with a different background color/ebn?