Changing filter doesn't automatically recalculate subtotal function

Submitted by Peter Olszowka

Description

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.

Other information:

Version: 1.6.x