@univerjs/sheets-data-validation v0.1.17 • Docs
Class: DataValidationFormulaService
Extends
Constructors
new DataValidationFormulaService()
new DataValidationFormulaService(
_registerOtherFormulaService,
_dataValidationCacheService,
_dataValidationModel): DataValidationFormulaServiceParameters
| Parameter | Type |
|---|---|
_registerOtherFormulaService | RegisterOtherFormulaService |
_dataValidationCacheService | DataValidationCacheService |
_dataValidationModel | DataValidationModel<IDataValidationRule> |
Returns
Overrides
Defined in
packages/sheets-data-validation/src/services/dv-formula.service.ts:32 (opens in a new tab)
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) |
Methods
addRule()
addRule(
unitId,
subUnitId,
ruleId,
formula1,
formula2): voidParameters
| Parameter | Type |
|---|---|
unitId | string |
subUnitId | string |
ruleId | string |
formula1 | undefined | string |
formula2 | undefined | string |
Returns
void
Defined in
packages/sheets-data-validation/src/services/dv-formula.service.ts:80 (opens in a new tab)
dispose()
dispose(): voidReturns
void
Inherited from
Defined in
packages/core/src/shared/lifecycle.ts:106 (opens in a new tab)
disposeWithMe()
protected disposeWithMe(disposable): IDisposableParameters
| Parameter | Type |
|---|---|
disposable | DisposableLike |
Returns
IDisposable
Inherited from
Defined in
packages/core/src/shared/lifecycle.ts:96 (opens in a new tab)
ensureNotDisposed()
protected ensureNotDisposed(): voidReturns
void
Inherited from
Defined in
packages/core/src/shared/lifecycle.ts:100 (opens in a new tab)
getRuleFormulaInfo()
getRuleFormulaInfo(
unitId,
subUnitId,
ruleId): undefined | [undefined | IFormulaInfo, undefined | IFormulaInfo]Parameters
| Parameter | Type |
|---|---|
unitId | string |
subUnitId | string |
ruleId | string |
Returns
undefined | [undefined | IFormulaInfo, undefined | IFormulaInfo]
Defined in
packages/sheets-data-validation/src/services/dv-formula.service.ts:180 (opens in a new tab)
getRuleFormulaResult()
getRuleFormulaResult(
unitId,
subUnitId,
ruleId): Promise<Nullable<[Nullable<IOtherFormulaResult>, Nullable<IOtherFormulaResult>]>>Parameters
| Parameter | Type |
|---|---|
unitId | string |
subUnitId | string |
ruleId | string |
Returns
Promise<Nullable<[Nullable<IOtherFormulaResult>, Nullable<IOtherFormulaResult>]>>
Defined in
packages/sheets-data-validation/src/services/dv-formula.service.ts:147 (opens in a new tab)
getRuleFormulaResultSync()
getRuleFormulaResultSync(
unitId,
subUnitId,
ruleId): undefined | Nullable<IOtherFormulaResult>[]Parameters
| Parameter | Type |
|---|---|
unitId | string |
subUnitId | string |
ruleId | string |
Returns
undefined | Nullable<IOtherFormulaResult>[]
Defined in
packages/sheets-data-validation/src/services/dv-formula.service.ts:162 (opens in a new tab)
removeRule()
removeRule(
unitId,
subUnitId,
ruleId): voidParameters
| Parameter | Type |
|---|---|
unitId | string |
subUnitId | string |
ruleId | string |
Returns
void
Defined in
packages/sheets-data-validation/src/services/dv-formula.service.ts:100 (opens in a new tab)
updateRuleFormulaText()
updateRuleFormulaText(
unitId,
subUnitId,
ruleId,
formula1,
formula2): voidParameters
| Parameter | Type |
|---|---|
unitId | string |
subUnitId | string |
ruleId | string |
formula1 | undefined | string |
formula2 | undefined | string |
Returns
void
Defined in
packages/sheets-data-validation/src/services/dv-formula.service.ts:111 (opens in a new tab)