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
[EMAIL PROTECTED]
------------------------------
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:[EMAIL PROTECTED]
Envoyé : dimanche, 17. décembre 2006 13:02
À : [email protected]
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
> [EMAIL PROTECTED]
>
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: [EMAIL PROTECTED] For additional
commands, e-mail: [EMAIL PROTECTED]
--
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
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
