124:
FilterBarCaption ALL Keyword ( sample 2, result )

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FilterBarFont := (IUnknown(Font) as stdole_TLB.StdFont);
	Description[EXPIVOTLib_TLB.exFilterBarAnd] := FormatABC('`<fgcolor=808080> ` + value + ` </fgcolor>`',OleVariant(Description[EXPIVOTLib_TLB.exFilterBarAnd]),Null,Null);
	FilterBarCaption := '(( ( value replace `[<b>` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `</b>]` with ` </b></bgcolor></fgcolor>` replace `' + 
	'[<s>` with `<bgcolor=C0C0C0><fgcolor=FFFFFF> ` replace `</s>]` with ` </fgcolor></bgcolor>` )  + `<r><fgcolor=808080>` + ( match' + 
	'itemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount + 1) + ` result(s)` ) : (`<r><fgcolor=808080>`+ itemcoun' + 
	't + ` item(s)`) )))';
	FilterBarPromptVisible := Integer(EXPIVOTLib_TLB.exFilterBarCompact) Or Integer(EXPIVOTLib_TLB.exFilterBarShowCloseIfRequired) Or Integer(EXPIVOTLib_TLB.exFilterBarSingleLine) Or Integer(EXPIVOTLib_TLB.exFilterBarCaptionVisible) Or Integer(EXPIVOTLib_TLB.exFilterBarVisible) Or Integer(EXPIVOTLib_TLB.exFilterBarPromptVisible);
	EndUpdate();
end
123:
FilterBarCaption ALL Keyword ( sample 1 )

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FilterBarFont := (IUnknown(Font) as stdole_TLB.StdFont);
	Description[EXPIVOTLib_TLB.exFilterBarAnd] := FormatABC('`<fgcolor=808080> ` + value + ` </fgcolor>`',OleVariant(Description[EXPIVOTLib_TLB.exFilterBarAnd]),Null,Null);
	FilterBarCaption := 'all';
	FilterBarPromptVisible := Integer(EXPIVOTLib_TLB.exFilterBarVisible) Or Integer(EXPIVOTLib_TLB.exFilterBarPromptVisible);
	EndUpdate();
end
122:
FilterBarCaption ALLUI Keyword ( sample 2, result )

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FilterBarFont := (IUnknown(Font) as stdole_TLB.StdFont);
	Description[EXPIVOTLib_TLB.exFilterBarAnd] := FormatABC('`<fgcolor=808080> ` + value + ` </fgcolor>`',OleVariant(Description[EXPIVOTLib_TLB.exFilterBarAnd]),Null,Null);
	FilterBarCaption := '(( ( allui replace `[<b>` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `</b>]` with ` </b></bgcolor></fgcolor>` replace `' + 
	'[<s>` with `<bgcolor=C0C0C0><fgcolor=FFFFFF> ` replace `</s>]` with ` </fgcolor></bgcolor>` )  + `<r><fgcolor=808080>` + ( match' + 
	'itemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount + 1) + ` result(s)` ) : (`<r><fgcolor=808080>`+ itemcoun' + 
	't + ` item(s)`) )))';
	FilterBarPromptVisible := Integer(EXPIVOTLib_TLB.exFilterBarVisible) Or Integer(EXPIVOTLib_TLB.exFilterBarPromptVisible);
	EndUpdate();
end
121:
FilterBarCaption ALLUI Keyword ( sample 1 )

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FilterBarFont := (IUnknown(Font) as stdole_TLB.StdFont);
	Description[EXPIVOTLib_TLB.exFilterBarAnd] := FormatABC('`<fgcolor=808080> ` + value + ` </fgcolor>`',OleVariant(Description[EXPIVOTLib_TLB.exFilterBarAnd]),Null,Null);
	FilterBarCaption := 'allui';
	FilterBarPromptVisible := Integer(EXPIVOTLib_TLB.exFilterBarVisible) Or Integer(EXPIVOTLib_TLB.exFilterBarPromptVisible);
	EndUpdate();
end
120:
FilterBarCaption AVAILABLE Keyword ( sample 2, result )

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FilterBarFont := (IUnknown(Font) as stdole_TLB.StdFont);
	Description[EXPIVOTLib_TLB.exFilterBarAnd] := FormatABC('`<fgcolor=808080> ` + value + ` </fgcolor>`',OleVariant(Description[EXPIVOTLib_TLB.exFilterBarAnd]),Null,Null);
	FilterBarCaption := '(( ( value replace `[` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `]` with ` </b></bgcolor></fgcolor>` ) + ` ` + ( avai' + 
	'lable replace `[` with `<bgcolor=C0C0C0><fgcolor=FFFFFF><b> ` replace `]` with ` </b></bgcolor></fgcolor>` replace `<s>` with ``' + 
	' replace `</s>` with `` ) + `<fgcolor=808080>` + ( matchitemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount ' + 
	'+ 1) + ` result(s)` ) : (`<r><fgcolor=808080>`+ itemcount + ` item(s)`) )))';
	FilterBarPromptVisible := Integer(EXPIVOTLib_TLB.exFilterBarVisible) Or Integer(EXPIVOTLib_TLB.exFilterBarPromptVisible);
	EndUpdate();
end
119:
FilterBarCaption AVAILABLE Keyword ( sample 1 )

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FilterBarFont := (IUnknown(Font) as stdole_TLB.StdFont);
	Description[EXPIVOTLib_TLB.exFilterBarAnd] := FormatABC('`<fgcolor=808080> ` + value + ` </fgcolor>`',OleVariant(Description[EXPIVOTLib_TLB.exFilterBarAnd]),Null,Null);
	FilterBarCaption := 'value + ` ` + available';
	FilterBarPromptVisible := Integer(EXPIVOTLib_TLB.exFilterBarVisible) Or Integer(EXPIVOTLib_TLB.exFilterBarPromptVisible);
	EndUpdate();
end
118:
Is it possible to somehow highlight the column's name different than its filter value in the control's filter bar ( sample 3, results )

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FilterBarFont := (IUnknown(Font) as stdole_TLB.StdFont);
	Description[EXPIVOTLib_TLB.exFilterBarAnd] := FormatABC('`<fgcolor=808080>` + value + `</fgcolor>`',OleVariant(Description[EXPIVOTLib_TLB.exFilterBarAnd]),Null,Null);
	FilterBarCaption := '(`<b>` + value + `</b><fgcolor=808080>` + ( matchitemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount + 1) + ' + 
	'` result(s)` ) : (`<fgcolor=808080>`+ itemcount + ` item(s)`) )) replace `[` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace' + 
	' `]` with ` </b></bgcolor></fgcolor>`';
	FilterBarPromptVisible := EXPIVOTLib_TLB.exFilterBarToggle;
	EndUpdate();
end
117:
Is it possible to somehow highlight the column's name different than its filter value in the control's filter bar ( sample 2 )

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FilterBarFont := (IUnknown(Font) as stdole_TLB.StdFont);
	Description[EXPIVOTLib_TLB.exFilterBarAnd] := FormatABC('`<fgcolor=808080>` + value + `</fgcolor>`',OleVariant(Description[EXPIVOTLib_TLB.exFilterBarAnd]),Null,Null);
	FilterBarCaption := 'value replace `[` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `]` with ` </b></bgcolor></fgcolor>`';
	FilterBarPromptVisible := EXPIVOTLib_TLB.exFilterBarToggle;
	EndUpdate();
end
116:
Is it possible to somehow highlight the column's name different than its filter value in the control's filter bar ( sample 1 )

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	Description[EXPIVOTLib_TLB.exFilterBarAnd] := FormatABC('`<fgcolor=808080>` + value + `</fgcolor>`',OleVariant(Description[EXPIVOTLib_TLB.exFilterBarAnd]),Null,Null);
	FilterBarCaption := 'value replace `[` with `<fgcolor=808080>[` replace `]` with `]</fgcolor>`';
	FilterBarPromptVisible := EXPIVOTLib_TLB.exFilterBarToggle;
	EndUpdate();
end
115:
Is it possible to automatically displays the control's filter label to the right

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FilterBarCaption := '`<r>` + value';
	FilterBarPromptVisible := Integer(EXPIVOTLib_TLB.exFilterBarShowCloseOnRight) Or Integer(EXPIVOTLib_TLB.exFilterBarToggle);
	EndUpdate();
