Relative addressing of sheets
In
Calc it is possible to have relative addressing of sheets. As with
column and cell references, the dollar sign is used to signify that
the sheet name is absolute.
=$Sheet2!$A$1
always refers to the first cell on sheet 2.
=Sheet2!$A$1
when on sheet one and copied to another sheet will refer to the first
cell of the next sheet.
This
is not possible in Excel.
