New to Telerik UI for ASP.NET Core? Download free 30-day trial

Sorting and Filtering

Loading Demo...

EXAMPLE
VIEW SOURCE
EDIT IN TELERIK REPL
- Edit in Telerik REPL
- Edit in Theme Builder
Change Theme
default
Themes & Swatches

SASS

LESS

Launch Theme Builder
Default Theme

Main

Main Dark

Nordic

Ocean Blue

Purple

Turquoise
Bootstrap Theme

Main

Main Dark

Nordic

Urban

Vintage
Material Theme

Main

Arctic

Lime Dark

Main Dark

Nova
Classic Theme

Main

Main Dark

Opal

Silver
- Black
- Blue Opal
- Bootstrap v3
- Default
- Fiori
- Flat
- High Contrast
- Material
- Material Black
- Metro
- Metro Black
- Moonlight
- Nova
- Office 365
- Silver
- Uniform

                    sorting_filtering.cshtml
                
                    Sorting_FilteringController.cs

Also available for:

CLIENT-SIDE API SERVER-SIDE API

kendo.syncReady(function(){jQuery("#spreadsheet").kendoSpreadsheet({"sheets":[{"name":"OrdersLog","columns":[{"width":80},{"width":100},{"width":100},{"width":150},{"width":150},{"width":130},{"width":130}],"filter":{"ref":"A3:G49"},"mergedCells":["A1:G1","A2:F2"],"rows":[{"cells":[{"background":"rgb(144,164,174)","color":"white","fontSize":18,"value":"ORDERS LOG","textAlign":"center"}],"height":50},{"cells":[{"background":"rgb(176,190,197)","color":"rgb(255,255,255)","value":"REPORT","textAlign":"right"},{"background":"rgb(176,190,197)","color":"rgb(255,255,255)","format":"MMM-dd","formula":"TODAY()","index":6}]},{"cells":[{"background":"rgb(236,239,241)","color":"black","bold":true,"value":"ID","textAlign":"center"},{"background":"rgb(236,239,241)","color":"black","bold":true,"value":"DATE","textAlign":"center"},{"background":"rgb(236,239,241)","color":"black","bold":true,"value":"TIME","textAlign":"center"},{"background":"rgb(236,239,241)","color":"black","bold":true,"value":"CLIENT","textAlign":"center"},{"background":"rgb(236,239,241)","color":"black","bold":true,"value":"COMPANY","textAlign":"center"},{"background":"rgb(236,239,241)","color":"black","bold":true,"value":"SHIPPING","textAlign":"center"},{"background":"rgb(236,239,241)","color":"black","bold":true,"value":"DISCOUNT","textAlign":"center"}]},{"cells":[{"value":10223,"textAlign":"center"},{"value":new Date(2014,5,30,0,0,0,0),"textAlign":"center"},{"format":"hh:mm","value":new Date(2014,5,30,9,30,0,0),"textAlign":"center"},{"value":"Terry Lawson","textAlign":"left"},{"value":"Excella","textAlign":"left"},{"value":"1 day","textAlign":"center"},{"format":"0%","value":0.02,"textAlign":"center"}]},{"cells":[{"value":10247,"textAlign":"center"},{"value":new Date(2014,6,1,0,0,0,0),"textAlign":"center"},{"format":"hh:mm","value":new Date(2014,6,1,15,15,0,0),"textAlign":"center"},{"value":"Charles Miller","textAlign":"left"},{"value":"Complete Tech","textAlign":"left"},{"value":"2 days","textAlign":"center"},{"format":"0%","value":0.08,"textAlign":"center"}]},{"cells":[{"value":10251,"textAlign":"center"},{"value":new Date(2014,6,1,0,0,0,0),"textAlign":"center"},{"format":"hh:mm","value":new Date(2014,6,1,14,13,0,0),"textAlign":"center"},{"value":"Jennie Walker","textAlign":"left"},{"value":"Plan Smart","textAlign":"left"},{"value":"2 days","textAlign":"center"},{"format":"0%","value":0.1,"textAlign":"center"}]},{"cells":[{"value":10226,"textAlign":"center"},{"value":new Date(2014,5,30,0,0,0,0),"textAlign":"center"},{"format":"hh:mm","value":new Date(2014,5,30,17,43,0,0),"textAlign":"center"},{"value":"Samuel Green","textAlign":"left"},{"value":"Excella","textAlign":"left"},{"value":"regular","textAlign":"center"},{"format":"0%","value":0.08,"textAlign":"center"}]},{"cells":[{"value":10227,"textAlign":"center"},{"value":new Date(2014,5,30,0,0,0,0),"textAlign":"center"},{"format":"hh:mm","value":new Date(2014,5,30,10,27,0,0),"textAlign":"center"},{"value":"James Smith","textAlign":"left"},{"value":"Complete Tech","textAlign":"left"},{"value":"2 days","textAlign":"center"},{"format":"0%","value":0.01,"textAlign":"center"}]},{"cells":[{"value":10228,"textAlign":"center"},{"value":new Date(2014,5,30,0,0,0,0),"textAlign":"center"},{"format":"hh:mm","value":new Date(2014,5,30,11,12,0,0),"textAlign":"center"},{"value":"Nora Allen","textAlign":"left"},{"value":"Plan Smart","textAlign":"left"},{"value":"express","textAlign":"center"},{"format":"0%","value":0,"textAlign":"center"}]},{"cells":[{"value":10229,"textAlign":"center"},{"value":new Date(2014,5,29,0,0,0,0),"textAlign":"center"},{"format":"hh:mm","value":new Date(2014,5,29,13,56,0,0),"textAlign":"center"},{"value":"Robyn Mason","textAlign":"left"},{"value":"Excella","textAlign":"left"},{"value":"express","textAlign":"center"},{"format":"0%","value":0.07,"textAlign":"center"}]},{"cells":[{"value":10230,"textAlign":"center"},{"value":new Date(2014,5,29,0,0,0,0),"textAlign":"center"},{"format":"hh:mm","value":new Date(2014,5,29,14,40,0,0),"textAlign":"center"},{"value":"Ralph Burke","textAlign":"left"},{"value":"Plan Smart","textAlign":"left"},{"value":"regular","textAlign":"center"},{"format":"0%","value":0.06,"textAlign":"center"}]},{"cells":[{"value":10231,"textAlign":"center"},{"value":new Date(2014,5,29,0,0,0,0),"textAlign":"center"},{"format":"hh:mm","value":new Date(2014,5,29,8,25,0,0),"textAlign":"center"},{"value":"Patty Prince","textAlign":"left"},{"value":"Integra Design","textAlign":"left"},{"value":"1 day","textAlign":"center"},{"format":"0%","value":0.02,"textAlign":"center"}]},{"cells":[{"value":10232,"textAlign":"center"},{"value":new Date(2014,5,29,0,0,0,0),"textAlign":"center"},{"format":"hh:mm","value":new Date(2014,5,29,10,9,0,0),"textAlign":"center"},{"value":"Natasha Green","textAlign":"left"},{"value":"Excella","textAlign":"left"},{"value":"express","textAlign":"center"},{"format":"0%","value":0,"textAlign":"center"}]},{"cells":[{"value":10233,"textAlign":"center"},{"value":new Date(2014,5,29,0,0,0,0),"textAlign":"center"},{"format":"hh:mm","value":new Date(2014,5,29,12,54,0,0),"textAlign":"center"},{"value":"James Smith","textAlign":"left"},{"value":"Complete Tech","textAlign":"left"},{"value":"express","textAlign":"center"},{"format":"0%","value":0.03,"textAlign":"center"}]},{"cells":[{"value":10259,"textAlign":"center"},{"value":new Date(2014,6,2,0,0,0,0),"textAlign":"center"},{"format":"hh:mm","value":new Date(2014,6,2,11,28,0,0),"textAlign":"center"},{"value":"Francis Stevens","textAlign":"left"},{"value":"Plan Smart","textAlign":"left"},{"value":"2 days","textAlign":"center"},{"format":"0%","value":0.08,"textAlign":"center"}]},{"cells":[{"value":10235,"textAlign":"center"},{"value":new Date(2014,5,29,0,0,0,0),"textAlign":"center"},{"format":"hh:mm","value":new Date(2014,5,29,18,22,0,0),"textAlign":"center"},{"value":"Roger Peters","textAlign":"left"},{"value":"Integra Design","textAlign":"left"},{"value":"2 days","textAlign":"center"},{"format":"0%","value":0.03,"textAlign":"center"}]},{"cells":[{"value":10236,"textAlign":"center"},{"value":new Date(2014,5,29,0,0,0,0),"textAlign":"center"},{"format":"hh:mm","value":new Date(2014,5,29,9,7,0,0),"textAlign":"center"},{"value":"Nora Allen","textAlign":"left"},{"value":"Plan Smart","textAlign":"left"},{"value":"express","textAlign":"center"},{"format":"0%","value":0.02,"textAlign":"center"}]},{"cells":[{"value":10224,"textAlign":"center"},{"value":new Date(2014,5,30,0,0,0,0),"textAlign":"center"},{"format":"hh:mm","value":new Date(2014,5,30,12,14,0,0),"textAlign":"center"},{"value":"Scott Lewis","textAlign":"left"},{"value":"Circuit Design","textAlign":"left"},{"value":"express","textAlign":"center"},{"format":"0%","value":0.09,"textAlign":"center"}]},{"cells":[{"value":10225,"textAlign":"center"},{"value":new Date(2014,5,30,0,0,0,0),"textAlign":"center"},{"format":"hh:mm","value":new Date(2014,5,30,14,58,0,0),"textAlign":"center"},{"value":"Scott Fox","textAlign":"left"},{"value":"Zig Zag Coder","textAlign":"left"},{"value":"express","textAlign":"center"},{"format":"0%","value":0.1,"textAlign":"center"}]},{"cells":[{"value":10239,"textAlign":"center"},{"value":new Date(2014,5,29,0,0,0,0),"textAlign":"center"},{"format":"hh:mm","value":new Date(2014,5,29,17,20,0,0),"textAlign":"center"},{"value":"Marian Rodriguez","textAlign":"left"},{"value":"Zig Zag Coder","textAlign":"left"},{"value":"1 day","textAlign":"center"},{"format":"0%","value":0.06,"textAlign":"center"}]},{"cells":[{"value":10240,"textAlign":"center"},{"value":new Date(2014,5,29,0,0,0,0),"textAlign":"center"},{"format":"hh:mm","value":new Date(2014,5,29,8,4,0,0),"textAlign":"center"},{"value":"Joe Lawrence","textAlign":"left"},{"value":"Complete Tech","textAlign":"left"},{"value":"2 days","textAlign":"center"},{"format":"0%","value":0.07,"textAlign":"center"}]},{"cells":[{"value":10241,"textAlign":"center"},{"value":new Date(2014,5,29,0,0,0,0),"textAlign":"center"},{"format":"hh:mm","value":new Date(2014,5,29,10,49,0,0),"textAlign":"center"},{"value":"Francis Stevens","textAlign":"left"},{"value":"Plan Smart","textAlign":"left"},{"value":"regular","textAlign":"center"},{"format":"0%","value":0,"textAlign":"center"}]},{"cells":[{"value":10242,"textAlign":"center"},{"value":new Date(2014,5,29,0,0,0,0),"textAlign":"center"},{"format":"hh:mm","value":new Date(2014,5,29,13,33,0,0),"textAlign":"center"},{"value":"Lynda Evans","textAlign":"left"},{"value":"Complete Tech","textAlign":"left"},{"value":"regular","textAlign":"center"},{"format":"0%","value":0.05,"textAlign":"center"}]},{"cells":[{"value":10243,"textAlign":"center"},{"value":new Date(2014,5,29,0,0,0,0),"textAlign":"center"},{"format":"hh:mm","value":new Date(2014,5,29,16,18,0,0),"textAlign":"center"},{"value":"Keith Clark","textAlign":"left"},{"value":"Circuit Design","textAlign":"left"},{"value":"1 day","textAlign":"center"},{"format":"0%","value":0,"textAlign":"center"}]},{"cells":[{"value":10244,"textAlign":"center"},{"value":new Date(2014,6,1,0,0,0,0),"textAlign":"center"},{"format":"hh:mm","value":new Date(2014,6,1,19,2,0,0),"textAlign":"center"},{"value":"Kara Wood","textAlign":"left"},{"value":"Excella","textAlign":"left"},{"value":"2 days","textAlign":"center"},{"format":"0%","value":0,"textAlign":"center"}]},{"cells":[{"value":10245,"textAlign":"center"},{"value":new Date(2014,6,1,0,0,0,0),"textAlign":"center"},{"format":"hh:mm","value":new Date(2014,6,1,9,46,0,0),"textAlign":"center"},{"value":"Juan Jacobs","textAlign":"left"},{"value":"Plan Smart","textAlign":"left"},{"value":"regular","textAlign":"center"},{"format":"0%","value":0.07,"textAlign":"center"}]},{"cells":[{"value":10237,"textAlign":"center"},{"value":new Date(2014,5,29,0,0,0,0),"textAlign":"center"},{"format":"hh:mm","value":new Date(2014,5,29,13,51,0,0),"textAlign":"center"},{"value":"Samuel Green","textAlign":"left"},{"value":"Excella","textAlign":"left"},{"value":"express","textAlign":"center"},{"format":"0%","value":0.15,"textAlign":"center"}]},{"cells":[{"value":10265,"textAlign":"center"},{"value":new Date(2014,6,2,0,0,0,0),"textAlign":"center"},{"format":"hh:mm","value":new Date(2014,6,2,14,36,0,0),"textAlign":"center"},{"value":"Alison Thompson","textAlign":"left"},{"value":"Circuit Design","textAlign":"left"},{"value":"express","textAlign":"center"},{"format":"0%","value":0.1,"textAlign":"center"}]},{"cells":[{"value":10248,"textAlign":"center"},{"value":new Date(2014,6,1,0,0,0,0),"textAlign":"center"},{"format":"hh:mm","value":new Date(2014,6,1,18,7,0,0),"textAlign":"center"},{"value":"Jerry Wright","textAlign":"left"},{"value":"Integra Design","textAlign":"left"},{"value":"regular","textAlign":"center"},{"format":"0%","value":0.07,"textAlign":"center"}]},{"cells":[{"value":10234,"textAlign":"center"},{"value":new Date(2014,5,29,0,0,0,0),"textAlign":"center"},{"format":"hh:mm","value":new Date(2014,5,29,15,38,0,0),"textAlign":"center"},{"value":"Nora Allen","textAlign":"left"},{"value":"Plan Smart","textAlign":"left"},{"value":"regular","textAlign":"center"},{"format":"0%","value":0.1,"textAlign":"center"}]},{"cells":[{"value":10238,"textAlign":"center"},{"value":new Date(2014,5,29,0,0,0,0),"textAlign":"center"},{"format":"hh:mm","value":new Date(2014,5,29,14,36,0,0),"textAlign":"center"},{"value":"Mark Moore","textAlign":"left"},{"value":"Webcom Services","textAlign":"left"},{"value":"regular","textAlign":"center"},{"format":"0%","value":0.09,"textAlign":"center"}]},{"cells":[{"value":10246,"textAlign":"center"},{"value":new Date(2014,6,1,0,0,0,0),"textAlign":"center"},{"format":"hh:mm","value":new Date(2014,6,1,12,31,0,0),"textAlign":"center"},{"value":"Patty Prince","textAlign":"left"},{"value":"Integra Design","textAlign":"left"},{"value":"regular","textAlign":"center"},{"format":"0%","value":0.08,"textAlign":"center"}]},{"cells":[{"value":10252,"textAlign":"center"},{"value":new Date(2014,6,1,0,0,0,0),"textAlign":"center"},{"format":"hh:mm","value":new Date(2014,6,1,16,57,0,0),"textAlign":"center"},{"value":"James Smith","textAlign":"left"},{"value":"Complete Tech","textAlign":"left"},{"value":"express","textAlign":"center"},{"format":"0%","value":0.02,"textAlign":"center"}]},{"cells":[{"value":10253,"textAlign":"center"},{"value":new Date(2014,6,1,0,0,0,0),"textAlign":"center"},{"format":"hh:mm","value":new Date(2014,6,1,18,42,0,0),"textAlign":"center"},{"value":"Marian Rodriguez","textAlign":"left"},{"value":"Zig Zag Coder","textAlign":"left"},{"value":"regular","textAlign":"center"},{"format":"0%","value":0.01,"textAlign":"center"}]},{"cells":[{"value":10254,"textAlign":"center"},{"value":new Date(2014,6,1,0,0,0,0),"textAlign":"center"},{"format":"hh:mm","value":new Date(2014,6,1,9,46,0,0),"textAlign":"center"},{"value":"Patty Prince","textAlign":"left"},{"value":"Integra Design","textAlign":"left"},{"value":"express","textAlign":"center"},{"format":"0%","value":0,"textAlign":"center"}]},{"cells":[{"value":10255,"textAlign":"center"},{"value":new Date(2014,6,1,0,0,0,0),"textAlign":"center"},{"format":"hh:mm","value":new Date(2014,6,1,12,31,0,0),"textAlign":"center"},{"value":"Jack Sims","textAlign":"left"},{"value":"Circuit Design","textAlign":"left"},{"value":"express","textAlign":"center"},{"format":"0%","value":0,"textAlign":"center"}]},{"cells":[{"value":10256,"textAlign":"center"},{"value":new Date(2014,6,2,0,0,0,0),"textAlign":"center"},{"format":"hh:mm","value":new Date(2014,6,2,15,15,0,0),"textAlign":"center"},{"value":"Hannah Watson","textAlign":"left"},{"value":"Excella","textAlign":"left"},{"value":"regular","textAlign":"center"},{"format":"0%","value":0.01,"textAlign":"center"}]},{"cells":[{"value":10257,"textAlign":"center"},{"value":new Date(2014,6,2,0,0,0,0),"textAlign":"center"},{"format":"hh:mm","value":new Date(2014,6,2,18,7,0,0),"textAlign":"center"},{"value":"Gregory Morrison","textAlign":"left"},{"value":"Webcom Services","textAlign":"left"},{"value":"2 days","textAlign":"center"},{"format":"0%","value":0.04,"textAlign":"center"}]},{"cells":[{"value":10258,"textAlign":"center"},{"value":new Date(2014,6,2,0,0,0,0),"textAlign":"center"},{"format":"hh:mm","value":new Date(2014,6,2,8,44,0,0),"textAlign":"center"},{"value":"Joe Lawrence","textAlign":"left"},{"value":"Complete Tech","textAlign":"left"},{"value":"1 day","textAlign":"center"},{"format":"0%","value":0,"textAlign":"center"}]},{"cells":[{"value":10249,"textAlign":"center"},{"value":new Date(2014,6,1,0,0,0,0),"textAlign":"center"},{"format":"hh:mm","value":new Date(2014,6,1,8,44,0,0),"textAlign":"center"},{"value":"Edward Hall","textAlign":"left"},{"value":"Zig Zag Coder","textAlign":"left"},{"value":"regular","textAlign":"center"},{"format":"0%","value":0.08,"textAlign":"center"}]},{"cells":[{"value":10260,"textAlign":"center"},{"value":new Date(2014,6,2,0,0,0,0),"textAlign":"center"},{"format":"hh:mm","value":new Date(2014,6,2,14,13,0,0),"textAlign":"center"},{"value":"Glenda White","textAlign":"left"},{"value":"Webcom Services","textAlign":"left"},{"value":"regular","textAlign":"center"},{"format":"0%","value":0.05,"textAlign":"center"}]},{"cells":[{"value":10261,"textAlign":"center"},{"value":new Date(2014,6,2,0,0,0,0),"textAlign":"center"},{"format":"hh:mm","value":new Date(2014,6,2,16,57,0,0),"textAlign":"center"},{"value":"Lynda Evans","textAlign":"left"},{"value":"Complete Tech","textAlign":"left"},{"value":"1 day","textAlign":"center"},{"format":"0%","value":0.01,"textAlign":"center"}]},{"cells":[{"value":10262,"textAlign":"center"},{"value":new Date(2014,6,2,0,0,0,0),"textAlign":"center"},{"format":"hh:mm","value":new Date(2014,6,2,8,48,0,0),"textAlign":"center"},{"value":"Edward Hall","textAlign":"left"},{"value":"Zig Zag Coder","textAlign":"left"},{"value":"2 days","textAlign":"center"},{"format":"0%","value":0.04,"textAlign":"center"}]},{"cells":[{"value":10250,"textAlign":"center"},{"value":new Date(2014,6,1,0,0,0,0),"textAlign":"center"},{"format":"hh:mm","value":new Date(2014,6,1,11,28,0,0),"textAlign":"center"},{"value":"Jerry Wright","textAlign":"left"},{"value":"Integra Design","textAlign":"left"},{"value":"regular","textAlign":"center"},{"format":"0%","value":0.08,"textAlign":"center"}]},{"cells":[{"value":10264,"textAlign":"center"},{"value":new Date(2014,6,2,0,0,0,0),"textAlign":"center"},{"format":"hh:mm","value":new Date(2014,6,2,13,51,0,0),"textAlign":"center"},{"value":"Jerry Wright","textAlign":"left"},{"value":"Integra Design","textAlign":"left"},{"value":"2 days","textAlign":"center"},{"format":"0%","value":0,"textAlign":"center"}]},{"cells":[{"value":10263,"textAlign":"center"},{"value":new Date(2014,6,2,0,0,0,0),"textAlign":"center"},{"format":"hh:mm","value":new Date(2014,6,2,9,7,0,0),"textAlign":"center"},{"value":"Charles Miller","textAlign":"left"},{"value":"Complete Tech","textAlign":"left"},{"value":"regular","textAlign":"center"},{"format":"0%","value":0.1,"textAlign":"center"}]},{"cells":[{"value":10266,"textAlign":"center"},{"value":new Date(2014,6,2,0,0,0,0),"textAlign":"center"},{"format":"hh:mm","value":new Date(2014,6,2,17,20,0,0),"textAlign":"center"},{"value":"Alison Ross","textAlign":"left"},{"value":"Excella","textAlign":"left"},{"value":"express","textAlign":"center"},{"format":"0%","value":0.02,"textAlign":"center"}]},{"cells":[{"value":10267,"textAlign":"center"},{"value":new Date(2014,6,2,0,0,0,0),"textAlign":"center"},{"format":"hh:mm","value":new Date(2014,6,2,8,4,0,0),"textAlign":"center"},{"value":"Alexandra Kennedy","textAlign":"left"},{"value":"Webcom Services","textAlign":"left"},{"value":"regular","textAlign":"center"},{"format":"0%","value":0.05,"textAlign":"center"}]},{"cells":[{"value":10268,"textAlign":"center"},{"value":new Date(2014,6,2,0,0,0,0),"textAlign":"center"},{"format":"hh:mm","value":new Date(2014,6,2,10,49,0,0),"textAlign":"center"},{"value":"Agnes Hill","textAlign":"left"},{"value":"Integra Design","textAlign":"left"},{"value":"1 day","textAlign":"center"},{"format":"0%","value":0,"textAlign":"center"}]}]}],"toolbar":{"home":["open","exportAs",["cut","copy","paste"],["bold","italic","underline"],"hyperlink","insertComment","insertImage","backgroundColor","textColor","borders","fontSize","fontFamily","alignment","textWrap",["formatDecreaseDecimal","formatIncreaseDecimal"],"format","merge","freeze","filter","toggleGridlines"],"insert":[["addColumnLeft","addColumnRight","addRowBelow","addRowAbove"],["deleteColumn","deleteRow"]],"data":["sort","filter","validation"]}});});

Sorting and Filtering

Themes & Swatches

Support & Learning Resources