@univerjs/engine-formula v0.5.4


Class: RangeReferenceObject

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/range-reference-object.ts:21

Extends

Constructors

new RangeReferenceObject()

new RangeReferenceObject(
   range, 
   forcedSheetId?, 
   forcedUnitId?): RangeReferenceObject

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/range-reference-object.ts:22

Parameters

ParameterType
rangeIRange
forcedSheetId?Nullable<string>
forcedUnitId?string

Returns

RangeReferenceObject

Overrides

BaseReferenceObject.constructor

Properties

PropertyTypeDefault valueInherited fromDefined in
patternstring''BaseReferenceObject.patternsubmodules/univer/packages/engine-formula/src/basics/object-class-type.ts:18

Methods

dispose()

dispose(): void

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:82

Returns

void

Inherited from

BaseReferenceObject.dispose


getActiveSheetColumnCount()

getActiveSheetColumnCount(): number

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:342

Returns

number

Inherited from

BaseReferenceObject.getActiveSheetColumnCount


getActiveSheetRowCount()

getActiveSheetRowCount(): number

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:338

Returns

number

Inherited from

BaseReferenceObject.getActiveSheetRowCount


getArrayFormulaCellData()

getArrayFormulaCellData(): IRuntimeUnitDataType

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:314

Returns

IRuntimeUnitDataType

Inherited from

BaseReferenceObject.getArrayFormulaCellData


getCellByColumn()

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

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:431

Parameters

ParameterType
columnnumber

Returns

| ErrorValueObject | NullValueObject | NumberValueObject | BooleanValueObject | StringValueObject | ArrayValueObject

Inherited from

BaseReferenceObject.getCellByColumn


getCellByPosition()

getCellByPosition(rowRaw?, columnRaw?): 
  | ErrorValueObject
  | NullValueObject
  | NumberValueObject
  | BooleanValueObject
  | StringValueObject
  | ArrayValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:477

Parameters

ParameterType
rowRaw?number
columnRaw?number

Returns

| ErrorValueObject | NullValueObject | NumberValueObject | BooleanValueObject | StringValueObject | ArrayValueObject

Inherited from

BaseReferenceObject.getCellByPosition


getCellByRow()

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

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

Parameters

ParameterType
rownumber

Returns

| ErrorValueObject | NullValueObject | NumberValueObject | BooleanValueObject | StringValueObject | ArrayValueObject

Inherited from

BaseReferenceObject.getCellByRow


getCellData()

getCellData(row, column): Nullable<ICellData>

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:455

Parameters

ParameterType
rownumber
columnnumber

Returns

Nullable<ICellData>

Inherited from

BaseReferenceObject.getCellData


getCellPattern()

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

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:505

Get the pattern of the cell

Parameters

ParameterType
unitIdstring
sheetIdstring
rownumber
columnnumber

Returns

string

Inherited from

BaseReferenceObject.getCellPattern


getCellValueObject()

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

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:397

Parameters

ParameterType
cellICellData

Returns

| ErrorValueObject | NullValueObject | NumberValueObject | BooleanValueObject | StringValueObject | ArrayValueObject

Inherited from

BaseReferenceObject.getCellValueObject


getColumnCount()

getColumnCount(): number

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

Returns

number

Inherited from

BaseReferenceObject.getColumnCount


getColumnData()

getColumnData(): IObjectArrayPrimitiveType<Partial<IColumnData>>

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:358

Returns

IObjectArrayPrimitiveType<Partial<IColumnData>>

Inherited from

BaseReferenceObject.getColumnData


getCurrentActiveArrayFormulaCellData()

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

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

Returns

| undefined | ObjectMatrix<Nullable<ICellData>>

Inherited from

BaseReferenceObject.getCurrentActiveArrayFormulaCellData


getCurrentActiveSheetData()

getCurrentActiveSheetData(): ISheetItem

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:435

Returns

ISheetItem

Inherited from

BaseReferenceObject.getCurrentActiveSheetData


getCurrentRuntimeActiveArrayFormulaCellData()

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

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:451

Returns

| undefined | ObjectMatrix<Nullable<ICellData>>

Inherited from

BaseReferenceObject.getCurrentRuntimeActiveArrayFormulaCellData


getCurrentRuntimeSheetData()

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

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:443

Returns

| undefined | ObjectMatrix<Nullable<ICellData>>

Inherited from

BaseReferenceObject.getCurrentRuntimeSheetData


getCurrentStylesData()

