Hi,
it depends where your cursor is.
Enter =SUM(A1:A10) into a cell.
Click outside the cell, then click the cell. Press Shift+F4 repeatedly
to change through $A1:$A10 and so on.
Now in the formula bar, click the A1 part of the formula. Now Shift+F4
cycles only the A1 through $A1, A$1 and so on.
If you position the cursor within the formula at let's say the SUM part,
nothing happens with Shift+F4.
HTH
Uwe
Donald R. Fredkin wrote:
On 24 May 2006, you wrote in gmane.comp.openoffice.general:
this feature works like a charm. Place your cell cursor to a cell
containing a formula containing a cell reference like =SUM(A1:A10) and
press Shift+F4. Perhaps the window manager on your system uses this key
combination for itself...
Thanks, but I am still having no luck. I am running Win2K, so I don't have
much control over the window manager. Under "Customize" Shift+F4 is shown
as being assigned to "Relative/Absolute References" from the "Insert"
category.
I think I remember selecting a reference in Excel (in the formula bar) and
using Shift+F4.
Do you have any more words of wisdom?
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
[EMAIL PROTECTED] - Technical Writer
StarOffice - Sun Microsystems, Inc. - Hamburg, Germany
http://www.sun.com/staroffice
http://documentation.openoffice.org/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
