To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=95757
User sweigel changed the following:
What |Old value |New value
================================================================================
Status|UNCONFIRMED |RESOLVED
--------------------------------------------------------------------------------
Resolution| |INVALID
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Sun Nov 2 19:30:42 +0000
2008 -------
The behaviour is absolutely correct!
A1 is a relative reference. For your use case you might want to use $A$1 as an
absolute reference.
Please look for references;absolute/ralative in the index of the program´s
online help. This is not a speciality of Calc but a common feature of
spreadsheets: http://en.wikipedia.org/wiki/Spreadsheet#Cell_reference
"A typical cell reference in "A1" style consists of one or two case-insensitive
letters to identify the column (if there are up to 256 columns: A-Z and AA-IV)
followed by a row number (e.g. in the range 1-65536). Either part can be
relative (it changes when the formula it is in is moved or copied), or absolute
(indicated with $ in front of the part concerned of the cell reference)."
Issue is invalid.
---------------------------------------------------------------------
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]
