Answering to your questions:
- The Spreasdheet widget does not expose sort / filter events, that could be handled. In addition, the DataSource of the Spreadsheet could be configured with remote source (transport actions as in our demo
). In such scenario, the information of how the data is currently sorted / filtered should be sent to server along with the information about the deleted / inserted / updated entry. The data from the database should be sorted and filtered on the server and the appropriate item should be modified / deleted or created. This synchronization of the filtering / sorting of data between the client and the server is currently not supported by the Spreadsheet and the DataSource objects;
- As I mentioned, there is no event that would be fired, when the data in the Sheet is sorted. However, you could simply remove the filter
tool from the toolbar by manually specifying the included tools in the Home tab
you will find a simple Dojo sample, demonstrating the above.
Alternatively, if you need to hide only the sort section in the filtering menu, you could do that by using CSS:
Telerik by Progress