Description: Version: 7.6.2.1 (X86_64) / LibreOffice Community Build ID: 60(Build:1) CPU threads: 4; OS: Linux 6.1; UI render: default; VCL: kf5 (cairo+xcb) Locale: ru-RU (ru_RU.UTF-8); UI: ru-RU 7.6.2-3 Calc: threaded When you select part of a column with merged cells, all columns that are part of the merged cell are selected. Steps to Reproduce: 1.open spreadsheet 2.merge a4:c4 3.select a2:a5 Actual Results: selected a2:c5 Expected Results: selected a2:a5 Reproducible: Always User Profile Reset: Yes Additional Info: This is probably the result of fixing bug 155796 and bug 128678.
can confirm with: Version: 7.6.2.1 (AARCH64) / LibreOffice Community Build ID: 56f7684011345957bbf33a7ee678afaf4d2ba333 CPU threads: 4; OS: Linux 6.1; UI render: default; VCL: gtk3 Locale: de-DE (de_DE.UTF-8); UI: en-US Flatpak Calc: threaded but NOT with: Version: 7.4.7.2 / LibreOffice Community Build ID: 40(Build:2) CPU threads: 4; OS: Linux 6.1; UI render: default; VCL: gtk3 Locale: de-DE (de_DE.UTF-8); UI: de-DE Debian package version: 4:7.4.7-1 Calc: threaded
Based on comment 1.
I was able to replicate this bug in Linux using this repository: https://bibisect.libreoffice.org/linux-64-7.6 More information on the commit that caused this bug here: https://git.libreoffice.org/core/commit/39aa1f6424390821579bfb6b6ba14e9ce11040ce Adding CC: Jaume Pujantell Information about the first version that caused this bug: Version: 7.6.1.0.0+ (X86_64) / LibreOffice Community Build ID: 39aa1f6424390821579bfb6b6ba14e9ce11040ce CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded
(In reply to kdub from comment #3) > I was able to replicate this bug in Linux using this repository: > https://bibisect.libreoffice.org/linux-64-7.6 > > More information on the commit that caused this bug here: > https://git.libreoffice.org/core/commit/ > 39aa1f6424390821579bfb6b6ba14e9ce11040ce Let's the commit from the master branch (24.2) as well: https://cgit.freedesktop.org/libreoffice/core/commit/?id=341029de72cf957b7bc7775e51544070d4a49874
Thinking about this, I'm not sure this should be considered a bug. There's a merged cell in the range, which means your selection isn't strictly within column A, but spans to column C. Excel also behaves the same way. Let's ask the UX team, can you please share your thoughts?
LibreOffice behaves exactly like MS Excel, at least on macOS. However, I can follow the idea that selecting b1:b5 should not add a1 and c5 if a2:c4 is merged (as you get it via ctrl).