Pending Review
Last Updated: 27 Nov 2018 14:25 by ADMIN
Created by: DerekAlfonso
Comments: 1
Category: Spreadsheet
Type: Feature Request
1

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?

Pending Review
Last Updated: 22 Nov 2018 07:09 by ADMIN
Created by: Dimitar
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
Provide support for zooming the Spreadsheet's cells grid similar to the one provided by Excel.
Pending Review
Last Updated: 20 Nov 2018 14:47 by ADMIN
Created by: Dave
Comments: 2
Category: Spreadsheet
Type: Feature Request
1

The sheets bar should be configurable with some configuration options to control the ability to..

1. Add sheets

2. Remove sheets

3. Rename sheets

4. Reorder sheets


Pending Review
Last Updated: 20 Nov 2018 14:30 by ADMIN

1. The top tab section (with the Home, Insert, Data, Undo, Redo) button of the toolbar should be configurable to be hidden, i.e. "single toolbar" configuration should be supported. Since it is possible to configure the toolbar to show custom items, it should also be possible to hide other tabs and the undo/redo button and only have a single toolbar as the configuration.

/* Style hack to hide the "Home/Insert/Data" tabstrip at the top of the spreadsheet. */
.k-spreadsheet-tabstrip.k-tabstrip {
    & > ul {
        display: none;
    }

    & .k-content {
        border-top: 0px;
    }
}

/**
 * Style hack to hide the undo/redo buttons in the quick-access toolbar.
 */
.k-tabstrip-wrapper .k-spreadsheet-quick-access-toolbar {
    display: none;
}

Pending Review
Last Updated: 09 Nov 2018 16:41 by Prasadh
When we use custom validation for a cell using below method
kendo.spreadsheet.defineFunction("CUSTOM_VALIDATION", function(num){});
its triggered for each cell. Let say i have applied this validation method for 100 cells. If i changed any one cell then this method got invoked 100 times. Instead it should execute single time i.e, for that changed cell only. We cant keep 100 different methods for 100 cells. This will impact more on performance. Please look it on this and fix accordingly. 
This feature will be helpful for complex usage.
Pending Review
Last Updated: 08 Oct 2018 18:23 by Prasadh
Created by: Prasadh
Comments: 0
Category: Spreadsheet
Type: Feature Request
2
IF any custom validation available for spreadsheet cells, then while exporting the sheet, those validation error messages or formats not getting exported. So here it will be helpful if its exports validations too. So user can see error in both UI and Exported file. 
In the below example, user can see the error messages in ui but cant see on the exported file. 
https://docs.telerik.com/kendo-ui/controls/data-management/spreadsheet/how-to/validation-to-column
Pending Review
Last Updated: 03 Oct 2018 19:18 by George
Created by: George
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
Ability to set a cell with font Strikethrough
Pending Review
Last Updated: 28 Sep 2018 15:08 by ADMIN
Created by: Ram
Comments: 0
Category: Spreadsheet
Type: Feature Request
7
Ability to dynamically bound the DropDown editor to an array of objects 
Pending Review
Last Updated: 03 Aug 2018 13:32 by ADMIN
Created by: Imported User
Comments: 1
Category: Spreadsheet
Type: Feature Request
8
Can we have a facility to copy a cell and paste it to a selection. (i.e paste to multiple cells)
Pending Review
Last Updated: 24 Jul 2018 20:55 by ADMIN
Created by: WT
Comments: 0
Category: Spreadsheet
Type: Feature Request
5
Currently only the global culture is used to parse dates. This behavior differs from Excel as I can enter 1/1/19 to parse to 1/1/2019.

I would like the widget to format using the chosen date culture (mm/dd/yyyy), but parse in an optional way, such as mm/dd/yy.
Pending Review
Last Updated: 18 Jul 2018 13:33 by ADMIN
Created by: auto
Comments: 0
Category: Spreadsheet
Type: Feature Request
2
I use data binding data source for spreadsheet
But when I use it, data auto input begins at row 0
I want to insert 2 row (To Write title)
Pending Review
Last Updated: 06 Jul 2018 05:13 by Doug Hills
I have altered the kendo code to add row and column references to the k-spreadsheet-cell dom objects. A sample of this is: 
<div style="color: rgb(81, . . .  class="k-spreadsheet-cell r17c1 row-17 col-1"> . . . .
I have items that I wish to place on top of cells in the spreadsheet.
I can use these classes to identify the dom element corresponding to a spreadsheet cell object. I wish that this thing would let me post images. This is working really well. 
Request: It would be nice if the spreadsheet code to do this out of the box. Further, it would be beneficial to add a 'tag' property to a spreadsheet cell that would be indicated in the cell's dom object. If a cell has a tag, it should be rendered even if it doesn't have non-trivial formatting or a value.
Pending Review
Last Updated: 03 Jul 2018 16:42 by ADMIN
Created by: Andrea
Comments: 2
Category: Spreadsheet
Type: Feature Request
21
We'd need support for checkboxes columns in the new Spreadsheet control.
Pending Review
Last Updated: 22 Jun 2018 07:39 by ADMIN
Created by: Imported User
Comments: 0
Category: Spreadsheet
Type: Feature Request
2
It would be nice to have text orientation support (at least vertical) like in MS Office.
Pending Review
Last Updated: 08 Jun 2018 10:41 by ADMIN
Created by: Imported User
Comments: 1
Category: Spreadsheet
Type: Feature Request
3
By default the items in filter are in random order. Can we sort the items in ascending order by default.
Pending Review
Last Updated: 29 May 2018 15:18 by ADMIN
Spreadsheet import currently handles (keeps) rich text formatting of a cell if the entire cell is formatted, such as a colored row or all bold text in cell. However, if the content of the cell is a mix of plain text and formatted text, the formatting gets dropped on import. If it is possible, it would be nice to keep rich text under this condition.
Pending Review
Last Updated: 18 May 2018 16:08 by ADMIN
Created by: Imported User
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
It would be great to be able to put buttons inside a cell or merged cell for atomic functionality. 
Actually I would really need it for a project we are working on at our company.
Pending Review
Last Updated: 14 May 2018 12:28 by ADMIN
Created by: Martin
Comments: 1
Category: Spreadsheet
Type: Feature Request
6
In Kendo UI spreadsheet when wrap cell text it currently split text in middle of word. Change so that splits on white space
Pending Review
Last Updated: 02 Apr 2018 19:30 by Telerik Admin
Hi Progress - just some quick feedback: 1. Telerik Control Panel updates - it feels like a lot of the time, when the TCP needs updating the user has to manually uninstall the old version and the install the new one using the .exe installer. If the TCP could automatically handle this process, that would be appreciated. 2. The various Telerik Spread Processing libraries (and other document processing libraries) can only be installed as an included component of the Telerik "UI for X" library installations. It would be great if there was an option in the TCP to do a standalone installation of just the Spread Processing libraries. Thanks and kind regards, - Lawrence
Pending Review
Last Updated: 13 Mar 2018 14:01 by Mike
type =IF( "a"="A" ; 1 ; 0 ) and =IF( EXACT("a";"A") ; 1 ; 0 )
into Kendo Spreadsheet and Google Spreadsheet and MS Excel.
There is a special EXACT function (which is also available in Kendo) to enforce case-sensitivity. By default it should be off.