[Libreoffice-bugs] [Bug 105394] A warning should be issued if one of the cells included in the computation has a value of any kind that is not taken into account in the result

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=105394

--- Comment #14 from Bruno Pagani <bruno.n.pagani at gmail.com> ---
Yes, it works if the locale setting is correct for all cells, and since this
has been understood the issue has been about how this could go unnoticed and
have adverse effects. For instance, my case was for the grade of students, and
the effect would have been for their final grade to not take into account the
first exam of the year. And it this precise case, that was enough for the
student to pass or not. It would have gone unnoticed if I hadn’t computed the
mean of grades independently.

All I’m asking for is to issue a warning to the user when they apply any
formula on cells with different locale settings amongst them, or maybe even
better to issue a warning when some non-empty cells are not considered for
computation in the selected area. Because visually, there is nothing that tells
you the first cell has a wrong format.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20181208/8b118fd5/attachment.html>