Calc Guide

Figure 136: Linking sheets: pasting a formula to
a cell range
6) Click Yes. You have now copied the formulas into each cell while
maintaining the format you set up in the original worksheet. Of
course, in this example you would have to tidy the worksheet up
by removing the zeros in the non-formatted rows.
Figure 137: Linking Sheets: Copy Paste Special from K7...N17
Note
OOo default is to paste all the attributes of the original cell(s) -
formats, notes, objects, text strings and numbers.
The Function Wizard can also be used to accomplish the linking. Use of
this Wizard is described in detail in the section on Functions.
196 OpenOffice.org 3.x Calc Guide