end
114:
How can I get the number of results/items being shown in the control's filter bar (sample 4)

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FilterBarFont := (IUnknown(Font) as stdole_TLB.StdFont);
	FilterBarPrompt := FormatABC('`<b>` + value',OleVariant(FilterBarPrompt),Null,Null);
	FilterBarCaption := '`<b><r>` + value + `</b><fgcolor=808080>` + ( matchitemcount < 0 ? ( ( len(value) ? `<br>` : `` ) + `<r>` + abs(matchitemcount +' + 
	' 1) + ` result(s)` ) : (`<fgcolor=808080>`+ itemcount + ` item(s)`) )';
	FilterBarPromptVisible := Integer(EXPIVOTLib_TLB.exFilterBarCompact) Or Integer(EXPIVOTLib_TLB.exFilterBarShowCloseOnRight) Or Integer(EXPIVOTLib_TLB.exFilterBarShowCloseIfRequired) Or Integer(EXPIVOTLib_TLB.exFilterBarCaptionVisible) Or Integer(EXPIVOTLib_TLB.exFilterBarVisible) Or Integer(EXPIVOTLib_TLB.exFilterBarPromptVisible);
	EndUpdate();
end
113:
How can I get the number of results being shown in the control's filter bar (sample 3)

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FilterBarFont := (IUnknown(Font) as stdole_TLB.StdFont);
	FilterBarCaption := '`<b><r>` + value + `</b><fgcolor=808080>` + ( matchitemcount < 0 ? ( ( len(value) ? `<br>` : `` ) + `<r>` + abs(matchitemcount +' + 
	' 1) + ` result(s)` ) : ``)';
	FilterBarPromptVisible := Integer(EXPIVOTLib_TLB.exFilterBarCompact) Or Integer(EXPIVOTLib_TLB.exFilterBarCaptionVisible) Or Integer(EXPIVOTLib_TLB.exFilterBarVisible) Or Integer(EXPIVOTLib_TLB.exFilterBarPromptVisible);
	EndUpdate();
end
112:
How can I get the number of results being shown in the control's filter bar (sample 2, compact)

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FilterBarFont := (IUnknown(Font) as stdole_TLB.StdFont);
	FilterBarCaption := '`<b><r>` + value + `</b><fgcolor=808080>` + ( matchitemcount < 0 ? `<off -4> ` + abs(matchitemcount + 1) + ` result(s)` : ``)';
	FilterBarPromptVisible := Integer(EXPIVOTLib_TLB.exFilterBarCompact) Or Integer(EXPIVOTLib_TLB.exFilterBarSingleLine) Or Integer(EXPIVOTLib_TLB.exFilterBarCaptionVisible) Or Integer(EXPIVOTLib_TLB.exFilterBarVisible) Or Integer(EXPIVOTLib_TLB.exFilterBarPromptVisible);
	EndUpdate();
end
111:
How can I get the number of results being shown in the control's filter bar (sample 1)

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FilterBarFont := (IUnknown(Font) as stdole_TLB.StdFont);
	FilterBarCaption := '`<b>` + value + `</b><r><fgcolor=808080>` + ( matchitemcount < 0 ? abs(matchitemcount + 1) + ` result(s)` : ``)';
	FilterBarPromptVisible := Integer(EXPIVOTLib_TLB.exFilterBarCaptionVisible) Or Integer(EXPIVOTLib_TLB.exFilterBarVisible) Or Integer(EXPIVOTLib_TLB.exFilterBarPromptVisible);
	EndUpdate();
end
110:
FilterBarCaption Predefined Keywords

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	LinesAtRoot := EXPIVOTLib_TLB.exLinesAtRoot;
	FilterInclude := EXPIVOTLib_TLB.exItemsWithChilds;
	FilterBarFont := (IUnknown(Font) as stdole_TLB.StdFont);
	FilterBarCaption := '`<fgcolor=0000FF><i>value/current</i></fgcolor>: <fgcolor=808080>` + value + `</fgcolor>` + `<br><fgcolor=0000FF><i>available</i' + 
	'></fgcolor>: ` + available + `<br><fgcolor=0000FF><i>allui</i></fgcolor>: ` + allui + `<br><fgcolor=0000FF><i>all</i></fgcolor>:' + 
	' ` + all + `<br><fgcolor=0000FF><i>itemcount</i></fgcolor>: <fgcolor=808080>` + itemcount + `</fgcolor>`+ `<br><fgcolor=0000FF><' + 
	'i>visibleitemcount</i></fgcolor>: <fgcolor=808080>` + visibleitemcount + `</fgcolor>`+ `<br><fgcolor=0000FF><i>matchitemcount</i' + 
	'></fgcolor>: <fgcolor=808080>` + matchitemcount + `</fgcolor>`+ `<br><fgcolor=0000FF><i>promptpattern</i></fgcolor>: <fgcolor=80' + 
	'8080>` + promptpattern + `</fgcolor>`+ `<br><fgcolor=0000FF><i>leafitemcount</i></fgcolor>: <fgcolor=808080>` + leafitemcount + ' + 
	'`</fgcolor>`';
	FilterBarPromptPattern := 'USA';
	FilterBarPromptVisible := Integer(EXPIVOTLib_TLB.exFilterBarCaptionVisible) Or Integer(EXPIVOTLib_TLB.exFilterBarVisible) Or Integer(EXPIVOTLib_TLB.exFilterBarPromptVisible);
	EndUpdate();
end
109:
I am using filter prompt feature, and also column's filter, just wondering if possible to compact displaying the filter bar so it won't show on multiple lines

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FilterBarFont := (IUnknown(Font) as stdole_TLB.StdFont);
	FilterBarCaption := '`<r><i><fgcolor=808080><upline><solidline><sha ;;0>` + value';
	FilterBarPromptPattern := 'USA';
	FilterBarPromptVisible := Integer(EXPIVOTLib_TLB.exFilterBarCompact) Or Integer(EXPIVOTLib_TLB.exFilterBarSingleLine) Or Integer(EXPIVOTLib_TLB.exFilterBarVisible) Or Integer(EXPIVOTLib_TLB.exFilterBarPromptVisible);
	EndUpdate();
end
108:
Just wondering if it is possible to show the filter bar's close button on the right ( sample 2 )

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FilterBarPromptVisible := Integer(EXPIVOTLib_TLB.exFilterBarShowCloseOnRight) Or Integer(EXPIVOTLib_TLB.exFilterBarToggle) Or Integer(EXPIVOTLib_TLB.exFilterBarPromptVisible);
	FilterBarPrompt := FormatABC('`<r>` + value',OleVariant(FilterBarPrompt),Null,Null);
	EndUpdate();
end
107:
How can I change the visual appearance of the filter bar's close button (EBN)

