https://bugs.documentfoundation.org/show_bug.cgi?id=156817
--- Comment #3 from mattia.b89 <[email protected]> --- yes, @ady was right, my opening description is poor and case is complicated; I'll remedy here: *FOREWORD: with "sum/average" I am talking about the automatic calculation results shown in the status bar, on the right, just before the zoom slider* Referring to my screencast, I show you three issues: 1- if I select column H (all numeric values), sum/average is calculated; and this is done both if I select the first cell and drag cursor until last one OR I individually select those cells; with column I (containing a problematic cell "Err:510"), if I selects cells by dragging the cursor, sum/average is EMPTY, no calculation are done (and this is right!) but none message is shown (around time 0:10 in my video); this is FIRST ISSUE: if I select something, I'd like to see values for sum/average OR the reason why Calc can't do its work; in a few word, a better sum/average error handling [enhancement]. 2- if I individually select cells in column I, first two cells (numeric) return sum/average values and as soon as (around time 0:29 in my video) I include the third cell (Err:510), sum/average in the status bar CORRECTLY! changes in "Error: Variable missing"; unfortunately situation goes back to EMPTY sum/average when I select other numeric cells; but here is the SECOND ISSUE: if I deselect the "Err:510" cell (time 0:34) the sum/average values got updated to a wrong result, that is "Error: Variable missing", even if current selection contains only good cells [bug]; 3- the THIRD and last comes now: how to fix the second issue? the following workaround works: simply select a good cell (I pick one from column H) and then immediately deselect it (time 0:37); you can notice sum/average values change accordingly; in a few word, sum/average calculation didn't get update with a problematic cell [bug], indeed I need to "force" an update by selecting/deselecting a foreign cell. I hope this will clarify my report. -- You are receiving this mail because: You are the assignee for the bug.
