How to set default font in LibreOffice Calc

LibreOffice Calc is an excellent open-source replacement for the popular spreadsheet program Microsoft Excel. One irritation for me is that the default font and font size it uses are not what I would like. To set your own font, font size and other text formatting as default it takes a few steps as described below.

  1. Open LibreOffice Calc. It opens with a new spreadsheet document.

  2. First, we set our font as default for this spreadsheet document: Go to Format -> Styles and Formatting. Right-click on Default and choose Modify. In the Font tab, set the font, font size and other formatting options that you would like to be the default. Click OK.

  3. We now save this format as a template: Go to File -> Templates -> Save As Template. Choose My Templates and click Save. Give your template a name.

  4. Finally, we make our template as the default template: Go to File -> Templates -> Manage. In the Spreadsheets tab, click on your template and click Set as default. We are done! 🙂

All new spreadsheets created by Libreoffice Calc will now have the default font set in this template. Note that this is the font that will also be used for comments in Calc.

Tried with: LibreOffice 4.2.8.2 and Ubuntu 14.04

How to use SkyDrive as Microsoft Office

SkyDrive offers a lot of online storage that can be synced with many devices. However, its killer feature is that you can create, edit and view Microsoft Office documents, right in the comfort of your browser.

SkyDrive will render almost any Word, Excel and Powerpoint file, no matter how complicated it is. Just upload it to SkyDrive and view it from there. If you use Outlook.com for webmail, you can view Word, Excel and Powerpoint attachments in SkyDrive.

In addition to viewers, SkyDrive also has Word, Excel and Powerpoint webapps. So, you can create and edit such files right in your browser. Of course, these webapps have only the basic features, since Microsoft does not want to kill its golden goose: Microsoft Office. However, these webapps are already on par or even better than Google Docs.

SkyDrive is a boon only for those who do not want to pay for Microsoft Office, but also for folks on Linux. With SkyDrive, Linux users can view, create and edit Office files better than what you did with LibreOffice.

So, in essence SkyDrive is a web-based Microsoft Office Lite. Enjoy it 🙂