menu

UWP

  • Code Examples
  • Upgrade Guide
  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Class Excel2007Function - UWP API Reference | Syncfusion

    Show / Hide Table of Contents

    Class Excel2007Function

    Represents functions added in Excel 2007.

    Inheritance
    System.Object
    Excel2007Function
    Namespace: Syncfusion.XlsIO
    Assembly: Syncfusion.XlsIO.UWP.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

    Extension Methods

    DateTimeExtension.ToDateTime(Object)
    Back to top Generated by DocFX
    Copyright © 2001 - 2025 Syncfusion Inc. All Rights Reserved