Are you looking for the DDE function?

----- Original Message ----- From: "David Hoehns" <david.hoe...@att.net>
To: <users@openoffice.org>
Sent: Tuesday, June 22, 2010 4:22 PM
Subject: Re: [users] Edit directly in cell


If you just want to reflect one cell in another cell, put the cursor in the cell where you want the info to showup. Then click the = in the function bar (it is immediately right of the Sigma) Then click the cell you want to "mimic" Hit return.

--------------------------------------------------
From: "John Kaufmann" <kaufm...@nb.net>
Sent: Monday, June 21, 2010 2:49 PM
To: <users@openoffice.org>
Subject: Re: [users] Edit directly in cell

In a message dated 2010.06.20 13:23 -0500, Elaheh Hashemi wrote:

Hi, i´ve just migrated from using ms excell to OO 3.1 and 3.2 (new version) calc.

one function that i have looked extensively but without sucess is to turn of the "edit directly in cell" (as it is called in excell) where we the result (in excell) is that a cell contains a link to another cell, in the same or any other worksheet or even a diferent file, it automatically jumps to that cell, if the link is a diferent file it opens it.
... is this possible in OO?

Not quite sure if this is what you are asking, but...
One of the OpenOffice quirks that you just have to learn is the large number of settings that are buried under Tools|Options. In this case, Tools|Options, then "OpenOffice.Org Calc", "General" and untick "Press Enter to switch to edit mode". Does that give the behavior you are looking for?

John

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Reply via email to