An option to disable syncing of filters and sorting
When working on a shared spreadsheet document in Teams we need to use different sets of sorting and filters to be applied at the same time.
Currently filters and sorting applied by one persons prevents other to do his/her job and vice versa.
We are working on different parts of the document and each of us needs to see something different at a given time.
Filters and sorting are modifying the access to the data but not change it and there should be a way to disable the sync for it if needed.
Working on off-line copies is not an option because we all must change or add the data as well.
Imagine a spreadsheet with at least 30 columns and the 500 rows. To work on it we must apply filters and sorting, but the other person needs different sets of filters and sorting to do his/her job so we are constantly clashing and can't work at the same time.
We could as well just work on a document that is shared in a cloud and I thought that having a shared document at the same time will give us some control over what is being synced. Sorting and filtering is a kind of an input that doesn't change the data itself but changes only the view and I would like to have an ability to turn it off the sync.
Also, hiding of columns and rows could be part of that offline set of actions.
Ideally, we could decide which is synced with who.
Here is some more info behind the idea: