[Solved] Accessing the the 'active' cell

[robleyd]

I'm trying

Code: Select all   Expand viewCollapse view

cell = ThisDocument.getCurrentSelection()


And then cell is an ScCellObj

Then when I try

Code: Select all   Expand viewCollapse view

y = cell.CellAddress.Row


I get the error 'Property or method not found: CellAdress'

But I have inspected 'cell' like so

Code: Select all   Expand viewCollapse view

msgbox cell dbg_properties

And I can see a property SbxOBJECT CellAddress

[FJCC]

Are you sure you spelled CellAddress correctly? You have it misspelled twice, two different ways, in your post.

[ajotatxe]

In my code I wrote "adress". Thanks.

[Villeroy]

viewtopic.php?f=20&t=86922&p=406973#p406973 gets the active cell of a view even when a range, multiple ranges or shapes are selected.

[ajotatxe]

https://forum.openoffice.org/en/forum/viewtopic.php?f=20&t=86922&p=406973#p406973 gets the active cell of a view even when a range, multiple ranges or shapes are selected.

Nice solution, but how could one figure out about this 'ViewData' property and its structure and meaning? I have searched but in the API Reference it only says that
"set special view state
Data to set a special view state after loading. The type depends on the component and is usually retrieved from a ::com::sun::star::frame::Controller object by its ::com::sun::star::frame::XController interface. Default is: no view data."

[Villeroy]

No macro coding without object inspection tool.
MRI tutorial
The XRay tool

In 99% of all use cases you want the active cell in ThisComponent's active window: oCell = getActiveCell(ThisComponent.getCurrentController())