When a cell/row is selected, its first cell is focused and the sheet is scrolled to show it. If a long sheet is scrolled down/right to edit cells, this scroll top/left is very annoying and user unfriendly.
In these scenarios Excel focuses the topmost/leftmost currently visible cell, avoiding sheet scrolling.
NOTE: for rows reproduction select cell AX2, then click on the header of row 2 - sheet is scrolled to the left and cell A2 is focused.
Column C is selected, cell C1 is focused and the sheet is scrolled to top.
The used has to scroll down to the bottom row again to edit data at the bottom of the sheet.
Column C is selected. The currently visible topmost cell of column C is focused, without scrolling the sheet. Excel works that way
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.
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.
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.
Client-side exported Excel workbooks are exported "uncompressed" (as readable text) and their size is much greater than the original document.
Regression since R2 2019 - 2019.2.514
The performance in the latest official version is significantly worse compared to older versions (2017.1.117 and 2018.1.118 tested).
The UI freezes and remains unresponsive for minutes.
The new font size is applied without significant delay.
Currently the API is very much limited to what is possible in the frontend in my opinion. It would be great if you could add events like: - A cell/range was selected - A cell was cut/pasted/copied - The context menu was initialized - A row/column was added - A row was added/deleted/hidden - A cell's content was modified ... ...
When pasting data from Excel, the data is being pasted as an image instead of values