2. Import attached Dummy.xlsx file
3. No data loaded
4. please check
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
Other spreadsheet applications (Excel and Google Sheets, to name two) offer the ability to insert individual cells into a sheet without inserting a whole row/column. Most importantly, this feature updates cell references in formulas, which is not something that can be done with copy and paste.
For example, in the following spreadsheet (screenshot from Excel), I've right-clicked cell A2 and chosen "Insert" on the context menu. There is also a button on the ribbon that opens the same "Insert" dialog.
I want to shift the cells down, so I click OK in the dialog. Note that the formulas update accordingly: the sum range expands to A1:A5, while the individual cell references remap.
Can this feature please be added to Kendo spreadsheet? Otherwise, our clients will have to continue manually re-writing formulas after they copy/cut and paste to achieve a similiar-looking (but functionally different) result.
The current client-side export functionality does not preserve the number of columns.
Load the following file in the Spreadsheet which contains columns up to "BA".
Export the file
Load the file again in the Spreadsheet and notice that the columns are displayed up to "AX" instead of "BA".
Client-side export does not preserve the number of columns greater than "AX".
Client-side export does not preserve the exact number of columns.
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.
Enable Cut/Copy cell values and can Paste it in mutiple selected values
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
2. Open Attached Test.xlsx file
3. Check the value of A2, it is different than Excel
Note: Cell format of A2 is set as below, if I select only $ format then it is working.
1. Open https://demos.telerik.com/kendo-ui/spreadsheet/index in IE 11
2. Start editing cells C3 to C12 and enter value 1234 in each cell as fast as possible
3. 1234 enter, 1234 enter , 1234 enter and so on without waiting for UI rendering completion as UI freezes for few seconds, and then all cells get updated in one go
4. below is the result, few cells are having wrong values
5. Its very serious issue
Note: Excel 365, Excel and GoogleSheet works fine in such cases
When a string, used as old_text for SUBSTITUTE(text, old_text, new_text, [instance_num]) function, is repeated more than once and the new_text is an empty string, one occurrence of the old_text remains not substituted.
=SUBSTITUTE(A1, "ab", "")
ab with another string, e.g.
cd, replaces all instances of
ab as expected.
113ab11 - when ab is repeated more than once in a row, one of its instances remains unchanged to an empty string
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.
I have observed that Conditional Formatting in Spreadhseet is not supported. Please add support for the same as it is very important feature of XLSX. during financial calculation this feature plays an important role. Here is the issue that needs a fix.
2. Check attached file CellColorFormula.xlsx, conditional formatting set for B2, C2, D2
3. Import attached file CellColorFormula.xlsx
4. Check Cells B2, C2, D2 and try to change values for A2, C2, D2
5. None of the conditional formatting is working