LibO Calc - Copy Without Increment as Default?

Help with installation and general system troubleshooting questions concerning the office suite LibreOffice.
Post Reply
2CV67oo
Posts: 55
Joined: Sat Nov 27, 2010 11:12 pm
Location: Alsace

LibO Calc - Copy Without Increment as Default?

Post by 2CV67oo »

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...
LibreOffice4.4.2.2 on Ubuntu 15.04.1 & LibreOffice ??? on W8.1 & LibreOffice 3.3.4 on Win7
User avatar
kingfisher
Volunteer
Posts: 2127
Joined: Tue Nov 20, 2007 10:53 am

Re: LibO Calc - Copy Without Increment as Default?

Post by kingfisher »

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
2CV67oo
Posts: 55
Joined: Sat Nov 27, 2010 11:12 pm
Location: Alsace

Re: LibO Calc - Copy Without Increment as Default?

Post by 2CV67oo »

kingfisher wrote:I think you'll just have to get used to it.
I suspect so too, but I keep trying! :)
The reverse is not more intuitive, you are used to it, that's all.
For me it's more intuitive, because just dragging would just copy whereas adding the Ctrl key would increment the list.
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
Post Reply