Last Updated: 03 Sep 2019 10:08 by ADMIN
Created on: 27 Aug 2019 15:47
Category: Spreadsheet
Type: Feature Request
Updating formula by clicking

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!

1 comment
Ivan Danchev
Posted on: 03 Sep 2019 10:08

Hello Holly,

Thank you for submitting this feature request and describing the use case in such detail. We will monitor the community's interest in it and consider implementing it in a subsequent release.

Ivan Danchev
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.