Class Excel2007Function

Represents functions added in Excel 2007.

Inheritance

System.Object

Excel2007Function

Namespace: Syncfusion.XlsIO

Assembly: Syncfusion.XlsIO.NET.dll

Syntax

public sealed class Excel2007Function : Enum

Fields

AVERAGEIF

Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria

Declaration

public const Excel2007Function AVERAGEIF

Field Value

Type
Excel2007Function

AVERAGEIFS

Returns the average (arithmetic mean) of all cells that meet multiple criteria.

Declaration

public const Excel2007Function AVERAGEIFS

Field Value

Type
Excel2007Function

BESSELI

Returns the modified Bessel function In(x).

Declaration

public const Excel2007Function BESSELI

Field Value

Type
Excel2007Function

BESSELJ

Returns the Bessel function Jn(x).

Declaration

public const Excel2007Function BESSELJ

Field Value

Type
Excel2007Function

BESSELK

Returns the modified Bessel function Kn(x).

Declaration

public const Excel2007Function BESSELK

Field Value

Type
Excel2007Function

BESSELY

Returns the Bessel function Yn(x).

Declaration

public const Excel2007Function BESSELY

Field Value

Type
Excel2007Function

BIN2DEC

Converts a binary number to decimal.

Declaration

public const Excel2007Function BIN2DEC

Field Value

Type
Excel2007Function

BIN2HEX

Converts a binary number to hexadecimal.

Declaration

public const Excel2007Function BIN2HEX

Field Value

Type
Excel2007Function

BIN2OCT

Converts a binary number to octal.

Declaration

public const Excel2007Function BIN2OCT

Field Value

Type
Excel2007Function

COMPLEX

Converts real and imaginary coefficients into a complex number.

Declaration

public const Excel2007Function COMPLEX

Field Value

Type
Excel2007Function

CONVERT

Converts a number from one measurement system to another.

Declaration

public const Excel2007Function CONVERT

Field Value

Type
Excel2007Function

CUBEKPIMEMBER

Returns a key performance indicator (KPI) name, property, and measure, and displays the name and property in the cell. A KPI is a quantifiable measurement, such as monthly gross profit or quarterly employee turnover, used to monitor an organization's performance.

Declaration

public const Excel2007Function CUBEKPIMEMBER

Field Value

Type
Excel2007Function

CUBEMEMBER

Returns a member or tuple in a cube hierarchy. Use to validate that the member or tuple exists in the cube.

Declaration

public const Excel2007Function CUBEMEMBER

Field Value

Type
Excel2007Function

CUBEMEMBERPROPERTY

Returns the value of a member property in the cube. Use to validate that a member name exists within the cube and to return the specified property for this member.

Declaration

public const Excel2007Function CUBEMEMBERPROPERTY

Field Value

Type
Excel2007Function

CUBERANKEDMEMBER

Returns the nth, or ranked, member in a set. Use to return one or more elements in a set, such as the top sales performer or top 10 students.

Declaration

public const Excel2007Function CUBERANKEDMEMBER

Field Value

Type
Excel2007Function

CUBESET

Defines a calculated set of members or tuples by sending a set expression to the cube on the server, which creates the set, and then returns that set to Microsoft Office Excel.

Declaration

public const Excel2007Function CUBESET

Field Value

Type
Excel2007Function

CUBESETCOUNT

Returns the number of items in a set.

Declaration

public const Excel2007Function CUBESETCOUNT

Field Value

Type
Excel2007Function

CUBEVALUE

Returns an aggregated value from a cube.

Declaration

public const Excel2007Function CUBEVALUE

Field Value

Type
Excel2007Function

DEC2BIN

Converts a decimal number to binary.

Declaration

public const Excel2007Function DEC2BIN

Field Value

Type
Excel2007Function

DEC2HEX

Converts a decimal number to hexadecimal.

Declaration

public const Excel2007Function DEC2HEX

Field Value

Type
Excel2007Function

DEC2OCT

Converts a decimal number to octal.

Declaration

public const Excel2007Function DEC2OCT

Field Value

Type
Excel2007Function

DELTA

Tests whether two values are equal.

