Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Info

Please check out our YouTube video or our Live Demodemo to get an idea about how Data Tables for Confluence works.

...

The macro supports the following options:

  • Enable paging: Check to enable Enable the paging functionality.

  • Page sizes: Comma separated page sizes (number or “all”) to override default sizes if paging is enabled where the first entry is used as default page size; “all,50,100” for example shows options “50 / 100 / all” and “all” is selected by default

  • Enable searching: Check to enable the Enable the (global) searching functionality.

  • Enable column filtering: Enable column filtering.

  • Exclude columns from search: Comma separated column to exclude from searching.

  • Enable column selector: Check to enable the Enable a button that allows to toggle visibility of individual columns.

  • Enable copy to clipboard: Check to enable Enable a button that copies the table data to the clipboard.

  • Enable Excel export: Check to enable Enable a button that exports the table data as .xlsx file.

  • Enable CSV export: Check to enable Enable a button that exports the table data as .csv file.

  • Enable PDF export: Check to enable Enable a button that exports the table data as .pdf file.

  • Enable printing: Check to enable Enable a “print” button.

  • Order columns: Comma separated column numbers to order by initially (use “!” to order descending); “2!;1” for example uses column 2 (descending) as primary order column and column 1 (ascending) as second order column.

  • Fixed order columns: Number of columns defined in option “Order columns” for which the order is unchangeable.

  • Footer row: Comma separated functions (“min” / “minimum”, “max” / “maximum”, “avg” / “average”, “sum”, “count”, “md” / “median” or empty) to be used in the footer row.

  • Data locale: Defines the locale that should be used to parse numbers.

  • Grouping columns: Comma separated column numbers to group; “2;3” for example groups by column 2 and then by column 3.

  • Detail column: Number of the column that contains the information that will be rendered as expandable/collapsible detail row.

  • Detail column format: Defines if the detail column should be rendered as expandable detail row (default option “DetailRow“) or as overlay (option “Overlay”).

  • Show information: Check to show Show dataset information such as number of records.

  • Disable state saving: Check to disable Disable automatic table state saving and restoring.

...

The macro supports the following options:

  • CSV header row: Check to use Use the first row as column header.

  • CSV quote: Define the character that is used as CSV quote, leave empty if no quote us used.

  • CSV delimiter: Define the character that is used as CSV delimiter.

  • Column format: Comma separated format (empty, “html”, “link” or “date” in format YYYY-MM-DD) to be used for rendering the column, whereas “html” supports the tags <a>, <em> and <strong> and “link” renders the data as hyperlink.

  • Enable paging: Check to enable Enable the paging functionality.

  • Page sizes: Comma separated page sizes (number or “all”) to override default sizes if paging is enabled where the first entry is used as default page size; “all,50,100” for example shows options “50 / 100 / all” and “all” is selected by default

  • Enable searching: Check to enable the Enable the (global) searching functionality.

  • Enable column filtering: Enable column filtering.

  • Exclude columns from search: Comma separated column to exclude from searching.

  • Enable column selector: Check to enable the Enable a button that allows to toggle visibility of individual columns.

  • Enable copy to clipboard: Check to enable Enable a button that copies the table data to the clipboard.

  • Enable Excel export: Check to enable Enable a button that exports the table data as .xlsx file.

  • Enable CSV export: Check to enable Enable a button that exports the table data as .csv file.

  • Enable PDF export: Check to enable Enable a button that exports the table data as .pdf file.

  • Enable printing: Check to enable Enable a “print” button.

  • Order columns: Comma separated column numbers to order by initially (use “!” to order descending); “2!;1” for example uses column 2 (descending) as primary order column and column 1 (ascending) as second order column.

  • Fixed order columns: Number of columns defined in option “Order columns” for which the order is unchangeable.

  • Footer row: Comma separated functions (“min” / “minimum”, “max” / “maximum”, “avg” / “average”, “sum”, “count”, “md” / “median” or empty) to be used in the footer row.

  • Data locale: Define the locale that should be used to parse numbers.

  • Grouping columns: Comma separated column numbers to group; “2;3” for example groups by column 2 and then by column 3.

  • Show information: Check to show Show dataset information such as number of records.

  • Disable state saving: Check to disable Disable automatic table state saving and restoring.

