Formula Editing with Cell Selection in Edit Mode

[omerix]

Hello Paramvir Teams,


This formula functionality is extremely useful for data entry tasks as it saves time and avoids the need for external tools like calculators. It simplifies tasks directly within the grid by allowing quick computations.

I want to achieve Excel-like behavior in the ParamQuery grid during cell editing. Specifically:

I start formula input by typing = in a cell, which puts the cell in edit mode.

*) While still in edit mode, I want to click another cell in the grid and have its reference automatically added to the formula in the editing cell (e.g., =D4).

*) Currently, clicking another cell exits the edit mode. I would like to prevent this behavior so that the cell remains in edit mode, and the clicked cell's reference is inserted into the formula.

*) Is it possible to implement such behavior in ParamQuery? If yes, could you please share an example configuration or code to achieve this?


For example, I attempted to calculate the weight by typing = in the "Freight" column
https://paramquery.com/pro/demos/freeze_columns

Thanks

[paramvir]

Currently the cell or a range reference has to be entered in a formula manually.

Your suggestion to fetch the reference automatically upon click on a cell / range is great and would be considered for addition in upcoming versions.

Thanks