Bug 107366 - Bug in selection menu for active cell range functions
Summary: Bug in selection menu for active cell range functions
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.2.6.2 release
Hardware: x86-64 (AMD64) macOS (All)
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected
Depends on:
Blocks: Statusbar Calc-Function
  Show dependency treegraph
 
Reported: 2017-04-23 12:19 UTC by rl
Modified: 2023-06-27 14:27 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Result of step 7 (21.48 KB, image/png)
2017-04-23 12:19 UTC, rl
Details

Note You need to log in before you can comment on or make changes to this bug.
Description rl 2017-04-23 12:19:02 UTC
Created attachment 132765 [details]
Result of step 7

In the status bar of Calc the results of some functions are calculated and displayed automatically for the active cell range. The functions are Average, CountA, Count, Maximum, Minimum, Sum, Selection count.

(Sorry, I don't know the official term for this feature. But the attached screenshot will hopefully make clear what I mean.)

In a context menu, that is, a menu that opens once I right-mouse-button (RMB) click on the status bar, I can select which subset of the functions mentioned above I want Calc to execute automatically.

That context menu doesn't work correctly in LibreOffice 5.3.2.2 for macOS, as you can see in the attached screenshot. The selection shown in the context menu almost never matches the actually selected functions.

To reproduce this issue in Calc:
1. RMB click on the function section of the status bar
2. Select "None"
3. RMB click on status bar again
4. Select "Sum"
 → Result: "Sum: 0" appears in status bar, as expected
5. RMB click on status bar again
 → Result: "Sum" is not selected in context menu, when it should be
6. Select "Average"
 → Result: "Average: ; Sum: 0" appears in status bar, as expected
7. RMB click on status bar again
 → Result: "Sum" is now selected in context menu, but "Average" is not

(LibreOffice 5.3.2.2, macOS 10.12.4)
Comment 1 Alex Thurgood 2017-04-24 10:07:53 UTC
Confirming
Comment 2 Alex Thurgood 2017-04-24 10:08:24 UTC
Tested with 

Version: 5.3.2.2
Build ID: 6cd4f1ef626f15116896b1d8e1398b56da0d0ee1
Threads CPU : 2; Version de l'OS :Mac OS X 10.12.4; UI Render : par défaut; Moteur de mise en page : nouveau; 
Locale : fr-FR (fr_FR.UTF-8); Calc: group
Comment 3 Alex Thurgood 2017-04-24 10:11:30 UTC
Doesn't work properly either in 

Version: 5.2.6.2
Build ID: a3100ed2409ebf1c212f5048fbe377c281438fdc
Threads CPU : 2; Version de l'OS :Mac OS X 10.12.4; UI Render : par défaut; 
Locale : fr-FR (fr_FR.UTF-8); Calc: group
Comment 4 Alex Thurgood 2017-04-24 10:12:13 UTC
Am pretty certain that this was reported a while ago against an earlier version, but would need to be found again.
Comment 5 Heiko Tietze 2017-04-24 11:14:44 UTC
No issue on Windows with 5.4.
Comment 6 Yousuf Philips (jay) (retired) 2017-04-25 04:09:22 UTC
No repo here. Must be a Mac only issue.

Version: 5.4.0.0.alpha0+
Build ID: f0340e3dca1091accdb71e0c566b96cdf9e0f791
CPU threads: 2; OS: Linux 4.4; UI render: default; VCL: gtk2; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2017-04-21_13:34:48
Locale: en-US (en_US.UTF-8); Calc: group

@Alex, @Steve: Can you test master to ensure its not fixed there?
Comment 7 steve 2017-05-21 08:20:51 UTC
For anybody wondering RMB click = Right Mouse Button click (I suppose)

Confirming error in step 5:  Result: "Sum" is not selected in context menu, when it should be

Confirming step 7: Result: "Sum" is now selected in context menu, but "Average" is not

Version: 5.5.0.0.alpha0+
Build ID: 20d04d6938a104124ac06271f17978a290cccf6c
CPU threads: 8; OS: Mac OS X 10.12.5; UI render: default; 
TinderBox: MacOSX-x86_64@49-TDF, Branch:master, Time: 2017-05-21_00:31:17
Locale: de-DE (de_DE.UTF-8); Calc: group
Comment 8 eisa01 2018-03-17 13:20:03 UTC
Still present. May be a regression since bug 101634, as that was reported fixed

Version: 6.1.0.0.alpha0+
Build ID: 8e8dd8f320a3ff59ff8a16c1a7a867888ce80700
CPU threads: 2; OS: Mac OS X 10.12.6; UI render: default; 
TinderBox: MacOSX-x86_64@49-TDF, Branch:master, Time: 2018-03-13_23:59:29
Locale: en-US (en_US.UTF-8); Calc: group
Comment 9 Xisco Faulí 2018-03-21 18:12:17 UTC
The problem is that Average can't be selected... it's not a regression... Multiple regressions started in https://cgit.freedesktop.org/libreoffice/core/commit/?id=7bc97db5b972f27693161beb9182f8a5850f5551
Comment 10 Xisco Faulí 2018-03-21 18:50:08 UTC
I thought it might be caused by a loop starting with 1 but I can't find any in vcl/osx/
Comment 11 Xisco Faulí 2018-03-21 19:06:30 UTC
(In reply to Xisco Faulí from comment #9)
> The problem is that Average can't be selected... it's not a regression...
> Multiple regressions started in
> https://cgit.freedesktop.org/libreoffice/core/commit/
> ?id=7bc97db5b972f27693161beb9182f8a5850f5551

s/Multiple regressions/Multiple selections
Comment 12 QA Administrators 2019-03-22 04:04:24 UTC Comment hidden (obsolete)
Comment 13 eisa01 2019-04-20 17:47:40 UTC
This is still present

Version: 6.3.0.0.alpha0+
Build ID: ea9c13be02ba731074fa4207944ff7df40a0fb5c
CPU threads: 2; OS: Mac OS X 10.13.6; UI render: default; VCL: osx; 
TinderBox: MacOSX-x86_64@49-TDF, Branch:master, Time: 2019-04-10_20:43:17
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded
Comment 14 QA Administrators 2023-03-07 04:18:09 UTC Comment hidden (obsolete)
Comment 15 rl 2023-03-07 22:00:31 UTC
Still present in this «macOS (Apple Silicon)» release:

Version: 7.5.1.2 (X86_64) / LibreOffice Community
Build ID: fcbaee479e84c6cd81291587d2ee68cba099e129
CPU threads: 10; OS: Mac OS X 13.2.1; UI render: default; VCL: osx
Locale: en-US (en_DE.UTF-8); UI: en-US
Calc: threaded

My Apple M1 Max system runs macOS Ventura 13.2.1.
Comment 16 rl 2023-03-07 22:27:52 UTC
Have not yet checked the current «macOS (Intel)» version.