@univerjs/engine-formula v0.4.2 • Docs

Class: BaseValueObject

Extends

• ObjectClassType

Extended by

• ArrayValueObject
• ErrorValueObject
• BooleanValueObject
• NullValueObject
• NumberValueObject
• StringValueObject

Constructors

new BaseValueObject()

new BaseValueObject(_rawValue): BaseValueObject

Parameters

Returns

BaseValueObject

Overrides

ObjectClassType.constructor

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:36 (opens in a new tab)

Properties

Methods

abs()

abs(): BaseValueObject

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:422 (opens in a new tab)

acos()

acos(): BaseValueObject

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:305 (opens in a new tab)

acosh()

acosh(): BaseValueObject

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:310 (opens in a new tab)

asin()

asin(): BaseValueObject

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:325 (opens in a new tab)

asinh()

asinh(): BaseValueObject

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:330 (opens in a new tab)

atan()

atan(): BaseValueObject

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:345 (opens in a new tab)

atan2()

atan2(valueObject): BaseValueObject

Parameters

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:350 (opens in a new tab)

atan2Inverse()

atan2Inverse(valueObject): BaseValueObject

Parameters

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:355 (opens in a new tab)

atanh()

atanh(): BaseValueObject

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:360 (opens in a new tab)

cbrt()

cbrt(): BaseValueObject

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:290 (opens in a new tab)

ceil()

ceil(valueObject): BaseValueObject

Parameters

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:447 (opens in a new tab)

ceilInverse()

ceilInverse(valueObject): BaseValueObject

Parameters

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:452 (opens in a new tab)

compare()

compare(
   valueObject, 
   operator, 
   isCaseSensitive): BaseValueObject

Parameters

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:180 (opens in a new tab)

compareBy()

compareBy(value, operator): BaseValueObject

Parameters

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:244 (opens in a new tab)

concatenate()

concatenate(value, concatenateType): string

Parameters

Returns

string

Defined in

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

concatenateBack()

concatenateBack(valueObject): BaseValueObject

Parameters

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:214 (opens in a new tab)

concatenateFront()

concatenateFront(valueObject): BaseValueObject

Parameters

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:209 (opens in a new tab)

convertToBooleanObjectValue()

convertToBooleanObjectValue(): BaseValueObject

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:462 (opens in a new tab)

convertToNumberObjectValue()

convertToNumberObjectValue(): BaseValueObject

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:457 (opens in a new tab)

cos()

cos(): BaseValueObject

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:295 (opens in a new tab)

cosh()

cosh(): BaseValueObject

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:300 (opens in a new tab)

count()

count(): BaseValueObject

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:115 (opens in a new tab)

countA()

countA(): BaseValueObject

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:119 (opens in a new tab)

countBlank()

countBlank(): BaseValueObject

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:123 (opens in a new tab)

dispose()

dispose(): void

Returns

void

Inherited from

ObjectClassType.dispose

Defined in

packages/engine-formula/src/basics/object-class-type.ts:20 (opens in a new tab)

divided()

divided(valueObject): BaseValueObject

Parameters

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:150 (opens in a new tab)

dividedBy()

dividedBy(value): BaseValueObject

Parameters

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:234 (opens in a new tab)

exp()

exp(): BaseValueObject

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:417 (opens in a new tab)

floor()

floor(valueObject): BaseValueObject

Parameters

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:437 (opens in a new tab)

floorInverse()

floorInverse(valueObject): BaseValueObject

Parameters

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:442 (opens in a new tab)

getArrayValue()

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

Returns

Nullable<BaseValueObject>[][]

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:62 (opens in a new tab)

getNegative()

getNegative(): BaseValueObject

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:127 (opens in a new tab)

getPattern()

getPattern(): string

Returns

string

Inherited from

ObjectClassType.getPattern

Defined in

packages/engine-formula/src/basics/object-class-type.ts:24 (opens in a new tab)

getReciprocal()

getReciprocal(): BaseValueObject

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:131 (opens in a new tab)

getValue()

getValue(): string | number | boolean

Returns

string | number | boolean

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:57 (opens in a new tab)

isArray()

isArray(): boolean

Returns

boolean

Inherited from

ObjectClassType.isArray

Defined in

packages/engine-formula/src/basics/object-class-type.ts:52 (opens in a new tab)

isAsyncArrayObject()

isAsyncArrayObject(): boolean

Returns

boolean

Inherited from

ObjectClassType.isAsyncArrayObject

Defined in

packages/engine-formula/src/basics/object-class-type.ts:44 (opens in a new tab)

isAsyncObject()

isAsyncObject(): boolean

Returns

boolean

Inherited from

ObjectClassType.isAsyncObject

Defined in

packages/engine-formula/src/basics/object-class-type.ts:40 (opens in a new tab)

isBoolean()

isBoolean(): boolean

Returns

boolean

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:87 (opens in a new tab)

isCube()

isCube(): boolean

Returns

boolean

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:75 (opens in a new tab)

isEqual()

isEqual(valueObject): BaseValueObject

Parameters

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:185 (opens in a new tab)

isEqualType()

isEqualType(object): boolean

Parameters

Returns

boolean

Inherited from

ObjectClassType.isEqualType

Defined in

packages/engine-formula/src/basics/object-class-type.ts:60 (opens in a new tab)

isError()

isError(): boolean

Returns

boolean

Overrides

ObjectClassType.isError

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:95 (opens in a new tab)

isGreaterThan()

