https://bugs.documentfoundation.org/show_bug.cgi?id=90122
Bug ID: 90122
Summary: Mix lines in calculations after sorting : big hidden
errors
Product: LibreOffice
Version: 4.2.7.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: critical
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 114201
--> https://bugs.documentfoundation.org/attachment.cgi?id=114201&action=edit
example with the bug identified: 2 tabs : before and after sorting
You make a sheet with calculations per line :
Ex : before sorting :
in Line 14 ( column N and next): uses cells from line 14
after sorting :
( and subtotal calculations)
in Line 14 (colum N and next): the formula uses cells from line 21 instead of
14 ! so the calculation and sums are false !!!
I made an example attached that produce the bug : 1st tab: the initial sheet
without sorting.
second tab : after sorting. in red : cells with mix-up references in
calculations.
The bug is in sorting, I found that by making subtotals (that include the
sorting): you can reproduce that bug with a sorting only.
Feel free to ask for more info.
I tested on Windows and different linux distrib and version : it is since 3.5
(!)
--
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
