small UI quirk, picking reference in formula edit 'eats up' next operand,
formula "=B1+B2" in B3,
want to change to "=B1+A2*B2",
place cursor between '+' and 'B2',
mouse click on A2, 'B2' gone ... :-(
IMHO clicking the reference should insert it ( 'A2' ) and only! replace parts which are marked, as it happens when you type or paste the insertion.
similar but the other way around:
formula "=B1+B2" in B3,
want to change to "=A3*B2",
place cursor between '=' and 'B1',
mark 'B1+' with mouse or shift and cursor right,
mouse click on A3, 'B1' replaced but '+' kept,
IMHO clicking the reference should insert it ( 'A3' ) and replace the complete! marked part, as it happens when you type or paste the replacement.