Spreadsheets are used for What-if calculations. Change one number in a spreadsheet and all the calculations in a large spreadsheet will re-calculate, will automatically change. With this wiki learn how to use OpenOffice Calc to learn your way around this powerful (and free) software. OpenOffice Calc is the spreadsheet part of the OpenOffice software package. Calc is similar to Microsoft Excel, with almost the same abilities.Calc is capable of opening and saving spreadsheets in Microsoft Excel's file format.
Official Apache OpenOffice download page. Join the OpenOffice revolution, the free office productivity suite with over 295 million trusted downloads. A beta version of OpenOffice.org 3.4 was released on 12 April 2011, including new SVG import, improved ODF 1.2 support, and spreadsheet functionality. 4 2 161 Before the final version of OpenOffice.org 3.4 could be released, Oracle cancelled its sponsorship of development 12 and fired the remaining Star Division development team.
OpenOffice Calc has an option with which you can freeze selected columns and rows so that they always remain visible, even if you have scrolled some way down or across the spreadsheet. As such, with the freeze option you can lock a number of rows and columns on the top or left of a spreadsheet.
![Formulas Formulas](https://www.macworld.co.uk/cmsdata/slideshow/3524091/OpenOffice_Calc.jpg)
If you have opened a large OpenOffice spreadsheet document, it might be handy to keep some of its rows and columns stationary. OpenOffice Calc has an option with which you can freeze selected columns and rows so that they always remain visible, even if you have scrolled some way down or across the spreadsheet. Onedrive mac os x 10.6. As such, with the freeze option you can lock a number of rows and columns on the top or left of a spreadsheet.
Open a OpenOffice spreadsheet, and then click on a column header to the right of where you want to freeze. Then you should click Window and the Freeze option from the menu. A dark line should appear on the spreadsheet, as in the shot below, which highlights where you placed the freeze. Now move the scroll bar to the right, and the frozen column remain stationary on the left of the spreadsheet.
To freeze spreadsheet rows, click on the header of the row (its number) directly below where you intend to freeze it. 2017 polaris ranger 900 service manual. Click on Window and the Freeze How to make lofi in fl studio. option to add a dark line that runs across the spreadsheet as below. All the rows above that line are frozen, and they will stay at the top of the spreadsheet when you scroll down the page.
Openoffice Spreadsheet Free
You can also freeze both rows and columns. Neutraface 2 font free mac. Click on a cell that is immediately below the row and just to the right of columns that you’re going to freeze. Select Window > Freeze and both a horizontal and vertical line will then appear on your spreadsheet as below. All the rows above and columns to the left of those lines remain in view as you scroll across the spreadsheet.
Openoffice Spreadsheet File
Having frozen the rows and columns, you can also unfreeze them. Astroneer free mac. Click Window > Freeze to remove the checkmark beside the option. That removes the horizontal/vertical freeze lines that were on the spreadsheet.
Openoffice Spreadsheet Download
You can also freeze rows and columns much the same with alternative spreadsheet packages such as Excel. This is a handy option for keeping row and column labels visible in spreadsheets.