with Pivot1 do
begin
	BeginUpdate();
	with VisualAppearance do
	begin
		Add(1,'gBFLBCJwBAEHhEJAAEhABHQDg6AADACAxRDgMQBQKAAzAJBIYhiG4cYCgMZhXDOCYXABCEYRXBIZQ7BKNIxjSJ5BhIAAyDSJMjSRJUEhqGCWYDleYYYAKHIMQLOg7IJj' + 
	'yI4/SJAYCydKAWhxIaZKJHCZoEDaTAADCNVAQp6MEIJVbVEI0e79OgBLp/Z7kECIJJAaRjHQdJxGLA8EhtCQhCZteK6SgMKJYXhWQYRXI1JwvMBrWrdQjiOYELQtMKmS' + 
	'ZNLYGG4dR5SVJbcYhSYsRRFMoyDIOXYDLKsdYqSpXIThObEGgaPqJYjsUjCMKnR7HVIURrBPC9TBPE69ZgmC6ucKPX51ShKFaBWDZcwFAS+UBuYCAILiEAQGZ1XT8ORO' + 
	'icbgJgSTJRlCaZeDsHY7QGR4xkSYp3CaExZAQMgalQYAwjCAAfBANxcA2TgKAUOpDCGFhKg0RpXCwCwDHQHQHEyAIkCkOhbFOGA8A8DohBgRg9AccZcn8EpEjMLI2C2D' + 
	'YxAgQgvAIUIVkoAAPBQDJlECTZ3CCYwDACQwUA8A5MCAWAWDiQi4l8aQOEgLJuBgBgDmYFAzEoIoIl0WALgKYJbBABADAAHgHg8VAMmqCQQDMXABAATYwTmNwBDATJXA' + 
	'iAgjHmNQ5lgQ5QEQEQMmcWg/GwD5ylyNw2gMcJcjsBgBgOQQDDhRpVAMMwnDBFw1B0Ax8D0DxOmmJJIGQTY5hGMAwkwM4CAYLZAmAOJnAqAojiIGg6iieYkmeAYOHaKJ' + 
	'DCyCwjH6AoggsQpQliAJLhgaJ0CESBTnyDwjk+cg4g4P5IHIHJ+BWRRzlYWAxiOUxihsY4KjKLJRGqC44FCegkkkM58iAKAPnIWIWD8SRSFSfQnkmewUhYP4GiGKJ7G0' + 
	'TIbCSUoggqUo0lAQ4LnEcBcD8Coiiif4nE+eAAn2HpOkcFJqi4T5SkyMw/kqQown8IBIBOdA+A+DJrBqVxXEqYo4lCApLhGHBnD8S4ymyfxmg+cwQkQP5egOUZIWoEAk' + 
	'jIeIPBMBJBD+TBjBifwvkuc58hQJQPmFrYykkchclSApKjGOBuD+TRDFCfw3mmIxNi8FxFlOXhVC4aYDFyPgvg2YBcBcLZGCGCJ0DSLRzGSWQ/lmY5+mEP5gmMDBZRSM' + 
	'RsFsOxMhMJJ/DsTpTnwaQaE+N5ojuNhdEYNI5C4TZJO1GRDmCaxnA2Yx4n8IpIjOTBQBQC5TgyYw7gUYRYikC0BYRwsDQBoB8eA6Q2hsE0BUXgywZtYCyHMKwnxSAhAQ' + 
	'HkIQhRrBaDsCwA4ERiB2EWAIYIXhhiVEgAEUYwwYjyASLge4FhHgRDkM8OQih0jWPkGgBBAQ');
	end;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FilterBarPromptVisible := Integer(EXPIVOTLib_TLB.exFilterBarToggle) Or Integer(EXPIVOTLib_TLB.exFilterBarPromptVisible);
	Background[EXPIVOTLib_TLB.exFooterFilterBarButton] := $1000000;
	EndUpdate();
end
106:
How can I change the visual appearance of the filter bar's close button (solid)

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FilterBarPromptVisible := EXPIVOTLib_TLB.exFilterBarPromptVisible;
	Background[EXPIVOTLib_TLB.exFooterFilterBarButton] := $ff;
	EndUpdate();
end
105:
Is it possible to prevent definitely showing the filter bar's close button

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FilterBarPromptVisible := EXPIVOTLib_TLB.exFilterBarPromptVisible;
	Background[EXPIVOTLib_TLB.exFooterFilterBarButton] := $ffffffff;
	EndUpdate();
end
104:
Is it possible to show the close button only if there is a filter applied

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FilterBarPromptVisible := Integer(EXPIVOTLib_TLB.exFilterBarShowCloseIfRequired) Or Integer(EXPIVOTLib_TLB.exFilterBarPromptVisible);
	EndUpdate();
end
103:
The control's filter bar is not closed once I click the close button (toggle)
with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FilterBarCaption := '`<r><fgcolor=808080>` + value';
	FilterBarPromptPattern := 'USA';
	FilterBarPromptVisible := Integer(EXPIVOTLib_TLB.exFilterBarCompact) Or Integer(EXPIVOTLib_TLB.exFilterBarToggle) Or Integer(EXPIVOTLib_TLB.exFilterBarSingleLine) Or Integer(EXPIVOTLib_TLB.exFilterBarVisible) Or Integer(EXPIVOTLib_TLB.exFilterBarPromptVisible);
	EndUpdate();
end
102:
How can I display the control's filter on a single line

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FilterBarCaption := 'len(value) ? `filter for: <fgcolor 808080>` + value  : `<fgcolor 808080>no filter`';
	FilterBarPromptVisible := Integer(EXPIVOTLib_TLB.exFilterBarSingleLine) Or Integer(EXPIVOTLib_TLB.exFilterBarVisible);
	EndUpdate();
end
101:
How can I display the control's filter on a single line (prompt-combined)

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FilterBarCaption := '`<r>` + value';
	FilterBarPromptVisible := Integer(EXPIVOTLib_TLB.exFilterBarCompact) Or Integer(EXPIVOTLib_TLB.exFilterBarSingleLine) Or Integer(EXPIVOTLib_TLB.exFilterBarVisible) Or Integer(EXPIVOTLib_TLB.exFilterBarPromptVisible);
	EndUpdate();
end
100:
How can I programmatically clear the control's filter
// Click event - Occurs when the user presses and then releases the left mouse button over the control.
procedure TForm1.Pivot1Click(ASender: TObject; );
begin
	with Pivot1 do
	begin
		ClearFilter();
	end
end;

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FilterBarPromptVisible := EXPIVOTLib_TLB.exFilterBarPromptVisible;
	FilterBarPromptPattern := 'USA';
	EndUpdate();
end
99:
Is it possible to prevent closing the control's filter bar, so it is always shown (prompt-combined)

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FilterBarPromptPattern := 'USA';
	FilterBarPromptVisible := Integer(EXPIVOTLib_TLB.exFilterBarVisible) Or Integer(EXPIVOTLib_TLB.exFilterBarPromptVisible);
	EndUpdate();
end
98:
Is it possible to prevent closing the control's filter bar, so it is always shown (prompt)

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FilterBarPromptVisible := EXPIVOTLib_TLB.exFilterBarPromptVisible;
	FilterBarPromptPattern := 'USA';
	EndUpdate();
end
97:
Is it possible to prevent closing the control's filter bar, so it is always shown

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FilterBarCaption := 'len(value) = 0 ? `<fgcolor=808080>no filter` : value';
	FilterBarPromptVisible := EXPIVOTLib_TLB.exFilterBarVisible;
	EndUpdate();
end
96:
How can I find if the control is running in DPI mode
with Pivot1 do
begin
	OutputDebugString( FormatABC('dpi = 1 ? `normal/stretch mode` : `dpi mode`',Null,Null,Null) );
end
95:
If I connect it to a datasource, all works perfectly but the records that I see in the control is a little number of total of the recordset. I need to show all 60.000 rows of the recordset without click on the [...] button. Itís possible to setting up this parameters
with Pivot1 do
begin
	DisplayPivotData := -1;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
end
94:
How do I change the drop down filter icon/button (white)

with Pivot1 do
begin
	BeginUpdate();
	with VisualAppearance do
	begin
		Add(2,'gBFLBCJwBAEHhEJAAEhABX8GACAADACAxSDEMQBQKAAzQFAYbhgHCGAAGQaBUgmFgAQhFcZQSKUOQTDKNYykCIRSDUJYkSZEIyjBI8ExXFqNACkGKwYgmNYiTLAcgANJ' + 
	'0WBaGIZJ4gOT5fDKMoEDRRYADFCscwxJybQAqGQKKb+VgAVY/cTyBIAEQSKA0TDOQ5TSKWB4JPZQRBEbZMNBtBIUJquKaqShdQJCU5FdY3Xblez9P7AMBwLFEC4NQ8YN' + 
	'YuPhjR4dRTIMhvVAsUArFh8Zg9GZZFjmDIDT4ydBLTQwcyVIKnP5qOa6XbmPoCQDYKxZHYxPzVDa3axuL76dqCAT7XrXNy1TbNRrzQKfcJqfCbdw2YaDZLOOT3fjuI4h' + 
	'hKaRzFAHJ+jYQ4xHuY4gHuGIXGeExqC8Tp6C+PoEm+G5ImycRgh0XwvDGa5rgOeoejyXwnFeQp2mkf5ClgBB9gCWIYAwfYAEKV58mkdwOggNArgOXY2EWLoDkKOA0mgb' + 
	'hOGgZApgaSBIHWSYHSmbApgYThmESZYJkIeIkgeCpfliLIHgpMIcmUYYYmODAlg2SI4mWfRfGOEguDcCRjFYAJihCQhJBSDoRmONgKEcI4kFCEJhhOVYTmYnAlEAQhWB' + 
	'MJYJGYWoWmWSR2F6F5lnkWAQhUAgpEieRWEuSYkjWGpmkmNhuhuZwJkYcocmaaYkjyEhngnUA6lEFAlAEgI=');
		Add(1,'CP:2 -6 -4 2 4');
	end;
	Background[EXPIVOTLib_TLB.exHeaderFilterBarButton] := $1000000;
	Background[EXPIVOTLib_TLB.exCursorHoverColumn] := BackColor;
	HeaderVisible := True;
	HeaderHeight := 24;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	DisplayFilterList := Integer(EXPIVOTLib_TLB.exShowCheckBox) Or Integer(EXPIVOTLib_TLB.exSortItemsAsc);
	PivotBarVisible := EXPIVOTLib_TLB.exPivotBarVisible;
	EndUpdate();
