RE: Calc C#CLI programming - Get the used range in a sheet - XUsedAreaCursor

Hello Niklas,

This seems to be ok:
        unoidl.com.sun.star.sheet.XSheetCellCursor
                xCursor = xSheet.createCursor();
        unoidl.com.sun.star.sheet.XUsedAreaCursor
                xUsedCursor =
(unoidl.com.sun.star.sheet.XUsedAreaCursor)xCursor;
        xUsedCursor.gotoStartOfUsedArea(true);
                xUsedCursor.gotoEndOfUsedArea(true);

But from hier how should I do the link to XCellRangeAddressable
in order to get the used area bound.

I miss someting in the access principle.

Thank's for your help.


------------------------------
Paul Veuve
vep@xxxxxxxx
------------------------------
CDI CONSEILS ET DEVELOPPEMENTS
INDUSTRIELS SA
Chemin de la Justice 15
CH-2000 NEUCHATEL
------------------------------
http://www.cdisa.ch

Phone  (+41 32) 733 31 31 
   or  (+41 78) 600 31 31

  Fax  (+41 32) 733 31 32
------------------------------
-----Message d'origine-----
De : Niklas.Nebel@xxxxxxx [mailto:Niklas.Nebel@xxxxxxx] 
Envoyé : lundi, 18. décembre 2006 09:48
À : dev@xxxxxxxxxxxxxx
Objet : Re: [dev] Calc C#CLI programming - Get the used range in a sheet -
XUsedAreaCursor

Paul Veuve wrote:
> But accessible methods for xUsedCursor in C# are only:
>       xUsedCursor.Equals()
>       xUsedCursor.GetHashCode()
>       xUsedCursor.GetType()
>       xUsedCursor.gotoStartOfUsedArea()
>       xUsedCursor.gotoEndOfUsedArea()
>       xUsedCursor.ToString()
> 
> There is no method nor property for .RangeAddress

Service SheetCellCursor includes service SheetCellRange, so you can just
query for XCellRangeAddressable interface.

Niklas

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@xxxxxxxxxxxxxx For additional
commands, e-mail: dev-help@xxxxxxxxxxxxxx

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.432 / Virus Database: 268.15.22/590 - Release Date: 16.12.2006
17:39
 

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.432 / Virus Database: 268.15.23/591 - Release Date: 17.12.2006
15:17