Declaration

public const Excel2007Function DELTA

Field Value

Type
Excel2007Function

ERF

Returns the error function.

Declaration

public const Excel2007Function ERF

Field Value

Type
Excel2007Function

ERFC

Returns the complementary error function.

Declaration

public const Excel2007Function ERFC

Field Value

Type
Excel2007Function

GESTEP

Tests whether a number is greater than a threshold value.

Declaration

public const Excel2007Function GESTEP

Field Value

Type
Excel2007Function

HEX2BIN

Converts a hexadecimal number to binary.

Declaration

public const Excel2007Function HEX2BIN

Field Value

Type
Excel2007Function

HEX2DEC

Converts a hexadecimal number to decimal.

Declaration

public const Excel2007Function HEX2DEC

Field Value

Type
Excel2007Function

HEX2OCT

Converts a hexadecimal number to octal.

Declaration

public const Excel2007Function HEX2OCT

Field Value

Type
Excel2007Function

IMABS

Returns the absolute value (modulus) of a complex number.

Declaration

public const Excel2007Function IMABS

Field Value

Type
Excel2007Function

IMAGINARY

Returns the imaginary coefficient of a complex number.

Declaration

public const Excel2007Function IMAGINARY

Field Value

Type
Excel2007Function

IMARGUMENT

Returns the argument theta, an angle expressed in radians.

Declaration

public const Excel2007Function IMARGUMENT

Field Value

Type
Excel2007Function

IMCONJUGATE

Returns the complex conjugate of a complex number.

Declaration

public const Excel2007Function IMCONJUGATE

Field Value

Type
Excel2007Function

IMCOS

Returns the cosine of a complex number

Declaration

public const Excel2007Function IMCOS

Field Value

Type
Excel2007Function

IMDIV

Returns the quotient of two complex numbers.

Declaration

public const Excel2007Function IMDIV

Field Value

Type
Excel2007Function

IMEXP

Returns the exponential of a complex number.

Declaration

public const Excel2007Function IMEXP

Field Value

Type
Excel2007Function

IMLN

Returns the natural logarithm of a complex number.

Declaration

public const Excel2007Function IMLN

Field Value

Type
Excel2007Function

IMLOG10

Returns the base-10 logarithm of a complex number.

Declaration

public const Excel2007Function IMLOG10

Field Value

Type
Excel2007Function

IMLOG2

Returns the base-2 logarithm of a complex number.

Declaration

public const Excel2007Function IMLOG2

Field Value

Type
Excel2007Function

IMPOWER

Returns a complex number raised to an integer power.

Declaration

public const Excel2007Function IMPOWER

Field Value

Type
Excel2007Function

IMPRODUCT

Returns the product of from 2 to 29 complex numbers

Declaration

public const Excel2007Function IMPRODUCT

Field Value

Type
Excel2007Function

IMREAL

Returns the real coefficient of a complex number

Declaration

public const Excel2007Function IMREAL

Field Value

Type
Excel2007Function

IMSIN

Returns the sine of a complex number

Declaration

public const Excel2007Function IMSIN

Field Value

Type
Excel2007Function

IMSQRT

Returns the square root of a complex number

Declaration

public const Excel2007Function IMSQRT

Field Value

Type
Excel2007Function

IMSUB

Returns the difference between two complex numbers

Declaration

public const Excel2007Function IMSUB

Field Value

Type
Excel2007Function

IMSUM

Returns the sum of complex numbers.

Declaration

public const Excel2007Function IMSUM

Field Value

Type
Excel2007Function

OCT2BIN

Converts an octal number to binary.

Declaration

public const Excel2007Function OCT2BIN

Field Value

Type
Excel2007Function

OCT2DEC

Converts an octal number to decimal.

Declaration

public const Excel2007Function OCT2DEC

Field Value

Type
Excel2007Function

OCT2HEX

Converts an octal number to hexadecimal.

Declaration

public const Excel2007Function OCT2HEX

Field Value

Type
Excel2007Function

SUMIFS

Adds the cells in a range that meet multiple criteria

Declaration

public const Excel2007Function SUMIFS

Field Value

Type
Excel2007Function