Microsoft .NET Framework versions

The versions of Microsoft .NET can be determined using the release number found in the registry at this location:

[HKLM\SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\Full]
Release=
.NET Versions Release Version
378389 4.5
378681 4.5.1 Preview
378675 378758 4.5.1
379893 4.5.2
381029 393223 393273 393289 4.6 Preview
393295 393297 4.6
394254 394271 4.6.1
394747 394748 394800 4.6.2 Preview
394802 394806 4.6.2
460798 460805 4.7
461283 461290 4.7.1 Preview
461308 461310 4.7.1
461808 461814 4.7.2
528040 528049 528372 4.8
528449 4.8.x Insider

Found more? Drop a comment below.

Resources

Server Core editions

Command line for Windows Server Core editions:

reg query "HKLM\SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\Full"

Additional keywords: dotnet clrver

Office: There’s not enough memory or system resources to start

Symptoms

These error messages are displayed when selecting a Word (.docx), PowerPoint (.pptx) or Excel (.xlsx) file in the Windows Explorer preview pane:

  • There’s not enough memory or system resources to start PowerPoint
  • There’s not enough memory or system resources to start Word
  • Excel displays an error message with a red cross icon ❌ and no text

Solution

This happens when the 32-bit version of Microsoft Office is installed after having uninstalled the 64-bit version. This leaves references in the registry to the 64-bit Preview Handlers.

To fix these errors and repair the preview pane, run Regedit as administrator and delete these registry keys:

Microsoft Excel previewer

HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID{00020827-0000-0000-C000-000000000046}

Microsoft PowerPoint previewer

HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID{65235197-874B-4A07-BDC5-E65EA825B718}

Microsoft Word previewer

HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID{84F66100-FF7C-4fb4-B0C0-02CD7FB668FE}

Microsoft Visio previewer

HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID{21E17C2F-AD3A-4b89-841F-09CFE02D16B7}

Important

A logoff/logon or reboot is required.

Convertir les tables MyISAM en InnoDB

Chez les hébergeurs mutualisés, comme Infomaniak, les serveurs de base de données MySQL/MariaDB sont souvent configuré pour créer des tables au format MyISAM par défaut, mais le format de table InnoDB est préférable.

Il est possible de les convertir manuellement en 2 étapes (testé avec WordPress et LimeSurvey).

1. Lister les tables MyISAM

Remplacer database par le nom de la base de données (schema):

select concat(
  'alter table `', table_name, '` engine=InnoDB;')
  as sql_statements
from information_schema.tables
  as tb
where table_schema = 'database'
  and engine = 'MyISAM'
  and table_type = 'BASE TABLE';

2. Exécuter la query générée précédemment

Note qu’avec phpMyAdmin il faut d’abord cliquer sur Options et sélectionner Full Texts.

SQL reserved words

Liste des mots réservés du langage SQL

A

a, abort, abs, absolute, access, action, ada, add, admin, after, aggregate, alias, all, allocate, also, alter, always, analyse, analyze, and, any, are, array, as, asc, asensitive, assertion, assignment, asymmetric, at, atomic, attribute, attributes, audit, authorization, auto_increment, avg, avg_row_length

B

backup, backward, before, begin, bernoulli, between, bigint, binary, bit, bit_length, bitvar, blob, bool, boolean, both, breadth, break, browse, bulk, by

C

c, cache, call, called, cardinality, cascade, cascaded, case, cast, catalog, catalog_name, ceil, ceiling, chain, change, char, char_length, character, character_length, character_set_catalog, character_set_name, character_set_schema, characteristics, characters, check, checked, checkpoint, checksum, class, class_origin, clob, close, cluster, clustered, coalesce, cobol, collate, collation, collation_catalog, collation_name, collation_schema, collect, column, column_name, columns, command_function, command_function_code, comment, commit, committed, completion, compress, compute, condition, condition_number, connect, connection, connection_name, constraint, constraint_catalog, constraint_name, constraint_schema, constraints, constructor, contains, containstable, continue, conversion, convert, copy, corr, corresponding, count, covar_pop, covar_samp, create, createdb, createrole, createuser, cross, csv, cube, cume_dist, current, current_date, current_default_transform_group, current_path, current_role, current_time, current_timestamp, current_transform_group_for_type, current_user, cursor, cursor_name, cycle

