Constants |
NUMBER_START |
Start of simple numerical formats (first format) |
NUMBER_STANDARD |
The "General" standard format formatindex="0" |
NUMBER_INT |
0 Integer number formatindex="1" |
NUMBER_DEC2 |
0.00 Decimal number with 2 decimals formatindex="2" |
NUMBER_1000INT |
#,##0 Integer number with group separator formatindex="3" |
NUMBER_1000DEC2 |
#,##0.00 Decimal number with group separator formatindex="4" |
NUMBER_SYSTEM |
#,##0.00 In SO5/Win this format was retrieved from the Regional Settings formatindex="5" |
NUMBER_END |
End of simple numerical formats (last format) |
SCIENTIFIC_START |
Start of Scientific formats (first format) |
SCIENTIFIC_000E000 |
0.00E+000 Number in scientific notation with exponent in 3 digit placeholders formatindex="6" |
SCIENTIFIC_000E00 |
0.00E+00 Number in scientific notation with exponent in 2 digit placeholders formatindex="7" |
SCIENTIFIC_END |
End of Scientific formats (last format) |
PERCENT_START |
Start of Percent formats (first format) |
PERCENT_INT |
0% Percentage format, rounded to integer formatindex="8" |
PERCENT_DEC2 |
0.00% Percentage format, rounded to 2 decimals formatindex="9" |
PERCENT_END |
End of Percent formats (last format) |
FRACTION_START |
Start of Fraction formats (first format) |
FRACTION_1 |
# ?/? Number with decimal in fraction in 1 digit placeholder formatindex="10" |
FRACTION_2 |
# ??/?? Number with decimal in fraction in 2 digit placeholders formatindex="11" |
FRACTION_END |
End of Fraction formats (last format) |
CURRENCY_START |
Start of Currency formats (first format) |
CURRENCY_1000INT |
#,##0 DM Integer currency format with group separator formatindex="12" |
CURRENCY_1000DEC2 |
#,##0.00 DM Decimal currency format with group separator formatindex="13" |
CURRENCY_1000INT_RED |
#,##0 DM Integer currency format with negative in red formatindex="14" |
CURRENCY_1000DEC2_RED |
#,##0.00 DM Decimal currency format with negative in red formatindex="15" |
CURRENCY_1000DEC2_CCC |
#,##0.00 DEM Currency in ISO-4217 abbreviation format formatindex="16" |
CURRENCY_1000DEC2_DASHED |
#,##0.-- DM Currency format with dash representing 0 in decimals formatindex="17" |
CURRENCY_END |
End of Currency formats (last format) |
DATE_START |
Start of Date formats (first format) |
DATE_SYSTEM_SHORT |
08.10.97 see also DATE_SYSTEM_... explanation formatindex="18" |
DATE_SYSTEM_LONG |
Wednesday, 8. October 1997 see also DATE_SYSTEM_... explanation
formatindex="19" |
DATE_SYS_DDMMYY |
08.10.97 see also DATE_SYS_... explanation formatindex="20" |
DATE_SYS_DDMMYYYY |
08.10.1997 see also DATE_SYS_... explanation
Note: When editing already existing date data this
format is forced in order to always edit the full century.
formatindex="21" |
DATE_SYS_DMMMYY |
8. Oct 97 see also DATE_SYS_... explanation formatindex="22" |
DATE_SYS_DMMMYYYY |
8. Oct 1997 see also DATE_SYS_... explanation formatindex="23" |
DATE_DIN_DMMMYYYY |
8. Oct. 1997 DIN/EN formatindex="24" |
DATE_SYS_DMMMMYYYY |
8. October 1997 see also DATE_SYS_... explanation formatindex="25" |
DATE_DIN_DMMMMYYYY |
8. October 1997 DIN/EN formatindex="26" |
DATE_SYS_NNDMMMYY |
Wed, 8. Oct 97 see also DATE_SYS_... explanation formatindex="27" |
DATE_DEF_NNDDMMMYY |
Wed 08.Oct 97 see also DATE_DEF_... explanation formatindex="28" |
DATE_SYS_NNDMMMMYYYY |
Wed, 8. October 1997 see also DATE_SYS_... explanation formatindex="29" |
DATE_SYS_NNNNDMMMMYYYY |
Wednesday, 8. October 1997 formatindex="30" |
DATE_DIN_MMDD |
10-08 DIN/EN formatindex="31" |
DATE_DIN_YYMMDD |
97-10-08 DIN/EN formatindex="32" |
DATE_DIN_YYYYMMDD |
1997-10-08 DIN/EN/ISO formatindex="33" |
DATE_SYS_MMYY |
10.97 see also DATE_SYS_... explanation formatindex="34" |
DATE_SYS_DDMMM |
08.Oct see also DATE_SYS_... explanation formatindex="35" |
DATE_MMMM |
October formatindex="36" |
DATE_QQJJ |
4th quarter 97 formatindex="37" |
DATE_WW |
week of year formatindex="38" |
DATE_END |
End of Date formats (last format) |
TIME_START |
Start of Time formats (first format) |
TIME_HHMM |
HH:MM Time format with hour and minute formatindex="39" |
TIME_HHMMSS |
HH:MM:SS Time format with hour, minute and second formatindex="40" |
TIME_HHMMAMPM |
HH:MM AM/PM Time format with hour, minute and morning/afternoon notation formatindex="41" |
TIME_HHMMSSAMPM |
HH:MM:SS AM/PM Time format with hour, minute, second and morning/afternoon notation formatindex="42" |
TIME_HH_MMSS |
[HH]:MM:SS Time format with amount of hours formatindex="43" |
TIME_MMSS00 |
MM:SS,00 Time format with second in fraction formatindex="44" |
TIME_HH_MMSS00 |
[HH]:MM:SS,00 Time format with amount of hours and seconds with fraction formatindex="45" |
TIME_END |
End of Time formats (last format) |
DATETIME_START |
Start of DateTime formats (first format) |
DATETIME_SYSTEM_SHORT_HHMM |
08.10.97 01:23 Date/time format formatindex="46" |
DATETIME_SYS_DDMMYYYY_HHMMSS |
08.10.1997 01:23:45 Date/time format with second
Note: When editing already existing date/time data this
format is forced in order to always edit the full century.
formatindex="47" |
DATETIME_END |
End of DateTime formats (last format) |
BOOLEAN |
BOOLEAN format
@attention
Not defined in locale data, but generated by the number
formatter. If you want to access this format you MUST
do it via com::sun::star::util::XNumberFormatTypes::getFormatIndex()
instead of XNumberFormatCode::getFormatCode().
reserved formatindex="48"
|
TEXT |
Text format
@attention
Not defined in locale data, but generated by the number
formatter. If you want to access this format you MUST
do it via com::sun::star::util::XNumberFormatTypes::getFormatIndex()
instead of XNumberFormatCode::getFormatCode()
reserved formatindex="49"
|
INDEX_TABLE_ENTRIES |
count of built-in format codes. |
Constants' Details |
NUMBER_START
const short NUMBER_START = 0;
- Description
- Start of simple numerical formats (first format)
|
|
NUMBER_STANDARD
const short NUMBER_STANDARD = NUMBER_START;
- Description
- The "General" standard format
formatindex="0"
|
|
NUMBER_INT
const short NUMBER_INT = NUMBER_START+1;
- Description
- 0
Integer number formatindex="1"
|
|
NUMBER_DEC2
const short NUMBER_DEC2 = NUMBER_START+2;
- Description
- 0.00
Decimal number with 2 decimals formatindex="2"
|
|
NUMBER_1000INT
const short NUMBER_1000INT = NUMBER_START+3;
- Description
- #,##0
Integer number with group separator formatindex="3"
|
|
NUMBER_1000DEC2
const short NUMBER_1000DEC2 = NUMBER_START+4;
- Description
- #,##0.00
Decimal number with group separator formatindex="4"
|
|
NUMBER_SYSTEM
const short NUMBER_SYSTEM = NUMBER_START+5;
- Description
- #,##0.00
In SO5/Win this format was retrieved from the Regional Settings formatindex="5"
|
|
NUMBER_END
const short NUMBER_END = NUMBER_SYSTEM ;
- Description
- End of simple numerical formats (last format)
|
|
SCIENTIFIC_START
const short SCIENTIFIC_START = NUMBER_END+1;
- Description
- Start of Scientific formats (first format)
|
|
SCIENTIFIC_000E000
const short SCIENTIFIC_000E000 = SCIENTIFIC_START;
- Description
- 0.00E+000
Number in scientific notation with exponent in 3 digit placeholders formatindex="6"
|
|
SCIENTIFIC_000E00
const short SCIENTIFIC_000E00 = SCIENTIFIC_START+1;
- Description
- 0.00E+00
Number in scientific notation with exponent in 2 digit placeholders formatindex="7"
|
|
SCIENTIFIC_END
const short SCIENTIFIC_END = SCIENTIFIC_000E00;
- Description
- End of Scientific formats (last format)
|
|
PERCENT_START
const short PERCENT_START = SCIENTIFIC_END+1;
- Description
- Start of Percent formats (first format)
|
|
PERCENT_INT
const short PERCENT_INT = PERCENT_START;
- Description
- 0%
Percentage format, rounded to integer formatindex="8"
|
|
PERCENT_DEC2
const short PERCENT_DEC2 = PERCENT_START+1;
- Description
- 0.00%
Percentage format, rounded to 2 decimals formatindex="9"
|
|
PERCENT_END
const short PERCENT_END = PERCENT_DEC2;
- Description
- End of Percent formats (last format)
|
|
FRACTION_START
const short FRACTION_START = PERCENT_END+1;
- Description
- Start of Fraction formats (first format)
|
|
FRACTION_1
const short FRACTION_1 = FRACTION_START;
- Description
- # ?/?
Number with decimal in fraction in 1 digit placeholder formatindex="10"
|
|
FRACTION_2
const short FRACTION_2 = FRACTION_START+1;
- Description
- # ??/??
Number with decimal in fraction in 2 digit placeholders formatindex="11"
|
|
FRACTION_END
const short FRACTION_END = FRACTION_2;
- Description
- End of Fraction formats (last format)
|
|
CURRENCY_START
const short CURRENCY_START = FRACTION_END+1;
- Description
- Start of Currency formats (first format)
|
|
CURRENCY_1000INT
const short CURRENCY_1000INT = CURRENCY_START;
- Description
- #,##0 DM
Integer currency format with group separator formatindex="12"
|
|
CURRENCY_1000DEC2
const short CURRENCY_1000DEC2 = CURRENCY_START+1;
- Description
- #,##0.00 DM
Decimal currency format with group separator formatindex="13"
|
|
CURRENCY_1000INT_RED
const short CURRENCY_1000INT_RED = CURRENCY_START+2;
- Description
- #,##0 DM
Integer currency format with negative in red formatindex="14"
|
|
CURRENCY_1000DEC2_RED
const short CURRENCY_1000DEC2_RED = CURRENCY_START+3;
- Description
- #,##0.00 DM
Decimal currency format with negative in red formatindex="15"
|
|
CURRENCY_1000DEC2_CCC
const short CURRENCY_1000DEC2_CCC = CURRENCY_START+4;
- Description
- #,##0.00 DEM
Currency in ISO-4217 abbreviation format formatindex="16"
|
|
CURRENCY_1000DEC2_DASHED
const short CURRENCY_1000DEC2_DASHED = CURRENCY_START+5;
- Description
- #,##0.-- DM
Currency format with dash representing 0 in decimals formatindex="17"
|
|
CURRENCY_END
const short CURRENCY_END = CURRENCY_1000DEC2_DASHED;
- Description
- End of Currency formats (last format)
|
|
DATE_START
const short DATE_START = CURRENCY_END+1;
- Description
- Start of Date formats (first format)
|
|
DATE_SYSTEM_SHORT
const short DATE_SYSTEM_SHORT = DATE_START;
- Description
- 08.10.97
see also DATE_SYSTEM_... explanation formatindex="18"
|
|
DATE_SYSTEM_LONG
const short DATE_SYSTEM_LONG = DATE_START+1;
- Description
- Wednesday, 8. October 1997
see also DATE_SYSTEM_... explanation
formatindex="19"
|
|
DATE_SYS_DDMMYY
const short DATE_SYS_DDMMYY = DATE_START+2;
- Description
- 08.10.97
see also DATE_SYS_... explanation formatindex="20"
|
|
DATE_SYS_DDMMYYYY
const short DATE_SYS_DDMMYYYY = DATE_START+3;
- Description
- 08.10.1997
see also DATE_SYS_... explanation
Note: When editing already existing date data this
format is forced in order to always edit the full century.
formatindex="21"
|
|
DATE_SYS_DMMMYY
const short DATE_SYS_DMMMYY = DATE_START+4;
- Description
- 8. Oct 97
see also DATE_SYS_... explanation formatindex="22"
|
|
DATE_SYS_DMMMYYYY
const short DATE_SYS_DMMMYYYY = DATE_START+5;
- Description
- 8. Oct 1997
see also DATE_SYS_... explanation formatindex="23"
|
|
DATE_DIN_DMMMYYYY
const short DATE_DIN_DMMMYYYY = DATE_START+6;
- Description
- 8. Oct. 1997
DIN/EN formatindex="24"
|
|
DATE_SYS_DMMMMYYYY
const short DATE_SYS_DMMMMYYYY = DATE_START+7;
- Description
- 8. October 1997
see also DATE_SYS_... explanation formatindex="25"
|
|
DATE_DIN_DMMMMYYYY
const short DATE_DIN_DMMMMYYYY = DATE_START+8;
- Description
- 8. October 1997
DIN/EN formatindex="26"
|
|
DATE_SYS_NNDMMMYY
const short DATE_SYS_NNDMMMYY = DATE_START+9;
- Description
- Wed, 8. Oct 97
see also DATE_SYS_... explanation formatindex="27"
|
|
DATE_DEF_NNDDMMMYY
const short DATE_DEF_NNDDMMMYY = DATE_START+10;
- Description
- Wed 08.Oct 97
see also DATE_DEF_... explanation formatindex="28"
|
|
DATE_SYS_NNDMMMMYYYY
const short DATE_SYS_NNDMMMMYYYY = DATE_START+11;
- Description
- Wed, 8. October 1997
see also DATE_SYS_... explanation formatindex="29"
|
|
DATE_SYS_NNNNDMMMMYYYY
const short DATE_SYS_NNNNDMMMMYYYY = DATE_START+12;
- Description
- Wednesday, 8. October 1997
formatindex="30"
|
|
DATE_DIN_MMDD
const short DATE_DIN_MMDD = DATE_START+13;
- Description
- 10-08
DIN/EN formatindex="31"
|
|
DATE_DIN_YYMMDD
const short DATE_DIN_YYMMDD = DATE_START+14;
- Description
- 97-10-08
DIN/EN formatindex="32"
|
|
DATE_DIN_YYYYMMDD
const short DATE_DIN_YYYYMMDD = DATE_START+15;
- Description
- 1997-10-08
DIN/EN/ISO formatindex="33"
|
|
DATE_SYS_MMYY
const short DATE_SYS_MMYY = DATE_START+16;
- Description
- 10.97
see also DATE_SYS_... explanation formatindex="34"
|
|
DATE_SYS_DDMMM
const short DATE_SYS_DDMMM = DATE_START+17;
- Description
- 08.Oct
see also DATE_SYS_... explanation formatindex="35"
|
|
DATE_MMMM
const short DATE_MMMM = DATE_START+18;
- Description
- October
formatindex="36"
|
|
DATE_QQJJ
const short DATE_QQJJ = DATE_START+19;
- Description
- 4th quarter 97
formatindex="37"
|
|
DATE_WW
const short DATE_WW = DATE_START+20;
- Description
- week of year
formatindex="38"
|
|
DATE_END
const short DATE_END = DATE_WW;
- Description
- End of Date formats (last format)
|
|
TIME_START
const short TIME_START = DATE_END+1;
- Description
- Start of Time formats (first format)
|
|
TIME_HHMM
const short TIME_HHMM = TIME_START;
- Description
- HH:MM
Time format with hour and minute formatindex="39"
|
|
TIME_HHMMSS
const short TIME_HHMMSS = TIME_START+1;
- Description
- HH:MM:SS
Time format with hour, minute and second formatindex="40"
|
|
TIME_HHMMAMPM
const short TIME_HHMMAMPM = TIME_START+2;
- Description
- HH:MM AM/PM
Time format with hour, minute and morning/afternoon notation formatindex="41"
|
|
TIME_HHMMSSAMPM
const short TIME_HHMMSSAMPM = TIME_START+3;
- Description
- HH:MM:SS AM/PM
Time format with hour, minute, second and morning/afternoon notation formatindex="42"
|
|
TIME_HH_MMSS
const short TIME_HH_MMSS = TIME_START+4;
- Description
- [HH]:MM:SS
Time format with amount of hours formatindex="43"
|
|
TIME_MMSS00
const short TIME_MMSS00 = TIME_START+5;
- Description
- MM:SS,00
Time format with second in fraction formatindex="44"
|
|
TIME_HH_MMSS00
const short TIME_HH_MMSS00 = TIME_START+6;
- Description
- [HH]:MM:SS,00
Time format with amount of hours and seconds with fraction formatindex="45"
|
|
TIME_END
const short TIME_END = TIME_HH_MMSS00;
- Description
- End of Time formats (last format)
|
|
DATETIME_START
const short DATETIME_START = TIME_END + 1;
- Description
- Start of DateTime formats (first format)
|
|
DATETIME_SYSTEM_SHORT_HHMM
const short DATETIME_SYSTEM_SHORT_HHMM = DATETIME_START;
- Description
- 08.10.97 01:23 Date/time format
formatindex="46"
|
|
DATETIME_SYS_DDMMYYYY_HHMMSS
const short DATETIME_SYS_DDMMYYYY_HHMMSS = DATETIME_START+1;
- Description
- 08.10.1997 01:23:45 Date/time format with second
Note: When editing already existing date/time data this
format is forced in order to always edit the full century.
formatindex="47"
|
|
DATETIME_END
const short DATETIME_END = DATETIME_SYS_DDMMYYYY_HHMMSS;
- Description
- End of DateTime formats (last format)
|
|
BOOLEAN
const short BOOLEAN = DATETIME_END+1;
- Description
- BOOLEAN format
@attention
Not defined in locale data, but generated by the number
formatter. If you want to access this format you MUST
do it via com::sun::star::util::XNumberFormatTypes::getFormatIndex()
instead of XNumberFormatCode::getFormatCode().
reserved formatindex="48"
|
|
TEXT
const short TEXT = BOOLEAN+1;
- Description
- Text format
@attention
Not defined in locale data, but generated by the number
formatter. If you want to access this format you MUST
do it via com::sun::star::util::XNumberFormatTypes::getFormatIndex()
instead of XNumberFormatCode::getFormatCode()
reserved formatindex="49"
|
|
INDEX_TABLE_ENTRIES
const short INDEX_TABLE_ENTRIES = TEXT+1;
- Description
- count of built-in format codes.
|
|
Copyright © 2020, The Apache Software Foundation, Licensed under the Apache License, Version 2.0. Apache, the Apache feather logo, Apache OpenOffice and OpenOffice.org are trademarks of The Apache Software Foundation. Other names may be trademarks of their respective owners.