| | Name | Value | Description | |
| |
exPivotBarVisible | 1
|
The pivot bar to show the columns is visible. Include or exclude this flag to
show or hide the control's pivot bar. The PivotColumnsFloatBarVisible
property indicates whether the control shows a floating panel to display the
pivot columns that can be dropped to the control's pivot bar.
| |
| |
exPivotBarSizable | 2
|
The pivot bar is sizable. Include or exclude this flag to allow or prevent
resizing the pivot bar at runtime. If this flag is present, the user can resize
the pivot bar by dragging the bottom side of the control. The resize cursor is
shown when the pivot bar is resizable and cursor hovers the bottom side of the
pivot bar. The PaneHeight property
specifies the height of the top/bottom parts. The top panel is the control's
pivot bar, while the bottom part is the control's list where the result goes.
The PaneMinHeight property specifies the
minimum height of the top/bottom parts.
| |
| |
exPivotBarFloat | 4
|
The pivot bar is shown to a floating window. Include this flag, to display the
control's pivot bar to a separate window ( a floating panel ).
| |
| |
exPivotBarAutoFit | 8
|
Changes automatically the height of the pivot bar so all elements fits the client area.
When this flag is present, the height of the pivot's bar is automatically
adjusted so the entire content fits the header. The PaneHeight
property specifies the height of control's panels. The PaneMinHeight
property specifies the min height of control's panels.
| |
| |
exPivotBarShowTotals | 16
|
Specifies if the control handles the Total/SubTotal fields. By default, the
control displays a Total field in the pivot bar. Include or exclude this flag to
show or hide the Total field in the pivot bar. In other words, you can use this
option to allow or prevent using the total/sub-totals function in the
control.
| |
| |
exPivotBarAutoHide | 32
|
Indicates if the pivot bar is hidden while the cursor does not hover it.
Include or exclude this flag to allow or disable the Auto-Hide feature. The
Auto-Hide feature shows the pivot bar while the cursor hovers it, while the
pivot bar is hidden, when cursor is outside of the pivot bar.
| |
| |
exPivotBarAllowValues | 64
|
Specifies if the user can drop values of the columns to the pivot bar. By
default, the control allow dragging columns as values, so actually, if the user
drags the column to the second line, the value found on the column will compose
the new column to be shown in the control's list. For instance, if you have a
column named Region, it means that the list will display all regions, each
region to be grouped in a single column.
Here's a screen shot of value columns:
The Federal Shipping, Speedy Express and United Package columns indicates the
values being found on the Shippers_CompanyName column.
| |
| |
exPivotBarAllowFormatAppearance | 128
|
Specifies if the user can select a different appearance for columns or total/subtotal fields.
Use the Add method of the FormatAppearances
collection to add new predefined appearance to the context's list.
By default, the control displays the list of appearances in the control's
context menu as shown in the following screen shot:
Include or exclude this flag to allow or prevent applying the appearances
using the control's context menu.
| |
| |
exPivotBarAllowFormatConditionalAppearance | 16777216
|
Specifies if the user can select conditional appearance for columns.
By default, the control displays the list of conditional appearances in the control's
context menu as shown in the following screen shot:
Include or exclude this flag to allow or prevent applying the conditional appearances
using the control's context menu.
| |
| |
exPivotBarAllowFormatContent | 256
|
Specifies if the user can select the way the column's data is displayed. Use
the Add method of the FormatContents
collection to add new predefined functions to the context's list.
By default, the control displays the list of format functions in the
control's context menu under the Content sub-menu as shown in the following
screen shot:
Include or exclude this flag to allow or prevent applying the format
functions using the control's context menu.
| |
| |
exPivotBarAutoUpdate | 512
|
Indicates whether the control' list is automatically updated once the user drops objects in the pivot bar.
By default, the control automatically updates-executes the control's layout as
soon as the user drag and drop columns/aggregate functions to the control. In
case this is a time-consuming depending on how large the data you provide, you
can use this option to prevent executing the layout only when the user clicks
the Refresh buttons as shown in the following screen shot:
Exclude this flag from the PivotBarVisible property, and so the Refresh
button is shown in the bottom side of the control, and the changes will be
applied to the control's list once the user clicks the Refresh button. Once the
data is updated, the buttons shows as disabled until next change occurs. The
control fires the LayoutStartChanging(exPivotDataLayoutExecute)
/ LayoutEndChanging(exPivotDataLayoutExecute)
events once the control updates / executes the current layout.
| |
| |
exPivotBarAllowUndoRedo | 1024
|
Indicates if the pivot bar allows Undo/Redo operations, if the user presses the
CTRL+Z/Y.
The control restores the previously layout once the user presses the CTRL + Z
keys combination. The control restores the next layout once the user presses the
CTRL + Y keys combination. Exclude this flag, and the Undo/Redo feature is
disabled.
| |
| |
exPivotBarAllowResizeColumns | 2048
|
Indicates if the user can resizes the columns in the pivot bar. This flag
affects the columns to be displayed din the pivot bar, not the columns to be
displayed in the control's list.
| |
| |
exPivotBarDefault | 16781275
|
exPivotBarDefault. Indicates the default value of the PivotBarVisible property.
| |
| |
exPivotBarHideAddNew | 4096
|
Prevents showing the add new buttons in the pivot bar. Clicking the Add New
button displays a list of columns or aggregate functions that can be added in
the current context. For instance, the Add New button in the Rows section, helps
you to add more columns to Group-By rows, and a Add New button in the Columns
section, adds new Group-By Columns or new Aggregate functions to be used. The
following screen shot shows theAdd New button:
| |
| |
exPivotBarContextSortAscending | 65536
|
Shows the columns alphabetically in ascending order. This flag can be combined
with
exPivotBarContextSortReverse and so, the columns will be alphabetically
displayed in descending order. The PivotColumnsSortOrder
property specifies the sorting order of the columns to be shown on the Columns
Floating Panel ( PivotColumnsFloatBarVisible
property )
| |
| |
exPivotBarContextSortReverse | 1048576
|
Shows the columns in reverse order. This flag can be combined with
exPivotBarContextSortAscending and so, the columns will be alphabetically
displayed in descending order.
| |
| |
exPivotBarReadOnly | 268435456
|
Makes the pivot bar read only, so no changes are allowed.
| |
