I want to use formulas like MS Excel

Getting help Questions
1

Hi,
I am able to run the formula on single cell.
But I want to apply the same formula by dragging or double clicking on the cell for the entire column,
also I want to select coordinates by clicking on particular cell, like in MS Excel.

This is very critical for my project waiting for your reply.

2

Hi,
I am able to run the formula on single cell.
But I want to apply the same formula by dragging or double clicking on the cell for the entire column,
also I want to select coordinates by clicking on particular cell, like in MS Excel.

This is very critical for my project waiting for your reply.

3

Hi @kunal

this functionality is not yet applied as an out-of-the-box feature.

However, you can apply the same logic using our callbacks. If you are interested I can tell you more about the approach.

4

@aleksandra_budnik yes, Please share me the approach for high performance for the large datasets.

5

Creating a point-and-click functionality is planned for the II stage of the new formula plugin reported here https://github.com/handsontable/handsontable/issues/6466 and to achieve the same with the current solution you’d need to rewrite the cell editor logic. Cause by default when you click outside the editor it closes.