Changing filter doesn't automatically recalculate subtotal function
Submitted by Peter Olszowka
Please describe the problem: This is primarily an Excel compatibility issue which may not necessarily be of goal of gnumeric. I will describe "expected" behavior as excel behavior.
Steps to reproduce:
- put numbers in cells A1 - B3.
- in cell B4 put formula =subtotal(9,B2:B3)
- select cells A1:B3
- create auto filter
- change filter to hide row 3
Actual results: Result in B4 doesn't change until F9 pressed.
Expected results: Result in B4 should change immediately upon filter change.
Does this happen every time? Yes.