end
93:
How do I change the drop down filter icon/button (black)

with Pivot1 do
begin
	BeginUpdate();
	with VisualAppearance do
	begin
		Add(1,'gBFLBCJwBAEHhEJAAEhABXUIQAAYAQGKIcBiAKBQAGYBIJDEMgzDDAUBjKKocQTC4AIQjCK4JDKHYJRpHEZyCA8EhqGASRAFUQBYiWE4oSpLABQaK0ZwIGyRIrkGQgQg' + 
	'mPYDSDNU4zVIEEglBI0TDNczhNDENgtGYaJqHIYpZBcM40TKkEZoSIITZcRrOEBiRL1S0RBhGcRUHZlWzdN64LhuK47UrWdD/XhdVzXRbjfz1Oq+bxve48Br7A5yYThd' + 
	'r4LhOFQ3RjIL4xbIcUwGe6VZhjOLZXjmO49T69HTtOCYBEBA');
	end;
	Background[EXPIVOTLib_TLB.exHeaderFilterBarButton] := $1000000;
	Background[EXPIVOTLib_TLB.exCursorHoverColumn] := $ffffffff;
	BackColorHeader := RGB(0,0,0);
	ForeColorHeader := RGB(255,255,255);
	HeaderVisible := True;
	HeaderHeight := 22;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	DisplayFilterList := Integer(EXPIVOTLib_TLB.exShowCheckBox) Or Integer(EXPIVOTLib_TLB.exSortItemsAsc);
	EndUpdate();
end
92:
How do I prevent showing the control's BackColorAlternate property on empty / non-items part of the control

with Pivot1 do
begin
	BeginUpdate();
	BackColorAlternate := $7ff0f0f0;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '12';
	PivotColumns := 'sum(5)';
	EndUpdate();
end
91:
How can I find out if the user clicks the grid's header
// MouseMove event - Occurs when the user moves the mouse.
procedure TForm1.Pivot1MouseMove(ASender: TObject; Button : Smallint;Shift : Smallint;X : Integer;Y : Integer);
begin
	with Pivot1 do
	begin
		OutputDebugString( 'Type of ColumnFromPoint: ' );
		OutputDebugString( ColumnFromPoint[-1,-1] );
		OutputDebugString( ' should not be VT_NULL' );
		OutputDebugString( 'Type of ValueFromPoint: ' );
		OutputDebugString( ValueFromPoint[-1,-1] );
		OutputDebugString( ' should be VT_NULL' );
	end
end;

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	PivotColumns := 'sum(5)';
end
90:
What should I set FormatPivotHeader to, to show it on the columns header only

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	PivotColumns := 'sum(5)/12';
	FormatPivotHeader := '(iaggregate ? ( caption + ` <off -6><font ;6>(` + lower(caggregate) + '')</off></font>'') : caption) + ( ( display=1 ? `<c>Date: <' + 
	'b><upline><dotline>` + date(`now`) : `` ) + `</dotline> </b>` )';
	EndUpdate();
end
89:
What should I set FormatPivotHeader to, to show "Report Generated on 7/9/2016 14:20" etc when the report is executed (ie the date and time will change)

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	PivotColumns := 'sum(5)/12';
	FormatPivotHeader := '(iaggregate ? (`<b>` + caption + `</b> <off -6><font ;6>(` + lower(caggregate) + '')</off></font>'') : caption) + `<r>ReportDate: ' + 
	'` + date(`now`)';
	EndUpdate();
end
88:
Is it possible to display aggregate result on parent rows as well

with Pivot1 do
begin
	BeginUpdate();
	HeaderHeight := 22;
	DefaultItemHeight := 20;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '12[bold],0';
	with FormatConditionalAppearances.Add('nempty','not empty','') do
	begin
		Expression := 'len(value) != 0';
		BackColor := $f0f0f0;
	end;
	PivotColumns := 'sum(5)[nempty]/6';
	IncludeExpandColumn := EXPIVOTLib_TLB.exIncludeExpandColumn;
	DrawGridLines := EXPIVOTLib_TLB.exNoLines;
	ShowBranchRows := Integer(EXPIVOTLib_TLB.exBranchIncludeAggregate) Or Integer(EXPIVOTLib_TLB.exBranchTree);
	EndUpdate();
end
87:
How do I show expanded/collapsed rows

with Pivot1 do
begin
	BeginUpdate();
	HeaderHeight := 22;
	DefaultItemHeight := 20;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '12[bold],0';
	with FormatConditionalAppearances.Add('nempty','not empty','') do
	begin
		Expression := 'len(value) != 0';
		BackColor := $f0f0f0;
	end;
	PivotColumns := 'sum(5)[nempty]/6';
	IncludeExpandColumn := EXPIVOTLib_TLB.exIncludeExpandColumn;
	DrawGridLines := EXPIVOTLib_TLB.exNoLines;
	EndUpdate();
end
86:
How do I show expanded/collapsed columns

with Pivot1 do
begin
	BeginUpdate();
	HeaderHeight := 22;
	DefaultItemHeight := 20;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	with FormatConditionalAppearances.Add('nempty','not empty','') do
	begin
		Expression := 'len(value) != 0';
		BackColor := $f0f0f0;
	end;
	PivotColumns := 'sum(5)[nempty]/12';
	FormatPivotHeader := '(iaggregate ? ( caption + ` <r>[` + lower(caggregate) + `]` ) : caption)';
	IncludeExpandColumn := EXPIVOTLib_TLB.exIncludeExpandColumn;
	EndUpdate();
end
85:
Where you have say "Sum of ...." as the first row heading of the pivot are there and options to be able to change this text as a whole

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	with FormatConditionalAppearances.Add('nempty','not empty','') do
	begin
		Expression := 'len(value) != 0';
		BackColor := $f0f0f0;
	end;
	PivotColumns := 'sum(5)[nempty]/12';
	FormatPivotHeader := '(iaggregate ? (`<b>` + caption + `</b> <off -6><font ;6>(` + lower(caggregate) + '' )'') : caption)';
	EndUpdate();
end
84:
How can I get the data column from the cursor
// MouseMove event - Occurs when the user moves the mouse.
procedure TForm1.Pivot1MouseMove(ASender: TObject; Button : Smallint;Shift : Smallint;X : Integer;Y : Integer);
begin
	with Pivot1 do
	begin
		OutputDebugString( 'DataColumn' );
		OutputDebugString( DataColumnFromPoint[-1,-1] );
	end
end;

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	PivotColumns := 'sum(5)[content=numeric]';
	Refresh();
end
83:
Is there any way for the user to change the alignment at runtime (using excontextmenu)

// RClick event - Occurs once the user right clicks the control.
procedure TForm1.Pivot1RClick(ASender: TObject; );
begin
	with Pivot1 do
	begin
		h := DataColumns.Item[OleVariant(5)].Alignment;
		c := (IUnknown(ComObj.CreateComObject(ComObj.ProgIDToClassID('Exontrol.ContextMenu'))) as EXCONTEXTMENULib_TLB.ExContextMenu);
		with c do
		begin
			FlatImageWidth := 0;
			ToString := 'Alignment[align=1][dis],[group=0x71](Left[typ=2][grp=100][close=0][id=0],Center[typ=2][grp=100][close=0][id=1],Right[typ=2][grp=' + 
		'100][close=0][id=2])';
			item[OleVariant(h)].Checked := True;
			h := Select(Null,Null,Null);
		end;
		with DataColumns.Item[OleVariant(5)] do
		begin
			Alignment := h;
			HeaderAlignment := h;
		end;
		Refresh();
	end
end;

