I asked this question several years ago for OOCalc, with no success.
Trying again for LibO Calc...
If I copy cells by dragging, then the contents increment.
If I don't want the increment, I need to hold down 'Ctrl'.
Is there any way I can switch these behaviours, so simple dragging gives un-incremented copy & drag with Ctrl gives an increment?
I would find that altogether more intuitive & make less mistakes.
Excell always had that option...
I did a lot of searching, so I suspect the answer is 'no' but I think it is worth asking, just in case...
LibO Calc - Copy Without Increment as Default?
LibO Calc - Copy Without Increment as Default?
LibreOffice4.4.2.2 on Ubuntu 15.04.1 & LibreOffice ??? on W8.1 & LibreOffice 3.3.4 on Win7
- kingfisher
- Volunteer
- Posts: 2127
- Joined: Tue Nov 20, 2007 10:53 am
Re: LibO Calc - Copy Without Increment as Default?
The only approximation I can think of is to apply a key binding to fill down. That would require you to select the range first so would be a regressive change. I think you'll just have to get used to it. The reverse is not more intuitive, you are used to it, that's all.
Apache OpenOffice 4.1.12 on Linux
Re: LibO Calc - Copy Without Increment as Default?
I suspect so too, but I keep trying!kingfisher wrote:I think you'll just have to get used to it.
For me it's more intuitive, because just dragging would just copy whereas adding the Ctrl key would increment the list.The reverse is not more intuitive, you are used to it, that's all.
Ctrl is often used to add things:
- If I drag & drop an object without Ctrl - it just moves it, whereas if I drag & drop with Ctrl - it adds another object.
- If I click on several objects without Ctrl - I end up with just the last one, whereas if I click on several with Ctrl - I get them all.
Anyway, it is certainly not a big deal.
I just wondered if there was some setting I could change which I had not found yet, even with Google...
Thanks!
LibreOffice4.4.2.2 on Ubuntu 15.04.1 & LibreOffice ??? on W8.1 & LibreOffice 3.3.4 on Win7