Accueil Fonctions Calc Menu Basic EDI OOo 1.x EDI OOo 2.x EDI LibO - OOo 3.x Affectation touche Affectation icône Etape par étape Macro débutant Fonctions Basic Dialogues OOo1-2 Dialogues LibO-OOo3 Quelques exemples Exemples dialogue Fonctions perso Définitions Recherche sur site


FONCTIONS BASIC

 

 

Texte Asc, Chr, Format, InStr, Join, LCase, Left, Len, Lset, LTrim, Mid, Rem, Right, Rset, RTrim, Space, Split, Str, StrComp, String, Trim, Ucase, Val
Dates et heures CDate, CDateFromIso, CDateToIso, Date, DateDiff, DateSerial, DateValue, Day, GetSystemTicks, Hour, Minute, Month, Now, Second, Time, Timer, TimeSerial, TimeValue, Wait, WeekDay, Year
Logiques And, Eqv, Imp, Not, Or, Xor
Mathématiques Abs, Atn, Cos, Exp, Fix, Hex, Int, Log, Mod, Oct, Randomize, Rnd, Sgn, Sin, Sqr, Tan
Ecran Blue, Green, InputBox, MsgBox, Print, QBColor, Red, RGB, TwipsPerPixelX, TwipsPerPixelY
Fichiers ChDir,ChDrive, Close, ConvertToURL, ConvertFromURL, CurDir, Dir, Eof, FileAttr, FileCopy, FileDateTime, FileExists, FileLen, FreeFile, Get, GetAttr, Input, Kill, Line Input, Loc, Lof, MkDir, Name, Open, Put, Reset, RmDir, Seek, SetAttr, Write
Variables Array, CBool, CCur, CDate, CDbl, CDec, CInt, CLng, Const, CSng, CStr, CVar, CVErr, DefBool, DefDate, DefDbl, DefInt, DefLng, DefSng, DefStr, DefObj, DefVar, DimArray, EqualUnoObjects, Dim, FindObject, FindPropertyObject, Global, HasUnoInterfaces, IsArray, IsDate, IsEmpty, IsMissing, IsNull, IsNumeric, IsObject, IsUnoStruct, LBound, Let, Option Base, Option Explicit, Optional, Public, Redim, Set, Static, Type, TypeName, UBound, VarType
Erreurs Erl, Err, Error, On Error GoTo, Resume
Divers Beep, Case, Choose, Call, CreateObject, Declare, Do.. Loop, End, Environ, Exit, For.. Next, FreeLibrary, Function, GetGuiType, GetSolarVersion, Gosub, If.. Then.. Else, Iff, Select Case, Stop, Sub, Switch, Return, While.. Wend, With
Tri alphabéthique

Abs, And, Array, Asc, Atn

Base (Option Base), Beep, Blue

Call, Case, CBool, CCur, CDate, CDateFromIso, CDateToIso, CDbl, CDec, ChDir, ChDrive, Choose, Chr, CInt, CLng, Close, Const, ConvertFromURL, ConvertToURL, Cos, CreateObject, CSng, CStr, CurDir, CVar, CVErr

Date, DateDiff, DateSerial, DateValue, Day, Declare, DefBool, DefDate, DefDbl, DefInt, DefLng, DefObj, DefSng, DefStr, DefVar, Dim, DimArray, Dir, Do.. Loop

Else (If.. Then.. Else), End, Environ, Eof, EqualUnoObjects, Eqv, Erl, Err, Error, Error (On Error GoTo), Exit, Exp, Explicit (Option Explicit)

FileAttr, FileCopy, FileDateTime, FileExists, FileLen, FindObject, FindPropertyObject, Fix, For.. Next, Format, FreeFile, FreeLibrary, Function

Get, GetAttr, GetGuiType, GetSolarVersion, GetSystemTicks, Global, Gosub, Gosub (On.. Gosub), Goto, GoTo (On Error GoTo), GoTo (On GoTo), Green

HasUnoInterfaces, Hex, Hour

If.. Then.. Else, Iff, Imp, Input, Input (Line Input), InputBox, InStr, Int, IsArray, IsDate, IsEmpty, IsMissing, IsNull, IsNumeric, IsObject, IsUnoStruct

Join

Kill

LBound, LCase, Left, Len, Let, Line Input, Loc, Lof, Log, Loop (Do.. Loop), LSet, LTrim

Mid, Minute, MkDir, Mod, Month, MsgBox

Name, Next (For.. Next), Not, Now

Oct, On Error GoTo, On.. Gosub, On.. Goto, Open, Option Base, Option Explicit, Optional, Or

Print, Public, Put

QBColor

Randomize, Red, Redim, Rem, Reset, Resume (On Error GoTo), Return, Right, RGB, RmDir, Rnd, Rset, Rtrim

Second, Seek, Select Case, Set, SetAttr, Sgn, Sin, Space, Split, Sqr, Static, Stop, Str, StrComp, String, Sub, Switch

Tan, Then (If.. Then.. Else), Time, Timer, TimeSerial, TimeValue, Trim, TwipsPerPixelX, TwipsPerPixelY, Type, TypeName

UBound, Ucase

Val, VarType

Wait, WeekDay, While.. Wend, With..End With, Write

Xor

Year



 

 


 

Ce site n'est plus mis à jour. Merci aux nombreux visiteurs depuis 2003. Consultez le Wiki LibreOffice.
   

Le tableur Calc par l'exemple : christianwtd@free.fr
Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 2.0 France License.

  .

Site optimisé pour Firefox

Dernière modification : 29/08/2010 à 18h48


Déjà plusieurs visites sur ce site depuis quelque temps (au moins vous et moi)

Compteur non certifié