https://bugs.freedesktop.org/show_bug.cgi?id=55964
Priority: medium
Bug ID: 55964
Assignee: [email protected]
Summary: When sorting with data used in formulas, copies data
rather than moves
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
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
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
