Interface PivotValue

Access and modify value groups in pivot tables.

interface PivotValue {
    getDisplayType(): PivotValueDisplayType;
    getFormula(): string;
    getPivotTable(): GoogleAppsScript.Spreadsheet.PivotTable;
    getSummarizedBy(): PivotTableSummarizeFunction;
    setDisplayName(name: string): GoogleAppsScript.Spreadsheet.PivotValue;
    setFormula(formula: string): GoogleAppsScript.Spreadsheet.PivotValue;
    showAs(
        displayType: PivotValueDisplayType,
    ): GoogleAppsScript.Spreadsheet.PivotValue;
    summarizeBy(
        summarizeFunction: PivotTableSummarizeFunction,
    ): GoogleAppsScript.Spreadsheet.PivotValue;
}

Index

Methods

getDisplayType getFormula getPivotTable getSummarizedBy setDisplayName setFormula showAs summarizeBy

Methods

getDisplayType

getDisplayType(): PivotValueDisplayType
Returns PivotValueDisplayType
- Defined in google-apps-script-typedoc/DefinitelyTyped/types/google-apps-script/google-apps-script.spreadsheet.d.ts:1545

getFormula

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

getPivotTable

getPivotTable(): GoogleAppsScript.Spreadsheet.PivotTable
Returns GoogleAppsScript.Spreadsheet.PivotTable
- Defined in google-apps-script-typedoc/DefinitelyTyped/types/google-apps-script/google-apps-script.spreadsheet.d.ts:1547

getSummarizedBy

getSummarizedBy(): PivotTableSummarizeFunction
Returns PivotTableSummarizeFunction
- Defined in google-apps-script-typedoc/DefinitelyTyped/types/google-apps-script/google-apps-script.spreadsheet.d.ts:1548

setDisplayName

setDisplayName(name: string): GoogleAppsScript.Spreadsheet.PivotValue
Parameters
- name: string
Returns GoogleAppsScript.Spreadsheet.PivotValue
- Defined in google-apps-script-typedoc/DefinitelyTyped/types/google-apps-script/google-apps-script.spreadsheet.d.ts:1549

setFormula

setFormula(formula: string): GoogleAppsScript.Spreadsheet.PivotValue
Parameters
- formula: string
Returns GoogleAppsScript.Spreadsheet.PivotValue
- Defined in google-apps-script-typedoc/DefinitelyTyped/types/google-apps-script/google-apps-script.spreadsheet.d.ts:1550

showAs

showAs(
displayType: PivotValueDisplayType,
): GoogleAppsScript.Spreadsheet.PivotValue
Parameters
- displayType: PivotValueDisplayType
Returns GoogleAppsScript.Spreadsheet.PivotValue
- Defined in google-apps-script-typedoc/DefinitelyTyped/types/google-apps-script/google-apps-script.spreadsheet.d.ts:1551

summarizeBy

summarizeBy(
summarizeFunction: PivotTableSummarizeFunction,
): GoogleAppsScript.Spreadsheet.PivotValue
Parameters
- summarizeFunction: PivotTableSummarizeFunction
Returns GoogleAppsScript.Spreadsheet.PivotValue
- Defined in google-apps-script-typedoc/DefinitelyTyped/types/google-apps-script/google-apps-script.spreadsheet.d.ts:1552