TdxSpreadSheetFunctionType Enum

Enumerates available categories in the functions repository.

Declaration

TdxSpreadSheetFunctionType = (
    ftCommon,
    ftCompatibility,
    ftDateTime,
    ftMath,
    ftFinancial,
    ftInformation,
    ftLookupAndReference,
    ftLogical,
    ftStatistical,
    ftText,
    ftCube,
    ftDatabase,
    ftEngineering
);

Members

Name
`ftCommon`
`ftCompatibility`
`ftDateTime`
`ftMath`
`ftFinancial`
`ftInformation`
`ftLookupAndReference`
`ftLogical`
`ftStatistical`
`ftText`
`ftCube`
`ftDatabase`
`ftEngineering`

Remarks

Options include:

Value	End-User Command	Description
ftCommon	–	The default option. The registered function belongs to no category found in popular spreadsheet applications.
ftCompatibility	CompatibilityFormulasGallery	The registered function belongs to the group that contains the all function tokens found in Microsoft Excel® 2010 and later under the “Compatibility” category. The compatibility functions are considered deprecated, and the functions repository retains them to maintain backward compatibility with old spreadsheet applications and their document formats (BIFF8 and newer). Other categories contain new counterpart functions that have replaced all functions in this category.
ftDateTime	DateAndTimeFormulasGallery	The registered function belongs to the group that contains all function tokens found in Microsoft Excel® under the “Date and time” category. The date and time functions can return the current date and time and perform calendar-related calculations on date/time values.
ftMath	MathAndTrigFormulasGallery	The registered function belongs to the group that contains all function tokens found in Microsoft Excel® under the “Math and trigonometry” category. The math functions include basic arithmetic, conditional sums and products, trigonometric calculations, etc.
ftFinancial	FinancialFormulasGallery	The registered function belongs to the group that contains all function tokens found in Microsoft Excel® under the “Financial” category. The financial functions perform many finance-related calculations, such as yield calculations, interest rates, investment variations, internal rate of return, payments and asset depreciation.
ftInformation	InformationFormulasGallery	The registered function belongs to the group that contains all function tokens found in Microsoft Excel® under the “Information” category. The information functions return the status of a cell or its content.
ftLookupAndReference	LookupAndReferenceFormulasGallery	The registered function belongs to the group that contains all function tokens found in Microsoft Excel® under the “Lookup and reference” category. The lookup and reference functions are designed to work with data arrays (vector columns, rows, and rectangular cell ranges). The group includes functions that search specific values at defined conditions, transpose matrices, and compare cell ranges. Note Due to the parameter and calculated result data format limitations, all lookup and reference functions are not available for use in calculated field expressions. The “Expression Editor“ does not list this function category.
ftLogical	LogicalFormulasGallery	The registered function belongs to the group that contains all function tokens found in Microsoft Excel® under the “Logical” category. The logical functions include Boolean operators, conditional tests and functions that return constant logical values.
ftStatistical	StatisticalFormulasGallery	The registered function belongs to the category that contains all function tokens found in Microsoft Excel® under the “Statistical” category. Statistical functions perform most of the common statistical operations, from basic mean and mode calculations to the more complex statistical distribution and probability tests.
ftText	TextFormulasGallery	The registered function belongs to the group that contains all function tokens found in Microsoft Excel® under the “Text” category. The text functions are designed to work with strings. You can use them to change cell value formatting, concatenate strings, search certain text, convert strings to upper- or lowercase, etc.
ftCube	–	The registered function belongs to the group that contains all function tokens found in Microsoft Excel® under the “Cube” category. These functions are designed to work with OLAP cubes. The function repository uses this reserved enumeration value to register all “Cube” category function tokens as “empty” function signatures (that is, without assigned implementation routines) to ensure compatibility with Microsoft Excel® spreadsheet documents that can contain these functions.
ftDataBase	–	The registered function belongs to the group that contains all function tokens found in Microsoft Excel® under the “Database” category. These functions are designed to work with the connected database’s entries. The function repository uses this reserved enumeration value to register all “Database” function tokens as “empty” function signatures (that is, without assigned implementation routines) to ensure compatibility with Microsoft Excel® spreadsheet documents that can contain these functions. Note Database functions are not available for use in calculated field expressions. The “Expression Editor“ does not list this function category.
ftEngineering	–	The registered function belongs to the group that contains all function tokens found in Microsoft Excel® under the “Engineering” category. These functions convert cell values between various notations, perform bitwise calculations, etc. The function repository uses this reserved enumeration value to register all “Engineering” function tokens as “empty” function signatures (that is, without assigned implementation routines) to ensure compatibility with Microsoft Excel® spreadsheet documents that can contain these functions.