Description: Selecting a single group of cells results in the correct Average and Sum values being displayed in the bottom bar. If cells are selected using Ctrl-Select (i.e. non-contiguous groups), the incorrect values are displayed for the Average and Sum values. Steps to Reproduce: 1. Create blank sheet and put random values in 2 or more cells 2. Select cells using Ctrl-Select Actual Results: Average and Sum displayed in bottom bar is incorrect - only reports first value (or the average/sum of initial range if selected as a window instead of Ctrl-Select) Expected Results: Average and sum should reflect all values selected, not just first value or first group selected on multiple selections. Reproducible: Always User Profile Reset: No Additional Info: Version: 7.1.1.2 (x64) / LibreOffice Community Build ID: fe0b08f4af1bacafe4c7ecc87ce55bb426164676 CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win Locale: en-GB (en_GB); UI: en-US Calc: threaded
Works for me. Version: 7.1.3.0.0+ (x64) / LibreOffice Community Build ID: 436573acb76714ae9b0ccb8e664911b9696269f4 CPU threads: 4; OS: Windows 10.0 Build 21296; UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: es-ES Calc: threaded
Hmm... I have rebooted since I reported this bug and it now works for me too. Seems to be an intermittent issue.
(In reply to Steve Lewis from comment #2) > Hmm... I have rebooted since I reported this bug and it now works for me > too. Seems to be an intermittent issue. let's close this one as WFM. Feel free reopen it if you'll see it again