Operations on regions with hidden content

Submitted by Luis Mendes

Description

Hi,

I'll try to give an example:

cols 1 2 3 rows 1 colors nr cars cost each 2 green 2 10.000 3 blue 4 15.000 4 yellow 1 25.000 5 green 10 30.000 6 black 7 7.000

then I select Auto Filter, so thar the first row is the title row. if I want to remove all the rows containing green cars, I would filter in the color column by green, which gives me:

cols 1 2 3 rows 1 colors nr cars cost each 2 green 2 10.000 5 green 10 30.000

then I select rows 2 through 5 and delete them.

I was expecting the result to be (as it is in Excel since version 97 as Dave told us):

cols 1 2 3 rows 1 colors nr cars cost each 2 blue 4 15.000 3 yellow 1 25.000 4 black 7 7.000

the green lines would have disappearesd and a row renumbering proccess would have taken place.

But in Gnumeric, instead, what I get is: cols 1 2 3 rows 1 colors nr cars cost each 2 black 7 7.000

All the rows between the firs and the last "green" ones were deleted. Which is: gnumeric removed not only the visible (green) but also what was not visible (rows containing blue and yellow cars).

Version: git master