@univerjs/sheets-data-validation v0.1.17 • Docs
Class: DataValidationCustomFormulaService
Extends
Constructors
new DataValidationCustomFormulaService()
new DataValidationCustomFormulaService(
_registerOtherFormulaService,
_lexerTreeBuilder,
_dataValidationModel,
_dataValidationCacheService): DataValidationCustomFormulaServiceParameters
| Parameter | Type |
|---|---|
_registerOtherFormulaService | RegisterOtherFormulaService |
_lexerTreeBuilder | LexerTreeBuilder |
_dataValidationModel | DataValidationModel<IDataValidationRule> |
_dataValidationCacheService | DataValidationCacheService |
Returns
DataValidationCustomFormulaService
Overrides
Defined in
packages/sheets-data-validation/src/services/dv-custom-formula.service.ts:63 (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,
rule): voidParameters
| Parameter | Type |
|---|---|
unitId | string |
subUnitId | string |
rule | ISheetDataValidationRule |
Returns
void
Defined in
packages/sheets-data-validation/src/services/dv-custom-formula.service.ts:225 (opens in a new tab)
deleteByRuleId()
deleteByRuleId(
unitId,
subUnitId,
ruleId): voidParameters
| Parameter | Type |
|---|---|
unitId | string |
subUnitId | string |
ruleId | string |
Returns
void
Defined in
packages/sheets-data-validation/src/services/dv-custom-formula.service.ts:139 (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)
getCellFormulaValue()
getCellFormulaValue(
unitId,
subUnitId,
row,
col): Promise<Nullable<IOtherFormulaResult>>Parameters
| Parameter | Type |
|---|---|
unitId | string |
subUnitId | string |
row | number |
col | number |
Returns
Promise<Nullable<IOtherFormulaResult>>
Defined in
packages/sheets-data-validation/src/services/dv-custom-formula.service.ts:309 (opens in a new tab)
getRuleFormulaInfo()
getRuleFormulaInfo(
unitId,
subUnitId,
ruleId): undefined | IFormulaDataParameters
| Parameter | Type |
|---|---|
unitId | string |
subUnitId | string |
ruleId | string |
Returns
undefined | IFormulaData
Defined in
packages/sheets-data-validation/src/services/dv-custom-formula.service.ts:319 (opens in a new tab)
updateRuleFormula()
updateRuleFormula(
unitId,
subUnitId,
ruleId,
ranges,
formula): voidParameters
| Parameter | Type |
|---|---|
unitId | string |
subUnitId | string |
ruleId | string |
ranges | IRange[] |
formula | string |
Returns
void
Defined in
packages/sheets-data-validation/src/services/dv-custom-formula.service.ts:301 (opens in a new tab)
updateRuleRanges()
updateRuleRanges(
unitId,
subUnitId,
ruleId,
oldRanges,
newRanges): voidParameters
| Parameter | Type |
|---|---|
unitId | string |
subUnitId | string |
ruleId | string |
oldRanges | IRange[] |
newRanges | IRange[] |
Returns
void
Defined in
packages/sheets-data-validation/src/services/dv-custom-formula.service.ts:233 (opens in a new tab)