Description: 1. enter text in a cell 2. try to drag (and thus cut/paste) the cell to another cell location bug: with dozens of attempts it's possible, but the area where the mouse must be hovered is far too small for easy use excel behavior: when you hover the mouse, the cursor icon changes indicating that a move operation is possible calc behavior: the cursor icon never changes, whether or not you've positioned the mouse such that a copy/drag operation is possible general: this is a systemic UI problem - Calc forces the uses into trial and error mode in many formatting/cell border/cell background scenarios Steps to Reproduce: 1. enter text in a cell 2. try to drag (and thus cut/paste) the cell to another cell location Actual Results: bug: with dozens of attempts it's possible, but the area where the mouse must be hovered is far too small for easy use calc behavior: the cursor icon never changes, whether or not you've positioned the mouse such that a copy/drag operation is possible general: this is a systemic UI problem - Calc forces the uses into trial and error mode in many formatting/cell border/cell background scenarios Expected Results: Calc should behave like Excel but be smarter, less buggy and more elegantly designed. Excel is a UI nightmare. Calc is better in some areas; worse in others. It's very disappointing Reproducible: Always User Profile Reset: N/A Additional Info: User-Agent: Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.81 Safari/537.36
Do you know how to select only one cell? https://help.libreoffice.org/Calc/Selecting_Multiple_Cells#Mark_a_single_cell Selected area is showed with a transparent blue. Draggin it the icon changes for me.
(In reply to m.a.riosv from comment #1) > Do you know how to select only one cell? > https://help.libreoffice.org/Calc/Selecting_Multiple_Cells#Mark_a_single_cell > > Selected area is showed with a transparent blue. > Draggin it the icon changes for me. Thanks - that worked. Any tips on the border/background behavior report I submitted the same day?
Also, is 5.3 safe to use (in terms of data loss)? I was reading a lot of comments about formatting auto-changing when saving and reopening a document and I'm afraid of losing work on this massive spreadsheet.
I work with calc 5.3 on daily basis, and even having some crash I never lost my data. You can activate the backup option on Menu/Tools/Options/LibreOffice/Load and Save - Always create a backup copy https://help.libreoffice.org/index.php?title=Common/General_7&Language=en-US&System=WIN&Version=5.4#bm_id3151380 Please remember one bug report one issue.
Thanks! You've helped me greatly.