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

Hello Gerrit,

This is 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 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

Regards.

------------------------------
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 : Gerrit Jasper [mailto:g.jasper@xxxxxxxxxx] 
Envoyé : dimanche, 17. décembre 2006 13:02
À : dev@xxxxxxxxxxxxxx
Objet : Re: [dev] Calc C#CLI programming - Get the used range in a sheet -
XUsedAreaCursor

Paul Veuve wrote:
> Hello,
>
> This sample work nice in basic but in CLI - C#, I can not pass a cell 
> as argument in createCursorByRange() only XSheetCellRange type.
>
> ------------------------------
> Paul Veuve
> vep@xxxxxxxx
>   
Paul,

Could there be an analogy?
Something like this:

xUsedCursor.gotoStartOfUsedArea()
xUsedCursor.gotoEndOfUsedArea(True)
xAddress = xUsedCursor.RangeAddress
lastCol = xAddress.EndColumn           
lastRow = xAddress.EndRow

Sincerely,
Gerrit Jasper

---------------------------------------------------------------------
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.22/590 - Release Date: 16.12.2006
17:39