[Bug] Changing any field in a sorted Grid removes the modified row from proper sort order

[rockerest]

Bug Description

Basically as the title says: If a Grid is sorted, changing any field in a row - even if that field is not part of the sort - removes the row from proper sort order and places it at the bottom of the Grid.

How to Reproduce

1. Create a Grid
2. Add some data (at least 2 rows will be necessary to see this in effect)
3. Add a sort to the Grid
4. Modify the first row, changing a field that is not part of the applied sort
5. Note the field is placed at the bottom of the Grid

Expected Behavior

1. Changing a field should always properly apply the correct sorts and filters
2. Changing a field that is not part of any sort or filter in the current view should have no effect

Operating System

Windows

AppFlowy Version(s)

0.8.8

Screenshots

Screen.Recording.2025-04-16.202106.mp4

Additional Context

No response

[bogdanpc28]

I was just going to create the same bug. it's really annoying and it's a basic functionality for a grid that can ruin other features of it if it's not fixed in time.