https://bugs.freedesktop.org/show_bug.cgi?id=85479
Bug ID: 85479
Summary: EDITING; error in referencing cells in formulas when
sorting source data
Product: LibreOffice
Version: 4.3.1.2 release
Hardware: x86 (IA32)
OS: All
Status: UNCONFIRMED
Severity: blocker
Priority: medium
Component: Spreadsheet
Assignee: [email protected]
Reporter: [email protected]
Created attachment 108443
--> https://bugs.freedesktop.org/attachment.cgi?id=108443&action=edit
simple table to show the issue
Let's say we have a simple two-column table. The first contains a list of
unsorted numbers; the second, in each cell, a formula that adds the contents of
the cell above the second column with the contents of the adjacent cell of the
first column (of course using relative references), thus showing the gradual
increase of the values. If we select the contents of the first column and
order it (without extending to the second column), the cell references in the
first column moving as if they were absolute rather than relative, so the
results of the formulas are incorrect. I am attaching a simple table to show
the problem.
The issue is present in Linux and Windows both x86
--
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
