Show TOC

Function documentationi5Grid Grid Area

 

You use this function to configure the main area of your SAP Manufacturing Integration and Intelligence (SAP MII) i5grids.

Features

The grid area properties are the following:

Property Name

Parameter Name

Data Type

Description

Grid Type

GridType

String

Describes the available grid types. For more information, see Available Grid Types.

Font

FontFace

String

Determines the font type of column values.

Font Size

FontSize

Integer

Determines the font size of the text in column values.

Font Style

FontStyle

String

Determines the style of the font of column values.

Grid Line Color

GridColor

Color

Determines the color of the grid line.

Text Color

TextColor

Color

Determines the color of the text.

Background Color

BackgroundColor

Color

Determines the color of the background of the i5Grid.

User Locale Format

UseLocaleFormat

Boolean

Select this checkbox to display the datetime values and number format depending on the user’s locale format.

Date and Time Format

DateFormat

String

Following are the various available combinations used to customize the display of datetime and number format in i5Grids:

  • If datetime and number format are deselected, the default query settings are displayed.

  • If datetime and number format are deselected in the query and in i5Grid Grid Area, the default datetime format (YYYY-MM-DD HH:MM:SS Z) of the server and the number format (upto 3 decimal digits) is displayed.

  • The datetime and number format settings defined in the i5Grid Layout for a specific column take precedence over the settings defined in the i5Grid Grid Area. For other columns, where the settings are not defined in the i5Grid Layout, the default settings from the i5Grid Grid Area are considered to render the grid.

Note Note

The standard date and time format, which is overridden when the User Locale Format checkbox is selected.

End of the note.

Number Format

NumberFormat

String

The standard number format, which is overridden when the User Locale Format checkbox is selected.

For more information on datetime and number format, see Date and Time Format.

Show Horizontal Grid

ShowHorizontalGrid

Boolean

Select this checkbox to display the horizontal grid.

Show Vertical Grid

ShowVerticalGrid

Boolean

Select this checkbox to display the vertical grid.

Show Scroll Bar

ShowScrollBar

Boolean

Displays the vertical scroll bar when there are a large number of rows.

Show Horizontal Scroll Bar

ShowHorizontalScrollBar

Boolean

Displays the horizontal scroll bar when there are a large number of columns.

Show Row Header

ShowRowHeader

Boolean

Displays an additional column for each row with the descriptions provided in the Row Headings. For more information on row headings, see i5Grid Row Heading.

Activities

You set the above properties for your grid template on the Grid Area screen in the SAP MII Workbench. You can change the parameter values using web page scripting. For more information, see Web Page Scripting for i5Grids.