@univerjs/sheets-data-validation v0.4.2 • Docs
Class: DataValidationCustomFormulaService
Extends
Constructors
new DataValidationCustomFormulaService()
new DataValidationCustomFormulaService(
_instanceSrv,
_registerOtherFormulaService,
_lexerTreeBuilder,
_dataValidationModel,
_dataValidationCacheService,
_injector): DataValidationCustomFormulaServiceParameters
| Parameter | Type |
|---|---|
_instanceSrv | IUniverInstanceService |
_registerOtherFormulaService | RegisterOtherFormulaService |
_lexerTreeBuilder | LexerTreeBuilder |
_dataValidationModel | DataValidationModel |
_dataValidationCacheService | DataValidationCacheService |
_injector | Injector |
Returns
DataValidationCustomFormulaService
Overrides
Defined in
sheets-data-validation/src/services/dv-custom-formula.service.ts:65 (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,
rule): voidParameters
| Parameter | Type |
|---|---|
unitId | string |
subUnitId | string |
rule | ISheetDataValidationRule |
Returns
void
Defined in
sheets-data-validation/src/services/dv-custom-formula.service.ts:214 (opens in a new tab)
deleteByRuleId()
deleteByRuleId(
unitId,
subUnitId,
ruleId): voidParameters
| Parameter | Type |
|---|---|
unitId | string |
subUnitId | string |
ruleId | string |
Returns
void
Defined in
sheets-data-validation/src/services/dv-custom-formula.service.ts:146 (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)
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
sheets-data-validation/src/services/dv-custom-formula.service.ts:297 (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
sheets-data-validation/src/services/dv-custom-formula.service.ts:307 (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
sheets-data-validation/src/services/dv-custom-formula.service.ts:289 (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
sheets-data-validation/src/services/dv-custom-formula.service.ts:222 (opens in a new tab)