D

data, database, databases, date, datetime, datetime_interval_code, datetime_interval_precision, day, day_hour, day_microsecond, day_minute, day_second, dayofmonth, dayofweek, dayofyear, dbcc, deallocate, dec, decimal, declare, default, defaults, deferrable, deferred, defined, definer, degree, delay_key_write, delayed, delete, delimiter, delimiters, dense_rank, deny, depth, deref, derived, desc, describe, descriptor, destroy, destructor, deterministic, diagnostics, dictionary, disable, disconnect, disk, dispatch, distinct, distinctrow, distributed, div, do, domain, double, drop, dual, dummy, dump, dynamic, dynamic_function, dynamic_function_code

E

each, element, else, elseif, enable, enclosed, encoding, encrypted, end, end-exec, enum, equals, errlvl, escape, escaped, every, except, exception, exclude, excluding, exclusive, exec, execute, existing, exists, exit, exp, explain, external, extract

F

false, fetch, fields, file, fillfactor, filter, final, first, float, float4, float8, floor, flush, following, for, force, foreign, fortran, forward, found, free, freetext, freetexttable, freeze, from, full, fulltext, function, fusion

G

g, general, generated, get, global, go, goto, grant, granted, grants, greatest, group, grouping

H

handler, having, header, heap, hierarchy, high_priority, hold, holdlock, host, hosts, hour, hour_microsecond, hour_minute, hour_second

I

identified, identity, identity_insert, identitycol, if, ignore, ilike, immediate, immutable, implementation, implicit, in, include, including, increment, index, indicator, infile, infix, inherit, inherits, initial, initialize, initially, inner, inout, input, insensitive, insert, insert_id, instance, instantiable, instead, int, int1, int2, int3, int4, int8, integer, intersect, intersection, interval, into, invoker, is, isam, isnull, isolation, iterate

J

join

K

k, key, key_member, key_type, keys, kill

L

lancompiler, language, large, last, last_insert_id, lateral, leading, least, leave, left, length, less, level, like, limit, lineno, lines, listen, ln, load, local, localtime, localtimestamp, location, locator, lock, login, logs, long, longblob, longtext, loop, low_priority, lower

M

m, map, match, matched, max, max_rows, maxextents, maxvalue, mediumblob, mediumint, mediumtext, member, merge, message_length, message_octet_length, message_text, method, middleint, min, min_rows, minus, minute, minute_microsecond, minute_second, minvalue, mlslabel, mod, mode, modifies, modify, module, month, monthname, more, move, multiset, mumps, myisam

N

name, names, national, natural, nchar, nclob, nesting, new, next, no, no_write_to_binlog, noaudit, nocheck, nocompress, nocreatedb, nocreaterole, nocreateuser, noinherit, nologin, nonclustered, none, normalize, normalized, nosuperuser, not, nothing, notify, notnull, nowait, null, nullable, nullif, nulls, number, numeric

O

object, octet_length, octets, of, off, offline, offset, offsets, oids, old, on, online, only, open, opendatasource, openquery, openrowset, openxml, operation, operator, optimize, option, optionally, options, or, order, ordering, ordinality, others, out, outer, outfile, output, over, overlaps, overlay, overriding, owner

P

pack_keys, pad, parameter, parameter_mode, parameter_name, parameter_ordinal_position, parameter_specific_catalog, parameter_specific_name, parameter_specific_schema, parameters, partial, partition, pascal, password, path, pctfree, percent, percent_rank, percentile_cont, percentile_disc, placing, plan, pli, position, postfix, power, preceding, precision, prefix, preorder, prepare, prepared, preserve, primary, print, prior, privileges, proc, procedural, procedure, process, processlist, public, purge

