Description: When cell B1 and B2 are selected and cell B1 is right-clicked while Aa is input in cell A1, cell B2 is deselected and a menu appears with only cell B1 selected. Steps to Reproduce: 1. Input Aa to cell A1. 2. Select cells B1:B2, and right click cell A1 or cell A2. Actual Results: When right click B1, B1:B2 are still selected and menu appears. When right click B2, only B2 is selected and menu appears. Expected Results: When right click B2, B1:B2 are still selected and menu appears. Reproducible: Always User Profile Reset: Yes Additional Info: Cells B2, C2, D2,,, causes this too. "Aa" "aA" "Bb" cause this problem. "A" "AA" "Cc" don't cause this problem.
(In reply to tadashi from comment #0) > ... > 2. Select cells B1:B2, and right click cell A1 or cell A2. Doesn't match with .... > When right click B1, B1:B2 are still selected and menu appears. > When right click B2, only B2 is selected and menu appears. About where right-click is done.
(In reply to m.a.riosv from comment #1) > (In reply to tadashi from comment #0) > > ... > > 2. Select cells B1:B2, and right click cell A1 or cell A2. > > Doesn't match with > .... > > When right click B1, B1:B2 are still selected and menu appears. > > When right click B2, only B2 is selected and menu appears. > About where right-click is done. It is not hard to imagine it as a simple typo. It should had been: 2. Select cells B1:B2, and right click cell B1 or cell B2. I can replicate. Right-click on B2 > the selection is maintained as B1:B2. Right-click on B1 (which already had the focus) > the selection is lost, selecting only B1. Without having A1 with content, the behavior is normal, as expected, when right-clicking on either B1 or on B2. This can be also replicated by selecting C1:C3 instead of B1:B2, as long as A1 has content. It can also be replicated when the cell with content is different than A1. When the worksheet is empty of content, you can select B1:B2 and right-click on B1 and the selection is maintained, as expected. Setting to NEW.
I made many mistakes. Thank you for testing, m.a.riosv san. Thank you for translating, ady san.
No repro Version: 7.6.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: 845054aa25b7cba1daa1ff30b142d549027299bd CPU threads: 4; OS: Linux 5.19; UI render: default; VCL: gtk3 Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US Calc: threaded win only?
(In reply to raal from comment #4) > win only? Under Windows, no repro in LO 7.3, repro in 7.4.3.2 (possibly also in prior 7.4 releases) and repro in: Version: 7.6.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: 389a8d52d9961f89c0b2847b30ee1ca59a8fdc80 CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: en-US (es_AR); UI: en-US Calc: CL threaded Built: 2023-05-02
(In reply to ady from comment #5) > (In reply to raal from comment #4) > > win only? > Built: 2023-05-02 Typo: 7.6.alpha as of 2023-06-02
Pretty sure this is related to bug 157038. If there are misspelled words and the Automatic Spell Checker is enabled, the issue occurs ("Aa" "aA" "Bb" are all marked as misspelled words by the spell checker). You'll notice that if you turn off the Automatic Spell Checker, the issue no longer is reproducible. Therefore I will be marking this bug as a duplicate. *** This bug has been marked as a duplicate of bug 157038 ***