To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=105479
User regina changed the following:
What |Old value |New value
================================================================================
CC|'' |'regina'
--------------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
--------------------------------------------------------------------------------
Keywords| |oooqa
--------------------------------------------------------------------------------
Resolution| |WORKSFORME
--------------------------------------------------------------------------------
------- Additional comments from reg...@openoffice.org Wed Sep 30 13:29:51
+0000 2009 -------
I consider the behavior to be correct. Adapting references when moving is the
most wanted behavior. If you cut a cell and then paste it, then it is the same
as moving and the default type 'Calc8' is used. If you want to ignore the
references, you can paste it as "unformatted text".
You get no warning, because the cell in which you enter it, is empty.
You can avoid the problem, if you use =SUM($B$2:B2), =SUM($B$2:B3),
=SUM($B$2:B4),... in your 'Total' column. That would allow sorting in addition.
---------------------------------------------------------------------
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: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
