On LO 5.3.3 (1:5.3.3~rc2-0ubuntu0.16.04.1~lo0, Dutch UI) when I apply a filter on a column in Calc, the filter seems to work only from row 1 until it hits an empty row. All rows below the empty row are left untouched by the filter. When removing the empty row, the filter works until it hits the next empty row and so on.
Is this intended behavior or a bug?
P.S. - the behavior seems to change when inserting a new empty row a few rows above the first empty row. The filter then seems to ignore that newly inserted empty row and continue filtering.
Also, when typing a value into one of the empty row’s cells, the filter no longer sees the empty row as a barrier and continues to filter beyond that row. Oddly, removing the value from the cell (hence restoring the fully empty row), does NOT re-trigger the filter block; the filter keeps on working beyond the empty row.