Filter are not shown from Table Spreadsheet Include

[Nicolas Goutte]

Hello,

See below where a filter is applied to select only lines with "A" but the Table Spreadsheet Include is showing all lines.

Could help me with this issue?

Thank you,

** without any filter **

** with filter "A"  **

[Stiltsoft support]

Hi @Nicolas Goutte ,

It's an expected behavior, I'm afraid.

In the Table Spreadsheet Include macro you select to show the whole sheet or a specific cell range. So, when you filter smth in the source Table Spreadsheet, the cells are not deleted, they are just temporarily hidden.

So, the workaround will be to wrap your Table Spreadsheet Include macro in the Table Filter macro (all our macros are compatible) and filter it on the fly. So, your users won't be able to make any changes to the original spreadsheet as they work with the reused content but they will be able to filter the required data.