getCurrentStylesData(): Styles

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:439

Returns

Styles

Inherited from

BaseReferenceObject.getCurrentStylesData


getDefaultSheetId()

getDefaultSheetId(): string

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:278

Returns

string

Inherited from

BaseReferenceObject.getDefaultSheetId


getDefaultUnitId()

getDefaultUnitId(): string

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:286

Returns

string

Inherited from

BaseReferenceObject.getDefaultUnitId


getFirstCell()

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

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

Returns

| ErrorValueObject | NullValueObject | NumberValueObject | BooleanValueObject | StringValueObject | ArrayValueObject

Inherited from

BaseReferenceObject.getFirstCell


getForcedSheetId()

getForcedSheetId(): Nullable<string>

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:260

Returns

Nullable<string>

Inherited from

BaseReferenceObject.getForcedSheetId


getForcedSheetName()

getForcedSheetName(): string

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:270

Returns

string

Inherited from

BaseReferenceObject.getForcedSheetName


getForcedUnitId()

getForcedUnitId(): string

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:248

Returns

string

Inherited from

BaseReferenceObject.getForcedUnitId


getPattern()

getPattern(): string

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

Returns

string

Inherited from

BaseReferenceObject.getPattern


getRangeData()

getRangeData(): IRange

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:220

Returns

IRange

Inherited from

BaseReferenceObject.getRangeData


getRangePosition()

getRangePosition(): {
  endAbsoluteRefType: AbsoluteRefType;
  endColumn: number;
  endRow: number;
  rangeType: RANGE_TYPE;
  sheetId: string;
  startAbsoluteRefType: AbsoluteRefType;
  startColumn: number;
  startRow: number;
  unitId: string;
}

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

Returns

{
  endAbsoluteRefType: AbsoluteRefType;
  endColumn: number;
  endRow: number;
  rangeType: RANGE_TYPE;
  sheetId: string;
  startAbsoluteRefType: AbsoluteRefType;
  startColumn: number;
  startRow: number;
  unitId: string;
}
NameTypeDescriptionDefined in
endAbsoluteRefType?AbsoluteRefType-submodules/univer/packages/core/src/sheets/typedef.ts:473
endColumnnumber-submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:143
endRownumber-submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:141
rangeType?RANGE_TYPE-submodules/univer/packages/core/src/sheets/typedef.ts:469
sheetId?stringId of the Worksheet the range belongs to. When this field is not defined, it should be considered as the range in the currently activated worksheet.submodules/univer/packages/core/src/sheets/typedef.ts:422
startAbsoluteRefType?AbsoluteRefType-submodules/univer/packages/core/src/sheets/typedef.ts:471
startColumnnumber-submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:142
startRownumber-submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:140
unitId?stringId of the Workbook the range belongs to. When this field is not defined, it should be considered as the range in the currently activated worksheet.submodules/univer/packages/core/src/sheets/typedef.ts:416

Inherited from

BaseReferenceObject.getRangePosition


getRefOffset()

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

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:112

Returns

{
  x: number;
  y: number;
}
NameTypeDefined in
xnumbersubmodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:114
ynumbersubmodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:115

Inherited from

BaseReferenceObject.getRefOffset


getRowCount()

getRowCount(): number

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:346

Returns

number

Inherited from

BaseReferenceObject.getRowCount


getRowData()

getRowData(): IObjectArrayPrimitiveType<Partial<IRowData>>

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:354

Returns

IObjectArrayPrimitiveType<Partial<IRowData>>

Inherited from

BaseReferenceObject.getRowData


getRuntimeArrayFormulaCellData()

getRuntimeArrayFormulaCellData(): IRuntimeUnitDataType

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:322

Returns

IRuntimeUnitDataType

Inherited from

BaseReferenceObject.getRuntimeArrayFormulaCellData


getRuntimeData()

getRuntimeData(): IRuntimeUnitDataType

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:306

Returns

IRuntimeUnitDataType

Inherited from

BaseReferenceObject.getRuntimeData


getRuntimeFeatureCellData()

getRuntimeFeatureCellData(): {}

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

Returns

{}

Inherited from

BaseReferenceObject.getRuntimeFeatureCellData


getRuntimeFeatureCellValue()

getRuntimeFeatureCellValue(row, column): undefined | ICellData

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:473

Parameters

ParameterType
rownumber
columnnumber

Returns

undefined | ICellData

Inherited from

BaseReferenceObject.getRuntimeFeatureCellValue


getSheetId()