...

  • Attachment: Define the CSV file attached to the Confluence page to load the CSV data from.

  • CSV header row: Check to use Use the first row as column header.

  • CSV quote: Define the character that is used as CSV quote, leave empty if no quote us used.

  • CSV delimiter: Define the character that is used as CSV delimiter.

  • Column format: Comma separated format (empty, “html”, “link” or “date” in format YYYY-MM-DD) to be used for rendering the column, whereas “html” supports the tags <a>, <em> and <strong> and “link” renders the data as hyperlink.

  • Enable paging: Check to enable Enable the paging functionality.

  • Page sizes: Comma separated page sizes (number or “all”) to override default sizes if paging is enabled where the first entry is used as default page size; “all,50,100” for example shows options “50 / 100 / all” and “all” is selected by default

  • Enable searching: Check to enable the Enable the (global) searching functionality.

  • Enable column filtering: Enable column filtering.

  • Exclude columns from search: Comma separated column to exclude from searching.

  • Enable column selector: Check to enable the Enable a button that allows to toggle visibility of individual columns.

  • Enable copy to clipboard: Check to enable Enable a button that copies the table data to the clipboard.

  • Enable Excel export: Check to enable Enable a button that exports the table data as .xlsx file.

  • Enable CSV export: Check to enable Enable a button that exports the table data as .csv file.

  • Enable PDF export: Check to enable Enable a button that exports the table data as .pdf file.

  • Enable printing: Check to enable Enable a “print” button.

  • Order columns: Comma separated column numbers to order by initially (use “!” to order descending); “2!;1” for example uses column 2 (descending) as primary order column and column 1 (ascending) as second order column.

  • Fixed order columns: Number of columns defined in option “Order columns” for which the order is unchangeable.

  • Footer row: Comma separated functions (“min” / “minimum”, “max” / “maximum”, “avg” / “average”, “sum”, “count”, “md” / “median” or empty) to be used in the footer row.

  • Data locale: Define the locale that should be used to parse numbers.

  • Grouping columns: Comma separated column numbers to group; “2;3” for example groups by column 2 and then by column 3.

  • Show information: Check to show Show dataset information such as number of records.

  • Disable state saving: Check to disable Disable automatic table state saving and restoring.

...

  • URL: Define the URL to load the remote CSV data from.

  • CSV header row: Check to use Use the first row as column header.

  • CSV quote: Define the character that is used as CSV quote, leave empty if no quote us used.

  • CSV delimiter: Define the character that is used as CSV delimiter.

  • Column format: Comma separated format (empty, “html”, “link” or “date” in format YYYY-MM-DD) to be used for rendering the column, whereas “html” supports the tags <a>, <em> and <strong> and “link” renders the data as hyperlink.

  • Enable paging: Check to enable Enable the paging functionality.

  • Page sizes: Comma separated page sizes (number or “all”) to override default sizes if paging is enabled where the first entry is used as default page size; “all,50,100” for example shows options “50 / 100 / all” and “all” is selected by default

  • Enable searching: Check to enable the Enable the (global) searching functionality.

  • Enable column filtering: Enable column filtering.

  • Exclude columns from search: Comma separated column to exclude from searching.

  • Enable column selector: Check to enable the Enable a button that allows to toggle visibility of individual columns.

  • Enable copy to clipboard: Check to enable Enable a button that copies the table data to the clipboard.

  • Enable Excel export: Check to enable Enable a button that exports the table data as .xlsx file.

  • Enable CSV export: Check to enable Enable a button that exports the table data as .csv file.

  • Enable PDF export: Check to enable Enable a button that exports the table data as .pdf file.

  • Enable printing: Check to enable Enable a “print” button.

  • Order columns: Comma separated column numbers to order by initially (use “!” to order descending); “2!;1” for example uses column 2 (descending) as primary order column and column 1 (ascending) as second order column.

  • Fixed order columns: Number of columns defined in option “Order columns” for which the order is unchangeable.

  • Footer row: Comma separated functions (“min” / “minimum”, “max” / “maximum”, “avg” / “average”, “sum”, “count”, “md” / “median” or empty) to be used in the footer row.

  • Data locale: Define the locale that should be used to parse numbers.

  • Grouping columns: Comma separated column numbers to group; “2;3” for example groups by column 2 and then by column 3.

  • Show information: Check to show Show dataset information such as number of records.

  • Disable state saving: Check to disable Disable automatic table state saving and restoring.

...

The macro supports the following options:

  • Enable paging: Check to enable Enable the paging functionality.

  • Page sizes: Comma separated page sizes (number or “all”) to override default sizes if paging is enabled where the first entry is used as default page size; “all,50,100” for example shows options “50 / 100 / all” and “all” is selected by default

  • Enable searching: Check to enable the Enable the (global) searching functionality.

  • Enable column filtering: Enable column filtering.

  • Enable column selector: Check to enable Enable the a button that allows to toggle visibility of individual columns.

  • Enable copy to clipboard: Check to enable Enable a button that copies the table data to the clipboard.

  • Enable Excel export: Check to enable Enable a button that exports the table data as .xlsx file.

  • Enable CSV export: Check to enable Enable a button that exports the table data as .csv file.

  • Enable PDF export: Check to enable Enable a button that exports the table data as .pdf file.

  • Enable printing: Check to enable Enable a “print” button.

  • Show columns: Select the columns to be included in the table.

  • Group column: (Optional) column to group the data.

  • Order columns: Comma separated column numbers to order by initially (use “!” to order descending); “2!;1” for example uses column 2 (descending) as primary order column and column 1 (ascending) as second order column.

  • Fixed order columns: Number of columns defined in option “Order columns” for which the order is unchangeable.

  • Show information: Check to show Show dataset information such as number of records.

  • Disable state saving: Check to disable Disable automatic table state saving and restoring.

...