Sorting Not Working
Advised by MSO365 support to raise a bug here. The sort function is not working correctly when using excel on the web however when we open the exact same file in the application it works fine.
When we sort a date field in ascending or descending order (as shown in OnlineIssue1 & 2) it does not sort the data correctly as some data is still in the wrong order. If we follow the exact same steps in the application the data sorts perfectly as expected (as shown in Application1).
I dont believe this is a data issue as it works fine in the application so it appears to be a bug.
Christine Clark commented
I am having the same exact issue.