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

ASP.NET Core Spreadsheet Sorting and Filtering

Loading Demo...

EXAMPLE
VIEW SOURCE
Edit in Telerik REPL
Change Theme
default
Default Theme

Main

Main Dark

Nordic

Ocean Blue

Ocean Blue A11Y

Purple

Turquoise
Bootstrap Theme

Main

Bootstrap 3

Bootstrap 3 Dark

Main Dark

Nordic

Turquoise

Turquoise Dark

Urban

Vintage
Material Theme

Main

Arctic

Lime Dark

Main Dark

Nova
Classic Theme

Main

Green

Green Dark

Lavender

Lavender Dark

Main Dark

Metro

Metro Dark

Moonlight

Opal

Opal Dark

Silver

Silver Dark

Uniform
Fluent Theme

Main
Launch Theme Builder

HtmlHelper
TagHelper
Files:
                    sorting_filtering.cshtml
                
                    Sorting_FilteringController.cs
                
                    Sorting_Filtering_TagHelper.cshtml

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":true,"insert":true,"data":true}});});

ASP.NET Core Spreadsheet Sorting and Filtering

Support & Learning Resources

Additional Resources

Product Bundles

DevCraft

Web

Mobile

Document Management

Desktop

Reporting & Mocking

Automated Testing

CMS

UI/UX Tools

Debugging

Extended Reality

Free Tools

ASP.NET Core Spreadsheet Sorting and Filtering

Support & Learning Resources

Additional Resources