Currently, the Spreadsheet component doesn't have the functionality to create a formula using the keyboard arrows.
For example:1. Open: https://demos.telerik.com/kendo-ui/spreadsheet/index
Does the kendo spreadsheet support conditional formatting / data bars (which are the background bar charts on a cell)...
See example below - and attached simple xlsx (in zip)
which in excel you add like
If not currently supported as standard, any suggested workarounds?
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.
The filtering on the spreadsheet component is great!!
There is however one behaviour that causes confusion for end users, and that is filtering when merged cells are present in the selection.
An example is available in the following dojo:
Open the dojo and filter column A on a1 and you will only see only b1 in column B, but the b1a will not be shown.
To be clear - This is also how Excel behaves... (which is of course your prime aim so its not a bug as such)...
Interestingly google sheets stops you putting filter on merged cells / stops you merging on filtered column.
The Excel behavior is discussed in the following threads:
Is it possible to implement something, so the end user experience would be improved? Maybe when merged cells are present :
a) if they click filter, this is detect and user is warned of this behaviour
b) if they click filter, the sheet is changed into an unmerged version (which repeats data in merged cells) as in the excel examples above.
We have a client that recently brought to our attention the fact that he found a case where he couldn't place his cursor in a certain spot of a formula, click a cell, and have it fill that cell in. It works if you try to do that for the first cell listed in the formula, but not the rest. I've outlined a sample case below.
You can enter a formula in a cell like =IF(A2+B2, 1, -(A2+B2), 2). Then, highlight a cell, like A2 below, and delete it by hitting backspace or delete.
After hitting delete, leave the cursor in the same location of the formula and click a new cell, like A4.
For this case, since it's the first cell in the formula, it will insert the cell you just clicked on in the correct location. However, next try highlighting the next cell referenced, hitting delete, and clicking on a new cell to have it insert the cell into the formula. In this case, we highlighted and deleted B2, then tried to click on B4.
You'll see that, for this one, instead of inserting B4, it gives an error message. Our client said that it significantly slows him down when he has to manually type in each change to the formula, so is there any way we could have it insert the cell you click on for all cases? It doesn't look like this is a current feature, so would you be able to add it, please? Thank you!
2. Import attached Dummy.xlsx file
3. No data loaded
4. please check
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 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.
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