https://bugs.documentfoundation.org/show_bug.cgi?id=97558
Bug ID: 97558
Summary: : sort function doesn't maintain coherency of formula
in a cell
Product: LibreOffice
Version: 5.0.4.2 release
Hardware: x86 (IA32)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 122374
--> https://bugs.documentfoundation.org/attachment.cgi?id=122374&action=edit
spreadsheet to calculate a balance between ressource (credit) and expense
(debit)
Hi,
I use libreoffice after downloading Libreoffice_5.0.4_win_x86.msi.
In the spreadsheet which is attached, we retain the cell G51 with the formula
F49-G50. the result is 36. Select all the table (except the title 1rst row),
sort ascending on column B, we will see the final sums (at the row 82) of the 2
columns F and G will be no more balanced. The reason why is : the formula of
the cell G51 before sorting become wrong after sorting. If instead of using the
formula we use a real value, that is 36, then the sort comes out with a correct
result, the final sums of the columns F and G are still balanced.
regards
--
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
