Is OpenOffice.org 3.0 a suitable office application

[Sandroo]

Does open office application are best suitable for calculation and other support. My work is totally based calculation and other options. I had found the calc is the basic tool in it and best to use the same. How to start with that. In the spread in open office how to freeze header and add notes to a cell. How to rotate a table int that.

[JonathanD]

The OpenOffice.org 3.0 is a completely characteristic for office collection. The collection is designed to entirely fulfill the requirements of working in generally office surroundings. It consists of a record administration program called Base, a vector-based drawing surrounding called Draw, an arrangement of the program called Impress, a worksheet program called Calc, a scientific calculator called Math and a word notebook called Writer. Here are several of the finer aspects of Calc, Impress and Writer.

[Macarenas]

By evasion, worksheet applications or submissions exchange entries like 042 to 42. Leading zeros in statistics are used in several places, an easy illustration being serial numbers. To put in a number that begins with a zero, immediately type [‘] previous to the number. Entering ‘042 will exchange it to 042. The apostrophe does not demonstrate in the worksheet. This method cannot be used for assessable figures. To do this, choose the cells you wish to insert the numbers in, then go to Format then to the Cells and then to the Numbers. Under grouping, choose User-defined. In the Format code field, enter.

[ThoMas321]

To freeze headers at the same time as you are working with huge documents, choose the column to the right, or the row instantaneously below the row you wish to frozen, and verify the Window then the Freeze. To unfreeze the frozen area, do not verify Window and then Freeze. Choose a single cell with this alternative will freeze all rows above the cell, and all columns to the left of the cell. It is not probable to freeze two divide areas at the same time. To freeze headers at the same time as printing a document, you have to go to the Format then to the Print Ranges and to the Edit. Hit on the Rows to Repeat icon, then choose the rows with the cursor.

[ZeDaX]

To put in notes to particular cells, you have to choose the cell, then go to Insert and then to the Notes. A yellow field will come into view where you can type in your text. Pull the notes of the field to resize or change the position to the note. Each cell with a note will have a diminutive red square on the top right corner. The note will be able to be seen when the mouse hovers over this square. On the other hand, you can right-click on the cell and choose Insert Note in the menu. To edit the note, you have to go to the Insert and then to the Notes again. To demonstrate the note eternally at the same time as editing extra cells, right-click on the cell with the note and verify demonstrate note. The note will be able to be seen till you right-click and deselect Show Note. You have to twice click on the note in this view to edit it.

[Sam.D]

To revolve a table in such a manner that the rows are converted into the columns and the columns be converted into the rows, choose a series of data, go to Edit and then to the Copy then choose a single cell where you desire to past it. Then go to Edit after that to the Paste Special and check Transpose under alternatives, and then hit OK. If you choose a row or a column, the data gets pasted several times over in the rows and columns, so be certain to choose immediately one cell. Also, the data will get mechanically rotated the next time you utilize the Paste Special, so make sure that the Transpose alternative is unchecked.