issues
search
lightsheet-team
/
lightsheet
GNU Lesser General Public License v3.0
1
stars
1
forks
source link
Formula reference symbol updating
#121
Closed
Fluglow
closed
3 months ago
Fluglow
commented
3 months ago
Closes #112
Update cell reference symbols in formulas when a referenced cell is moved
For example,
=A1
->
=B1
when a column is inserted at position 0
Also implemented for range operations: if column B is moved to D,
=A1:B1
->
=A1:D1
Only performed when doing column/row operations, but implemented so that the logic can be used for moving a single cell (#68)
Closes #112
=A1
->=B1
when a column is inserted at position 0=A1:B1
->=A1:D1