Completed
Last Updated: 26 Feb 2020 14:58 by ADMIN
Created by: Su Pei
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
It would be useful if copy and paste the data have the option of fill the series or copy the value for the date format. 
Furthermore, copy from multiple column value and allow to paste multiple copied value from the spreadsheet will be added advantage. 

Thanks. 
Unplanned
Last Updated: 26 Feb 2020 14:56 by ADMIN
Created by: SHIVANG
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
I am working on a project where i am using KendoUI components. I have to show a financial sheet. All formulas are working fine like SUM,INDIRECT etc. but IRR not working as expected.

Tested IRR formula outside my project and the same happened.
Declined
Last Updated: 26 Feb 2020 14:54 by ADMIN
Created by: Victor
Comments: 1
Category: Spreadsheet
Type: Feature Request
1
I need the way to get a user the opportunity to set the columns headers. Moreover, the columns headers should be saved separately from the main spreadsheet data.

Of course, the possible variant is to have two spreadsheets: the one – for the data, the second (with one row) – for the headers.

But the better way is to get a user the opportunity to set the spreadsheet columns headers.
It would be ideally if a user could change “A”, “B”, “C” for “ID”, “Product”, “Quantity” …
Not to have a first row for headers, but change the spreadsheet columns headers!
Moreover, we have the context menu on the columns headers and it is possible to add one more item “Edit” in it.
Completed
Last Updated: 26 Feb 2020 14:52 by ADMIN
Created by: Nikos
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
Under Review
Last Updated: 26 Feb 2020 14:50 by ADMIN
Presently in Spreadsheet tooltip is not working for filter applied range 
so tooltip should display for each cell in which the range of filter is applied
Unplanned
Last Updated: 26 Feb 2020 14:48 by ADMIN
Created by: Ashvinkumar
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
Add ability to add group multiple columns and add a group header for those columns.
Declined
Last Updated: 26 Feb 2020 14:46 by ADMIN
Created by: Otto Neff
Comments: 1
Category: Spreadsheet
Type: Feature Request
1
Unplanned
Last Updated: 26 Feb 2020 14:44 by ADMIN
Expose a property on the range object of the spreadsheet component which shows whether a range is currently hidden or shown
Unplanned
Last Updated: 26 Feb 2020 14:43 by ADMIN
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>
Declined
Last Updated: 26 Feb 2020 14:35 by ADMIN
Created by: David
Comments: 1
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.
Unplanned
Last Updated: 26 Feb 2020 14:33 by ADMIN
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...
Unplanned
Last Updated: 26 Feb 2020 14:30 by ADMIN
Created by: Otto Neff
Comments: 3
Category: Spreadsheet
Type: Feature Request
2
Under Review
Last Updated: 26 Feb 2020 14:29 by ADMIN
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.
Unplanned
Last Updated: 26 Feb 2020 14:28 by ADMIN
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.
Duplicated
Last Updated: 26 Feb 2020 14:27 by ADMIN
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..
Completed
Last Updated: 26 Feb 2020 14:25 by ADMIN
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.
Duplicated
Last Updated: 26 Feb 2020 14:19 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.
Unplanned
Last Updated: 26 Feb 2020 14:18 by ADMIN
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.
Unplanned
Last Updated: 26 Feb 2020 14:17 by ADMIN

I see some potential for improvements here, I see how the Spreadsheet entirely depends on the JSON structure. It doesn't have to be like this as the setDataSource() method shows clearly that the columns could be further configured: 

https://www.telerik.com/forums/datasource---specify-columns#msCK2ytWcESxeUMs-6a3uQ

Therefore, the Sheet columns could be configured upon the widget initialization. Such configuration options could be represented in the following manner for the HTML helper version of the widget:

.Columns<Kendo.Mvc.Examples.Models.SpreadsheetProductViewModel>(columns =>
{
    columns.Add(c => c.ProductId).Name("Product ID").Width(100);
    columns.Add(c => c.ProductName).Name("Name").Width(415);
})
Declined
Last Updated: 26 Feb 2020 14:16 by ADMIN
Please see Demo https://dojo.telerik.com/UNOPUvaB/2

In first data row (Row 3) I create a range of numeric values from a , middle and maximum value.
Validation works perfectly, e.g. when manipulating the Middle value, I cannot go below minimum cell value and not above maximum cell value, until adjusted.

I want to accomplish the same with dates in second data row (Row 4 when I reference another "C4", it looks like validation works as expected, but the Date Picker is broken.