Ask Your Question
0

Is it possible to shut off "auto-cell reference" in Calc?

asked 2019-06-29 00:37:32 +0200

Rich Lang gravatar image

When in edit mode, and editing a formula, if I click to another cell (unconsciously expecting to exit edit mode--because that's what happens if I'm editing a cell containing text or a number), Calc automatically adds a cell reference into the formula (screwing up my formula).

Is it possible to shut off this feature? And, if so, how?

I admit, some may like this feature. But I don't. I know how to type the correct syntax for a cell reference and I don't need this officious program feature doing different things depending upon whatever different type of cell content then exists in the cell I'm then editing.

(Calc 6.2.4.2 on Window 7)

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
1

answered 2019-07-04 17:10:30 +0200

Rich Lang gravatar image

Given that the answer to my above question is apparently "No", I've settled on the following workaround to this Calc feature (which I find to be obnoxious, given its results):

At Tools > Options > Calc > General, select "Press Enter to switch to edit mode". Then one trains themselves to be in the habit of always entering edit mode by pressing Enter, and always exiting edit mode by pressing Enter (before one clicks to another cell).

There are other ways to enter and exit edit mode, but, to me, the above seems the most straightforward and easiest to remember (and learn to do habitually).

Note that one probably does not want to also have checked "Press Enter to move selection", given the manner in which these two options interact.

I also note that, while Excel also has a "click to other cell to insert cell reference" feature, Excel's implementation of this feature is a bit more sophisticated than that of Calc. In Excel, when editing a formula, the cell reference is only inserted if, in fact, given the then location of the insertion point, it then makes syntactical sense to enter a cell reference at that location in the formula. Otherwise, clicking into another cell automatically selects that cell and turns off edit mode (and does not affect the previously edited formula). (Which is probably why, over the years, after editing a formula to my satisfaction, I've been able to develop the habit of simply clicking to another cell and simultaneously (a) exiting edit mode, and (b) selecting the other cell.)

Given Calc's operational functionality, I need to re-train my habitual way of doing things.

edit flag offensive delete link more
0

answered 2019-06-29 08:49:37 +0200

pierre-yves samyn gravatar image

Hi

AFAIK there is no option for that unfortunately...

As a workaround I think the Function Wizard should limit the "risks" of clicking out:

image description

Regards

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-06-29 00:37:32 +0200

Seen: 34 times

Last updated: Jul 04