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)
Version:
(earliest affected)
4.3.1.2 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
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:

Attachments
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 		Details
View All Add an attachment (proposed patch, testcase, etc.)

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: 4.3.1.2 release
Comment 1 Martin Vogel 2014-09-30 19:46:49 UTC 
In LibreOffice Calc 4.2.6.3 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 4.3.2.2, 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 4.3.2.2, 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 4.3.1.2 portable - Win7 x86

Confirm correct behavior with LO 4.2.6.3, 4.3.2.2 portable

@Martin, please upgrade to 4.3.2.2
Comment 6 Martin Vogel 2014-10-06 09:14:28 UTC 
Confirmed: Bug no longer exists in Version 4.3.2.2 (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 ***