I want to achieve something like this:
Start typing a formula in a cell by entering "=",
the cell can then accept relative arrow key references to other cells and cell ranges, including with Control/CMD and SHIFT + arrow keys.
As an example, in cell A1, I type "=", then if I press RIGHTARROW, the cell A1 should now display "=A2". That A2 box should be highlighted.
Now if I press SHIFT+RIGHTARROW, it should be "=A2:A3". The A2:A3 range should be highlighted just like in Excel.
I did similar to this check jsfiddle
In my code if click at cell where entered "=" it updated by its coords. And reference cell value also not showing. If I use 'formulas: true' instead of 'useFormula:true' then it showing error.