Composite View Properties
The following properties are available for Composite View objects, grouped by the categories shown in the View Property Sets editor.
Appearance
| Property | Type | Default | Description |
|---|---|---|---|
string |
The text that appears on the view tab or title bar after the view builds or refreshes. If no value is specified, the CaptionBeforeBuild value is used. If no CaptionBeforeBuild value is specified, the view name is used. The value can be tokenized, which allows the caption to reflect the current context. For example, if the view has selectors and the CaptionAfterBuild contains a token for each of the selectors, the caption after the view is built or refreshed reflects the selections represented by the view data. See also: CaptionBeforeBuild |
||
string |
The text that appears on the view tab or title bar when the view is opened and before the view builds for the first time. If no value is specified, the view name is used as the caption. The value can be tokenized. See also: CaptionAfterBuild |
AutoComplete Ranges
| Property | Type | Default | Description |
|---|---|---|---|
Configures the auto-complete ranges. Each AutoComplete Range defines the range of cells for which the configuration applies as well as the source from which (and when) the list of available cell values is generated along with various aspects of the presentation and behavior. |
Behavior
| Property | Type | Default | Description |
|---|---|---|---|
bool |
true |
Controls whether the user is allowed to copy and cut from the view to the clipboard using the Ctrl+C and Ctrl+X keys, respectively, or using the Copy and Cut tools. When content is copied (or cut) from the view and then pasted into an Excel spreadsheet, any hidden rows and/or columns within the copied range are automatically unhidden in Excel. |
|
bool |
true |
Controls whether the Find and Replace dialog can be launched from the WorkbookView grid control. The Find and Replace dialog is launched using the F5 + Shift, Ctrl + F, or Ctrl + H keys. |
|
bool |
false |
Controls whether only a single instance of the view can be opened by the user from the view selector. When the setting is True, only a single instance is allowed. When the user attempts to open another instance of the view from the view selector, the existing view’s window is activated. |
|
bool |
true |
Controls whether the user is allowed to paste into the grid control using the Ctrl+V or the Shift+Insert keys, or using the Paste tool. |
|
bool |
false |
Controls whether the view can be saved by a user. If true, the Save View As and Save View button tools are enabled. |
|
bool |
false |
||
bool |
false |
Controls whether the view automatically builds when opened. If true, the view automatically builds, but only if the view is buildable. Whether or not the view is buildable is based on the view state. For instance, if a view has selectors and each selector has a selection, the view is buildable. |
|
bool |
true |
Controls whether calculation of Excel formulas is performed on a background thread, which can improve performance. |
|
PasteOption |
PasteOption.All |
Controls whether formulas, formats, and/or values are pasted into a worksheet when the Ctrl+V or the Shift+Insert keys are pressed to initiate the paste. When the PastePolicy is None, no paste operation is performed. |
|
WorksheetZoomMagnificationPercentageRestorePolicy |
Default valueWorksheetZoomMagnificationPercentageRestorePolicy.DoNotRestore |
Controls whether the worksheet zoom magnification percentages are restored when a view is rebuilt, when a view is opened and built, or not at all. DoNotRestore - (Default) When a user changes the zoom magnfication percentages for any worksheet in a view, and then rebuilds or opens a new instance of the view, the magnification of the worksheets is the same as in the view template. RestoreOnRebuild - When a view is rebuilt, the zoom magnification of each worksheet is restored to the percentage as set by the user before rebuilding the view. RestoreOnOpenAndRebuild - As with the RestoreOnRebuild option, when a view is rebuilt, the zoom magnification of each worksheet is restored to the percentage as set by the user before rebuilding the view. And, when a new instance of the view is opened and built, the zoom magnfication of the worksheets is set to the percentages of the worksheets in the instance of the view for which the percentages were most recently changed. |
Comments
| Property | Type | Default | Description |
|---|---|---|---|
bool |
false |
Controls whether to allow the Comments Editor to be used to display and edit comments. |
|
ArrayList of CommentRange |
Controls the behavior or comments within each specified comment range. |
||
CommentsEditMode |
Dodeca.Common.CommentsEditMode.Grid |
Controls whether to use a Chat or Grid user-interface to display and edit comments. |
|
bool |
true |
Controls whether the comments are loded when the view is built. This setting is applied to all the comment ranges, and is typically only set to False for development/debugging purposes. |
Comments Editor
| Property | Type | Default | Description |
|---|---|---|---|
bool |
true |
Controls whether to expose the Context pane in the Comments Editor. Only applicable when EditMode is Grid. |
|
CommentsExplorerAllowFieldChooser |
bool |
true |
Controls whether to enable the field-chooser in the Comments Editor. Only applicable when EditMode is Grid. |
bool |
true |
Controls whether to expose the Links pane in the Comments Editor. Only applicable when EditMode is Grid. |
|
string |
Worksheet Comments and Attachments |
Specifies the caption used for the Comments Editor. |
|
string |
Edit worksheet comments and attachments. |
Specifies the tooltip used for the caption of the Comments Editor. |
|
SelectorControlUIDisplayMode |
SelectorControlUIDisplayMode.DockedControl |
Controls whether the Comments Editor is displayed in a docked pane or a modal dialog. - DockedControl: The Comments Editor is displayed in a dockable pane. The docked location is specified by the Comments Editor’s DockedControlLocation, whhich is located in the Comments Editor category. - LockedDockedControl: Same as a DockedControl, except that the user cannot move the Comments Editor to a different docked location. - ModalDialog: The comments editor is displayed in a modal dialog. |
|
bool |
false |
Controls whether the Comments Editor is automatically displayed when the view is built. |
|
CommentsExplorerDockedControlLocation |
DockedControlLocation |
DockedControlLocation.Right |
The initial docked location for dockable Comments Editor. The setting is only applicable when the CommentsExplorerDisplayMode is set to DockedControl or LockedDockedControl. |
bool |
true |
Controls whether to show the Context pane in the Comments Editor. Only applicable when EditMode is Grid. |
|
bool |
true |
Controls whether to show the DateTime column in the Comments Editor. Only applicable when EditMode is Grid. |
|
CommentsExplorerShowLastDateTime |
bool |
true |
Controls whether to show the LastDateTime column in the Comments Editor. Only applicable when EditMode is Grid. |
bool |
true |
Controls whether to show the LastUserID column in the Comments Editor. Only applicable when EditMode is Grid. |
|
bool |
true |
Controls whether to show the Links pane in the Comments Editor. Only applicable when EditMode is Grid. |
|
bool |
false |
Controls whether to show the Subject column in the Comments Editor. Only applicable when EditMode is Grid. |
|
bool |
true |
Controls whether to show the LastUserID column in the Comments Editor. Only applicable when EditMode is Grid. |
|
string |
Worksheet Comments and Attachments |
Specifies the caption used for the tab of the Comments Editor. |
|
string |
Edit worksheet comments and attachments. |
Specifies the tooltip used for the tab of the Comments Editor. |
CompositeView Properties
| Property | Type | Default | Description |
|---|---|---|---|
string |
The name of the base sheet in the CompositeView’s Excel template. The value can be tokenized. |
||
BaseWorksheetRetentionPolicy |
BaseWorksheetRetentionPolicy.Remove |
Whether to remove the CompositeView’s base sheet after generating the view. |
|
List<CompositeViewSourceViewConfiguration> of CompositeViewSourceViewConfiguration |
A list of view configurations to run. |
Culture
| Property | Type | Default | Description | ||
|---|---|---|---|---|---|
string |
English (United States) |
When the CulturePolicy is set to UseSpecifiedCulture, the CultureName setting specifies the name of the culture used by the view. |
|||
CulturePolicy |
CulturePolicy.UseSpecifiedCulture |
Controls whether the culture associated with the view is the culture specifed by the CultureName setting or is the culture of the client Windows operating system. The culture determines the list separator used when Excel formulas are evaluated. In Excel formulas that contain a function, the function arguments are separated by either a comma or a semicolon. The list separator that is defined by the regional settings associated with the culture is used as the function argument separator in Excel formulas. Any Excel formulas entered into the grid control by the user or through a workbook script must use the culture’s list separator. For an Excel template-based view , the formulas that are in the Excel template are automatically converted to use the specified culture’s list separator as the function argument separator. The Excel formulas used in workbook scripts must use the culture’s list separator as the argument separator explicitly. For example, if a workbook script uses the Address function, the row and column numbers must be separated by a comma when the CultureName is English (United States) and a semicolon when the CultureName is French (France). Alternatively, the @SEP function can be used to create a workbook script that is culture-neutral. For example, =Address(ROW()@SEP()COL())
|
Excel File Encryption
| Property | Type | Default | Description | ||
|---|---|---|---|---|---|
bool |
false |
Controls whether the Excel file is encrypted when the user saves the view as an Excel file, exports the view to an Excel file, opens the view in Excel, or sends an email with the view attached as an Excel file. A password is required to encrypt the Excel file, and is obtained from the user.
|
Excel Template
| Property | Type | Default | Description |
|---|---|---|---|
The ID and version number of the binary artifact that contains the Excel template. |
Exports
| Property | Type | Default | Description |
|---|---|---|---|
ArrayList of ViewExport |
View Export Definitions |
Grid Properties
| Property | Type | Default | Description |
|---|---|---|---|
bool |
true |
Controls whether the user is allowed to customize the auto-calculate functions that are displayed in the Status bar. When AutoCalculateAllowCustomize is True, the user can open the AutoCalculate menu by clicking the right mouse button in the Status bar. |
|
bool |
true |
Controls whether the auto-calculate function results are displayed in the Status bar and whether the AutoCalculate menu is displayed when the user clicks the right mouse button in the Status bar. |
|
AutoCalculateFunctionFlags |
Default valueAutoCalculateFunctionFlags.Average | AutoCalculateFunctionFlags.Count | AutoCalculateFunctionFlags.Sum |
Controls which auto-calculate function results are displayed in the Status bar by default. As in Excel, the auto-calculate feature provides a way to see the results of the following calculation functions as applied to the selected range of cells: Average - Finds the average of the numerical values. Count - Counts the cells that contain a value. Numerical Count - Counts the cells that contain a numerical value Min - Finds the smallest numerical value. Max - Finds the largest numerical value. Sum - Adds the numerical values. |
|
DefaultableBooleanValue |
DefaultableBooleanValue.Default |
Controls whether the grid lines are visible or hidden for template and cascade sheets. Default — The grid line visibility setting in the Excel template is used. True — Grid lines are visible. False — Grid lines are hidden. |
|
HorizontalScrollBarVisible |
DefaultableBooleanValue |
DefaultableBooleanValue.Default |
Controls whether the horizontal scroll bar is visible. Default — The horizontal scroll bar option setting in the Excel template is used. True — The horizontal scroll bar is visible. False — The horizontal scroll bar is hidden. |
DefaultableBooleanValue |
DefaultableBooleanValue.Default |
Controls whether the outline symbols are visible or hidden for template and cascade sheets. Default — The outline symbols visibility setting in the Excel template is used. True — For worksheets with an outline, the outline symbols are displayed. False — Outline symbols are hidden. |
|
DefaultableBooleanValue |
DefaultableBooleanValue.Default |
Controls whether the row and column headers are visible or hidden for template and cascade sheets. Default — The row and column headers visibility setting in the Excel template is used. True — Row and column headers are visible. False — Row and column headers are hidden. |
|
double |
The ratio of the width of the worksheet tabs to the width of the horizontal scrollbar as a number between zero and one. For example, if set to .75, the width of the area for worksheet tabs is 75% and the width of the scroll bar area is 25% of the total width of the view window. |
||
DefaultableBooleanValue |
DefaultableBooleanValue.Default |
Controls whether sheet tabs are visible or hidden. Default — The sheet tabs visibility setting in the Excel template is used. True — Sheet tabs are visible. False — Sheet tabs are hidden. See also: ExcelTemplateBinaryArtifact |
|
DefaultableBooleanValue |
DefaultableBooleanValue.Default |
Controls whether the vertical scroll bar is visible. Default — The vertical scroll bar option setting in the Excel template is used. True — The vertical scroll bar is visible. False — The vertical scroll bar is hidden. |
Selectors
| Property | Type | Default | Description |
|---|---|---|---|
SelectorConfiguration |
Configures the selectors for the view, including the order the selectors are displayed in the toolbar as well as the following settings for each selector: Optional — Controls whether a selection is optional or required. MultiSelect — Controls whether the user is allowed to select multiple items or only a single item. If checked, multiple items can be selected. Caption — An optional caption that overrides the default caption defined for the selector. Selector List — The selector list that defines 1) how the list of selectable items is generated and 2) the user-interface control used to display the items. If no selector list is specified, the default selector list defined for the selector is used. Last Used Item Context — Controls the caching of the item(s) selected when the view is built or refreshed. Refer to the SelectorLastUsedItemContext for additional information. LastUsedItemContextLabel — The context label used when the Last Used Item Context is set to ByLabel. Connection Policy — For a selector that requires a connection to generate the list of selectable items, the connection policy controls whether the selector uses the view’s connection or uses a specified connection. Connection Settings — When the connection policy is UseSpecifiedConnection, the connection settings identify and configure the connection. |
||
SelectorControlUIDisplayMode |
SelectorControlUIDisplayMode.DockedControl |
Controls whether a docked pane or a modal dialog contains the user-interface control that displays the selectable items. The setting is only applicable to selectors that display the items in a user-interface control, such as a treeview or listbox, when the user clicks the 'Show' button on the selector tool. DockedControl — Displays a pane that contains the user-interface control. The pane is docked the first time the user clicks the 'Show' button. The docked location is specified by the SelectorDockedControlLocation. If multiple selector user-interface controls are docked, each is displayed as a separate tab in the pane. LockedDockedControl — Same as a DockedControl, except that the user cannot move the control to a different docked location. ModalDialog — Displays a modal dialog that contains the user-interface control. The dialog is displayed each time the user clicks the 'Show' button, and must be closed by the user. See also: SelectorDockedControlLocation |
|
DockedControlGroupStyle |
DockedControlGroupStyle.Tabbed |
The layout of the group of dockable selector user-interface controls. The setting is only applicable when the SelectorControlDisplayMode is set to DockedControl. Tabbed - Each selector control is displayed as a tabbed window within the group. Only the content of the selector control that is displayed in the active tab is visible. Stacked - The selector controls are displayed as stacked tiles. SlidingHeaders - Each selector control is represented by a button and only the content of the active selector control is visible. A selector control is activated by pressing its button. SideBySide - The selector controls displayed as side-by-side tiles. The combination of the SelectorDockedControlLocation and SelectorDockedControlGroupStyle settings determines the location and layout of the selector controls. See also: SelectorControlUIDisplayMode, SelectorDockedControlLocation |
|
DockedControlLocation |
DockedControlLocation.Right |
The initial docked location for dockable selector user-interface controls. The setting is only applicable when the SelectorControlDisplayMode is set to DockedControl. See also: SelectorControlUIDisplayMode |
|
LastUsedItemContextScope |
LastUsedItemContextScope.BySelector |
Controls the caching of the item(s) selected when the view is built or refreshed. The cache is used to determine the default selected item(s) for the selectors that are assigned a selector list with a DefaultSelectionPolicy of LastUsedItem. BySelector — The cache is shared by all views configured with the BySelector context. BySelectorList — The cache is shared by all views configured with the BySelectorList context. ByView — The cache is used only by this view. ByLabel — The cache is shared by all views configured with the ByLabel context and assigned the same SelectorLastUsedItemContextLabel as this view. See also: SelectorLastUsedItemContextLabel |
|
string |
The context label used when the SelectorLastUsedItemContext is set to ByLabel. Views that are assigned the same label share the same default selections. See also: SelectorLastUsedItemContext |
Status Information
| Property | Type | Default | Description |
|---|---|---|---|
StatusBarContentAlignment |
StatusBarContentAlignment.Center |
Controls the alignment of the progress text within the progress text area on the status bar. ProgressTextAlign is only applicable when ShowStatusBar is true. See also: ShowStatusBar, ShowProgressText |
|
bool |
true |
Controls whether the progress text is displayed in the status bar. ShowProgressText is only applicable when ShowStatusBar is true. See also: ShowStatusBar, ProgressTextAlign |
|
bool |
true |
Controls whether the status bar is displayed in the view window. See also: ShowStatusIcon, ShowStatusText, ShowProgressText, ProgressTextAlign |
|
bool |
true |
Controls whether the status icon is displayed in the status bar. ShowStatusIcon is only applicable when ShowStatusBar is true. See also: ShowStatusBar, ShowStatusText |
|
bool |
true |
Controls whether a status icon is displayed on the view window tab. |
|
bool |
true |
Controls whether the status text is displayed in the status bar. ShowStatusText is only applicable when ShowStatusBar is true. See also: ShowStatusBar, ShowStatusIcon |
|
string |
Ready to Build |
The text displayed in the status bar to indicate the view is buildable as determined by the view state. For instance, a view that has selectors is typically considered buildable when each selector has a selected item. |
|
string |
Cancelled |
The text displayed in the status bar to indicate the view was cancelled. |
|
string |
Error |
The text displayed in the status bar to indicate a view operation failed. |
|
string |
Information |
The text displayed in the status bar to indicate that the status details contain information. The details are displayed when the Details button is clicked. |
|
string |
Not Ready to Build |
The text displayed in the status bar to indicate the view is not buildable as determined by the view state. |
|
string |
Ready |
The text displayed in the status bar to indicate a view operation is complete. |
|
string |
Selection Changed |
The text displayed in the status bar to indicate a selection changed. |
|
string |
Waiting for Server Response |
The text displayed in the status bar to indicate the view is waiting for a response from the server. |
|
string |
Warning |
The text displayed in the status bar to indicate that the status details contain a warning. The details are displayed when the Details button is clicked. |
|
string |
Working |
The text displayed in the status bar to indicate a view operation is processing. |
UI
| Property | Type | Default | Description |
|---|---|---|---|
string |
The key of the PopupMenuTool to use as the context menu for the grid control. Any popup menu tool that is defined in the toolbars configuration assigned as the ViewToolbarsConfigurationID can be used as the grid context menu. See also: ViewToolbarsConfigurationID |
||
string |
The ID of the toolbars configuration that defines the view-specific menus and tools. At run-time, the menus and tools are merged with the application menus and tools. See also: ViewToolbarsConfigurationID |
||
RenderExcelViewAsDocumentPolicy |
RenderExcelViewAsDocumentPolicy.RenderAsExcel |
Controls whether the view is rendered as an Excel spreadsheet, which is the default, or as a PDF. When the value is RenderAsPDF, the WindowsViewUIObjectTypeID should be set to WorkbookViewAndPdfViewer. The PDF toolbar, which contains the PDF tools, is built into the PDF viewer. If the view requires a Build button and POV selectors, set the ViewToolbarsConfigurationID to View Standard, which is included in the metadata starter kit. |
|
string |
The key of the PopupMenuTool displayed when the sheet tab area of the grid control is clicked with the right mouse button. Although any popup menu tool that is defined in the toolbars configuration assigned as the ViewToolbarsConfigurationID can be specified as the sheet context menu, only a popup menu tool that contains any of the tools with the following keys should be used: InsertSheetContextMenuButton, DeleteSheetContextMenuButton, and RenameSheetContextMenuButton. The SheetContextMenu is a standard popup menu tool that contains these tools and can be imported into a toolbars configuration. See also: ViewToolbarsConfigurationID |
||
bool |
false |
Controls whether a formula bar is displayed along the top of the grid. The formula bar contains a dropdown list of range names for the workbook and the active worksheet. It also contains an area that displays the constant value or formula stored in the active cell, and can be used to enter or edit values or formulas in cells. |
|
string |
The ID of the toolbars configuration that defines the view-specific menus and tools displayed within the view window. See also: MergeableToolbarsConfigurationID |
||
string |
The object type ID of the Windows form that contains the user-interface controls used to display the view data. This is a required setting. |
UI - WorkbookView
| Property | Type | Default | Description |
|---|---|---|---|
bool |
false |
Controls whether the Chart Explorer can be launched from the WorkbookView grid control. The Chart Explorer is launched using the F6 + Shift keys. |
|
bool |
false |
Controls whether the Range Explorer can be launched from the WorkbookView grid control. The Range Explorer is launched using the F6 + Shift keys. |
|
bool |
false |
Controls whether the Shape Explorer can be launched from the WorkbookView grid control. The Shape Explorer is launched using the F6 + Shift keys. |
|
bool |
false |
Controls whether the Workbook Designer can be launched from the WorkbookView grid control. The Workbook Designer is launched using the F3 key. |
|
bool |
false |
Controls whether the Workbook Explorer can be launched from the WorkbookView grid control. The Workbook Explorer is launched using the F6 key. |
View Attachments
View Comments
| Property | Type | Default | Description |
|---|---|---|---|
string |
True |
Controls whether to allow comments to be added. AllowAdd can be specified as a formula that evaluates to True or False. |
|
string |
False |
Controls whether to allow comments that have already been saved to be deleted. AllowDelete can be specified as a formula that evaluates to True or False. The following tokens are available for the current comment: [T.Comment.CreatedBy], [T.Comment.CreatedDate], [T.Comment.UpdatedBy], [T.Comment.UpdatedDate]. |
|
string |
False |
Controls whether to allow comments that have already been saved to be updated. AllowUpdate can be specified as a formula that evaluates to True or False. The following tokens are available for the current comment: [T.Comment.CreatedBy], [T.Comment.CreatedDate], [T.Comment.UpdatedBy], [T.Comment.UpdatedDate]. |
|
ViewCommentsAutoAddSelectorValuesToKeyItems |
bool |
true |
Controls whether the selector values are automatically added to the KeyItems. |
ViewCommentsAutoAddViewIdToKeyItems |
bool |
true |
Controls whether the view’s ID is automatically added to the KeyItems. |
string |
The context string is stored with each comment. It can be used to capture context specific information that may be important to understanding the comment. A formula can be used to specify this string. |
||
string |
g |
Specifies the format used when displaying a date, such as the created or last modified date, in the Comments Editor or an Excel comment. The DateFormat value can either be a standard or a custom format string. The default value, g, combines the short date and short time patterns, as defined by the view’s culture, separated by a space. A standard format string consists of a single format character specifier from the following list of standard format specifiers. The patterns are influenced by the view’s culture, which defines the short and long patterns as well as the date separator and time separator. With the following standard format specifiers, the displayed time is the local time. The examples are based on the United States (English) culture: d: Short date pattern, 4/9/2009 D: Long date pattern, Thursday, April 09, 2009 t: Short time pattern, 7:53 PM T: Long time pattern, 7:53:03 PM f: Combination of long date and short time patterns separated by a space, Thursday, April 09, 2009 7:53 PM F: Full date/time pattern, Thursday, April 09, 2009 7:53:03 PM g: Combination of short date and short time patterns separated by a space, 4/9/2009 7:53 PM G: Combination of short date and long time patterns separated by a space, 4/9/2009 7:53:03 PM The format specifiers are based on the .NET framework conventions. Refer to the following links for more information about standard and custom format specifiers, all of which are supported for the DateFormat property: |
|
CommentsEditMode |
Dodeca.Common.CommentsEditMode.Chat |
Controls whether to use a Chat or Grid user-interface to display and edit comments. |
|
bool |
false |
Controls whether to allow view comments. |
|
ArrayList of NamedKeyValuePair |
Specifies the KeyItems the View Comments Editor will use to link comments to the view. A miminmum of one KeyItem is required for view comments. The view’s AutoAddViewIdToKeyItems property can be used to include the view’s ID in the KeyItems without having to actually enter it. |
||
ViewCommentsMaxCommentCharacters |
int |
-1 |
The maximum number of characters to display of each comment in the comment cell. Enter -1 for no limit. |
CommentSortPolicy |
CommentSortPolicy.DateAscending |
When EditMode is Grid, specifies how to sort comments when displayed in the View Comments Editor.
|
|
ViewCommentsSpellCheckEnabled |
bool |
false |
Controls whether to provide view comments spell-checking. |
CommentThreadPolicy |
CommentThreadPolicy.ThreadedMultipleRootComments |
When EditMode is Grid, controls the type of threading allowed for view comments.
|