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

Sorting and Filtering

Loading Demo...

EXAMPLE
VIEW SOURCE
Edit in Theme Builder
Change Theme
Default
SASS

LESS
- Default
- Bootstrap
- Material
- Launch Theme Builder
- 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:

API REFERENCE

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

Support & Learning Resources

Was this demo helpful?

Tell us how we can improve this demo