@univerjs/engine-formula v0.1.17 • Docs

Class: BaseFunction

Extends

• Disposable

Constructors

new BaseFunction()

new BaseFunction(_name): BaseFunction

Parameters

Returns

BaseFunction

Overrides

Disposable.constructor

Defined in

packages/engine-formula/src/functions/base-function.ts:66 (opens in a new tab)

Properties

Accessors

column

get column(): number

Returns

number

Defined in

packages/engine-formula/src/functions/base-function.ts:86 (opens in a new tab)

name

get name(): IFunctionNames

Returns

IFunctionNames

Defined in

packages/engine-formula/src/functions/base-function.ts:70 (opens in a new tab)

row

get row(): number

Returns

number

Defined in

packages/engine-formula/src/functions/base-function.ts:82 (opens in a new tab)

subUnitId

get subUnitId(): Nullable<string>

Returns

Nullable<string>

Defined in

packages/engine-formula/src/functions/base-function.ts:78 (opens in a new tab)

unitId

get unitId(): Nullable<string>

Returns

Nullable<string>

Defined in

packages/engine-formula/src/functions/base-function.ts:74 (opens in a new tab)

Methods

binarySearch()

binarySearch(
   value, 
   searchArray, 
   resultArray, 
   searchType?): BaseValueObject

Parameters

Returns

BaseValueObject

Defined in

packages/engine-formula/src/functions/base-function.ts:249 (opens in a new tab)

binarySearchExpand()

binarySearchExpand(
   value, 
   searchArray, 
   resultArray, 
   axis, 
   searchType?): undefined | ErrorValueObject | ArrayValueObject

Parameters

Returns

undefined | ErrorValueObject | ArrayValueObject

Defined in

packages/engine-formula/src/functions/base-function.ts:334 (opens in a new tab)

calculate()

calculate(...arg): NodeValueType

Parameters

Returns

NodeValueType

Defined in

packages/engine-formula/src/functions/base-function.ts:135 (opens in a new tab)

calculateCustom()

calculateCustom(...arg): PrimitiveValueType | PrimitiveValueType[][]

Parameters

Returns

PrimitiveValueType | PrimitiveValueType[][]

Defined in

packages/engine-formula/src/functions/base-function.ts:129 (opens in a new tab)

checkArrayType()

checkArrayType(variant): boolean

Parameters

Returns

boolean

Defined in

packages/engine-formula/src/functions/base-function.ts:139 (opens in a new tab)

createReferenceObject()

createReferenceObject(reference, range): ErrorValueObject | BaseReferenceObject

Parameters

Returns

ErrorValueObject | BaseReferenceObject

Defined in

packages/engine-formula/src/functions/base-function.ts:492 (opens in a new tab)

dispose()

dispose(): void

Returns

void

Inherited from

Disposable.dispose

Defined in

packages/core/src/shared/lifecycle.ts:106 (opens in a new tab)

disposeWithMe()

protected disposeWithMe(disposable): IDisposable

Parameters

Returns

IDisposable

Inherited from

Disposable.disposeWithMe

Defined in

packages/core/src/shared/lifecycle.ts:96 (opens in a new tab)

ensureNotDisposed()

protected ensureNotDisposed(): void

Returns

void

Inherited from

Disposable.ensureNotDisposed

Defined in

packages/core/src/shared/lifecycle.ts:100 (opens in a new tab)

equalSearch()

equalSearch(
   value, 
   searchArray, 
   resultArray, 
   isFirst): BaseValueObject

Parameters

Returns

BaseValueObject

Defined in

packages/engine-formula/src/functions/base-function.ts:292 (opens in a new tab)

equalSearchExpand()

equalSearchExpand(
   value, 
   searchArray, 
   resultArray, 
   isFirst, 
   axis): undefined | ErrorValueObject | ArrayValueObject

Parameters

Returns

undefined | ErrorValueObject | ArrayValueObject

Defined in

packages/engine-formula/src/functions/base-function.ts:353 (opens in a new tab)

flattenArray()

flattenArray(variants, ignoreLogicalValuesAndText): BaseValueObject | ArrayValueObject

Parameters

Returns

BaseValueObject | ArrayValueObject

Defined in

packages/engine-formula/src/functions/base-function.ts:427 (opens in a new tab)

fuzzySearch()

