In a spreadsheet, to select only one cell (say A1), the user currently has to do the following: 1. Begin a drag on the cell of interest. 2. Continue the drag to an adjacent cell (say B1). 3. Continue the drag back to the cell of interest, deselecting B1. 4. Release the mouse button, leaving only A1 selected. A widely used commercial spreadsheet program allows the user to select A1 by just clicking the cell cursor (thick black rectangle), once the cell cursor has been placed on A1. Currently, clicking the cell cursor (except for the autofill handle) doesn't do anything in Calc. People who are used to the other spreadsheet program's way of selecting a single cell can be unaware for a long time that the above 4-step procedure is the LO equivalent. These users can easily assume that selecting just a single cell isn't possible in Calc. Please consider adding the described single-cell selection method. I'm using LibreOffice 4.1.4.2 on Ubuntu 13.04.
As I now recall, the UI of that other spreadsheet program is a little different than I remembered when I first submitted this feature request. The following may be easy enough for existing LO users and for users of that other spreadsheet software to get used to: A. When the cell is _not_ selected, drag from the cell contents (the area enclosed by the cell cursor) to select a range of cells. This is unchanged from current LO. B. When the cell _is_ selected, drag from the cell contents (the area enclosed by the cell cursor) to move the cell. This is unchanged from current LO. C. Single-click the cell cursor (except an autofill handle) to select the cell. This is the same feature I requested in comment 0. D. Drag from the cell cursor (except the autofill handles) to move the cell. This is a new feature to LO. I think this is what I was really thinking of when I first submitted this RFE. The 4-step procedure that I listed is really only the first 4 steps of a 5-step procedure, step 5 being the same as item B. That other spreadsheet program allows item D as a single step to replace LO's 5-step procedure.
You can click and then Shift+CLick or Cltr+click to select one cell... LibreOffice is not x-office. Maybe introducing the behaviour you suggest would have a lot of consequences for other editing/behaviour...
Changing severity to "enhancement" per standard convention.
asking for expert calc advice here to see if we'd ever implement this kind of change.
It is an old and valid enhancement request. There are surely a few duplicates of this one around.
(In reply to Markus Mohrhard from comment #5) > It is an old and valid enhancement request. There are surely a few > duplicates of this one around. I happened to find bug 45059, for example, in which I think the submitter wanted what I've requested here.
*** This bug has been marked as a duplicate of bug 38994 ***