Search results

HyperlinkSettings API in JavaScript (ES5) Pivot Table API control

Allow a set of options to display a hyperlink to link data for individual cells that are shown in the pivot table. These options allow you to enable a separate hyperlink for row headers, column headers, value cells, and summary cells in the hyperlinkSettings class. The options available are:

  • showHyperlink: Allows you to set the visibility of hyperlink in all cells.
  • showRowHeaderHyperlink: Allows you to set the visibility of hyperlink in row headers.
  • showColumnHeaderHyperlink: Allows you to set the visibility of hyperlink in column headers.
  • showValueCellHyperlink: Allows you to set the visibility of hyperlink in value cells.
  • showSummaryCellHyperlink: Allows you to set the visibility of hyperlink in summary cells.
  • headerText: Allows you to set the visibility of hyperlink based on header text.
  • conditionalSettings: Allows you to set the visibility of hyperlink based on specific condition.
  • cssClass: Allows you to add CSS class name to the hyperlink options.

    By default, the hyperlink options are disabled for all cells in the pivot table.

Properties

conditionalSettings

ConditionalSettingsModel[]

Allow options for setting the visibility of hyperlink based on specific condition. The options available here are as follows:

  • measure: Allows you to specify the value field caption to get visibility of hyperlink option for specific measure.
  • condition: Allows you to choose the operator type such as equals, greater than, less than, etc.
  • value1: Allows you to set the start value.
  • value2: Allows you to set the end value. This option will be used by default when the operator Between and NotBetween is chosen to apply.

Defaults to []

cssClass

string

Allows you to add the CSS class name to the hyperlink options. Use this class name you can apply styles to a hyperlink easily at your end.

Defaults to

headerText

string

Allows you to set the visibility of hyperlink in the cells based on specific row or column header.

Allows you to set the visibility of hyperlink in column headers that are currently shown in the pivot table.

Defaults to false

Allows you to set the visibility of hyperlink in all cells that are currently shown in the pivot table.

Defaults to false

Allows you to set the visibility of hyperlink in row headers that are currently shown in the pivot table.

Defaults to false

Allows you to set the visibility of hyperlink in summary cells that are currently shown in the pivot table.

Defaults to false

Allows you to set the visibility of hyperlink in value cells that are currently shown in the pivot table.

Defaults to false