Value Format

<< Click to Display Table of Contents >>

 

Value Format

Using formats allows users to change how data is displayed, without changing the value behind them. A format is a text that can be either edited manually or configured via format dialog box. Its usage is similar to formats used in spreadsheets, following the same basic syntax, but with a few extensions. The following data types are supported:

Number (decimal, scientific, hexadecimal, binary, or octal output)

Text

Boolean

Date and Time (Gregorian calendar)

 

The objects that support formats must change their data types in their Value property, according to the intended format type.

Value Format window

Value Format window

The following formats are available:

General: There is no specific format. It is performed automatically, depending on data type

Number: Presents integers and fractions, allowing users to define the number of decimals and the use of commas to separate thousands. For numbers that are either too big or too small, use the Scientific format. The symbols are the ones defined on Control Panel - Regional Configuration

Date and Time: Presents numerical values (Gregorian format) for date and time, when they are valid

Percent: Multiplies a number by 100 and adds the percent symbol to it, also defining the number of decimals

Scientific: This format presents a number with a mantissa and an exponent, ideal for numbers of different magnitudes, allowing users to select the number of decimals and formats

Special: Allows formatting integers in non-decimal bases (hexadecimal, octal, or binary)

Was this page useful?