Pending Review
Last Updated: 24 Jan 2019 09:12 by ADMIN
Created by: WT
Comments: 2
Category: Spreadsheet
Type: Feature Request
5
In percent-formatted cells, Excel will place a '%' as the user types. This allows 50% to be entered as '50'.

Steps (excel and kendo):

1. Format a cell as percent

2. Enter 50

Excel shows "50.00%". The actual value is .5

Kendo widget shows "5000.00%". The actual value is 50
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: 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: 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: 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.
Pending Review
Last Updated: 14 Feb 2018 05:39 by Johnson
total row count should display on footer like in excel , row count should change after each filter , also option for to add "action link" to the columns so that we can navigate/popup to other pages..
Pending Review
Last Updated: 22 Dec 2017 15:15 by ADMIN
I checked out the feature request provisions on your site. Since I'd like to include photos with my description, I'm hoping that it is okay that I send this to you for forwarding on to the appropriate audience.

My feature request involves the spreadsheet control in Kendo's JQuery controls

The request is for an attribute to be added to a cell of a spreadsheet which can be used by JQuery to associate the HTML dom element with the spreadsheet's javascript model. Here is why:


In needing to place things in the cells of spreadsheets (such as images and my own custom controls) as can be seen in my images 1 and 2, it is necessary to know which div.k-spreadsheet-cell corresponds with a kendo javascript spreadsheet cell. As a work around, I have given my custom controls an index number. In the kendo javascript object, I set the cell's background color to the same value as that index. This gave me two benefits: 1) it put a characteristic on the cell's div object that could identify the cell; 2) it rendered the cell even if it had no content--this is particularly important.

In my image 4, you can see the background color attribute of a cell div. In image 3, you can see my collection of custom controls. Each of my div.custom-control has a control_index property. I have a routine that runs periodically to reckon the location and size of each control whose background color is set to a value matching one of my cell's control indices. Once located, the controls are laid down onto their respective cells at their appropriate size (or made invisible if the target cell is scrolled off of the container).

This work around contains a lot of painful overhead. For instance, when a spreadsheet is first rendered, I have to traverse the div.k-spreadsheet-cell elements to check their background color attributes. If they qualify, a css class must be placed on the cell so that a black cell isn't presented in the time that it takes to reckon and position my custom controls.

If there were a 'tag' attribute that could be added to a cell's javascript model and that tag was ascribed to the div.k-spreadsheet-cell element (AND make the element render even if it is otherwise trivial), this operation would be a lot easier. I think that I'm not the only one who would like to take some control over the dom objects of the spreadsheet control. 

I would be happy to discuss this further with anybody who is interested.

Thanks,

Doug
Pending Review
Last Updated: 11 Dec 2017 17:46 by Tristan
The spreadsheet widget should be able to take an imported .xlsx file, such as a preconstructed template, and update bound database tables if the fields match.
Pending Review
Last Updated: 05 Dec 2017 21:56 by Richard
Created by: Richard
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
The Excel file downloaded from Spreadsheet does not maintain leading spaces.  In other words, the internal sharedString.xml should use <t xml:space="preserve"> when necessary.
Pending Review
Last Updated: 05 Dec 2017 21:50 by Richard
Created by: Richard
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
WorksheetPageSetup would be a dialog in the kendo ui spreadsheet and persist when the work book is downloaded as Excel or pdf. 
The setup values would also be used to prepopulate the settings in the download dialog.

WorksheetPageSetup would be maintained when a server-side generated Telerik.Windows.Documents.Spreadsheet.Model.Workbook is converted to a Telerik.Web.Spreadsheet.Workbook by method FromDocument().

Page setup maintains settings for printing: orientation, scaling, margins, paper size, grid lines, column headings etc...
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: 11 Oct 2017 14:48 by ADMIN
Created by: David
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
The spreadsheet doesn't provide any configuration options for the font size unit; it is always in pixels. I need to be able to specify other CSS units, such as points or ems.
Pending Review
Last Updated: 21 Sep 2017 12:31 by Tushar
Created by: Tushar
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
1. Formula selection dragging

2. Formula selection resize

Details: While using cell references in formulas in a cell, user should be able to drag and resize the referenced cell selection.

Refer the video present here for details.
<https://drive.google.com/file/d/0B2aXCYXjjcD9RDZpd0lScEV3UUk/view?usp=sharing>
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: 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: 15 Sep 2017 07:56 by ADMIN
Expose a property on the range object of the spreadsheet component which shows whether a range is currently hidden or shown
Pending Review
Last Updated: 11 Oct 2017 14:37 by ADMIN
Created by: Geoffrey
Comments: 0
Category: Spreadsheet
Type: Feature Request
3
add indent property to spreadsheet cells to closer match excel
Pending Review
Last Updated: 10 Aug 2017 09:08 by ADMIN
I have a first example using the Kendo Toolbar widget and I was able to get an Angular button rendered in the toolbar:
http://dojo.telerik.com/ucIfin
When I tried to do the same thing in the Kendo Spreadsheet widget toolbar, it failed to compile my template:
http://dojo.telerik.com/UseWI

In general Angular directives are not compiled properly when specified in the template of a Spreadsheet Toolbar item.  I am aware of a workaround for the kendo-button specific case, but I would like the template to work for custom Angular directives as well.
Pending Review
Last Updated: 28 Feb 2018 10:39 by ADMIN
Created by: Doron Naveh
Comments: 0
Category: Spreadsheet
Type: Feature Request
12
 add search functionality to the Spreadsheet.