Unplanned
Last Updated: 21 Jul 2020 07:16 by ADMIN
Created by: Dhruven
Comments: 1
Category: Spreadsheet
Type: Feature Request
3

When I use this formula 

=HYPERLINK("mailto:"&B4&"?subject=“& B5 & “&body=“ & B6,", "test")

in the excel, I am able to click on the link which opens up my mail client with compose new email window and also populates To, Subject and Body of the email from cells B4, B5, B6 respectively.

But currently, HYPERLINK formula does not support "mailto:" functionality in Kendo UI spreadsheet. I would love to see this with kendo UI spreadsheet. 

For more details you can see the discussion on the forums here

Unplanned
Last Updated: 08 Jul 2020 07:55 by ADMIN
Created by: Naveen
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
It would be useful to have a method capable of executing a formula without assigning it to a cell in the Spreadsheet.
Unplanned
Last Updated: 17 Jun 2020 09:41 by ADMIN
Created by: Naveen
Comments: 1
Category: Spreadsheet
Type: Feature Request
2

Need:

Extract only the values for all Spreadsheet cells. These extracted values can be sent back to server (with minimum size) as server only needs data on each sheet. On other information required like references, formulas, images, colors etc.

 

Possible Approach:

On click of save or a separate button, which will generate a low size data file (having sheet name, cell index and value), which we can send to server.

 

It will save network traffic and also no complex parsing needed at server side to fetch data.

 

Unplanned
Last Updated: 11 Jun 2020 11:21 by Naveen
Created by: David M
Comments: 5
Category: Spreadsheet
Type: Feature Request
24
Use case:
My app doesn't know how many rows of data the excel spreadsheet will be prior to upload.  I've defaulted to my maximum amount of 10,000 which will be normal for some, but overkill for others.  The ability to change the number of rows/columns to accommodate the size of the sheet after loading, would be a nice addition.  

As a workaround, I'm destroying and reloading the widget instance after the initial load.
Unplanned
Last Updated: 10 Jun 2020 12:55 by ADMIN
Created by: Naveen
Comments: 2
Category: Spreadsheet
Type: Feature Request
2

Dear Concerned,

1. open https://demos.telerik.com/kendo-ui/spreadsheet/index

2. select row header of row 10, go to Insert tab

3. click insert row below, it inserts row successfully after row 10, it adjust formulas of row 12, and other rows there after which is good.

4. But issue is - it neither keep format of row 10 in new row & nor it add formulas to various columns in new row(e.g. F11, E11)

Please suggest how can we achieve it, it is very common and useful feature which excel have. if you do not have any ready solution then please suggest workaround for the same as it is urgent for my client.

Unplanned
Last Updated: 02 Jun 2020 07:34 by ADMIN
Created by: kaan
Comments: 1
Category: Spreadsheet
Type: Feature Request
0

Hi,

I want to highlight spreadsheet on cell hover. But I just want to highlight row and column until cell. Is there any way to do this ? 

In example, When my mouse on cell E11.

Best Regards,

Kaan

Unplanned
Last Updated: 28 May 2020 12:32 by ADMIN

In Excel it is possible to select several rows and increase/decrease all selected rows height. In the Spreadsheet this works only for the last selected row. The following steps demonstrate the behavior:

1. Open https://demos.telerik.com/kendo-ui/spreadsheet/index

2. Click on the header of row 6, hold and drag until rows 6, 7, 8, 9 , 10 are selected.

3. Click the handle below row 10's header and drag to increase the height of the rows. The Spreadsheet increases only the last row's height.

Unplanned
Last Updated: 05 May 2020 18:04 by ADMIN
Created by: Ohenewa
Comments: 0
Category: Spreadsheet
Type: Feature Request
1

Currently, the sheets in the Spreadsheet component can be reordered. It will be a very useful feature if we can configure the component in a way this reordering can be disabled.

Thus the users won't be able to move the sheets' tabs.

Unplanned
Last Updated: 05 May 2020 16:07 by ADMIN

Currently, when the "Custom format" button in the Spreadsheet is clicked, the available predefined formats that can be applied to a cell appear as demonstrated in the below screenshot. These predefined options don't change if you set a specific Kendo UI culture. 

It will be a very useful feature to be able to change the predefined custom formats. Also, it will be nice if the custom formats in the Spreadsheet can be set based on the selected Kendo UI culture. 

Unplanned
Last Updated: 25 Mar 2020 18:01 by ADMIN
Created by: Naveen
Comments: 0
Category: Spreadsheet
Type: Feature Request
1

Add support for multiple ranges for the Spreadsheet's SUM function, for example: 

=SUM(E5:E6:E9:E10)

Unplanned
Last Updated: 17 Mar 2020 08:05 by ADMIN
Created by: Massimo
Comments: 1
Category: Spreadsheet
Type: Feature Request
3

Needs:

Load big excel files stored on the server

Possible implementation:

Load on demand data:

First load the file structure (sheets name, column names and number of rows)

Then load data when sheet is selected or scrolled

Unplanned
Last Updated: 26 Feb 2020 15:31 by ADMIN
Created by: Imported User
Comments: 1
Category: Spreadsheet
Type: Feature Request
9
Integration of the pivot control with the spreadsheet
Unplanned
Last Updated: 26 Feb 2020 15:16 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;
}

Unplanned
Last Updated: 26 Feb 2020 15:14 by ADMIN
Created by: Brian
Comments: 1
Category: Spreadsheet
Type: Feature Request
3

It would be nice to have custom attributes for rows and cells so that I can track things behind the scenes such as row identifiers that could be used to update a corresponding rows in a the data base. This id would not be editable by the user. There are many more uses I would like this for and that is just one example.

I would rather not have to create a column in the spreadsheet just for this and then hide it. I find that very clunky.

 

Thanks.

Unplanned
Last Updated: 26 Feb 2020 15:13 by ADMIN
Created by: Michael
Comments: 1
Category: Spreadsheet
Type: Feature Request
0

Hi,

We are using Kendo spreadsheet one of our applications. We wanted to get applied filters and set back to the Kendo spreadsheet. Not able to find a documentation for that. Can you please anyone help to sort this issue out?

Thanks

Unplanned
Last Updated: 26 Feb 2020 15:12 by ADMIN
Created by: Jeffrey
Comments: 1
Category: Spreadsheet
Type: Feature Request
0

Hello

We are trying to use the Kendo Jquery spreadsheet but are running across some issues in terms of setting up for printing and/or exporting to PDF.

 

Currently, we let the user modify the spreadsheet to suit their needs.  The problem is there is no way to see page breaks at this time...that we know of.  The users stretch columns and row to suit their needs but the only way to see if they 'broke' across a page is to export to pdf to see...

 

We would like one or two options...

1. We know what our page size is - 8 1/2 x 11.  Is there a way to fix the max size of the spreadsheet so it's 1 page wide?  If the user inserts columns then the other columns just get smaller and smaller - proportionally - but ultimately the sheet is as only as wide as 1 page...

 

2. The ability to see where the page breaks are so they can set up the sheet correctly.

 

Please let me know if one of these options is feasible or are we stuck?

 

Thank you

Jeffrey Suffet

Unplanned
Last Updated: 26 Feb 2020 15:06 by ADMIN
Created by: kaan
Comments: 3
Category: Spreadsheet
Type: Feature Request
0

Hello,

Is is possible to trigger validation in cells in spreadsheet control? I want to make all validation controls with a button click outside the spreadsheet control.

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.
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.
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
1 2 3 4 5