Datasheet

Valid Parents: Viewport

Valid Children: None

Title resource tabs

• Main
• Alignment
• Format
• Border
• Style

Title resources

• Main
  • Column
    Dataset
    Width
    Auto Fit
    
  • Column Heading
    Heading
    Font
    Height
    Color
    Background
    
  • Cells
    Font
    Height
    Color
    Background
    

• Alignment
  • Column Heading
    Horizontal
    Vertical
    
  • Cells
    Horizontal
    Vertical
    
  • Datasheet
    Position
    Horizontal
    Vertical
    Clipping
    Min Row
    Max Row
    Width Margin
    Height Margin
    

• Format
  • Undefined Value
    Text
    
  • Numeric Format
    Decimals
    Floating Point Format
    Trailing Zeros
    Plus Sign
    Minus Sign
    Decimal
    Digit Spacer
    
• Border
  • Cells
    Width
    Color
    Style
    
  • Datasheet
    Width
    Color
    Style
    

• Style
  • Column Heading
    Rotation
    Skewing
    Boldness
    Expansion
    Spacing
    Path
    
  • Cells
    Rotation
    Skewing
    Boldness
    Expansion
    Spacing
    Path
    

Datasheet  Resource Set

Auto Fit (XuNcolumnAutoFit)
This resource controls whether the width of the column is determined by the widest text in the column (true), or the specified/default width (as determined by the viewport's width and the total number of datasheet objects) of the column (false).

• Type: float
• Default: true
• Range: false,true

Background (XuNcellBackgroundColor)
The color of the cell background.

• Type: float
• Default: Unset
• Range:

Background (XuNcolumnHeadingBackgroundColor)
The color of the column heading background.

• Type: float
• Default: Unset
• Range:

Boldness (XuNcellTextBoldness)
The relative boldness of the cell text. The value must be in the range of 0. ­ 20. and expresses a percentage of the character height. Vector fonts are by default represented by one pixel wide vectors on the screen and by a boldness of 10% of the character height on hardcopy devices. With polygon fonts, the boldness factor affects the outline of the fonts. By default the outline has no width. The character has a width but the line outlining it has no width. By setting the boldness factor, the width of the line surrounding the character is increased.

• Type: float
• Default: 0
• Range: 0:20

Boldness (XuNcolumnTextBoldness)
The relative boldness of the column heading text. The value must be in the range of 0. ­ 20. and expresses a percentage of the character height. Vector fonts are by default represented by one pixel wide vectors on the screen and by a boldness of 10% of the character height on hardcopy devices. With polygon fonts, the boldness factor affects the outline of the fonts. By default the outline has no width. The character has a width but the line outlining it has no width. By setting the boldness factor, the width of the line surrounding the character is increased.

• Type: float
• Default: 0
• Range: 0:20

Clipping (XuNdatasheetViewportClipping)
This resource controls whether the datasheet objects are clipped against the viewport's limits.

• Type: float
• Default: false
• Range: false,true

Color (XuNcellBorderColor)
The color of the cell border.

• Type: float
• Default: 1
• Range:

Color (XuNcellTextColor)
The color of the cell text.

• Type: float
• Default: 1
• Range:

Color (XuNcolumnTextColor)
The color of the column heading text.

• Type: float
• Default: 1
• Range:

Color (XuNdatasheetBorderColor)
The color of the datasheet border.

• Type: float
• Default: 1
• Range:

Dataset (XuNdatasetName)
A dataset name, an expression or a text string where the cell data can be found.

• Type: string
• Default: Unset
• Range: N/A

Decimal (XuNdecimalPoint)
Sets decimal point symbol.

• Type: string
• Default: A period "." if locale setting is not available.
• Range: .

Decimals (XuNnumDecimals)
Sets the maximum number of decimal places. 

• Type: float
• Default: Between 0 and 16
• Range: 0:16

Digit Spacer (XuNthreeDigitSpacer)
The character that will appear between each third digit in a number.

• Type: string
• Default: None (0) if locale setting is not available.
• Range: N/A

Expansion (XuNcellTextExpansion)
The width of the character body. To produce wider­than­normal characters set the expansion to greater than 1. Narrower characters are achieved by setting expansion to less than 1.

• Type: float
• Default: 1
• Range: 0.2:2

Expansion (XuNcolumnTextExpansion)
The width of the character body. To produce wider­than­normal characters set the expansion to greater than 1. Narrower characters are achieved by setting expansion to less than 1.

• Type: float
• Default: 1
• Range: 0.2:2

Floating Point Format (XuNfloatingFormat)
The floating number format to be used for representing the cell numeric values values. Possible options:

• Type: string
• Default: "decimal"
• Range: "decimal" ," ee" ," log10"

Font (XuNcellTextFont)
The font for the cell text. The default font is determined by the textoption font resource. Refer to the font table for the UNICLD fonts.

• Type: string
• Default: Unset
• Range: " simp" ,"carg" ,"cart" ,"cenb" ,"cobo" ,"comp" ,"coub" ,"couo" ,"cour" ,"cyri" ,"dupl" ,"futu" ,"gote" ,"gotg" ,"goti" ,"gree" ,"hebo" ,"helb" ,"helo" ,"helv" ,"ital" ,"matr" ,"psim" ,"scri" ,"simg" ,"sims" ,"smag" ,"smai" ,"smal" ,"swib" ,"swil" ,"swim" ,"tem", "tibi", "tibo", "tiit", "tiro", "trii", "trip", "utbi", "utob", "utoi", "utor", "vsim"

Font (XuNcolumnTextFont)
The font for the column heading text. The default font is determined by the textoption font resource. Refer to the font table for the UNICLD fonts.

• Type: string
• Default: Unset
• Range: " simp" ,"carg" ,"cart" ,"cenb" ,"cobo" ,"comp" ,"coub" ,"couo" ,"cour" ,"cyri" ,"dupl" ,"futu" ,"gote" ,"gotg" ,"goti" ,"gree" ,"hebo" ,"helb" ,"helo" ,"helv" ,"ital" ,"matr" ,"psim" ,"scri" ,"simg" ,"sims" ,"smag" ,"smai" ,"smal" ,"swib" ,"swil" ,"swim" ,"tem", "tibi", "tibo", "tiit", "tiro", "trii", "trip", "utbi", "utob", "utoi", "utor", "vsim"

Heading (XuNcolumnHeading)
A text string to be used as the column heading text.

• Type: string
• Default: As specified in Dataset.
• Range: N/A

Height (XuNcellTextHeight)
The height of the cell text.

• Type: float
• Default: 3
• Range: 0:100

Height (XuNcolumnTextHeight)
The height of the column heading text.

• Type: float
• Default: 3
• Range: 0:100

Horizontal (XuNcellTextHorizontalJustification)
Sets the horizontal justification of the cell text relative to the cell bounding box. Possible options:

• Type: string
• Default: "center"
• Range: "center" ," left" ," right"

Horizontal (XuNcolumnTextHorizontalJustification)
Sets the horizontal justification of the column heading text relative to the column heading bounding box. Possible options:

• Type: string
• Default: "center"
• Range: "center" ," left" ," right"

Horizontal (XuNdatasheetHorizontalJustification)
Sets the horizontal justification of the entire datasheet relative to the insertion point. Possible options:

• Type: string
• Default: " left"
• Range: "center" ," left" ," right"

Max Row (XuNdatasheetMaxRow)
Sets the last row of the datasheet.

• Type: float
• Default: The maximum row in the datasheet objects.
• Range:  

Min Row (XuNdatasheetMinRow)
Sets the first row of the datasheet.

• Type: float
• Default: 1
• Range:  

Minus Sign (XuNminusSign)
The character that will precede all negative numbers.

• Type: string
• Default: "­"
• Range: N/A

Path (XuNcellTextPath)
The text path is the direction of the path along which text characters are drawn. Possible options:

• Type: string
• Default: "right."
• Range: "right. 'left'" ," up. 'down'"

Path (XuNcolumnTextPath)
The text path is the direction of the path along which text characters are drawn. Possible options:

• Type: string
• Default: "right."
• Range: "right. 'left'" ," up. 'down'"

Plus Sign (XuNplusSign)
The character that will precede all positive numbers.

• Type: string
• Default: Unset
• Range: N/A

Position (XuNdatasheetPosition)
Sets the position (insertion point) of the first datasheet object in the viewport. The rest of the datasheet objects are appended to the right of the preceding datasheet objects. 

• Type: point
• Default: (0,100)
• Range:  

Rotation (XuNcellTextRotation)
The rotation angle of the cell  text relative to the base line. The angle of rotation of is always measured counterclockwise.

• Type: float
• Default: 0
• Range: ­360:360

Rotation (XuNcolumnTextRotation)
The rotation angle of the column heading text relative to the base line. The angle of rotation of is always measured counterclockwise.

• Type: float
• Default: 0
• Range: ­360:360

Skewing (XuNcellTextSkewing)
The skewing angle of the cell text. The skew angle is measured counterclockwise from the character base line. The skew angle must be between 10 and 170 degrees. The default value is 90, i.e., no skewing.

• Type: float
• Default: 90
• Range: 10:170

Skewing (XuNcolumnTextSkewing)
The skewing angle of the column heading text. The skew angle is measured counterclockwise from the character base line. The skew angle must be between 10 and 170 degrees. The default value is 90, i.e., no skewing.

• Type: float
• Default: 90
• Range: 10:170

Spacing (XuNcellTextSpacingMode)
Controls the spacing between characters. Possible options:

• Type: string
• Default: "kerned"
• Range: "kerned" ," fixed" ," proportional"

Spacing (XuNcolumnTextSpacingMode)
Controls the spacing between characters. Possible options:

• Type: string
• Default: "kerned"
• Range: "kerned" ," fixed" ," proportional"

Style (XuNcellBorderStyle)
The line style of the cell borders. The default style is a solid line. All possible line styles are shown in the table below.

• Type: string
• Default: "lineStyle0"
• Range: "lineStyle0" ,"lineStyle0:'lineStyle11'"

Style (XuNdatasheetBorderStyle)
The line style of the datasheet borders. The default style is a solid line. All possible line styles are shown in the table below.

• Type: string
• Default: "lineStyle0"
• Range: "lineStyle0" ,"lineStyle0:'lineStyle11'"

Text (XuNundefinedText)
A text string to be used as the undefined value.

• Type: string
• Default: UNDEF
• Range: N/A

Trailing Zeros (XuNtrailingZeros)
Allows you to customize the treatment of trailing zeros of the cell numeric values. Possible options:

• Type: string
• Default: "truncated"
• Range: "truncated" ," untouched", "withDecimal", "withoutDecimal"

Vertical (XuNcellTextVerticalJustification)
Sets the vertical justification of the cell text relative to the cell bounding box.. Possible options:

• Type: string
• Default: "middle"
• Range: "top" ,"middle" ,"bottom"

Vertical (XuNcolumnTextVerticalJustification)
Sets the vertical justification of the column heading text relative to the column heading bounding box.. Possible options:

• Type: string
• Default: "middle"
• Range: "top" ,"middle" ,"bottom"

Vertical (XuNdatasheetVerticalJustification)
Sets the vertical justification of the entire datasheet relative to the insertion point. Possible options:

• Type: string
• Default: "top"
• Range: "top" ,"middle" ,"bottom"

Width (XuNcellBorderWidth)
The line width of the cell borders.

• Type: float
• Default: 0.15
• Range: 0:5

Width (XuNcolumnWidth)
Sets the width of the datasheet column. 
By default, the width of the column is determined by the width of the viewport and total number of datasheet objects attached to the viewport. 
If "Auto Fit" is specified, then the column width is determined by the widest text in the column.

• Type: float
• Default: Unset
• Range: >0

Width (XuNdatasheetBorderWidth)
The line width of the datasheet borders.

• Type: float
• Default: 0.5
• Range: 0:5

Height Margin (XuNdatasheetHeightMargin)
Sets the vertical space between the text and the cell or column border of the datasheet objects. 

• Type: float
• Default: 0
• Range: 0:50

Width Margin (XuNdatasheetWidthMargin)
Sets the horizontal space between the text and the cell or column border of the datasheet objects. 

• Type: float
• Default: 0
• Range: 0:50

Inherited Resources

Controls Resource Set

Destroyable (XuNdestroyable)
This resource controls whether the object can be destroyed by a destroy or reset command. Values can be true (On) to set the object as destroyable, or false (Off) to set the object as permanent.

• Type: float
• Default: true
• Range: false,true

Immutable (XuNimmutable)
This resource controls whether the object can be modified. Values are true (On) for non­modifiable, or false (Off) for modifiable. Setting this resource to true (On) locks the currents settings for the object and disables any further changes to the object, including resetting this resource.

• Type: float
• Default: false
• Range: false,true

Object Name (XuNname)
The name of the object.

• Type: string
• Default:
• Range: N/A

Object Enabled (XuNobjectEnabled)
This resource enables or disables the legend. This resource can be set to either true (On) to enable the object or false (Off) to disabled it.

• Type: float
• Default: true
• Range: false,true

Include in Saved GSL (XuNsave)
This resource controls whether the object is included in saved GSL. Values are true (On) to include the object in saved GSL or false (Off) to omit the object.

• Type: float
• Default: true
• Range: false,true

User Data (XuNuserData)
A dataset name or pointer which the user can associate with the object. The dataset is for user use and will not be used by Gsharp.

• Type: string
• Default: Unset
• Range: N/A

Return to Graphic Objects.