Unplanned
Last Updated: 25 Feb 2020 15:44 by ADMIN
DefaultCellStyle property in spreadsheet has a field “Wrap”, but doesn’t have a field “Format”. For example, if I need to process all cells as text, I must set the field “Format” on a client side:
sheet.range("A1:AX200").wrap(true).format("@");
It works.
But the initialization of the range ("A1:AX200") takes time… It is not very fast…
It would be better to have the field “Format” in the DefaultCellStyle property in spreadsheet…
Declined
Last Updated: 25 Feb 2020 15:33 by ADMIN
Created by: Doug
Comments: 1
Category: Spreadsheet
Type: Feature Request
2
Custom editors are great!  But often when you have a custom editor, you want to restrict data entry to only use that editor, and not free-form typing in the cell.  You can prevent free-form typing in the cell by disabling the cell, but then the custom editor button is no longer available.

Suggestion is to still show custom editor button even if cell is disabled, perhaps with an additional setting; so that you could optionally not show the custom editor if the cell is disabled, since often a disabled cell should prevent any kind of modification.
Declined
Last Updated: 25 Feb 2020 15:28 by ADMIN
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
Declined
Last Updated: 25 Feb 2020 15:26 by ADMIN
I checked out the feature request provisions on your site. Since I'd like to include photos with my description, I'm hoping that it is okay that I send this to you for forwarding on to the appropriate audience.

My feature request involves the spreadsheet control in Kendo's JQuery controls

The request is for an attribute to be added to a cell of a spreadsheet which can be used by JQuery to associate the HTML dom element with the spreadsheet's javascript model. Here is why:


In needing to place things in the cells of spreadsheets (such as images and my own custom controls) as can be seen in my images 1 and 2, it is necessary to know which div.k-spreadsheet-cell corresponds with a kendo javascript spreadsheet cell. As a work around, I have given my custom controls an index number. In the kendo javascript object, I set the cell's background color to the same value as that index. This gave me two benefits: 1) it put a characteristic on the cell's div object that could identify the cell; 2) it rendered the cell even if it had no content--this is particularly important.

In my image 4, you can see the background color attribute of a cell div. In image 3, you can see my collection of custom controls. Each of my div.custom-control has a control_index property. I have a routine that runs periodically to reckon the location and size of each control whose background color is set to a value matching one of my cell's control indices. Once located, the controls are laid down onto their respective cells at their appropriate size (or made invisible if the target cell is scrolled off of the container).

This work around contains a lot of painful overhead. For instance, when a spreadsheet is first rendered, I have to traverse the div.k-spreadsheet-cell elements to check their background color attributes. If they qualify, a css class must be placed on the cell so that a black cell isn't presented in the time that it takes to reckon and position my custom controls.

If there were a 'tag' attribute that could be added to a cell's javascript model and that tag was ascribed to the div.k-spreadsheet-cell element (AND make the element render even if it is otherwise trivial), this operation would be a lot easier. I think that I'm not the only one who would like to take some control over the dom objects of the spreadsheet control. 

I would be happy to discuss this further with anybody who is interested.

Thanks,

Doug
Unplanned
Last Updated: 25 Feb 2020 15:19 by ADMIN
Created by: Imported User
Comments: 1
Category: Spreadsheet
Type: Feature Request
3
By default the items in filter are in random order. Can we sort the items in ascending order by default.
Unplanned
Last Updated: 25 Feb 2020 15:17 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.

 

Unplanned
Last Updated: 25 Feb 2020 15:17 by ADMIN
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.
Unplanned
Last Updated: 25 Feb 2020 15:10 by ADMIN
When using the bottom right corner of a cell to batch copy values across a range by dragging the corner, an error popup appears if a disabled cell is found inside the range that was dragged into.  It is possible to reproduce this with this demo:

https://demos.telerik.com/kendo-ui/spreadsheet/disabled-cells

1.  Set the quantity column to disabled.

2. Select B3.

3.  Drag the bottom right corner of B3 to D3.

4.  See error: "Destination range contains disabled cells."

There should be an option to allow that to copy into any enabled cells in that range and ignore the disabled ones.
Declined
Last Updated: 25 Feb 2020 15:07 by ADMIN
Created by: Otto Neff
Comments: 1
Category: Spreadsheet
Type: Feature Request
3
Completed
Last Updated: 25 Feb 2020 15:04 by ADMIN
Created by: Chris
Comments: 0
Category: Spreadsheet
Type: Feature Request
3
Additional functionality for:
-- Conditional Formatting -- coloring of cells, for example based upon a value and then be able to import from excel, and export back out.
-- Data Validation (dropdowns).  Also be able to import and export back out.
Declined
Last Updated: 25 Feb 2020 15:04 by ADMIN
Created by: Tom
Comments: 3
Category: Spreadsheet
Type: Feature Request
3
1. Save Excel workbook to folder on server (the Excel file can be re-purposed in many ways)
2. Better ways to send sheet data back to controller ... more JSON serialization options, csv, etc.
Unplanned
Last Updated: 25 Feb 2020 15:02 by ADMIN
Created by: Geoffrey
Comments: 0
Category: Spreadsheet
Type: Feature Request
3
add indent property to spreadsheet cells to closer match excel
Declined
Last Updated: 25 Feb 2020 15:00 by ADMIN
Created by: Ganesan
Comments: 1
Category: Spreadsheet
Type: Feature Request
3
Show/Hide Column & Row Header
Unplanned
Last Updated: 25 Feb 2020 14:54 by ADMIN
Created by: WT
Comments: 0
Category: Spreadsheet
Type: Feature Request
5
Currently only the global culture is used to parse dates. This behavior differs from Excel as I can enter 1/1/19 to parse to 1/1/2019.

I would like the widget to format using the chosen date culture (mm/dd/yyyy), but parse in an optional way, such as mm/dd/yy.
Declined
Last Updated: 25 Feb 2020 14:52 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
Unplanned
Last Updated: 25 Feb 2020 14:50 by ADMIN
Created by: Ganesan
Comments: 1
Category: Spreadsheet
Type: Feature Request
5
add a double line border single or multiple cell.
Declined
Last Updated: 25 Feb 2020 14:49 by ADMIN
Created by: Jeffrey
Comments: 1
Category: Spreadsheet
Type: Feature Request
5
Allow additional control over what a user can undo/redo, or a clearer way to control the undo/redo stack.  

Right now, users cannot undo more complex custom logic - i.e. a user deletes the content of a single cell which triggers code for us to clear the content of every cell in that row.  When a user then attempts a single undo via keyboard shortcut, it cannot undo this more complex chain of events.
Unplanned
Last Updated: 25 Feb 2020 14:43 by ADMIN
Created by: Jack
Comments: 0
Category: Spreadsheet
Type: Feature Request
6
Need a default cell format, in addition to rowHeight and columnWidth including:
- font size,
- font-family,
- font weight
- (see other toolbar options)

Default cell format would set the default values for all cells and toolbar options.
Completed
Last Updated: 25 Feb 2020 14:36 by ADMIN
Created by: Martin
Comments: 1
Category: Spreadsheet
Type: Feature Request
6
In Kendo UI spreadsheet when wrap cell text it currently split text in middle of word. Change so that splits on white space
Unplanned
Last Updated: 25 Feb 2020 14:35 by ADMIN
Created by: Ram
Comments: 0
Category: Spreadsheet
Type: Feature Request
7
Ability to dynamically bound the DropDown editor to an array of objects