Q

quote

R

raid0, raiserror, range, rank, raw, read, reads, readtext, real, recheck, reconfigure, recursive, ref, references, referencing, regexp, regr_avgx, regr_avgy, regr_count, regr_intercept, regr_r2, regr_slope, regr_sxx, regr_sxy, regr_syy, reindex, relative, release, reload, rename, repeat, repeatable, replace, replication, require, reset, resignal, resource, restart, restore, restrict, result, return, returned_cardinality, returned_length, returned_octet_length, returned_sqlstate, returns, revoke, right, rlike, role, rollback, rollup, routine, routine_catalog, routine_name, routine_schema, row, row_count, row_number, rowcount, rowguidcol, rowid, rownum, rows, rule

S

save, savepoint, scale, schema, schema_name, schemas, scope, scope_catalog, scope_name, scope_schema, scroll, search, second, second_microsecond, section, security, select, self, sensitive, separator, sequence, serializable, server_name, session, session_user, set, setof, sets, setuser, share, show, shutdown, signal, similar, simple, size, smallint, some, soname, source, space, spatial, specific, specific_name, specifictype, sql, sql_big_result, sql_big_selects, sql_big_tables, sql_calc_found_rows, sql_log_off, sql_log_update, sql_low_priority_updates, sql_select_limit, sql_small_result, sql_warnings, sqlca, sqlcode, sqlerror, sqlexception, sqlstate, sqlwarning, sqrt, ssl, stable, start, starting, state, statement, static, statistics, status, stddev_pop, stddev_samp, stdin, stdout, storage, straight_join, strict, string, structure, style, subclass_origin, sublist, submultiset, substring, successful, sum, superuser, symmetric, synonym, sysdate, sysid, system, system_user

T

table, table_name, tables, tablesample, tablespace, temp, template, temporary, terminate, terminated, text, textsize, than, then, ties, time, timestamp, timezone_hour, timezone_minute, tinyblob, tinyint, tinytext, to, toast, top, top_level_count, trailing, tran, transaction, transaction_active, transactions_committed, transactions_rolled_back, transform, transforms, translate, translation, treat, trigger, trigger_catalog, trigger_name, trigger_schema, trim, true, truncate, trusted, tsequal, type

U

uescape, uid, unbounded, uncommitted, under, undo, unencrypted, union, unique, unknown, unlisten, unlock, unnamed, unnest, unsigned, until, update, updatetext, upper, usage, use, user, user_defined_type_catalog, user_defined_type_code, user_defined_type_name, user_defined_type_schema, using, utc_date, utc_time, utc_timestamp

V

vacuum, valid, validate, validator, value, values, var_pop, var_samp, varbinary, varchar, varchar2, varcharacter, variable, variables, varying, verbose, view, volatile

W

waitfor, when, whenever, where, while, width_bucket, window, with, within, without, work, write, writetext

X

x509, xor

Y

year, year_month

Z

zerofill, zone

Traduction des formules Excel français/anglais

Traduction des formules Excel en anglais et en français. Valable aussi pour LibreOffice.

NB: J’ai publié cet article en 2010. Depuis 2018 Microsoft propose un outil de traduction de fonctions multilingue: Excel – Traducteur de fonctions

