Skip to end of banner
Go to start of banner

_Copy_CommonTableCapabilitiesParametersXLCld

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

The parameters listed on this page are part of our common table capabilities that are available to many macros that produce or modify tables.

Macro Editor LabelDefaultDescriptionMacro Parameter
Number of heading rows


Enable column sorting










































Column types



Column types determine how column data is sorted and displayed. By default, column data is treated as a text string sorted alphabetically. When the default behavior is less than optimal for your situation, the Column types parameter can be set specifically. This page describes the behavior of the various types. In addition, numeric types are right aligned and can result in a total row entry. 

The following column types are not supported in the current release:

  • Numeric with data formatting (FF)
  • Float with comma as decimal point (FC)
  • Currency with comma as decimal points (CC)

These column types are expected to be featured in the upcoming release.

columnTypesColumn calculations
Column calculations

When an auto total parameter is selected, this parameter can be used to customize the calculation or text that is shown on the total row. By default, all numeric fields, as specified by column types, are totaled. By specifying a comma separated list of calculation requests, the behavior can be modified using special values for the corresponding column.

The Max and Min Total type is available only for Advanced Tables for Confluence: Server and Data Center.

columnCalculations
































Table border width
Enter width for the table border in pixels. It is recommended to use Table style instead.border
  • No labels