fuzzySearch(
   value, 
   searchArray, 
   resultArray, 
   isFirst): BaseValueObject

Parameters

Returns

BaseValueObject

Defined in

packages/engine-formula/src/functions/base-function.ts:302 (opens in a new tab)

fuzzySearchExpand()

fuzzySearchExpand(
   value, 
   searchArray, 
   resultArray, 
   isFirst, 
   axis): undefined | ErrorValueObject | ArrayValueObject

Parameters

Returns

undefined | ErrorValueObject | ArrayValueObject

Defined in

packages/engine-formula/src/functions/base-function.ts:380 (opens in a new tab)

getDefinedName()

getDefinedName(name): null | IDefinedNamesServiceParam

In Excel, to inject a defined name into a function that has positioning capabilities, such as using the INDIRECT function to reference a named range, you can write it as follows: =INDIRECT("DefinedName1")

Parameters

Returns

null | IDefinedNamesServiceParam

Defined in

packages/engine-formula/src/functions/base-function.ts:96 (opens in a new tab)

getIndexNumValue()

getIndexNumValue(indexNum, defaultValue): number | ErrorValueObject

Starting with 1 For instance, The column number (starting with 1 for the left-most column of table_array) that contains the return value. https://support.microsoft.com/en-us/office/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1 (opens in a new tab)

Parameters

Returns

number | ErrorValueObject

Defined in

packages/engine-formula/src/functions/base-function.ts:149 (opens in a new tab)

getMatchTypeValue()

getMatchTypeValue(logicValueObject?): undefined | number

A logical value that specifies 1/TRUE , 0/FALSE, -1, default 1. The difference from getZeroOrOneByOneDefault is that we need to get -1

Parameters

Returns

undefined | number

Defined in

packages/engine-formula/src/functions/base-function.ts:221 (opens in a new tab)

getZeroOrOneByOneDefault()

getZeroOrOneByOneDefault(logicValueObject?): undefined | number

A logical value that specifies 1/TRUE , 0/FALSE, default 1 For instance range_lookup, A logical value that specifies whether you want VLOOKUP to find an approximate or an exact match Approximate match - 1/TRUE Exact match - 0/FALSE https://support.microsoft.com/en-us/office/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1 (opens in a new tab) For instance A1, A logical value that specifies what type of reference is contained in the cell ref_text. If a1 is TRUE or omitted, ref_text is interpreted as an A1-style reference. If a1 is FALSE, ref_text is interpreted as an R1C1-style reference. https://support.microsoft.com/zh-cn/office/indirect-%E5%87%BD%E6%95%B0-474b3a3a-8a26-4f44-b491-92b6306fa261 (opens in a new tab)

Parameters

Returns

undefined | number

Defined in

packages/engine-formula/src/functions/base-function.ts:188 (opens in a new tab)

isAddress()

isAddress(): boolean

Returns

boolean

Defined in

packages/engine-formula/src/functions/base-function.ts:114 (opens in a new tab)

isAsync()

isAsync(): boolean

Returns

boolean

Defined in

packages/engine-formula/src/functions/base-function.ts:110 (opens in a new tab)

isCustom()

isCustom(): boolean

Returns

boolean

Defined in

packages/engine-formula/src/functions/base-function.ts:118 (opens in a new tab)

orderSearch()

orderSearch(
   value, 
   searchArray, 
   resultArray, 
   searchType, 
   isDesc): BaseValueObject

Parameters

Returns

BaseValueObject

Defined in

packages/engine-formula/src/functions/base-function.ts:312 (opens in a new tab)

orderSearchExpand()

orderSearchExpand(
   value, 
   searchArray, 
   resultArray, 
   searchType, 
   isDesc, 
   axis): undefined | ErrorValueObject | ArrayValueObject

Parameters

Returns

undefined | ErrorValueObject | ArrayValueObject

Defined in

packages/engine-formula/src/functions/base-function.ts:407 (opens in a new tab)

setDefinedNames()

setDefinedNames(definedNames): void

Parameters

Returns

void

Defined in

packages/engine-formula/src/functions/base-function.ts:106 (opens in a new tab)

setRefInfo()

setRefInfo(
   unitId, 
   subUnitId, 
   row, 
   column): void

Parameters

Returns

void

Defined in

packages/engine-formula/src/functions/base-function.ts:122 (opens in a new tab)