:: com :: sun :: star :: sheet ::

constants group FormulaLanguage

Constants
ODFF Function names and operators as defined by the OASIS OpenDocument Format (ODF) Formula specification (ODFF aka OpenFormula).  
ODF_11 Function names and operators as used in ODF documents prior to the ODFF specification, up to ODF v1.1.  
ENGLISH Function names and operators as used in the English language user interface.  
NATIVE Function names and operators as used in the current native language user interface.  
XL_ENGLISH Function names and operators as used in the English version of Excel. This formula language is also used in VBA formulas.  
OOXML Function names and operators as used in OOXML.
Since LibreOffice 4.2  
API Function names and operators as used with XFunctionAccess and other API context. Names are mostly identical to ENGLISH and ODF_11, but while ENGLISH names can be adapted to UI needs and ODF_11 has to stay error compatible, the API names strive to stay compatible but may get corrected in case of errors. Earlier versions than LibreOffice 5.3 always used ODF_11 in API context.
Since LibreOffice 5.3  
Constants' Details
ODFF
const long ODFF = 0;
Description
Function names and operators as defined by the OASIS OpenDocument Format (ODF) Formula specification (ODFF aka OpenFormula).
ODF_11
const long ODF_11 = 1;
Description
Function names and operators as used in ODF documents prior to the ODFF specification, up to ODF v1.1.
ENGLISH
const long ENGLISH = 2;
Description
Function names and operators as used in the English language user interface.
NATIVE
const long NATIVE = 3;
Description
Function names and operators as used in the current native language user interface.
XL_ENGLISH
const long XL_ENGLISH = 4;
Description
Function names and operators as used in the English version of Excel. This formula language is also used in VBA formulas.
OOXML
const long OOXML = 5;
Description
Function names and operators as used in OOXML.
Since LibreOffice 4.2
API
const long API = 6;
Description
Function names and operators as used with XFunctionAccess and other API context. Names are mostly identical to ENGLISH and ODF_11, but while ENGLISH names can be adapted to UI needs and ODF_11 has to stay error compatible, the API names strive to stay compatible but may get corrected in case of errors. Earlier versions than LibreOffice 5.3 always used ODF_11 in API context.
Since LibreOffice 5.3
Top of Page