asked 2012-04-14 12:21:06 +0200

Anonymous

For example :

I have a 5v x 2h block of cells that I want to merge in order to become a 5v x 1h block with a colour background and border.

Is there anyway I can automate this process?

At the moment I merge the cells manually, then select the section I want and format it with the relevant colour and border. It is very time consuming!

FYI it is for a booking schedule!

delete close flag offensive retag edit

1 Answer

Sort by » oldest newest most voted

answered 2012-04-14 16:01:44 +0200

Pedro

3218 ● 4 ● 23 ● 54

You can automate that by saving a macro and setting a hotkey to the macro. You need to enable macro recording in Tools, Options, LibreOffice, General, check the last box "Enable experimental (unstable) features". Then record the macro (Tools, Macro, Record Macro) by executing the actions that you want to repeat later and then click on Stop Recording.

When the macro is successfully created you can go to Tools, Customize, Keyboard and assign a hotkey to easily repeat the actions.

link delete flag offensive edit

Comments

Thanks for the answer, and this almost works but it doesn't help if the section I am trying to consolidate is 5v x 4h or any other amount of horizontal cells. I need to find a way that will make it merge all horizontal cells, no matter how many of them there are ...

TBBB ( 2012-04-15 11:42:57 +0200 )edit

That is another level of macros. That requires programming (not just repeating your recorded actions). For that you need to teach yourself macro programming or find some ready code on the internet (or find someone who can teach you or do it for you for free or for a fee).

Pedro ( 2012-04-15 12:12:32 +0200 )edit

Here is a good starting point (see Chapter 12) http://www.libreoffice.org/get-help/documentation/#cg

Pedro ( 2012-04-15 12:13:06 +0200 )edit

Resources

Donate

LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!

Question tools

Stats

Asked: 2012-04-14 12:21:06 +0200

Seen: 394 times

Last updated: Apr 14 '12

Automated merge and format CALC