New to Telerik Document Processing? Start a free 30-day trial

FunctionCategory

Enum

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

Definition

Assembly:Telerik.Windows.Documents.Spreadsheet.dll

Syntax:

public enum FunctionCategory

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

DateTime = 1

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

Engineering = 8

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

Financial = 0

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

Information = 7

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

Logical = 6

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

LookupReference = 4

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

MathTrig = 2

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

Statistical = 3

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

Text = 5