Hello, my name is Ernesto Montemayor. My first language is not english, so I hope I can explain clearly enough here.
The problem presents when the Data filters are active, and only a group of the whole data in the spreadsheet is shown. If I add new data on a cell, and I click on it and move it down to fill the rest of the cells in the column with the same value, Calc fills ALL the column incluiding the cells not shown.
It would be more useful if only the visualized cells were filled, otherwise the usefulness of data filters are downgraded.
Thanks to everyone for this great office suite.