I am trying to set the filer option for columns A to G and also column Q but cannot seem to get any syntax to work.
The below works for setting the filter option for columns A to G but when I try to also include Q I get an error or only column Q is filtered
.Filter(filter =>
{
filter.Ref("A1:G7000").Columns(columns => { });
})
Error
.Filter(filter =>
{
filter.Ref("A1:G7000;Q1:Q7000").Columns(columns => { });
})
Error
.Filter(filter =>
{
filter.Ref("A1:G7000,Q1:Q7000").Columns(columns => { });
})
Only Column Q is filterable
.Filter(filter =>
{
filter.Ref("A1:G7000).Columns(columns => { });
filter.Ref("Q1:Q7000").Columns(columns => { });
})
Any help on the syntax would be appreciated
Jeff