Autoría | Ultima modificación | Ver Log |
################################################################ PhpSpreadsheet - function name translations#### Français (French)################################################################## Fonctions Cube (Cube Functions)##CUBEKPIMEMBER = MEMBREKPICUBECUBEMEMBER = MEMBRECUBECUBEMEMBERPROPERTY = PROPRIETEMEMBRECUBECUBERANKEDMEMBER = RANGMEMBRECUBECUBESET = JEUCUBECUBESETCOUNT = NBJEUCUBECUBEVALUE = VALEURCUBE#### Fonctions de base de données (Database Functions)##DAVERAGE = BDMOYENNEDCOUNT = BDNBDCOUNTA = BDNBVALDGET = BDLIREDMAX = BDMAXDMIN = BDMINDPRODUCT = BDPRODUITDSTDEV = BDECARTYPEDSTDEVP = BDECARTYPEPDSUM = BDSOMMEDVAR = BDVARDVARP = BDVARP#### Fonctions de date et d’heure (Date & Time Functions)##DATE = DATEDATEVALUE = DATEVALDAY = JOURDAYS = JOURSDAYS360 = JOURS360EDATE = MOIS.DECALEREOMONTH = FIN.MOISHOUR = HEUREISOWEEKNUM = NO.SEMAINE.ISOMINUTE = MINUTEMONTH = MOISNETWORKDAYS = NB.JOURS.OUVRESNETWORKDAYS.INTL = NB.JOURS.OUVRES.INTLNOW = MAINTENANTSECOND = SECONDETIME = TEMPSTIMEVALUE = TEMPSVALTODAY = AUJOURDHUIWEEKDAY = JOURSEMWEEKNUM = NO.SEMAINEWORKDAY = SERIE.JOUR.OUVREWORKDAY.INTL = SERIE.JOUR.OUVRE.INTLYEAR = ANNEEYEARFRAC = FRACTION.ANNEE#### Fonctions d’ingénierie (Engineering Functions)##BESSELI = BESSELIBESSELJ = BESSELJBESSELK = BESSELKBESSELY = BESSELYBIN2DEC = BINDECBIN2HEX = BINHEXBIN2OCT = BINOCTBITAND = BITETBITLSHIFT = BITDECALGBITOR = BITOUBITRSHIFT = BITDECALDBITXOR = BITOUEXCLUSIFCOMPLEX = COMPLEXECONVERT = CONVERTDEC2BIN = DECBINDEC2HEX = DECHEXDEC2OCT = DECOCTDELTA = DELTAERF = ERFERF.PRECISE = ERF.PRECISERFC = ERFCERFC.PRECISE = ERFC.PRECISGESTEP = SUP.SEUILHEX2BIN = HEXBINHEX2DEC = HEXDECHEX2OCT = HEXOCTIMABS = COMPLEXE.MODULEIMAGINARY = COMPLEXE.IMAGINAIREIMARGUMENT = COMPLEXE.ARGUMENTIMCONJUGATE = COMPLEXE.CONJUGUEIMCOS = COMPLEXE.COSIMCOSH = COMPLEXE.COSHIMCOT = COMPLEXE.COTIMCSC = COMPLEXE.CSCIMCSCH = COMPLEXE.CSCHIMDIV = COMPLEXE.DIVIMEXP = COMPLEXE.EXPIMLN = COMPLEXE.LNIMLOG10 = COMPLEXE.LOG10IMLOG2 = COMPLEXE.LOG2IMPOWER = COMPLEXE.PUISSANCEIMPRODUCT = COMPLEXE.PRODUITIMREAL = COMPLEXE.REELIMSEC = COMPLEXE.SECIMSECH = COMPLEXE.SECHIMSIN = COMPLEXE.SINIMSINH = COMPLEXE.SINHIMSQRT = COMPLEXE.RACINEIMSUB = COMPLEXE.DIFFERENCEIMSUM = COMPLEXE.SOMMEIMTAN = COMPLEXE.TANOCT2BIN = OCTBINOCT2DEC = OCTDECOCT2HEX = OCTHEX#### Fonctions financières (Financial Functions)##ACCRINT = INTERET.ACCACCRINTM = INTERET.ACC.MATAMORDEGRC = AMORDEGRCAMORLINC = AMORLINCCOUPDAYBS = NB.JOURS.COUPON.PRECCOUPDAYS = NB.JOURS.COUPONSCOUPDAYSNC = NB.JOURS.COUPON.SUIVCOUPNCD = DATE.COUPON.SUIVCOUPNUM = NB.COUPONSCOUPPCD = DATE.COUPON.PRECCUMIPMT = CUMUL.INTERCUMPRINC = CUMUL.PRINCPERDB = DBDDB = DDBDISC = TAUX.ESCOMPTEDOLLARDE = PRIX.DECDOLLARFR = PRIX.FRACDURATION = DUREEEFFECT = TAUX.EFFECTIFFV = VCFVSCHEDULE = VC.PAIEMENTSINTRATE = TAUX.INTERETIPMT = INTPERIRR = TRIISPMT = ISPMTMDURATION = DUREE.MODIFIEEMIRR = TRIMNOMINAL = TAUX.NOMINALNPER = NPMNPV = VANODDFPRICE = PRIX.PCOUPON.IRREGODDFYIELD = REND.PCOUPON.IRREGODDLPRICE = PRIX.DCOUPON.IRREGODDLYIELD = REND.DCOUPON.IRREGPDURATION = PDUREEPMT = VPMPPMT = PRINCPERPRICE = PRIX.TITREPRICEDISC = VALEUR.ENCAISSEMENTPRICEMAT = PRIX.TITRE.ECHEANCEPV = VARATE = TAUXRECEIVED = VALEUR.NOMINALERRI = TAUX.INT.EQUIVSLN = AMORLINSYD = SYDTBILLEQ = TAUX.ESCOMPTE.RTBILLPRICE = PRIX.BON.TRESORTBILLYIELD = RENDEMENT.BON.TRESORVDB = VDBXIRR = TRI.PAIEMENTSXNPV = VAN.PAIEMENTSYIELD = RENDEMENT.TITREYIELDDISC = RENDEMENT.SIMPLEYIELDMAT = RENDEMENT.TITRE.ECHEANCE#### Fonctions d’information (Information Functions)##CELL = CELLULEERROR.TYPE = TYPE.ERREURINFO = INFORMATIONSISBLANK = ESTVIDEISERR = ESTERRISERROR = ESTERREURISEVEN = EST.PAIRISFORMULA = ESTFORMULEISLOGICAL = ESTLOGIQUEISNA = ESTNAISNONTEXT = ESTNONTEXTEISNUMBER = ESTNUMISODD = EST.IMPAIRISREF = ESTREFISTEXT = ESTTEXTEN = NNA = NASHEET = FEUILLESHEETS = FEUILLESTYPE = TYPE#### Fonctions logiques (Logical Functions)##AND = ETFALSE = FAUXIF = SIIFERROR = SIERREURIFNA = SI.NON.DISPIFS = SI.CONDITIONSNOT = NONOR = OUSWITCH = SI.MULTIPLETRUE = VRAIXOR = OUX#### Fonctions de recherche et de référence (Lookup & Reference Functions)##ADDRESS = ADRESSEAREAS = ZONESCHOOSE = CHOISIRCOLUMN = COLONNECOLUMNS = COLONNESFORMULATEXT = FORMULETEXTEGETPIVOTDATA = LIREDONNEESTABCROISDYNAMIQUEHLOOKUP = RECHERCHEHHYPERLINK = LIEN_HYPERTEXTEINDEX = INDEXINDIRECT = INDIRECTLOOKUP = RECHERCHEMATCH = EQUIVOFFSET = DECALERROW = LIGNEROWS = LIGNESRTD = RTDTRANSPOSE = TRANSPOSEVLOOKUP = RECHERCHEV*RC = LC#### Fonctions mathématiques et trigonométriques (Math & Trig Functions)##ABS = ABSACOS = ACOSACOSH = ACOSHACOT = ACOTACOTH = ACOTHAGGREGATE = AGREGATARABIC = CHIFFRE.ARABEASIN = ASINASINH = ASINHATAN = ATANATAN2 = ATAN2ATANH = ATANHBASE = BASECEILING.MATH = PLAFOND.MATHCEILING.PRECISE = PLAFOND.PRECISCOMBIN = COMBINCOMBINA = COMBINACOS = COSCOSH = COSHCOT = COTCOTH = COTHCSC = CSCCSCH = CSCHDECIMAL = DECIMALDEGREES = DEGRESECMA.CEILING = ECMA.PLAFONDEVEN = PAIREXP = EXPFACT = FACTFACTDOUBLE = FACTDOUBLEFLOOR.MATH = PLANCHER.MATHFLOOR.PRECISE = PLANCHER.PRECISGCD = PGCDINT = ENTISO.CEILING = ISO.PLAFONDLCM = PPCMLN = LNLOG = LOGLOG10 = LOG10MDETERM = DETERMATMINVERSE = INVERSEMATMMULT = PRODUITMATMOD = MODMROUND = ARRONDI.AU.MULTIPLEMULTINOMIAL = MULTINOMIALEMUNIT = MATRICE.UNITAIREODD = IMPAIRPI = PIPOWER = PUISSANCEPRODUCT = PRODUITQUOTIENT = QUOTIENTRADIANS = RADIANSRAND = ALEARANDBETWEEN = ALEA.ENTRE.BORNESROMAN = ROMAINROUND = ARRONDIROUNDDOWN = ARRONDI.INFROUNDUP = ARRONDI.SUPSEC = SECSECH = SECHSERIESSUM = SOMME.SERIESSIGN = SIGNESIN = SINSINH = SINHSQRT = RACINESQRTPI = RACINE.PISUBTOTAL = SOUS.TOTALSUM = SOMMESUMIF = SOMME.SISUMIFS = SOMME.SI.ENSSUMPRODUCT = SOMMEPRODSUMSQ = SOMME.CARRESSUMX2MY2 = SOMME.X2MY2SUMX2PY2 = SOMME.X2PY2SUMXMY2 = SOMME.XMY2TAN = TANTANH = TANHTRUNC = TRONQUE#### Fonctions statistiques (Statistical Functions)##AVEDEV = ECART.MOYENAVERAGE = MOYENNEAVERAGEA = AVERAGEAAVERAGEIF = MOYENNE.SIAVERAGEIFS = MOYENNE.SI.ENSBETA.DIST = LOI.BETA.NBETA.INV = BETA.INVERSE.NBINOM.DIST = LOI.BINOMIALE.NBINOM.DIST.RANGE = LOI.BINOMIALE.SERIEBINOM.INV = LOI.BINOMIALE.INVERSECHISQ.DIST = LOI.KHIDEUX.NCHISQ.DIST.RT = LOI.KHIDEUX.DROITECHISQ.INV = LOI.KHIDEUX.INVERSECHISQ.INV.RT = LOI.KHIDEUX.INVERSE.DROITECHISQ.TEST = CHISQ.TESTCONFIDENCE.NORM = INTERVALLE.CONFIANCE.NORMALCONFIDENCE.T = INTERVALLE.CONFIANCE.STUDENTCORREL = COEFFICIENT.CORRELATIONCOUNT = NBCOUNTA = NBVALCOUNTBLANK = NB.VIDECOUNTIF = NB.SICOUNTIFS = NB.SI.ENSCOVARIANCE.P = COVARIANCE.PEARSONCOVARIANCE.S = COVARIANCE.STANDARDDEVSQ = SOMME.CARRES.ECARTSEXPON.DIST = LOI.EXPONENTIELLE.NF.DIST = LOI.F.NF.DIST.RT = LOI.F.DROITEF.INV = INVERSE.LOI.F.NF.INV.RT = INVERSE.LOI.F.DROITEF.TEST = F.TESTFISHER = FISHERFISHERINV = FISHER.INVERSEFORECAST.ETS = PREVISION.ETSFORECAST.ETS.CONFINT = PREVISION.ETS.CONFINTFORECAST.ETS.SEASONALITY = PREVISION.ETS.CARACTERESAISONNIERFORECAST.ETS.STAT = PREVISION.ETS.STATFORECAST.LINEAR = PREVISION.LINEAIREFREQUENCY = FREQUENCEGAMMA = GAMMAGAMMA.DIST = LOI.GAMMA.NGAMMA.INV = LOI.GAMMA.INVERSE.NGAMMALN = LNGAMMAGAMMALN.PRECISE = LNGAMMA.PRECISGAUSS = GAUSSGEOMEAN = MOYENNE.GEOMETRIQUEGROWTH = CROISSANCEHARMEAN = MOYENNE.HARMONIQUEHYPGEOM.DIST = LOI.HYPERGEOMETRIQUE.NINTERCEPT = ORDONNEE.ORIGINEKURT = KURTOSISLARGE = GRANDE.VALEURLINEST = DROITEREGLOGEST = LOGREGLOGNORM.DIST = LOI.LOGNORMALE.NLOGNORM.INV = LOI.LOGNORMALE.INVERSE.NMAX = MAXMAXA = MAXAMAXIFS = MAX.SIMEDIAN = MEDIANEMIN = MINMINA = MINAMINIFS = MIN.SIMODE.MULT = MODE.MULTIPLEMODE.SNGL = MODE.SIMPLENEGBINOM.DIST = LOI.BINOMIALE.NEG.NNORM.DIST = LOI.NORMALE.NNORM.INV = LOI.NORMALE.INVERSE.NNORM.S.DIST = LOI.NORMALE.STANDARD.NNORM.S.INV = LOI.NORMALE.STANDARD.INVERSE.NPEARSON = PEARSONPERCENTILE.EXC = CENTILE.EXCLUREPERCENTILE.INC = CENTILE.INCLUREPERCENTRANK.EXC = RANG.POURCENTAGE.EXCLUREPERCENTRANK.INC = RANG.POURCENTAGE.INCLUREPERMUT = PERMUTATIONPERMUTATIONA = PERMUTATIONAPHI = PHIPOISSON.DIST = LOI.POISSON.NPROB = PROBABILITEQUARTILE.EXC = QUARTILE.EXCLUREQUARTILE.INC = QUARTILE.INCLURERANK.AVG = MOYENNE.RANGRANK.EQ = EQUATION.RANGRSQ = COEFFICIENT.DETERMINATIONSKEW = COEFFICIENT.ASYMETRIESKEW.P = COEFFICIENT.ASYMETRIE.PSLOPE = PENTESMALL = PETITE.VALEURSTANDARDIZE = CENTREE.REDUITESTDEV.P = ECARTYPE.PEARSONSTDEV.S = ECARTYPE.STANDARDSTDEVA = STDEVASTDEVPA = STDEVPASTEYX = ERREUR.TYPE.XYT.DIST = LOI.STUDENT.NT.DIST.2T = LOI.STUDENT.BILATERALET.DIST.RT = LOI.STUDENT.DROITET.INV = LOI.STUDENT.INVERSE.NT.INV.2T = LOI.STUDENT.INVERSE.BILATERALET.TEST = T.TESTTREND = TENDANCETRIMMEAN = MOYENNE.REDUITEVAR.P = VAR.P.NVAR.S = VAR.SVARA = VARAVARPA = VARPAWEIBULL.DIST = LOI.WEIBULL.NZ.TEST = Z.TEST#### Fonctions de texte (Text Functions)##BAHTTEXT = BAHTTEXTCHAR = CARCLEAN = EPURAGECODE = CODECONCAT = CONCATDOLLAR = DEVISEEXACT = EXACTFIND = TROUVEFIXED = CTXTLEFT = GAUCHELEN = NBCARLOWER = MINUSCULEMID = STXTNUMBERVALUE = VALEURNOMBREPHONETIC = PHONETIQUEPROPER = NOMPROPREREPLACE = REMPLACERREPT = REPTRIGHT = DROITESEARCH = CHERCHESUBSTITUTE = SUBSTITUET = TTEXT = TEXTETEXTJOIN = JOINDRE.TEXTETRIM = SUPPRESPACEUNICHAR = UNICARUNICODE = UNICODEUPPER = MAJUSCULEVALUE = CNUM#### Fonctions web (Web Functions)##ENCODEURL = URLENCODAGEFILTERXML = FILTRE.XMLWEBSERVICE = SERVICEWEB#### Fonctions de compatibilité (Compatibility Functions)##BETADIST = LOI.BETABETAINV = BETA.INVERSEBINOMDIST = LOI.BINOMIALECEILING = PLAFONDCHIDIST = LOI.KHIDEUXCHIINV = KHIDEUX.INVERSECHITEST = TEST.KHIDEUXCONCATENATE = CONCATENERCONFIDENCE = INTERVALLE.CONFIANCECOVAR = COVARIANCECRITBINOM = CRITERE.LOI.BINOMIALEEXPONDIST = LOI.EXPONENTIELLEFDIST = LOI.FFINV = INVERSE.LOI.FFLOOR = PLANCHERFORECAST = PREVISIONFTEST = TEST.FGAMMADIST = LOI.GAMMAGAMMAINV = LOI.GAMMA.INVERSEHYPGEOMDIST = LOI.HYPERGEOMETRIQUELOGINV = LOI.LOGNORMALE.INVERSELOGNORMDIST = LOI.LOGNORMALEMODE = MODENEGBINOMDIST = LOI.BINOMIALE.NEGNORMDIST = LOI.NORMALENORMINV = LOI.NORMALE.INVERSENORMSDIST = LOI.NORMALE.STANDARDNORMSINV = LOI.NORMALE.STANDARD.INVERSEPERCENTILE = CENTILEPERCENTRANK = RANG.POURCENTAGEPOISSON = LOI.POISSONQUARTILE = QUARTILERANK = RANGSTDEV = ECARTYPESTDEVP = ECARTYPEPTDIST = LOI.STUDENTTINV = LOI.STUDENT.INVERSETTEST = TEST.STUDENTVAR = VARVARP = VAR.PWEIBULL = LOI.WEIBULLZTEST = TEST.Z