Once cells selection contain #N/D cell, the statusbar Sum and Average values are not visible, with the Error message displayed instead (OK). However, after de-select the #N/D cell (using Ctrl+LMB), the value is not updated and the Error message persists. If after deselecting #N/D cell I do deselect other cell with valid value and select the valid value back, the Avg/Sum is updated. Deselecting the #N/D cell should restore Avg/Sum calculation itself (if after deselecting, calculation is possible).
Please, can you attach a sample file.
Created attachment 175032 [details] LO Calc update issue Test case for the report. Try to select values from Sheet1, cells C2:C7 The Sum of the cells displayed in the status bar will not show since there's #N/D value. Now deselect the C4 using Ctrl+LMB The Sum will still not be displayed But if deselect also C3, the sum will update. Select back the C3 and sum will still be there.
The issue it's deselecting C4, 'Error:Value not available' in status bar.
Version: 7.2.1.2 (x64) / LibreOffice Community Build ID: 87b77fad49947c1441b67c559c339af8f3517e22 CPU threads: 4; OS: Windows 10.0 Build 21390; UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL
Also in Version: 7.6.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: 8dfceb4e0b05b9d531e27e38b954f18e33091f8a CPU threads: 16; OS: Linux 5.19; UI render: default; VCL: gtk3 Locale: ro-RO (ro_RO.UTF-8); UI: en-US Calc: threaded
There is no bug here. When you select a cell with and error, the status bar shows a "long" phrase for that error. In attachment 175032 [details] from comment 2, when you [CTRL]+click on that cell with the "Not available" error, you deselect the cell, but the focus is still on the same cell, so the error is shown on the status bar. To demonstrate (just as described in comment 0), using attachment 175032 [details] from comment 2, after deselecting the cell C4 with the error, go and press [CTRL]+click on C7 twice > now the selection is the same relevant area but the cell that has the focus (C7) has no error, so the status bar shows the specified calculated values. So, this is not a bug, just simple common behavior. Someone might want to suggest some different behavior regarding the status bar (e.g. if the function shown on the status bar normally disregards some type of error on the main area, then also disregard it on the status bar) as a request for enhancement, but that's a different issue.