Re: [prog] Référence de la dernière cellule d'une feuille Calc - Laurent Godard - org.openoffice.fr.prog

10 messages in org.openoffice.fr.progRe: [prog] Référence de la dernière c...

From	Sent On	Attachments
LEJEUNE Sandrine - CETE NC/DGTI/AS	Apr 19, 2005 5:44 am
Alain Nowak	Apr 19, 2005 8:50 am
Laurent Godard	Apr 19, 2005 10:49 pm
LEJEUNE Sandrine - CETE NC/DGTI/AS	Apr 20, 2005 12:22 am
LE LOUARNE Serge	Apr 20, 2005 12:28 am
Laurent Godard	Apr 20, 2005 12:32 am
Tony GALMICHE	Apr 20, 2005 12:38 am
Laurent Godard	Apr 20, 2005 12:59 am
Bernard Marcelly	Apr 20, 2005 5:23 am
Laurent Godard	Apr 20, 2005 5:38 am

	Permalink for this message Paste this link in email or IM:
	Permalink for this thread Paste this link in email or IM:
	Atom feed for this thread Paste this URL into your reader:

Subject:	Re: [prog] Référence de la dernière cellule d'une feuille Calc	Actions...
From:	Laurent Godard (lgod...@indesko.com)
Date:	Apr 20, 2005 5:38:00 am
List:	org.openoffice.fr.prog

Bonjour Bernard,

Mais, il y a peut etre une API, à creuser ...

Oui, autour du SheetCellCursor, non décrit dans le bouquin. Solution:

Dim monDocument As Object, maFeuille As Object Dim curs1 As Object, uneCellule As Object monDocument = ThisComponent maFeuille = monDocument.Sheets(2) ' troisième feuille curs1 = maFeuille.createCursor ' curseur de cellule curs1.gotoEndOfUsedArea(False) uneCellule = curs1.getCellByPosition(0,0) uneCellule.CellBackColor = RGB(255,255,0) ' mettre en jaune

Excellent :) de la puissance des curseurs ...

Laurent

	Start a set with this search
	Include this search in one of my sets
	Exclude this search from one of my sets
	Permalink to these results Paste this link in email or IM:
	Atom feed for tracking future search results Paste this URL into your reader: