Pending Review
Last Updated: 27 Nov 2018 14:25 by ADMIN
DerekAlfonso
Created on: 26 Nov 2018 19:41
Category: Spreadsheet
Type: Feature Request
1
How to configure spreadsheet filtration?

Hello,

We are using Spreadsheet widget in our system and have following questions to meet the demands of our customers:

  1. How can the filters be limited to valid choices by type of column? For example a numeric column does not need Filter By Condition options by date or by text containing values.
  2. On initial drop down of the filter the Filter by Value section opens, since most of our columns are numeric that isn't useful. How could we collapse the filter by value option on initial opening of the filter?

Currently we use spreadsheet filtering configuration according to this example:

            $("#spreadsheet").kendoSpreadsheet({
                sheets: [
                {
                    name: "OrdersLog",
                    mergedCells: [
                        "A1:G1",
                        "A2:F2"
                    ],
                    filter: {
                        ref: "A3:G49",
                        columns:[]
                    },

Can you please provide us with working examples of configuration (or required code adjustments) that will help us to meet the requrements above?

1 comment
ADMIN
Veselin Tsvetanov
Posted on: 27 Nov 2018 14:25
Hi Derek,

Currently, the Spreadsheet widget does not expose a configuration option that would allow you to configure the filtering menu. That is why the Filter by condition options could not be reduced to display only those of them which correspond to the value type used in the column. Also, the Filter by condition section could not be displayed as default instead of the Filter by value.

As the Spreadsheet lacks the above described two features, I have converted the current thread to a feature request in our Feedback portal. Here you will find the publicly available item, which I would recommend you to cast your vote for. Based on the support it receives from the community, we will decide on whether to proceed with its implementation or not.

Regards,
Veselin Tsvetanov
Progress Telerik
Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.