@univerjs/sheets-formula v0.4.2 • Docs

Class: RegisterOtherFormulaService

Extends

Disposable

Constructors

new RegisterOtherFormulaService()

new RegisterOtherFormulaService(_commandService, _activeDirtyManagerService): RegisterOtherFormulaService

Parameters

Parameter	Type
`_commandService`	`ICommandService`
`_activeDirtyManagerService`	`IActiveDirtyManagerService`

Properties

Property	Modifier	Type	Default value	Inherited from	Defined in
`_disposed`	`protected`	`boolean`	`false`	`Disposable`.`_disposed`	packages/core/src/shared/lifecycle.ts:93 (opens in a new tab)
`formulaChange$`	`public`	`Observable`<{ `formulaId`: `string`; `formulaText`: `string`; `subUnitId`: `string`; `unitId`: `string`; }>	`undefined`	-	packages/sheets-formula/src/services/register-other-formula.service.ts:30 (opens in a new tab)
`formulaResult$`	`public`	`Observable`<`Record`<`string`, `Record`<`string`, `IOtherFormulaResult`[]>>>	`undefined`	-	packages/sheets-formula/src/services/register-other-formula.service.ts:35 (opens in a new tab)

Methods

deleteFormula()

deleteFormula(
   unitId, 
   subUnitId, 
   formulaIdList): void

Parameters

Parameter	Type
`unitId`	`string`
`subUnitId`	`string`
`formulaIdList`	`string`[]

Returns

void

Defined in

packages/sheets-formula/src/services/register-other-formula.service.ts:170 (opens in a new tab)

dispose()

dispose(): void

Returns

void

Overrides

Disposable.dispose

Defined in

packages/sheets-formula/src/services/register-other-formula.service.ts:46 (opens in a new tab)

disposeWithMe()

disposeWithMe(disposable): IDisposable

Parameters

Parameter	Type
`disposable`	`DisposableLike`

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)

getFormulaValue()

getFormulaValue(
   unitId, 
   subUnitId, 
formulaId): Promise<Nullable<IOtherFormulaResult>>

Parameters

Parameter	Type
`unitId`	`string`
`subUnitId`	`string`
`formulaId`	`string`

Returns

Promise<Nullable<IOtherFormulaResult>>

Defined in

packages/sheets-formula/src/services/register-other-formula.service.ts:181 (opens in a new tab)

getFormulaValueSync()

getFormulaValueSync(
   unitId, 
   subUnitId, 
formulaId): Nullable<IOtherFormulaResult>

Parameters

Parameter	Type
`unitId`	`string`
`subUnitId`	`string`
`formulaId`	`string`

Returns

Nullable<IOtherFormulaResult>

Defined in

packages/sheets-formula/src/services/register-other-formula.service.ts:199 (opens in a new tab)

registerFormula()

registerFormula(
   unitId, 
   subUnitId, 
   formulaText, 
   extra?): string

Parameters

Parameter	Type
`unitId`	`string`
`subUnitId`	`string`
`formulaText`	`string`
`extra`?	`Record`<`string`, `any`>

Returns

string

Defined in

packages/sheets-formula/src/services/register-other-formula.service.ts:150 (opens in a new tab)

Registerfunctionservice Remoteregisterfunctionservice