Page tree

Versions Compared

Key

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

...

Info

The date format can be specified and alternated depending on dates contained in your table.

Use the following formats for specifying date:

  • yy - year
  • mm - month or m - month without the leading zero
  • dd - day or d - day without the leading zero

For the details on date formats, see What date formats are supported?

Expand
Info

Starting from version 3.1.0 the add-on supports filtration of cells containing both date and time. Filtration occurs only by date, time value is skipped.

How to filter number range

...

  1. Open the macro and locate the Number Filter Columns box.
  2. Click it and select the columns containing the numbers.
  3. Once you have saved the page, locate the box for a column with number and enter the appropriate number range.

Expand

How to manage filters in the view page mode

Starting from version 3.1.0 Table Filter add-on supports management of filters in the view page mode. In such a way, you can manage filters of all types, including the box for hiding specific columns of the table.

You can perform the following actions on filters:

  • add new filters and the box for hiding table columns
  • delete the no longer needed filters and box for hiding table columns
  • save the default values of filters
  • define width of filter boxes

You may encounter the four situations, as follows:

You have inserted the table into the Table filter macro, added filters and saved the page.

In this case, you will see the screen similar to the one displayed. You can add new filters by clicking the Add filter icon.

You have inserted the table into the Table filter macro and saved the page without any configuration.

In this case, you will see the screen similar to the one displayed. You can add the required filters by clicking the Add filter icon.

You have inserted the table into the Table filter macro and enabled automatic row number or/and default sorting.

In this case, no filtration pane will be displayed. You will have to switch the page to the edit mode and then configure settings of the Table Filter macro while editing it.

You have not inserted the table into the Table filter macro.

In this case, you will see the corresponding notification about the missing table in the macro body. You will have to swith the page to the edit mode and insert the table into the macro body. Then you can add the filters either when editing the page or viewing it.

Adding filters in the page view mode

  1. On the filtration pane, locate the Add filter icon and click it.
  2. Select the appropriate filter type and the column for data filtration.
  3. To save the modifications in the macro body, click the Save settings icon.

Info

If adding the number or date filters, additional configuration of the data format may be required.

Deleting filters in the page view mode

  1. On the filtration page, locate the filter you want to remove.
  2. Click and drag the filter to the bottom of the page.
  3. Release the left mouse button. The filter will be removed.
  4. To save the modifications in the macro body, click the Save settings icon.

Saving default values for filters in the page view mode

  1. Locate the filter you want to specify default values for.
  2. Select or enter the appropriate default values for one or multiple filters.
  3. To save the modifications in the macro body, click the Save settings icon.

Saving filter width in the page view mode

  1. Locate the filter box which width you want to change.
  2. Position the mouse pointer at the right border of the filter box, until the cursor changes.
  3. Click and hold the left mouse button and drag the filter box border to the left or or to the right.
  4. Release the left mouse button when width of the filter box is appropriate.
  5. To save the modifications in the macro body, click the Save settings icon.

Info

You can change the box width for the following filter types:

  • Dropdown filter
  • Free text filter
  • Global filter
  • Hide columns selector

Changing order of filters on the filtration pane

  1. Locate the filter box which position on the filtration pane you want to change.
  2. Click and drag the filter box to the appropriate position on the filtration pane.
  3. Release the left mouse button when complete.
  4. To save the modifications in the macro body, click the Save settings icon.

Info

You can only change order of filter boxes of the same type on the filtration pane. For example, you cannot position the global filter between the two dropdown filters.

...