Text with spaces are not sorted properly on the frontend side
The backend and the web-frontend both have their own implementation of how things should be sorted. The frontend implementation is needed for real-time collaboration, but also to give real-time suggestions a row has changed position. They both need to work exactly the same.
The bug
If you have a table with a text field, have two rows where each cell value of each row has:
Timothy Cervantes
Tim Roberts
It results in a "row has moved" warning, even though the row is already in the correct position. After clicking outside the row, it will be moved to the position of which the frontend thinks it's correct, but after refreshing the page, it will be reset.
Expected
It's expected that the web-frontend sort matches the one on the backend. That means, it should not show the "row has moved" warning when editing the cell value.
Information
- More information about how to setup your development environment can be found here https://baserow.io/docs/development%2Fdevelopment-environment
- More information about how view filters work can be found here https://baserow.io/docs/plugins%2Fview-filter-type