Hi Team,
I would like to request the Kendo UI Spreadsheet to include JSZip 3.x functionality for future releases.
Thank you!
It would be great if you would add accessabbility to the spreadsheet as it seems to be the last control without this feature.
Currently the focus gets trapped inside its grid and the user cannot leave the spreadsheet with the TAB key. At least this should be avoided. It would be also better if only the first cell would be focusable and you then could navigate with the arrow keys, as with thousands of cells it is not very comfortable to use the TAB key.
Currently, after export to excel and opening the exported file again in Spreadsheet, the row heights for rows with predefined height change. The above could be easily observed on the Index demo:
* initially, the height of the top row is set to 70px;
* export the Spreadsheet to Excel;
* after re-importing the above file, the height of the first row "Invoice #52" becomes 81px without any apparent reason.
type =IF( "a"="A" ; 1 ; 0 ) and =IF( EXACT("a";"A") ; 1 ; 0 ) into Kendo Spreadsheet and Google Spreadsheet and MS Excel. There is a special EXACT function (which is also available in Kendo) to enforce case-sensitivity. By default it should be off.
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.
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.
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.
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.
The current context menu lets you hide a row or column, but then you cannot show it again, so the user can lose data. At present there is no context menu option to unhide it and there is no element indicating the column/row was there in the first place. This should behave like in Excel.
I know that Kendo Spreadsheet works like most popular Spreadsheets (Excel and Google Spreadsheet) where, if you copy or drag and paste values from cells, you will copy also the styles, validations, etc from that cell to the new one (unless you select "paste values only" in a context menu or ctrl + shift + v). It would be awesome if we can set how this works by configuring a property in the Spreadsheet configuration, something like pasteValuesOnly: false/true or even more complex with an object where you can choose if paste values, validations, formulas, styles or whatever. Also you could attach this functionalities to a context menu (as Google Spreadsheet does) and be able to paste everything, values only, format only, formulas or data validation.
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.
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.
For KendoUI Spreadsheet, it should have the ability to add images or logo into the spreadsheet. This feature is already available in Handsontable component.
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.
can add float object container ? eg:charts
Enable Cut/Copy cell values and can Paste it in mutiple selected values
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.
E.g. italian culture uses ";" as parameter separator in formulae. Our client will adopt spreadsheet component on a global basis and users need to be able to e.g. copy/paste from excel to spreadsheet component using their culture