Operations on regions with hidden content
Submitted by Luis Mendes
Link to original bug (#143220)
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