@univerjs/engine-formula v0.1.17 • Docs

Class: BaseReferenceObject

Extends

ObjectClassType

Extended by

RangeReferenceObject

Constructors

new BaseReferenceObject()

new BaseReferenceObject(_token): BaseReferenceObject

Parameters

Parameter	Type
`_token`	`string`

Returns

BaseReferenceObject

Overrides

ObjectClassType.constructor

Defined in

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

Properties

Property	Modifier	Type	Default value	Inherited from	Defined in
`_disposed`	`protected`	`boolean`	`false`	`ObjectClassType._disposed`	packages/core/src/shared/lifecycle.ts:93 (opens in a new tab)
`pattern`	`public`	`string`	`''`	`ObjectClassType.pattern`	packages/engine-formula/src/basics/object-class-type.ts:20 (opens in a new tab)

Methods

dispose()

dispose(): void

Returns

void

Overrides

ObjectClassType.dispose

Defined in

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

disposeWithMe()

protected disposeWithMe(disposable): IDisposable

Parameters

Parameter	Type
`disposable`	`DisposableLike`

Returns

IDisposable

Inherited from

ObjectClassType.disposeWithMe

Defined in

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

ensureNotDisposed()

protected ensureNotDisposed(): void

Returns

void

Inherited from

ObjectClassType.ensureNotDisposed

Defined in

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

getActiveSheetColumnCount()

getActiveSheetColumnCount(): number

Returns

number

Defined in

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

getActiveSheetRowCount()

getActiveSheetRowCount(): number

Returns

number

Defined in

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

getArrayFormulaCellData()

getArrayFormulaCellData(): IRuntimeUnitDataType

Returns

IRuntimeUnitDataType

Defined in

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

getCellByColumn()

getCellByColumn(column): 
  | ErrorValueObject
  | NullValueObject
  | NumberValueObject
  | BooleanValueObject
  | StringValueObject
  | ArrayValueObject

Parameters

Parameter	Type
`column`	`number`

Returns

Defined in

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

getCellByPosition()

getCellByPosition(row?, column?): 
  | ErrorValueObject
  | NullValueObject
  | NumberValueObject
  | BooleanValueObject
  | StringValueObject
  | ArrayValueObject

Parameters

Parameter	Type
`row`?	`number`
`column`?	`number`

Returns

Defined in

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

getCellByRow()

getCellByRow(row): 
  | ErrorValueObject
  | NullValueObject
  | NumberValueObject
  | BooleanValueObject
  | StringValueObject
  | ArrayValueObject

Parameters

Parameter	Type
`row`	`number`

Returns

Defined in

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

getCellData()

getCellData(row, column): ICellData

Parameters

Parameter	Type
`row`	`number`
`column`	`number`

Returns

ICellData

Defined in

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

getCellPattern()

getCellPattern(
   unitId, 
   sheetId, 
   row, 
   column): string

Get the pattern of the cell

Parameters

Parameter	Type
`unitId`	`string`
`sheetId`	`string`
`row`	`number`
`column`	`number`

Returns

string

Defined in

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

getCellValueObject()

getCellValueObject(cell): 
  | ErrorValueObject
  | NullValueObject
  | NumberValueObject
  | BooleanValueObject
  | StringValueObject
  | ArrayValueObject

Parameters

Parameter	Type
`cell`	`ICellData`

Returns

Defined in

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

getColumnCount()

getColumnCount(): number

Returns

number

Defined in

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

getColumnData()

getColumnData(): IObjectArrayPrimitiveType<Partial<IColumnData>>

Returns

IObjectArrayPrimitiveType<Partial<IColumnData>>

Defined in

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

getCurrentActiveArrayFormulaCellData()

getCurrentActiveArrayFormulaCellData(): undefined | ObjectMatrix<Nullable<ICellData>>

Returns

undefined | ObjectMatrix<Nullable<ICellData>>

Defined in

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

getCurrentActiveSheetData()

getCurrentActiveSheetData(): ISheetItem

Returns

ISheetItem

Defined in

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

getCurrentRuntimeActiveArrayFormulaCellData()

getCurrentRuntimeActiveArrayFormulaCellData(): undefined | ObjectMatrix<Nullable<ICellData>>

Returns

undefined | ObjectMatrix<Nullable<ICellData>>

Defined in

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

getCurrentRuntimeSheetData()

getCurrentRuntimeSheetData(): undefined | ObjectMatrix<Nullable<ICellData>>

Returns

undefined | ObjectMatrix<Nullable<ICellData>>

Defined in

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

getCurrentStylesData()

getCurrentStylesData(): Styles

Returns

Styles

Defined in

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

getDefaultSheetId()

getDefaultSheetId(): string

Returns

