LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 07-31-2020, 11:49 AM   #1
RockDoctor
Senior Member
 
Registered: Nov 2003
Location: Minnesota, US
Distribution: Fedora, Ubuntu, Linux Mint
Posts: 1,738

Rep: Reputation: 405Reputation: 405Reputation: 405Reputation: 405Reputation: 405
Question Selecting a range of cells LO Calc vs. Gnumeric


In Gnumeric, if I have a block of cells of unknown length, all of which contain values, and I want to select all cells from the current cell (somewhere in that block) to the last cell. I just hold down the Shift key and press End Down-Arrow. But I can't for the life of me figure out how to do the same selection with a couple of keystrokes in LO Calc. What am I missing? Thanks.
 
Old 07-31-2020, 11:58 AM   #2
rtmistler
Moderator
 
Registered: Mar 2011
Location: USA
Distribution: MINT Debian, Angstrom, SUSE, Ubuntu, Debian
Posts: 8,823
Blog Entries: 13

Rep: Reputation: 3989Reputation: 3989Reputation: 3989Reputation: 3989Reputation: 3989Reputation: 3989Reputation: 3989Reputation: 3989Reputation: 3989Reputation: 3989Reputation: 3989
CTRL-SHIFT-END/DOWN does it for me.
 
Old 07-31-2020, 01:16 PM   #3
RockDoctor
Senior Member
 
Registered: Nov 2003
Location: Minnesota, US
Distribution: Fedora, Ubuntu, Linux Mint
Posts: 1,738

Original Poster
Rep: Reputation: 405Reputation: 405Reputation: 405Reputation: 405Reputation: 405
Quote:
Originally Posted by rtmistler View Post
CTRL-SHIFT-END/DOWN does it for me.
Thank you. Tried CTRL-SHIFT-END/DOWN and it highlighted everything down to the bottom-right-most occupied cell, including blank cells. Not quite what I wanted. So based on your suggestion, I tried CTRL-SHIFT/<Arrow-key>, which does do what I want.
 
Old 07-31-2020, 01:37 PM   #4
rtmistler
Moderator
 
Registered: Mar 2011
Location: USA
Distribution: MINT Debian, Angstrom, SUSE, Ubuntu, Debian
Posts: 8,823
Blog Entries: 13

Rep: Reputation: 3989Reputation: 3989Reputation: 3989Reputation: 3989Reputation: 3989Reputation: 3989Reputation: 3989Reputation: 3989Reputation: 3989Reputation: 3989Reputation: 3989
Sorry I meant either one key versus the other, not both together. Sounds like you figured that out. DOWN is the down arrow, but it says PgDn. END is the right arrow, which does say End. At least on my "thousand purpose per key" keyboard.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] Hotkeys in gnumeric. Creating gnumeric/system hotkeys Alex McGregor Linux - Newbie 1 08-30-2014 12:20 PM
[SOLVED] Hotkeys in gnumeric. Creating gnumeric/system hotkeys Alex McGregor Linux - Software 2 08-30-2014 12:14 PM
Referencing cells in an OO calc data range (or better approach to pairing ranges) boblikeslinux Linux - Software 5 06-17-2010 08:32 AM
Gnumeric doesn't merge cells when using autofill MonctonJohn Linux - Software 3 03-25-2008 06:30 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 09:53 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration