https://bugs.documentfoundation.org/show_bug.cgi?id=169075
Bug ID: 169075
Summary: The selected range by shortcut SHIFT+SPACE/ CTRL+SPACE
doesn't seem to be truely desired
Product: LibreOffice
Version: 26.2.0.0 alpha0+ master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
The selected range by shortcut SHIFT+SPACE/ CTRL+SPACE doesn't seem to be
truely desired
Steps to Reproduce:
1. Open Calc
2. Press SHIFT+SPACE (A1:XFD1) or CTRL+SPACE (selects A1:A1048576) or pressing
CTRL+END. Click in margin on column/or row
Actual Results:
It selects the full range of a Jumbo sheet.
Casual users don't truly make use of Jumbo sheet size. However the do want to
copy/paste a number of columns (say A-Z) or some range with content (row 1 to
500)
The lazy people use SHIFT+SPACE and CTRL+SPACE (see bug 169069 as example). So
are moving insane ranges around where it's actually about 'small' area's the
want to actually move. However it's quite an effort to define a small area
(breaking workflow), so move large chuncks
With the potential side-effect of moving formatting and other stuff around too
which is actually out of sight.
This is causing also sorts of side-effects
* Large file sizes (if DF formatting being scattered across the sheet)
* slow pasting (way to large range)
I surely don't know what I have put onto the outer skirts of my sheet. I'm
already happy when I can navigating a sheet with say column A-Z and 2000 rows
The the sheets supports it doesn't mean it's practical/useful.
Essence: LibreOffice has all sorts of shortcuts to reach the outer end of a
sheet. With of risk of putting some thinking there.
However this isn't desired for a 'normal' user, using Calc a spreadsheet
instead of some large database.
This relates to bug bug 167674
Expected Results:
* The hard part. Limited the size: as bug 167674
* Incremental increases of the shortcut. CTRL+SPACE or SHIFT+SPACE increasing
range incremental instead of all of nothing
Something else?
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 620(Build:0)
CPU threads: 4; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster;
VCL: win
Locale: nl-NL (nl_NL); UI: en-US
Calc: CL threaded
--
You are receiving this mail because:
You are the assignee for the bug.
