Ask Your Question

Record a macro

asked 2019-06-18 11:29:10 +0200

Wooflibre gravatar image

In Calc
What and where is the command to record a macro Where is the command to stop RECORDING a macro

In Excel, when you are at the top of a column of data, and you wish to get to the bottom of it, the command is END DOWN

What is the equivalent command for END DOWN on CALC?

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted

answered 2019-06-18 11:55:00 +0200

updated 2019-06-18 13:02:18 +0200

Record Macro Option: From Menu: Tools -> Macros -> Record Macros.

Once you click, a small window would appear which would have button to STOP recording.

After you stop recording, a dialog box would open to save the macro.

To show the community your question has been answered, click the ✓ next to the correct answer, and "upvote" by clicking on the ^ arrow of any helpful answers. These are the mechanisms for communicating the quality of the Q&A on this site. Thanks!

edit flag offensive delete link more

answered 2019-06-18 12:08:15 +0200

Lupp gravatar image

Recording macros is an optional feature and is only available if enabled under
Tools>Options>LibreOffice>Advanced>Optional Features.
Coming from MS Office you may feel lost. Recording is heavily restricted, and recorded macros look basically diferent fro macros you would write on your own line by line. In addition LibreOffice Basic actually is just "another Basic" containing very few additional predefined names (with specic functionality then, of course). Any nontrivial macro having to handle objects for the document will need to use the uno-API, while VBA glues all that into the language.

The LibO macro recorder on the other hand uses a few 1000 predefined routines NOT implemented in Basic, and sparsely (at best) documented. Avoid recording generally, or rework recorded code to better fit into your macros.

What you call "END DOWN" may be what LIbO Calc does if you press Ctrl+DownArrow. You can record the command. Using the API it's a bit more complicated

edit flag offensive delete link more

answered 2019-06-18 12:08:34 +0200

robleyd gravatar image

updated 2019-06-18 12:13:05 +0200

What is the equivalent command for END > DOWN on CALC

Ctr+Arrow will take you to the cell with data prior to the next blank cell in the direction of the arrow. Ctrl+Home will take you to A1. Ctrl+End will take you to the last row/column whre there is data or formulae.

See also Keyboard Shortcuts for Spreadsheets

If this answer helped you, please accept it by clicking the check mark ✔ to the left and, karma permitting, upvote it. If this resolves your problem, close the question, that will help other people with the same question.

edit flag offensive delete link more


I would not recommend to close questions for being solved in this askbot site. Better reasons for closing are "outdated" and (probably) "irrelevant". Much more important with helping other users is it to "accept" a good and complete answer or to upvote(unbiased) or downvote(without resentments) answers and questions.

Lupp gravatar imageLupp ( 2019-06-18 12:15:31 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-06-18 11:29:10 +0200

Seen: 4,172 times

Last updated: Jun 18 '19