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.3 votes
The Excel file downloaded from Spreadsheet does not maintain leading spaces. In other words, the internal sharedString.xml should use <t xml:space="preserve"> when necessary.1 vote
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...1 vote
I want to know the combination keys that generate the paste event
I use data binding data source for spreadsheet
But when I use it, data auto input begins at row 0
I want to insert 2 row (To Write title)3 votes
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.2 votes
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.
Ability to dynamically bound the DropDown editor to an array of objects7 votes
It would be nice to have text orientation support (at least vertical) like in MS Office.1 vote
Expose a property on the range object of the spreadsheet component which shows whether a range is currently hidden or shown
Expose a property on the range object of the spreadsheet component which shows whether a range is currently hidden or shown3 votes
When typing a formula and selecting another cell in Excel we can press F2 to be able to change the formula manually, however when using the spreadsheet when trying to change the formula with the arrow left or right button we select another cell.3 votes
In MS Excel when you type a number you can easily go to other cells by using the arrow keys and type in another number, thus allowing for fast editing of the spreadsheet. This does not work in the spreadsheet component.
this functionality only needs to work when not creating a formula.4 votes
add indent property to spreadsheet cells to closer match excel6 votes
I have a first example using the Kendo Toolbar widget and I was able to get an Angular button rendered in the toolbar:
When I tried to do the same thing in the Kendo Spreadsheet widget toolbar, it failed to compile my template:
In general Angular directives are not compiled properly when specified in the template of a Spreadsheet Toolbar item. I am aware of a workaround for the kendo-button specific case, but I would like the template to work for custom Angular directives as well.4 votes
add search functionality to the Spreadsheet.28 votes
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.9 votes
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:
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.4 votes
Allowing custom editors to be inline would be very helpful. In particular, inline editors using other Kendo controls (e.g. masked textbox, numeric textbox) should be possible.6 votes
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.4 votes
Currently the spreadsheet dynamically creates the FilterMenu for a range, that is, it's not created until someone clicks the filter dropdown, and it's destroyed if they switched tabs.
There is no event that is fired when these things happen, which makes it hard to attach to, and customize, the FilterMenu without setting up some crazy listening code (setTimeout, etc.).
It would be great if either (or both:
- You could specify a template for the filter menu.
- You could listen for a "FilterMenu Initialized" event and capture the menu there and customize it.1 vote
- Don't see your idea?