First time here? Check out the FAQ!
asked 2012-04-14 12:21:06 +0200
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!
answered 2012-04-14 16:01:44 +0200Pedro
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.
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!
Asked: 2012-04-14 12:21:06 +0200
Seen: 394 times
Last updated: Apr 14 '12