Variable Specifications Editor

Data > Variable > All Formats

 

Click the All Formats button in the Variable Editor dialog to display the Variable Specifications Editor.

Use this dialog, which is organized in spreadsheet format, to view and edit the properties of the variables in the active DataSheet. You can resize the dialog (to allow greater viewing of the various columns) by dragging its corners or sides.

 

print

Click the Print button to print a copy of the information displayed in the Variable Specifications Editor.

printpreview

Click the PrintPreview button to preview the information displayed in the Variable Specifications Editor before printing

pagesetup

Click the PageSetup  button to opens a printer setup dialog, allowing you to change any of the options on the default printer before printing the appearance of the data area of the design

save

Click the Save button to save the information displayed in the Variable Specifications Editor

outtosheet

Click the Output to DataSheet button to export the information displayed in the Variable Specifications Editor to a DataSheet

cut

Click the Cut button to cut the selected cell(s) in the dialog to the Clipboard.

copy

Click the Copy button to copy the selected cell(s) in the dialog to the Clipboard.

paste

Click the Paste button to paste the contents of the Clipboard to the selected cells.

addcol

Click the Add Variables button to Add variables.

delcol

Click the Delete Variables button to Delete variables.

fillcol

Click the Fill/Copy Down button to fill down variables

dictioncol

Click the Direction button to change direction after pressing enter key

frezecol

Click the Freeze First Column button to make unscrollable the first column

 

 

Name:
The Name column lists the variable name as it is displayed in the variable header cells of the datasheet

Type:
The Type column displays the data type for each variable. Use the list boxes to select a different data type for the selected variable. See Data Types.

Width:
sets the width of cells in this column
The default value is 60.0F, which specifies the width of the column is 60 pixels

Indent:
sets the indent of the grouping information

Resizable
sets whether this column can be resized
The default value is true, which specifies that the column can be resized
Double clicking on the column header resize cursor will cause the column to resize to match the text if Resizable is true

Visible
sets whether this column is visible
The default value is true, which specifies that the column is displayed

Locked
sets whether cells in this column are marked as locked
The default value is false, which specifies that the cells in the column are not marked as locked
You can specify that certain columns of cells are locked; that is, the user cannot edit them. You mark columns of cells as locked by setting this property to true. Columns of cells are not locked until the DataSheet Protect property is also set to true for the sheet.
Because the default value of the Protect property is true, unless you have changed the value of the Protect property, when you mark a column of cells as locked, they are locked and the user cannot edit them. When the Protect property is false, the user can still interact with cells marked as locked.

Formula
sets the formula for cells in this column
Set this property to a mathematical expression made up of cell references, operators, and functions (either provided or custom functions you define). For a list of the operators and functions you can use in formulas, refer to the Formula Reference.
Returning the value of the Formula property provides a string containing the written expression of the formula, for example, SUM(A1:B1). However, if you have changed the cell reference style to a style that cannot represent the formula, the Spread component provides the formula with question marks as placeholders for cell references that cannot be represented.

Auto Sorting
sets whether this column allows automatic sorting
The default value is false, which specifies that the column does not allow automatic sorting

Auto Filter
sets the auto filter index for the column

Page Break
sets whether a page break is inserted before this column when printing
The default value is false, which specifies that a page break has not been inserted before this column.

Items:
sets the items for the drop-down list in the combo box

Items Data:
sets the corresponding data for the items in the drop-down list in the combo box

Editor Value:
sets what value is written to the underlying data model
The default value is EditorValue.String, which specifies that the text value of the selected item is written to the model

oString: Writes to the model the text value of the selected item

oIndex: Writes to the model the index of the selected item

oItemData: Writes to the model the corresponding data of the selected item

Editable:
sets whether you can type into the edit portion of the combo box
If set to true, the end user can enter information in the cell by typing. If set to false, the end user can only interact with the drop-down list and can not type in a value directly into the cell.

List Alignment:
sets the side of the cell on which the list aligns.
The default value is ListAlignment.Left, which specifies that the list box aligns to the left side of the cell

List Offset:
sets the side of the cell on which the list aligns
The default value is ListAlignment.Left, which specifies that the list box aligns to the left side of the cell

List Width:
sets the width (in pixels) of the drop-down list
The default value is -1, which specifies that the list becomes the width of the cell

Max Length
sets the maximum number of characters allowed in the combo box cell
The default value is 255, which specifies that at most 255 characters are allowed per item
By default, the text in the edit field is limited to 255 characters and is left aligned. You can change the maximum number of characters allowed by setting this property

Horizontal:
sets the default horizontal alignment for cells in this column
The default value is CellHorizontalAlignment.General, which specifies that the alignment depends on the cell's interpretation of the contents.
The HorizontalAlignment and VerticalAlignment properties determine the alignment of the cell's content (that is, the text) which is independent of the alignment of the cell's background image.

Vertical:
sets the default vertical alignment for cells in this column
The default value is CellVerticalAlignment.General, which specifies that the alignment depends on the cell's interpretation of the contents
The HorizontalAlignment and VerticalAlignment properties determine the alignment of the cell's content (that is, the text) which is independent of the alignment of the cell's background image.

TextOrientation:
sets how text orients itself when painting the cell
The default value is TextOrientation.TextHorizontal, which specifies that the text is aligned horizontally in the control.

Angle:
sets the rotation angle of the text for the cell

