@univerjs/engine-formula v0.5.4

Class: LambdaValueObjectObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/lambda-value-object.ts:56

Extends

• BaseValueObject

Constructors

new LambdaValueObjectObject()

new LambdaValueObjectObject(
   _lambdaNode, 
   _interpreter, 
   _lambdaPrivacyVarKeys): LambdaValueObjectObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/lambda-value-object.ts:63

Parameters

Returns

LambdaValueObjectObject

Overrides

BaseValueObject.constructor

Properties

Methods

abs()

abs(): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:422

Returns

BaseValueObject

Inherited from

BaseValueObject.abs

acos()

acos(): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:305

Returns

BaseValueObject

Inherited from

BaseValueObject.acos

acosh()

acosh(): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:310

Returns

BaseValueObject

Inherited from

BaseValueObject.acosh

asin()

asin(): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:325

Returns

BaseValueObject

Inherited from

BaseValueObject.asin

asinh()

asinh(): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:330

Returns

BaseValueObject

Inherited from

BaseValueObject.asinh

atan()

atan(): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:345

Returns

BaseValueObject

Inherited from

BaseValueObject.atan

atan2()

atan2(valueObject): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:350

Parameters

Returns

BaseValueObject

Inherited from

BaseValueObject.atan2

atan2Inverse()

atan2Inverse(valueObject): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:355

Parameters

Returns

BaseValueObject

Inherited from

BaseValueObject.atan2Inverse

atanh()

atanh(): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:360

Returns

BaseValueObject

Inherited from

BaseValueObject.atanh

cbrt()

cbrt(): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:290

Returns

BaseValueObject

Inherited from

BaseValueObject.cbrt

ceil()

ceil(valueObject): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:447

Parameters

Returns

BaseValueObject

Inherited from

BaseValueObject.ceil

ceilInverse()

ceilInverse(valueObject): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:452

Parameters

Returns

BaseValueObject

Inherited from

BaseValueObject.ceilInverse

compare()

compare(
   valueObject, 
   operator, 
   isCaseSensitive): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:180

Parameters

Returns

BaseValueObject

Inherited from

BaseValueObject.compare

compareBy()

compareBy(value, operator): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:244

Parameters

Returns

BaseValueObject

Inherited from

BaseValueObject.compareBy

concatenate()

concatenate(value, concatenateType): string

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:249

Parameters

Returns

string

Inherited from

BaseValueObject.concatenate

concatenateBack()

concatenateBack(valueObject): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:214

Parameters

Returns

BaseValueObject

Inherited from

BaseValueObject.concatenateBack

concatenateFront()

concatenateFront(valueObject): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:209

Parameters

Returns

BaseValueObject

Inherited from

BaseValueObject.concatenateFront

convertToBooleanObjectValue()

convertToBooleanObjectValue(): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:462

Returns

BaseValueObject

Inherited from

BaseValueObject.convertToBooleanObjectValue

convertToNumberObjectValue()

convertToNumberObjectValue(): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:457

Returns

BaseValueObject

Inherited from

BaseValueObject.convertToNumberObjectValue

cos()

cos(): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:295

Returns

BaseValueObject

Inherited from

BaseValueObject.cos

cosh()

cosh(): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:300

Returns

BaseValueObject

Inherited from

BaseValueObject.cosh

count()

count(): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:115

Returns

BaseValueObject

Inherited from

BaseValueObject.count

countA()

countA(): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:119

Returns

BaseValueObject

Inherited from

BaseValueObject.countA

countBlank()

countBlank(): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:123

Returns

BaseValueObject

Inherited from

BaseValueObject.countBlank

dispose()

dispose(): void

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/lambda-value-object.ts:74

Returns

void

Overrides

BaseValueObject.dispose

divided()

divided(valueObject): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:150

Parameters

Returns

BaseValueObject

Inherited from

BaseValueObject.divided

dividedBy()

dividedBy(value): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:234

Parameters

Returns

BaseValueObject

Inherited from

BaseValueObject.dividedBy

execute()

execute(...variants): BaseValueObject | AsyncObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/lambda-value-object.ts:86

Parameters

Returns

BaseValueObject | AsyncObject

executeCustom()

executeCustom(...variants): BaseValueObject | AsyncObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/lambda-value-object.ts:119

Execute custom lambda function, handle basic types

Parameters

Returns

BaseValueObject | AsyncObject

exp()

exp(): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:417

Returns

BaseValueObject

Inherited from

BaseValueObject.exp

floor()

floor(valueObject): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:437

Parameters

Returns

BaseValueObject

Inherited from

BaseValueObject.floor

floorInverse()

