@univerjs/sheets-data-validation v0.5.4

Class: DataValidationCustomFormulaService

Defined in: sheets-data-validation/src/services/dv-custom-formula.service.ts:35

Extends

Disposable

Constructors

new DataValidationCustomFormulaService()

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

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

Parameters

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

Returns

DataValidationCustomFormulaService

Overrides

Disposable.constructor

Properties

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

Methods

addRule()

addRule(
   unitId, 
   subUnitId, 
   rule): void

Defined in: sheets-data-validation/src/services/dv-custom-formula.service.ts:159

Parameters

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

Returns

void

deleteByRuleId()

deleteByRuleId(
   unitId, 
   subUnitId, 
   ruleId): void

Defined in: sheets-data-validation/src/services/dv-custom-formula.service.ts:110

Parameters

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

Returns

void

dispose()

dispose(): void

Defined in: core/src/shared/lifecycle.ts:109

Returns

void

Inherited from

Disposable.dispose

disposeWithMe()

disposeWithMe(disposable): IDisposable

Defined in: core/src/shared/lifecycle.ts:99

Parameters

Parameter	Type
`disposable`	`DisposableLike`

Returns

IDisposable

Inherited from

Disposable.disposeWithMe

ensureNotDisposed()

protected ensureNotDisposed(): void

Defined in: core/src/shared/lifecycle.ts:103

Returns

void

Inherited from

Disposable.ensureNotDisposed

getCellFormula2Value()

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

Defined in: sheets-data-validation/src/services/dv-custom-formula.service.ts:180

Parameters

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

Returns

Promise<Nullable<ICellData>>

getCellFormula2ValueSync()

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

Defined in: sheets-data-validation/src/services/dv-custom-formula.service.ts:208

Parameters

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

Returns

Nullable<ICellData>

getCellFormulaValue()

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

Defined in: sheets-data-validation/src/services/dv-custom-formula.service.ts:166

Parameters

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

Returns

Promise<Nullable<ICellData>>

getCellFormulaValueSync()

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

Defined in: sheets-data-validation/src/services/dv-custom-formula.service.ts:194

Parameters

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

Returns

Nullable<ICellData>

getRuleFormulaInfo()

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

Defined in: sheets-data-validation/src/services/dv-custom-formula.service.ts:222

Parameters

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

Returns

undefined | IFormulaData

Datavalidationcacheservice Datavalidationformulacontroller