Managing Filtration Parameters

Setting the Decimal Separator

You may need to set the correct decimal separator when using the number range filters or enabling sparkline charts if your table contains decimal numbers.

To set the decimal separator:

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

Setting the Date Format

You may need to set the correct date format when using the date range filters. Filtration of dates may work incorrectly if the incorrect date format is specified.

To set the date format:

1. Switch the page to edit mode.
2. Select the macro and click Edit.
3. Switch to the Filtration tab.
4. Locate the Date format box.
5. Select the correct date format from the list or manually specify the needed format.
6. Save the macro and the page.

You can also define the date format in the page view mode.

Setting default width for filter boxes

You may need to increase or decrease of filter boxes shown on the filtration pane.

To set width for filter boxes:

1. Switch the page to edit mode.
2. Select the macro and click Edit.
3. Switch to the Filtration tab.
4. Click Set width of filters.
5. Enter the appropriate width in pixels for available filters.
6. Save the macro and the page.

For the details on how set width of filter boxes in the page view mode, see this.

Disabling the Change Saving

You may need to disable the saving changes after filtration. This can be useful when you share some table with other people and set the default values for filtration, and do not want them to be overwritten.

To disable the change saving:

1. Switch the page to edit mode.
2. Select the macro and click Edit.
3. Switch to the Filtration tab.
4. Locate and select the Disable the change saving option.
5. Save the macro and the page.
   

Hiding Filter Labels

1. Switch the page to edit mode.
2. Select the macro and click Edit.
3. Switch to the Filtration tab.
4. Locate and select the Hide Filter Labels option.
5. Save the macro and the page.

Hiding the Filtration Pane

Table Filter and Charts add-on allows you to hide the filtration pane in the page view mode. This may be useful when you have applied the required filters and do not want to allow other users filter the table.

To hide the filtration pane:

1. Switch the page to edit mode.
2. Select the macro and click Edit.
3. Switch to the Filtration tab.
4. Locate and select the Hide filtration pane option.
5. Save the macro and the page.

To restore the filtration pane, reset selection for the Hide filtration pane option.

Hiding the control buttons

Table Filter and Charts add-on allows you to hide the control buttons shown when you click the Cogwheel button on the filtration pane. This may be useful when you want to disable export of table date or its sharing.

To hide the control button on the filtration pane:

1. Switch the page to edit mode.
2. Select the macro and click Edit.
3. Switch to the Filtration tab.
4. Locate and select the Hide control buttons option.
5. Save the macro and the page.

To restore the filtration pane, reset selection for the Hide control buttons option.

Changing order of filters

While editing the macro you can change order of filters of the same type. Order of filters of different types can be modified in the page view mode.

1. Switch the page to edit mode.
2. Select the macro and click Edit.
3. Locate the filter type in which you want to change order of filtered columns
4. Drag the column label to the appropriate place in the filter box.
5. Save the macro and the page.

Setting the Data Operator

1. Switch the page to edit mode.
2. Select the macro and click Edit.
3. Switch to the Filtration tab.
4. Locate the Multi-Filter Operator box.
5. Select the appropriate operator - AND or OR.
6. Save the macro and the page.

Setting the Cell Value Delimiter

The cell value delimiter is used for treating multiple delimited values in table cells as separate values in the dropdown filter.

1. Switch the page to edit mode.
2. Select the macro and click Edit.
3. Switch to the Filtration 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.

Setting worklog settings

1. Switch the page to edit mode.
2. Select the macro and click Edit.
3. Switch to the Filtration 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.