Suppose each column label is  alphabetic and each row label is in numeral order in a Cal sheet. And you want to freeze the 1st row and the 1st column.

1) select the cell B2

2) Window --> Freeze

https://sites.google.com/site/projectcodebank/Do-It-Yourself/freezing-rows-and-columns-in-open-office-libre-office