https://bugs.documentfoundation.org/show_bug.cgi?id=121078
Mike Kaganski <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |NOTABUG
Status|UNCONFIRMED |RESOLVED
--- Comment #4 from Mike Kaganski <[email protected]> ---
1. The original description was wrong when described the column C: it should
say that a formula like "=IF(A1="";"";SUM(A1;B1))" is used there.
2. There is no bug in Calc; rather, there's an error in the formula in D, where
the result of "IF(C1="","",SUM(C2-C1)/C1)" is unconditionally multiplied by
100. In case of cells with empty neighbors, this results in ""*100, which is
naturally wrong, which is reported as #VALUE!.
The proper formula is "=IF(C2="";"";SUM(C2-C1)/C1*100)"
Closing NOTABUG.
--
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
