Formula not updating after column filter

Tags: #<Tag:0x00007efc6dec84a0>
#1

Hi,
Formula value is not updating after applying column filter. I understand this might be a bug/limitations with Hyperformula implementation. Is there a work around for this?

#2

Hi @ashishs

When you filter out the rows they are still in the dataset (hidden, but not removed) that is why the formula result does not change. If you would like to alter that behavior at the moment, you would need to change the formula via afterFilter() hook. You can use the hook response to filter out the indexes that are gone

27

But it would be easier to call the this.rowIndexMapper.notTrimmedIndexesCache method instead. Demo https://jsfiddle.net/gc0jp2k4/12/

#3

Thanks @aleksandra_budnik, it works. But I had to use getNotTrimmedIndexes method though.

Also, is it possible to disable filter on ‘Blank cells’ and some rows as I am using them as header cells and filtering them out will cause UI issues.

#4

The filtering UI and list of option logic do not have any dedicated methods so we do not have control over limiting the list, meaning (Blank cells) unremovable.

#5