It is a little stupid, but I have been crashing for several days on an apparently very simple problem. So, for once, I ask the question...
We all know about multiple cell selection. We click on a first and, by adding the keys [Ctrl] or [Shift] we have several blocks of cells selected, contiguous or not.
Reading if one or more selections have been made is very easy; it’s already mentioned here.
Depending on the case, we can access to the selected cells perfectly. But we are talking here about ALREADY EXISTING visual selections. Do a visual selection of a single cell or block of cells is very simple as well:
Code: Select all
thisComponent.currentController.select(mySheet.getCellRangeByName("$A$7")
' or ...
thisComponent.currentController.select(mySheet.getCellRangeByName("$B20:$B$21")
Thanks for this reading!