Enum FunctionCategory

Categorizes spreadsheet functions by domain (Financial, DateTime, MathTrig, Statistical, etc.) for organizational and discovery purposes.

Namespace: Telerik.Windows.Documents.Spreadsheet.Expressions.Functions

Assembly: Telerik.Windows.Documents.Spreadsheet.dll

Syntax

public enum FunctionCategory

DateTime

Date and time functions for parsing, formatting, and calculating with dates and times.

Engineering

Engineering functions for complex numbers, base conversions, and Bessel calculations.

Financial

Financial functions for loans, investments, depreciation, and securities calculations.

Information

Information functions for querying cell types, values, and error states.

Logical

Logical functions for boolean operations and conditional evaluation (AND, OR, IF, NOT).

LookupReference

Lookup and reference functions for searching, matching, and navigating cell ranges.

MathTrig

Mathematical and trigonometric functions for arithmetic, rounding, and trigonometry operations.

Statistical

Statistical functions for data analysis including averages, distributions, and variance calculations.

Text

Text functions for string manipulation, concatenation, parsing, and formatting.