with Pivot1 do
begin
	PivotBarVisible := Integer(EXPIVOTLib_TLB.exPivotBarAllowResizeColumns) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowUndoRedo) Or Integer(EXPIVOTLib_TLB.exPivotBarAutoUpdate) Or Integer(EXPIVOTLib_TLB.exPivotBarShowTotals) Or Integer(EXPIVOTLib_TLB.exPivotBarAutoFit) Or Integer(EXPIVOTLib_TLB.exPivotBarVisible);
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	with DataColumns.Item[OleVariant(5)] do
	begin
		Alignment := EXPIVOTLib_TLB.RightAlignment;
		HeaderAlignment := EXPIVOTLib_TLB.RightAlignment;
	end;
	PivotRows := '0';
	PivotColumns := 'sum(5)[content=numeric]';
	Refresh();
end
82:
Is there any way for the user to change the alignment at runtime

// RClick event - Occurs once the user right clicks the control.
procedure TForm1.Pivot1RClick(ASender: TObject; );
begin
	with Pivot1 do
	begin
		OutputDebugString( 'The column gets aligned to the center' );
		with DataColumns.Item[OleVariant(5)] do
		begin
			Alignment := EXPIVOTLib_TLB.CenterAlignment;
			HeaderAlignment := EXPIVOTLib_TLB.CenterAlignment;
		end;
		Refresh();
	end
end;

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	with DataColumns.Item[OleVariant(5)] do
	begin
		Alignment := EXPIVOTLib_TLB.RightAlignment;
		HeaderAlignment := EXPIVOTLib_TLB.RightAlignment;
	end;
	PivotRows := '0';
	PivotColumns := 'sum(5)[content=numeric]';
	Refresh();
end
81:
How can I align a column to the right

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	with DataColumns.Item[OleVariant(5)] do
	begin
		Alignment := EXPIVOTLib_TLB.RightAlignment;
		HeaderAlignment := EXPIVOTLib_TLB.RightAlignment;
	end;
	PivotRows := '0';
	PivotColumns := 'sum(5)[content=numeric]';
	Refresh();
end
80:
How can I display the control's content on an single A3 paper size, when using PDF format
with Pivot1 do
begin
	BeginUpdate();
	VisualAppearance.Add(1,'c:\exontrol\images\normal.ebn');
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FormatConditionalAppearances.Item['positive'].BackColor := $100ff00;
	FormatConditionalAppearances.Item['negative'].BackColor := $10000ff;
	PivotRows := '0';
	PivotColumns := 'sum(5)[positive,negative]/12';
	ExpandAll();
	var_CopyTo := CopyTo['C:\Temp\Preview.pdf|11.69 in x 16.53 in||single'];
	OutputDebugString( 'Look for C:\Temp\Preview.pd file.' );
	EndUpdate();
end
79:
How can I display the control's content on an A3 paper size, when using PDF format
with Pivot1 do
begin
	BeginUpdate();
	VisualAppearance.Add(1,'c:\exontrol\images\normal.ebn');
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FormatConditionalAppearances.Item['positive'].BackColor := $100ff00;
	FormatConditionalAppearances.Item['negative'].BackColor := $10000ff;
	PivotRows := '0';
	PivotColumns := 'sum(5)[positive,negative]/12';
	ExpandAll();
	var_CopyTo := CopyTo['C:\Temp\Preview.pdf|11.69 in x 16.53 in'];
	OutputDebugString( 'Look for C:\Temp\Preview.pd file.' );
	EndUpdate();
end
78:
How can I export the control's content to a PDF document (method 1)
with Pivot1 do
begin
	BeginUpdate();
	VisualAppearance.Add(1,'c:\exontrol\images\normal.ebn');
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FormatConditionalAppearances.Item['positive'].BackColor := $100ff00;
	FormatConditionalAppearances.Item['negative'].BackColor := $10000ff;
	PivotRows := '0';
	PivotColumns := 'sum(5)[positive,negative]/12';
	ExpandAll();
	EndUpdate();
	with (IUnknown(ComObj.CreateComObject(ComObj.ProgIDToClassID('Exontrol.Print'))) as EXPRINTLib_TLB.Print) do
	begin
		PrintExt := (IUnknown(Pivot1.DefaultInterface) as EXPIVOTLib_TLB.Pivot);
		CopyTo('c:/temp/xtest.pdf');
	end;
	OutputDebugString( 'Look for C:\Temp\xtest.pdf file.' );
	EndUpdate();
end
77:
How can I export the control's content to a PDF document (method 2)
with Pivot1 do
begin
	BeginUpdate();
	VisualAppearance.Add(1,'c:\exontrol\images\normal.ebn');
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FormatConditionalAppearances.Item['positive'].BackColor := $100ff00;
	FormatConditionalAppearances.Item['negative'].BackColor := $10000ff;
	PivotRows := '0';
	PivotColumns := 'sum(5)[positive,negative]/12';
	ExpandAll();
	var_CopyTo := CopyTo['c:/temp/xtest.pdf'];
	OutputDebugString( 'Look for C:\Temp\xtest.pdf file.' );
	EndUpdate();
end
76:
Does / could the control have a read-only mode by where I could load the data and layout and just use the control to display it and allow the user to scroll around it / print it but not change it
with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	PivotColumns := 'sum(5)[content=numeric]';
	DisplayFilterList := EXPIVOTLib_TLB.exNoItems;
	PivotBarVisible := Integer(EXPIVOTLib_TLB.exPivotBarReadOnly) Or Integer(EXPIVOTLib_TLB.exPivotBarAutoUpdate) Or Integer(EXPIVOTLib_TLB.exPivotBarAutoFit) Or Integer(EXPIVOTLib_TLB.exPivotBarVisible);
	Refresh();
end
75:
Is it possible to edit the conditional-expression at runtime

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	with FormatConditionalAppearances.Add('custom','custom','') do
	begin
		Bold := True;
		FontSize := 12;
		Expression := 'value > 2000';
		ContextEditExpression := True;
	end;
	PivotRows := '0';
	PivotColumns := 'sum(5)[custom]/12';
	EndUpdate();
end
74:
How can I highlight values using EBN colors

with Pivot1 do
begin
	BeginUpdate();
	VisualAppearance.Add(1,'c:\exontrol\images\normal.ebn');
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FormatConditionalAppearances.Item['positive'].BackColor := $100ff00;
	FormatConditionalAppearances.Item['negative'].BackColor := $10000ff;
	PivotRows := '0';
	PivotColumns := 'sum(5)[positive,negative]/12';
	EndUpdate();
end
73:
How do I mark not-empty values in the chart

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	with FormatConditionalAppearances.Add('nempty','not empty','') do
	begin
		Expression := 'len(value) != 0';
		BackColor := $f0f0f0;
	end;
	PivotColumns := 'sum(5)[nempty]/12';
	EndUpdate();
end
72:
How can I highlight negative and positive values in the same chart

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	PivotColumns := 'sum(5)[negative,positive]/12';
	EndUpdate();
end
71:
How can I highlight values that starts with a letter

with Pivot1 do
begin
	BeginUpdate();
	with FormatConditionalAppearances.Add('f','starts with f','lower(value) startwith `f`') do
	begin
		Expression := 'lower(value) startwith `f`';
		Shadow := $1;
		ShadowOffset := 0;
	end;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0[f]';
	EndUpdate();
end
70:
How can I mark values greater than a value, 100 for instance

with Pivot1 do
begin
	BeginUpdate();
	with FormatConditionalAppearances.Add('greater100','>100','value > 100') do
	begin
		Expression := '( dbl(value) != 0 ) ? (value > 100) : 0';
		ForeColor := $ff;
	end;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	PivotColumns := 'sum(5)[greater100,content=numeric]';
	EndUpdate();
end
69:
How can I remove the Conditional context-menu

with Pivot1 do
begin
	BeginUpdate();
	PivotBarVisible := Integer(EXPIVOTLib_TLB.exPivotBarAllowResizeColumns) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowUndoRedo) Or Integer(EXPIVOTLib_TLB.exPivotBarAutoUpdate) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowFormatContent) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowFormatAppearance) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowValues) Or Integer(EXPIVOTLib_TLB.exPivotBarShowTotals) Or Integer(EXPIVOTLib_TLB.exPivotBarAutoFit) Or Integer(EXPIVOTLib_TLB.exPivotBarSizable) Or Integer(EXPIVOTLib_TLB.exPivotBarVisible);
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	PivotColumns := 'sum(5)[content=numeric]';
	EndUpdate();
