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.
Open LibreOffice Calc. It opens with a new spreadsheet document.
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.
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.
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.
Choose File > Export as PDF. Choose General > Range > Selection. Click Export.
The PDF file produced by this method has a few problems. It includes sheet number at the top and sometimes the content is cropped off at the page margins. Moreover, this produces a PDF that is the size of a A4 page, no matter what is the size of your chart.
A better solution is to:
Click on the chart to select it.
Right-click and choose Copy.
Open LibreOffice Draw and paste there.
Export the selection to PDF, just like above. This PDF does not have the sheet number at the top and the content is not cropped off.
This PDF still is the size of a A4 page. To crop it down its content, use the PDFCrop tool.
LibreOffice Calc is the spreadsheet application in the LibreOffice suite. In LibreOffice Calc, if the cells of a spreadsheet hold the results of formulas, then those results cannot be copied and pasted to a different cell. This is because the formula is copied instead of the result.
To copy the results of the formulas instead of the formulas themselves, do this:
Copy the cells as usual.
Right-click at the cell where you want to paste the results and choose Paste Special.
In the Paste Special dialog, under the Selection section, uncheck all the different types of selection. Check only Numbers (assuming that the results are numbers). Choose OK.
The results of formulas should be pasted now instead of the formulas. This trick can also be used to do in-place replacement of cells with formulas with their results.