Bug 141585

Summary: UI Issue: Autosum function in bottom bar broken in LibreOffice Calc 7.1.1.2 x64 for Windows
Product: LibreOffice Reporter: Steve Lewis <lewis>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED WORKSFORME    
Severity: normal CC: 79045_79045, miguelangelrv
Priority: medium    
Version: 7.1.1.2 release   
Hardware: x86-64 (AMD64)   
OS: Windows (All)   
Whiteboard:
Crash report or crash signature: Regression By:

Description Steve Lewis 2021-04-09 12:44:19 UTC 
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
Comment 1 m_a_riosv 2021-04-09 16:59:53 UTC 
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
Comment 2 Steve Lewis 2021-04-09 18:31:03 UTC 
Hmm... I have rebooted since I reported this bug and it now works for me too. Seems to be an intermittent issue.
Comment 3 Roman Kuznetsov 2021-07-23 18:51:14 UTC 
(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