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


Class: DataValidationFormulaService

Extends

Constructors

new DataValidationFormulaService()

new DataValidationFormulaService(
   _instanceService, 
   _registerOtherFormulaService, 
   _dataValidationCacheService, 
   _dataValidationModel): DataValidationFormulaService

Parameters

ParameterType
_instanceServiceIUniverInstanceService
_registerOtherFormulaServiceRegisterOtherFormulaService
_dataValidationCacheServiceDataValidationCacheService
_dataValidationModelDataValidationModel

Returns

DataValidationFormulaService

Overrides

Disposable.constructor

Defined in

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

Properties

PropertyModifierTypeDefault valueInherited fromDefined in
_disposedprotectedbooleanfalseDisposable._disposedcore/src/shared/lifecycle.ts:93

Methods

addRule()

addRule(
   unitId, 
   subUnitId, 
   rule): void

Parameters

ParameterType
unitIdstring
subUnitIdstring
ruleISheetDataValidationRule

Returns

void

Defined in

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


dispose()

dispose(): void

Returns

void

Inherited from

Disposable.dispose

Defined in

core/src/shared/lifecycle.ts:106


disposeWithMe()

disposeWithMe(disposable): IDisposable

Parameters

ParameterType
disposableDisposableLike

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


getRuleFormulaInfo()

getRuleFormulaInfo(
   unitId, 
   subUnitId, 
   ruleId): undefined | [undefined | IFormulaInfo, undefined | IFormulaInfo]

Parameters

ParameterType
unitIdstring
subUnitIdstring
ruleIdstring

Returns

undefined | [undefined | IFormulaInfo, undefined | IFormulaInfo]

Defined in

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


getRuleFormulaResult()

getRuleFormulaResult(
   unitId, 
   subUnitId, 
ruleId): Promise<Nullable<[Nullable<IOtherFormulaResult>, Nullable<IOtherFormulaResult>]>>

Parameters

ParameterType
unitIdstring
subUnitIdstring
ruleIdstring

Returns

Promise<Nullable<[Nullable<IOtherFormulaResult>, Nullable<IOtherFormulaResult>]>>

Defined in

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


getRuleFormulaResultSync()

getRuleFormulaResultSync(
   unitId, 
   subUnitId, 
   ruleId): undefined | Nullable<IOtherFormulaResult>[]

Parameters

ParameterType
unitIdstring
subUnitIdstring
ruleIdstring

Returns

undefined | Nullable<IOtherFormulaResult>[]

Defined in

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


removeRule()

removeRule(
   unitId, 
   subUnitId, 
   ruleId): void

Parameters

ParameterType
unitIdstring
subUnitIdstring
ruleIdstring

Returns

void

Defined in

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