get the selected Cell in a range (Calc)

Hello,

If i mark a cell-range by mouse, then i can get this range
by StarBasic
for example with:

range = ThisComponent.getCurrentSelection


But how can i get the 'active' cell in this range by
StarBasic?


In other words: in calc exists two 'types' of
cell-selection:

(1) the cell ist selected (in german:
"ausgewählt")
  (a) only (temporary) black border
  (b) in a range: black background and (temporary) white
border

(2) the cell is marked (in german: "markiert")
 --> only black background


What i need (by StarBasic) is (1)-(b).
It is in all cases (single or multiple cellrange) only one
cell.



greetings,

Jörg

------------------------------------------------------------
---------
To unsubscribe, e-mail: dev-unsubscribeapi.openoffice.org
For additional commands, e-mail: dev-helpapi.openoffice.org

Download AndrewMacro.odt

I demonstrate how to obtain the active cell.

Jörg Schmidt wrote:
> Hello,
>
> If i mark a cell-range by mouse, then i can get this
range by StarBasic
> for example with:
>
> range = ThisComponent.getCurrentSelection
>
>
> But how can i get the 'active' cell in this range by
StarBasic?
>
>
> In other words: in calc exists two 'types' of
cell-selection:
>
> (1) the cell ist selected (in german:
"ausgewählt")
>   (a) only (temporary) black border
>   (b) in a range: black background and (temporary)
white border
>
> (2) the cell is marked (in german:
"markiert")
>  --> only black background
>
>
> What i need (by StarBasic) is (1)-(b).
> It is in all cases (single or multiple cellrange) only
one cell.
>
>
>
> greetings,
>
> Jörg
>
>
------------------------------------------------------------
---------
> To unsubscribe, e-mail: dev-unsubscribeapi.openoffice.org
> For additional commands, e-mail: dev-helpapi.openoffice.org
>
>   

-- 
Andrew Pitonyak
My Macro Document: http://www.pi
tonyak.org/AndrewMacro.odt
My Book: http://w
ww.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.or
g/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html

------------------------------------------------------------
---------
To unsubscribe, e-mail: dev-unsubscribeapi.openoffice.org
For additional commands, e-mail: dev-helpapi.openoffice.org