Completed
Last Updated: 26 Feb 2020 14:58 by ADMIN
Created by: Su Pei
Comments: 0
Category: Spreadsheet
Type: Feature Request
2
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
2
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
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.
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.
Completed
Last Updated: 26 Feb 2020 14:10 by ADMIN

Hi,

 

I encountered a bug when using the spreadsheet control with a remote datasource which I was able to replicate using the datasource binding demo (https://demos.telerik.com/kendo-ui/spreadsheet/datasource).

When entering data on an empty cell in an empty row not adjacent to a non-empty row (e.g. a row that is two rows below the end of the data); then editing a cell in the same row, but adjacent column, this creates two items in the corresponding datasource.

Editing an empty row above this new row will modify one of the records created in this process.

Unplanned
Last Updated: 26 Feb 2020 14:09 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


Unplanned
Last Updated: 26 Feb 2020 14:07 by ADMIN

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?