https://bugs.freedesktop.org/show_bug.cgi?id=45146
Bug #: 45146
Summary: : Sort column
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.4.5 release
Platform: Other
OS/Version: All
Status: UNCONFIRMED
Status Whiteboard: BSA
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
Created attachment 56052
--> https://bugs.freedesktop.org/attachment.cgi?id=56052
Example file
Problem description:
Steps to reproduce:
1. If a cell have a complex formula like this:
=E58*G58+E327*G327+E267*G267+E67*G67+E37*G37+I37+E188*G188+E263*G263+E251*G251+E246*G246+I246+4*G126+2*G155+E222*G222+I222+E137*G137
2. When ordered cells grow or descending by going to "Data", Sort..."
3. The result of the formula becomes wrong
In the attached file, the result of the formula in cell M28 is 320, when i
order the column "I" the result in cell M28 becomes 25 and is incorrect.
Current behavior:
The result of the formula changes
Expected behavior:
The result of the formula does not change
Platform (if different from the browser):
Browser: Opera/9.80 (Windows NT 6.1; U; Edition Campaign 21; it)
Presto/2.10.229 Version/11.60
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