end
68:
How do change the way the negative/positive numbers show when using conditional-format

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	with FormatConditionalAppearances.Item['negative'] do
	begin
		BackColor := $0;
		ForeColor := $808080;
		FontSize := 8;
	end;
	with FormatConditionalAppearances.Item['positive'] do
	begin
		BackColor := $0;
		ForeColor := $1;
		FontSize := 11;
	end;
	PivotRows := '0';
	PivotColumns := 'sum(5)[negative,positive,content=numeric]';
	EndUpdate();
end
67:
How do I highlight the negative values with white color or black

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	with FormatConditionalAppearances.Item['negative'] do
	begin
		BackColor := $1;
		ForeColor := $ffffff;
	end;
	PivotRows := '0';
	PivotColumns := 'sum(5)[negative,content=numeric]';
	EndUpdate();
end
66:
Does your control support conditional-format, so I can highlight certain values

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	PivotColumns := 'sum(5)[negative,content=numeric]';
	EndUpdate();
end
65:
How do I add a computed column/field, like VAT for instance (method 2)

with Pivot1 do
begin
	BeginUpdate();
	with Aggregates do
	begin
		Add('vat19','sum','VAT 19%','VAT 19%').FormatValue := 'value * 0.19';
		Add('vat24','sum','VAT 24%','VAT 24%').FormatValue := 'value * 0.24';
	end;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	PivotColumns := 'sum(5)[content=numeric],vat19(5)[bold,content=numeric],vat24(5)[bold,content=numeric]';
	EndUpdate();
end
64:
How do I add a computed column/field, like VAT for instance (method 1)

with Pivot1 do
begin
	BeginUpdate();
	with FormatContents.Add('vat19','VAT 19%',Null) do
	begin
		Expression := 'len(value) ? ((value * 1.19) format '''') : ''''';
	end;
	with FormatContents.Add('vat24','VAT 24%',Null) do
	begin
		Expression := 'len(value) ? ((value * 1.24) format '''') : ''''';
	end;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	PivotColumns := 'sum(5)[content=numeric],sum(5)[bold,content=vat19],sum(5)[bold,content=vat24]';
	EndUpdate();
end
63:
How can I hide some values for instance negative values

with Pivot1 do
begin
	BeginUpdate();
	with FormatContents.Add('hiden','hide negative',Null) do
	begin
		Expression := 'value < 0 ? `` : value';
	end;
	with FormatContents.Add('hidep','hide positive',Null) do
	begin
		Expression := 'value > 0 ? `` : value';
	end;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	PivotColumns := 'sum(5)[bold],sum(5)[content=hiden],sum(5)[content=hidep]';
	EndUpdate();
end
62:
How can I decode the Layout property

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	PivotColumns := 'sum(5)/12';
	Layout := 'Columns =1;C0.Width = 64';
	with (IUnknown(ComObj.CreateComObject(ComObj.ProgIDToClassID('Exontrol.Print'))) as EXPRINTLib_TLB.Print) do
	begin
		OutputDebugString( Decode64TextW[Pivot1.Layout] );
	end;
	EndUpdate();
end
61:
How can I specify the sorting type, so the column gets sorted as numeric for instance

with Pivot1 do
begin
	Import('1,1#11,11#101,101','eor=''#'' eof='','' hdr=0');
	with DataColumns.Item[OleVariant(0)] do
	begin
		Caption := 'Numeric';
		SortType := EXPIVOTLib_TLB.SortNumeric;
	end;
	DataColumns.Item[OleVariant(1)].Caption := 'String (default)';
	PivotRows := '0';
	Refresh();
end
60:
How can I disable the control's context menu
with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	PivotBarVisible := Integer(EXPIVOTLib_TLB.exPivotBarAllowResizeColumns) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowUndoRedo) Or Integer(EXPIVOTLib_TLB.exPivotBarAutoUpdate) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowValues) Or Integer(EXPIVOTLib_TLB.exPivotBarShowTotals) Or Integer(EXPIVOTLib_TLB.exPivotBarAutoFit) Or Integer(EXPIVOTLib_TLB.exPivotBarSizable) Or Integer(EXPIVOTLib_TLB.exPivotBarVisible);
end
59:
How do I get the captions of the columns
with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	OutputDebugString( DataColumns.Count );
	OutputDebugString( DataColumns.Item[OleVariant(0)].PivotCaption );
	OutputDebugString( DataColumns.Item[OleVariant(0)].Caption );
	OutputDebugString( DataColumns.Item[OleVariant(1)].PivotCaption );
	OutputDebugString( DataColumns.Item[OleVariant(1)].Caption );
end
58:
How can I specify the default-format for a specified column, so it always shows as numeric for instance
with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	with DataColumns.Item['Freight'] do
	begin
		DefaultFormatContent := 'numeric';
		DefaultFormatAppearances := 'bold';
		SortOrder := EXPIVOTLib_TLB.SortAscending;
		SortType := EXPIVOTLib_TLB.SortNumeric;
	end;
	PivotTotalDefaultFormatContent := 'currency';
	PivotTotalDefaultFormatAppearances := 'strikeout,bold';
	PivotRows := '0';
	PivotColumns := 'sum(5)[bold,content=numeric]';
	PivotTotals := 'sum[strikeout,bold,content=currency]';
	PivotColumnsFloatBarVisible := True;
	Refresh();
end
57:
How can I display the percentage column

with Pivot1 do
begin
	FormatContents.Add('percent','value + `%`',Null);
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '5[content=percent]';
	Refresh();
end
56:
How do I change the name for months in the drop-down filter window (localization)

with Pivot1 do
begin
	OutputDebugString( Description[EXPIVOTLib_TLB.exFilterBarDateMonths] );
	Description[EXPIVOTLib_TLB.exFilterBarDateMonths] := 'Ianuarie Februarie Martie Aprilie Mai Iunie Iulie August Septembrie Octombrie Noiembrie Decembrie';
	Description[EXPIVOTLib_TLB.exFilterBarAll] := '(Toate)';
	Description[EXPIVOTLib_TLB.exFilterBarBlanks] := '(Gol)';
	Description[EXPIVOTLib_TLB.exFilterBarNonBlanks] := '(Plin)';
	Description[EXPIVOTLib_TLB.exFilterBarFilterForCaption] := 'Filtreaza:';
	Description[EXPIVOTLib_TLB.exFilterBarDateTodayCaption] := 'Azi';
	Description[EXPIVOTLib_TLB.exFilterBarDateWeekDays] := 'D L Ma Mi J V S';
	Description[EXPIVOTLib_TLB.exFilterBarExclude] := 'Exclud';
	Description[EXPIVOTLib_TLB.exColumnsFloatBar] := 'Coloane';
	Description[EXPIVOTLib_TLB.exFilterBarAnd] := 'si';
	Description[EXPIVOTLib_TLB.exFilterBarDate] := 'Data:';
	Description[EXPIVOTLib_TLB.exFilterBarDateTitle] := 'Data';
	Description[EXPIVOTLib_TLB.exFilterBarDateTo] := 'la';
	Description[EXPIVOTLib_TLB.exFilterBarNot] := 'nu';
	Description[EXPIVOTLib_TLB.exFilterBarOr] := 'sau';
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	DataColumns.Item['OrderDate'].SortType := EXPIVOTLib_TLB.SortDate;
	PivotRows := '9';
	Refresh();
end
55:
How can I scale and print programmatically the pivot table, to fit on one axis eg FitPageHeight but infinite width etc
with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '6';
	PivotColumns := 'sum(5)/3';
	Refresh();
	with (IUnknown(ComObj.CreateComObject(ComObj.ProgIDToClassID('Exontrol.Print'))) as EXPRINTLib_TLB.Print) do
	begin
		Options := 'FitToPage = x 5';
		PrintExts := (IUnknown(Pivot1.DefaultInterface) as EXPIVOTLib_TLB.Pivot);
		Preview();
	end;
end
54:
How can I scale and print programmatically the pivot table, to fit on one axis eg FitPageWidth but infinite height etc
with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '6';
	PivotColumns := 'sum(5)/3';
	Refresh();
	with (IUnknown(ComObj.CreateComObject(ComObj.ProgIDToClassID('Exontrol.Print'))) as EXPRINTLib_TLB.Print) do
	begin
		Options := 'FitToPage = 5 x';
		PrintExts := (IUnknown(Pivot1.DefaultInterface) as EXPIVOTLib_TLB.Pivot);
		Preview();
	end;
