@univerjs/sheets-data-validation v0.5.0-beta.1 • Docs

Class: DataValidationCustomFormulaService

Extends

Disposable

Constructors

new DataValidationCustomFormulaService()

new DataValidationCustomFormulaService(
   _instanceSrv, 
   _registerOtherFormulaService, 
   _dataValidationModel, 
   _dataValidationCacheService): DataValidationCustomFormulaService

Parameters

Parameter	Type
`_instanceSrv`	`IUniverInstanceService`
`_registerOtherFormulaService`	`RegisterOtherFormulaService`
`_dataValidationModel`	`DataValidationModel`
`_dataValidationCacheService`	`DataValidationCacheService`

Returns

DataValidationCustomFormulaService

Overrides

Disposable.constructor

Defined in

sheets-data-validation/src/services/dv-custom-formula.service.ts:42

Properties

Property	Modifier	Type	Default value	Inherited from	Defined in
`_disposed`	`protected`	`boolean`	`false`	`Disposable`.`_disposed`	core/src/shared/lifecycle.ts:93

Methods

addRule()

addRule(
   unitId, 
   subUnitId, 
   rule): void

Parameters

Parameter	Type
`unitId`	`string`
`subUnitId`	`string`
`rule`	`ISheetDataValidationRule`

Returns

void

Defined in

sheets-data-validation/src/services/dv-custom-formula.service.ts:158

deleteByRuleId()

deleteByRuleId(
   unitId, 
   subUnitId, 
   ruleId): void

Parameters

Parameter	Type
`unitId`	`string`
`subUnitId`	`string`
`ruleId`	`string`

Returns

void

Defined in

sheets-data-validation/src/services/dv-custom-formula.service.ts:109

dispose()

dispose(): void

Returns

void

Inherited from

Disposable.dispose

Defined in

core/src/shared/lifecycle.ts:106

disposeWithMe()

disposeWithMe(disposable): IDisposable

Parameters

Parameter	Type
`disposable`	`DisposableLike`

Returns

IDisposable

Inherited from

Disposable.disposeWithMe

Defined in

core/src/shared/lifecycle.ts:96

ensureNotDisposed()

protected ensureNotDisposed(): void

Returns

void

Inherited from

Disposable.ensureNotDisposed

Defined in

core/src/shared/lifecycle.ts:100

getCellFormula2Value()

getCellFormula2Value(
   unitId, 
   subUnitId, 
   ruleId, 
   row, 
column): Promise<Nullable<ICellData>>

Parameters

Parameter	Type
`unitId`	`string`
`subUnitId`	`string`
`ruleId`	`string`
`row`	`number`
`column`	`number`

Returns

Promise<Nullable<ICellData>>

Defined in

sheets-data-validation/src/services/dv-custom-formula.service.ts:179

getCellFormula2ValueSync()

getCellFormula2ValueSync(
   unitId, 
   subUnitId, 
   ruleId, 
   row, 
column): Nullable<ICellData>

Parameters

Parameter	Type
`unitId`	`string`
`subUnitId`	`string`
`ruleId`	`string`
`row`	`number`
`column`	`number`

Returns

Nullable<ICellData>

Defined in

sheets-data-validation/src/services/dv-custom-formula.service.ts:207

getCellFormulaValue()

getCellFormulaValue(
   unitId, 
   subUnitId, 
   ruleId, 
   row, 
column): Promise<Nullable<ICellData>>

Parameters

Parameter	Type
`unitId`	`string`
`subUnitId`	`string`
`ruleId`	`string`
`row`	`number`
`column`	`number`

Returns

Promise<Nullable<ICellData>>

Defined in

sheets-data-validation/src/services/dv-custom-formula.service.ts:165

getCellFormulaValueSync()

getCellFormulaValueSync(
   unitId, 
   subUnitId, 
   ruleId, 
   row, 
column): Nullable<ICellData>

Parameters

Parameter	Type
`unitId`	`string`
`subUnitId`	`string`
`ruleId`	`string`
`row`	`number`
`column`	`number`

Returns

Nullable<ICellData>

Defined in

sheets-data-validation/src/services/dv-custom-formula.service.ts:193

getRuleFormulaInfo()

getRuleFormulaInfo(
   unitId, 
   subUnitId, 
   ruleId): undefined | IFormulaData

Parameters

Parameter	Type
`unitId`	`string`
`subUnitId`	`string`
`ruleId`	`string`

Returns

undefined | IFormulaData

Defined in

sheets-data-validation/src/services/dv-custom-formula.service.ts:221

Datavalidationcacheservice Datavalidationformulacontroller