Hide a filtered column from the spreadsheet
    • Dark
      Light
    • PDF

    Hide a filtered column from the spreadsheet

    • Dark
      Light
    • PDF

    Article Summary

    When you use a Tree or Cell parameter filter, you can hide the database columns that are used in the filter from the Excel table:
    image.png

    When you hide those columns, the inserted values will always be taken from a selected Tree Filter item or a cell value.

    In the example below we use a Tree filter, but the process is the same for filtering on a cell value.

    1. Add a row filter in the SQL Spreads Designer

    After you have created your Tree filter you will have to add a Custom SQL Filter in the Designer to apply the Tree filter selection to the data loaded from SQL Server:
    image.png

    To quickly insert a Tree Filter parameter or a Cell parameter, click the Insert button above the filter text area:
    image.png

    2. Specify which Tree Filter that holds the columns value

    Before hiding the column, you must specify which Tree filter that holds the selected value for that column. To do that, go to the Columns tab in the SQL Spreads Designer and click the small cog on the right side of the column's row:
    image.png

    Click the Insert button above the Parameter to use as value for this column field...
    image.png

    ... and select the Tree Filter value to use for this column:
    image.png

    3. Hide the column

    You can now hide the column by unchecking the Show checkbox in the SQL Spreads Designer:
    image.png

    Using the same technique, you can hide all the filtered columns:

    image.png


    Was this article helpful?