Page 1 of 1

Please clarify selection modes in Libreoffice Calc

Posted: Thu Nov 22, 2018 11:12 pm
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.

Re: Please clarify selection modes in Libreoffice Calc

Posted: Thu Nov 22, 2018 11:16 pm
by RoryOF
In Writer, Block selection mode allows one to define and select a vertical block of text.

Re: Please clarify selection modes in Libreoffice Calc

Posted: Thu Nov 22, 2018 11:32 pm
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?

Re: Please clarify selection modes in Libreoffice Calc

Posted: Thu Nov 22, 2018 11:35 pm
by RoryOF
Look up "Selection modes in spreadsheets" in the Help file. It seems that it doesn't do anything special.

Re: Please clarify selection modes in Libreoffice Calc

Posted: Thu Nov 22, 2018 11:44 pm
by Zizi64
The selection items in LibreOffice 6.1.2 Calc
selection items in LO Calc.png

Re: Please clarify selection modes in Libreoffice Calc

Posted: Tue Apr 09, 2019 11:09 pm
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.

Re: Please clarify selection modes in Libreoffice Calc

Posted: Wed Apr 10, 2019 6:49 am
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.

Re: Please clarify selection modes in Libreoffice Calc

Posted: Wed Apr 10, 2019 10:36 am
by robleyd
Same question asked at AskLibreOffice

Re: Please clarify selection modes in Libreoffice Calc

Posted: Wed Apr 10, 2019 12:55 pm
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 2483 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.

Re: Please clarify selection modes in Libreoffice Calc

Posted: Thu Apr 11, 2019 1:15 am
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.

Re: Please clarify selection modes in Libreoffice Calc

Posted: Thu Apr 11, 2019 1:27 am
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.