https://bugs.documentfoundation.org/show_bug.cgi?id=99417
Bug ID: 99417
Summary: effect of sort does not propagate to other column
Product: LibreOffice
Version: unspecified
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
i have a simple worksheet containing in
column A: the numbers 1,2,...n
column B: input numbers (in the range 0 ..100)
column C: the formula =B1, =(C1+B2), ... =(Cm+Bn) where m=n-1
column D: the formula =C1/A1, =C2/A2, ... =Cn/An
So, in column D one expects the average value of the values in B.
(cumulative, e.g. D7 contains the average of B1, B2, ... B7)
Now I sort the values in column B
(Select column B, click Data > sort > descending)
The values in C change accordingly, but those in D remain the same!
--
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
