https://bugs.freedesktop.org/show_bug.cgi?id=55964

          Priority: medium
            Bug ID: 55964
          Assignee: libreoffice-bugs@lists.freedesktop.org
           Summary: When sorting with data used in formulas, copies data
                    rather than moves
          Severity: normal
    Classification: Unclassified
                OS: Linux (All)
          Reporter: bugzi...@androidsnetwork.com
          Hardware: Other
            Status: UNCONFIRMED
           Version: 3.5.4 release
         Component: Chart
           Product: LibreOffice

Created attachment 68547
  --> https://bugs.freedesktop.org/attachment.cgi?id=68547&action=edit
Examples of Sorting data when refered to by other cells

When there are forulas relying on data from other source cells, and the source
cells are sorted, the formulas dont reflect the new location of the original
data. The only way to make it behave in a correct manner is to move the source
data. Defeating the sort option.
IE
room    201        201    1    ,49-52
name     RM_201                
ports     1,49-52                
interface     1                
name     RM_201                
room    202        202    2    ,49-52
name     RM_202                
ports     2,49-52                
interface     2                
name     RM_202                
room    203        203    3    ,49-52
name     HSIA_RM203                
ports     3,49-52                
interface     3                
name     HSIA_RM203                

Corectly sorted form:
room    201        201    1    ,49-52
name     RM_201        202    2    ,49-52
ports     1,49-52        203    3    ,49-52
interface     1                
name     RM_201                
room    202                
name     RM_202                
ports     2,49-52                
interface     2                
name     RM_202                
room    203                
name     RM_203                
ports     3,49-52                
interface     3                
name     RM_203

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to