floorInverse(valueObject): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:442

Parameters

Returns

BaseValueObject

Inherited from

BaseValueObject.floorInverse

getArrayValue()

getArrayValue(): Nullable<BaseValueObject>[][]

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:62

Returns

Nullable<BaseValueObject>[][]

Inherited from

BaseValueObject.getArrayValue

getLambdaPrivacyVarKeys()

getLambdaPrivacyVarKeys(): string[]

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/lambda-value-object.ts:163

Returns

string[]

getNegative()

getNegative(): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:127

Returns

BaseValueObject

Inherited from

BaseValueObject.getNegative

getPattern()

getPattern(): string

Defined in: submodules/univer/packages/engine-formula/src/basics/object-class-type.ts:24

Returns

string

Inherited from

BaseValueObject.getPattern

getReciprocal()

getReciprocal(): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:131

Returns

BaseValueObject

Inherited from

BaseValueObject.getReciprocal

getValue()

getValue(): string | number | boolean

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:57

Returns

string | number | boolean

Inherited from

BaseValueObject.getValue

isArray()

isArray(): boolean

Defined in: submodules/univer/packages/engine-formula/src/basics/object-class-type.ts:52

Returns

boolean

Inherited from

BaseValueObject.isArray

isAsyncArrayObject()

isAsyncArrayObject(): boolean

Defined in: submodules/univer/packages/engine-formula/src/basics/object-class-type.ts:44

Returns

boolean

Inherited from

BaseValueObject.isAsyncArrayObject

isAsyncObject()

isAsyncObject(): boolean

Defined in: submodules/univer/packages/engine-formula/src/basics/object-class-type.ts:40

Returns

boolean

Inherited from

BaseValueObject.isAsyncObject

isBoolean()

isBoolean(): boolean

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:87

Returns

boolean

Inherited from

BaseValueObject.isBoolean

isCube()

isCube(): boolean

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:75

Returns

boolean

Inherited from

BaseValueObject.isCube

isEqual()

isEqual(valueObject): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:185

Parameters

Returns

BaseValueObject

Inherited from

BaseValueObject.isEqual

isEqualType()

isEqualType(object): boolean

Defined in: submodules/univer/packages/engine-formula/src/basics/object-class-type.ts:60

Parameters

Returns

boolean

Inherited from

BaseValueObject.isEqualType

isError()

isError(): boolean

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:95

Returns

boolean

Inherited from

BaseValueObject.isError

isGreaterThan()

isGreaterThan(valueObject): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:205

Parameters

Returns

BaseValueObject

Inherited from

BaseValueObject.isGreaterThan

isGreaterThanOrEqual()

isGreaterThanOrEqual(valueObject): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:193

Parameters

Returns

BaseValueObject

Inherited from

BaseValueObject.isGreaterThanOrEqual

isLambda()

isLambda(): boolean

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/lambda-value-object.ts:82

Returns

boolean

Overrides

BaseValueObject.isLambda

isLessThan()

isLessThan(valueObject): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:201

Parameters

Returns

BaseValueObject

Inherited from

BaseValueObject.isLessThan

isLessThanOrEqual()

isLessThanOrEqual(valueObject): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:197

Parameters

Returns

BaseValueObject

Inherited from

BaseValueObject.isLessThanOrEqual

isNotEqual()

isNotEqual(valueObject): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:189

Parameters

Returns

BaseValueObject

Inherited from

BaseValueObject.isNotEqual

isNull()

isNull(): boolean

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:99

Returns

boolean

Inherited from

BaseValueObject.isNull

isNumber()

isNumber(): boolean

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:83

Returns

boolean

Inherited from

BaseValueObject.isNumber

isReferenceObject()

isReferenceObject(): boolean

Defined in: submodules/univer/packages/engine-formula/src/basics/object-class-type.ts:48

Returns

boolean

Inherited from

BaseValueObject.isReferenceObject

isString()

isString(): boolean

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:79

Returns

boolean

Inherited from

BaseValueObject.isString

isValueObject()

isValueObject(): boolean

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:40

Returns

boolean

Inherited from

BaseValueObject.isValueObject

log()

log(): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:407

Returns

BaseValueObject

Inherited from

BaseValueObject.log

log10()

log10(): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:412

Returns

BaseValueObject

Inherited from

BaseValueObject.log10

map()

map(callbackFn): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:165

return every value in the array after the callback function, excluding the error value

Parameters

Returns

BaseValueObject

Inherited from

BaseValueObject.map

mapValue()

mapValue(callbackFn): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:175

return every value in the array after the callback function

Parameters

Returns

BaseValueObject

