workbooktable

This configuration is optional.

  • Documentation

  • YAML Format

  • XML Format

Fill relevant inputs (blue boxes) and click the blue bars on the left to copy XML configuration snippets.
<workbookTableConfiguration
>
required

Configuration for workbook table view and workbook table excel export.

<tableStyles
<tableStyle
id
required
=
string

Unique string for identifying this style.

<printName
>
optional
string

The name that will be displayed to the user for selecting a style.

</printName>
<grandTotal
<backgroundColor
>
optional
string

Hexadecimal background color specification (#RRGGBB, e.g. #184e7b).

</backgroundColor>
>
optional

The style settings to apply to row totals, column totals and the grand total.

</grandTotal>
<columnSubtotal
<backgroundColor
>
optional
string

Hexadecimal background color specification (#RRGGBB, e.g. #184e7b).

</backgroundColor>
>
optional

The style settings to apply to column subtotals.

</columnSubtotal>
<rowSubtotal
<backgroundColor
>
optional
string

Hexadecimal background color specification (#RRGGBB, e.g. #184e7b).

</backgroundColor>
>
optional

The style settings to apply to row subtotals.

</rowSubtotal>
<borders
xs:string
SPECIFIC
ALL
>
optional

Which borders to draw - possible values: * SPECIFIC (a fixed set of specific borders, e.g. always below column headers, always above column totals...) * ALL

Default: SPECIFIC

</borders>
>
requiredmax. unbounded

One combination of colors/border setting which can be used to style tables in workbook table views and excel export.

</tableStyle>
>
optional

List of possible table styles (colors, which borders to draw) like e.g. a blue style containing blue colors for backgrounds and a green style containing green colors...

</tableStyles>
<pivotTable
<maxCountDimensionsRows
>
optional
int

Maximum number of row dimensions. (If the table is configured to have at least one column dimension)

Default: 8

</maxCountDimensionsRows>
<maxCountDimensionsColumns
>
optional
int

Maximum number of column dimensions.

Default: 8

</maxCountDimensionsColumns>
<maxCountMeasures
>
optional
int

Maximum number of measures. (If the table is configured to have at least one column dimension)

Default: 10

</maxCountMeasures>
<columnsNumberTableNotDisplayedThreshold
>
optional
int

If the number of columns in the table exceeds this number, user won't be able to show the table. (If the table is configured to have at least one column dimension)

Default: 100

</columnsNumberTableNotDisplayedThreshold>
>
optional

Limits for pivot tables (tables that have > 0 column dimensions). Authorised users can restrict these limits further in the advanced data view settings for a data view.

</pivotTable>
</workbookTableConfiguration>
This is a generated sample file with fake data and all the possible options shown, refer to the Documentation tab for what combinations are valid and what is required or not. 
cadenzaconfig:
  settings:
    workbooktable:
      tableStyles:
      - id: "text"
        printName: "text"
        grandTotal:
          backgroundColor: "text"
        columnSubtotal:
          backgroundColor: "text"
        rowSubtotal:
          backgroundColor: "text"
        borders: "SPECIFIC"
      - id: "text"
        printName: "text"
        grandTotal:
          backgroundColor: "text"
        columnSubtotal:
          backgroundColor: "text"
        rowSubtotal:
          backgroundColor: "text"
        borders: "SPECIFIC"
      pivotTable:
        maxCountDimensionsRows: 15
        maxCountDimensionsColumns: 15
        maxCountMeasures: 15
        columnsNumberTableNotDisplayedThreshold: 15

Filename: workbooktable-config.xml

This is a generated sample file with fake data and all the possible options shown, refer to the Documentation tab for what combinations are valid and what is required or not. 
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<workbookTableConfiguration>
  <tableStyles>
    <tableStyle id="text">
      <printName>text</printName>
      <grandTotal>
        <backgroundColor>text</backgroundColor>
      </grandTotal>
      <columnSubtotal>
        <backgroundColor>text</backgroundColor>
      </columnSubtotal>
      <rowSubtotal>
        <backgroundColor>text</backgroundColor>
      </rowSubtotal>
      <borders>SPECIFIC</borders>
    </tableStyle>
    <tableStyle id="text">
      <printName>text</printName>
      <grandTotal>
        <backgroundColor>text</backgroundColor>
      </grandTotal>
      <columnSubtotal>
        <backgroundColor>text</backgroundColor>
      </columnSubtotal>
      <rowSubtotal>
        <backgroundColor>text</backgroundColor>
      </rowSubtotal>
      <borders>SPECIFIC</borders>
    </tableStyle>
  </tableStyles>
  <pivotTable>
    <maxCountDimensionsRows>15</maxCountDimensionsRows>
    <maxCountDimensionsColumns>15</maxCountDimensionsColumns>
    <maxCountMeasures>15</maxCountMeasures>
    <columnsNumberTableNotDisplayedThreshold>15</columnsNumberTableNotDisplayedThreshold>
  </pivotTable>
</workbookTableConfiguration>