[EMAIL PROTECTED] wrote:
Just want to say I love Open Office!
I've been using your spreadsheet and would really like to see a button or
shortcut key for switching between viewing the formulas or actual values in the
spread sheet.
It is just too inconvenient and time consuming to go to . . .
Tools/options/openoffice.org calc/Calculate and then check or uncheck the 'Formulas' box (under the heading 'Display') to switch between seeing formulas or values.
Just a personal preference to have a button or shortcut key to do this, I think
it would be a commonly used option if made available and would save a lot of
people a lot of time.
Thanks for you amazing software!
I agree with you. A similar situation exists for other settings made in
the Tools >Options >Dialogue. It is unlikely to achieve anything
writing to this list, though. The procedure is to file an issue.
In the meantime (and it will be a long meantime), this macro will do
what you want. To install it
1. Tools >Macros >Organise Macros >OpenOffice.org Basic : you get a
dialogue.
2. In the left box, under "My Macros", find "Standard" and expand it.
Select a Module (you probably only have Module 1). Click "Edit" : you
get the module.
3. Navigate to the end (Ctrl+End). Click ENTER twice. Paste in the
macro. Save. Close the editor.
4. Use Tools >Customise to assign the macro to a menu command, toolbar
icon or keyboard shortcut.
(NOTE: ThisComponent ... NOT ...ShowFormulas is all one line)
Sub ShowFormulas
If ThisComponent.SupportsService(
"com.sun.star.sheet.SpreadsheetDocument" ) Then
ThisComponent.CurrentController.ShowFormulas = NOT
ThisComponent.CurrentController.ShowFormulas
End If
End Sub
--
Xfce on PCLinuxOS, OOo 2.0.2 (en_GB).
Direct mail to teaman is not opened; if necessary, email realmail.
If you're seeking, check out http://www.rci.org.au
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
