Spreadsheet - Filter Spaces in Cells

[三]

Is there a way to filter the JSON data saved in the spreadsheet out of cells that are not filled with data but contain Spaces

[Patrick | Technical Support Engineer, Senior]

Hello 三,

Please take a look at the following couple of ways in which you can filter based on the space character:

Filter with DropDown Menu

One way in which you can search for only specific filtered items is to open the filter dropdown and select the items:

Please take a look at this Progress Kendo UI Dojo which is used in the gif above.

Programmatic CustomFilter 

Another option is to create a kendo.spreadsheet.CustomFilter which can be applied to the Kendo UI Spreadsheet based on your preferences:

JavaScript

          //get spreadsheet, activesheet, and range
          var spreadsheet = $("#spreadsheet").data("kendoSpreadsheet");
          var sheet = spreadsheet.activeSheet();
          var range = sheet.range("A3:G49");

          //set custom filter based on your preferences
          var filter = new kendo.spreadsheet.CustomFilter({
            logic: "or",
            criteria:[
              { operator: "matches", value: " "},
              { operator: "matches", value: "  "},
              { operator: "matches", value: "   "},
              { operator: "matches", value: "    "},
              { operator: "matches", value: "     "},
              { operator: "matches", value: "      "}
            ],
          });

          //set filter
          range.filter([ { column: 4, filter: filter } ]);
          

Here is the Progress Kendo UI Dojo which provides the approach above.

 

Feature Request

Based on the inquiry, I have created a feature request with a vote on your behalf for the Kendo UI SpreadSheet to be able to filter Null or WhiteSpace values easier with the built-in API.  Please feel free to follow the request and provide any comments within the thread. 

Please let me know if you have any questions regarding the above. 

 

Regards,
Patrick | Technical Support Engineer, Senior
Progress Telerik