WordWrap:
sets whether text that is too long to fit in the cell wraps to additional lines
The default value is false, which specifies that text does not wrap to multiple lines

Null Display:
sets the text to display for null values
The default value is null, which means nothing is specified for a null display.

Dec Places:
sets the number of decimal places.
The default value is -1, which specifies that the control uses the default regional settings value.

Fixed Point:
sets whether to display zeros as placeholders in the decimal portion of the number for a fixed-point numeric display.
The default value is true, which specifies that the value displays place-holding zeros in the decimal portion

Negative Red:
sets whether negative numeric values are displayed in red
The default value is false, which specifies that negative values are not displayed in red

Leading Zero
sets whether leading zeros are displayed
The default value is LeadingZero.UseRegional, which specifies using the regional settings

oUseRegional: Displays leading zeros according to the Windows regional settings

oNo: Does not display leading zeros

oYes: Displays leading zeros

Spin Button:
sets whether a spin button is displayed when editing
The default value is false, which specifies not showing the spin buttons

Casing:
sets the case of characters in the text cell
The default value is CharacterCasing.Normal, which specifies that the case of the characters is left unchanged.

Character Set:
sets what characters to allow for the text cell
The default value is CharacterSet.Ascii, which specifies that any ASCII character is valid

DD Button:
sets whether a drop-down button is displayed in the cell

ButtonAlign:
sets where the buttons are displayed in the cell

ReadOnly:
sets whether the cell is read-only (and thus cannot be modified)
The default value is false, which specifies that the cell can be edited.

Static:
sets whether the cell is static, which prohibits user interaction
The default value is false, which specifies that the user can enter edit mode
When set to true, this property prohibits the user from entering edit mode when clicking on the cell. It forces the cell to be a label cell because it displays whatever text is set for this cell but does not allow the user to edit it.

String Trim:
Sets how to trim characters that do not fit in the cell.

Required:
Value is required

Unique:
The values in column must be unique

Indexed Items:
If checked, when user enters the index of item, the label of item is returned

Bad Level:
Tells the software what to do when the user enters a wrong value.

Max Value:
sets the maximum value allowed for user input
The default value is 9999999.99. The upper limit is 14 digits
The MaximumValue properties limit the value that the user enters when editing the cell. It does not affect the data model and does not the limit the cell getting a value by other means, for example by means of a formula or code.
The built-in operators and built-in functions for use in formulas return results as a Double (15 digits).

Min Value:
sets the minimum value allowed for user entry
The default value is -9999999.99
The MinimumValue properties limit the value that the user enters when editing the cell. It does not affect the data model and does not the limit the cell getting a value by other means, for example by means of a formula.

List Check:
List of authorized values

Message:
Error message when the user enters a wrong value

Accepts Key:
sets how arrow keys are processed by the edit control
The default value is AcceptsArrowKeys.AllArrows, which specifies that the control processes user input from the keyboard arrow keys as well as Ctrl-arrow key combinations. AcceptsArrowKeys setting that determines how arrow keys are handled

Mode:
sets how automatic completion works
The default value is AutoCompleteMode.None, which specifies that no automatic completion is set

oAppend: Appends the remainder of the most likely candidate string to the existing characters, highlighting the appended characters.

oNone: Disables the automatic completion feature for the ComboBox and TextBox controls

oSuggest: Displays the auxiliary drop-down list associated with the edit control. This drop-down is populated with one or more suggested completion strings.

oSuggestAppend: Applies both Suggest and Append options

Source:
sets the source of complete strings used for automatic completion
The default value is AutoCompleteSource.None, which specifies no automatic completion source

oAllSystemSources: Specifies the equivalent of FileSystem and AllUrl as the source. This is the default value when AutoCompleteMode has been set to a value other than the default.

o AllUrl: Specifies the equivalent of HistoryList and RecentlyUsedList as the source.

o CustomSource: Specifies strings from a built-in AutoCompleteStringCollection as the source.

o FileSystem: Specifies the file system as the source.

o FileSystemDirectories: Specifies that only directory names and not file names will be automatically completed.

o HistoryList: Includes the Uniform Resource Locators (URLs) in the history list.

o ListItems: Specifies that the items of the ComboBox represent the source.

o None: Specifies that no AutoCompleteSource is currently in use. This is the default value of AutoCompleteSource.

o RecentlyUsedList: Includes the Uniform Resource Locators (URLs) in the list of those URLs most recently used.

AutoFill:
sets a whether the AutoCompleteCustomSource is automatically filled with data from other cells in the column.

Date Separator:
sets a date separator string

Time Separator:
sets a time separator string

Format
sets the format for displaying dates and times
The default value is DateTimeFormat.ShortDate, which specifies the abbreviated date format

Maximum Date:
sets the maximum date value allowed for user entry
The default value is "9999-12-31".

Maximum Time:
sets the maximum time value allowed for user entry
The default value is "23:59:59.9999999".

Minimum Date:
sets the minimum date value allowed for user entry
The default value is "0001-01-01".

Minimum Time:
sets the minimum time value allowed for user entry
The default value is "00:00:00".

Default Date:
sets the default date for the control
The default value is System.DateTime.Now, which specifies the present date

Default Time:
sets the default time used in the control
VisualStat uses this property to fill in the time portion that is not set into the cell, typically when dates are entered and times are ignored. When the user enters a date into a date-time cell and no time is specified, the value of this property is used
When the user sets the date in the cell with the pop-up calendar, the time is set to midnight.