ExtReact Docs Help

Introduction

The documentation for the ExtReact product diverges somewhat from the documentation of other Sencha products. The sections below describe documentation for all products except where indicated as unique to ExtReact.

Terms, Icons, and Labels

Many classes have shortcut names used when creating (instantiating) a class with a configuration object. The shortcut name is referred to as an alias (or xtype if the class extends Ext.Component). The alias/xtype is listed next to the class name of applicable classes for quick reference.

ExtReact component classes list the configurable name prominently at the top of the API class doc followed by the fully-qualified class name.

Access Levels

Framework classes or their members may be specified as private or protected. Else, the class / member is public. Public, protected, and private are access descriptors used to convey how and when the class or class member should be used.

Member Types

Member Syntax

Below is an example class member that we can disect to show the syntax of a class member (the lookupComponent method as viewed from the Ext.button.Button class in this case).

lookupComponent ( item ) : Ext.Component
protected

Called when a raw config object is added to this container either during initialization of the items config, or when new items are added), or {@link #insert inserted.

This method converts the passed object into an instanced child component.

This may be overridden in subclasses when special processing needs to be applied to child creation.

Parameters

item :  Object

The config object being added.

Returns
Ext.Component

The component to be added.

Let's look at each part of the member row:

Member Flags

The API documentation uses a number of flags to further commnicate the class member's function and intent. The label may be represented by a text label, an abbreviation, or an icon.

Class Icons

- Indicates a framework class

- A singleton framework class. *See the singleton flag for more information

- A component-type framework class (any class within the Ext JS framework that extends Ext.Component)

- Indicates that the class, member, or guide is new in the currently viewed version

Member Icons

- Indicates a class member of type config

Or in the case of an ExtReact component class this indicates a member of type prop

- Indicates a class member of type property

- Indicates a class member of type method

- Indicates a class member of type event

- Indicates a class member of type theme variable

- Indicates a class member of type theme mixin

- Indicates that the class, member, or guide is new in the currently viewed version

Class Member Quick-Nav Menu

Just below the class name on an API doc page is a row of buttons corresponding to the types of members owned by the current class. Each button shows a count of members by type (this count is updated as filters are applied). Clicking the button will navigate you to that member section. Hovering over the member-type button will reveal a popup menu of all members of that type for quick navigation.

Getter and Setter Methods

Getting and setter methods that correlate to a class config option will show up in the methods section as well as in the configs section of both the API doc and the member-type menus just beneath the config they work with. The getter and setter method documentation will be found in the config row for easy reference.

ExtReact component classes do not hoist the getter / setter methods into the prop. All methods will be described in the Methods section

History Bar

Your page history is kept in localstorage and displayed (using the available real estate) just below the top title bar. By default, the only search results shown are the pages matching the product / version you're currently viewing. You can expand what is displayed by clicking on the button on the right-hand side of the history bar and choosing the "All" radio option. This will show all recent pages in the history bar for all products / versions.

Within the history config menu you will also see a listing of your recent page visits. The results are filtered by the "Current Product / Version" and "All" radio options. Clicking on the button will clear the history bar as well as the history kept in local storage.

If "All" is selected in the history config menu the checkbox option for "Show product details in the history bar" will be enabled. When checked, the product/version for each historic page will show alongside the page name in the history bar. Hovering the cursor over the page names in the history bar will also show the product/version as a tooltip.

Search and Filters

Both API docs and guides can be searched for using the search field at the top of the page.

On API doc pages there is also a filter input field that filters the member rows using the filter string. In addition to filtering by string you can filter the class members by access level, inheritance, and read only. This is done using the checkboxes at the top of the page.

The checkbox at the bottom of the API class navigation tree filters the class list to include or exclude private classes.

Clicking on an empty search field will show your last 10 searches for quick navigation.

API Doc Class Metadata

Each API doc page (with the exception of Javascript primitives pages) has a menu view of metadata relating to that class. This metadata view will have one or more of the following:

Expanding and Collapsing Examples and Class Members

Runnable examples (Fiddles) are expanded on a page by default. You can collapse and expand example code blocks individually using the arrow on the top-left of the code block. You can also toggle the collapse state of all examples using the toggle button on the top-right of the page. The toggle-all state will be remembered between page loads.

Class members are collapsed on a page by default. You can expand and collapse members using the arrow icon on the left of the member row or globally using the expand / collapse all toggle button top-right.

Desktop -vs- Mobile View

Viewing the docs on narrower screens or browsers will result in a view optimized for a smaller form factor. The primary differences between the desktop and "mobile" view are:

Viewing the Class Source

The class source can be viewed by clicking on the class name at the top of an API doc page. The source for class members can be viewed by clicking on the "view source" link on the right-hand side of the member row.

ExtReact 6.6.0


top
NOTE: This is a private utility class for internal use by the framework. Don't rely on its existence.

Summary

Represents the PivotTable root element for non-null PivotTables. There exists one pivotTableDefinition for each PivotTableDefinition part.

(CT_PivotTableDefinition)

No members found using the current filters

configs

Required Configs

cacheId : Number
required req

Specifies the identifier of the related PivotCache definition. This Id is listed in the pivotCaches collection in the workbook part.

Defaults to:

null

getCacheId : Number

Returns the value of cacheId

Returns

Number

setCacheId (cacheId)

Sets the value of cacheId

Parameters

cacheId :  Number

dataCaption : String
required req

Specifies the name of the value area field header in the PivotTable. This caption is shown in the PivotTable when two or more fields are in the values area.

Defaults to:

'Values'

getDataCaption : String

Returns the value of dataCaption

Returns

String

setDataCaption (dataCaption)

Sets the value of dataCaption

Parameters

dataCaption :  String

name : String
required req

Specifies the PivotTable name.

Defaults to:

null

getName : String

Returns the value of name

Returns

String

setName (name)

Sets the value of name

Parameters

name :  String

Optional Configs

applyAlignmentFormats : Boolean

If true apply legacy table auto-format alignment properties.

Defaults to:

false

getApplyAlignmentFormats : Boolean

Returns the value of applyAlignmentFormats

Returns

Boolean

setApplyAlignmentFormats (applyAlignmentFormats)

Sets the value of applyAlignmentFormats

Parameters

applyAlignmentFormats :  Boolean

applyBorderFormats : Boolean

If true apply legacy table auto-format border properties.

Defaults to:

false

getApplyBorderFormats : Boolean

Returns the value of applyBorderFormats

Returns

Boolean

setApplyBorderFormats (applyBorderFormats)

Sets the value of applyBorderFormats

Parameters

applyBorderFormats :  Boolean

applyFontFormats : Boolean

If true apply legacy table auto-format font properties.

Defaults to:

false

getApplyFontFormats : Boolean

Returns the value of applyFontFormats

Returns

Boolean

setApplyFontFormats (applyFontFormats)

Sets the value of applyFontFormats

Parameters

applyFontFormats :  Boolean

applyNumberFormats : Boolean

If true apply legacy table auto-format number format properties.

Defaults to:

false

getApplyNumberFormats : Boolean

Returns the value of applyNumberFormats

Returns

Boolean

setApplyNumberFormats (applyNumberFormats)

Sets the value of applyNumberFormats

Parameters

applyNumberFormats :  Boolean

applyPatternFormats : Boolean

If true apply legacy table auto-format pattern properties.

Defaults to:

false

getApplyPatternFormats : Boolean

Returns the value of applyPatternFormats

Returns

Boolean

setApplyPatternFormats (applyPatternFormats)

Sets the value of applyPatternFormats

Parameters

applyPatternFormats :  Boolean

applyWidthHeightFormats : Boolean

If true apply legacy table auto-format width/height properties.

Defaults to:

true

getApplyWidthHeightFormats : Boolean

Returns the value of applyWidthHeightFormats

Returns

Boolean

setApplyWidthHeightFormats (applyWidthHeightFormats)

Sets the value of applyWidthHeightFormats

Parameters

applyWidthHeightFormats :  Boolean

asteriskTotals : Boolean

Specifies a boolean value that indicates whether an asterisks should be displayed in subtotals and totals when visual totals are not used in OLAP -based PivotTables.

A value of 1 or true indicates an asterisks are displayed in subtotals and totals for OLAP PivotTables when visual tools are not available.

A value of 0 or false indicates an asterisk will not be displayed. This attribute depends on the implementation and availability of visual tools in the application user interface.

Defaults to:

null

getAsteriskTotals : Boolean

Returns the value of asteriskTotals

Returns

Boolean

setAsteriskTotals (asteriskTotals)

Sets the value of asteriskTotals

Parameters

asteriskTotals :  Boolean

autoFormatId : Number

Identifies which legacy table auto-format to apply.

Use a value >= 4096 and <= 4117.

Annex G of the file c061750_ISO_IEC_29500-1_2012.pdf contains a listing of the supported PivotTable AutoFormats, example formatting, and a sample workbook with each of those AutoFormats applied.

Defaults to:

4096

getAutoFormatId : Number

Returns the value of autoFormatId

Returns

Number

setAutoFormatId (autoFormatId)

Sets the value of autoFormatId

Parameters

autoFormatId :  Number

autoGenerateId : Boolean

Set to true to auto generate an id if none is defined.

Defaults to:

true

getAutoGenerateId : Boolean

Returns the value of autoGenerateId

Returns

Boolean

setAutoGenerateId (autoGenerateId)

Sets the value of autoGenerateId

Parameters

autoGenerateId :  Boolean

chartFormat : Number

Specifies the next chart formatting identifier to use on the PivotTable.

Defaults to:

null

getChartFormat : Number

Returns the value of chartFormat

Returns

Number

setChartFormat (chartFormat)

Sets the value of chartFormat

Parameters

chartFormat :  Number

colFields : Ext.exporter.file.ooxml.excel.Field[]

Represents the collection of fields that are on the column axis of the PivotTable.

Defaults to:

null

setColFields (colFields)

Sets the value of colFields

Parameters

colFields :  Ext.exporter.file.ooxml.excel.Field[]

colGrandTotals : Boolean

Specifies a boolean value that indicates whether grand totals should be displayed for the PivotTable columns.

A value of 1 or true indicates grand totals should be displayed.

A value of 0 or false indicates grand totals should not be displayed for PivotTable columns.

Defaults to:

null

getColGrandTotals : Boolean

Returns the value of colGrandTotals

Returns

Boolean

setColGrandTotals (colGrandTotals)

Sets the value of colGrandTotals

Parameters

colGrandTotals :  Boolean

colHeaderCaption : String

Specifies the string to be displayed in column header in compact mode. This attribute depends on whether the application implements a compact mode for displaying PivotTables in the user interface.

Defaults to:

null

getColHeaderCaption : String

Returns the value of colHeaderCaption

Returns

String

setColHeaderCaption (colHeaderCaption)

Sets the value of colHeaderCaption

Parameters

colHeaderCaption :  String

colItems : Ext.exporter.file.ooxml.excel.Item[]

Represents the collection of column items of the PivotTable.

Defaults to:

null

setColItems (colItems)

Sets the value of colItems

Parameters

colItems :  Ext.exporter.file.ooxml.excel.Item[]

compact : Boolean

Specifies a boolean value that indicates whether new fields should have their compact flag set to true.

A value of 1 or true indicates new fields should default to compact mode equal to true.

A value of 0 or false indicates new fields should default to compact mode equal to false. This attribute depends on whether the application implements a compact mode in the user interface.

Defaults to:

false

getCompact : Boolean

Returns the value of compact

Returns

Boolean

setCompact (compact)

Sets the value of compact

Parameters

compact :  Boolean

compactData : Boolean

Specifies a boolean value that indicates whether the field next to the data field in the PivotTable should be displayed in the same column of the spreadsheet

Defaults to:

false

getCompactData : Boolean

Returns the value of compactData

Returns

Boolean

setCompactData (compactData)

Sets the value of compactData

Parameters

compactData :  Boolean

createdVersion : Number

Specifies the version of the application that created the cache. This attribute is application-dependent.

Defaults to:

null

getCreatedVersion : Number

Returns the value of createdVersion

Returns

Number

setCreatedVersion (createdVersion)

Sets the value of createdVersion

Parameters

createdVersion :  Number

customListSort : Boolean

Specifies a boolean value that indicates whether the "custom lists" option is offered when sorting this PivotTable.

A value of 1 or true indicates custom lists are offered when sorting this PivotTable.

A value of 0 or false indicates custom lists are not offered. This attribute depends on the implementation of sorting features in the application.

Defaults to:

null

getCustomListSort : Boolean

Returns the value of customListSort

Returns

Boolean

setCustomListSort (customListSort)

Sets the value of customListSort

Parameters

customListSort :  Boolean

dataFields : Ext.exporter.file.ooxml.excel.DataField[]

Represents the collection of items in the data region of the PivotTable.

Defaults to:

null

setDataFields (dataFields)

Sets the value of dataFields

Parameters

dataFields :  Ext.exporter.file.ooxml.excel.DataField[]

dataOnRows : Boolean

Specifies a boolean value that indicates whether the field representing multiple fields in the data region is located in the row area or the column area.

A value of 1 or true indicates that this field is located in the row area.

A value of 0 or false indicates that this field is located in the column area.

Defaults to:

null

getDataOnRows : Boolean

Returns the value of dataOnRows

Returns

Boolean

setDataOnRows (dataOnRows)

Sets the value of dataOnRows

Parameters

dataOnRows :  Boolean

dataPosition : Number

Specifies the position for the field representing multiple data field in the PivotTable, whether that field is located in the row area or column area.

Missing attribute indicates this field is last, or innermost in the field list.

  • 0 indicates this field is first, or outermost in the field list.
  • 1 indicates this field is second in the field list.
  • 2 indicates this field is third in the field list, and increasing values follow this pattern.

    If this value is higher than the number of fields in the field list, then this field is last, or innermost in the field list.

Defaults to:

null

getDataPosition : Number

Returns the value of dataPosition

Returns

Number

setDataPosition (dataPosition)

Sets the value of dataPosition

Parameters

dataPosition :  Number

disableFieldList : Boolean

Specifies a boolean value that indicates whether to disable the PivotTable field list.

A value of 1 or true indicates the field list, or similar mechanism for selecting fields in the user interface, is disabled.

A value of 0 or false indicates the field list is enabled.

Defaults to:

null

getDisableFieldList : Boolean

Returns the value of disableFieldList

Returns

Boolean

setDisableFieldList (disableFieldList)

Sets the value of disableFieldList

Parameters

disableFieldList :  Boolean

editData : Boolean

Specifies a boolean value that indicates whether the user is allowed to edit the cells in the data area of the PivotTable.

A value of 1 or true indicates the user can edit values in the data area.

A value of 0 or false indicates the cells in the data area are not editable.

Defaults to:

null

getEditData : Boolean

Returns the value of editData

Returns

Boolean

setEditData (editData)

Sets the value of editData

Parameters

editData :  Boolean

enableDrill : Boolean

Specifies a boolean value that indicates whether the user is prevented from drilling down on a PivotItem or aggregate value.

A value of 1 or true indicates the user can drill down on a pivot item or aggregate value.

A value of 0 or false indicates the user is prevented from drilling down pivot item.

Defaults to:

null

getEnableDrill : Boolean

Returns the value of enableDrill

Returns

Boolean

setEnableDrill (enableDrill)

Sets the value of enableDrill

Parameters

enableDrill :  Boolean

enableFieldProperties : Boolean

Specifies a boolean value that indicates whether the user is prevented from displaying PivotField properties.

A value of 1 or true indicates the user can display pivot field properties.

A value of 0 or false indicates the user cannot display pivot field properties. This attribute depends on how pivot field properties are exposed in the application user interface.

Defaults to:

null

getEnableFieldProperties : Boolean

Returns the value of enableFieldProperties

Returns

Boolean

setEnableFieldProperties (enableFieldProperties)

Sets the value of enableFieldProperties

Parameters

enableFieldProperties :  Boolean

enableWizard : Boolean

Specifies a boolean value that indicates whether the user is prevented from displaying the PivotTable wizard.

A value of 1 or true indicates the user can display the PivotTable wizard.

A value of 0 or false indicates the user can not display the PivotTable wizard. This attribute depends on whether the application exposes a wizard or similar mechanism for creating and working with PivotTables in the user interface.

Defaults to:

null

getEnableWizard : Boolean

Returns the value of enableWizard

Returns

Boolean

setEnableWizard (enableWizard)

Sets the value of enableWizard

Parameters

enableWizard :  Boolean

errorCaption : String

Specifies the string to be displayed in cells that contain errors.

Defaults to:

null

getErrorCaption : String

Returns the value of errorCaption

Returns

String

setErrorCaption (errorCaption)

Sets the value of errorCaption

Parameters

errorCaption :  String

fieldListSortAscending : Boolean

Specifies a boolean value that indicates whether fields in the PivotTable are sorted in non-default order in the field list.

A value of 1 or true indicates fields for the PivotTable are sorted in the field list. The sort order from the data source is applied for range-based PivotTables. Alphabetical sorting is applied for external data PivotTables.

A value of 0 or false indicates fields in the field list are not sorted.

Defaults to:

null

getFieldListSortAscending : Boolean

Returns the value of fieldListSortAscending

Returns

Boolean

setFieldListSortAscending (fieldListSortAscending)

Sets the value of fieldListSortAscending

Parameters

fieldListSortAscending :  Boolean

fieldPrintTitles : Boolean

Specifies a boolean value that indicates whether the row and column titles from the PivotTable should be printed.

A value of 1 or true indicates row and column titles should be printed.

A value of 0 or false indicates row and column titles should not be printed.

Defaults to:

null

getFieldPrintTitles : Boolean

Returns the value of fieldPrintTitles

Returns

Boolean

setFieldPrintTitles (fieldPrintTitles)

Sets the value of fieldPrintTitles

Parameters

fieldPrintTitles :  Boolean

generateTplAttributes

Note Do not rename the config names that are part of the attributes since they are mapped to the xml attributes needed by the template.

Defaults to:

true

grandTotalCaption : String

Specifies the string to be displayed for grand totals.

Defaults to:

null

getGrandTotalCaption : String

Returns the value of grandTotalCaption

Returns

String

setGrandTotalCaption (grandTotalCaption)

Sets the value of grandTotalCaption

Parameters

grandTotalCaption :  String

gridDropZones : Boolean

Specifies a boolean value that indicates whether the in-grid drop zones should be displayed at runtime, and whether classic layout is applied.

A value of 1 or true indicates in-grid drop zones should be displayed and classic layout should be applied to the PivotTable.

A value of 0 or false indicates in-grid drop zones should be disabled and classic layout should not be applied.

Note: Grid drop zones are optional runtime UI, determined by the application, that indicate to the user the locations of the page, row, column, and data fields in the PivotTable report. See layout discussion under pivotTableDefinition for the precise locations of these areas.

Defaults to:

null

getGridDropZones : Boolean

Returns the value of gridDropZones

Returns

Boolean

setGridDropZones (gridDropZones)

Sets the value of gridDropZones

Parameters

gridDropZones :  Boolean

id : String

Unique id for this object. Auto generated when missing.

Defaults to:

null

getId : String

Returns the value of id

Returns

String

setId (id)

Sets the value of id

Parameters

id :  String

immersive : Boolean

Specifies a boolean value that indicates whether PivotTable immersive experience user interface should be turned off.

A value of 1 or true indicates the PivotTable immersive experience should be turned off for this PivotTable.

A value of 0 or false indicates the immersive experience should be left on. This attribute depends on whether the application implements an immersive experience in the user interface.

Defaults to:

null

getImmersive : Boolean

Returns the value of immersive

Returns

Boolean

setImmersive (immersive)

Sets the value of immersive

Parameters

immersive :  Boolean

indent : Number

Specifies the indentation increment for compact axis and can be used to set the Report Layout to Compact Form.

Defaults to:

null

getIndent : Number

Returns the value of indent

Returns

Number

setIndent (indent)

Sets the value of indent

Parameters

indent :  Number

itemPrintTitles : Boolean

Specifies a boolean value that indicates whether PivotItem names should be repeated at the top of each printed page.

A value of 1 or true indicates pivot items names should be repeated at the top of each page.

A value of 0 or false indicates should not be repeated.

Defaults to:

true

getItemPrintTitles : Boolean

Returns the value of itemPrintTitles

Returns

Boolean

setItemPrintTitles (itemPrintTitles)

Sets the value of itemPrintTitles

Parameters

itemPrintTitles :  Boolean

location : Ext.exporter.file.ooxml.excel.Location

Represents location information for the PivotTable.

Defaults to:

{}

setLocation (location)

Sets the value of location

Parameters

location :  Ext.exporter.file.ooxml.excel.Location

mdxSubqueries : Boolean

Specifies a boolean value that indicates whether MDX sub-queries are supported by OLAP data provider for this PivotTable.

A value of 1 or true indicates MDX sub-queries are supported by the OLAP data provider.

A value of 0 or false indicates MDX sub-queries are not supported.

Defaults to:

null

getMdxSubqueries : Boolean

Returns the value of mdxSubqueries

Returns

Boolean

setMdxSubqueries (mdxSubqueries)

Sets the value of mdxSubqueries

Parameters

mdxSubqueries :  Boolean

mergeItem : Boolean

Specifies a boolean value that indicates whether row or column titles that span multiple cells should be merged into a single cell.

A value of 1 or true indicates that titles that span multiple cells are merged into a single cell.

A value of 0 or false indicates titles are not merged.

Defaults to:

null

getMergeItem : Boolean

Returns the value of mergeItem

Returns

Boolean

setMergeItem (mergeItem)

Sets the value of mergeItem

Parameters

mergeItem :  Boolean

minRefreshableVersion : Number

Specifies the minimum version of the application required to update this PivotTable view. This attribute is application-dependent.

Defaults to:

null

getMinRefreshableVersion : Number

Returns the value of minRefreshableVersion

Returns

Number

setMinRefreshableVersion (minRefreshableVersion)

Sets the value of minRefreshableVersion

Parameters

minRefreshableVersion :  Number

missingCaption : String

Specifies the string to be displayed in cells with no value

Defaults to:

null

getMissingCaption : String

Returns the value of missingCaption

Returns

String

setMissingCaption (missingCaption)

Sets the value of missingCaption

Parameters

missingCaption :  String

multipleFieldFilters : Boolean

Specifies a boolean value that indicates whether the fields of a PivotTable can have multiple filters set on them.

A value of 1 or true indicates the fields of a PivotTable can have multiple filters.

A value of 0 or false indicates the fields of a PivotTable can only have a simple filter.

Defaults to:

null

getMultipleFieldFilters : Boolean

Returns the value of multipleFieldFilters

Returns

Boolean

setMultipleFieldFilters (multipleFieldFilters)

Sets the value of multipleFieldFilters

Parameters

multipleFieldFilters :  Boolean

outline : Boolean

Specifies a boolean value that indicates whether new fields should have their outline flag set to true.

A value of 1 or true indicates new fields are created with outline equal to true.

A value of 0 or false indicates new fields are created with outline equal to false.

Defaults to:

true

getOutline : Boolean

Returns the value of outline

Returns

Boolean

setOutline (outline)

Sets the value of outline

Parameters

outline :  Boolean

outlineData : Boolean

Specifies a boolean value that indicates whether data fields in the PivotTable should be displayed in outline form.

A value of 1 or true indicates data fields will display in outline form.

A value of 0 or false indicates data fields will not display in outline form.

Defaults to:

null

getOutlineData : Boolean

Returns the value of outlineData

Returns

Boolean

setOutlineData (outlineData)

Sets the value of outlineData

Parameters

outlineData :  Boolean

pageFields : Ext.exporter.file.ooxml.excel.PageField[]

Represents the collection of items in the page or report filter region of the PivotTable.

Defaults to:

null

setPageFields (pageFields)

Sets the value of pageFields

Parameters

pageFields :  Ext.exporter.file.ooxml.excel.PageField[]

pageOverThenDown : Boolean

Specifies a boolean value that indicates how the page fields are laid out when there are multiple PivotFields in the page area.

A value of 1 or true indicates the fields will display "Over, then down"

A value of 0 or false indicates the fields will display "down, then Over"

Defaults to:

null

getPageOverThenDown : Boolean

Returns the value of pageOverThenDown

Returns

Boolean

setPageOverThenDown (pageOverThenDown)

Sets the value of pageOverThenDown

Parameters

pageOverThenDown :  Boolean

pageStyle : String

Specifies the name of the style to apply to each of the field item headers in the page area of the PivotTable.

Defaults to:

null

getPageStyle : String

Returns the value of pageStyle

Returns

String

setPageStyle (pageStyle)

Sets the value of pageStyle

Parameters

pageStyle :  String

pageWrap : Number

Specifies the number of page fields to display before starting another row or column.

Defaults to:

null

getPageWrap : Number

Returns the value of pageWrap

Returns

Number

setPageWrap (pageWrap)

Sets the value of pageWrap

Parameters

pageWrap :  Number

path : String

Full path of the file inside the zip package

Defaults to:

null

getPath : String

Returns the value of path

Returns

String

setPath (path)

Sets the value of path

Parameters

path :  String

pivotFields : Ext.exporter.file.ooxml.excel.PivotField[]

Represents the collection of fields that appear on the PivotTable.

Defaults to:

null

setPivotFields (pivotFields)

Sets the value of pivotFields

Parameters

pivotFields :  Ext.exporter.file.ooxml.excel.PivotField[]

pivotTableStyle : String

Specifies the name of the style to apply to the main table area of the PivotTable.

Defaults to:

null

getPivotTableStyle : String

Returns the value of pivotTableStyle

Returns

String

setPivotTableStyle (pivotTableStyle)

Sets the value of pivotTableStyle

Parameters

pivotTableStyle :  String

pivotTableStyleInfo : Ext.exporter.file.ooxml.excel.PivotTableStyleInfo

Represent information on style applied to the PivotTable.

Defaults to:

{}

setPivotTableStyleInfo (pivotTableStyleInfo)

Sets the value of pivotTableStyleInfo

Parameters

pivotTableStyleInfo :  Ext.exporter.file.ooxml.excel.PivotTableStyleInfo

preserveFormatting : Boolean

Specifies a boolean value that indicates whether the formatting applied by the user to the PivotTable cells is discarded on refresh.

A value of 1 or true indicates the formatting applied by the end user is discarded on refresh.

A value of 0 or false indicates the end-user formatting is retained on refresh.

Defaults to:

null

getPreserveFormatting : Boolean

Returns the value of preserveFormatting

Returns

Boolean

setPreserveFormatting (preserveFormatting)

Sets the value of preserveFormatting

Parameters

preserveFormatting :  Boolean

printDrill : Boolean

Specifies a boolean value that indicates whether drill indicators expand collapse buttons should be printed.

A value of 1 or true indicates that these buttons should be printed.

A value of 0 or false indicates that these buttons should not be printed.

Defaults to:

null

getPrintDrill : Boolean

Returns the value of printDrill

Returns

Boolean

setPrintDrill (printDrill)

Sets the value of printDrill

Parameters

printDrill :  Boolean

published : Boolean

Specifies a boolean value that indicates whether data fields in the PivotTable are published and available for viewing in a server rendering environment.

A value of 1 or true indicates that the data fields in the PivotTable are published and shall be available for viewing in a server rendering environment.

A value of 0 or false indicates that the data fields in the PivotTable are not published and shall not be available for viewing in a server rendering environment.

Defaults to:

null

getPublished : Boolean

Returns the value of published

Returns

Boolean

setPublished (published)

Sets the value of published

Parameters

published :  Boolean

rowFields : Ext.exporter.file.ooxml.excel.Field[]

Represents the collection of row fields for the PivotTable.

Defaults to:

null

setRowFields (rowFields)

Sets the value of rowFields

Parameters

rowFields :  Ext.exporter.file.ooxml.excel.Field[]

rowGrandTotals : Boolean

Specifies a boolean value that indicates whether grand totals should be displayed for the PivotTable rows. The default value for this attribute is true.

A value of 1 or true indicates grand totals are displayed for the PivotTable rows.

A value of 0 or false indicates grand totals will not be displayed.

Defaults to:

null

getRowGrandTotals : Boolean

Returns the value of rowGrandTotals

Returns

Boolean

setRowGrandTotals (rowGrandTotals)

Sets the value of rowGrandTotals

Parameters

rowGrandTotals :  Boolean

rowHeaderCaption : String

Specifies the string to be displayed in row header in compact mode.

Defaults to:

null

getRowHeaderCaption : String

Returns the value of rowHeaderCaption

Returns

String

setRowHeaderCaption (rowHeaderCaption)

Sets the value of rowHeaderCaption

Parameters

rowHeaderCaption :  String

rowItems : Ext.exporter.file.ooxml.excel.Item[]

Represents the collection of items in row axis of the PivotTable.

Defaults to:

null

setRowItems (rowItems)

Sets the value of rowItems

Parameters

rowItems :  Ext.exporter.file.ooxml.excel.Item[]

showCalcMbrs : Boolean

Specifies a boolean value that indicates whether calculated members should be shown in the PivotTable view. This attribute applies to PivotTables from OLAP-sources only.

A value of 1 or true indicates that calculated members should be shown.

A value of 0 or false indicates calculated members should not be shown.

Defaults to:

null

getShowCalcMbrs : Boolean

Returns the value of showCalcMbrs

Returns

Boolean

setShowCalcMbrs (showCalcMbrs)

Sets the value of showCalcMbrs

Parameters

showCalcMbrs :  Boolean

showDataDropDown : Boolean

Specifies a boolean value that indicates whether the drop-down lists for the fields in the PivotTable should be hidden. This attribute depends on whether the application implements drop down lists or similar mechanism in the user interface.

A value of 1 or true indicates drop down lists are displayed for fields.

A value of 0 or false indicates drop down lists will not be displayed.

Defaults to:

null

getShowDataDropDown : Boolean

Returns the value of showDataDropDown

Returns

Boolean

setShowDataDropDown (showDataDropDown)

Sets the value of showDataDropDown

Parameters

showDataDropDown :  Boolean

showDataTips : Boolean

Specifies a boolean value that indicates whether tooltips should be displayed for PivotTable data cells.

A value of 1 or true indicates tooltips are displayed.

A value of 0 or false indicates tooltips will not be displayed. This attribute depends on whether the application employs tooltips or similar mechanism in the user interface.

Defaults to:

null

getShowDataTips : Boolean

Returns the value of showDataTips

Returns

Boolean

setShowDataTips (showDataTips)

Sets the value of showDataTips

Parameters

showDataTips :  Boolean

showDrill : Boolean

Specifies a boolean value that indicates whether drill indicators should be hidden.

A value of 1 or true indicates drill indicators are displayed.

A value of 0 or false indicates drill indicators will not be displayed.

Defaults to:

null

getShowDrill : Boolean

Returns the value of showDrill

Returns

Boolean

setShowDrill (showDrill)

Sets the value of showDrill

Parameters

showDrill :  Boolean

showDropZones : Boolean

Specifies a boolean value that indicates whether the PivotTable should display large drop zones when there are no fields in the data region.

A value of 1 or true indicates a large drop zone is displayed.

A value of 0 or false indicates a large drop zone will not be displayed.

Defaults to:

null

getShowDropZones : Boolean

Returns the value of showDropZones

Returns

Boolean

setShowDropZones (showDropZones)

Sets the value of showDropZones

Parameters

showDropZones :  Boolean

showEmptyCol : Boolean

Specifies a boolean value that indicates whether to include empty columns in the table.

A value of 1 or true indicates empty columns are included in the PivotTable.

A value of 0 or false indicates empty columns are excluded.

Defaults to:

null

getShowEmptyCol : Boolean

Returns the value of showEmptyCol

Returns

Boolean

setShowEmptyCol (showEmptyCol)

Sets the value of showEmptyCol

Parameters

showEmptyCol :  Boolean

showEmptyRow : Boolean

Specifies a boolean value that indicates whether to include empty rows in the table.

A value of 1 or true indicates empty rows are included in the PivotTable.

A value of 0 or false indicates empty rows are excluded.

Defaults to:

null

getShowEmptyRow : Boolean

Returns the value of showEmptyRow

Returns

Boolean

setShowEmptyRow (showEmptyRow)

Sets the value of showEmptyRow

Parameters

showEmptyRow :  Boolean

showError : Boolean

Specifies a boolean value that indicates whether to show error messages in cells.

A value of 1 or true indicates error messages are shown in cells.

A value of 0 or false indicates error messages are shown through another mechanism the application provides in the user interface.

Defaults to:

null

getShowError : Boolean

Returns the value of showError

Returns

Boolean

setShowError (showError)

Sets the value of showError

Parameters

showError :  Boolean

showHeaders : Boolean

Specifies a boolean value that indicates whether to suppress display of pivot field headers.

A value of 1 or true indicates field headers are shown in the PivotTable.

A value of 0 or false indicates field headers are excluded.

Defaults to:

null

getShowHeaders : Boolean

Returns the value of showHeaders

Returns

Boolean

setShowHeaders (showHeaders)

Sets the value of showHeaders

Parameters

showHeaders :  Boolean

showItems : Boolean

Specifies a boolean value that indicates whether to display item names when adding a field onto a PivotTable that has no data fields.

A value of 1 or true indicates item names are displayed.

A value of 0 or false indicates item names will not be displayed.

Defaults to:

null

getShowItems : Boolean

Returns the value of showItems

Returns

Boolean

setShowItems (showItems)

Sets the value of showItems

Parameters

showItems :  Boolean

showMemberPropertyTips : Boolean

Specifies a boolean value that indicates whether member property information should be omitted from PivotTable tooltips.

A value of 1 or true indicates member property information is included.

A value of 0 or false indicates member property information is excluded. This attribute depends on whether the application employs tooltips or similar mechanism in the user interface.

Defaults to:

null

getShowMemberPropertyTips : Boolean

Returns the value of showMemberPropertyTips

Returns

Boolean

setShowMemberPropertyTips (showMemberPropertyTips)

Sets the value of showMemberPropertyTips

Parameters

showMemberPropertyTips :  Boolean

showMissing : Boolean

Specifies a boolean value that indicates whether to show a message in cells with no value.

A value of 1 or true indicates to show a message string in cells without values.

A value of 0 or false indicates no message string will shown in cells without values.

Defaults to:

null

getShowMissing : Boolean

Returns the value of showMissing

Returns

Boolean

setShowMissing (showMissing)

Sets the value of showMissing

Parameters

showMissing :  Boolean

showMultipleLabel : Boolean

Specifies a boolean value that indicates whether a page field with multiple selected items should display "(multiple items)" instead of "All". This attribute applies only to non-OLAP PivotTables. The messages displayed depend on the application implementation.

A value of 1 or true indicates a different message string is displayed for a page field with multiple items.

A value of 0 or false indicates the same message string is displayed for all page fields.

Defaults to:

null

getShowMultipleLabel : Boolean

Returns the value of showMultipleLabel

Returns

Boolean

setShowMultipleLabel (showMultipleLabel)

Sets the value of showMultipleLabel

Parameters

showMultipleLabel :  Boolean

subtotalHiddenItems : Boolean

Specifies a boolean value that indicates whether data for hidden pivotItems for PivotFields in the data area should be included in subtotals.

A value of 1 or true indicates that data for hidden pivot items in the data area is included in subtotals.

A value of 0 or false indicates hidden pivot items will not be included in subtotals.

Defaults to:

null

getSubtotalHiddenItems : Boolean

Returns the value of subtotalHiddenItems

Returns

Boolean

setSubtotalHiddenItems (subtotalHiddenItems)

Sets the value of subtotalHiddenItems

Parameters

subtotalHiddenItems :  Boolean

tag : String

Specifies a user-defined string that is associated with this PivotTable.

Defaults to:

null

getTag : String

Returns the value of tag

Returns

String

setTag (tag)

Sets the value of tag

Parameters

tag :  String

updatedVersion : Number

Specifies the version of the application that last updated the PivotTable view. This attribute is application-dependent.

Defaults to:

null

getUpdatedVersion : Number

Returns the value of updatedVersion

Returns

Number

setUpdatedVersion (updatedVersion)

Sets the value of updatedVersion

Parameters

updatedVersion :  Number

useAutoFormatting : Boolean

Specifies a boolean value that indicates whether legacy auto formatting has been applied to the PivotTable view.

A value of 1 or true indicates that legacy auto formatting has been applied to the PivotTable.

A value of 0 or false indicates that legacy auto formatting has not been applied to the PivotTable.

Defaults to:

true

getUseAutoFormatting : Boolean

Returns the value of useAutoFormatting

Returns

Boolean

setUseAutoFormatting (useAutoFormatting)

Sets the value of useAutoFormatting

Parameters

useAutoFormatting :  Boolean

vacatedStyle : String

Specifies the name of the style to apply to the cells left blank when a PivotTable shrinks during a refresh operation

Defaults to:

null

getVacatedStyle : String

Returns the value of vacatedStyle

Returns

String

setVacatedStyle (vacatedStyle)

Sets the value of vacatedStyle

Parameters

vacatedStyle :  String

viewLayoutType : String

Possible values:

  • compact
  • outline
  • tabular

Use this config to set the pivot table layout

Defaults to:

'outline'

getViewLayoutType : String

Returns the value of viewLayoutType

Returns

String

setViewLayoutType (viewLayoutType)

Sets the value of viewLayoutType

Parameters

viewLayoutType :  String

visualTotals : Boolean

Specifies a boolean value that indicates whether totals should be based on visible data only. This attribute applies to OLAP PivotTables only.

A value of 1 or true indicates subtotals are computed on visible data only.

A value of 0 or false indicates subtotals are computed on all data.

Defaults to:

null

getVisualTotals : Boolean

Returns the value of visualTotals

Returns

Boolean

setVisualTotals (visualTotals)

Sets the value of visualTotals

Parameters

visualTotals :  Boolean

worksheet : Ext.exporter.file.ooxml.excel.Worksheet

Reference to the parent worksheet.

Defaults to:

null

setWorksheet (worksheet)

Sets the value of worksheet

Parameters

worksheet :  Ext.exporter.file.ooxml.excel.Worksheet

properties

Instance Properties

collectFiles

Collect all files that are part of the final zip file

Parameters

files :  Object

Object key is the path to the file and object value is the content

types :  Ext.exporter.file.ooxml.ContentType[]

methods

Instance Methods

checkCollection ( data, dataCollection, className ) : Ext.util.Collection

This method could be used in config appliers that need to initialize a Collection that has items of type className.

Parameters

data :  Object

dataCollection :  Object

className :  Object

Returns

:Ext.util.Collection

collectContentTypes ( types )

Collect all content types that are part of the final zip file

Parameters

types :  Ext.exporter.file.ooxml.ContentType[]

collectFiles ( files )

Collect all files that are part of the final zip file

Parameters

files :  Object

Object key is the path to the file and object value is the content

getRenderData Object

Return the data used when rendering the template

Returns

:Object

render String

Renders the content according to the template provided to the class

Returns

:String
Static Methods

override ( members ) : Ext.Base
static sta

Override members of this class. Overridden methods can be invoked via Ext.Base#callParent.

Ext.define('My.Cat', {
    constructor: function() {
        alert("I'm a cat!");
    }
});

My.Cat.override({
    constructor: function() {
        alert("I'm going to be a cat!");

        this.callParent(arguments);

        alert("Meeeeoooowwww");
    }
});

var kitty = new My.Cat(); // alerts "I'm going to be a cat!"
                          // alerts "I'm a cat!"
                          // alerts "Meeeeoooowwww"

Direct use of this method should be rare. Use Ext.define instead:

Ext.define('My.CatOverride', {
    override: 'My.Cat',
    constructor: function() {
        alert("I'm going to be a cat!");

        this.callParent(arguments);

        alert("Meeeeoooowwww");
    }
});

The above accomplishes the same result but can be managed by the Ext.Loader which can properly order the override and its target class and the build process can determine whether the override is needed based on the required state of the target class (My.Cat).

Parameters

members :  Object

The properties to add to this class. This should be specified as an object literal containing one or more properties.

Returns

:Ext.Base

this class

ExtReact 6.6.0