Interface DataSourceFormula

Access and modify existing data source formulas.

interface DataSourceFormula {
    forceRefreshData(): DataSourceFormula;
    getAnchorCell(): GoogleAppsScript.Spreadsheet.Range;
    getDataSource(): DataSource;
    getDisplayValue(): string;
    getFormula(): string;
    getStatus(): DataExecutionStatus;
    refreshData(): DataSourceFormula;
    setFormula(formula: string): DataSourceFormula;
    waitForCompletion(timeoutInSeconds: number): DataExecutionStatus;
}

Index

Methods

forceRefreshData getAnchorCell getDataSource getDisplayValue getFormula getStatus refreshData setFormula waitForCompletion

Methods

forceRefreshData

forceRefreshData(): DataSourceFormula
Returns DataSourceFormula
- Defined in google-apps-script-typedoc/DefinitelyTyped/types/google-apps-script/google-apps-script.spreadsheet.d.ts:360

getAnchorCell

getAnchorCell(): GoogleAppsScript.Spreadsheet.Range
Returns GoogleAppsScript.Spreadsheet.Range
- Defined in google-apps-script-typedoc/DefinitelyTyped/types/google-apps-script/google-apps-script.spreadsheet.d.ts:361

getDataSource

getDataSource(): DataSource
Returns DataSource
- Defined in google-apps-script-typedoc/DefinitelyTyped/types/google-apps-script/google-apps-script.spreadsheet.d.ts:362

getDisplayValue

getDisplayValue(): string
Returns string
- Defined in google-apps-script-typedoc/DefinitelyTyped/types/google-apps-script/google-apps-script.spreadsheet.d.ts:363

getFormula

getFormula(): string
Returns string
- Defined in google-apps-script-typedoc/DefinitelyTyped/types/google-apps-script/google-apps-script.spreadsheet.d.ts:364

getStatus

getStatus(): DataExecutionStatus
Returns DataExecutionStatus
- Defined in google-apps-script-typedoc/DefinitelyTyped/types/google-apps-script/google-apps-script.spreadsheet.d.ts:365

refreshData

refreshData(): DataSourceFormula
Returns DataSourceFormula
- Defined in google-apps-script-typedoc/DefinitelyTyped/types/google-apps-script/google-apps-script.spreadsheet.d.ts:366

setFormula

setFormula(formula: string): DataSourceFormula
Parameters
- formula: string
Returns DataSourceFormula
- Defined in google-apps-script-typedoc/DefinitelyTyped/types/google-apps-script/google-apps-script.spreadsheet.d.ts:367

waitForCompletion

waitForCompletion(timeoutInSeconds: number): DataExecutionStatus
Parameters
- timeoutInSeconds: number
Returns DataExecutionStatus
- Defined in google-apps-script-typedoc/DefinitelyTyped/types/google-apps-script/google-apps-script.spreadsheet.d.ts:368