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: 22 Jul 2019 14:08 by ADMIN
ADMIN
Created by: Marin Bratanov
Comments: 1
Category: Spreadsheet
Type: Feature Request
1
The current context menu lets you hide a row or column, but then you cannot show it again, so the user can lose data. At present there is no context menu option to unhide it and there is no element indicating the column/row was there in the first place. This should behave like in Excel.
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:01 by ADMIN
Created by: Imported User
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
It would be great if there is a cell (and column) type that lets you choose from a defined list (manually defined list or based on a cell-range). It should be possible to make multple selections and the output should be put into the cell separated with semi-colons.
Declined
Last Updated: 26 Feb 2020 14:46 by ADMIN
Created by: Otto Neff
Comments: 1
Category: Spreadsheet
Type: Feature Request
1
Declined
Last Updated: 27 Feb 2020 16:04 by ADMIN
Unplanned
Last Updated: 03 Jun 2019 10:55 by ADMIN
Created by: iFACTS Admin
Comments: 4
Category: Spreadsheet
Type: Feature Request
1

Hi again :)

I see that in the configuration I can specify the max number of rows/column. However, I can do it per component basis, and I would like to have that on a per-sheet basis. Any way I can implement this?

Thanks!

Declined
Last Updated: 26 Feb 2020 14:03 by ADMIN
Created by: Otto Neff
Comments: 1
Category: Spreadsheet
Type: Feature Request
1
Unplanned
Last Updated: 25 Nov 2019 08:44 by ADMIN
It would be useful if it is possible to filter between a range of values, like in Excel. For example filter for values that are between 3 and 6.
Unplanned
Last Updated: 19 Nov 2019 15:54 by ADMIN
Created by: Janne
Comments: 1
Category: Spreadsheet
Type: Feature Request
1

I would like to be able to generate PDF from spreadsheet using HTML template (like http://dojo.telerik.com/Ovegu), so i could specify headers and footers for all PDFs that are created by the user.

Unplanned
Last Updated: 10 Sep 2019 08:55 by ADMIN
Created by: Chris
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
Currently the API does not provide a way to detect when filtering occurs. It would be great if you could add a filter event.
Unplanned
Last Updated: 17 Sep 2019 08:30 by ADMIN
Created by: Chris
Comments: 3
Category: Spreadsheet
Type: Feature Request
1

Hi

Does the kendo spreadsheet support conditional formatting / data bars (which are the background bar charts on a cell)...

See example below - and attached simple xlsx (in zip)

 



which in excel you add like

 

If not currently supported as standard, any suggested workarounds?

Thanks

 

Chris

Unplanned
Last Updated: 04 Oct 2019 08:10 by ADMIN
Created by: Sandeep
Comments: 1
Category: Spreadsheet
Type: Feature Request
1

Enhancement

Please refer to this Dojo example - https://dojo.telerik.com/IRIRahoS/2.

Current behavior

Currently, if the filter configuration is not explicitly set, the filter button from the toolbar seem inefficient. If you toggle a filter for a column, that filter is applied for that column only. In Excel, the filter will be applied for all columns. Also, you need to manually select all the cells that you wish to filter/sort.

Steps to observe the above:
In the Dojo example, toggle filter for a column only (without manually selecting cells).

You can see that the filter will be applied for that column only. Please compare to Excel.

You will see that there is no content to be filtered/sorted. You need to select manually. Again, please compare to Excel.

Expected/desired behavior

When the filter button is pressed, execute the filter configuration logic, so that it will behave as Excel.
filter: { ref: "A3:G49", columns:[] },

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);
})
Unplanned
Last Updated: 09 Oct 2019 15:13 by ADMIN
Consider implementing functionality for importing and working with encrypted / password protected Excel files in the SpreadSheet component
Unplanned
Last Updated: 22 Aug 2019 10:51 by ADMIN
Created by: G.K. Raju
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
Currently there is no suitable event to detect cell styling changes. Such event could be implemented similar to the formatChange event but for the styling changes.
Unplanned
Last Updated: 03 Sep 2019 10:08 by ADMIN
Created by: Holly
Comments: 1
Category: Spreadsheet
Type: Feature Request
1

We have a client that recently brought to our attention the fact that he found a case where he couldn't place his cursor in a certain spot of a formula, click a cell, and have it fill that cell in. It works if you try to do that for the first cell listed in the formula, but not the rest. I've outlined a sample case below.

You can enter a formula in a cell like =IF(A2+B2, 1, -(A2+B2), 2). Then, highlight a cell, like A2 below, and delete it by hitting backspace or delete.

After hitting delete, leave the cursor in the same location of the formula and click a new cell, like A4.

For this case, since it's the first cell in the formula, it will insert the cell you just clicked on in the correct location. However, next try highlighting the next cell referenced, hitting delete, and clicking on a new cell to have it insert the cell into the formula. In this case, we highlighted and deleted B2, then tried to click on B4.

You'll see that, for this one, instead of inserting B4, it gives an error message. Our client said that it significantly slows him down when he has to manually type in each change to the formula, so is there any way we could have it insert the cell you click on for all cases? It doesn't look like this is a current feature, so would you be able to add it, please? Thank you!

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.