https://bugs.freedesktop.org/show_bug.cgi?id=83276
Priority: medium
Bug ID: 83276
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: Incorrect Formulae After Sorting
Severity: critical
Classification: Unclassified
OS: Windows (All)
Reporter: dmdcare...@care2.com
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.3.1.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 105470
--> https://bugs.freedesktop.org/attachment.cgi?id=105470&action=edit
Example for Incorrect Formulae After Sorting
Windows 7 Home Premium SP1
Sorting data to which formulae refer results in incorrect formulae.
The attachment contains a worksheet with three columns: rank, organisation
contacted, and number of contacts. The third and subsequent rows in the rank
column contain a formula to determine an entry's rank and when the list needs
re-sorting.
Sorting takes places on the organisation contacted and number of contacts
columns based on the descending number of contacts and the ascending
organisation contacted.
Change the number of contacts in any row from three onwards to a higher number
than one or more of the entries above the chosen row. The rank column heading
changes to "Re-sort" and the chosen row displays the same text instead of a
ranking number (or a blank).
Highlight the organisation contacted and number of contacts headings and the
data, select Data, Sort... and click OK. When the data is sorted the text
"Re-sort" is still displayed in the chosen row as the formula in the chosen row
now refers to the new position of the organisation contacted.
I believe, but am not sure, sorting in version 4.3 resulted in the formula
referring to the chosen row, however, that was definitely the case in 4.2 (and
earlier) releases.
--
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
