[Solved] Repeat command like f4 in Excel

Discuss the spreadsheet application

[Solved] Repeat command like f4 in Excel

Postby iratozer » Fri May 30, 2008 7:44 pm

Welcome beginner. Please answer all of the questions below which may provide information necessary to answer your question.
-----------------------------------------------------------------------------------------------------------
Which version of OpenOffice.org are you using? 2.4
What Operating System (version) are you using? Windows XP SP2
What is your question or comment? Is there a repeat last command function in Calc, like the f4 key in Microsoft Excel?
Last edited by Hagar Delest on Tue Jun 10, 2008 2:26 pm, edited 2 times in total.
Reason: tagged the thread as Solved.
iratozer
 
Posts: 4
Joined: Fri May 30, 2008 7:39 pm

Re: Repeat command like f4 in Excel

Postby Villeroy » Fri May 30, 2008 7:44 pm

Shift+F4
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28551
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Repeat command like f4 in Excel

Postby iratozer » Fri May 30, 2008 8:11 pm

Greetings Villeroy, and thank you for the fast reply, and I just went and tried it, but id did not work. Maybe I should give further info.

In Excel, if I insert a row or column, I can then hit the f4 function key as many times as I need to and it inserts more rows or columns.
iratozer
 
Posts: 4
Joined: Fri May 30, 2008 7:39 pm

Re: Repeat command like f4 in Excel

Postby Villeroy » Fri May 30, 2008 8:18 pm

I remembered that F4 in Excel toggles between relative, mixed and absolute referencing. In Writer and Calc F4 calls the datasource window. Go to Tools>Customize... tab:Keyboard.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28551
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Repeat command like f4 in Excel

Postby iratozer » Fri May 30, 2008 8:48 pm

Very excellent, thank you very much for the help and have a wonderful life.
iratozer
 
Posts: 4
Joined: Fri May 30, 2008 7:39 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 22 guests