string

Defined in

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

getDefaultUnitId()

getDefaultUnitId(): string

Returns

string

Defined in

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

getFirstCell()

getFirstCell(): 
  | ErrorValueObject
  | NullValueObject
  | NumberValueObject
  | BooleanValueObject
  | StringValueObject
  | ArrayValueObject

Returns

Defined in

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

getForcedSheetId()

getForcedSheetId(): Nullable<string>

Returns

Nullable<string>

Defined in

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

getForcedSheetName()

getForcedSheetName(): string

Returns

string

Defined in

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

getForcedUnitId()

getForcedUnitId(): string

Returns

string

Defined in

packages/engine-formula/src/engine/reference-object/base-reference-object.ts:237 (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:22 (opens in a new tab)

getRangeData()

getRangeData(): IRange

Returns

IRange

Defined in

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

getRangePosition()

getRangePosition(): {
  endColumn: number;
  endRow: number;
  startColumn: number;
  startRow: number;
}

Returns

{
  endColumn: number;
  endRow: number;
  startColumn: number;
  startRow: number;
}

Name	Type	Defined in
`endColumn`	`number`	packages/engine-formula/src/engine/reference-object/base-reference-object.ts:140 (opens in a new tab)
`endRow`	`number`	packages/engine-formula/src/engine/reference-object/base-reference-object.ts:138 (opens in a new tab)
`startColumn`	`number`	packages/engine-formula/src/engine/reference-object/base-reference-object.ts:139 (opens in a new tab)
`startRow`	`number`	packages/engine-formula/src/engine/reference-object/base-reference-object.ts:137 (opens in a new tab)

Defined in

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

getRefOffset()

getRefOffset(): {
  x: number;
  y: number;
}

Returns

{
  x: number;
  y: number;
}

Name	Type	Defined in
`x`	`number`	packages/engine-formula/src/engine/reference-object/base-reference-object.ts:112 (opens in a new tab)
`y`	`number`	packages/engine-formula/src/engine/reference-object/base-reference-object.ts:113 (opens in a new tab)

Defined in

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

getRowCount()

getRowCount(): number

Returns

number

Defined in

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

getRowData()

getRowData(): IObjectArrayPrimitiveType<Partial<IRowData>>

Returns

IObjectArrayPrimitiveType<Partial<IRowData>>

Defined in

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

getRuntimeArrayFormulaCellData()

getRuntimeArrayFormulaCellData(): IRuntimeUnitDataType

Returns

IRuntimeUnitDataType

Defined in

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

getRuntimeData()

getRuntimeData(): IRuntimeUnitDataType

Returns

IRuntimeUnitDataType

Defined in

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

getRuntimeFeatureCellData()

getRuntimeFeatureCellData(): {}

Returns

{}

Defined in

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

getRuntimeFeatureCellValue()

getRuntimeFeatureCellValue(row, column): undefined | ICellData

Parameters

Parameter	Type
`row`	`number`
`column`	`number`

Returns

undefined | ICellData

Defined in

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

getSheetId()

getSheetId(): string

Returns

string

Defined in

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

getToken()

getToken(): string

Returns

string

Defined in

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

getUnitData()

getUnitData(): IUnitData

Returns

IUnitData

Defined in

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

getUnitId()

getUnitId(): string

Returns

string

Defined in

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

getUnitStylesData()

getUnitStylesData(): IUnitStylesData

Returns

IUnitStylesData

Defined in

packages/engine-formula/src/engine/reference-object/base-reference-object.ts:287 (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:50 (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:42 (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:38 (opens in a new tab)

isCell()

isCell(): boolean

Returns

boolean

Defined in

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

isColumn()

isColumn(): boolean

Returns

boolean

Defined in

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

isEqualType()

isEqualType(object): boolean

Parameters

Parameter	Type
`object`	`ObjectClassType`

Returns

boolean

Inherited from

ObjectClassType.isEqualType

Defined in

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

isError()

isError(): boolean

Returns

boolean

Inherited from

ObjectClassType.isError

Defined in

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

isExceedRange()

isExceedRange(): boolean

Returns

boolean

Defined in

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

isRange()

isRange(): boolean

Returns

boolean

Defined in

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

isReferenceObject()

isReferenceObject(): boolean

Returns

boolean

Overrides

ObjectClassType.isReferenceObject

Defined in

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

isRow()

isRow(): boolean

Returns

boolean

Defined in

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

isTable()

isTable(): boolean

Returns

boolean

Defined in

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

isValueObject()

isValueObject(): boolean

Returns

boolean

Inherited from

ObjectClassType.isValueObject

Defined in

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

iterator()

iterator(callback): Nullable<boolean>

Parameters

Parameter	Type
`callback`	(`valueObject`, `rowIndex`, `columnIndex`) => `Nullable`<`boolean`>

Returns

Nullable<boolean>

Defined in

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

setArrayFormulaCellData()

setArrayFormulaCellData(unitData): void

Parameters

Parameter	Type
`unitData`	`IRuntimeUnitDataType`

Returns

void

Defined in

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

setDefaultSheetId()

setDefaultSheetId(sheetId): void

Parameters

Parameter	Type
`sheetId`	`string`

Returns

void

Defined in

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

setDefaultUnitId()

setDefaultUnitId(unitId): void

Parameters

Parameter	Type
`unitId`	`string`

Returns

void

Defined in

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

setForcedSheetId()

setForcedSheetId(sheetNameMap): void

Parameters

Parameter	Type
`sheetNameMap`	`IUnitSheetNameMap`

Returns

void

Defined in

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

setForcedSheetIdDirect()

setForcedSheetIdDirect(sheetId): void

Parameters

Parameter	Type
`sheetId`	`string`

Returns

void

Defined in

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

setForcedSheetName()

setForcedSheetName(sheetName): void

Parameters

Parameter	Type
`sheetName`	`string`

Returns

void

Defined in

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

setForcedUnitIdDirect()

setForcedUnitIdDirect(unitId): void

Parameters

Parameter	Type
`unitId`	`string`

Returns

void

Defined in

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

setPattern()

setPattern(pattern): void

Only used in NumberValueObject

Parameters

Parameter	Type
`pattern`	`string`

Returns

void

Inherited from

ObjectClassType.setPattern

Defined in

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

setRangeData()

setRangeData(range): void

Parameters

Parameter	Type
`range`	`IRange`

Returns

void

Defined in

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

setRefOffset()

setRefOffset(x, y): void

Parameters

Parameter	Type	Default value
`x`	`number`	`0`
`y`	`number`	`0`

Returns

void

Defined in

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

setRuntimeArrayFormulaCellData()

setRuntimeArrayFormulaCellData(unitData): void

Parameters

Parameter	Type
`unitData`	`IRuntimeUnitDataType`

Returns

void

Defined in

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

setRuntimeData()

setRuntimeData(runtimeData): void

Parameters

Parameter	Type
`runtimeData`	`IRuntimeUnitDataType`

Returns

void

Defined in

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

setRuntimeFeatureCellData()

setRuntimeFeatureCellData(unitData): void

Parameters

Parameter	Type
`unitData`	`object`

Returns

void

Defined in

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

setToken()

setToken(token): void

Parameters

Parameter	Type
`token`	`string`

Returns

void

Defined in

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

setUnitData()

setUnitData(unitData): void

Parameters

Parameter	Type
`unitData`	`IUnitData`

Returns

void

Defined in

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

setUnitStylesData()

setUnitStylesData(unitStylesData): void

Parameters

Parameter	Type
`unitStylesData`	`IUnitStylesData`

Returns

void

Defined in

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

toArrayValueObject()

toArrayValueObject(useCache): ArrayValueObject

Parameters

Parameter	Type	Default value
`useCache`	`boolean`	`true`

Returns

ArrayValueObject

Defined in

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

toUnitRange()

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

Returns

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

Name	Type	Defined in
`range`	{ `endColumn`: `number`; `endRow`: `number`; `startColumn`: `number`; `startRow`: `number`; }	packages/engine-formula/src/engine/reference-object/base-reference-object.ts:567 (opens in a new tab)
`range.endColumn`	`number`	packages/engine-formula/src/engine/reference-object/base-reference-object.ts:140 (opens in a new tab)
`range.endRow`	`number`	packages/engine-formula/src/engine/reference-object/base-reference-object.ts:138 (opens in a new tab)
`range.startColumn`	`number`	packages/engine-formula/src/engine/reference-object/base-reference-object.ts:139 (opens in a new tab)
`range.startRow`	`number`	packages/engine-formula/src/engine/reference-object/base-reference-object.ts:137 (opens in a new tab)
`sheetId`	`string`	packages/engine-formula/src/engine/reference-object/base-reference-object.ts:568 (opens in a new tab)
`unitId`	`string`	packages/engine-formula/src/engine/reference-object/base-reference-object.ts:569 (opens in a new tab)

Defined in

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

unionBy()

unionBy(referenceObject): NodeValueType

Parameters

Parameter	Type
`referenceObject`	`BaseReferenceObject`

Returns

NodeValueType

Defined in

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

unionRange()

unionRange(rangeData1, rangeData2): IRange

Parameters

Parameter	Type
`rangeData1`	`IRange`
`rangeData2`	`IRange`

Returns

IRange

Defined in

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

Basefunction Basevalueobject