Manual > Appendix > Number Formats > Number Formats (System Formats)

About system formats

This page explains the specifications regarding the "system format" of numeric formats.

The system format for number format is a number format that is pre-prepared within the FA-Server system.

The system formats available are as follows:

(System format type)

type	Number Format Name	Contents
Default format	@NUMBER	This is the default format (recommended). This format inherits all the properties of @LOCALE internally, and will behave the same as @LOCALE unless customized by a user format.
ANSI format	@ANSI	The standard format (@ANSI) is a universal format that is not affected by locale. For @ANSI, the decimal point character is a period "." and the separator is a comma "," every three digits. Example) @ANSI 12345.678 Example: @ANSI.S 12,345.678
ISO format	@ISO	The standard format (@ISO) is a universal format that is not affected by locale. For @ISO, the decimal point is a comma "," and the separator is a space every three digits. Example: @ISO 12345,678 Example: @ISO.S 12 345,678
Regional format (auto-switching)	@LOCALE	If you specify this format, the operation will be according to the locale setting set in the Locale root property (or the LocaleNumber root property).
Region format (fixed)	@ja, @en, etc.	This format is used when you want to directly specify a country-specific format, regardless of the Locale root property setting. To specify, use the locale ID that indicates the country, such as ja (Japan) or en (English), after "@".
Binary format	@BIN	This is the format for displaying numbers in binary.
Octal format	@OCT	This is the format for displaying numbers in octal.
Hexadecimal format	@HEX	This is the format for displaying numbers in hexadecimal.

When specifying the number format using the system format, you can specify any option by adding it to the end of the number format name such as "@NUMBER".

By adding options, it is possible to define more detailed operations.

Example: If the OS language setting is Japanese and the Locale property of root is "DEFAULT"

@NUMBER 12345.678

@NUMBER.2 ... 12345.68 *2 decimal places

@NUMBER.2S ... 12,345.68 *With two decimal places, a separator "," is added

@NUMBER ... ABC12345.678 *Example of adding a header using properties

For more information about options, see "Number format options and properties".

Default format (@NUMBER)

Format: @NUMBER[.Option format]<Property format>

The default format (@NUMBER) is an internal format that inherits the specifications of @LOCALE, and will behave the same as @LOCALE unless customized by a user format definition (overridden by the NumberFormatConf root property).

Example of specifying number format	Display example
@NUMBER	12345.678
@NUMBER.2	12345.68
@NUMBER.2S	12,345.68
@NUMBER.2SP	+12,345.68

*The display example in the above table is an example when the OS language setting is Japanese and the Locale property of root is "DEFAULT".

*The above table is just an example. By specifying other options, you can support various formats. For details about options, see "Number format options and properties".

When specifying a format, you can specify multiple properties by separating each property with a semicolon, like so: . You can also specify a list of <> pairs, like so: ...

When listing <> pairs, make sure not to put any characters between the <> (spaces are also not allowed).

ANSI format (@ANSI)

Format: @ANSI[.Option format]<Property format>

The standard format (@ANSI) is a universal format that is not affected by locale.

In @ANSI, the decimal point is a period "." and the separator is a comma "," every three digits.

Example of specifying number format	Display example
@ANSI	12345.678
@ANSI.2	12345.68
@ANSI.2S	12,345.68

*The display examples in the above table will be displayed in the same way regardless of the OS language settings or the settings of the root Locale property (or LocaleNumber property).

*You can also specify options for @ANSI. For details about options, see "Number format options and properties".

ISO format (@ISO)

Format: @ISO[.Option format]<Property format>

The standard format (@ISO) is a universal format that is not affected by locale.

In @ISO, the decimal point is a comma "," and the separator is a space separated every three digits.

Example of specifying number format	Display example
@ISO	12345,678
@ISO.2	12345,68
@ISO.2S	12 345,68

*The display examples in the above table will be displayed in the same way regardless of the OS language settings or the settings of the root Locale property (or LocaleNumber property).

*You can also specify options for @ISO. For details about options, see "Number format options and properties".

Regional format (auto-switch) (@LOCALE)

Format: @LOCALE[.option format]<property format>

Regional formatting (automatic switching) operates according to the locale setting set in the Locale root property (or the LocaleNumber root property).

For example, if you set the Locale root property (or the LocaleNumber root property) to "DEFAULT", the display will follow the OS settings.

Alternatively, if you set the Locale root property (or the LocaleNumber root property) to "en", the display will be in "en" (English) regardless of the OS settings.

Example of specifying number format	Display example
@LOCALE	12345.678
@LOCALE.2	12345.68
@LOCALE.2S	12,345.68

*The display example in the above table is an example when the OS language setting is Japanese and the Locale property of root (or the LocaleNumber root property) is "DEFAULT".

*You can also specify options for @LOCALE. For details about options, see "Number format options and properties".

Regional format (fixed) (@ja, @en, etc.)

Format: @[Locale ID][.Option format]<Property format>

The fixed regional format directly specifies the locale using a "locale ID" that represents the region of each country, such as ja (Japan) or en (English).

Regardless of the setting of the Locale root property (or the LocaleNumber root property) or the OS settings, the content will be displayed in the regional specifications of the specified locale ID.

Example of specifying number format	Display example
@ja	12345.678
@ja.2	12345.68
@ja.2S	12,345.68
@de	12345,678
@de.2	12345,68
@de.2S	12.345,68

*For details about the locale IDs that can be specified in the table above, see "About locale IDs".

*You can also specify options for the fixed regional format. For details about options, see "Number format options and properties".

Binary format (@BIN)

Format: @BIN[.Option format]<Property format>

Binary format (@BIN) is a format for displaying numbers in binary.

Example of specifying number format	Display example
@NUMBER	65535
@BIN	1111111111111111
@BIN.L16S8	11111111 11111111
@BIN.L32S4	0000 0000 0000 0000 1111 1111 1111 1111
@BIN.L32S8	00000000 00000000 11111111 11111111
@BIN.L32S16	0000000000000000 1111111111111111

*You can also specify options for the binary format (@BIN). For details about options, see "Number format options and properties".

Octal format (@OCT)

Format: @OCT[.Option format]<Property format>

Octal format (@OCT) is a format for displaying numbers in octal notation.

Example of specifying number format	Display example
@NUMBER	65535
@OCT	177777
@OCT.S4	17 7777
@OCT.S3L12	000 000 177 777

*You can also specify options for the octal format (@OCT). For details about options, see "Number format options and properties".

Hexadecimal format (@HEX)

Format: @HEX[.Option format]<Property format>

Hexadecimal format (@HEX) is a format for displaying numbers in hexadecimal.

Example of specifying number format	Display example
@NUMBER	4294967295
@HEX	FFFFFFFF
@HEX.L16	00000000FFFFFFFF
@HEX.L16S4	0000 0000 FFFF FFFF
@HEX.L16S8	00000000 FFFFFFFF

*You can also specify options for the hexadecimal format (@HEX). For details about options, see "Number format options and properties".

Number format (system format)

Number format (system format)