https://bugs.documentfoundation.org/show_bug.cgi?id=99734
m.a.riosv <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED CC| |[email protected] | |rg Resolution|--- |NOTABUG --- Comment #1 from m.a.riosv <[email protected]> --- If you do the same between ranges on the same file you have the same result. You are using a range with a formula to calculate the average, so there are not empty cells for the calculation. A trick is use and array than returns an empty string to avoid zeroes so AVARAGE() calculates without those cells because they are text, like {=IF(B2:B7;B2:B7;"")} Resolved as notabug, please if you are not agree reopen it. -- 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
