4 messages in org.openoffice.fr.progRe: Re: [prog] FormulaLocal et nom de...
FromSent OnAttachments
christianwtdSep 24, 2006 8:02 am 
christianwtdSep 24, 2006 8:05 am 
Manuel NAUDINSep 24, 2006 9:34 am 
christianwtdSep 24, 2006 11:48 am 
Actions with this message:
Paste this link in email or IM:
Paste this link in email or IM:
Atom feed for this thread
Paste this URL into your reader:
Subject:Re: Re: [prog] FormulaLocal et nom de fonctionActions...
From:Manuel NAUDIN (audi@gmail.com)
Date:Sep 24, 2006 9:34:39 am
List:org.openoffice.fr.prog

Bonjour, est-ce que justement FormulaLocal ne désigne pas le nom 'localisé' de la fonction ? Cela serait donc normal.

Le 24/09/06, christianwtd<chri@free.fr> a écrit :

J'espère que les listings vont mieux passer.

Listing 1 :

Sub FormulaTests Dim oDocument As Object, oSheet As Object, oCell As Object ' oDocument = ThisComponent oSheet=oDocument.Sheets.getByName("Feuille1") For i =1 to 10 oCell = oSheet.getCellByPosition(0, i) oCell.Value = i Next i oSheet.getCellByPosition(0,i).FormulaLocal = "=SOMME(A2:A11)" End Sub

et Listing 2 :

Sub FormulaTests Dim oDocument As Object, oSheet As Object, oCell As Object ' oDocument = ThisComponent oSheet=oDocument.Sheets.getByName("Feuille1") For i =1 to 10 oCell = oSheet.getCellByPosition(0, i) oCell.Value = i Next i oCell = oSheet.getCellByPosition(0, i) oCell.Formula = "=SUM(A2:A11)" End Sub

Bon surf, Christian

-- Visitez http://christianwtd.free.fr/ pour débuter avec Calc, d'OpenOffice.org

--------------------------------------------------------------------- To unsubscribe, e-mail: prog@fr.openoffice.org For additional commands, e-mail: prog@fr.openoffice.org