Pending Review
Last Updated: 10 Sep 2019 10:15 by ADMIN
Created by: Imported User
Comments: 1
Category: Spreadsheet
Type: Feature Request
11
On excel, you can filter merged rows. On the kendo spreadsheet widget, filtering on merged rows is not possible. It would be a very useful feature for us. 

Also worth noting is that if you convert an excel file to JSON using Telerik RadSpreadProcessing, and load the kendo widget with the JSON, the widget displays a filter icon but clicking it loads a non-functioning filter. Wouldn't it make more sense to load with a message along the lines of 'You loaded a spreadsheet with filters applied to merged rows, which is not supported in this widget'. Otherwise it's quite confusing to our users.
Pending Review
Last Updated: 06 Mar 2019 21:07 by Ernest
Created by: Imported User
Comments: 5
Category: Spreadsheet
Type: Feature Request
26
It would be great if you could put images to cells using html. E.g.: <img src="..."> would result in an image in the cell.
Pending Review
Last Updated: 27 Feb 2019 15:26 by Michael
Can the Spreadsheet widget be updated to initialize a sheet that is bound to a datasource when the datasource is an empty object?  

Generally, when a sheet is bound to a datasource, it is for the purpose of editing data, creating new rows and updating/deleting existing rows.  If a datasource comes back empty, the sheet isn't initialized.  So there are no column headers, which can be confusing to users when they don't know what data to enter in which columns.  The other thing is that the sheet itself is not fully initialize so that even if we assign column headers programmatically, when users start entering data, the UI becomes unresponsive and generates a javascript error: Uncaught TypeError: Cannot read property 'indexOf' of undefined
    at r.set (kendo.all.js:4586)
    at r.set (kendo.all.js:4760)
    at kendo.all.js:127702
Pending Review
Last Updated: 26 Feb 2019 09:25 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

Pending Review
Last Updated: 21 Feb 2019 06:52 by ADMIN
How to add Superscript, Subscript HTML Entities to Kendo Spreadsheet Cell Data
Pending Review
Last Updated: 11 Feb 2019 09:23 by Naveen
Created by: Naveen
Comments: 0
Category: Spreadsheet
Type: Feature Request
3
Make Spreadsheet xlsx import failure more user friendly. Currently, when xlsx import fails, the UI thread is blocked and the user needs to reload the page in the browser. The import operation instead could process the file in the background and could return meaningful message without blocking the UI.
Pending Review
Last Updated: 11 Feb 2019 08:57 by ADMIN
Created by: Naveen
Comments: 1
Category: Spreadsheet
Type: Feature Request
3

Dear Concerned,

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

2. Open attached MultipleSheetsRowHeightIssue.xlsx

3. Please notice there are 3 sheets with default row height 20, 30, 40 respectively (you can check in MS Excel)

4. Now Click export, and open the exported file again 

5. Now we have an issue here - all sheets set to default row height to 40. (It seems that it is setting the last sheet's default row height to all sheets)

Its severe issue, please share a fix or at least provide some workaround.

 

Pending Review
Last Updated: 31 Jan 2019 07:38 by Kathy

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);
})
Pending Review
Last Updated: 29 Jan 2019 14:58 by Maxwell
Created by: Jiri
Comments: 3
Category: Spreadsheet
Type: Feature Request
14
I want to be able to double click a column header  to set column width to max width of entries - autoresize
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 Jan 2019 07:07 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

Pending Review
Last Updated: 04 Jan 2019 18:01 by SALVATORE BORRELLI
Created by: John
Comments: 1
Category: Spreadsheet
Type: Feature Request
13
I would like to be able to do conditional formatting against other columns and not just the existing conditional formatting.

For example:

Column 1 = 1.2
Column 2 = 1.5

If the value of Column 2 is greater than the value of Column 1, I want the color to be green.
If the value of Column 2 is less than the value of Column 1, I want the color to be red.
If the value of Column 2 is equal to the value of Column 1, I want the color to be black.
Pending Review
Last Updated: 29 Dec 2018 16:20 by ADMIN

Hi,

When editing a workbook with the Spreadsheet component, if a user switches from a worksheet to another, then moves the scrollbars, when switching back, although the active cell is adequately recovered, the scrollbars are not (the user experience is that they do not react to worksheet switching).

Is this behavior planned to be changed? Is there a workaround?

Best

Pending Review
Last Updated: 17 Dec 2018 14:57 by ADMIN
Created by: Brian
Comments: 1
Category: Spreadsheet
Type: Feature Request
0

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.

Pending Review
Last Updated: 27 Nov 2018 14:25 by ADMIN
Created by: DerekAlfonso
Comments: 1
Category: Spreadsheet
Type: Feature Request
1

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?

Pending Review
Last Updated: 20 Nov 2018 14:47 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


Pending Review
Last Updated: 20 Nov 2018 14:30 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;
}

Pending Review
Last Updated: 09 Nov 2018 16:41 by Prasadh
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.
Pending Review
Last Updated: 08 Oct 2018 18:23 by Prasadh
Created by: Prasadh
Comments: 0
Category: Spreadsheet
Type: Feature Request
2
IF any custom validation available for spreadsheet cells, then while exporting the sheet, those validation error messages or formats not getting exported. So here it will be helpful if its exports validations too. So user can see error in both UI and Exported file. 
In the below example, user can see the error messages in ui but cant see on the exported file. 
https://docs.telerik.com/kendo-ui/controls/data-management/spreadsheet/how-to/validation-to-column
Pending Review
Last Updated: 03 Oct 2018 19:18 by George
Created by: George
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
Ability to set a cell with font Strikethrough
1 2 3 4 5