Translation status

1,536 Strings 100%
Browse Translate
25,079 Words 100%

Strings status

1,536
All strings — 25,079 words Browse Edit Zen
1,536
Translated strings — 25,079 words Browse Edit Zen
14
Translated strings with dismissed checks — 22 words Browse Edit Zen

Other components

Component Translated Untranslated Untranslated words Untranslated characters Checks Suggestions Comments
Glossary LibreOffice Help - master MPL-2.0 16% 5 8 57 0 4 0
text/sbasic/shared/03 This component is linked to the LibreOffice Help - master/auxiliary repository. MPL-2.0 35% 1,828 23,081 175,136 3 3 0
text/sdraw This component is linked to the LibreOffice Help - master/auxiliary repository. MPL-2.0 0 0 0 0 0 0
text/simpress/00 This component is linked to the LibreOffice Help - master/auxiliary repository. MPL-2.0 0 0 0 0 0 0
text/shared/autokorr This component is linked to the LibreOffice Help - master/auxiliary repository. MPL-2.0 0 0 0 0 0 0
auxiliary MPL-2.0 0 0 0 0 0 0
text/simpress/04 This component is linked to the LibreOffice Help - master/auxiliary repository. MPL-2.0 0 0 0 0 0 0
text/sbasic/python This component is linked to the LibreOffice Help - master/auxiliary repository. MPL-2.0 0 0 0 0 0 0
text/sdraw/00 This component is linked to the LibreOffice Help - master/auxiliary repository. MPL-2.0 0 0 0 0 0 0
text/shared/01 This component is linked to the LibreOffice Help - master/auxiliary repository. MPL-2.0 0 0 0 0 0 0
Browse all components

Overview

Project website www.libreoffice.org
Translation process
  • Translations can be made directly.
  • Translation suggestions can be made.
  • Any authenticated user can contribute.
  • The translation uses bilingual files.
Translation license Mozilla Public License 2.0
Filemask */helpcontent2/source/text/scalc/guide.po
Translation file Download fr/helpcontent2/source/text/scalc/guide.po
Last change Dec. 22, 2021, 4:59 p.m.
Last author sophie

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 1,536 25,079 199,645
Translated 100% 1,536 100% 25,079 100% 199,645
Needs editing 0% 0 0% 0 0% 0
Failing checks 0% 0 0% 0 0% 0
Strings with suggestions 0% 0 0% 0 0% 0
Not translated strings 0% 0 0% 0 0% 0
Last year Previous

Activity in last 12 months

2 changes 17 changes 4 changes 3 changes 12 changes 28 changes 71 changes 4 changes 13 changes 1 change 12 changes 1 change 4 changes 0 changes 0 changes 0 changes 0 changes 4 changes 2 changes 4 changes 9 changes 1 change 32 changes 90 changes
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

Quick numbers

25,079
Hosted words
1,536
Hosted strings
100%
Translated
0
Contributors
and previous 30 days

Trends of last 30 days

—
Hosted words
—
—
Hosted strings
—
—
Translated
+5%
—
Contributors
-100%
User avatar sophie

New translation

LibreOffice Help - master / text/scalc/guide — French

Wildcard comparisons are <emph>not</emph> case sensitive, hence "A?" will match both "A1" and "a1".
Les comparaisons avec caractères génériques ne sont <emph>pas</emph> sensibles à la casse, d'où "A?" correspondra à la fois à "A1" et "a1".
a month ago
User avatar sophie

Translation changed

LibreOffice Help - master / text/scalc/guide — French

<input>=SUMIF(A1:A5;"A??";B1:B5)</input> sums the values in <emph>B1:B5</emph> whose corresponding values in <emph>A1:A5</emph> start with "A" followed by exactly two other characters.
<input>=SOMME.SI(A1:A5;"A??";B1:B5)</input> additionne les valeurs dans <emph>B1:B5</emph> dont les valeurs correspondantes dans <emph>A1:A5</ emph> commence par "A" suivi d'exactement deux autres caractères.
a month ago
User avatar sophie

