search

ironcalc / IronCalc

Main engine of the IronCalc ecosystem
Apache License 2.0
2.05k stars 47 forks source link

Fix: Can't reference a cell when editing an existing formula #101

Open dg-ac opened 1 month ago

dg-ac commented 1 month ago

To reproduce, follow these steps:

  1. Add a formula that references other cells (for example, =SUM(A1,A2)) and press Enter
  2. Edit that same formula and delete A2
  3. Try to replace A2 by clicking on A3
  4. Currently this opens the cell A3, instead of adding it as a reference to =SUM(A1,)

Also, see below a screen recording with the issue:

https://github.com/user-attachments/assets/a7aa8c2b-2bab-4429-9ae8-90f7bd159eef

nhatcher commented 1 month ago

Yup, this is a known issue. You can only do that at the end of the formula

dg-ac commented 1 month ago

Should we keep this issue open then?

nhatcher commented 1 month ago

Should we keep this issue open then?

Yes.

By the way, GitHub closes automatically some issues, feel free to reopen them if they are not properly done