worng results in dragging elements in formulas

To comment on the following update, log in, then open the
issue:
http://www.openoffice.org/issues/show_bug.cgi?id=82928

                 Issue #|82928
                 Summary|worng results in dragging elements
in formulas
               Component|Spreadsheet
                 VersionOo 2.3
                Platform|PC
                     URL|
              OS/Version|Windows XP
                  Status|UNCONFIRMED
       Status whiteboard|
                Keywords|
              Resolution|
              Issue type|DEFECT
                Priority|P3
            Subcomponent|ui
             Assigned to|spreadsheet
             Reported by|scagni





------- Additional comments from scagniopenoffice.org Wed Oct 24 12:30:08 +0000 2007
-------
Create and compute any simple formula with fixed references
to some cells, for
example:  =SUM($B$1+$A$3+$B$5)
Now double click on it so that it opens and all the cells it
is referring to are
outlined with different colors.
If you drag any of the outlined cells, the reference in the
formula is moved
accordingly. 
This should work also for fixed (i.e. with a preceding
dollar sign, like the one
above) references, since this is a manual dragging, and
fixed references should
not change automatically but it should be possible for the
user to voluntarily
do so.
However if in the formula above you try to, say, drag the
reference $B$1 to the
cell below, you don't get $B$2, but instead $B$2:B2, which
is inconsistent with
reference notations for formulas, and in many cases causes
errors or unwanted
results.

------------------------------------------------------------
---------
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-unsubscribesc.openoffice.org
For additional commands, e-mail: issues-helpsc.openoffice.org

To comment on the following update, log in, then open the
issue:
http://www.openoffice.org/issues/show_bug.cgi?id=82928



User fst changed the following:

                What    ld value 
               |New value
============================================================
====================
                  Status|UNCONFIRMED              
|RESOLVED
------------------------------------------------------------
--------------------
              Resolution|                         
|DUPLICATE
------------------------------------------------------------
--------------------




------- Additional comments from fstopenoffice.org Wed Oct 24
12:34:32 +0000 2007 -------
double to Issue 73766

*** This issue has been marked as a duplicate of 73766 ***

------------------------------------------------------------
---------
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-unsubscribesc.openoffice.org
For additional commands, e-mail: issues-helpsc.openoffice.org

To comment on the following update, log in, then open the
issue:
http://www.openoffice.org/issues/show_bug.cgi?id=82928



User fst changed the following:

                What    ld value 
               |New value
============================================================
====================
                  Status|RESOLVED                  |CLOSED
------------------------------------------------------------
--------------------




------- Additional comments from fstopenoffice.org Wed Oct 24
12:34:52 +0000 2007 -------
closed double

------------------------------------------------------------
---------
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-unsubscribesc.openoffice.org
For additional commands, e-mail: issues-helpsc.openoffice.org