New translation

LibreOffice Help - master / text/scalc/guide — French

<input>=SUMIF(A1:A5;"A??";B1:B5)</input> sums the values in <emph>B1:B5</emph> whose corresponding values in <emph>A1:A5</emph> start with "A" followed by exactly two other characters.
<input>=SOMME.SI(A1:A5;"A??";B1:B5)</input> additionne les valeurs dans <emph>B1:B5</emph> dont les valeurs correspondantes dans <emph>A1:A5</ emph> commence par "A" suivi d'exactement deux autres caractères.
a month ago
User avatar sophie

New translation

LibreOffice Help - master / text/scalc/guide — French

<input>=COUNTIF(A1:A10;"Chi*")</input> counts the number of cells in the range <emph>A1:A10</emph> containing strings that start with "Chi" followed by zero or more characters.
<input>=NB.SI(A1:A10;"Chi*")</input> compte le nombre de cellules dans la plage <emph>A1:A10</emph> contenant des chaînes commençant par "Chi" suivi de zéro ou plus de caractères.
a month ago
User avatar sophie

New translation

LibreOffice Help - master / text/scalc/guide — French

The following examples consider that the options <menuitem>Enable wildcards in formulas</menuitem> and <menuitem>Search criteria = and <> must apply to whole cells</menuitem> are enabled in <switchinline select="sys"><caseinline select="MAC"><menuitem>%PRODUCTNAME - Preferences - %PRODUCTNAME Calc - Calculate</menuitem></caseinline><defaultinline><menuitem>Tools - Options - %PRODUCTNAME Calc - Calculate</menuitem></defaultinline></switchinline>.
Les exemples suivants considèrent que les options <menuitem>Activer les caractères génériques dans les formules</menuitem> et <menuitem>Critères de recherche = et <> doivent s'appliquer à des cellules entières</menuitem> sont activées dans <switchinline select="sys"><caseinline select="MAC"><menuitem>%PRODUCTNAME - Préférences - %PRODUCTNAME Calc - Calculer</menuitem></caseinline><defaultinline><menuitem>Outils - Options - %PRODUCTNAME Calc - Calculer</menuitem></defaultinline> </switchinline>.
a month ago
User avatar sophie

New translation

LibreOffice Help - master / text/scalc/guide — French

Examples of Wildcards in Formulas
Exemples de caractères génériques dans les formules
a month ago
User avatar sophie

New translation

LibreOffice Help - master / text/scalc/guide — French

<emph>Other functions:</emph> MATCH and SEARCH.
<emph>Autres fonctions : </emph>EQUIV et CHERCHE.
a month ago
User avatar sophie

New translation

LibreOffice Help - master / text/scalc/guide — French

<emph>Lookup functions:</emph> HLOOKUP, LOOKUP and VLOOKUP.
<emph>Fonctions de recherche :</emph> RECHERCHEH, RECHERCHE et RECHERCHEV
a month ago
User avatar sophie

New translation

LibreOffice Help - master / text/scalc/guide — French

<emph>Conditional functions:</emph> AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS, MAXIFS, MINIFS, SUMIF and SUMIFS.
<emph>Fonctions conditionnelles :</emph> MOYENNE.SI, MOYENNE.SI.ENS, NB.SI, NB.SI.ENS, MAX.SI, MIN.SI, SOMME.SI et SOMME.SI.ENS.
a month ago
User avatar sophie

New translation

LibreOffice Help - master / text/scalc/guide — French

<emph>Database functions:</emph> DAVERAGE, DCOUNT, DCOUNTA, DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR and DVARP.
<emph>Fonctions de base de données :</emph> BDMOYENNE, BDNB, BDNBVAL, BDLIRE, BDMAX, BDMIN, BDPRODUIT, BDECARTYPE, BDECARTYPEP, BDSOMME, BDVAR et BDVARP.
a month ago
Browse all translation changes