end
53:
How can I get the column from the cursor
// MouseMove event - Occurs when the user moves the mouse.
procedure TForm1.Pivot1MouseMove(ASender: TObject; Button : Smallint;Shift : Smallint;X : Integer;Y : Integer);
begin
	with Pivot1 do
	begin
		OutputDebugString( ColumnFromPoint[-1,-1] );
	end
end;

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	Refresh();
end
52:
How can I get the value from the cursor
// MouseMove event - Occurs when the user moves the mouse.
procedure TForm1.Pivot1MouseMove(ASender: TObject; Button : Smallint;Shift : Smallint;X : Integer;Y : Integer);
begin
	with Pivot1 do
	begin
		OutputDebugString( ValueFromPoint[-1,-1] );
	end
end;

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	Refresh();
end
51:
How can I specify a column to display HTML format

with Pivot1 do
begin
	Import('Bold <b>1,Bold <b>2#Bold <b>3,Bold <b>4#Bold <b>5,Bold <b>6','eor=''#'' eof='','' hdr=0');
	DataColumns.Item[OleVariant(0)].HTML := True;
	DataColumns.Item[OleVariant(1)].HTML := True;
	PivotRows := '0';
	Refresh();
end
50:
Does your control supports scrolling by touching the screen

with Pivot1 do
begin
	rs := (IUnknown(ComObj.CreateComObject(ComObj.ProgIDToClassID('ADOR.Recordset'))) as ADODB_TLB.Recordset);
	with rs do
	begin
		Open('Data','Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExPivot\Sample\Access2007\sample.accdb',3,3,Null);
	end;
	DataSource := (IUnknown(rs) as ADODB_TLB.Recordset);
	AutoDrag := Integer(EXPIVOTLib_TLB.exAutoDragScrollOnShortTouch) Or Integer(EXPIVOTLib_TLB.exAutoDragScroll);
end
49:
How can I specify programatically the width of the pivot column ( first column )

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	PivotColumns := 'sum(5)/12';
	Layout := 'Columns =1;C0.Width = 64';
	EndUpdate();
end
48:
How can I show the total of each row, when columns are shown as expanded

with Pivot1 do
begin
	BeginUpdate();
	IncludeExpandColumn := EXPIVOTLib_TLB.exIncludeExpandColumn;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	PivotColumns := 'sum(5)/12';
	EndUpdate();
end
47:
How can I prevent grouping by a specified column
with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	DataColumns.Item['Freight'].AllowGroupBy := EXPIVOTLib_TLB.exGroupByNone;
end
46:
How can I sort alphabetically the columns to be displayed in the context menu/floating panel

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotBarVisible := Integer(EXPIVOTLib_TLB.exPivotBarContextSortAscending) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowResizeColumns) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowUndoRedo) Or Integer(EXPIVOTLib_TLB.exPivotBarAutoUpdate) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowFormatContent) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowFormatAppearance) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowValues) Or Integer(EXPIVOTLib_TLB.exPivotBarShowTotals) Or Integer(EXPIVOTLib_TLB.exPivotBarAutoFit) Or Integer(EXPIVOTLib_TLB.exPivotBarSizable) Or Integer(EXPIVOTLib_TLB.exPivotBarVisible);
	PivotColumnsSortOrder := EXPIVOTLib_TLB.exPivotColumnsAscending;
	PivotColumnsFloatBarVisible := True;
end
45:
How can I prevent dropping data to the control
with Pivot1 do
begin
	AllowDrop := False;
end
44:
Is it possible to allow incremental filtering on drop down filter window too, as I can on the control menus

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	DisplayFilterList := Integer(EXPIVOTLib_TLB.exHideFilterPattern) Or Integer(EXPIVOTLib_TLB.exFilterListDefault);
end
43:
How can I prevent showing the Filter For field in the drop down filter window

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	DisplayFilterList := Integer(EXPIVOTLib_TLB.exHideFilterPattern) Or Integer(EXPIVOTLib_TLB.exFilterListDefault);
end
42:
How can I display the numeric columns only when selecting a new aggregate, like SUM

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0[bold]';
	PivotColumns := 'sum(5)/12,count(5)/12';
	DataColumns.Item['Freight'].SortType := EXPIVOTLib_TLB.SortNumeric;
end
41:
How can I add a value column

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	PivotColumns := 'sum(5)/12';
end
40:
I would like to always have the subtotals in the same row of the "father row". Could that be done

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0[bold],2';
	PivotColumns := 'sum(5)/12,count(5)/12';
	ShowViewCompact := Integer(EXPIVOTLib_TLB.exViewCompactAggregates) Or Integer(EXPIVOTLib_TLB.exViewCompact);
	PivotTotals := '/sum,sum(0)';
end
39:
Is there any way, when I change the filter of the column, it broadcast the filter to the other pivot columns that were duplicated

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0,2';
	ShowBranchRows := EXPIVOTLib_TLB.exBranchCompact;
	PivotColumns := 'sum(5)/12[filter=''gBpNxjNh1MhlBoKNhpOZ0hJVNxpOhlMggKBhMZrMJnMoAgI=''],count(5)/12[filter=''gBpNxjNh1MhlBoKNhpOZ0hJVNxpOhlMggKBhMZr' + 
	'MJnMoAgI='']';
	ShowViewCompact := Integer(EXPIVOTLib_TLB.exViewCompactKeepSettings) Or Integer(EXPIVOTLib_TLB.exViewCompact);
end
38:
How can I summarize more fields in the same cell

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0,2';
	ShowBranchRows := EXPIVOTLib_TLB.exBranchCompact;
	PivotColumns := 'sum(5)/12,count(5)/12';
	ShowViewCompact := EXPIVOTLib_TLB.exViewCompact;
end
37:
How do I programmatically group by rows, in a compact way, no hierarchy lines

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0,2';
	ShowBranchRows := EXPIVOTLib_TLB.exBranchCompact;
end
36:
How do I programmatically group by rows

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0,1,2';
	LinesAtRoot := EXPIVOTLib_TLB.exLinesAtRoot;
	HasLines := EXPIVOTLib_TLB.exSolidLine;
end
35:
How do I programmatically group by columns

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	PivotColumns := 'sum(5)/12;6';
end
34:
How can I hide the add new button on the pivot bar

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotBarVisible := Integer(EXPIVOTLib_TLB.exPivotBarHideAddNew) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowResizeColumns) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowUndoRedo) Or Integer(EXPIVOTLib_TLB.exPivotBarAutoUpdate) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowFormatContent) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowFormatAppearance) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowValues) Or Integer(EXPIVOTLib_TLB.exPivotBarShowTotals) Or Integer(EXPIVOTLib_TLB.exPivotBarAutoFit) Or Integer(EXPIVOTLib_TLB.exPivotBarSizable) Or Integer(EXPIVOTLib_TLB.exPivotBarVisible);
end
33:
Is it possible to show the data that generated the result, when double clicking the row

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0[italic]';
	PivotColumns := 'count(0)[underline]';
	PivotTotals := 'count[bold,strikeout]';
	ShowDataOnDblClick := True;
	EndUpdate();
end
32:
Does your control support subscript or superscript, in HTML captions

with Pivot1 do
begin
	HeaderHeight := 22;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	DataColumns.Item['ShipCountry'].Caption := 'ShipCountry<font ;7><off 6><sha ;;0>subscript';
	DataColumns.Item['ShipRegion'].Caption := 'ShipRegion<font ;7><off -6><sha ;;0>superscript';
	Refresh();
end
31:
Is it possible to define a different background color for the pivot bar

with Pivot1 do
begin
	Background[EXPIVOTLib_TLB.exPivotBarBackColor] := $f0f0f0;
end
30:
How can I display an icon/image to Content sub-menu

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	Images('gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTql' + 
	'Vq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0' + 
	'ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yN' + 
	'AOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=');
	FormatContents.Item['numeric'].Name := '<img>1</img> Numeric';
	PivotRows := '5[content=numeric]';
end
29:
How can I change the selection background in the control's context menu

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	Background[EXPIVOTLib_TLB.exSelBackColorFilter] := $ff;
end
28:
How can I display the column as date in a long format

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FormatContents.Add('longdate','longdate(date(value))',Null);
	PivotRows := '9[content=longdate]';