Anglais / English Français / French
ABS ABS
ABSREF REFABS
ACOS ACOS
ACOSH ACOSH
ACTIVE.CELL CELLULE.ACTIVE
ADD.BAR AJOUTER.BARRE
ADD.COMMAND AJOUTER.COMMANDE
ADD.MENU AJOUTER.MENU
ADD.TOOLBAR AJOUTER.BARRE.OUTILS
ADDRESS ADRESSE
AND ET
APP.TITLE APP.TITRE
AREAS ZONES
ARGUMENT ARGUMENT
ASC ASC
ASIN ASIN
ASINH ASINH
ATAN ATAN
ATAN2 ATAN2
ATANH ATANH
AVEDEV ECART.MOYEN
AVERAGE MOYENNE
BETADIST LOI.BETA
BETAINV BETA.INVERSE
BINOMDIST LOI.BINOMIALE
CALL FONCTION.APPELANTE
CALLER CELLULE.APPELANTE
CANCEL.KEY TOUCHE.ARRET
CEILING PLAFOND
CELL CELLULE
CHAR CAR
CHECK.COMMAND COMMANDE.COCHER
CHIDIST LOI.KHIDEUX
CHIINV KHIDEUX.INVERSE
CHITEST TEST.KHIDEUX
CHOOSE CHOISIR
CLEAN EPURAGE
CODE CODE
COLUMN COLONNE
COLUMNS COLONNES
COMBIN COMBIN
CONCATENATE CONCATENER
CONFIDENCE INTERVALLE.CONFIANCE
CORREL COEFFICIENT.CORRELATION
COS COS
COSH COSH
COUNT NB
COUNTA NBVAL
COUNTBLANK NB.VIDE
COUNTIF NB.SI
COVAR COVARIANCE
CREATE.OBJECT CREER.OBJET
CRITBINOM CRITERE.LOI.BINOMIALE
CUSTOM.REPEAT REPETER.PERSONNALISE
CUSTOM.UNDO ANNULER.PERSONNALISE
DATE DATE
DATEDIF DATEDIF
DATESTRING DATESTRING
DATEVALUE DATEVAL
DAVERAGE BDMOYENNE
DAY JOUR
DAYS360 JOURS360
DB DB
DBCS DBCS
DCOUNT BDNB
DCOUNTA BDNBVAL
DDB DDB
DEGREES DEGRES
DELETE.BAR SUPPRIMER.BARRE
DELETE.COMMAND SUPPRIMER.COMMANDE
DELETE.MENU SUPPRIMER.MENU
DELETE.TOOLBAR SUPPRIMER.BARRE.OUTILS
DEREF DEREF
DEVSQ SOMME.CARRES.ECARTS
DGET BDLIRE
DIALOG.BOX ZONE.DE.DIALOGUE
DIRECTORY REPERTOIRE
DMAX BDMAX
DMIN BDMIN
DOCUMENTS DOCUMENTS
DOLLAR FRANC
DPRODUCT BDPRODUIT
DSTDEV BDECARTYPE
DSTDEVP BDECARTYPEP
DSUM BDSOMME
DVAR BDVAR
DVARP BDVARP
ECHO ECRAN
ENABLE.COMMAND COMMANDE.ACTIVER
ENABLE.TOOL ACTIVER.OUTIL
ERROR ERREUR
ERROR.TYPE TYPE.ERREUR
EVALUATE EVALUER
EVEN PAIR
EXACT EXACT
EXEC LANCER
EXECUTE EXEC
EXP EXP
EXPONDIST LOI.EXPONENTIELLE
FACT FACT
FCLOSE F.FERMER
FDIST LOI.F
FILES FICHIERS
FIND TROUVE
FINDB FINDB
FINV INVERSE.LOI.F
FISHER FISHER
FISHERINV FISHER.INVERSE
FIXED CTXT
FLOOR PLANCHER
FOPEN F.OUVRIR
FORECAST PREVISION
FORMULA.CONVERT CONVERSION.FORMULE
FPOS F.POSITION
FREAD F.LIRE
FREADLN F.LIRE.LIGNE
FREQUENCY FREQUENCE
FSIZE F.DIMENSION
FTEST TEST.F
FV VC
FWRITE F.ECRIRE
FWRITELN F.ECRIRE.LIGNE
GAMMADIST LOI.GAMMA
GAMMAINV LOI.GAMMA.INVERSE
GAMMALN LNGAMMA
GEOMEAN MOYENNE.GEOMETRIQUE
GET.BAR LIRE.BARRE
GET.CELL LIRE.CELLULE
GET.CHART.ITEM LIRE.ELEMENT.GRAPHIQUE
GET.DEF LIRE.DEF
GET.DOCUMENT LIRE.DOCUMENT
GET.FORMULA LIRE.FORMULE
GET.LINK.INFO LIRE.INFO.LIAISON
GET.MOVIE LIRE.ANIMATION
GET.NAME LIRE.NOM
GET.NOTE LIRE.COMMENTAIRES
GET.OBJECT LIRE.OBJET
GET.PIVOT.FIELD LIRE.CHAMP.DYNAMIQUE
GET.PIVOT.ITEM LIRE.ELEMENT.TABCROIS.DYNAMIQUE
GET.PIVOT.TABLE LIRE.TABLEAU.CROISE.DYNAMIQUE
GET.TOOL LIRE.OUTIL
GET.TOOLBAR LIRE.BARRE.OUTILS
GET.WINDOW LIRE.FENETRE
GET.WORKBOOK LIRE.CLASSEUR
GET.WORKSPACE LIRE.ENV
GOTO ATTEINDRE
GROUP GROUPER
GROWTH CROISSANCE
HALT ARRETER
HARMEAN MOYENNE.HARMONIQUE
HELP AIDE
HLOOKUP RECHERCHEH
HOUR HEURE
HYPGEOMDIST LOI.HYPERGEOMETRIQUE
IF SI
INDEX INDEX
INDIRECT INDIRECT
INFO INFO
INITIATE ACCEDER
INPUT ENTRER
INT ENT
INTERCEPT ORDONNEE.ORIGINE
IPMT INTPER
IRR TRI
ISBLANK ESTVIDE
ISERR ESTERR
ISERROR ESTERREUR
ISLOGICAL ESTLOGIQUE
ISNA ESTNA
ISNONTEXT ESTNONTEXTE
ISNUMBER ESTNUM
ISPMT ISPMT
ISREF ESTREF
ISTEXT ESTTEXTE
KURT KURTOSIS
LARGE GRANDE.VALEUR
LAST.ERROR DERNIERE.ERREUR
LEFT GAUCHE
LEFTB LEFTB
LEN NBCAR
LENB LENB
LINEST DROITEREG
LINKS LIAISONS
LN LN
LOG LOG
LOG10 LOG10
LOGEST LOGREG
LOGINV LOI.LOGNORMALE.INVERSE
LOGNORMDIST LOI.LOGNORMALE
LOOKUP RECHERCHE
LOWER MINUSCULE
MATCH EQUIV
MAX MAX
MDETERM DETERMAT
MEDIAN MEDIANE
MID STXT
MIDB MIDB
MIN MIN
MINUTE MINUTE
MINVERSE INVERSEMAT
MIRR TRIM
MMULT PRODUITMAT
MOD MOD
MODE MODE
MONTH MOIS
MOVIE.COMMAND COMMANDE.ANIMATION
N N
NA NA
NAMES NOMS
NEGBINOMDIST LOI.BINOMIALE.NEG
NORMDIST LOI.NORMALE
NORMINV LOI.NORMALE.INVERSE
NORMSDIST LOI.NORMALE.STANDARD
NORMSINV LOI.NORMALE.STANDARD.INVERSE
NOT NON
NOTE COMMENTAIRES
NOW MAINTENANT
NPER NPM
NPV VAN
NUMBERSTRING NUMBERSTRING
ODD IMPAIR
OFFSET DECALER
OPEN.DIALOG OUVRIR.DIALOGUE
OPTIONS.LISTS.GET LIRE.LISTES.PERSONNELLES
OR OU
PAUSE PAUSE
PEARSON PEARSON
PERCENTILE CENTILE
PERCENTRANK RANG.POURCENTAGE
PERMUT PERMUTATION
PI PI
PIVOT.ADD.DATA AJOUTER.DONNEES.TABLEAU.CROISE
PMT VPM
POISSON LOI.POISSON
POKE POINT
POWER PUISSANCE
PPMT PRINCPER
PRESS.TOOL ENFONCER.OUTIL
PROB PROBABILITE
PRODUCT PRODUIT
PROPER NOMPROPRE
PV VA
QUARTILE QUARTILE
RADIANS RADIANS
RAND ALEA
RANK RANG
RATE TAUX
REFTEXT TEXTEREF
REGISTER REGISTRE
REGISTER.ID REGISTRE.NUMERO
RELREF REFREL
RENAME.COMMAND COMMANDE.RENOMMER
REPLACE REMPLACER
REPLACEB REPLACEB
REPT REPT
REQUEST REQUETE
RESET.TOOLBAR RETABLIR.BARRE.OUTILS
RESTART RECOMMENCER
RESULT RESULTAT
RESUME REPRISE
RIGHT DROITE
RIGHTB RIGHTB
ROMAN ROMAIN
ROUND ARRONDI
ROUNDDOWN ARRONDI.INF
ROUNDUP ARRONDI.SUP
ROW LIGNE
ROWS LIGNES
RSQ COEFFICIENT.DETERMINATION
SAVE.DIALOG ENREGISTRER.DIALOGUE
SAVE.TOOLBAR ENREGISTRER.BARRE.OUTILS
SCENARIO.GET LIRE.SCENARIO
SEARCH CHERCHE
SEARCHB SEARCHB
SECOND SECONDE
SELECTION SELECTION
SERIES SERIE
SET.NAME POSER.NOM
SET.VALUE POSER.VALEUR
SHOW.BAR AFFICHER.BARRE
SIGN SIGNE
SIN SIN
SINH SINH
SKEW COEFFICIENT.ASYMETRIE
SLN AMORLIN
SLOPE PENTE
SMALL PETITE.VALEUR
SPELLING.CHECK VERIFIER.ORTHOGRAPHE
SQRT RACINE
STANDARDIZE CENTREE.REDUITE
STDEV ECARTYPE
STDEVP ECARTYPEP
STEP PAS.A.PAS
STEYX ERREUR.TYPE.XY
SUBSTITUTE SUBSTITUE
SUBTOTAL SOUS.TOTAL
SUM SOMME
SUMIF SOMME.SI
SUMPRODUCT SOMMEPROD
SUMSQ SOMME.CARRES
SUMX2MY2 SOMME.X2MY2
SUMX2PY2 SOMME.X2PY2
SUMXMY2 SOMME.XMY2
SYD SYD
T T
TAN TAN
TANH TANH
TDIST LOI.STUDENT
TERMINATE TERMINER
TEXT TEXTE
TEXT.BOX ZONE.TEXTE
TEXTREF REFTEXTE
TIME TEMPS
TIMEVALUE TEMPSVAL
TINV LOI.STUDENT.INVERSE
TODAY AUJOURDHUI
TRANSPOSE TRANSPOSE
TREND TENDANCE
TRIM SUPPRESPACE
TRIMMEAN MOYENNE.REDUITE
TRUNC TRONQUE
TTEST TEST.STUDENT
TYPE TYPE
UNREGISTER SUPPRIMER.REGISTRE
UPPER MAJUSCULE
USDOLLAR USDOLLAR
VALUE CNUM
VAR VAR
VARP VAR.P
VDB VDB
VLOOKUP RECHERCHEV
VOLATILE VOLATILE
WEEKDAY JOURSEM
WEIBULL LOI.WEIBULL
WINDOW.TITLE TITRE.FENETRE
WINDOWS FENETRES
YEAR ANNEE
ZTEST TEST.Z