<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - 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" href="https://bugs.documentfoundation.org/show_bug.cgi?id=105394#c14">Comment # 14</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - 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" href="https://bugs.documentfoundation.org/show_bug.cgi?id=105394">bug 105394</a> from <a class="email" href="mailto:bruno.n.pagani@gmail.com" title="Bruno Pagani <bruno.n.pagani@gmail.com>"> Bruno Pagani</a> <pre>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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>