ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: 徐雪峰 on August 08, 2020, 07:32:28 pm

Title: can excel formular sum only filter data
Post by: 徐雪峰 on August 08, 2020, 07:32:28 pm

i want write a excel formular to sum a column's data,but the summary don't include the hidden cells of the column.
is there any way to do it?

Title: Re: can excel formular sum only filter data
Post by: paramvir on August 10, 2020, 10:37:40 am

Please try

Code: [Select]

filterModel: { hideRows: true },