https://issues.apache.org/ooo/show_bug.cgi?id=123970
Bug ID: 123970
Issue Type: DEFECT
Summary: cells with logics are changed when sorted
Product: Calc
Version: 4.0.1
Hardware: PC
OS: Windows 7
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: ui
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
I have a Calc-sheet with about 45000 rows. With the logic operation (an
example) IF(H108>H107;I107/J107;0) i reduce the interesting rows to 360, all
others will be 0.
When I then try to sort the column with "ascending" I get a total confusing
answer. Rows change data and the rows are not ascending. I can understand if
the sorting would give me an answer beginning with 0 and then with increasing
values but I get zeros spread in the sheet. Values are also changed and this
can of course be if the logic operation mentioned above is changed since the
order of the rows is different, but I haven't any fixed operators in the rows
that are sorted.
I can send you the Calc-file if interesting, about 3MB. I have no possibility
to test if this would work in MS-Excel.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
