Openoffice help

[blue-eye-boy]

I'm busy with a spreadsheet in openoffice calc. Now I want to know 2 things:

1. The colum headers is now a,b,c etc. I did name the colums, but the moment I scroll down the sheet, the colum names are gone. Isn't it possible to name the colums, so no matter where I scroll down to, the colum names is visible?

2. The, the sheet I'm making, will be done on a monthly basis. I put in values each day, at the end of the month I total the sheet, and print a "statement". But inside the sheet, I used formulas for each day's entry. Now January is finished now, but I want to save and print it, and start with February. But the same formulas will be used for each day. How can I copy, or maybe "preserve" the formulas? If I can copy it, I just save the current sheet to January, and "paste" the formulas into a new sheet for february. Or if I can preserve the formulas, I save the current sheet as January, and "save as" the shet then as february, and delete the data (but then the formulas must stay).

Any ideas?

 

[Skywalker42]

1.
If you have long rows or columns of data that extend beyond the viewable area of the spreadsheet, you can freeze them, which allows you to see the columns or rows as you scroll through the rest of the data.

1. Select the row below, or the column to the right of the row or column that you want to be in the frozen region. All rows above, or all columns to the left of the selection are frozen.
To freeze both horizontally and vertically, select the cell that is below the row and to the right of the column that you want to freeze.
2. Choose Window - Freeze.
To deactivate, choose Window - Freeze again.


2.
Right click on the Sheet tab at the bottom
select Move/Copy Sheet
Select the position
Check the [x] Copy box
Rename the name sheet to FEB

The formulas are preserved.


2.

 

[wishblade]

From what I understand of what you are trying to do:

1. Here you are trying to freeze a number of rows.
I think there are a number of ways of achieving this. The quickest that I know of is this: hover you mouse just above the vertical scroll bar (on the right side of the OpenOffice window). There is a splitter that can then be dragged down into place, effectively creating a visual splitter in the sheet.
That doesn't always look to good, so there is another way to do the same thing. Simply select the row in which the column headers are, and then slect the menu option Window > Freeze. That will freeze the current selected row. Note that it only freezes a single row, so won't help if the coloumn headers are in 2 or more rows.

2. To copy just formula's and formatting from one sheet to another, select the area to copy (or the entire sheet if necessary), change to the sheet that you want to copy to, and then use the menu option Edit > Paste Special.
Now in the paste special dialog window, deselect the 'Text', 'Values', etc options, leaving the 'Formulas' and 'Formats' (for example to copy the cell formattings as well).
When the data is pasted, the entered values are removed, but the existing formulas stay...

Hope that helps a bit

 

[wishblade]

I see SkyWalker beat me to the answer.