OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Can't toggle relative/absolute references

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
jrlloyd
General User
General User


Joined: 22 Jan 2007
Posts: 14

PostPosted: Tue Aug 04, 2009 6:05 am    Post subject: Can't toggle relative/absolute references Reply with quote

Every time I try to use Shift+F4 to toggle references in a formula, all that happens is that a new sheet opens.
I've looked in Tools, customise, keyboard & Shift +F4 is listed as "Relative/Absolute References" so now I'm feeling lost any help please? (I find the customize keyboard feature particularly impenetrable)
_________________
JohnL
Back to top
View user's profile Send private message
keme
Moderator
Moderator


Joined: 30 Aug 2004
Posts: 2910
Location: Egersund, Norway

PostPosted: Wed Aug 05, 2009 4:40 pm    Post subject: Reply with quote

If you're on an Apple laptop, you probably need to hold the Fn key down too. I don't have the mac at hand, so I can't test it right now, but there may also be some mixup with shift, option (alt) and command keys. Try out different combinations and see if you have any luck.

Edit: Just tried, and Fn+Shift+F4 works on my MacBook.


Last edited by keme on Thu Aug 06, 2009 4:04 am; edited 1 time in total
Back to top
View user's profile Send private message
jrlloyd
General User
General User


Joined: 22 Jan 2007
Posts: 14

PostPosted: Thu Aug 06, 2009 2:22 am    Post subject: Reply with quote

Sorry - should have specified its Windows XP Sp3 & OO 3.1
_________________
JohnL
Back to top
View user's profile Send private message
keme
Moderator
Moderator


Joined: 30 Aug 2004
Posts: 2910
Location: Egersund, Norway

PostPosted: Thu Aug 06, 2009 4:11 am    Post subject: Reply with quote

jrlloyd wrote:
Sorry - should have specified its Windows XP Sp3 & OO 3.1
Then I'm sorry for making the wrong assumption. I thought I'd seen you stating you used a Mac previously, and jumped to the wrong conclusion.

Another thought: The hotkey can only modify one reference at a time. If the selected cell has more than one cell/range reference, you must be in edit mode for it to work (press function key F2 to get there) and the text cursor must be at/within the reference you want to alter.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group