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.
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.
In the scpreadsheet you can use controls like dropdowns & datepicker , but should be helpful if user could to customize the design and behavior. For example, the dropdown and any other control needs be opened since an icon at right that is displayed over the next column, As user i would like to choose how i want to be displayed the control: Open clicking on it, set expand direction, styles, etc.
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.
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.
It should be possible to define cell types (or types that are valid for the entire column) like: - Booleans (which will result in showing check boxes inside the cells)
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.
Right now, a List based validation is strict on case, it'd be nice to have a toggle for when it is appropriate.
Currently if you access cells range programmatically, you can set background color, text color etc. It would be good to have the way to set classes or to get the DOM of the range. Another option would be to get DOM or set a class to individual cells (e.g. via range.forEachCell).
Presently in Spreadsheet tooltip is not working for filter applied range so tooltip should display for each cell in which the range of filter is applied
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.
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.
It would be useful if copy and paste the data have the option of fill the series or copy the value for the date format. Furthermore, copy from multiple column value and allow to paste multiple copied value from the spreadsheet will be added advantage. Thanks.
Currently if I set column border width large, it has multiple problems: 1. it will overlay on columns next to it; 2. when copy the cell with thick border and paste somewhere else, the thick border get copied as well; 3. when select cell with thick border, the border will block part of editor;