https://bugs.documentfoundation.org/show_bug.cgi?id=161641
Bug ID: 161641
Summary: CTRL+A should select only the closest range of cells
filled with data
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Blocks: 98259
Created attachment 194803
--> https://bugs.documentfoundation.org/attachment.cgi?id=194803&action=edit
Example file from Excel 2016
Pressing Ctrl+A in Excel behaves differently from Calc:
If the cursor selection is on a cell whose neighboring cells have any data, the
rectangular cell range gets selected on first press of the combination.
On second press of the combination the whole sheet is selected, just like in
Calc, or if the selected cells neighbors are all empty.
Copying this behavior would be useful for users switching from Excel.
1. Open attached file
2. Click on cell C5, press Ctrl+A
-> The range C4:D6 gets selected.
Press Ctrl+A again to get the whole sheet selected.
3. Click on cell G5, press Ctrl+A
-> The range G4:H6 gets selected
4. Click on cell B11, press Ctrl+A
-> The range B10:B12 gets selected
5. Click on cell F10, press Ctrl+A
-> The range E8:F10 gets selected
6. Click on cell A1, press Ctrl+A
-> The whole sheet is selected
In Calc the whole sheet is selected on first press.
Version: 24.8.0.0.alpha1+ (X86_64) / LibreOffice Community
Build ID: a2b6ce5d21b7f5c84ced8485f5af279f1bf8135f
CPU threads: 14; OS: Windows 10 X86_64 (10.0 build 19045); UI render:
Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: default
This worked always like this.
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=98259
[Bug 98259] [META] Keyboard shortcuts and accelerators bugs and enhancements
--
You are receiving this mail because:
You are the assignee for the bug.
