Apache OpenOffice (AOO) Bugzilla – Issue 120514
Instant filter will extend its database range while added a subtotal line.
Last modified: 2012-08-09 09:05:01 UTC
Created attachment 78894 [details] sample file can repro this bug Build: Aoo3.4.1_r1369843 Steps: 1.Open the sample file in AOO. 2. Enable filter to the data. 3. Input =subtotal(9; B2:B10) in cell B11. 4. Select a item in drop-down list of cell A1. Defects: You can find that the subtotal result will be hidden, as it is in database range of Instant filter.