| View previous topic :: View next topic |
| Author |
Message |
yuvalaviel
General User
Joined: 20 Jan 2004
Posts: 25
|
 Posted: Wed Sep 29, 2004 4:53 am Post subject: Editing a formula without using a mouse |
 |
|
Is it possible to edit a formula without using a mouse?
If I click on the formula, and choose Edit -> Object -> Edit, I can edit the formula, but if I just mark the formula Edit->Object is disabled.
Any macro that can do it? (What I want is to be able to put the cursor near a formula and type something that opens it for editing) |
|
| Back to top |
|
 |
gsarnold
General User
Joined: 15 Jul 2003
Posts: 6
|
| Posted: Wed Sep 29, 2004 5:09 am Post subject: Re: Editing a formula without using a mouse |
|
|
On Windows, you can hit the F2 key -- works just like Excel. Should work on Linux, too. Not sure if Mac has an F2 key.
Good luck!
| yuvalaviel wrote: | Is it possible to edit a formula without using a mouse?
If I click on the formula, and choose Edit -> Object -> Edit, I can edit the formula, but if I just mark the formula Edit->Object is disabled.
Any macro that can do it? (What I want is to be able to put the cursor near a formula and type something that opens it for editing) |
|
|
| Back to top |
|
|
RGB
Super User
Joined: 25 Nov 2003
Posts: 1743
Location: In Lombardy, near a glass of red Tuscany wine
|
| Posted: Wed Sep 29, 2004 5:17 am Post subject: |
|
|
gsarnold, yuvalaviel is talking about the equation editor, not about a spreadsheet formula.
Is an interesting question... and I have no answer  .
I can't find a way to do this with the keyboard: also the navigator needs the mouse! |
|
| Back to top |
|
|
gsarnold
General User
Joined: 15 Jul 2003
Posts: 6
|
| Posted: Wed Sep 29, 2004 9:30 am Post subject: |
|
|
Oh, crap, sorry - I didn't realize.
| RGB wrote: | gsarnold, yuvalaviel is talking about the equation editor, not about a spreadsheet formula.
Is an interesting question... and I have no answer .
I can't find a way to do this with the keyboard: also the navigator needs the mouse! |
|
|
| Back to top |
|
|
yuvalaviel
General User
Joined: 20 Jan 2004
Posts: 25
|
| Posted: Thu Sep 30, 2004 12:00 am Post subject: |
|
|
| Quote: | | yuvalaviel is talking about the equation editor, not about a spreadsheet formula. |
Yeap. Thats true.
Answer anyone? |
|
| Back to top |
|
|
RGB
Super User
Joined: 25 Nov 2003
Posts: 1743
Location: In Lombardy, near a glass of red Tuscany wine
|
| Posted: Fri Oct 01, 2004 1:25 am Post subject: |
|
|
Well, I found the answer myself, but it would wish that there was a better solution:
F5 to open the navigator.
TAB focuss the "cursor" in the list of objects.
down arrow until the "desired" object is found.
ENTER twice |
|
| Back to top |
|
|
yuvalaviel
General User
Joined: 20 Jan 2004
Posts: 25
|
| Posted: Thu Oct 07, 2004 4:34 am Post subject: |
|
|
Indeed it works, but what if you have tens of equations? The object list just give object number, which I have somehow to map to the televant equation. |
|
| Back to top |
|
|
RGB
Super User
Joined: 25 Nov 2003
Posts: 1743
Location: In Lombardy, near a glass of red Tuscany wine
|
| Posted: Thu Oct 07, 2004 4:46 am Post subject: |
|
|
| I agree with you. Maybe this is a good feature request... |
|
| Back to top |
|
|
RGB
Super User
Joined: 25 Nov 2003
Posts: 1743
Location: In Lombardy, near a glass of red Tuscany wine
|
|
| Back to top |
|
|
ftack
Moderator
Joined: 27 Jan 2003
Posts: 3102
Location: Belgium
|
| Posted: Thu Oct 07, 2004 5:28 am Post subject: |
|
|
If it can help: you can give OLE objects a meaningfull name so that it becomes easier to identify them in Navigator. With the Object selected, Shift+F10 (this is a keyboard thread, isn't it  ) Object and there you can supply a name. |
|
| Back to top |
|
|
RGB
Super User
Joined: 25 Nov 2003
Posts: 1743
Location: In Lombardy, near a glass of red Tuscany wine
|
| Posted: Thu Oct 07, 2004 5:36 am Post subject: |
|
|
| ftack wrote: | | If it can help: you can give OLE objects a meaningfull name so that it becomes easier to identify them in Navigator. With the Object selected, Shift+F10 (this is a keyboard thread, isn't it ) Object and there you can supply a name. |
But shift+F10 only works if you previously select the object with the mouse, otherwise, gives the wrong menu... |
|
| Back to top |
|
|
yuvalaviel
General User
Joined: 20 Jan 2004
Posts: 25
|
| Posted: Thu Oct 07, 2004 6:04 am Post subject: |
|
|
| Thanks RGB. You got my presious vote there. |
|
| Back to top |
|
|
yuvalaviel
General User
Joined: 20 Jan 2004
Posts: 25
|
| Posted: Wed Oct 20, 2004 3:33 am Post subject: |
|
|
For those who read this thread, there is a bogous solution, but it is good enough to mention:
Go one line above the line with the formula and use Shift+F5. It will choose the first formula in the next line. If you want to edit the other formulas in this line - you'll have to use mouse.
see bug report http://www.openoffice.org/issues/show_bug.cgi?id=35122
(True for OO-1.1.3) |
|
| Back to top |
|
|
RGB
Super User
Joined: 25 Nov 2003
Posts: 1743
Location: In Lombardy, near a glass of red Tuscany wine
|
| Posted: Wed Oct 20, 2004 8:11 am Post subject: |
|
|
| Good idea, yuvalaviel! Also, you can choose the other equations of the line selecting the first with shift+F5, and then using TAB |
|
| Back to top |
|
|
|
