Hi Jonathan,
Highlight the area, with the first row containing the formulae. Use
'edit / fill down' to populate the rest of the highlighted area. If you
have non contiguous sections to fill, go to the last cell (f5 B25000)
and press ctrl+shift+up to highlight all of the rows in that column.
Shift+left or right will extend the selection to neighbouring columns.
tc
Jonathan Kaye wrote:
Hi all,
I'm doing some work for a Namibian languages (Nama and Khoe) dictionary and
database project. I'm using openoffice calc to hold the records. My problem
is that I need 2 sheets: one that my users will actually enter the
information onto and a 2nd sheet, identical to the first except columns "i"
and "p" are reversed. This has to do with whether we are creating a
printable Nama-English or English-Nama dictionary.
This is easily done by having sheet2 contain the codes sheet1.a1,
sheet2.a2 ...sheet1.a25000, for column a of sheet2,
sheet1.b2 ...sheet2.b25000 and so on for 18 columns. By problem is that the
only way I have found to increment the formulae is by grabbing the little
square of the highlighted cell (which already has the formula) and dragging
it down 25000 cells or so. Doing this for 18 columns will be a bit of a
chore as you can imagine. Highlighting an entire area does not capture the
formulae.
My objective is to have the user enter data only once and have sheet2
generated automatically.
I tried doing linked formulae like $sheet1.$a$1, etc. but those only get
inserted into cells that are non-empty.
Any suggestions would be gratefully accepted.
Thanks in advance,
Jonathan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
