[Solved] Repeat command like f4 in Excel

Discuss the spreadsheet application
Post Reply
iratozer
Posts: 4
Joined: Fri May 30, 2008 7:39 pm

[Solved] Repeat command like f4 in Excel

Post by iratozer »

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.
User avatar
Villeroy
Volunteer
Posts: 31346
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Repeat command like f4 in Excel

Post by Villeroy »

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 with LibreOffice 6.0, latest OpenOffice and LibreOffice
iratozer
Posts: 4
Joined: Fri May 30, 2008 7:39 pm

Re: Repeat command like f4 in Excel

Post by iratozer »

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.
User avatar
Villeroy
Volunteer
Posts: 31346
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Repeat command like f4 in Excel

Post by Villeroy »

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 with LibreOffice 6.0, latest OpenOffice and LibreOffice
iratozer
Posts: 4
Joined: Fri May 30, 2008 7:39 pm

Re: Repeat command like f4 in Excel

Post by iratozer »

Very excellent, thank you very much for the help and have a wonderful life.
Post Reply