How to get cell Range from selected area

[makrandmane]

Hello

I am developing new Extension for open office Cal(Spreadsheet)
For that I am using Net Beans 5.5 , JDK 6.0 OpenOffice 3.0

I want to get cell rage of selected area

Scenario
If I open a new spreadsheet and select some Cell by using Mouse then I want cell Range Address for selected cells so I can access data from cell

Please tell me how to get cell Range from selected area

Thanks

[radhika_24]

Please Please can anyone help me!!!
i want to access the cells that have been currently selected by the user and then put the data in the cell adjacent to the selected cells...
I m totally lost ... last time i had a got a very prompt response from here
hope to the same soon !!! thanks a ton !!
Radhika

[vitcaro]

This example is Basic:

[radhika_24]

Thanks for that really..!
But When i print the value of RangeAddress - it says Basic Runtime error.
And can you tell me what could be the format of RangeAddress, i assume its in vector form as in 2,3 or something.
Thanks for the help
Radhika

[vitcaro]

Example of use of CellRangeAddress:

[radhika_24]

hey guys thanks a lot for the help!!!

i have compiled the code together and now if anyone needs to access the cells dynacmically according to the user's selection, can readily use this code

Sub Main
Dim oDocument As Object, oSheet As Object, oCell As Object, bCell As Object
oDocument=ThisComponent
Dim oSelection as Object
Dim oRange as Object
Dim r,c as integer
Dim oRangeAddress as New com.sun.star.table.CellRangeAddress

oDocument = StarDesktop.ActiveFrame.Controller.Model
oSheet = oDocument.CurrentController.getActiveSheet() ' get actual sheet

oSelection = oDocument.CurrentController.getSelection
oRangeAddress = oSelection.getRangeAddress ' get actual range / obtiene el rango actual

r = oRangeAddress.StartRow 'current row / la fila actual
c = oRangeAddress.StartColumn 'current column / la columna actual
oCell=oSheet.getCellByPosition(c,r)
End Sub

Enjoy,
Radhika