Bug 84511 - EDITING: Sorting corrupts cell references in COUNTIF formula (ZÄHLENWENN)
Summary: EDITING: Sorting corrupts cell references in COUNTIF formula (ZÄHLENWENN)
Status: RESOLVED DUPLICATE of bug 79441
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: Other All
: medium normal
Assignee: Not Assigned
Whiteboard: BSA
Depends on:
Reported: 2014-09-30 14:14 UTC by Martin Vogel
Modified: 2014-10-09 19:22 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Sheet with two tables which show the situation before and after the sorting attempt (29.28 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-09-30 14:14 UTC, Martin Vogel

Note You need to log in before you can comment on or make changes to this bug.
Description Martin Vogel 2014-09-30 14:14:59 UTC
Created attachment 107129 [details]
Sheet with two tables which show the situation before and after the sorting attempt

Problem description: 

Steps to reproduce:
1. Create a table where one column (e.g. A) counts values of other cells in the same line by using something like =COUNTIF(B2:D2;"x") in cell A2.
2. Sort the table by this column.

Current behavior:
The table is corrupted, does not even look sorted, and some (not all) cell references refer to wrong lines.

Expected behavior:
The table is nicely sorted, and all cell references still refer to the same lines as the formulas.
Operating System: Ubuntu
Version: release
Comment 1 Martin Vogel 2014-09-30 19:46:49 UTC
In LibreOffice Calc this error does not exist.
Comment 2 ign_christian 2014-10-01 01:37:48 UTC
Hi Martin, new behavior of internal sorting changed since 4.3.1 and 4.2.7

Please take a look at Bug 81633 and all related bugs. Perhaps you're reporting a duplicate?
Comment 3 raal 2014-10-02 09:17:48 UTC
Tested with version, Win7 - sorting is correct. Please test with newer version. Thank you.
Comment 4 A (Andy) 2014-10-03 06:45:24 UTC
I can also confirm: not reproducible with LO, Win 8.1, German
Comment 5 ign_christian 2014-10-03 07:42:16 UTC
Confirm wrong behavior (as displayed on attached file) with LO portable - Win7 x86

Confirm correct behavior with LO, portable

@Martin, please upgrade to
Comment 6 Martin Vogel 2014-10-06 09:14:28 UTC
Confirmed: Bug no longer exists in Version (Linux 64 bits).
Comment 7 Jean-Baptiste Faure 2014-10-09 19:22:30 UTC
In fact this bug is a duplicate of bug 79441.

Best regards. JBF

*** This bug has been marked as a duplicate of bug 79441 ***