getSheetId(): string

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:235

Returns

string

Inherited from

BaseReferenceObject.getSheetId


getToken()

getToken(): string

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:90

Returns

string

Inherited from

BaseReferenceObject.getToken


getUnitData()

getUnitData(): IUnitData

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

Returns

IUnitData

Inherited from

BaseReferenceObject.getUnitData


getUnitId()

getUnitId(): string

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:228

Returns

string

Inherited from

BaseReferenceObject.getUnitId


getUnitStylesData()

getUnitStylesData(): IUnitStylesData

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:298

Returns

IUnitStylesData

Inherited from

BaseReferenceObject.getUnitStylesData


isArray()

isArray(): boolean

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

Returns

boolean

Inherited from

BaseReferenceObject.isArray


isAsyncArrayObject()

isAsyncArrayObject(): boolean

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

Returns

boolean

Inherited from

BaseReferenceObject.isAsyncArrayObject


isAsyncObject()

isAsyncObject(): boolean

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

Returns

boolean

Inherited from

BaseReferenceObject.isAsyncObject


isCell()

isCell(): boolean

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:362

Returns

boolean

Inherited from

BaseReferenceObject.isCell


isColumn()

isColumn(): boolean

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:366

Returns

boolean

Inherited from

BaseReferenceObject.isColumn


isEqualType()

isEqualType(object): boolean

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

Parameters

ParameterType
objectObjectClassType

Returns

boolean

Inherited from

BaseReferenceObject.isEqualType


isError()

isError(): boolean

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

Returns

boolean

Inherited from

BaseReferenceObject.isError


isExceedRange()

isExceedRange(): boolean

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:98

Returns

boolean

Inherited from

BaseReferenceObject.isExceedRange


isRange()

isRange(): boolean

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/range-reference-object.ts:34

Returns

boolean

Overrides

BaseReferenceObject.isRange


isReferenceObject()

isReferenceObject(): boolean

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:147

Returns

boolean

Inherited from

BaseReferenceObject.isReferenceObject


isRow()

isRow(): boolean

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:370

Returns

boolean

Inherited from

BaseReferenceObject.isRow


isTable()

isTable(): boolean

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:378

Returns

boolean

Inherited from

BaseReferenceObject.isTable


isValueObject()

isValueObject(): boolean

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

Returns

boolean

Inherited from

BaseReferenceObject.isValueObject


iterator()

iterator(callback): Nullable<boolean>

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:151

Parameters

ParameterType
callback(valueObject, rowIndex, columnIndex) => Nullable<boolean>

Returns

Nullable<boolean>

Inherited from

BaseReferenceObject.iterator


setArrayFormulaCellData()

setArrayFormulaCellData(unitData): void

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:318

Parameters

ParameterType
unitDataIRuntimeUnitDataType

Returns

void

Inherited from

BaseReferenceObject.setArrayFormulaCellData


setDefaultSheetId()

setDefaultSheetId(sheetId): void

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:274

Parameters

ParameterType
sheetIdstring

Returns

void

Inherited from

BaseReferenceObject.setDefaultSheetId


setDefaultUnitId()

setDefaultUnitId(unitId): void

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:282

Parameters

ParameterType
unitIdstring

Returns

void

Inherited from

BaseReferenceObject.setDefaultUnitId


setForcedSheetId()

setForcedSheetId(sheetNameMap): void

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:252

Parameters

ParameterType
sheetNameMapIUnitSheetNameMap

Returns

void

Inherited from

BaseReferenceObject.setForcedSheetId


setForcedSheetIdDirect()

setForcedSheetIdDirect(sheetId): void

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:256

Parameters

ParameterType
sheetIdstring

Returns

void

Inherited from

BaseReferenceObject.setForcedSheetIdDirect


setForcedSheetName()

setForcedSheetName(sheetName): void

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:264

Parameters

ParameterType
sheetNamestring

Returns

void

Inherited from

BaseReferenceObject.setForcedSheetName


setForcedUnitIdDirect()

setForcedUnitIdDirect(unitId): void

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:242

Parameters

ParameterType
unitIdstring

Returns

void

Inherited from

BaseReferenceObject.setForcedUnitIdDirect


setPattern()

setPattern(pattern): void

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

Only used in NumberValueObject

Parameters

ParameterType
patternstring

Returns

void

Inherited from

BaseReferenceObject.setPattern


setRangeData()

setRangeData(range): void

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

Parameters

ParameterType
rangeIRange

Returns

