When I enter a formula into a cell and come back later (after a save?) Calc updates the formula to include the name of the sheet I was in, which makes reading the formula difficult.
For example Calc changes:
=(C7 * 0.3)+(D7 * 0.6)+(E7 * 1.5)+(F7 * 6.45)+(G7 * 9.2)+(H7 * 7.2)+(I7 * 9.2)
into:
=(‘Decom 2’.C7 * 0.3)+(‘Decom 2’.D7 * 0.6)+(‘Decom 2’.E7 * 1.5)+(‘Decom 2’.F7 * 6.45)+(‘Decom 2’.G7 * 9.2)+(‘Decom 2’.H7 * 7.2)+(‘Decom 2’.I7 * 9.2)
where “Decom 2” is the name of the sheet.
I rarely link to cells on another sheet, so this just makes it hard to read and edit the formula.
How can I stop this behaviour?