Tutorial - Tableur Calc d'OpenOffice.org par l'exemple

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