void

Inherited from

BaseReferenceObject.setRangeData


setRefOffset()

setRefOffset(x, y): void

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

Parameters

ParameterTypeDefault value
xnumber0
ynumber0

Returns

void

Inherited from

BaseReferenceObject.setRefOffset


setRuntimeArrayFormulaCellData()

setRuntimeArrayFormulaCellData(unitData): void

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:326

Parameters

ParameterType
unitDataIRuntimeUnitDataType

Returns

void

Inherited from

BaseReferenceObject.setRuntimeArrayFormulaCellData


setRuntimeData()

setRuntimeData(runtimeData): void

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

Parameters

ParameterType
runtimeDataIRuntimeUnitDataType

Returns

void

Inherited from

BaseReferenceObject.setRuntimeData


setRuntimeFeatureCellData()

setRuntimeFeatureCellData(unitData): void

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:334

Parameters

ParameterType
unitData{}

Returns

void

Inherited from

BaseReferenceObject.setRuntimeFeatureCellData


setToken()

setToken(token): void

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:94

Parameters

ParameterType
tokenstring

Returns

void

Inherited from

BaseReferenceObject.setToken


setUnitData()

setUnitData(unitData): void

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:294

Parameters

ParameterType
unitDataIUnitData

Returns

void

Inherited from

BaseReferenceObject.setUnitData


setUnitStylesData()

setUnitStylesData(unitStylesData): void

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:302

Parameters

ParameterType
unitStylesDataIUnitStylesData

Returns

void

Inherited from

BaseReferenceObject.setUnitStylesData


toArrayValueObject()

toArrayValueObject(useCache): ArrayValueObject

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:523

Parameters

ParameterTypeDefault value
useCachebooleantrue

Returns

ArrayValueObject

Inherited from

BaseReferenceObject.toArrayValueObject


toUnitRange()

toUnitRange(): {
  range: {
     endAbsoluteRefType: AbsoluteRefType;
     endColumn: number;
     endRow: number;
     rangeType: RANGE_TYPE;
     sheetId: string;
     startAbsoluteRefType: AbsoluteRefType;
     startColumn: number;
     startRow: number;
     unitId: string;
    };
  sheetId: string;
  unitId: string;
}

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:573

Returns

{
  range: {
     endAbsoluteRefType: AbsoluteRefType;
     endColumn: number;
     endRow: number;
     rangeType: RANGE_TYPE;
     sheetId: string;
     startAbsoluteRefType: AbsoluteRefType;
     startColumn: number;
     startRow: number;
     unitId: string;
    };
  sheetId: string;
  unitId: string;
}
NameTypeDescriptionDefined in
range{ endAbsoluteRefType: AbsoluteRefType; endColumn: number; endRow: number; rangeType: RANGE_TYPE; sheetId: string; startAbsoluteRefType: AbsoluteRefType; startColumn: number; startRow: number; unitId: string; }-submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:575
range.endAbsoluteRefType?AbsoluteRefType-submodules/univer/packages/core/src/sheets/typedef.ts:473
range.endColumnnumber-submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:143
range.endRownumber-submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:141
range.rangeType?RANGE_TYPE-submodules/univer/packages/core/src/sheets/typedef.ts:469
range.sheetId?stringId of the Worksheet the range belongs to. When this field is not defined, it should be considered as the range in the currently activated worksheet.submodules/univer/packages/core/src/sheets/typedef.ts:422
range.startAbsoluteRefType?AbsoluteRefType-submodules/univer/packages/core/src/sheets/typedef.ts:471
range.startColumnnumber-submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:142
range.startRownumber-submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:140
range.unitId?stringId of the Workbook the range belongs to. When this field is not defined, it should be considered as the range in the currently activated worksheet.submodules/univer/packages/core/src/sheets/typedef.ts:416
sheetIdstring-submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:576
unitIdstring-submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:577

Inherited from

BaseReferenceObject.toUnitRange


unionBy()

unionBy(referenceObject): NodeValueType

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

Parameters

ParameterType
referenceObjectBaseReferenceObject

Returns

NodeValueType

Inherited from

BaseReferenceObject.unionBy


unionRange()

unionRange(rangeData1, rangeData2): IRange

Defined in: submodules/univer/packages/engine-formula/src/engine/reference-object/base-reference-object.ts:387

Parameters

ParameterType
rangeData1IRange
rangeData2IRange

Returns

IRange

Inherited from

BaseReferenceObject.unionRange