Share via

2.4.1.4 Control Data Formatting

  • Article

This section specifies the rules that MUST be used for formatting data in controls.

DATA_FMT_LOCALE_VAL: MUST be an LCID.

DATA_FMT_LOCALE: locale:DATA_FMT_LOCALE_VAL

DATA_FMT_NUM_DIGITS: [0-9] | auto. See numDigits in section 2.4.2.11.

DATA_FMT_GROUPING: -1 | [0-9] | 32. See grouping in section 2.4.2.11.

DATA_FMT_DECIMAL_SEP: . | , | space_char. See decimalSep in section 2.4.2.11.

DATA_FMT_THOUSAND_SEP: . | , | space_char. See thousandSep in section 2.4.2.11.

DATA_FMT_NEG_ORDER: See negativeOrder in section 2.4.2.11.

DATA_FMT_POS_ORDER: See positiveOrder in section 2.4.2.11.

DATA_FMT_CUR_LOCALE: currencyLocale:DATA_FMT_LOCALE_VAL

DATA_FMT_DATE_FORMAT_CUSTOM: See dateFormat in section 2.4.2.11.

DATA_FMT_DATE_FORMAT: Short Date | Long Date | Year Month | none | DATA_FMT_DATE_FORMAT_CUSTOM

DATA_FMT_ALT_CAL: 0 | 1. See useAltCalendar in section 2.4.2.11.

DATA_FMT_EN_STR: 0 | 1. See englishStringOnly in section 2.4.2.11.

DATA_FMT_TIME_FORMAT_CUSTOM: See timeFormat in section 2.4.2.11.

DATA_FMT_TIME_FORMAT: Short Time | Long Time | none | DATA_FMT_TIME_FORMAT_CUSTOM

DATA_FMT_NOSECONDS: 0 | 1. See noSeconds in section 2.4.2.11.

DATA_FMT_CAT_STRING: "string", "plainMutiline"

DATA_FMT_CAT_PERCENTAGE: "percentage","semicolon delimited list of (DATA_FMT_LOCALE?, DATA_FMT_NUM_DIGITS, DATA_FMT_GROUPING?, DATA_FMT_DECIMAL_SEP?, DATA_FMT_THOUSAND_SEP?, DATA_FMT_NEG_ORDER)"

DATA_FMT_CAT_NUMBER: "number","semicolon delimited list of (DATA_FMT_LOCALE?, DATA_FMT_NUM_DIGITS, DATA_FMT_GROUPING?, DATA_FMT_DECIMAL_SEP?, DATA_FMT_THOUSAND_SEP?, DATA_FMT_NEG_ORDER)"

DATA_FMT_CAT_DATETIME: "datetime","semicolon delimited list of (DATA_FMT_LOCALE?, DATA_FMT_DATE_FORMAT, DATA_FMT_ALT_CAL?, DATA_FMT_EN_STR?, DATA_FMT_TIME_FORMAT, DATA_FMT_NOSECONDS?)"

DATA_FMT_CAT_DATE: "date","semicolon delimited list of (DATA_FMT_LOCALE?, DATA_FMT_DATE_FORMAT, DATA_FMT_ALT_CAL?, DATA_FMT_EN_STR?)"

DATA_FMT_CAT_TIME: "time","semicolon delimited list of (DATA_FMT_LOCALE?, DATA_FMT_TIME_FORMAT, DATA_FMT_NOSECONDS?)"

DATA_FMT_CTRL_DATE_PICKER: DATA_FMT_CAT_DATE or DATA_FMT_CAT_DATETIME.

DATA_FMT_CTRL_EXPBOX: DATA_FMT_CAT_TIME or DATA_FMT_CAT_DATE or DATA_FMT_CAT_DATETIME or DATA_FMT_CAT_NUMBER or DATA_FMT_CAT_PERCENTAGE.

DATA_FMT_CTRL_TEXTBOX: DATA_FMT_CTRL_EXPBOX