Page History

Set the default sorting

1. Switch the page to the edit mode.
2. Select the macro and click Edit.
3. Switch to the Options tab.
4. Locate the Default Sorting  boxbox.
5. Click it and select the column with the appropriate sorting order.
6. Save the macro and the page.

Image Modified

Set the cell value delimiter

1. Switch the page to the edit mode.
2. Select the macro and click Edit.
3. Switch to the Options tab.

4. Locate the Cell value delimiter box.

5. Enter the character (multiple characters) used to separate values in cells.

6. Save the macro and the page.

Set the literal value delimiter

1. Switch the page to the edit mode.
2. Select the macro and click Edit.
3. Switch to the Options tab.

4. Locate the Literal value delimiter box.

5. Select the required literal value delimiter.

6. Save the macro and the page.

Image Added

Set the decimal separator

1. Switch the page to the edit mode.
2. Select the macro and click Edit.
3. Switch to the Options tab.
4. Locate the Decimal separator box box.
5. Select the correct decimal separator from the list, as follows:
   • Point
   • Comma
6. Save the macro and the page.

Image Modified

Set the thousands separator

1. Switch the page to the edit mode.
2. Select the macro and click Edit.
3. Switch to the Options tab.
4. Locate the Thousands separator box.
5. Select the correct decimal separator from the list, as follows:
   • Space
   • Point
   • Comma
6. Save the macro and the page.

Image Modified

Set the number of decimal places

1. Switch the page to the edit mode.
2. Select the macro and click Edit.
3. Switch to the Options tab.
4. Locate the Decimal places box.
5. Enter the number of decimal places to display.

6. Save the macro and the page.

Image Modified

Set the worklog settings

The Pivot Table macro supports summarization of worklogs and time intervals.

1. Switch the page to edit mode.
2. Select the macro and click Edit.
3. Switch to the Options tab.
4. Click the Set worklog settings button.
5. In the opened form, define the worklog parameters, as follows:
   1. Days in week - enter the number of business days in a week.
   2. Hours in day - enter the number of working hours in one business day.
   3. Time format - select the used time format in worklog values.
   4. Week shortening - enter the shortening for the week time unit if you use any language different from English.
   5. Day shortening - enter the shortening for the day time unit if you use any language different from English.
   6. Hour shortening - enter the shortening for the hour time unit if you use any language different from English.
   7. Minute shortening - enter the shortening for the minute time unit if you use any language different from English.
6. Click Save.
7. Save the macro and the page.

Shorten pivot table header

This option removes the operation type name from the pivot table header.

1. Switch the page to the edit mode.
2. Select the macro and click Edit.
3. Switch to the Options tab.
4. Locate and enable the Cumulative countShorten pivot table header option.
5. Save the macro and the page.

Image Removed

Show data values

1. Switch the page to the edit mode.
2. Select the macro and click Edit.
3. Switch to the Options tab.
4. Locate the Show data values option and select the appropriate option, as follows:
   • Number
   • Percentage
   • Number (Percentage)
   • Percentage (Number)
5. Save the macro and the page.

Image Removed

Before the 13.0.1 version of the app, this option was called Shorten title.

Show single-cell result as text

Hide totals

1. Switch the page to the edit mode.
2. Select the macro and click Edit.
3. Switch to the Options  tabtab.
4. Locate and enable the Hide totals option.
5. Save the macro and the page.

Image Removed

Show/Hide the source table

1. Switch the page to the edit mode.
2. Select the macro and click Edit.
3. Switch to the Options tab.
4. Locate the Source data option and select the appropriate option, as follows:
   
   • Show all content
   • Hide tables
   • Hide all content
5. Save the macro and the page.

1. Show single-cell result as text option.

Before the 13.0.1 version of the app, this option was called Show result as plain text.

Hide control panel

1. Switch the page to the edit mode.
2. Select the macro and click Edit .
3. Switch to the Options  tab.
4. Locate and enable the Hide control panel  option.

5. Save the macro and the page.

Customize no table found message

This option allows editing the default no table found message.

Set the literal value delimiter

When selecting the Literal operation type the Literal value delimiter option becomes available:

1. Switch the page to the edit mode.
2. Select the macro and click Edit.
3. Switch to the Options tab.
4. Locate the Literal value delimiter  option and select the appropriate option, as follows:

• • None (default)
  • Comma
  • Semicolon
  • Space
  • Line break
  • Bullet list
  • Numbered list
  • Any custom character

1. and enable the Customize no table found message option.
2. Enter your custom message that you want to be displayed instead of the standard one.
3. Save the macro and the page.

Image Removed

Collapse rows and columns

This option keeps the rows and columns of the multilevel pivot table collapsed by default

Show result as plain text

.

1. Switch the page to the edit mode.
2. Select the macro and click Edit.
3. Switch to the Options tab.
4. Locate and enable the Show result as plain text Collapse rows and columns option.
5. Save the macro and the page option.