Linux - SoftwareThis forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
I'm really missing the Excel shortcut combo Ctrl-D in Calc, which copies the content from the cell immediately above your active cell. The only way to do it in Calc seems to be to select the cell above with your mouse and fill down, or do the multiple key presses of going up one cell, Ctrl-C, move down, Ctrl-V. Or again, using the mouse.
Looking on the internet it seems people have asked about this many times before, but I could not find a resolution. Someone even went so far as to write a little macro installer to emulate the function (see http://www.8daysaweek.co.uk/downloads.htm#CopyDown) but alas the download given does not work. Instead of downloading an .sxc file, it downloads a zip file, and there are no instructions anywhere on getting the files contained in the zip file to work.
I've noticed that my version of Calc runs some VBA. I'm reckoning I could emulate this copying-down behaviour with the VBA macro:
ActiveCell.Value = ActiveCell.Offset(-1, 0).Value
... and that should work, once I've assigned it to the Ctrl-D key combination. Must I resort to VBA, or might there be a simpler way?
You have not seen the kind of ctrl-D action you want because ctrl-D is already defined in OpenOffice.org Calc to mean filling a select range of cells with the value (or sequence of values) based on the value of the top cell of the selected range.
However, Calc provides the tools (literally Tools - Customize menu) to define the action you want, using another key combination and a macro. So, I'd suggest that you record a Calc macro, name it, and assign a key combination to it.
I repeat: ctrl-D is already assigned to fill down in the manner described above. If you redefine ctrl-D to work the way you want it to, you will break fill down (Calc version), unless you define a key combination that works as ctrl-D does now.
OK, thanks for the advice. I was aware that Ctrl-D was already taken up with another function, but since I automatically do Ctrl-D to copy down the cell above (habit!), I don't think I'll be using the Fill Down function it was originally programmed with.
I also agree with "jlinkels" about OOBasic being hard to write in. I have, in the past, recorded a very brief and basic macro, then looked at the macro code to see what it looked like. "Complex" is one word to describe it! Talk about code overhead!
Thanks. I only have OpenOffice 2.3 (I'm waiting for Ubuntu to put 3·0 in their distro), but I fear even the Fill Down command (when done from the menus) does not perform exactly as Excel's. You need to select the cell above and the blank one for it to work - even if it was on a keyboard shortcut.
My macro (in my previous posting) doesn't work, but only because Calc comes back saying "The object variable is not set". Can I tweak my one-line macro above so it will make the cell I am in identical to the one above it? That's all I want. It's programmed in Excel VBA, but OpenOffice 2.3/Calc is now compatible with this, so it shouldn't be a problem.
Yes... Although I am currently running Ubuntu's "Gutsy Gibbon" release, I think I will keep my installation and skip "Intrepid Ibex". Hopefully by the next release in April 2009, Ubuntu will include OoO 3.0 by default.