Skip to main content
Skip table of contents

Table Enhancer Configuration

Parameters

Table number

Select an existing table that will be added to the macro.

Row numbers

Adds a consecutive number (starting at 1) to every row.

Options:

  • None: There will be no numbering.

  • Once Before Sorting: Add row numbers before initial sorting.

  • Independent From Sorting: Add row numbers completely independent from every sorting.

  • Once After Sorting: Add row numbers after initial sorting.

Background color for row numbers

Choose the background color for the row number cells.

Options:

  • Grey: Grey color.

  • Red: Red color.

  • Green: Green color.

  • Blue: Blue color.

  • Yellow: Yellow color.

  • Transparent: There will be no color.

  • As right next cell: Copy the color from the right next cell compared to the inserted row number cell.

Background color shade for row numbers

Choose the background color shade for the row number cells. The default one is Normal

  • Light: Light shade of the color

  • Normal: Normal shade of the color.

  • Dark: Dark shade of the color.

Sort order

Choose a sort order by selecting columns (1, 2, ...) together with their respective sort order (ASC for ascending, DESC for descending). Column numbers start with 1.

For example: 2DESC, 3ASC first sorts by column 2 descending and then 3 ascending if some cells have the same value.

Sorting without accents

When enabled, the text will be internally converted so that accented characters are switched to their non-accented equivalent before sorting. That is:

  • á, à, â, ã, ä will be replaced with a

  • ç will be replaced with c

  • é,è, ê, ë will be replaced with e

  • í, ì,İ, î, ï will be replaced with i

  • ó, ò,ô, õ, ö, ō will be replaced with o

  • ú, ù, û, ü will be replaced with u

  • ß will be replaced with S

Total line

When enabled, shows a total line at the end of the table. It contains sums for all columns containing numeric values.

Decimal mark

Choose either . (point) or , (comma) as decimal separator for parsing and summing numeric values for the total line.

Number of rows to keep visible

Choose the number of rows at the top of the table to be fixed while scrolling.

Number of columns to keep visible

Choose the number of columns on the left of the table to be fixed while scrolling (incl. a possible row numbering column).

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.