isGreaterThan(valueObject): BaseValueObject

Parameters

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:205 (opens in a new tab)

isGreaterThanOrEqual()

isGreaterThanOrEqual(valueObject): BaseValueObject

Parameters

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:193 (opens in a new tab)

isLambda()

isLambda(): boolean

Returns

boolean

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:91 (opens in a new tab)

isLessThan()

isLessThan(valueObject): BaseValueObject

Parameters

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:201 (opens in a new tab)

isLessThanOrEqual()

isLessThanOrEqual(valueObject): BaseValueObject

Parameters

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:197 (opens in a new tab)

isNotEqual()

isNotEqual(valueObject): BaseValueObject

Parameters

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:189 (opens in a new tab)

isNull()

isNull(): boolean

Returns

boolean

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:99 (opens in a new tab)

isNumber()

isNumber(): boolean

Returns

boolean

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:83 (opens in a new tab)

isReferenceObject()

isReferenceObject(): boolean

Returns

boolean

Inherited from

ObjectClassType.isReferenceObject

Defined in

packages/engine-formula/src/basics/object-class-type.ts:48 (opens in a new tab)

isString()

isString(): boolean

Returns

boolean

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:79 (opens in a new tab)

isValueObject()

isValueObject(): boolean

Returns

boolean

Overrides

ObjectClassType.isValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:40 (opens in a new tab)

log()

log(): BaseValueObject

Returns

BaseValueObject

Defined in

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

log10()

log10(): BaseValueObject

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:412 (opens in a new tab)

map()

map(callbackFn): BaseValueObject

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

Parameters

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:165 (opens in a new tab)

mapValue()

mapValue(callbackFn): BaseValueObject

return every value in the array after the callback function

Parameters

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:175 (opens in a new tab)

max()

max(): BaseValueObject

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:107 (opens in a new tab)

mean()

mean(): BaseValueObject

Calculate the mean of the entire array.

reference https://numpy.org/doc/stable/reference/generated/numpy.mean.html#numpy.mean (opens in a new tab)

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:371 (opens in a new tab)

median()

median(): BaseValueObject

Calculate the median of the entire array.

reference https://numpy.org/doc/stable/reference/generated/numpy.median.html (opens in a new tab)

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:382 (opens in a new tab)

min()

min(): BaseValueObject

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:111 (opens in a new tab)

minus()

minus(valueObject): BaseValueObject

Parameters

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:140 (opens in a new tab)

minusBy()

minusBy(value): BaseValueObject

Parameters

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:224 (opens in a new tab)

mod()

mod(valueObject): BaseValueObject

Parameters

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:155 (opens in a new tab)

modInverse()

modInverse(valueObject): BaseValueObject

Parameters

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:239 (opens in a new tab)

multiply()

multiply(valueObject): BaseValueObject

Parameters

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:145 (opens in a new tab)

multiplyBy()

multiplyBy(value): BaseValueObject

Parameters

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:229 (opens in a new tab)

plus()

plus(valueObject): BaseValueObject

Parameters

Returns

BaseValueObject

Defined in

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

plusBy()

plusBy(value): BaseValueObject

Parameters

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:219 (opens in a new tab)

pow()

pow(valueObject): BaseValueObject

Parameters

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:275 (opens in a new tab)

powInverse()

powInverse(valueObject): BaseValueObject

Parameters

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:280 (opens in a new tab)

round()

round(valueObject): BaseValueObject

Parameters

Returns

BaseValueObject

Defined in

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

roundInverse()

roundInverse(valueObject): BaseValueObject

Parameters

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:432 (opens in a new tab)

setArrayValue()

setArrayValue(value): void

Parameters

Returns

void

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:71 (opens in a new tab)

setPattern()

setPattern(pattern): void

Only used in NumberValueObject

Parameters

Returns

void

Inherited from

ObjectClassType.setPattern

Defined in

packages/engine-formula/src/basics/object-class-type.ts:32 (opens in a new tab)

setValue()

setValue(value): void

Parameters

Returns

void

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:67 (opens in a new tab)

sin()

sin(): BaseValueObject

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:315 (opens in a new tab)

sinh()

sinh(): BaseValueObject

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:320 (opens in a new tab)

sqrt()

sqrt(): BaseValueObject

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:285 (opens in a new tab)

std()

std(): BaseValueObject

Calculate the standard deviation of the entire array.

reference https://numpy.org/doc/stable/reference/generated/numpy.std.html (opens in a new tab)

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:402 (opens in a new tab)

sum()

sum(): BaseValueObject

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:103 (opens in a new tab)

tan()

tan(): BaseValueObject

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:335 (opens in a new tab)

tanh()

tanh(): BaseValueObject

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:340 (opens in a new tab)

toUnitRange()

toUnitRange(): {
  range: {
     endColumn: -1;
     endRow: -1;
     startColumn: -1;
     startRow: -1;
    };
  sheetId: '';
  unitId: '';
}

Returns

{
  range: {
     endColumn: -1;
     endRow: -1;
     startColumn: -1;
     startRow: -1;
    };
  sheetId: '';
  unitId: '';
}

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:44 (opens in a new tab)

var()

var(): BaseValueObject

Calculate the variance of the entire array.

reference https://numpy.org/doc/stable/reference/generated/numpy.var.html (opens in a new tab)

Returns

BaseValueObject

Defined in

packages/engine-formula/src/engine/value-object/base-value-object.ts:392 (opens in a new tab)