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. |