@univerjs/sheets-data-validation v0.4.2 • Docs
Class: DataValidationFormulaService
Extends
Constructors
new DataValidationFormulaService()
new DataValidationFormulaService(
_instanceService,
_registerOtherFormulaService,
_dataValidationCacheService,
_dataValidationModel): DataValidationFormulaServiceParameters
| Parameter | Type |
|---|---|
_instanceService | IUniverInstanceService |
_registerOtherFormulaService | RegisterOtherFormulaService |
_dataValidationCacheService | DataValidationCacheService |
_dataValidationModel | DataValidationModel |
Returns
Overrides
Defined in
sheets-data-validation/src/services/dv-formula.service.ts:31 (opens in a new tab)
Properties
| Property | Modifier | Type | Default value | Inherited from | Defined in |
|---|---|---|---|---|---|
_disposed | protected | boolean | false | Disposable._disposed | 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
sheets-data-validation/src/services/dv-formula.service.ts:83 (opens in a new tab)
dispose()
dispose(): voidReturns
void
Inherited from
Defined in
core/src/shared/lifecycle.ts:106 (opens in a new tab)
disposeWithMe()
disposeWithMe(disposable): IDisposableParameters
| Parameter | Type |
|---|---|
disposable | DisposableLike |
Returns
Inherited from
Defined in
core/src/shared/lifecycle.ts:96 (opens in a new tab)
ensureNotDisposed()
protected ensureNotDisposed(): voidReturns
void
Inherited from
Defined in
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
sheets-data-validation/src/services/dv-formula.service.ts:183 (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
sheets-data-validation/src/services/dv-formula.service.ts:150 (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
sheets-data-validation/src/services/dv-formula.service.ts:165 (opens in a new tab)
removeRule()
removeRule(
unitId,
subUnitId,
ruleId): voidParameters
| Parameter | Type |
|---|---|
unitId | string |
subUnitId | string |
ruleId | string |
Returns
void
Defined in
sheets-data-validation/src/services/dv-formula.service.ts:103 (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
sheets-data-validation/src/services/dv-formula.service.ts:114 (opens in a new tab)