Brent Opsahl wrote:
I have been trying to figure out how to lock a formula to one cell. it is the
function you use in excle that goes like this $C5* A6, and then when you fill
the formula down it stays on C5 when you go to A7 and so on for as long as you
want to go. and in OpenOffice calc i can't seem to get this to work.
As others have noted, OpenOffice.org's Calc works identically to Excel
in this regard--the $ locks the entry. So I'm going to assume you might
be asking a slightly different question. Is it possible your issue is
that you are building a formula by the "point" method (you point at
cells using the arrow keys) rather than just entering "=$C5*A6" directly
into the cell and are really asking for the keystroke to cycle through
the fixed reference options (what you do by pressing F4 in Excel, which
borrowed that keystroke from 123)?
If so--the keystroke is <Shift>-<F4> rather than plain <F4> in Calc
though you can reassign it if you wish. The plain <F4> brings up the
data sources window in all of the modules of OpenOffice.org.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
