Variable Editor

Data > Variable > Format

 

Use the options in the Variable dialog to enter specifications for the first selected variable.

Note any formatting changes made here will also be displayed in variable specification dialogs and the Variable Specifications Editor (All Formats command). Thus, these formatting options make it easier to quickly identify variables in the DataSheet itself and when selecting variables for analyses, graphs, etc.

 

Name:
The Name box contains the variable name, which is displayed in the column header in the spreadsheet. The name can be changed by typing a new name in the Name box.

Type:
The Type box contains the variable data type. You can change the selection to Number, Text, Factor, ... (see Data Types).

 

General

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. By default, spreadsheets that are bound to databases automatically determine the column width based on the data in the bound database fields. You can change how the width is determined or turn off this automatic sizing by setting the DataSheet DataAutoSizeColumns property.

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

Sort Indicator
Sets the sort indicator for this column
The default value is SortIndicator.None, which specifies that the column does not display a sort indicator

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

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.

Text Indent
sets the amount of space, in pixels, to indent text in cells of the column

Dec Increment:
sets the amount by which the value increments when using the spin buttons and the cursor is in the decimal portion
The default value is 0.1F, which specifies that the increment for the spin buttons is one tenth.

Int Increment:
sets the amount by which the value increments when using the spin buttons and the cursor is in the integer portion.
The default value is 1.0F, which specifies that the increment for the spin buttons is one.

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

ScrollBars:
sets which scroll bars to display for the text cell
The default value is ScrollBars.None, which specifies that neither scroll bar is displayed.

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

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.

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

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.

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.

Auto Filter
sets the auto filter index for the column

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

Sort Indicator
sets the sort indicator for this column
The default value is SortIndicator.None, which specifies that the column does not display a sort indicator

 

 

Format

Character Case:
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

Max Length:
sets the maximum number of characters allowed in the text cell
The default value is 255, which specifies that 255 characters can be typed in a text cell when in edit mode
This is the number of characters that can be typed, not the number that can be displayed. If you enter text by setting the Text property for a cell, this property does not limit those characters, only what can be typed by a user when in edit mode.

Negative Fmt:
sets how the value is formatted for negative values
The default value is NegativeFormat.UseRegional, which specifies using the regional settings.

Positive Fmt:
sets the format for displaying a positive value
The default value is PercentPositiveFormat.UseRegional, which specifies to use the regional settings.

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

Fraction Precision:
sets the precision when values are displayed as fractions
The default value is FractionDenominatorPrecision.Auto, which specifies that the system sets the precision automatically.

Fraction Digits:
sets the number of digits when values are displayed as fractions
The default value is 3, which specifies that three digits are displayed in the denominator of fractions

Fraction Custom Format:
sets how values are displayed as fractions with custom formatting
The default value is "# ???/???", which displays how values are displayed with custom formatting

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.

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

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

FractionMode:
sets whether values are represented as fractions

Multiline:
sets whether multiple lines of text are allowed
The default value is false, which specifies that multiple lines of text are not allowed
When set to true, multiple lines are allowed, but text is not automatically wrapped to new lines when the number of characters exceeds the width of the cell. To wrap lines of text automatically, set the WordWrap property. Otherwise, to wrap lines of text, be sure to type in carriage-return characters to force the text to the new lines.

Fract Render:
sets whether to allow fractions in edit mode when values are displayed as fractions

Fract Convert:
sets whether to convert whole numbers to fractions when values are displayed as fractions
The default value is false, which specifies that whole numbers are not converted

 

 

Alignment

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.

Degrees:
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

 

 

Symbols

Separator:
sets the string used to separate thousands in a numeric value

Percent:
sets the character to display as the percent sign
The default value is null, which indicates that a value is not specified

Decimal:
sets the decimal character

Currency:
sets the string for the currency symbol in displaying currency values

False:
sets the text for false state
The default value is the null string, which specifies that there is no text for the false state
This is the text that appears next to the check box when the box has no check in it representing the false (unchecked) state. If this is not defined, the control displays the Caption text for the check box

Indeterminate:
sets the text displayed when the state of the check box control is indeterminate
The default value is the null string, which specifies that there is no text for the false state
Set this property to specify the text for the indeterminate state. Set the False and True properties to specify the text for the false and true states.

True:
sets the text displayed when the state of the check box control is true
The default value is the null string, which specifies that there is no text for the false state
Set this property to specify the text for the true state. Set the Indeterminate and False properties to specify the text for the indeterminate and false states

ButtonAlign:
sets where the buttons are displayed in the cell

Show Separator:
sets whether to display the thousands separator string
The default value is false, which specifies that the separator is not displayed

ThreeState:
sets whether the check box has three states
The default value is false, which specifies is that the check box is two-state
Check boxes can be either two-state (with true and false) or three-state (with true, false, and indeterminate).
If you want to allow the check box to be three-state, set the value to true

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

Spin Wrap:
sets whether the value wraps when the minimum or maximum is reached
The default value is false, which specifies not the have the spin buttons wrap the values

Show Currency:
sets whether to display the currency symbol
The default value is true, which specifies that the currency symbol is displayed

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

 

 

 

Validation

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.

Misplaced Item:
Tells the software what to do when the user enters a wrong value.

Message:
Error message when the user enters a wrong value

List Check:
List of authorized values

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

 

 

Auto Complete

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

AC 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

AC 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 AutoComplete Custom Source:
sets a whether the AutoCompleteCustomSource is automatically filled with data from other cells in the column.

Custom Source:
sets a custom string collection when the AutoCompleteSource property is set to CustomSource
The default value is empty, which specifies that no automatic completion is set

 

 

Factor

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

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.

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

 

 

Date Time

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

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

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

Date Separator:
sets a date separator string

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

Editor Value:
sets what value is written to the underlying data model
The default value is DateTimeEditorValue.DateTime, which specifies that the DateTime data type of the cell is written to the model.

oString: Writes to the model the text value of the cell

oDateTime: Writes to the model the DateTime object of the cell

oDateSerial: Writes to the model the serial value (double-precision, floating-point) of the date of the cell

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

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

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.

Time Separator:
sets a time separator string