I am afraid, that the required filter functionality is not supported by the Spreadsheet widget. What I would suggest you is to log your idea in our Feedback portal
. Based on the support it receives from the community, we will decide on whether to proceed with its implementation.
Telerik by Progress