Inherited from

BaseValueObject.mapValue

max()

max(): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:107

Returns

BaseValueObject

Inherited from

BaseValueObject.max

mean()

mean(): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:371

Calculate the mean of the entire array.

reference https://numpy.org/doc/stable/reference/generated/numpy.mean.html#numpy.mean

Returns

BaseValueObject

Inherited from

BaseValueObject.mean

median()

median(): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:382

Calculate the median of the entire array.

reference https://numpy.org/doc/stable/reference/generated/numpy.median.html

Returns

BaseValueObject

Inherited from

BaseValueObject.median

min()

min(): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:111

Returns

BaseValueObject

Inherited from

BaseValueObject.min

minus()

minus(valueObject): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:140

Parameters

Returns

BaseValueObject

Inherited from

BaseValueObject.minus

minusBy()

minusBy(value): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:224

Parameters

Returns

BaseValueObject

Inherited from

BaseValueObject.minusBy

mod()

mod(valueObject): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:155

Parameters

Returns

BaseValueObject

Inherited from

BaseValueObject.mod

modInverse()

modInverse(valueObject): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:239

Parameters

Returns

BaseValueObject

Inherited from

BaseValueObject.modInverse

multiply()

multiply(valueObject): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:145

Parameters

Returns

BaseValueObject

Inherited from

BaseValueObject.multiply

multiplyBy()

multiplyBy(value): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:229

Parameters

Returns

BaseValueObject

Inherited from

BaseValueObject.multiplyBy

plus()

plus(valueObject): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:135

Parameters

Returns

BaseValueObject

Inherited from

BaseValueObject.plus

plusBy()

plusBy(value): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:219

Parameters

Returns

BaseValueObject

Inherited from

BaseValueObject.plusBy

pow()

pow(valueObject): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:275

Parameters

Returns

BaseValueObject

Inherited from

BaseValueObject.pow

powInverse()

powInverse(valueObject): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:280

Parameters

Returns

BaseValueObject

Inherited from

BaseValueObject.powInverse

round()

round(valueObject): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:427

Parameters

Returns

BaseValueObject

Inherited from

BaseValueObject.round

roundInverse()

roundInverse(valueObject): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:432

Parameters

Returns

BaseValueObject

Inherited from

BaseValueObject.roundInverse

setArrayValue()

setArrayValue(value): void

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:71

Parameters

Returns

void

Inherited from

BaseValueObject.setArrayValue

setPattern()

setPattern(pattern): void

Defined in: submodules/univer/packages/engine-formula/src/basics/object-class-type.ts:32

Only used in NumberValueObject

Parameters

Returns

void

Inherited from

BaseValueObject.setPattern

setValue()

setValue(value): void

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:67

Parameters

Returns

void

Inherited from

BaseValueObject.setValue

sin()

sin(): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:315

Returns

BaseValueObject

Inherited from

BaseValueObject.sin

sinh()

sinh(): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:320

Returns

BaseValueObject

Inherited from

BaseValueObject.sinh

sqrt()

sqrt(): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:285

Returns

BaseValueObject

Inherited from

BaseValueObject.sqrt

std()

std(): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:402

Calculate the standard deviation of the entire array.

reference https://numpy.org/doc/stable/reference/generated/numpy.std.html

Returns

BaseValueObject

Inherited from

BaseValueObject.std

sum()

sum(): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:103

Returns

BaseValueObject

Inherited from

BaseValueObject.sum

tan()

tan(): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:335

Returns

BaseValueObject

Inherited from

BaseValueObject.tan

tanh()

tanh(): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:340

Returns

BaseValueObject

Inherited from

BaseValueObject.tanh

toUnitRange()

toUnitRange(): {
  range: {
     endColumn: number;
     endRow: number;
     startColumn: number;
     startRow: number;
    };
  sheetId: string;
  unitId: string;
}

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:44

Returns

{
  range: {
     endColumn: number;
     endRow: number;
     startColumn: number;
     startRow: number;
    };
  sheetId: string;
  unitId: string;
}

Inherited from

BaseValueObject.toUnitRange

var()

var(): BaseValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/base-value-object.ts:392

Calculate the variance of the entire array.

reference https://numpy.org/doc/stable/reference/generated/numpy.var.html

Returns

BaseValueObject

Inherited from

BaseValueObject.var

create()

static create(
   lambdaNode, 
   interpreter, 
   lambdaPrivacyVarKeys): LambdaValueObjectObject

Defined in: submodules/univer/packages/engine-formula/src/engine/value-object/lambda-value-object.ts:57

Parameters

Returns

LambdaValueObjectObject