Please clarify selection modes in Libreoffice Calc

Discuss the spreadsheet application
Post Reply
catbill
Posts: 81
Joined: Sun Oct 08, 2017 6:51 pm

Please clarify selection modes in Libreoffice Calc

Post by catbill »

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
User avatar
RoryOF
Moderator
Posts: 34570
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Please clarify selection modes in Libreoffice Calc

Post by RoryOF »

In Writer, Block selection mode allows one to define and select a vertical block of text.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
catbill
Posts: 81
Joined: Sun Oct 08, 2017 6:51 pm

Re: Please clarify selection modes in Libreoffice Calc

Post by catbill »

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
User avatar
RoryOF
Moderator
Posts: 34570
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Please clarify selection modes in Libreoffice Calc

Post by RoryOF »

Look up "Selection modes in spreadsheets" in the Help file. It seems that it doesn't do anything special.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
User avatar
Zizi64
Volunteer
Posts: 11345
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Please clarify selection modes in Libreoffice Calc

Post by Zizi64 »

The selection items in LibreOffice 6.1.2 Calc
selection items in LO Calc.png
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
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.
catbill
Posts: 81
Joined: Sun Oct 08, 2017 6:51 pm

Re: Please clarify selection modes in Libreoffice Calc

Post by catbill »

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
User avatar
Zizi64
Volunteer
Posts: 11345
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Please clarify selection modes in Libreoffice Calc

Post by Zizi64 »

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; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
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
robleyd
Moderator
Posts: 5035
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Please clarify selection modes in Libreoffice Calc

Post by robleyd »

Same question asked at AskLibreOffice
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.1.2; SlackBuild for 24.2.1 by Eric Hameleers
User avatar
Villeroy
Volunteer
Posts: 31264
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Please clarify selection modes in Libreoffice Calc

Post by Villeroy »

LO6 status bar selection mode
LO6 status bar selection mode
Bildschirmfoto von 2019-04-10 12-47-00.png (7.13 KiB) Viewed 2393 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 with LibreOffice 6.0, latest OpenOffice and LibreOffice
catbill
Posts: 81
Joined: Sun Oct 08, 2017 6:51 pm

Re: Please clarify selection modes in Libreoffice Calc

Post by catbill »

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

Post by catbill »

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
Post Reply