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.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Introduction to Linux - A Hands on Guide
This guide was created as an overview of the Linux Operating System, geared toward new users as an exploration tour and getting started guide, with exercises at the end of each chapter.
For more advanced trainees it can be a desktop reference, and a collection of the base knowledge needed to proceed with system and network administration. This book contains many real life examples derived from the author's experience as a Linux system and network administrator, trainer and consultant. They hope these examples will help you to get a better understanding of the Linux system and that you feel encouraged to try out things on your own.
Click Here to receive this Complete Guide absolutely free.
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.