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

Fixed cell : equivalent to F4 in Excel

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


Joined: 28 Jan 2006
Posts: 2
Location: Belgium

PostPosted: Sat Jan 28, 2006 12:25 pm    Post subject: Fixed cell : equivalent to F4 in Excel Reply with quote

What is the fixed cell notation in OOo calc.
I am looking for the equivalent of F4 in Excel to get for instance cell $F$30.
Thanks
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Sat Jan 28, 2006 1:04 pm    Post subject: Reply with quote

Shift+F4
Back to top
View user's profile Send private message
Warrick Nelson
OOo Advocate
OOo Advocate


Joined: 04 May 2004
Posts: 203
Location: Christchurch, New Zealand

PostPosted: Sat Jan 28, 2006 1:06 pm    Post subject: Reply with quote

I'm not sure whether the function keys do different things in different versions of Excel, I have Excel 97 and F4 can be used to repeat the last action.

$F$30 gives an absolute reference in both spreadsheets.
Back to top
View user's profile Send private message Visit poster's website
bobharvey
Super User
Super User


Joined: 23 Apr 2004
Posts: 1075
Location: Lincolnshire

PostPosted: Sat Jan 28, 2006 2:52 pm    Post subject: Re: Fixed cell : equivalent to F4 in Excel Reply with quote

blauweulm wrote:
I am looking for the equivalent of F4 in Excel

Have you looked in the HELP? On the opening page is "Shortcut Keys for Spreadsheets" There is a long article called "absolute references in spreadsheets"
Back to top
View user's profile Send private message
blauweulm
Newbie
Newbie


Joined: 28 Jan 2006
Posts: 2
Location: Belgium

PostPosted: Sat Jan 28, 2006 10:40 pm    Post subject: Reply with quote

Thanks. Shift F4 does the job. The shortcut list is very usefull. (I searched in OOo Help in the "index" and "find" on "fixed ..." but could not find anything. )
Back to top
View user's profile Send private message
RickRandom
Super User
Super User


Joined: 27 Jan 2006
Posts: 1082
Location: UK

PostPosted: Sun Jan 29, 2006 12:38 am    Post subject: Reply with quote

I guess you would need to search on "absolute" as that is the nerdy spredsheet term for fixed, but my Help in OOo 2.0 doesn't work so I can't check!

Does anyone know the shortcut for Repeat? I have put a button on the Toolbar, but I am used to F4 for repeat from Excel (also Ctrl-Y in Excel, but in OOo Ctrl-Y seems to be Undo?).
Back to top
View user's profile Send private message
bobharvey
Super User
Super User


Joined: 23 Apr 2004
Posts: 1075
Location: Lincolnshire

PostPosted: Sun Jan 29, 2006 4:31 am    Post subject: Reply with quote

RickRandom wrote:
I guess you would need to search on "absolute" as that is the nerdy spredsheet term for fixed,
...and has been for 25 years...
Quote:
but my Help in OOo 2.0 doesn't work so I can't check!
I really don't know why they havn't rushed out a fix for that. It is very bad form in my opinion.

http://www.oooforum.org/forum/viewtopic.phtml?t=30888
is very helpful (!)
Back to top
View user's profile Send private message
8daysaweek.co.uk
Super User
Super User


Joined: 29 Nov 2003
Posts: 2130
Location: UK

PostPosted: Sun Jan 29, 2006 6:49 am    Post subject: Reply with quote

RickRandom wrote:
in OOo Ctrl-Y seems to be Undo?).

Ctrl + Z = undo Ctrl + Y = redo, in OOo and other programs on my computer.

BFN Smile,
_________________
James
www.8daysaweek.co.uk - A User-Focused OOo site
Back to top
View user's profile Send private message Visit poster's website AIM Address
RickRandom
Super User
Super User


Joined: 27 Jan 2006
Posts: 1082
Location: UK

PostPosted: Sun Jan 29, 2006 6:55 am    Post subject: Reply with quote

I would admit to being a spreadsheet nerd, but "absolute" isn't always obvious to the casual user, so I take a guess (perhaps a bad guess sometimes) at how much people know and phrase suggestions accordingly.

I found the fix for the lack of Help (via 8days a week - good for them) but I agree it is bad form that you have to find it and install it.

http://www.8daysaweek.co.uk/forums/viewtopic.php?t=311

If you have to have these errors, and we are all relying here on I guess a relatively small number of volunteers rather than the mass hordes of Microsoft staff, it would be at least constructive if there was a patch or service pack to fix it in one ot two clicks, and with it on the OOo website in a reasonably obvious place. If you get it wrong, "fess up".
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