OpenOffice works on both Linux and Windows. On Ubuntu, OpenOffice is
the default office suite. On Windows, instead of spending money on
Microsoft Office, download and use Openoffice.
OpenOffice Calc offers pretty much most of the functionalities that are in Microsoft Excel. The following is the list of some Openoffice calc spreadsheet tips and tricks.
Select the table in the spreadsheet, and click on Menu -> Format -> Autoformat.
You can also combine multiple conditions using OR/AND conditions. To use this, click on Menu -> Format -> Conditional Formatting.
OpenOffice Calc offers pretty much most of the functionalities that are in Microsoft Excel. The following is the list of some Openoffice calc spreadsheet tips and tricks.
1. Autoformat Tables
Instead of manually formatting your tables with different font colors and background, you can use one of the builtin table autoformat as shown below.Select the table in the spreadsheet, and click on Menu -> Format -> Autoformat.
2. Conditional Formatting
Using conditional formatting, you can format a specific cell or row only based on a certain condition. For example, if the cell value is “Technology”, you can set a custom background, and font to the cell or row.You can also combine multiple conditions using OR/AND conditions. To use this, click on Menu -> Format -> Conditional Formatting.
