https://bugs.freedesktop.org/show_bug.cgi?id=84511
Priority: medium
Bug ID: 84511
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: EDITING: Sorting corrupts cell references in COUNTIF
formula (ZÄHLENWENN)
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: m...@martinvogel.de
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.3.1.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 107129
--> https://bugs.freedesktop.org/attachment.cgi?id=107129&action=edit
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
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
