At 17:23 06/06/2007 +0200, 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
o Create the required formula (=Sheet1.A1) in cell A1 of Sheet2.
o Select that cell and drag the fill handle across the top row of
the required eighteen columns.
o Edit I1 and P1 so that they refer to the required, other column.
o Click A1 and then Shift-click R1 to select the eighteen cells in
the first row of the required columns.
o Copy.
o Click the column header of column A and then Shift-click the
column header of column R to select the eighteen columns.
o Paste.
o Wait for Calc to paste the modified formulae into the cells.
o Wait a bit more.
o Keep waiting. (There is a lot of work to do.)
o Bingo!
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
