Don Braun wrote:
Doing the following sure makes me miss Lotus 1-2-3. I wanted to change a simple addition formula that summed the quantities in two cells into their summed value. I right-clicked the cell and hit Ctrl C. Then again I right clicked the (same) cell and rolled down to "Paste special" and left-clicked it. The formula was changed into its value. In the 1-2-3 days one picked the cell or cells, hit the slash key and then the keys r and v in that sequence and one had the values instead of the formulas. Trackballing and mousing are slower than the second coming.
Everything on the menus can be accessed by the keyboard, either by navigating the menus using Alt + the underlined characters (e.g. Alt+E for the Edit menu, then S for Paste Special) or more direct shortcuts (e.g. Ctrl+Shift+V, as shown on the menu next to Paste Special).
Once in the Paste Special dialog, you can use Alt + the underlined characters to select / deselect options. So Alt+P deselects "Paste all", then Alt+N select "Numbers" and Alt+F deselects "Formulae".
From what I recall, this is similar to navigating the menus in the text-based versions of 1-2-3 - Alt is equivalent to "/" to access the menu, then single-letter options to select menus and items. Having done that, in LibreOffice you get a dialog with a more options so granted it's not quite as quick, but that's the downside of having more flexibility.
The shortcut keys can be configured to suit your preferences at Tools > Customise > Keyboard.
Mark. -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
