Spreadsheet: How to fix Row/Column Titles

I don't use OO very much, because I am a ardent SmartSuite [especially 
1-2-3] user.  I'm sure there must be a simple way to fix a group of 
rows/colums as 'titles' so that they do not scroll when the data is 
moved up/down and left/right.

I would have expected to find it in the 'View' menu list.  But, if it is 
there, it is not obvious.  In 1-2-3 it is very easy.  How can this be 
done with the OO spreadsheet?
-- 
TIA

On 02/12/08 04:57 pm, Heiko Nitzsche wrote:
>> I don't use OO very much, because I am a ardent SmartSuite [especially

>> 1-2-3] user.  I'm sure there must be a simple way to fix a group of 
>> rows/colums as 'titles' so that they do not scroll when the data is 
>> moved up/down and left/right.
>>
>> I would have expected to find it in the 'View' menu list.  But, if it 
>> is there, it is not obvious.  In 1-2-3 it is very easy.  How can this 
>> be done with the OO spreadsheet?
> 
> Click the upper left cell of the area you want to stick as header,
> then select from Window menu Lock or Fix (don't know how it is called
> in English OO as I only have the German version installed).
Thanks, Heiko!

It took a bit of experimenting, but I did get it to work.

I had to place the cursor in the upper left cell of the area that I 
wanted to scroll, not the header rows.  i.e., It had to be in the cell 
immediately below the lower left cell of the header rows.

And, the English menu item is "Freeze".  The key to your advice is
that 
'Freeze' was in the 'Window' menu.  I would not have expected it to be 
there.  'View' would have been much more logical, IMHO.

Thanks, again!

> I don't use OO very much, because I am a ardent SmartSuite [especially 
> 1-2-3] user.  I'm sure there must be a simple way to fix a group of 
> rows/colums as 'titles' so that they do not scroll when the data is 
> moved up/down and left/right.
> 
> I would have expected to find it in the 'View' menu list.  But, if it is 
> there, it is not obvious.  In 1-2-3 it is very easy.  How can this be 
> done with the OO spreadsheet?

Click the upper left cell of the area you want to stick as header,
then select from Window menu Lock or Fix (don't know how it is called