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 -- Registerd Linux user #445917 at http://counter.li.org/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