end
27:
Is it possible to display the column in upper-case

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FormatContents.Add('upper','upper(value)',Null);
	PivotRows := '0[content=upper]';
end
26:
How can I programatically bold a column

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0[bold]';
end
25:
How can I display the total with a different foreground color

with Pivot1 do
begin
	FormatAppearances.Add('fore',Null).ForeColor := $ff;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	PivotColumns := 'sum(5)';
	PivotTotals := 'sum[fore,bold]';
end
24:
How can I display the total with a different background color/ebn

with Pivot1 do
begin
	VisualAppearance.Add(1,'c:\exontrol\images\normal.ebn');
	FormatAppearances.Add('back',Null).BackColor := $1000000;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	PivotColumns := 'sum(5)';
	PivotTotals := 'sum[back]';
end
23:
How can I display the total with a solid background color

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
22:
Is it possible to change the "bold" caption in the control's context menu

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FormatAppearances.Item['bold'].Name := 'Ingrosat';
end
21:
Is it possible to show no Exclude field in the filter window

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	DisplayFilterList := Integer(EXPIVOTLib_TLB.exShowCheckBox) Or Integer(EXPIVOTLib_TLB.exSortItemsAsc);
end
20:
How can I prevent showing the drop down filter button

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	DisplayFilterList := EXPIVOTLib_TLB.exNoItems;
end
19:
How do I get the count of positive values only

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	Aggregates.Add('positive','sum',Null,Null).FormatValue := 'value < 0 ? 0 : 1';
	PivotRows := '0';
	PivotColumns := 'positive(5)';
end
18:
How do I get the sum for negative values only

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	Aggregates.Add('negative','sum',Null,Null).FormatValue := 'value < 0 ? value : 0';
	PivotRows := '0';
	PivotColumns := 'negative(5)';
end
17:
My data stores the data as strings, is it possible to load the data using Import method

with Pivot1 do
begin
	Import('''string 1'';''string 2''#''string 3'';''string 4''','str=`''` eor=''#'' eof='';'' hdr=0');
end
16:
Is it possible to load data using different separators

with Pivot1 do
begin
	Import('item 1;item 2#item 3;item 4','eor=''#'' eof='';'' hdr=0');
end
15:
Is it possible to align a column

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	with DataColumns.Item[OleVariant(0)] do
	begin
		Alignment := EXPIVOTLib_TLB.RightAlignment;
		HeaderAlignment := EXPIVOTLib_TLB.RightAlignment;
	end;
	Refresh();
end
14:
How can I change by code the column/rows background color

with Pivot1 do
begin
	BeginUpdate();
	VisualAppearance.Add(1,'c:\exontrol\images\normal.ebn');
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FormatAppearances.Add('aka',Null).BackColor := $1000000;
	PivotRows := '0[aka]';
	EndUpdate();
end
13:
How can I apply by code any appearance to my list

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0[italic]';
	PivotColumns := 'count(0)[underline]';
	PivotTotals := 'count[bold,strikeout]';
	EndUpdate();
end
12:
How can I display an icon instead SUM/Total field

with Pivot1 do
begin
	BeginUpdate();
	Images('gBJJgBggAAwAAgACEKAD/hz/EMNh8TIRNGwAjEZAEXjAojJAjIgjIBAEijUlk8plUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTql' + 
	'Vq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9oEEwGBwWDwmFw2Hw9+xUsxGNx2Px+LyUnyGVy2VyeZAGNjIJjITjIb0OjjGi0ukAAVj' + 
	'ILzmayWtAGejCvjLh2u3jG23O4ACx1ew11+zEYGsZZsZUe/wkZ4sYZvD4PCy8kjAzjLFjKd5WDjIz6HRvnTwUZGMZX8ZTPb8XU8Hh9cFjALjKVjK5jIv9/w9t78WdjJI' + 
	'oyWr7sKjIWu+/a8Og2QAEajLaIxAzlwhB0DwQuzoECjJWw1DiMQ3D0OgAQMKwsuj8xOy0SrzFEWMdFUExbGMCRfC8ZRswMaLsiofJVHiOo+kKRs2lL2Jsh8cyQo6Ag==' + 
	'');
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	with Aggregates.Item['sum'] do
	begin
		Name := '<img>1</img> Sum';
		Caption := '<img>1</img>';
	end;
	PivotColumnsFloatBarVisible := True;
	FormatPivotHeader := 'iaggregate ? (caggregate + (iaggregate != 5 ? '' '' : '''') + caption) : caption';
	FormatPivotTotal := 'caggregate';
	PivotRows := '0';
	PivotColumns := 'sum(5)';
	PivotTotals := 'sum,count';
	EndUpdate();
end
11:
How can I change the caption to be displayed when dragging an aggregate function

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotColumnsFloatBarVisible := True;
	FormatPivotHeader := '(iaggregate ? (''<b>'' + upper(caggregate) + ''</b> of '' + caption) : caption)';
	PivotRows := '0';
	PivotColumns := 'sum(5)';
	PivotTotals := 'sum,count';
	EndUpdate();
end
10:
I am using Import method, just wondering if I can rename the columns

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	with DataColumns.Item[OleVariant(0)] do
	begin
		Caption := 'New Caption';
		PivotCaption := 'New Pivot Caption';
	end;
	Refresh();
end
9:
Does your control support Fit-To-Page Print and Print Preview

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0,1,2';
	ExpandAll();
	with (IUnknown(ComObj.CreateComObject(ComObj.ProgIDToClassID('Exontrol.Print'))) as EXPRINTLib_TLB.Print) do
	begin
		Options := 'FitToPage = On';
		PrintExts := (IUnknown(Pivot1.DefaultInterface) as EXPIVOTLib_TLB.Pivot);
		Preview();
	end;
end
8:
How can I print the control

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0,1,2';
	ExpandAll();
	with (IUnknown(ComObj.CreateComObject(ComObj.ProgIDToClassID('Exontrol.Print'))) as EXPRINTLib_TLB.Print) do
	begin
		PrintExts := (IUnknown(Pivot1.DefaultInterface) as EXPIVOTLib_TLB.Pivot);
		Preview();
	end;
end
7:
How can I hide the pivot bar (hide completly)

with Pivot1 do
begin
	PivotBarVisible := Integer(EXPIVOTLib_TLB.exPivotBarAllowResizeColumns) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowUndoRedo) Or Integer(EXPIVOTLib_TLB.exPivotBarAutoUpdate) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowFormatContent) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowFormatAppearance) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowValues) Or Integer(EXPIVOTLib_TLB.exPivotBarShowTotals) Or Integer(EXPIVOTLib_TLB.exPivotBarAutoFit) Or Integer(EXPIVOTLib_TLB.exPivotBarSizable);
end
6:
How can I hide the pivot bar (auto-hide)

with Pivot1 do
begin
	PivotBarVisible := Integer(EXPIVOTLib_TLB.exPivotBarAllowResizeColumns) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowUndoRedo) Or Integer(EXPIVOTLib_TLB.exPivotBarAutoUpdate) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowFormatContent) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowFormatAppearance) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowValues) Or Integer(EXPIVOTLib_TLB.exPivotBarAutoHide) Or Integer(EXPIVOTLib_TLB.exPivotBarShowTotals) Or Integer(EXPIVOTLib_TLB.exPivotBarSizable) Or Integer(EXPIVOTLib_TLB.exPivotBarVisible);
end
5:
How can I count and get the total of a specified column

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotColumnsFloatBarVisible := True;
	PivotRows := '0';
	PivotColumns := 'sum(5)';
	PivotTotals := 'sum,count';
	EndUpdate();
end
4:
How can I add show the columns once I grouped a column

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	PivotColumnsFloatBarVisible := True;
end
3:
How can I programatically group the columns

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0:D';
end
2:
Is it possible to load data from a data source

with Pivot1 do
begin
	rs := (IUnknown(ComObj.CreateComObject(ComObj.ProgIDToClassID('ADOR.Recordset'))) as ADODB_TLB.Recordset);
	with rs do
	begin
		Open('Data','Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExPivot\Sample\Access2007\sample.accdb',3,3,Null);
	end;
	DataSource := (IUnknown(rs) as ADODB_TLB.Recordset);
end
1:
How can I load data

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
end