LibreOffice Calc - Macro to increase/decrease Cell Font Size

GaXve · December 1, 2019, 6:39am

In Excel, I found this Macro that allows you to Increase/Decrease cell Font Size of active cell (using Keyboard Shortcuts).

Is there a way to recreate something similar in LibreOffice?

https://www.extendoffice.com/documents/excel/4629-excel-shortcut-key-to-increase-font-size.html

Sub MakeBigger()
Selection.Font.Size = Selection.Font.Size + 1
End Sub
Sub MakeSmaller()
Selection.Font.Size = Selection.Font.Size - 1
End Sub

mikekaganski · December 1, 2019, 9:09am

There’s dedicated Increase function that increases font size by 2 pts (not 1) - you may bind it to any keyboard shortcut using Tools▸Customize; search for “Increase” typing it in the search box on Keyboard tab, and use the last of the three displayed “Increase” functions. Ditto for “Decrease” (but iiuc, it’s the second of the three “Decrease” functions. Confusing to have three identical names for three different functions, I know. tdf#129122).

GaXve · December 2, 2019, 2:19am

Wow! Thank you!!!
Quick question though, why is the increment 2 rather than 1?