When i use and clear standard filter, after the second time rows disappear

[Coiske60]

I have a calc spreadsheet with all my banking operations.
I want to introduce a “category” to distinguish “Rent”, “Taxes”, “Food”, “energy”, “water” … in order to calculate my spendings for each category. (these category names are in another sheet and in the column “category” they are the only ones to be accepted) by “validity”)

I use the standard filter : for each “name” that “begins with” p.e. the name of a supermarket, I introduce “Food” in the “category” column , and for the name of the water company it will be “water” …

The problem is that after a few of these operations some rows disappear (even their number! My row numbers become 0,2,3,4,6…)

What goes wrong, and how can I get those rows back?

Thankyou

[Wanderer]

@Coiske60

how can I get those rows back?

Mark the whole sheet, then open the context menu of the row numbers. There should be an entry to make all rows visible again. As filtering just makes some rows invisible (unless you output to another destination), this reverts the effect of the filter.