Please clarify selection modes in Libreoffice Calc

Discuss the spreadsheet application

Please clarify selection modes in Libreoffice Calc

Postby catbill » Thu Nov 22, 2018 11:12 pm

There are 4 selection modes in Calc: standard, extended, adding and block. I assume that the logic for each is the same as for selection mode in Writer. I have two questions about them:

How is block selection different from standard selection mode? I see no difference.

All of the selection modes seem to apply to cells but it appears that only the standard selection mode applies to text (within a cell). Is that correct?

Thank you.
LibreOffice 6.2.6.2
catbill
 
Posts: 81
Joined: Sun Oct 08, 2017 6:51 pm

Re: Please clarify selection modes in Libreoffice Calc

Postby RoryOF » Thu Nov 22, 2018 11:16 pm

In Writer, Block selection mode allows one to define and select a vertical block of text.
Apache OpenOffice 4.1.7 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29911
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Please clarify selection modes in Libreoffice Calc

Postby catbill » Thu Nov 22, 2018 11:32 pm

Yes, but this is Calc. I want to understand what it does in Calc. Could it have been a mistake to include it and no one noticed?
LibreOffice 6.2.6.2
catbill
 
Posts: 81
Joined: Sun Oct 08, 2017 6:51 pm

Re: Please clarify selection modes in Libreoffice Calc

Postby RoryOF » Thu Nov 22, 2018 11:35 pm

Look up "Selection modes in spreadsheets" in the Help file. It seems that it doesn't do anything special.
Apache OpenOffice 4.1.7 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29911
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Please clarify selection modes in Libreoffice Calc

Postby Zizi64 » Thu Nov 22, 2018 11:44 pm

The selection items in LibreOffice 6.1.2 Calc

selection items in LO Calc.png
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.3.3; AOO4.1.6
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 8549
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Please clarify selection modes in Libreoffice Calc

Postby catbill » Tue Apr 09, 2019 11:09 pm

In the question, I did not clearly specify what I was talking about. I was referring to the four selection modes that appear when you right click on the selection field in the Task bar.
LibreOffice 6.2.6.2
catbill
 
Posts: 81
Joined: Sun Oct 08, 2017 6:51 pm

Re: Please clarify selection modes in Libreoffice Calc

Postby Zizi64 » Wed Apr 10, 2019 6:49 am

I was referring to the four selection modes that appear when you right click on the selection field in the Task bar.

Sorry then I not understood your question, Which Taskbar and selection feature you meant?
Did you meant the Windows Taskbar, or a Toolbar of the AOO/LO?


Please upload a screenshot about the feature.
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.3.3; AOO4.1.6
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 8549
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Please clarify selection modes in Libreoffice Calc

Postby robleyd » Wed Apr 10, 2019 10:36 am

Same question asked at AskLibreOffice
Cheers
David
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 3057
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Please clarify selection modes in Libreoffice Calc

Postby Villeroy » Wed Apr 10, 2019 12:55 pm

Bildschirmfoto von 2019-04-10 12-47-00.png
LO6 status bar selection mode
Bildschirmfoto von 2019-04-10 12-47-00.png (7.13 KiB) Viewed 325 times

In LO this button offers 4 options on right-click for both components Calc and Writer. Block mode makes no sense with Calc and in fact it does nothing.
In AOO Calc there are 3 options which toggle by left click. F8 toggles between standard and expand. Shift+F8 toggles between standard and addition.

I never use these features because I prefer the usual keyboard navigation with Shift and Ctrl or mouse selection with Shift and Ctrl. They work with many different applications in similar ways.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27386
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Please clarify selection modes in Libreoffice Calc

Postby catbill » Thu Apr 11, 2019 1:15 am

robleyd wrote:Same question asked at AskLibreOffice

Not sure why I didn't link to that post and thank you for pointing that out.
LibreOffice 6.2.6.2
catbill
 
Posts: 81
Joined: Sun Oct 08, 2017 6:51 pm

Re: Please clarify selection modes in Libreoffice Calc

Postby catbill » Thu Apr 11, 2019 1:27 am

Zizi64 wrote:
I was referring to the four selection modes that appear when you right click on the selection field in the Task bar.

Sorry then I not understood your question, Which Taskbar and selection feature you meant?
Did you meant the Windows Taskbar, or a Toolbar of the AOO/LO?


Please upload a screenshot about the feature.

Oops. Sorry about that. I meant the LO Status bar, not Task bar. I would have included a screenshot but I can't get the latest version of the Snipping Tool to take a screenshot of a context menu, even with a delay.

Anyway, one of the responses in the linked Ask.LibreOffice post says that this issue is a bug and a bug report has been filed.
LibreOffice 6.2.6.2
catbill
 
Posts: 81
Joined: Sun Oct 08, 2017 6:51 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 17 guests