To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=82133
User regina changed the following:
What |Old value |New value
================================================================================
CC|'' |'regina'
--------------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
--------------------------------------------------------------------------------
Keywords| |oooqa
--------------------------------------------------------------------------------
Resolution| |WORKSFORME
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Mon Oct 1 16:52:19 +0000
2007 -------
You know, that the references in a formula are relative to the address, where
you use the formula, unless you set a $ to make it absolute. What happens now?
If you move your mouse down to select b3:b13 the active cell will be b13. If you
now use the formula $f3>=$f$13 it is relative to b13. When OOo enters the
formula to the cell b12, that part in the formula, which is still relative will
be changed. Cell b12 gets the formula $f2>=$f$13 and so on. Cell b11 gets
formula $f1>=$f$13 and b10 gets formula $f0>=$f$13. But a row 0 doesn't exist
and you get the #REF! error.
When you enter the formula you must write it in that way, that it fits to the
active cell.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
