https://bugs.documentfoundation.org/show_bug.cgi?id=91003
m.a.riosv <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #2 from m.a.riosv <[email protected]> --- Created attachment 115250 --> https://bugs.documentfoundation.org/attachment.cgi?id=115250&action=edit Sample file modified. Hi Peter, thanks for reporting. Use absolute/relative references in CF formulas it's very important. When you use a range in the CF formulas are adapted to every cell in the range similar as if you were copying them. In this case using absolute references in the CF formula preserves the average range for comparison with every cell value. So using: AVERAGE($B$7:$B$12) instead AVERAGE(B7:B12) makes CF work fine. -- 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
