Format Settings
Panel used to set the formats to parse and display numbers, dates and boolean values in Matrex.
Decimal pattern is
the format used to parse numbers.
Decimal separator
and grouping separator
tell which characters are used as decimal and grouping separators.
Dates
are parsed using the Date
Time Pattern if they contain both a date and a time part,
using the Only Date
Pattern if they contain only a date part, using the Only Time Pattern if
they contain only a time part.
The parser tries to apply all
of these formats when parsing dates.
Text For True
is the text used to represent the true boolean values as a text, both
for parsing (parsing is independent by the letter case) and to display
the value.
If strict
parsing
is selected, errors parsing dates and numbers are reported to the
users, otherwise parsing text that is not parsable returns 0 for
numbers and a zero-equivalent date (1-1-1970) for dates.