Last Updated: 01 Aug 2019 08:34 by ADMIN
Created on: 25 Jul 2019 15:00
Category: Spreadsheet
Type: Feature Request
Insert cells into spreadsheet (shift cells down/shift cells right)

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.



1 comment
Posted on: 01 Aug 2019 08:34
Hello David,

You could add a custom button to the Spreadsheet Cell Context Menu that could utilize the insertRow()/insertColumn() methods to shift cells down. The difference is, that this will shift all row cells. With this approach, the cell formulas will be updated. Here is a simple Dojo example that demonstrates the approach:

In terms of shifting the cells only - this is currently not possible with the current implementation. I believe that this feature request is valid and that the Spreadsheet will benefit from such a functionality. Therefore, the request is marked as "Approved".

Progress Telerik
Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.