The Kendo UI Spreadsheet's range.sort() method sorts column values based on the index. For example, when three column sort objects are passed to the function, the second column will be sorted based on the first column indexes, and the third column will be sorted based on the first and second column indexes. This is described in the API reference:
The built-in sort behavior of the Spreadsheet works differently than the one provided by Excel, where the functionality works based on a 'then-by' principle. I would encourage you to log this as a new feature request in the Kendo UI Feedback Portal.
This way, the rest of the community will be able to discuss and vote for this feature. Based on the demand and gathered feedback, this could be scheduled for implementation in a future release.
As a workaround for the current scenario, I would suggest first sorting the data on the server and then using the fromJSON() method
to load the data into the Spreadsheet. You could refer to the following demo, where the mentioned method is used to retrieve the data from a remote end-point and then bind it to the widget:
Get quickly onboarded and successful
with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.