|
185
|
Disable chart stacking
// ViewChange event - Occurs when the control's view is changed, such as when data is updated, summarized, sorted, or filtered.
procedure TForm1.Pivot1ViewChange(ASender: TObject; );
begin
with Pivot1 do
begin
(IUnknown(CustomView.Object) as EXGRAPHLib_TLB.Graph).AllowStack := False;
end
end;
with Pivot1 do
begin
BeginUpdate();
HeaderHeight := 24;
HeaderAppearance := EXPIVOTLib_TLB.Etched;
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
PivotColumnsFloatBarVisible := EXPIVOTLib_TLB.exPanelVisible;
PivotRows := '0';
PivotColumns := 'sum(5)/12';
ShowBranchRows := EXPIVOTLib_TLB.exBranchColumns;
PivotBarVisible := Integer(EXPIVOTLib_TLB.exPivotBarSingleAggregate) Or Integer(EXPIVOTLib_TLB.exPivotBarDefault);
CustomView.ControlID := 'exontrol.graph';
EndUpdate();
end
|
|
184
|
Can the vertical/horizontal line be hidden when the cursor hovers over the graph chart
with Pivot1 do
begin
BeginUpdate();
HeaderHeight := 24;
HeaderAppearance := EXPIVOTLib_TLB.Etched;
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
PivotColumnsFloatBarVisible := EXPIVOTLib_TLB.exPanelVisible;
PivotRows := '0';
PivotColumns := 'sum(5)/12';
ShowBranchRows := EXPIVOTLib_TLB.exBranchColumns;
PivotBarVisible := Integer(EXPIVOTLib_TLB.exPivotBarSingleAggregate) Or Integer(EXPIVOTLib_TLB.exPivotBarDefault);
with CustomView do
begin
License := 'XXXXXXXX';
ControlID := 'exontrol.graph';
(IUnknown(Object) as EXGRAPHLib_TLB.Graph).Cursor.Visible := False;
end;
EndUpdate();
end
|
|
183
|
Define the column caption and row title when the PivotRows property is empty
with Pivot1 do
begin
BeginUpdate();
HeaderHeight := 24;
HeaderAppearance := EXPIVOTLib_TLB.Etched;
Description[EXPIVOTLib_TLB.exColumnEmptyPivotRows] := '<c>\';
Description[EXPIVOTLib_TLB.exRowEmptyPivotRows] := 'Total';
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
PivotColumnsFloatBarVisible := EXPIVOTLib_TLB.exPanelAsChild;
PivotColumns := 'sum(5)[content=numeric]';
ShowBranchRows := EXPIVOTLib_TLB.exBranchColumns;
DrawGridLines := EXPIVOTLib_TLB.exRowLines;
GridLineStyle := EXPIVOTLib_TLB.exGridLinesSolid;
EndUpdate();
end
|
|
182
|
Change the background color of the splitbars
with Pivot1 do
begin
BeginUpdate();
Background[EXPIVOTLib_TLB.exHSplitBar] := $f0f0f0;
Background[EXPIVOTLib_TLB.exCSplitBar] := $f0f0f0;
HeaderHeight := 24;
HeaderAppearance := EXPIVOTLib_TLB.Etched;
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
PivotColumnsFloatBarVisible := EXPIVOTLib_TLB.exPanelAsChild;
PivotRows := '0';
PivotColumns := 'sum(5)/12';
ShowBranchRows := EXPIVOTLib_TLB.exBranchColumns;
PivotBarVisible := Integer(EXPIVOTLib_TLB.exPivotBarSingleAggregate) Or Integer(EXPIVOTLib_TLB.exPivotBarDefault);
DrawGridLines := EXPIVOTLib_TLB.exVLines;
EndUpdate();
end
|
|
181
|
Occurs when the control's view is changed, such as when data is updated, summarized, sorted, or filtered
// ViewChange event - Occurs when the control's view is changed, such as when data is updated, summarized, sorted, or filtered.
procedure TForm1.Pivot1ViewChange(ASender: TObject; );
begin
with Pivot1 do
begin
OutputDebugString( CustomView.Columns );
end
end;
with Pivot1 do
begin
HeaderHeight := 24;
HeaderAppearance := EXPIVOTLib_TLB.Etched;
GridLineStyle := EXPIVOTLib_TLB.exGridLinesGeometric;
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
PivotColumns := 'sum(5)/12';
end
|
|
180
|
Retrieves the data information about the current view, such as columns, data, ...
// ViewChange event - Occurs when the control's view is changed, such as when data is updated, summarized, sorted, or filtered.
procedure TForm1.Pivot1ViewChange(ASender: TObject; );
begin
with Pivot1 do
begin
with CustomView do
begin
OutputDebugString( 'Columns' );
OutputDebugString( Columns );
OutputDebugString( 'Items' );
OutputDebugString( Items );
OutputDebugString( 'Categories' );
OutputDebugString( Categories );
OutputDebugString( 'Series' );
OutputDebugString( Series );
OutputDebugString( 'Data' );
OutputDebugString( Data );
end;
end
end;
with Pivot1 do
begin
BeginUpdate();
HeaderHeight := 24;
HeaderAppearance := EXPIVOTLib_TLB.Etched;
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
PivotColumnsFloatBarVisible := EXPIVOTLib_TLB.exPanelVisible;
PivotRows := '0';
PivotColumns := 'sum(5)';
ShowBranchRows := EXPIVOTLib_TLB.exBranchColumns;
PivotBarVisible := Integer(EXPIVOTLib_TLB.exPivotBarSingleAggregate) Or Integer(EXPIVOTLib_TLB.exPivotBarDefault);
var_CustomView := CustomView;
EndUpdate();
end
|
|
179
|
Access the custom-view
with Pivot1 do
begin
BeginUpdate();
HeaderHeight := 24;
HeaderAppearance := EXPIVOTLib_TLB.Etched;
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
PivotColumnsFloatBarVisible := EXPIVOTLib_TLB.exPanelVisible;
PivotRows := '0';
PivotColumns := 'sum(5)';
ShowBranchRows := EXPIVOTLib_TLB.exBranchColumns;
PivotBarVisible := Integer(EXPIVOTLib_TLB.exPivotBarSingleAggregate) Or Integer(EXPIVOTLib_TLB.exPivotBarDefault);
with CustomView do
begin
ControlID := 'exontrol.graph';
(IUnknown(Object) as EXGRAPHLib_TLB.Graph).ForeColor := $808080;
end;
EndUpdate();
end
|
|
178
|
Switch between custom view and table mode
// OleEvent event - Occurs whenever the custom view fires an event.
procedure TForm1.Pivot1OleEvent(ASender: TObject; Ev : IOleEvent);
begin
with Pivot1 do
begin
CustomView.Visible := False;
end
end;
with Pivot1 do
begin
BeginUpdate();
HeaderHeight := 24;
HeaderAppearance := EXPIVOTLib_TLB.Etched;
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
PivotColumnsFloatBarVisible := EXPIVOTLib_TLB.exPanelVisible;
PivotRows := '0';
PivotColumns := 'sum(5)';
ShowBranchRows := EXPIVOTLib_TLB.exBranchColumns;
PivotBarVisible := Integer(EXPIVOTLib_TLB.exPivotBarSingleAggregate) Or Integer(EXPIVOTLib_TLB.exPivotBarDefault);
CustomView.ControlID := 'exontrol.graph';
EndUpdate();
end
|
|
177
|
'exontrol.graph' component creation failed
with Pivot1 do
begin
BeginUpdate();
HeaderHeight := 24;
HeaderAppearance := EXPIVOTLib_TLB.Etched;
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
PivotColumnsFloatBarVisible := EXPIVOTLib_TLB.exPanelVisible;
PivotRows := '0';
PivotColumns := 'sum(5)/12';
ShowBranchRows := EXPIVOTLib_TLB.exBranchColumns;
PivotBarVisible := Integer(EXPIVOTLib_TLB.exPivotBarSingleAggregate) Or Integer(EXPIVOTLib_TLB.exPivotBarDefault);
with CustomView do
begin
License := 'XXXXXXXX';
ControlID := 'exontrol.graph';
end;
EndUpdate();
end
|
|
176
|
How can I change the graphical/chart representation of my data
with Pivot1 do
begin
BeginUpdate();
HeaderHeight := 24;
HeaderAppearance := EXPIVOTLib_TLB.Etched;
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
PivotColumnsFloatBarVisible := EXPIVOTLib_TLB.exPanelVisible;
PivotRows := '0';
PivotColumns := 'sum(5)/12';
ShowBranchRows := EXPIVOTLib_TLB.exBranchColumns;
PivotBarVisible := Integer(EXPIVOTLib_TLB.exPivotBarSingleAggregate) Or Integer(EXPIVOTLib_TLB.exPivotBarDefault);
with CustomView do
begin
ControlID := 'exontrol.graph';
(IUnknown(Object) as EXGRAPHLib_TLB.Graph).SerieType := 'line';
end;
EndUpdate();
end
|
|
175
|
Organizes the layout into distinct sections: one for pivot rows, one for pivot columns, and a separate area for defining aggregates
with Pivot1 do
begin
BeginUpdate();
HeaderHeight := 24;
HeaderAppearance := EXPIVOTLib_TLB.Etched;
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
PivotColumnsFloatBarVisible := EXPIVOTLib_TLB.exPanelAsChild;
ShowBranchRows := EXPIVOTLib_TLB.exBranchColumns;
PivotRows := '0';
PivotBarVisible := Integer(EXPIVOTLib_TLB.exPivotBarSingleAggregate) Or Integer(EXPIVOTLib_TLB.exPivotBarDefault);
ShowDataOnDblClick := True;
EndUpdate();
end
|
|
174
|
How can I provide a graphical/chart representation of my data
with Pivot1 do
begin
BeginUpdate();
HeaderHeight := 24;
HeaderAppearance := EXPIVOTLib_TLB.Etched;
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
PivotColumnsFloatBarVisible := EXPIVOTLib_TLB.exPanelAsChild;
PivotRows := '0';
PivotColumns := 'sum(5)';
CustomView.ControlID := 'exontrol.graph';
EndUpdate();
end
|
|
173
|
Rename the Total caption
with Pivot1 do
begin
BeginUpdate();
HeaderHeight := 24;
HeaderAppearance := EXPIVOTLib_TLB.Etched;
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
PivotRows := '0';
PivotColumns := 'sum(5)';
PivotTotals := '/sum[bold]';
PivotColumnsFloatBarVisible := EXPIVOTLib_TLB.exPanelAsChild;
FormatPivotTotal := '( iaggregate = 5 ? (ilevel = 0 ? ''Overall amount'' : ''Sectional sum'') : caggregate )';
EndUpdate();
end
|
|
172
|
Specify the size of the Columns panel
with Pivot1 do
begin
BeginUpdate();
HeaderHeight := 24;
HeaderAppearance := EXPIVOTLib_TLB.Etched;
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
PivotRows := '0';
PivotColumns := 'sum(5)';
PivotColumnsFloatBarRect := ',,96';
PivotColumnsFloatBarVisible := EXPIVOTLib_TLB.exPanelAsChild;
EndUpdate();
end
|
|
171
|
Show a vertical line between pivot and Columns panel (EBN color)
with Pivot1 do
begin
BeginUpdate();
VisualAppearance.Add(1,'gBFLBCJwBAEHhEJAAEhABRsIQAAYAQGKIYBkAKBQAGaAoDDUNQxQwAAxwfBMKgBBCLIxhEYobgmGIXRpFICQTIcBhaGIZRiAKCRTDmHwyRCNIwCLD8QxtDqBY4gOZZXh' +
'al4cJTgMaBYi+Pw3DZHcbvBRkewzHQAKgnSjoDhEMg1CTVVYTDKdOSzDyEX7sIAACpOIZQVJVEY1VT8cyxIyEZimSypWqiYJ0Ty6cQwTAIgI');
Background[EXPIVOTLib_TLB.exColumnsFloatBackColor] := $1000000;
HeaderHeight := 24;
HeaderAppearance := EXPIVOTLib_TLB.Etched;
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
PivotRows := '0';
PivotColumns := 'sum(5)';
PivotColumnsFloatBarVisible := EXPIVOTLib_TLB.exPanelAsChild;
EndUpdate();
end
|
|
170
|
Change the background of the Columns panel (EBN color)
with Pivot1 do
begin
BeginUpdate();
VisualAppearance.Add(1,'gBFLBCJwBAEHhEJAAEhABNoCg6AADACAxRDAMgBQKAAzQFAYahqGKGAAGOD4JhUAIIRZGMIjFDcEwxC6NIpAWLoJDCH4mSTHYxgJIMWwzDiBZgkCA4fiGEYnThCIxzTJ' +
'0aw1CKbYRAKCUKoUAJFsSnQAJIgOO4lULPMIhDDQKQTIKBahoehqIhaEQyDSJNb2DCIahhMSEbKtCooDhGFZUWzLVxTJJNawHJqJJDuOTpSjKH4+RjWFKUXR9b4BJSNA' +
'gqeCQTiSWZEVxRUS0XbGCyZLSQY7uAAMKgOVoDYzdGLwHTtOwrMa1QAsDSbKqWZ5uRpHcQ5aAGN5DPbMbqwOaqLznAaLQLtG4RTikVRPTDYaj437+OaHGyNbI6HTNPpT' +
'lWDJWjYXI8l8C4fg6GYAAEEISgGJJGHQOocgyIwYnqKhYAAIQTH2MYRjQJBRAmZptmEAYIjGU5dk8UgOFgBJUgCTQIBYBoBmCCAmAqApghgDJUDmYQFCCZoEk2OBUm+B' +
'ZPCgZgagaYZIHYHoHmGWBcm8NwiEiFJVgmYgji4Kg6GKSI2C6C5jAiRgygwIojiycINkyeJmAYPJjkiTg+g+ZAIkCdIQkyWQWDuDxkBkJhKguZAzlIRQzGQc5ODWFJlE' +
'kVhWhWZYJFYTYTmUE4yF6F5mAmBhihiZhJhYX4WmQaAUnWGpOlmNhuhuZwJkYcocmcSY4naHZlkmKhrDuJ5JnYfofmgCgGgKIJnlmXJ2h4TQKBosRokoNoOiOaQKDSd4' +
'kmiChMncPBpgoZoaiaaZKHaHonmmE5iiKJRpDicomimaoKiaKoqmqSoeiIPgogqPotiyaxKlYPA+GuCqbBMa5KnaPovmwCwGj6LgP24RIhiyCwmkqMpsksNpKD6LQLBq' +
'OIzi0SxWlaHZtAOahPssM5Wi+IYtlsXpijKbZ5lyTo5mAE4UlqOpjHOQpEjubyanKPJvEuNgVj2TY1CCao+k2G52AyP5wAwBp9DYZZ1CCaxsAABAEICA');
Background[EXPIVOTLib_TLB.exColumnsFloatBackColor] := $1000000;
HeaderHeight := 24;
HeaderAppearance := EXPIVOTLib_TLB.Etched;
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
PivotRows := '0';
PivotColumns := 'sum(5)';
PivotColumnsFloatBarVisible := EXPIVOTLib_TLB.exPanelAsChild;
EndUpdate();
end
|
|
169
|
Change the background of the Columns panel (solid color)
with Pivot1 do
begin
BeginUpdate();
HeaderHeight := 24;
HeaderAppearance := EXPIVOTLib_TLB.Etched;
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
PivotRows := '0';
PivotColumns := 'sum(5)';
PivotColumnsFloatBarVisible := EXPIVOTLib_TLB.exPanelAsChild;
Background[EXPIVOTLib_TLB.exColumnsFloatBackColor] := $f0f0f0;
EndUpdate();
end
|
|
168
|
Change the visual appearance of the Columns panel
with Pivot1 do
begin
BeginUpdate();
VisualAppearance.Add(1,'gBFLBCJwBAEHhEJAAEhABNoCg6AADACAxRDAMgBQKAAzQFAYahqGKGAAGOD4JhUAIIRZGMIjFDcEwxC6NIpAWLoJDCH4mSTHYxgJIMWwzDiBZgkCA4fiGEYnThCIxzTJ' +
'0aw1CKbYRAKCUKoUAJFsSnQAJIgOO4lULPMIhDDQKQTIKBahoehqIhaEQyDSJNb2DCIahhMSEbKtCooDhGFZUWzLVxTJJNawHJqJJDuOTpSjKH4+RjWFKUXR9b4BJSNA' +
'gqeCQTiSWZEVxRUS0XbGCyZLSQY7uAAMKgOVoDYzdGLwHTtOwrMa1QAsDSbKqWZ5uRpHcQ5aAGN5DPbMbqwOaqLznAaLQLtG4RTikVRPTDYaj437+OaHGyNbI6HTNPpT' +
'lWDJWjYXI8l8C4fg6GYAAEEISgGJJGHQOocgyIwYnqKhYAAIQTH2MYRjQJBRAmZptmEAYIjGU5dk8UgOFgBJUgCTQIBYBoBmCCAmAqApghgDJUDmYQFCCZoEk2OBUm+B' +
'ZPCgZgagaYZIHYHoHmGWBcm8NwiEiFJVgmYgji4Kg6GKSI2C6C5jAiRgygwIojiycINkyeJmAYPJjkiTg+g+ZAIkCdIQkyWQWDuDxkBkJhKguZAzlIRQzGQc5ODWFJlE' +
'kVhWhWZYJFYTYTmUE4yF6F5mAmBhihiZhJhYX4WmQaAUnWGpOlmNhuhuZwJkYcocmcSY4naHZlkmKhrDuJ5JnYfofmgCgGgKIJnlmXJ2h4TQKBosRokoNoOiOaQKDSd4' +
'kmiChMncPBpgoZoaiaaZKHaHonmmE5iiKJRpDicomimaoKiaKoqmqSoeiIPgogqPotiyaxKlYPA+GuCqbBMa5KnaPovmwCwGj6LgP24RIhiyCwmkqMpsksNpKD6LQLBq' +
'OIzi0SxWlaHZtAOahPssM5Wi+IYtlsXpijKbZ5lyTo5mAE4UlqOpjHOQpEjubyanKPJvEuNgVj2TY1CCao+k2G52AyP5wAwBp9DYZZ1CCaxsAABAEICA');
Background[EXPIVOTLib_TLB.exColumnsFloatAppearance] := $1000000;
Background[EXPIVOTLib_TLB.exColumnsFloatCaptionBackColor] := $f6f6f6;
BackColorHeader := $1000000;
HeaderHeight := 24;
HeaderAppearance := EXPIVOTLib_TLB.Etched;
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
PivotRows := '0';
PivotColumns := 'sum(5)';
PivotColumnsFloatBarVisible := EXPIVOTLib_TLB.exPanelVisible;
EndUpdate();
end
|
|
167
|
Display the columns that users can group by or use for aggregate functions (child)
with Pivot1 do
begin
BeginUpdate();
HeaderHeight := 24;
HeaderAppearance := EXPIVOTLib_TLB.Etched;
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
PivotRows := '0';
PivotColumns := 'sum(5)';
PivotColumnsFloatBarVisible := EXPIVOTLib_TLB.exPanelAsChild;
EndUpdate();
end
|
|
166
|
Display the columns that users can group by or use for aggregate functions (float)
with Pivot1 do
begin
BeginUpdate();
HeaderHeight := 24;
HeaderAppearance := EXPIVOTLib_TLB.Etched;
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
PivotRows := '0';
PivotColumns := 'sum(5)';
PivotColumnsFloatBarVisible := EXPIVOTLib_TLB.exPanelVisible;
EndUpdate();
end
|
|
165
|
ShowIdem {string}, specifies the symbol used to indicate repeated captions, offering a clear visual cue for identical entries. This property is effective only when the showBranchRows property is set to exBranchColumns mode
with Pivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
PivotRows := '0[bold],2';
PivotColumns := 'sum(5)[content=currency],sum(5)[content=currency]/12:A';
PivotTotals := '/sum[bold,content=currency]';
ShowBranchRows := EXPIVOTLib_TLB.exBranchColumns;
ShowIdem := '<fgcolor lightgray>〃';
EndUpdate();
end
|
|
164
|
exBranchColumns + exBranchIncludeAggregate + exBranchRowDivider
with Pivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
PivotRows := '0[bold],2';
PivotColumns := 'sum(5)[content=currency],sum(5)[content=currency]/12:A';
PivotTotals := '/sum[bold,content=currency]';
ShowBranchRows := Integer(EXPIVOTLib_TLB.exBranchIncludeAggregate) Or Integer(EXPIVOTLib_TLB.exBranchRowDivider) Or Integer(EXPIVOTLib_TLB.exBranchColumns);
EndUpdate();
end
|
|
163
|
exBranchColumns + exBranchIncludeAggregate
with Pivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
PivotRows := '0[bold],2';
PivotColumns := 'sum(5)[content=currency],sum(5)[content=currency]/12:A';
PivotTotals := '/sum[bold,content=currency]';
ShowBranchRows := Integer(EXPIVOTLib_TLB.exBranchIncludeAggregate) Or Integer(EXPIVOTLib_TLB.exBranchColumns);
EndUpdate();
end
|
|
162
|
exBranchColumns
with Pivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
PivotRows := '0[bold],2';
PivotColumns := 'sum(5)[content=currency],sum(5)[content=currency]/12:A';
PivotTotals := '/sum[bold,content=currency]';
ShowBranchRows := EXPIVOTLib_TLB.exBranchColumns;
EndUpdate();
end
|
|
161
|
Displays a glitch funnel for drop-down filter buttons (empty or active)
with Pivot1 do
begin
BeginUpdate();
with VisualAppearance do
begin
RenderType := -1;
Add(1,'gBFLBCJwBAEHhEJAAEhABa8IQAAYAQGKIYBkAKBQAGaAoDDUNQxQwAAxwfBMKgBBCLIxhEYobgmGIXRpFMbxCKQahLEiTIhGUYJHgmK4tRiAUgxVDkBxrECZYqjcBZOi' +
'wLQ2TxDM7DNKUCBnIoABhGOaYDh+IQNQjUFKwTRFGRxK4EIRKAyTDLQdRyGSMMbjdQpBCbMiMRqhESKRq2UwYRYCFS1NalaztO6BUAvK67YrWez/YBfF+SfwGeqDYReW' +
'APfgWERnQrGMLxbD8KwZAKTRjkGJ4XhuB41TbQMqufL9ByXHKSSDpGjaXjeO5VVjYNAvS69UzXNq3bhtQAOXCMEwCgI=');
Add(2,'CP:1 -2 0 0 0');
end;
HeaderHeight := 28;
Background[EXPIVOTLib_TLB.exHeaderFilterBarButton] := $2000000;
Background[EXPIVOTLib_TLB.exHeaderFilterBarActive] := $2000001;
Background[EXPIVOTLib_TLB.exCursorHoverColumn] := $ffffffff;
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
|
|
160
|
Can I use a control to generate the data and another to import data (sample 2)
with Pivot1 do
begin
with (IUnknown(ComObj.CreateComObject(ComObj.ProgIDToClassID('Exontrol.Pivot'))) as EXPIVOTLib_TLB.Pivot) do
begin
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
PivotRows := '0';
PivotColumns := 'sum(5)[caption=<fgcolor red><b>Total]';
d := Export(Null,Null);
end;
Import(OleVariant(d),Null);
end
|
|
159
|
Can I use a control to generate the data and another to import data (sample 1)
with Pivot1 do
begin
with (IUnknown(ComObj.CreateComObject(ComObj.ProgIDToClassID('Exontrol.Pivot'))) as EXPIVOTLib_TLB.Pivot) do
begin
rs := (IUnknown(ComObj.CreateComObject(ComObj.ProgIDToClassID('ADODB.Recordset'))) as ADODB_TLB.Recordset);
with rs do
begin
with Fields do
begin
Append('Code',8,Null,Null,Null);
Append('Customer',8,Null,Null,Null);
Append('Sales',5,Null,Null,Null);
end;
Open(Null,Null,Null,Null,Null);
AddNew(Null,Null);
Fields.Item['Code'].Value := 'M';
Fields.Item['Customer'].Value := 'Jhon Doe';
Fields.Item['Sales'].Value := OleVariant(1234);
Update(Null,Null);
AddNew(Null,Null);
Fields.Item['Code'].Value := 'M';
Fields.Item['Customer'].Value := 'Jhon Doe';
Fields.Item['Sales'].Value := OleVariant(4567);
Update(Null,Null);
AddNew(Null,Null);
Fields.Item['Code'].Value := 'F';
Fields.Item['Customer'].Value := 'Jane Doe';
Fields.Item['Sales'].Value := OleVariant(9876);
Update(Null,Null);
AddNew(Null,Null);
Fields.Item['Code'].Value := 'F';
Fields.Item['Customer'].Value := 'Jane Doe';
Fields.Item['Sales'].Value := OleVariant(5432);
Update(Null,Null);
end;
DataSource := (IUnknown(rs) as ADODB_TLB.Recordset);
PivotRows := '1';
PivotColumns := 'sum(2)';
d := Export(Null,Null);
end;
Import(OleVariant(d),Null);
end
|
|
158
|
How can I replace or add an icon at runtime
with Pivot1 do
begin
BeginUpdate();
ImageSize := 16;
ReplaceIcon('gAAAABgYACEHgUJFEEAAWhUJCEJEEJggEhMCYEXjUbjkJQECj8gj8hAEjkshYEpk8kf8ClsulsvAExmcvf83js5nU7nkCeEcn8boMaocXosCB9Hn09pkzcEuoL/fE+Ok' +
'YB0gB9YhIHrddgVcr9aktZADAD8+P8CgIA==',Null);
ReplaceIcon('C:\images\favicon.ico',OleVariant(0));
with VisualAppearance do
begin
Add(4,'gBFLBCJwBAEHhEJAAEhABUYCg6AADACAxRDgMQBQKAAzQFAYbhkGCGAAGMZxRgmFgAQhFcZQSKUOQTDKMIziYBYfgkMIgSbJUgDGAkRRdDSOYDmGQYDiCIoRShOMIjHL' +
'UXxtDaIZwhEAoJb+RgAUY/cTzaAEUwHHiTKInaCQShsFYJUJAdRURQ9EwvCIZBpEWwLChENQwWLCNj2TScBwjCyqbale45ViqdoDU5EUiXJJ8ZxnECfYyrGjaMpCeKBU' +
'rGYTVRBIMxLLSia5oeJqMrnBpNVrIUgXCAGFwHK6BcauXIIDp6XoWWRbAAWDpVVzNNC3YzkCIceADHKiXxmVz4JLdGZ1QTGID2XaYaxWK4oZjsVSc4KDHbETbHFi9Fo3' +
'NaaxGisew+GYc4HlCR5NAAAIIEkQJSGMOgdE4RhYDwJJsAaAYQgmPpolCWgSCiBJzjcEIAkQXIBm8d5UhOQgCDUIBDDJDhgggJgKgKYJIDSVoDk8KBFF4OohEMZgWDsY' +
'YDj4GoGmGSB2B6B5iAiBgYDsYRjGSbIJo4RgqDuIpIAoLoLmMCJGDKDJjJiLA7xqUAAgGTwYnYPoPmQCQGEKEJkEkFg9gGY44BoRoSmSSQ2EKEggHgRhShSZRJFYVoVm' +
'WCRmFKFAgGOTheheZgJgYYoYmYSYWGaF4lkMMJ0hqZpJjYbobmcCZGHKHJmjmJh0h2Z4JmYcIaE8WZ2H6H5oAoBoCiCaBKBYfdjGoJoKiKaJKDaDojmkChGgmIgpCoVo' +
'WiWaJZiSd4mmmSh2h6J5qAqBoiiiaY5iSeIpmqComiqKpqkqNouiuah6hqMIsmsSpWiuGhP1kOoumuSp2j6L5sAsBo54gKwWkaMZsgsJpKjKbJLDaRYxYWRpSjSbIZiS' +
'e41m2CxmlqNptksdpejebR5iSfI4m4S4W16boLiaao6m5fJ9jubwLkaco8m8S5WnaPZunuOp4j6b5Lnac4SA0PAGlgP4wEwFwGkGcIMCcCpCnCCxiA8NYAAmMJfkSbhF' +
'CcFpFnGDBnBqRpUhuEwTDeZ5lHCfw6HIQxLCaAxygyJwqgGcATE4FA6hWY4tjEAAQBAgIA==');
end;
BackColorHeader := $4c6c6c6;
SelBackColor := $4000000;
SelForeColor := RGB(0,0,1);
Background[EXPIVOTLib_TLB.exSelBackColorFilter] := SelBackColor;
Background[EXPIVOTLib_TLB.exSelForeColorFilter] := SelForeColor;
Background[EXPIVOTLib_TLB.exBackColorFilter] := BackColor;
Background[EXPIVOTLib_TLB.exForeColorFilter] := ForeColor;
Background[EXPIVOTLib_TLB.exCursorHoverColumn] := $ffffffff;
Background[EXPIVOTLib_TLB.exHeaderFilterBarButton] := $4000000;
Background[EXPIVOTLib_TLB.exHeaderFilterBarActive] := $4010101;
Background[EXPIVOTLib_TLB.exFooterFilterBarButton] := $40000ff;
HeaderAppearance := EXPIVOTLib_TLB.Etched;
GridLineStyle := EXPIVOTLib_TLB.exGridLinesGeometric;
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
PivotRows := '12,0';
PivotColumns := 'sum(5)';
PivotTotals := '/sum';
DataColumns.item[OleVariant(0)].FormatImage := '1';
EndUpdate();
end
|
|
157
|
Rename the caption of a generated column
with Pivot1 do
begin
BeginUpdate();
HeaderAppearance := EXPIVOTLib_TLB.Etched;
HeaderHeight := 24;
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
PivotRows := '0';
PivotColumns := 'sum(5)[caption=<fgcolor red><b>Total]';
EndUpdate();
end
|
|
156
|
Computed-columns support
with Pivot1 do
begin
BeginUpdate();
HeaderAppearance := EXPIVOTLib_TLB.Etched;
HeaderHeight := 24;
GridLineStyle := EXPIVOTLib_TLB.exGridLinesGeometric;
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
Background[EXPIVOTLib_TLB.exColumnIndexColor] := $808080;
FormatContents.Add('Cptd','(%1/%2) format `` replace `.00` with ``',Null).Visible := False;
PivotRows := '0';
PivotColumns := 'sum(5),count(0),count(0)[content=Cptd,caption=<b>Computed(=1/2),bold]';
EndUpdate();
end
|
|
155
|
Show the index of each (generated-)column
with Pivot1 do
begin
BeginUpdate();
HeaderAppearance := EXPIVOTLib_TLB.Etched;
HeaderHeight := 24;
GridLineStyle := EXPIVOTLib_TLB.exGridLinesGeometric;
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
Background[EXPIVOTLib_TLB.exColumnIndexColor] := $ff;
EndUpdate();
end
|
|
154
|
The fine dotted lines in the control appear much thicker than the standard ones we've been using. How can we fix this
with Pivot1 do
begin
BeginUpdate();
GridLineStyle := EXPIVOTLib_TLB.exGridLinesGeometric;
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
EndUpdate();
end
|
|
153
|
Are there any properties to set text margins at tooltip, like Margins="5,5" (method 1). Margins is used to get some space between text and the tooltips border
// 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
ShowToolTip('new content','',Null,'+8','+8');
end
end;
with Pivot1 do
begin
ToolTipMargin := '16,8';
end
|
|
152
|
How can i set the sort order of an aggregated column with code
with Pivot1 do
begin
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
PivotRows := '0[bold]';
PivotColumns := 'sum(5)';
DataColumns.item['Freight'].SortType := EXPIVOTLib_TLB.SortNumeric;
Layout := 'singlesort="C1:2"';
end
|
|
151
|
Force hover-all feature
with Pivot1 do
begin
Background[EXPIVOTLib_TLB.exScrollHoverAll] := $ffffffff;
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
end
|
|
150
|
Disable hover-all feature (Windows 11 or greater)
with Pivot1 do
begin
Background[EXPIVOTLib_TLB.exScrollHoverAll] := $1;
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
end
|
|
149
|
Display a custom tooltip
// 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
ShowToolTip('new content','',Null,'+8','+8');
end
end;
with Pivot1 do
begin
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
end
|
|
148
|
Shows the tooltip of the object moved relative to its default position
// 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
ShowToolTip('<null>','<null>',Null,'+8','+8');
end
end;
with Pivot1 do
begin
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
end
|
|
147
|
ADOR, MDB (JET)
with Pivot1 do
begin
rs := (IUnknown(ComObj.CreateComObject(ComObj.ProgIDToClassID('ADOR.Recordset'))) as ADODB_TLB.Recordset);
with rs do
begin
Open('Data','Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\Exontrol\ExPivot\Sample\Access\sample.mdb',3,3,Null);
end;
DataSource := (IUnknown(rs) as ADODB_TLB.Recordset);
end
|
|
146
|
ImageSize property on 32 (specifies the size of control' icons/images/check-boxes/radio-buttons)
with Pivot1 do
begin
BeginUpdate();
ImageSize := 32;
DefaultItemHeight := 36;
HeaderHeight := DefaultItemHeight;
Font.Size := 16;
FilterBarFont.Size := Pivot1.Font.Size;
ToolTipFont.Size := Pivot1.Font.Size;
Indent := 26;
Images('gBJJgBAIDAAEg4AEEKAD/hz/EMNh8TIRNGwAjEZAEXjAojKAjMLjABhkaABAk0plUrlktl0vmExmUzmk1m03nE5nU7nk9miAoE+oVDolFo1HpFJpU5h8Sf9OqFNqUOqN' +
'UqdPq9VrFWrlbr1QpdhAFAkFis1ntFptVrtkrpszrNvmVxqk3uVtm1kmF3sdBvF/wGBmV+j9BYGHwWJulfxdax2NyFdx2JlV6l9Nw7AAGZymdz2Cy2GxErvWcz9ivlwy' +
'V21cuxugwktzGIzmvwtl0+53U5y0a0Wazmmyu/3dCyOMyXHx/J5nIr9q3uyqnBxFN3G46ma4vb7mD2Ng4nZze00fDkHC7t7us2rOX5tguetpHRlmz4HVqnXk1PjHO+CM' +
'Po9MBMC+j2vC8j7wS8cFNI4kBo05UIvfCT/NsnsApU+0Fqg/T+oy/kPxC0sEQfErKQK96+w28UWRI8UGvO8sTLS9r2PWmsMJTDTask3CsIbIEQRA3shOXEEAO/GclJ9F' +
'EKrrA8FRbKMXRIlb0JxCkjS1LMswhCcvuel0cv26cSMa8Ufx+2sQwhEUoSXOCjSbLcnxjKc7sdKUVyq28NtVI71P9P7JxtQEapjQ6fzfM8zPfNE2PhIsLL63E40slk5y' +
'7N89LcyU9SvMb3SdUc6VJLj5VLVLfO/PS9KzNFHUa/0XyBD0dxlS9cxhMlTRSoNXypPErWDPyfNS+MwprRNO0FD8wVVZ1AI08URwVRjtJ1WCn21QkkUrXVLVPQS/XIkF' +
'gTxT9iONZ9xVTdq+L1eKg3kkF6Upe68XtfV51/MtrVjBlwYFL1ev8y1/P6/lyzzYl02wntj0RVFmS1Qa+M5as93QxEUW9e993rfmQ2+vy65M/mL1lhl/2bj2ByVduMtN' +
'hCJT9hdz41nN14Ld12Z9UjfI/oUAaGseiw6+uFLLhcVabJOS5RqOE0BHlZ5VnEr5fOMs3st+aa/bbRzrJGV51Y0b0DbqaWXZD90hIsPbjWu52+6Wyadpe66hhO+P/Xio' +
'W5rD8ZbrUZuVg6n1dsE/cXmewu1m9PVwnd35/nueXho/NaJzmjc61W76esuT77eG8pTquy9TwWH8LEzG8RDfFalx3Gcfvna9rvG/cptGLd9tuI6TZOP5Fiqi99vea+X4' +
'VRcBq/JZZtVQ9cwSs5lsXE372+a9z7PbfB3VVqHyvMctLto8uob6eV0m/cD6MN2v+T33t6sBut42vdv2bJ8a997x2maFJfK+qArbGJPEKE+1qTflMsIdW/GCJX17KcT6' +
'/czr/X+u1g29B7j/4BQfWkkx4zIHisjhPCmE0K4SwtXM+d4BvHRwNZOoBph9IJvPek9d40FoMJxf691jj2ywQQcHEWET4XJwkTszlVqm2GokewxtBT1DpQjRxDN0rUVD' +
'NKdC3lb6tzNOwh6upMSSYfv4YBCl/bsn9PxiFCEo7SI6Obc9HeOrnY8x4jtHtdpN4GRbaorhsbu18Pph5CiHymI0RpSXGJ/z2oUOxYxG858AyiI+bfJtuTcG5yelBJyT' +
'8okhqFd4a5yxL0rvulYtKCsZiWxWkc1s1cRoxxwhA31DLE0mR9l9HqX8fJgTDmFMVH0MIsRzVYnwnMi1dyzmhLt2kS2pxIiU62Wj5ptQGlSYFakLonTUJNLKaM5Wzlff' +
'EkuFkk5wTrhVO2eE7G6lJhxFFYUZ55zmn0WuBCD4pzhirFCKkbomsOoIYmZx5p90LoYWGPdD5g0QmJRKYxbZ6zYoVQ2jVGylSak7KSkFH6RSjpHKFuU+YMyNo5SulkC6' +
'I0vonTCitMXPoEpVS2H5FQfEqp2R1opIgAEkJISYARTCukOhmPNI5Ex/wzGHUsicMwA1LHgQ90Y/KpoQHAD+pB/R4NzIaMAB9Xaw1gqaAOsh/A/ptIkWUfhGK1kZH8Rg' +
'H5GqvgArqRmt4AAPrTroRofBGADkqr6Rmu4D7CEaHARiwpJrEEZsXXwlVjyMWRsaRqwdkLGNBABZmytmyMnaINZqyVpLR2ftKAAAdd6h2osbaskdiq4EZtgSmyNcbVWR' +
'JNXe3AA7REar3b0stlAAXBtoRmvJGLjEYAHUWsFcwCD/rnaop9aEICMAPdK5hT6xpeuzdOtAgKuJeGfdq6ggEbkTvAP+p9UCHXrvKkcgIA==');
with VisualAppearance do
begin
Add(1,'gBFLBCJwBAEHhEJAAEhABfICg6AADACAxRDgMQBQKAAzQFAYbhkGCGAAGMZxRgmFgAQhFcZQSKUOQTDKMIziaQAGgkNQwCSLIwjNIsBxPFKVQChEYxSjKA40SJNUgyj6' +
'CCY+QLIE5PfQgAL9I6eJABCCSQKkYx0HScRiwPBIbAZAYhCZqaKhWgkKI/WBQIABRDVLx5ESiLRtKy7Mq2bpvXBcNxXHalaztO68LxvKyqHb5fJ/PpgL4YHgmC4NQ7EM' +
'RwF6rfbyfZ7Xg/ORPTijZ4sdzMHTzJyscx3HqfaBoOaZU5eMLceTUMofHIndxCcasPbsOatVqjG5sYjcGC3La9cz3Pq/bpuDCbMxuaK1TrYXr1TTrcofBDldAxXRKDxR' +
'DWVhLnYOw9i6XxzjuXprCaOoKB6EwbiCZZCGOdZYlcT4xHmbhMnwNxtn+G5bmqdZ7n4Pw/i+X5zm+dQ9g4CAFjsfAJheOI8HsDoWDWTB/lwSAQkmA5PEgRYoDyDwYFYF' +
'oFmGCBmBqBphDgRJ0gOTIYBGRB/lyRh0iSCZbjYWJzgWDwIjYLoLmMCJGDKDJjBgWgqG6YhyhGHRzA2aJ1mCABOAiOJvhCZBJBYRoRmSCQmEqEQimkAZgg8TZnDCV4Uk' +
'mCUmBKZYJGYWoWCUUhiFMNZckNUh2GENoaGaGZmgmJhqhqZpGGIEx2GYIxSGGGJdggWJth2Z4JmYeoemeSZ2H6H4hGmQhihyTRHGYLg7CiCgmgqIpokoNoOiOaJ4jqAo' +
'chqaZGgaCxpAoZoaiaaJqEmWIcGgShcnCJwqEqFoR3YOoFlgchflqNouiuawHmWSYqGkWZQhcatzmaOoumuSp2j6L5bBaKo0GQKRnGGCxqiyCwmkqMpsksNpOGUGI7A0' +
'ew1G0Rxlg0PptgsZuDG2Sx2l6N5tnYNZZjUDRXDCVo5l2FoymqOpukuNpujubwLjmWY5k0ZwxkaFxYlWdp6j6b5Lnafo/nABQdg2FxcUsY5BkmXAkmeQpckwNRrkKTh8' +
'CSHZBk4NwyC4KxxgMDwakOMZDn8GgwnGAo2C4cwthMcwmCcMoHBMHRehwTIghySYNksZwcH4HBMEsHx5hyPItiweYxnwSZEH4Mozn0fR+DMAo7EYJ50gkdZelKdNql2U' +
'gJn0GIukwH4HicQRai2GI4mSVpNl0dZGledgNgcYpYDWUx3FsOQi5YV5anaTY3G6W53A2RxylydxFjiaxEFCCgBBAQ==');
Add(2,'gBFLBCJwBAEHhEJAAEhABcoFg6AADACAxRDgMQBQKAAzQFAYbhkGCGAAGMZxRgmFgAQhFcZQSKUOQTDKMIziaQAGgkNQwCSLIwjNIsBxPFKVQChEYxSjKA40SJNUgyj6' +
'CCY+QLIE5PfQgAL9I6eJABCCSQKkYx0HScRiwPBIbAZAYhCZqaKhWgkKI/WBQIABRDVLx5ESiLRtKy7Mq2bpvXBcNxXHalaztO68LxvKyqHb5fJ/PpgL4YHgmC4NQ7EM' +
'RwF6rfbyfZ7Xg/ORPTijZ4sdzMHTzJyscx3HqfaBoOaZU5eMLceTUMofHIndxCcasPbsLpOS5LNKsaxmWLYdhFdTxQi6LpvfA8BwXC6JY7heRYRbFbYxRjGNi1TS7G4n' +
'GKd5WGuL4UHwI4VkaYxii8V4pgQMgVBQdQ5iCTYGi8T4vlWbJ3nuPg+l+H5AlSCg6ByPBoE8Ap3jqYxhBido5g0OgOGOGI4CsSpCCAcgcAuEokiEN5NCKfJ9DyTRjnSc' +
'g1CEYxOBmBpPCgagdgcIZoHoGIFA4AxQkCAxKAgKBwgGSpIBCZhjF2E5UnQPQMiMCJBCIBwxkSQgsgo+JtDKT4ziiQw+k6EwAnsOgLnkHI+yCQ4iEuE4klkPhShEJBpA' +
'oPgymOMoaDgHBjFMBgyD0HYTiCZSZhIIIGC4ChiHSew5kwM5omILZPiOBI0hwZw5kodIdA+M4Uj4PxOmMSJ9DuTQzmyZgviceZagaHVfj4awwmaAh2GUIYmCOEZZDaDR' +
'DFGdwcg4EwyHMN4LBOaJbCoaZqgKH8qkMfIyD8DozDyfA7A0Coui0OpMmOZJdCsahKg6NooioChwmEMxLEoXJbDUTRXGSUgykyMgQG0GpPHMdI3D4TRCgSeQ0kmaw+lG' +
'NAtCOZJVCiT5DhyRQwAqMg0EoDBBGEGAsASC5yiSCw+k4Mp6lWNQuksTpRjMTxDGzJwGmGMpDDKXYTECSAxl6Q5olkK4PgMMIVkASRMBMBgzEkaZEjsNALhIZA6AeQBg' +
'k0ZJEgAAJ0CIAgODMNIsD6DRih9uYwFyAwfCUb5ijmbI+gwdxkk8MZMGeMpPCkDxzBiC5MHMPJLDSSROFMLIoBEQogEMFJPnENYQGgE4DCOaJfC7tYkhGTQ0kyWwykuX' +
'pMiyRpKjKR4wngM4JmOWJACCdYtHMWw+Eych4nINYLAEYA8AgdAEEsQZajaQoog4GxPiMVIolcdxNG8XZVkmNoRwWRVBlFeFEeAZQJgnFiHgHwcAhjhHgGMSI5xki2Cy' +
'A4EQsA3i0HkBsLwKRFgAHcPkHopBJBcBeDUYI7xyDOHqKkWo2hLCsDIBIY4qQ5A8DoMMYwOAqCSBGKgU4yB2iDBwIgB4hxQgAAWNgBoAgsBdEcBUQ4sQ9A/HqD0JI8Rp' +
'BzH2OYVgahLBHFiJQJweQiDhDUE4SAARQAzFsG0EQwA6AOWSBkFgVAIBCHeGERQFQiCQHeFkC4vkiB8DyB4F4QxVDvGMNEOQexMjlBeOAKQiQLgfDA7QEAaRiBdEkH8T' +
'I7AZiFBAGYBIABWjYBiGACioQ4C1A+AMMgWhfgxHgPsT4URIB0COKgPgjRwiAB8AYUArxBgCF6J4GY5hrAOCAPAAoGRRCsCIMEXATXfgAF8BMJwURuEQDgD4Q4OBoAeH' +
'GFgLIwQrC2D0JoSQ+QvhrHoSgQI8AbDFGID8C4Ah6BQAQAASACwgCYCMAUMARAvCKAiAMCAokeCKBEOAKgCBoDaHuMsEAqwJDiACDURg8R6gPCyDofYWAhgoDIJ4ZAuh' +
'oiGAYGgRoQw/A0GMMga4GwxiEDeIYYInATCDBQAoBAwAoDlA0KMBoVRGiDGwDQUYIRsgaGGDgM4LAwDWB8EcIA1APhjEgGQVwgRIgjFIIQHokgZA+CSEkLIKQSjHAwMs' +
'CwDAsAEB2ABTIwRwD6A8CMToSxkAxE4HYIw+BsgbBEDAHYBwojCBoIYFgXSjABE4MsHIbQWhlGILQS4UhvBdAUKEEwHgxDAAABQQQUAhgKHiDwE4JS4A7BGLQZwCR4ga' +
'BEMUYAqgKApHgGwVAIRNgvBMMQXImwZDtE4I8UIyAZCDCAE8AwrhgAdEEBACQLRCg4FEB4AYtA7CdEiPQMoJAMDNCkOMCAXAFDhH0D0Q4EgfAaGSK4NYzRUj9BuCgAgs' +
'wOBjB4Fqpw8B2ADAwE4A4Qx2DAE6JIaQPQGhAGKBcIQ5B5gHByKIFARwADbAyKUfgdBKBBGyEcVIAB/ijHoIoSA0gdBNl+OATYERZgBGSDYWIWAUCEGKA4FAhR7CIBtY' +
'QGYZg4CMAiKEcAOwkBjHWE8Z4lQgA+DkBoTohwwCeAaMEEgBQCCABgHMRwQRhhMEWFQd4HwZgwDqFESItAbAGEANCpINAzANCCJkK4ah+heFYBURwsQrS2CsMYMoWGBh' +
'YDWI0EInQgiApXaOVI1QFDsC8MUNoMBMA1HMJga4eh+BeAWOgNNowGjYzCGAAwax+iJBeBVT4gxoBIAGFsJFBxgBiGKFkKQ7g5DFFQEcAo4AzDDACKEQQLgCiJDYB0Mg' +
'RBCCQAgQEA==');
Add(3,'gBFLBCJwBAEHhEJAAEhABQ4Fg6AADACAxRDgMQBQKAAzQFAYbhkGCGAAGMZxRgmFgAQhFcZQSKUOQTDKMIziaQAGgkNQwCSLIwjNIsBxPFKVQChEYxSjKA40SJNUgyj6' +
'CCY+QLIE5PfQgAL9I6eJABCCSQKkYx0HScRiwPBIbAZAYhCZqaKhWgkKI/WBQIABRDVLx5ESiLRtKy7Mq2bpvXBcNxXHalaztO68LxvKyqHb5fJ/PpgL4YHgmC4NQ7EM' +
'RwF6rfbyfZ7Xg/ORPTijZ4sdzMHTzJyscx3HqfaBoOaZU5eMLceTUMofHIndxCcasPbsLpOS5LNKsaxmWLYdhFdTxQi6LpvfA8BwXC6JY7heRYRbFbYxRjGNi1TS7G4n' +
'GKd5WGuL4UHwI4VkaYxii8V4pgQMgVBQdQ5iCTYGi8T4vlWbJ3nuPg+l+H5AlSCg6ByPBoE8Ap3jqYxhBido5g0OgOGOGI4CsSpCCAcgcAuEosiYN5NHMOJ+D4TpTnSe' +
'Q7CEY4uBmBpPhgagdgcIZoHibIEyUBJZDQIJShoCgcCAcoyAQOYYlcZJ1D0DxDCiQgwEiAZMHEMJLFKPJ9D2DoDnidQ4k+Y5QmKEROBkIhKD0JIZDIS4TGUCQuEeEJjn' +
'OIg8CuY4RkYNgwGMM5RllGpThDRYIGKZIpCkJFUH0PINyWcQ3CaaZCG+HBnEOTJhD8Tx4GoeQ/GcaZSHOH5nCmQhshoZhihYYwhiYA4RlkNoNEMUZ3ByDjwEsPxOnMaJ' +
'9DuDR6F6GYmCmKh0nANtMioP4Gg8aoSiIO5NhodociqaY6GaFYkEyOg8lsNRNTaUgykyMgQG0GpPiONJbD8DpDEyfA6k0KwOkWMQsGsAJU0SagwkoJQJDIPISCQCJTGS' +
'UwyGaM4KkmMgtksHpFjAZ4TGCBAbgaSpcksdhNAMIJHHsD5TjSWWMAMOpwjyLwbk6cAz0KRJiDkDYzESCwiggcgcgYIQwCIEINCMCITj6TVxkMXp2j0cQLlCTo7E2F4y' +
'mkMZdhMPJHDGHpLAyVg+k4UwrCCSIyByDJ8DuDY8CiWY0kiXAXC6QJwFKGIjCeJpjgyezjlyDw6klHx5myRoMGwZwbkcToTEiew4kwbQfEmUgPkOKJUD4DpTHSHQmgkX' +
'I/ASTA1g0XIEDMTBimyfI7jSLYHEiUoPk0Fw/kadAsHGao8A0A5smEMJ2mNyg5gzJZwDgCpChyIZVyIZwFCMJEPASRkBqE+IcHInRcDxA2H4bIsx0AtDsIBpwZwYicD6' +
'BscwDwUBgHCIYaIfgtiVH2O4WgUwJjEFeAEQA7y4hMCiBMS4aRdB9A4CYE4LxljyBMHcDItBxinDCLcTYmgejBFQ9UTg9gFBOEmAQTI7A4iZGMGkQAWQ7jYA2HIL8BRA' +
'jDG4HcCwARbjZHiNoDw1nLDnGyNINQ+wjCpBMEgcovQUgICQJEcgWRuBvAyJ4d4ugpCUAINcHogxIgnDiM4N4axzD3F2JMTY/hRqYF6FsWIxhYAGGoAALQYgYirBwBEB' +
'wpAjBEAAIEIYsA2gOHCMAGgXAACIDmMITAUgFABH0D0I4WwvhNFGMAOIvxRD2GKNcMA8gjAPDCPwBogRPAxA8PgRwZRICYDED8RAXQEghEAN8DIgwIBdB4JYWwMgtiQH' +
'oFQKAiRFguFKGwGQhglDsEOVwEQQRkCKBwOIHgSREDRBYHEXQcQdD7GIGARQHRxipBrMobgewDCUCADsEYWAzgMHKHQDQxxsDzA6EMfAeQHB4GQDkUYPA0iECiKoGgRh' +
'cDdA2GMQA8AOCjDSPgHI4QnApAKBICwHg1A+BcAwcYsgbjGGQNkCIgRsA6EcBEWANADjsB0B8YYzQQDIGSBcEYZBCCPEkFIHQSgkgZAwG4IwBAbAYGGAgL4Ch4g8BOCQ' +
'AA2KKC0GcAke4AAXAFCoHkDw4xbBFEcJkE4JRSiEFeJYKQVRMgJHODwX4xAgC/AsIIZAeAHDRG0HYI40RKCLEGDUI4jAghwBWIceA+whCpHMFYZYOQxglDMHMBQGxYjV' +
'HiAoBIPgfgHGwPsHYJRSB6A0IERQLhCjJHMA4OQoAoCOACLYGYSx8DpBQIMWQdRnDRH+DsE4fB3CeAmM67kAAXBFEIDYDI7wLBtEoEIfYNwjiUGGJQYQMAjCHEAO0C4z' +
'xW29CoCgfIxR9AKA6J8BgUAIhDGMIoJ40hqgwCgKETgnBhhqCGI0AIqgZhGDANQDIlBDCRGkCoJISR0g1BSKQOgfAzBRG0DYHARh4DeDAOwANuw8ApCKKkYg/RPhjBsH' +
'0J4yg5hPGWN0GwFBHQBFaDoQIURljFAoB4GgzRVzbBECQFQRQoguHGHANwDRdCKy8CgSIGwhhoDYJYYI1giBICSAEgI=');
Add(4,'gBFLBCJwBAEHhEJAAEhABUYCg6AADACAxRDgMQBQKAAzQFAYbhkGCGAAGMZxRgmFgAQhFcZQSKUOQTDKMIziYBYfgkMIgSbJUgDGAkRRdDSOYDmGQYDiCIoRShOMIjHL' +
'UXxtDaIZwhEAoJb+RgAUY/cTzaAEUwHHiTKInaCQShsFYJUJAdRURQ9EwvCIZBpEWwLChENQwWLCNj2TScBwjCyqbale45ViqdoDU5EUiXJJ8ZxnECfYyrGjaMpCeKBU' +
'rGYTVRBIMxLLSia5oeJqMrnBpNVrIUgXCAGFwHK6BcauXIIDp6XoWWRbAAWDpVVzNNC3YzkCIceADHKiXxmVz4JLdGZ1QTGID2XaYaxWK4oZjsVSc4KDHbETbHFi9Fo3' +
'NaaxGisew+GYc4HlCR5NAAAIIEkQJSGMOgdE4RhYDwJJsAaAYQgmPpolCWgSCiBJzjcEIAkQXIBm8d5UhOQgCDUIBDDJDhgggJgKgKYJIDSVoDk8KBFF4OohEMZgWDsY' +
'YDj4GoGmGSB2B6B5iAiBgYDsYRjGSbIJo4RgqDuIpIAoLoLmMCJGDKDJjJiLA7xqUAAgGTwYnYPoPmQCQGEKEJkEkFg9gGY44BoRoSmSSQ2EKEggHgRhShSZRJFYVoVm' +
'WCRmFKFAgGOTheheZgJgYYoYmYSYWGaF4lkMMJ0hqZpJjYbobmcCZGHKHJmjmJh0h2Z4JmYcIaE8WZ2H6H5oAoBoCiCaBKBYfdjGoJoKiKaJKDaDojmkChGgmIgpCoVo' +
'WiWaJZiSd4mmmSh2h6J5qAqBoiiiaY5iSeIpmqComiqKpqkqNouiuah6hqMIsmsSpWiuGhP1kOoumuSp2j6L5sAsBo54gKwWkaMZsgsJpKjKbJLDaRYxYWRpSjSbIZiS' +
'e41m2CxmlqNptksdpejebR5iSfI4m4S4W16boLiaao6m5fJ9jubwLkaco8m8S5WnaPZunuOp4j6b5Lnac4SA0PAGlgP4wEwFwGkGcIMCcCpCnCCxiA8NYAAmMJfkSbhF' +
'CcFpFnGDBnBqRpUhuEwTDeZ5lHCfw6HIQxLCaAxygyJwqgGcATE4FA6hWY4tjEAAQBAgIA==');
end;
BackColorHeader := $4c6c6c6;
SelBackColor := $4000000;
SelForeColor := RGB(0,0,1);
CheckImage[EXPIVOTLib_TLB.Unchecked] := 16777216;
CheckImage[EXPIVOTLib_TLB.Checked] := 33554432;
CheckImage[EXPIVOTLib_TLB.PartialChecked] := 50331648;
Background[EXPIVOTLib_TLB.exSelBackColorFilter] := SelBackColor;
Background[EXPIVOTLib_TLB.exSelForeColorFilter] := SelForeColor;
Background[EXPIVOTLib_TLB.exBackColorFilter] := BackColor;
Background[EXPIVOTLib_TLB.exForeColorFilter] := ForeColor;
Background[EXPIVOTLib_TLB.exCursorHoverColumn] := $ffffffff;
Background[EXPIVOTLib_TLB.exHeaderFilterBarButton] := $4000000;
Background[EXPIVOTLib_TLB.exHeaderFilterBarActive] := $4010101;
Background[EXPIVOTLib_TLB.exFooterFilterBarButton] := $40000ff;
HeaderAppearance := EXPIVOTLib_TLB.Etched;
GridLineStyle := EXPIVOTLib_TLB.exGridLinesGeometric;
Images('gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTql' +
'Vq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0' +
'ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yN' +
'AOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=');
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
PivotRows := '12,0';
PivotColumns := 'sum(5)';
PivotTotals := '/sum';
DataColumns.item[OleVariant(0)].FormatImage := 'value case (default: -1;''Germany'': 1;''USA'': 2;''Mexico'': 3)';
EndUpdate();
end
|
|
145
|
ImageSize property on 16 (default) (specifies the size of control' icons/images/check-boxes/radio-buttons)
with Pivot1 do
begin
BeginUpdate();
ImageSize := 16;
Images('gBJJgBAIDAAEg4ACEKAD/hz/EMNh8TIRNGwAjEZAEXjAojJAjMLjABAAgjUYkUnlUrlktl0vmExmUzmk1m03nE5nU7nkrQCAntBoVDolFo1HoM/ADAplLptImdMYFOqd' +
'SqlXq1QrVbrlGpVWsFNrNdnNjsk7pQAtNroFnt0sh8Yr9iulTuNxs1Eu8OiT/vsnsNVutXlk/oGGtVKxGLxWNtsZtN8iUYuNvy0Zvd+xNYwdwvl4p870GCqc8vOeuVtt' +
'mp1knyOayWVy+WzN/ze1wOElenm+12WUz/Bv2/3UyyWrzeutux2GSyGP2dQ33C1ur3GD3M4zUNzHdlWjq/E3nGzVpjWv4HA7fRy/Tv2IrN8rPW6nZ3ve7mUlfu20Z8ac' +
'vQyb+vY9jasYoDwMm+LytVBDqKG3z8O3Cb8P+mkAuY9cCQ2uL4KaxDKvkp8RNLEjqugnrwQo/UWPzFyeQw5sNLZFENrI4kOqU66pw8uzmOKvTqNqjULJvGL1JO48GtTG' +
'sbLdEL3scxLlyiw8dQeoUVxdLTtyKmUjwGlslRPJsnK1HbAKbKCrsQo8uQk/CeP44iaR/ATnTNPLvyxPU+z9P9AUDQVBowiofJXQ6Oo+kKMpIkjztE4TKn4P6JowfgPn' +
'wD5/nAjB8AOeAPo0eAA1IAFH07UhAIMpYAVIYFHqBUhwVjV1S1EtQAHxW65V0AZwAeuQAnwB5gAPYViEDVhwAHTQBkCjB4gOhwDmCyhH0sACAg==');
with VisualAppearance do
begin
Add(4,'gBFLBCJwBAEHhEJAAEhABUYCg6AADACAxRDgMQBQKAAzQFAYbhkGCGAAGMZxRgmFgAQhFcZQSKUOQTDKMIziYBYfgkMIgSbJUgDGAkRRdDSOYDmGQYDiCIoRShOMIjHL' +
'UXxtDaIZwhEAoJb+RgAUY/cTzaAEUwHHiTKInaCQShsFYJUJAdRURQ9EwvCIZBpEWwLChENQwWLCNj2TScBwjCyqbale45ViqdoDU5EUiXJJ8ZxnECfYyrGjaMpCeKBU' +
'rGYTVRBIMxLLSia5oeJqMrnBpNVrIUgXCAGFwHK6BcauXIIDp6XoWWRbAAWDpVVzNNC3YzkCIceADHKiXxmVz4JLdGZ1QTGID2XaYaxWK4oZjsVSc4KDHbETbHFi9Fo3' +
'NaaxGisew+GYc4HlCR5NAAAIIEkQJSGMOgdE4RhYDwJJsAaAYQgmPpolCWgSCiBJzjcEIAkQXIBm8d5UhOQgCDUIBDDJDhgggJgKgKYJIDSVoDk8KBFF4OohEMZgWDsY' +
'YDj4GoGmGSB2B6B5iAiBgYDsYRjGSbIJo4RgqDuIpIAoLoLmMCJGDKDJjJiLA7xqUAAgGTwYnYPoPmQCQGEKEJkEkFg9gGY44BoRoSmSSQ2EKEggHgRhShSZRJFYVoVm' +
'WCRmFKFAgGOTheheZgJgYYoYmYSYWGaF4lkMMJ0hqZpJjYbobmcCZGHKHJmjmJh0h2Z4JmYcIaE8WZ2H6H5oAoBoCiCaBKBYfdjGoJoKiKaJKDaDojmkChGgmIgpCoVo' +
'WiWaJZiSd4mmmSh2h6J5qAqBoiiiaY5iSeIpmqComiqKpqkqNouiuah6hqMIsmsSpWiuGhP1kOoumuSp2j6L5sAsBo54gKwWkaMZsgsJpKjKbJLDaRYxYWRpSjSbIZiS' +
'e41m2CxmlqNptksdpejebR5iSfI4m4S4W16boLiaao6m5fJ9jubwLkaco8m8S5WnaPZunuOp4j6b5Lnac4SA0PAGlgP4wEwFwGkGcIMCcCpCnCCxiA8NYAAmMJfkSbhF' +
'CcFpFnGDBnBqRpUhuEwTDeZ5lHCfw6HIQxLCaAxygyJwqgGcATE4FA6hWY4tjEAAQBAgIA==');
end;
BackColorHeader := $4c6c6c6;
SelBackColor := $4000000;
SelForeColor := RGB(0,0,1);
Background[EXPIVOTLib_TLB.exSelBackColorFilter] := SelBackColor;
Background[EXPIVOTLib_TLB.exSelForeColorFilter] := SelForeColor;
Background[EXPIVOTLib_TLB.exBackColorFilter] := BackColor;
Background[EXPIVOTLib_TLB.exForeColorFilter] := ForeColor;
Background[EXPIVOTLib_TLB.exCursorHoverColumn] := $ffffffff;
Background[EXPIVOTLib_TLB.exHeaderFilterBarButton] := $4000000;
Background[EXPIVOTLib_TLB.exHeaderFilterBarActive] := $4010101;
Background[EXPIVOTLib_TLB.exFooterFilterBarButton] := $40000ff;
HeaderAppearance := EXPIVOTLib_TLB.Etched;
GridLineStyle := EXPIVOTLib_TLB.exGridLinesGeometric;
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
PivotRows := '12,0';
PivotColumns := 'sum(5)';
PivotTotals := '/sum';
DataColumns.item[OleVariant(0)].FormatImage := 'value case (default: -1;''Germany'': 1;''USA'': 2;''Mexico'': 3)';
EndUpdate();
end
|
|
144
|
Is it possible to view all events the control fires
// Event event - Notifies the application once the control fires an event.
procedure TForm1.Pivot1Event(ASender: TObject; EventID : Integer);
begin
with Pivot1 do
begin
OutputDebugString( EventParam[-2] );
end
end;
with Pivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
PivotBarVisible := Integer(EXPIVOTLib_TLB.exPivotBarAllowFormatConditionalAppearance) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowResizeColumns) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowUndoRedo) 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);
EndUpdate();
end
|
|
143
|
Does your control support images
with Pivot1 do
begin
BeginUpdate();
Images('gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTql' +
'Vq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0' +
'ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yN' +
'AOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=');
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
DataColumns.item[OleVariant(0)].FormatImage := 'value case (default: -1;''Germany'': 1;''USA'': 2;''Mexico'': 3)';
EndUpdate();
end
|
|
142
|
Is it possible to rename the generated-columns
with Pivot1 do
begin
BeginUpdate();
HeaderAppearance := EXPIVOTLib_TLB.Etched;
HeaderHeight := 24;
Import('Item;1;2;3#A;10;20;30#A;20;40;50#A;20;30;20#B;10;10;10#B;20;50;30','str=`''` eor=''#'' eof='';'' hdr=1');
PivotRows := 0;
PivotColumns := 'sum(1),sum(2),sum(3)';
FormatPivotHeader := '(iaggregate ? (proper(aggregate) + ` <off -4>` + (caption case (default:`None`; 1:`Sunday`; 2:`Monday`; 3:`Tuesday`; 4:`Wednesda' +
'y`; 5:`Thursday`; 6:`Friday`; 7:`Saturday`)) + `</b>`) : caption)';
EndUpdate();
end
|
|
141
|
Is it possible to rename the columns
with Pivot1 do
begin
BeginUpdate();
AppendData('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
DataColumns.item[OleVariant(0)].Caption := '<b>Nation';
Refresh();
EndUpdate();
end
|
|
140
|
The pivot's rows and columns arer lost once I call the AppendData. Can I add/append data in the background so the layout of the pivot is not lost
with Pivot1 do
begin
BeginUpdate();
AppendData('Def',Null);
AppendData('A',Null);
AppendData('A',Null);
AppendData('A',Null);
PivotRows := 0;
PivotColumns := 'count(0)';
s := Layout;
AppendData('B',Null);
AppendData('B',Null);
Layout := s;
EndUpdate();
end
|
|
139
|
Is it possible to add data without clearing the previously data
with Pivot1 do
begin
BeginUpdate();
AppendData('Column',Null);
AppendData('1',Null);
AppendData('2',Null);
AppendData('3',Null);
EndUpdate();
end
|
|
138
|
How can I change the visual appearance of the Total button
with Pivot1 do
begin
BeginUpdate();
with VisualAppearance do
begin
Add(2,'gBFLBCJwBAEHhEJAAEhABAoCg6AADACAxRDgMQBQKAAzQFAcDBvBgABoGEZIJhUAIIRZGMIjFDcEwxC6NIpjeIBSDUJYkSZEAyjBI8ExXFqMQCkGKocgONYgQLHcgxeA' +
'0XRYFoYRinWA5PoAMoyTYMdIAnTOM4eU6AATwTSccw0fisAAfeq4Wh+HwIQiUBomGahajkMqDYRVagyCI2a4ZDZCIoVJalLAxCw8KDqGJnMr1R5/MDgOBYogXBqHYhiO' +
'AsdhjSYdBK/WLeHI6Y1GS7MMxzLK8cxVaqfMpoMI4FjuS5NU7TMC0PAXdy3LqvbBsOxbHqma5nVSBcC2ba9cz3PK4ABuW7bM6TRKNYbkOA4LiNQaxVSrNKmIwPI5DJ5M' +
'l2co1h0d5vBWDJQEkCI7mIJpykyTZblqdhYDyR5TlmX5RBgeI+D4BxLDkO5nlieh5g2FQ5DOZAiDkDASAmYh7l0RxZncPxfhadZkBmH5jvKLhamMcItBYXgoC4B4CBgF' +
'oskEP4hkgdgegcD4zlycA1goAJ5mIc4KjgfJ+D0ToTFGbx4h8Qh2CqDJjEeJg0gyT4DkCYg5kyAhCDeBxjkIQgDHSIgTkIP4NGGFplgGEZkkifhFgSIRHgCXwtAYeQ2B' +
'+DYlGkZgqgsIpnEoJxzmWGRiFqGJhmkBhDAwJBZDIYoZCYSQ+BOFAmBkJZBhKZpJlYHIXCYR4lFuHpnkmdh+h+aAKAaAogF6FhWgOIZogoJh/GuHoTl6DojmkChGhKJJ' +
'pEoVoWiUHAGDCTg6CmSheh6J5qAoTJriiWQUCSb4ploEwpgq4BKjWBomhmc4pAkOpRAQJQBICA==');
Add(1,'CP:2 -10 -6 8 8');
end;
Background[EXPIVOTLib_TLB.exPivotBarTotal] := $1000000;
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
EndUpdate();
end
|
|
137
|
Is it possible to highlight the column's header once a filter is applied
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 -8 -4 2 4');
end;
HeaderHeight := 28;
Background[EXPIVOTLib_TLB.exHeaderFilterBarButton] := $1fefefe;
Background[EXPIVOTLib_TLB.exHeaderFilterBarActive] := $1010101;
Background[EXPIVOTLib_TLB.exCursorHoverColumn] := $ffffffff;
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
|
|
136
|
How can I change the format the column displays (for instance, displaying no 0:00:00)
with Pivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
FormatContents.Add('notime','value replace `0:00:00` with ``',Null);
PivotRows := '9[content=notime]';
EndUpdate();
end
|
|
135
|
Is it possible to show the filterbar on top of the rows
with Pivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
FilterBarPromptVisible := Integer(EXPIVOTLib_TLB.exFilterBarTop) Or Integer(EXPIVOTLib_TLB.exFilterBarShowCloseIfRequired) Or Integer(EXPIVOTLib_TLB.exFilterBarPromptVisible);
EndUpdate();
end
|
|
134
|
How can I uses the control in window-less mode (with no user interface, option 3)
with Pivot1 do
begin
with (IUnknown(ComObj.CreateComObject(ComObj.ProgIDToClassID('Exontrol.Pivot'))) as EXPIVOTLib_TLB.Pivot) do
begin
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
PivotRows := '0';
PivotColumns := 'avg(5)';
OutputDebugString( Export(Null,Null) );
end;
end
|
|
133
|
How can I uses the control in window-less mode (with no user interface, option 2)
with Pivot1 do
begin
with (IUnknown(ComObj.CreateComObject(ComObj.ProgIDToClassID('Exontrol.Pivot'))) as EXPIVOTLib_TLB.Pivot) 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\Access\sample.accdb',3,3,Null);
end;
DataSource := (IUnknown(rs) as ADODB_TLB.Recordset);
PivotRows := '0';
PivotColumns := 'max(5)';
OutputDebugString( Export(Null,Null) );
end;
end
|
|
132
|
How can I uses the control in window-less mode (with no user interface, option 1)
with Pivot1 do
begin
with (IUnknown(ComObj.CreateComObject(ComObj.ProgIDToClassID('Exontrol.Pivot'))) as EXPIVOTLib_TLB.Pivot) do
begin
LoadXML('http://www.exontrol.net/testing.xml');
PivotRows := '1';
PivotColumns := 'max(6)';
OutputDebugString( Export(Null,Null) );
end;
end
|
|
131
|
How can I connect to a DBF file
with Pivot1 do
begin
BeginUpdate();
rs := (IUnknown(ComObj.CreateComObject(ComObj.ProgIDToClassID('ADODB.Recordset'))) as ADODB_TLB.Recordset);
with rs do
begin
Open('Select * From foxcode.DBF','Provider=vfpoledb;Data Source=C:\Program Files\Microsoft Visual FoxPro 9\',3,3,Null);
end;
DataSource := (IUnknown(rs) as ADODB_TLB.Recordset);
PivotRows := '0';
PivotColumns := 'count(0)[content=numeric],avg(7)[negative,content=numeric]';
EndUpdate();
end
|
|
130
|
Export Data in HTML format
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 `[<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);
with FormatConditionalAppearances do
begin
Add('G1000','> 1000','value > 1000').ForeColor := $ff0000;
Add('L1000','< 1000','value < 1000').ForeColor := $ff;
Add('Zero','zero','value = 0').BackColor := $e0e0e0;
end;
with FormatAppearances do
begin
Add('grayed',Null).ForeColor := $808080;
Add('red',Null).ForeColor := $ff;
Add('green',Null).ForeColor := $ff00;
Add('blue',Null).ForeColor := $ff0000;
Add('bgrayed',Null).BackColor := $808080;
Add('bred',Null).BackColor := $ff;
Add('bgreen',Null).BackColor := $ff00;
Add('bblue',Null).BackColor := $ff0000;
end;
PivotRows := '0[bold],2[grayed]';
PivotColumns := 'sum(5)[L1000],sum(5)[G1000]/12:A';
PivotTotals := 'sum[bold,content=currency,bgrayed]';
AutoDrag := EXPIVOTLib_TLB.exAutoDragScroll;
BackColorAlternate := RGB(240,240,240);
FilterBarPromptType := EXPIVOTLib_TLB.exFilterPromptContainsAny;
FilterBarPromptPattern := 'France Germany';
EndUpdate();
OutputDebugString( Export('htm',Null) );
end
|
|
129
|
Export Data in HTML format (IE)
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 `[<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);
with FormatConditionalAppearances do
begin
Add('G1000','> 1000','value > 1000').ForeColor := $ff0000;
Add('L1000','< 1000','value < 1000').ForeColor := $ff;
Add('Zero','zero','value = 0').BackColor := $e0e0e0;
end;
with FormatAppearances do
begin
Add('grayed',Null).ForeColor := $808080;
Add('red',Null).ForeColor := $ff;
Add('green',Null).ForeColor := $ff00;
Add('blue',Null).ForeColor := $ff0000;
Add('bgrayed',Null).BackColor := $808080;
Add('bred',Null).BackColor := $ff;
Add('bgreen',Null).BackColor := $ff00;
Add('bblue',Null).BackColor := $ff0000;
end;
ShowBranchRows := Integer(EXPIVOTLib_TLB.exBranchIncludeAggregate) Or Integer(EXPIVOTLib_TLB.exBranchTree);
PivotRows := '0[bold],2[grayed]';
PivotColumns := 'sum(5)[L1000],sum(5)[G1000]/12:A';
PivotTotals := '/sum[bold,content=currency,bgrayed]';
AutoDrag := EXPIVOTLib_TLB.exAutoDragScroll;
BackColorAlternate := RGB(240,240,240);
FilterBarPromptType := EXPIVOTLib_TLB.exFilterPromptContainsAny;
FilterBarPromptPattern := 'France Germany';
EndUpdate();
sFile := 'c:/temp/export.htm';
Export(OleVariant(sFile),'vis');
with (IUnknown(ComObj.CreateComObject(ComObj.ProgIDToClassID('InternetExplorer.Application'))) as SHDocVw_TLB.ShellBrowserWindow) do
begin
Navigate2(sFile,Null,Null,Null,Null);
end;
end
|
|
128
|
Export Data in CSV format
with Pivot1 do
begin
BeginUpdate();
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
PivotRows := '0';
PivotColumns := 'sum(5),sum(5)/12:A';
PivotTotals := 'sum[bold,content=currency]';
AutoDrag := EXPIVOTLib_TLB.exAutoDragScroll;
BackColorAlternate := RGB(240,240,240);
EndUpdate();
OutputDebugString( Export(Null,Null) );
end
|
|
127
|
Is it possible to change the visual appearance of the update / reload button being displayed in the control's pivot bar
with Pivot1 do
begin
BeginUpdate();
with VisualAppearance do
begin
Add(1,'gBFLBCJwBAEHhEJAAEhABMsGACAADACAxRDgMQBQKAAzAJBIYhiG4cYCgMYxXDOCYXABCEYRXBIZQ7BKNIxjSJwCgkBYJDSMAiiaLETwHFKVRwkWBBWjMAAxDZFcggA7' +
'7fwxHaOAghGgobjaPY+UbGERAAKQahLJamablCSqLjCS4kSLHEbQHTcRSzLKQZBBCCSQKkYx0HScRiwPBIbQkIQmbajOaYDCiQ53QLCAYRXS9PwvI7AMBwLA8EwXBo9D' +
'ZiIy4WyuGj3R4WchAbIwIxUK6XHhmLjZXg+Bz9T6LQZ0JStEx2SYjAJqOiKU62W9xbAUOxQTpIBJXW7Oc7GTa8dQfPoJaIDLicHgoZ6NLIcOR0abSO42CRrdByfRYMwv' +
'isCQKnYOh9i4LwbBINpBHeBxeC6X4TAIEpzkIWgei8L4Qk2boEhWPg9C4SJijIOZ7mEXA/iAX5yBKDx/lmVhEC0Z5ZlKHgGAAYIHkGcQxiCQ5eA4PghAKNgSG0VYXEiJ' +
'YFl+QAtiCBpdjcDJkB0IgAiYIgBmIQAWCYCoigYZB4DQYpAjoLh3h6SJFgcOpXlAAQBICA==');
end;
Background[EXPIVOTLib_TLB.exPivotBarReload] := $1000000;
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
PivotBarVisible := Integer(EXPIVOTLib_TLB.exPivotBarAllowFormatConditionalAppearance) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowResizeColumns) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowUndoRedo) 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);
EndUpdate();
end
|
|
126
|
Is it possible to change the visual appearance of the plus/add new button being displayed in the control's pivot bar
with Pivot1 do
begin
BeginUpdate();
with VisualAppearance do
begin
Add(1,'gBFLBCJwBAEHhEJAAEhABDwCg6AADACAxRDgMQBQKAAzAJBIYhiG4cYCgMYxXDOCYXABCEYRXBIZQ7BKNIxjSJ5BhIAAyDSJMjSRJUEhqGCWYDleYYYAKHIMQLJQKQSB' +
'cQR9EaBZBAWTpQC0OJDTJRI4TNAgbSYAAYRqoCb6loTKypaxjCQQIgkUBpGKdBynEYsDwSGyJCCJWyIbpKAwoVbcs4AYhuJpaQi+d5PFbjVT8dLAMBwLA8EwXAJ+OpfD' +
'xXU7eFKpR5fchXTI8UxXFqXZhkeQrfh7KYVRBKdBQRBEFQPJqnahqOpaXo2RoLUJKcQwHTmHYNQTALyuTALZrWeZ3XrgN74LbtZzVQauYRpbCMEr6bpoWLnFi6Ho1U4l' +
'lWah1jqSweFqfxPgQQRphi+Yak0YIuqUfJegef4zluaJ3nqPJeCYH4BAeX5TDLBpVGqKRRnwf4flefZtHsX54BYAR/F+EwVnUd5eAMMJKDIChygyIQpAoEh4iIJ5JlgX' +
'IcgCXpIGoFwnGEQh6BEKBgmMIICHgIJCAiUAzgyUoAhwJohkiRgygwYpiGoKwzGIcgKCkNQNCMRIbCYCRYk4QoMiOchWDwNBjhiJJaDYTRiGiFwlCQAhOE8JBJHITIRg' +
'wZRZFCFCZBkOIUhKTRpCWAwgGYQ4El4NxlBifIWCcCYCFoaoMGaKYyG6GxlBmGJdhkCAWBIeA5g4U4QhMJAImkPIShRVxGgQJRlCIUISh+SJpnCZIeBgFgiHgO4OlOMI' +
'NCISByECDQikkGhuh2JwpmqBogCKaYiC6FwhmkQ4yHgYgYiaHopiuaRakCbIsisSpGjYOwaHYKYMCkK5CA2IxrCwCwFigaJrkLTI6lcdANAEgIA=');
end;
Background[EXPIVOTLib_TLB.exPivotBarAddNew] := $1000000;
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
EndUpdate();
end
|
|
125
|
Is it possible to change the visual appearance of the position signs when user changes the column's position by drag and drop
with Pivot1 do
begin
BeginUpdate();
HeaderAppearance := EXPIVOTLib_TLB.Etched;
with VisualAppearance do
begin
Add(1,'gBFLBCJwBAEHhEJAAEhABZEGACAADACAxRDgMQBQKAAzAJBIYhiG4cYCgMYxXDOCYXABCEYRXBIZQ7BKNIxjSJwFgmEgADKMA4SOKIZhrE4bBhGaQRUgyI43RhHUBzVI' +
'UcQvE6TZRHCQYHgkNIhDJIM7TPLkeSVJaTIRoKhJUogApQThTMgVRDEThkGoSa6soSoYTDBKybLrSLKagOT5YUDKUqSdKEZRpEq1YztWbaQoCUoqVRRVIWfbNd4JJa4a' +
'DhWpYdpeeY5R7bWLgBYVVABL7LLRsSxpHxPF6RXxaeI3GKsaS8G6ic6nPQMHj7I4NS5pUa6Rh2VYNSa8AAtETRYznOw4bTMXAjNIea5bAYIIR5HIoDzVbQcCQAHL9DBe' +
'EMIQEEISgGhMGZQmocgymoYRRCIEQ0G2HYBnEIBig4V4zCQGINnmagCECY43medZ6H2Pw/g+X5fnueh/h+R5+AKABfkMWgGgGYA4AICoCGCE5WA4CphACMgSD2IRIDIB' +
'ICmEd5YGCBpRjGBgegWIYIgWdgoGIRQsiKCZiAiJZ0gGQI4jUS4LECOAiBmDJflGfg2BSY4Al4OhGkOCJ2DgFJjGGfgqgiH5Ch4RhGkqOQmEOEpkFkHQYhJRYyESAokG' +
'KHhIhKIxJEmf4VGUeRGFmF5iBkchPhYJQ5GoYIZg6Ug6GoFYmkmNhuhulRGHKGoImefh0BUZ4JmYeoemeSZ2H6HQmgoBgXDqXwUAQgI=');
Add(2,'CP:1 0 -36 0 0');
end;
Background[EXPIVOTLib_TLB.exColumnsPositionSign] := $2000000;
Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
EndUpdate();
end
|
|
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
|