Apache OpenOffice (AOO) Bugzilla – Issue 19133
An easy way to drag only one cell
Last modified: 2013-08-07 15:15:02 UTC
This is very difficult to drag only one cell in the spreadsheet, as far as I understand, I have to click on the cell, simulate I'm marking more that one cell and return to one cell market w/out un-clinking. I believe that Excel approach is very well. Start dragging a cell when select and drag the cell border.
You are right, to get the black backgound for the cell you have to do several steps. Steps to reproduce the problem: First operation "Drag and Drop A1:A3" (what works fine) 0. open new spreadsheet document 1. Write "A1", "B1", "C1" into A1 ... C1 2. Mark A1:C1 by mouseclick to A1 and move mouse pointer to C1 with pushed left mouse button 3. let off left mouse button 4. click into A1 5. move mouse pointer with pushed left mouse button to A10 6. let off left mouse button expected: Texts "A1", "B1", "C1" now are in A10:C10 actual: as expected Second operation "Drag and Drop only A1 (what does not work fine) 11. Write "A1" to A1 12. Mark A1 by mouse click to A1 13. let off left mouse button 14. click into A1 15. move mouse pointer with pushed left mouse button to A10 16. let off left mouse button expected: Text "A1" now is in A10 actual: A1:A10 is marked Workaround: 12. Mouse click into A1. Mark A1:C1 with pushed mousebutton and move back mouse pointer to A1 with still pushed mouse button. Result: A1 is marked (shows black background) now steps 13 - 16 will have the expected Result for "drag and drop" That still is in 1.1RC3 German version WIN98SE: 645m15(Build8669) [CWS:ooo11rc3] so I change version. Tha actual behaviour really might not be optimum, but it is no real problem, so "P5". I think that's on all platforms. I am not sure whether it will be possible to find a better solution, because we must keep up the function "mark several cells" of step 16. Rainer
Hi, the easiest way to select a single cell is to place the cell cursor on the desired cell, hold the shift key and click on the cell. Assigned to Bettina for further investigation. Frank
My attention was brought to Issue 3875 which is a duplicate to this one. So closing this as double. Frank *** This issue has been marked as a duplicate of 3875 ***
closed double