![print selection fit libre office print selection fit libre office](https://i1.wp.com/www.alphr.com/wp-content/uploads/2012/03/image37.png)
Text Formatting: Some times, when you enter a number like 00123 in a cell (if you want a five digit number), it automatically becomes 123 due to the default formatting.If they are not frozen, it may not be possible to determine (beyond a certain columns) which row (name and company) the data in the columns belongs to, for example. For example, if you have two columns as name and company, these two can be frozen on the left hand side of the screen while moving/ viewing the data on the other columns. Freeze: If a spread sheet contains a lot of columns, certain columns can be frozen on the screen while the remaining columns move freely.(Tools –> Options –> Libre Office Calc –> General) However, if you need to keep moving right frequently, you can set the function of the enter key to move to the immediate right side cell, each time the Enter key is pressed. By default, when the Enter key is pressed, the cell below the current working cell is selected. Change the function of the Enter Key: Its possible to change the function of the enter key.
![print selection fit libre office print selection fit libre office](https://www.fudzilla.com/media/k2/items/cache/0c818b1e797432892159565b770bf927_L.jpg)
These are just examples, and there are many more pre-programmed functions in each category. The pre-programmed functions include mathematical formulas like Average(N1,N2…), geometric functions like ACOS(val), ACOT(val), conversion functions like BIN2DEC(Number), etc that convert binary, hexadecimal, octal, decimal numbers in to any of the four, DEGREES(val) to convert radians in to degrees, financial transaction functions like IPMT(Rate, Period, NPER, PV, FV, Type) to calculate the compound interest value for a set of input variables, character functions like LOWER(text) that convert lower case text to upper case text, date and time functions like NETWORKDAYS(start date, end date, holidays) to return the number of working days between two dates excluding the holidays, NOW() to return the current time value as per the computer. This contains a lot of pre-programmed formulas to calculate the result of specific functions. Functions: The function parameter f(x) can be found just before the formula input line in Libre Office Calc.Most of the features might also be available with Open Office and MS Office equivalent applications. In this article, we look at nine important features that you might not have known previously, but could prove very useful while using a spread sheet application. Libre Office Calc is the application for making spreadsheets. Libre Office is a set of freely available open source based office productivity application.