workbooktable

This configuration is optional when using the plugin Workbook.

  • 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>
</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"

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>
</workbookTableConfiguration>