https://bugs.documentfoundation.org/show_bug.cgi?id=103564
Bug ID: 103564
Summary: Formulas cling to orignal cells they point to, which
will move, in other columns when sorting for first
column
Product: LibreOffice
Version: 4.3.3.2 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Before sorting by date column:
Date Sales Per Day Sales Accumulated
10/01/16 $100.00 $100.00
10/03/16 $100.00 $200.00
10/20/16 $100.00 $300.00
10/02/16 $100.00 $400.00
After sorting by date column:
Date Sales Per Day Sales Accumulated
10/01/16 $100.00 $100.00
10/02/16 $100.00 $400.00
10/03/16 $100.00 $200.00
10/20/16 $100.00 $300.00 <---different total!!!
Obviously we should end at $400 on the bottom right.
The formula (of third column) was only to add the cell above to the cell on the
left.
I will attempt to attach the files.
Steps to Reproduce:
1. see description
Actual Results:
Wrong final total due to sorting by date! Not obvious to user!
Expected Results:
Accurate final totals preserved in sorting!
Reproducible: Always
User Profile Reset: Adjust the formulas in sorting to point to new cells.
For example the $400-showing cell (C3) after sort should have had new formula
C2+B3, but had formula C5+B3
Additional Info:
User-Agent: Mozilla/5.0 (Windows NT 6.1; rv:45.0) Gecko/20100101 Firefox/45.0
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
