To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=110588
                 Issue #|110588
                 Summary|Sort fails to move cells (in other  columns) which con
                        |tain references to another file.
               Component|Spreadsheet
                 Version|OOo 3.2
                Platform|PC
                     URL|
              OS/Version|Windows 7
                  Status|UNCONFIRMED
       Status whiteboard|
                Keywords|
              Resolution|
              Issue type|DEFECT
                Priority|P3
            Subcomponent|editing
             Assigned to|spreadsheet
             Reported by|matt_uk





------- Additional comments from [email protected] Sat Apr  3 16:17:47 
+0000 2010 -------
Sorting by a chosen column (via Data|Sort) fails to move the cells in another
column if those cells reference another ODS file.  These cells are left in their
original positions.

Example

Enter data in columns.  One of the columns (eg column B) has cells with formulae
which reference cells in another ODS file on the same computer.

eg

='file:///C:/test/data.ods'#$Sheet1.A1

Select the data to be sorted.  Choose Data|Sort.  Choose to sort by a column
which contains just numbers (eg column A).  The columns in the selected area are
resequenced together as they should be, except that the cells of the column
containing the references to another file (colmun B) are left in their original
positions.

---------------------------------------------------------------------
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]

Reply via email to