Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-24-2/textscalc01/fr/units/?format=api&page=152
https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/units/?format=api&page=153", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/units/?format=api&page=151", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<variable id=\"func_style_header\"><link href=\"text/scalc/01/func_style.xhp\">STYLE</link></variable> function" ], "previous_source": "", "target": [ "Fonction <variable id=\"func_style_header\"><link href=\"text/scalc/01/func_style.xhp\">STYLE</link></variable>" ], "id_hash": -1520579132033131848, "content_hash": -1520579132033131848, "location": "func_style.xhp", "context": "func_style.xhp\nhd_id321673374992325\nhelp.text", "note": "6AhEB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7551, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111182391/?format=api", "priority": 100, "id": 112282033, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=6ae5d155f64b1ab8", "url": "https://translations.documentfoundation.org/api/units/112282033/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.382341Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_VORLAGE\"><variable id=\"func_style_desc\">Applies a style to the cell containing the formula.</variable></ahelp> After a set amount of time, another style can be applied." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_VORLAGE\"><variable id=\"func_style_desc\">Applique un style à la cellule contenant la formule.</variable></ahelp> Après un certain temps, un autre style peut être appliqué." ], "id_hash": 6065142634155186855, "content_hash": 6065142634155186855, "location": "func_style.xhp", "context": "func_style.xhp\npar_id441673375101757\nhelp.text", "note": "y45sr", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7552, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/111182458/?format=api", "priority": 100, "id": 112282034, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=d42bb7175ce59aa7", "url": "https://translations.documentfoundation.org/api/units/112282034/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.385122Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "This function always returns the numeric value 0, which allows to use it by adding the <emph>STYLE</emph> function to other functions in the same cell without changing its value." ], "previous_source": "", "target": [ "Cette fonction retourne toujours la valeur numérique 0, ce qui permet de l'utiliser en ajoutant la fonction <emph>STYLE</emph> à d'autres fonctions dans la même cellule sans changer sa valeur." ], "id_hash": 1313034526901143741, "content_hash": 1313034526901143741, "location": "func_style.xhp", "context": "func_style.xhp\npar_id681673375365338\nhelp.text", "note": "GswPt", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7553, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/111182506/?format=api", "priority": 100, "id": 112282037, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=9238d5f209c408bd", "url": "https://translations.documentfoundation.org/api/units/112282037/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.390382Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "The STYLE function should not be used without compelling reason, its purpose is the use with asynchronous Add-In functions to visually notify about the availability of a result. In almost all other cases using conditional formatting instead is a better choice." ], "previous_source": "", "target": [ "La fonction STYLE ne doit pas être utilisée sans raison impérieuse, son but est l'utilisation avec des fonctions Add-In asynchrones pour notifier visuellement la disponibilité d'un résultat. Dans presque tous les autres cas, l'utilisation de la mise en forme conditionnelle est un meilleur choix." ], "id_hash": 4340852398694219373, "content_hash": 4340852398694219373, "location": "func_style.xhp", "context": "func_style.xhp\npar_id1670450904\nhelp.text", "note": "V9E4f", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7554, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://translations.documentfoundation.org/api/units/111182575/?format=api", "priority": 100, "id": 112282038, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=bc3dce41fe923e6d", "url": "https://translations.documentfoundation.org/api/units/112282038/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.392832Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "STYLE(\"Style\" [; Time [; \"Style2\"]])" ], "previous_source": "", "target": [ "STYLE(\"style\"[;temps[;\"style_2\"]])" ], "id_hash": 1305044713307895830, "content_hash": 1305044713307895830, "location": "func_style.xhp", "context": "func_style.xhp\npar_id961673376106137\nhelp.text", "note": "m2FBk", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7555, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/111182602/?format=api", "priority": 100, "id": 112282040, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=921c734098b7f816", "url": "https://translations.documentfoundation.org/api/units/112282040/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.395381Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<emph>Style</emph> is the name of the cell style to be applied to the cell. Style names are not case-sensitive and must be entered in quotation marks." ], "previous_source": "", "target": [ "<emph>Style</emph> est le nom du style de cellule à appliquer à la cellule. Les noms de style ne sont pas sensibles à la casse et doivent être saisis entre guillemets." ], "id_hash": 6015326205682868444, "content_hash": 6015326205682868444, "location": "func_style.xhp", "context": "func_style.xhp\npar_id31673375542211\nhelp.text", "note": "NkFMi", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7556, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/111182688/?format=api", "priority": 100, "id": 112282042, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=d37abb5041d360dc", "url": "https://translations.documentfoundation.org/api/units/112282042/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.398133Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<emph>Time</emph> is an optional time range in seconds. After this time is elapsed, the style defined in <emph>Style2</emph> is applied. Leave this parameter blank if you do not want the style to be changed." ], "previous_source": "", "target": [ "<emph>Temps</emph> est une plage de temps facultative en secondes. Une fois ce temps écoulé, le style défini dans <emph>Style2</emph> est appliqué. Laissez ce paramètre vide si vous ne voulez pas que le style soit modifié." ], "id_hash": 4574010901924514365, "content_hash": 4574010901924514365, "location": "func_style.xhp", "context": "func_style.xhp\npar_id161673375589532\nhelp.text", "note": "8E46w", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7557, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/111182710/?format=api", "priority": 100, "id": 112282043, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=bf7a26ae5ff98a3d", "url": "https://translations.documentfoundation.org/api/units/112282043/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.401831Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<emph>Style2</emph> is the optional name of a cell style assigned to the cell after the time specified in the <emph>Time</emph> parameter has passed. If this parameter is missing the \"Default\" cell style is applied." ], "previous_source": "", "target": [ "<emph>Style2</emph> est le nom facultatif d'un style de cellule attribué à la cellule une fois que le temps spécifié dans le paramètre <emph>temps</emph> s'est écoulé. Si ce paramètre est manquant, le style de cellule \"Par défaut\" est appliqué." ], "id_hash": 1618184598095757033, "content_hash": 1618184598095757033, "location": "func_style.xhp", "context": "func_style.xhp\npar_id81673375703156\nhelp.text", "note": "aFQCT", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7558, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/111182800/?format=api", "priority": 100, "id": 112282044, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=9674f25186817ee9", "url": "https://translations.documentfoundation.org/api/units/112282044/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.403360Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<embedvar href=\"text/scalc/00/00000004.xhp#optional\"/>" ], "previous_source": "", "target": [ "<embedvar href=\"text/scalc/00/00000004.xhp#optional\"/>" ], "id_hash": -4148967812045054790, "content_hash": -4148967812045054790, "location": "func_style.xhp", "context": "func_style.xhp\npar_id971673376620554\nhelp.text", "note": "ryUMD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7559, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111182847/?format=api", "priority": 100, "id": 112282045, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=466be7c1d2865cba", "url": "https://translations.documentfoundation.org/api/units/112282045/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.407424Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<input>=10+STYLE(\"Good\",60,\"Neutral\")</input>" ], "previous_source": "", "target": [ "<input>=10+STYLE(\"Bien\",60,\"Neutre\")</input>" ], "id_hash": 8774010481600811310, "content_hash": 8774010481600811310, "location": "func_style.xhp", "context": "func_style.xhp\npar_id491673376748686\nhelp.text", "note": "U3hrJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7560, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111182902/?format=api", "priority": 100, "id": 112282046, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=f9c38c0bdb5ed12e", "url": "https://translations.documentfoundation.org/api/units/112282046/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.409210Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "Enters the value 10 into the cell and applies the style named \"Good\". After 60 seconds, the style \"Neutral\" is applied." ], "previous_source": "", "target": [ "Entre la valeur 10 dans la cellule et applique le style nommé \"Bien\". Après 60 secondes, le style \"Neutre\" est appliqué." ], "id_hash": -1878993523197637285, "content_hash": -1878993523197637285, "location": "func_style.xhp", "context": "func_style.xhp\npar_id11673376842469\nhelp.text", "note": "8deaD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7561, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/111182918/?format=api", "priority": 100, "id": 112282047, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=65ec7958928b8d5b", "url": "https://translations.documentfoundation.org/api/units/112282047/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.411443Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<input>=A1*A2+STYLE(IF(CURRENT()<100,\"Bad\",\"Good\"))</input>" ], "previous_source": "", "target": [ "<input>=A1*A2+STYLE(SI(ACTUELLE()<100,\"Mal\",\"Bien\"))</input>" ], "id_hash": 5410722021459901413, "content_hash": 5410722021459901413, "location": "func_style.xhp", "context": "func_style.xhp\npar_id271673376901358\nhelp.text", "note": "UYv4h", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7562, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111182943/?format=api", "priority": 100, "id": 112282048, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=cb16bf02e3803be5", "url": "https://translations.documentfoundation.org/api/units/112282048/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.415395Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "Enters the result of multiplying the values in cells A1 and A2 and applies the style \"Bad\" if the result is less than 100, otherwise the style \"Good\" is applied. Here the function <emph>CURRENT()</emph> is used to get the currently evaluated value of the function in the cell." ], "previous_source": "", "target": [ "Entre le résultat de la multiplication des valeurs dans les cellules A1 et A2 et applique le style \"Mal\" si le résultat est inférieur à 100, sinon le style \"Bien\" est appliqué. Ici, la fonction <emph>ACTUELLE()</emph> est utilisée pour obtenir la valeur actuellement évaluée de la fonction dans la cellule." ], "id_hash": -2021632878714423934, "content_hash": -2021632878714423934, "location": "func_style.xhp", "context": "func_style.xhp\npar_id1001673377339392\nhelp.text", "note": "Zt8eb", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7563, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 48, "source_unit": "https://translations.documentfoundation.org/api/units/111182975/?format=api", "priority": 100, "id": 112282049, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=63f1b79b9df9f582", "url": "https://translations.documentfoundation.org/api/units/112282049/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.419877Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<input>=\"Total\"&T(STYLE(\"Result\"))</input>" ], "previous_source": "", "target": [ "<input>=\"Total\"&T(STYLE(\"Résultat\"))</input>" ], "id_hash": -4503359689536300631, "content_hash": -4503359689536300631, "location": "func_style.xhp", "context": "func_style.xhp\npar_id761673377678426\nhelp.text", "note": "nMoAR", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7564, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111183065/?format=api", "priority": 100, "id": 112282050, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=4180da38e16019a9", "url": "https://translations.documentfoundation.org/api/units/112282050/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.422766Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "Enters the text \"Total\" into the cell and applies the style named \"Result\". Note that this example deals with textual values, hence the output of the <emph>STYLE</emph> function needs to be appended to the text using the & operator. The function <emph>T()</emph> is used to prevent the number \"0\" being appended to the resulting text." ], "previous_source": "", "target": [ "Entre le texte \"Total\" dans la cellule et applique le style nommé \"Résultat\". Notez que cet exemple traite des valeurs textuelles, par conséquent la sortie de la fonction <emph>STYLE</emph> doit être ajoutée au texte à l'aide de l'opérateur &. La fonction <emph>T()</emph> est utilisée pour empêcher que le chiffre \"0\" ne soit ajouté au texte résultant." ], "id_hash": -953226345366165529, "content_hash": -953226345366165529, "location": "func_style.xhp", "context": "func_style.xhp\npar_id871673377683120\nhelp.text", "note": "hBUAA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7565, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 55, "source_unit": "https://translations.documentfoundation.org/api/units/111183097/?format=api", "priority": 100, "id": 112282051, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=72c575b075e7e7e7", "url": "https://translations.documentfoundation.org/api/units/112282051/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.424049Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/STYLE\">STYLE wiki page</link>." ], "previous_source": "", "target": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/STYLE\">Page de wiki STYLE</link>." ], "id_hash": 7002454760026936309, "content_hash": 7002454760026936309, "location": "func_style.xhp", "context": "func_style.xhp\npar_id201677014634447\nhelp.text", "note": "zzt3s", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7566, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111183135/?format=api", "priority": 100, "id": 112282052, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=e12db780ef2613f5", "url": "https://translations.documentfoundation.org/api/units/112282052/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.425487Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<link href=\"text/scalc/01/04060109.xhp\">Spreadsheet Functions</link>" ], "previous_source": "", "target": [ "<link href=\"text/scalc/01/04060109.xhp\">Fonctions de classeur</link>" ], "id_hash": 7518784913983819571, "content_hash": 7518784913983819571, "location": "func_style.xhp", "context": "func_style.xhp\npar_id631673379195650\nhelp.text", "note": "rEQGK", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7567, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111183168/?format=api", "priority": 100, "id": 112282053, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=e858170b04924f33", "url": "https://translations.documentfoundation.org/api/units/112282053/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.426688Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<link href=\"text/scalc/guide/cellstyle_by_formula.xhp\">Assigning Formats by Formula</link>" ], "previous_source": "", "target": [ "<link href=\"text/scalc/guide/cellstyle_by_formula.xhp\">Assigner des formats à l'aide de formule</link>" ], "id_hash": 5770525440401091501, "content_hash": 5770525440401091501, "location": "func_style.xhp", "context": "func_style.xhp\npar_id151673379420755\nhelp.text", "note": "VZ5Ga", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7568, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/111183184/?format=api", "priority": 100, "id": 112282054, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=d015065082762bad", "url": "https://translations.documentfoundation.org/api/units/112282054/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.431149Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<link href=\"text/scalc/01/04060104.xhp#func_current_description\">CURRENT function</link>" ], "previous_source": "", "target": [ "<link href=\"text/scalc/01/04060104.xhp#func_current_description\">Fonction ACTUELLE</link>" ], "id_hash": -2897871533713709166, "content_hash": -2897871533713709166, "location": "func_style.xhp", "context": "func_style.xhp\npar_id461673376361959\nhelp.text", "note": "YADMA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7569, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111183206/?format=api", "priority": 100, "id": 112282055, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=57c8b13194472792", "url": "https://translations.documentfoundation.org/api/units/112282055/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.433772Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<link href=\"text/scalc/01/04060110.xhp#t\">T function</link>" ], "previous_source": "", "target": [ "<link href=\"text/scalc/01/04060110.xhp#t\">Fonction T</link>" ], "id_hash": 5689967768727522419, "content_hash": 5689967768727522419, "location": "func_style.xhp", "context": "func_style.xhp\npar_id381673378944042\nhelp.text", "note": "L6tnb", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7570, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111183242/?format=api", "priority": 100, "id": 112282056, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=cef6d389f66d0c73", "url": "https://translations.documentfoundation.org/api/units/112282056/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.436355Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "SUM Function" ], "previous_source": "", "target": [ "Fonction SOMME" ], "id_hash": -835747380684224227, "content_hash": -835747380684224227, "location": "func_sum.xhp", "context": "func_sum.xhp\ntit\nhelp.text", "note": "mEZBk", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7571, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111183270/?format=api", "priority": 100, "id": 112282057, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=7466d42f6c5a891d", "url": "https://translations.documentfoundation.org/api/units/112282057/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.438074Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<bookmark_value>SUM function</bookmark_value> <bookmark_value>adding;numbers in cell ranges</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>Fonction SOMME</bookmark_value><bookmark_value>Ajouter;nombres dans une plage de cellules</bookmark_value>" ], "id_hash": 6085024028718732676, "content_hash": 6085024028718732676, "location": "func_sum.xhp", "context": "func_sum.xhp\nid431636401649762\nhelp.text", "note": "fLyVA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7572, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/111183290/?format=api", "priority": 100, "id": 112282058, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=d472591d417f1584", "url": "https://translations.documentfoundation.org/api/units/112282058/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.439291Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<variable id=\"sum_head\"><link href=\"text/scalc/01/func_sum.xhp\">SUM</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"sum_head\"><link href=\"text/scalc/01/func_sum.xhp\">SOMME</link></variable>" ], "id_hash": -2868028676740648335, "content_hash": -2868028676740648335, "location": "func_sum.xhp", "context": "func_sum.xhp\nhd_id121636398275790\nhelp.text", "note": "jDti4", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7573, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111183311/?format=api", "priority": 100, "id": 112282059, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=5832b71d2d3d7271", "url": "https://translations.documentfoundation.org/api/units/112282059/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.440602Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<variable id=\"func_sum_desc\"><ahelp hid=\".\">Adds a set of numbers.</ahelp></variable>" ], "previous_source": "", "target": [ "<variable id=\"func_sum_desc\"><ahelp hid=\".\">Ajoute un ensemble de nombres.</ahelp></variable>" ], "id_hash": -5625976177105928921, "content_hash": -5625976177105928921, "location": "func_sum.xhp", "context": "func_sum.xhp\npar_id491636401806866\nhelp.text", "note": "c32xJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7574, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/111183348/?format=api", "priority": 100, "id": 112282060, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=31ec847980ca7d27", "url": "https://translations.documentfoundation.org/api/units/112282060/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.442443Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "SUM(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" ], "previous_source": "", "target": [ "SOMME<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>" ], "id_hash": -1464919939241204293, "content_hash": -1464919939241204293, "location": "func_sum.xhp", "context": "func_sum.xhp\npar_id3163656\nhelp.text", "note": "vfwu7", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7575, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111183361/?format=api", "priority": 100, "id": 112282061, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=6bab8f13a52425bb", "url": "https://translations.documentfoundation.org/api/units/112282061/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.446387Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<input>=SUM(2;3;4)</input> returns 9." ], "previous_source": "", "target": [ "<input>=SOMME(2;3;4)</input> renvoie 9." ], "id_hash": -6946537612386304541, "content_hash": -6946537612386304541, "location": "func_sum.xhp", "context": "func_sum.xhp\npar_id3163704\nhelp.text", "note": "h8z3Q", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7576, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111183381/?format=api", "priority": 100, "id": 112282062, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=1f98f0d88ad2fde3", "url": "https://translations.documentfoundation.org/api/units/112282062/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.449287Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<item type=\"input\">=SUM(A1;A3;B5)</item> calculates the sum of the three cells." ], "previous_source": "", "target": [ "<item type=\"input\">=SOMME(A1;A3;B5)</item> calcule la somme de trois cellules." ], "id_hash": 652939789567612619, "content_hash": 652939789567612619, "location": "func_sum.xhp", "context": "func_sum.xhp\npar_id3151740\nhelp.text", "note": "6ohPR", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7577, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/111183404/?format=api", "priority": 100, "id": 112282063, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=890fb54778e556cb", "url": "https://translations.documentfoundation.org/api/units/112282063/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.451191Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<item type=\"input\">=SUM(A1:E10)</item> calculates the sum of all cells in the A1 to E10 cell range." ], "previous_source": "", "target": [ "<item type=\"input\">=SOMME(A1:E10)</item> calcule la somme de toutes les cellules de la plage de cellules A1 à E10." ], "id_hash": -3872165459397171147, "content_hash": -3872165459397171147, "location": "func_sum.xhp", "context": "func_sum.xhp\npar_id931636109030406\nhelp.text", "note": "FbQ6a", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7578, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/111183420/?format=api", "priority": 100, "id": 112282064, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=4a434e07c1182835", "url": "https://translations.documentfoundation.org/api/units/112282064/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.453404Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "A formula such as <input>=SUM((A1:A40>=C1)*(A1:A40<C2)*B1:B40)</input> may be entered as an <link href=\"text/scalc/01/04060107.xhp\">array formula</link> by pressing the Shift<switchinline select=\"sys\"><caseinline select=\"MAC\">+Command</caseinline><defaultinline>+Ctrl</defaultinline></switchinline>+Enter keys instead of simply pressing the Enter key to finish entering the formula. The formula will then be shown in the Formula bar enclosed in braces and operates by multiplying corresponding elements of the arrays together and returning their sum." ], "previous_source": "", "target": [ "Une formule telle que <input>=SOMME((A1:A40>=C1)*(A1:A40<C2)*B1:B40)</input> peut être saisie en tant que <link href=\"text/scalc/01/04060107.xhp\">formule matricielle</link> en appuyant sur les touches Maj<switchinline select=\"sys\"><caseinline select=\"MAC\">+Commande</caseinline><defaultinline>+Ctrl</defaultinline></switchinline>+Entrée au lieu d'appuyer simplement sur la touche Entrée pour terminer la saisie de la formule. La formule sera alors affichée dans la barre de formule entre accolades et fonctionne en multipliant les éléments correspondants des matrices ensemble et en renvoyant leur somme." ], "id_hash": -8203016005970044413, "content_hash": -8203016005970044413, "location": "func_sum.xhp", "context": "func_sum.xhp\npar_id3151756\nhelp.text", "note": "UmyxD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7579, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 59, "source_unit": "https://translations.documentfoundation.org/api/units/111183456/?format=api", "priority": 100, "id": 112282065, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=0e2908676d4fda03", "url": "https://translations.documentfoundation.org/api/units/112282065/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.456231Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/SUM\">SUM wiki page</link>." ], "previous_source": "", "target": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/SUM\">Page de wiki SOMME</link>." ], "id_hash": 4469010790866011402, "content_hash": 4469010790866011402, "location": "func_sum.xhp", "context": "func_sum.xhp\npar_id771677014538669\nhelp.text", "note": "KohAT", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7580, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111183524/?format=api", "priority": 100, "id": 112282066, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=be051da2eef4c50a", "url": "https://translations.documentfoundation.org/api/units/112282066/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.459826Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "SUMIFS function" ], "previous_source": "", "target": [ "Fonction SOMME.SI.ENS" ], "id_hash": -3540436716313482577, "content_hash": -3540436716313482577, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\ntit\nhelp.text", "note": "DfceH", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7581, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111183542/?format=api", "priority": 100, "id": 112282067, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=4eddd79086626aaf", "url": "https://translations.documentfoundation.org/api/units/112282067/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.461497Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<bookmark_value>SUMIFS function</bookmark_value> <bookmark_value>sum;satisfying conditions</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>SOMME.SI.ENS, fonction</bookmark_value><bookmark_value>Somme;conditions de satisfaction</bookmark_value>" ], "id_hash": -2704983415798147745, "content_hash": -2704983415798147745, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\nbm_id658066580665806\nhelp.text", "note": "jDeBL", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7582, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111183560/?format=api", "priority": 100, "id": 112282068, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=5a75f7ea3a07555f", "url": "https://translations.documentfoundation.org/api/units/112282068/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.462793Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<variable id=\"sumifs_head\"><link href=\"text/scalc/01/func_sumifs.xhp\">SUMIFS</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"sumifs_head\"><link href=\"text/scalc/01/func_sumifs.xhp\">SOMME.SI.ENS</link></variable>" ], "id_hash": -3689655749840634933, "content_hash": -3689655749840634933, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\nhd_id658866588665886\nhelp.text", "note": "MpUwQ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7583, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111183561/?format=api", "priority": 100, "id": 112282069, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=4ccbb5a4e7457bcb", "url": "https://translations.documentfoundation.org/api/units/112282069/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.464568Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<ahelp hid=\".\"><variable id=\"sumifs_des\">Returns the sum of the values of cells in a range that meets multiple criteria in multiple ranges.</variable></ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\".\"><variable id=\"sumifs_des\">Renvoie la somme des valeurs des cellules d'une plage qui répond à des critères multiples dans plusieurs plages.</variable></ahelp>" ], "id_hash": 9169675903449353869, "content_hash": 9169675903449353869, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id659756597565975\nhelp.text", "note": "ZEdvF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7584, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/111183599/?format=api", "priority": 100, "id": 112282070, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=ff413ba6b28ece8d", "url": "https://translations.documentfoundation.org/api/units/112282070/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.465941Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "SUMIFS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)" ], "previous_source": "", "target": [ "SOMME.SI.ENS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)" ], "id_hash": 8486374903425621466, "content_hash": 8486374903425621466, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id11655988824213\nhelp.text", "note": "xhKwv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7585, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111183620/?format=api", "priority": 100, "id": 112282071, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=f5c5a9030d795dda", "url": "https://translations.documentfoundation.org/api/units/112282071/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.467321Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<emph>Func_Range</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for calculating the sum." ], "previous_source": "", "target": [ "<emph>plage_fonction</emph> – argument requis. C'est une plage de cellules, un nom d'une plage nommée ou une étiquette de colonne ou de ligne contenant les valeurs pour le calcul de la somme." ], "id_hash": -3181281400957303016, "content_hash": -3181281400957303016, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id59901690530236\nhelp.text", "note": "mP5Et", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7586, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/111183656/?format=api", "priority": 100, "id": 112282072, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=53d9d16bc5620718", "url": "https://translations.documentfoundation.org/api/units/112282072/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.468617Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "Simple usage" ], "previous_source": "", "target": [ "Usage simple" ], "id_hash": 100979218881927587, "content_hash": 100979218881927587, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\nhd_id193452436229521\nhelp.text", "note": "zahGz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7587, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111183688/?format=api", "priority": 100, "id": 112282073, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=8166c010872759a3", "url": "https://translations.documentfoundation.org/api/units/112282073/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.469976Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<item type=\"input\">=SUMIFS(B2:B6;B2:B6;\">=20\")</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=SOMME.SI.ENS(B2:B6;B2:B6;\">=20\")</item>" ], "id_hash": -3980841953204373942, "content_hash": -3980841953204373942, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id94321051525036\nhelp.text", "note": "tqgKL", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7588, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111183724/?format=api", "priority": 100, "id": 112282074, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=48c13555c047f64a", "url": "https://translations.documentfoundation.org/api/units/112282074/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.471081Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "Calculates the sum of values of the range B2:B6 that are greater than or equal to 20. Returns 75, because the fifth row does not meet the criterion." ], "previous_source": "", "target": [ "Calcule la somme des valeurs de la plage B2:B6 qui sont supérieures ou égales à 20. Renvoie 75 parce que la cinquième ligne ne correspond pas au critère." ], "id_hash": -8584625317315816146, "content_hash": -8584625317315816146, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id28647227259438\nhelp.text", "note": "NK7QS", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7589, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/111183777/?format=api", "priority": 100, "id": 112282075, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=08dd48c1d790d52e", "url": "https://translations.documentfoundation.org/api/units/112282075/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.472267Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<item type=\"input\">=SUMIFS(C2:C6;B2:B6;\">=20\";C2:C6;\">70\")</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=SOMME.SI.ENS(C2:C6;B2:B6;\">=20\";C2:C6;\">70\")</item>" ], "id_hash": -9075336950328213574, "content_hash": -9075336950328213574, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id36952767622741\nhelp.text", "note": "TzCFB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7590, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111183820/?format=api", "priority": 100, "id": 112282076, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=020ded207ab5bfba", "url": "https://translations.documentfoundation.org/api/units/112282076/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.473488Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "Calculates the sum of values of the range C2:C6 that are greater than 70 and correspond to cells of the B2:B6 range with values greater than or equal to 20. Returns 275, because the second and the fifth rows do not meet at least one criterion." ], "previous_source": "", "target": [ "Calcule la somme des valeurs de la plage C2:C6 qui sont supérieures à 70 et correspondent aux cellules de la plage B2:B6 dont les valeurs sont supérieures ou égales à 20. Renvoie 275, parce que les seconde et cinquième lignes ne correspondent pas à au moins un critère." ], "id_hash": 5531634363620764760, "content_hash": 5531634363620764760, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id189772445525114\nhelp.text", "note": "or3BG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7591, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 46, "source_unit": "https://translations.documentfoundation.org/api/units/111183870/?format=api", "priority": 100, "id": 112282077, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=ccc4502556f5ac58", "url": "https://translations.documentfoundation.org/api/units/112282077/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.476346Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "Using regular expressions and nested functions" ], "previous_source": "", "target": [ "Utilisation des expressions régulières et des fonctions imbriquées" ], "id_hash": -7905416432563865011, "content_hash": -7905416432563865011, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\nhd_id30455222431067\nhelp.text", "note": "YHh9T", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7592, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/111183913/?format=api", "priority": 100, "id": 112282078, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=124a51a3a77eba4d", "url": "https://translations.documentfoundation.org/api/units/112282078/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.477828Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<item type=\"input\">=SUMIFS(C2:C6;B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=SOMME.SI.ENS(C2:C6;B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>" ], "id_hash": -7100679125014514541, "content_hash": -7100679125014514541, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id307691022525348\nhelp.text", "note": "Ust3n", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7593, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111183957/?format=api", "priority": 100, "id": 112282079, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=1d7551f4f17a7493", "url": "https://translations.documentfoundation.org/api/units/112282079/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.478942Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "Calculates the sum of values of the range C2:C6 that correspond to all values of the range B2:B6 except its minimum and maximum. Returns 255, because the third and the fifth rows do not meet at least one criterion." ], "previous_source": "", "target": [ "Calcule la somme des valeurs de la plage C2:C6 qui correspondent à toutes les valeurs de la plage B2:B6 à l'exception de ses minimum et maximum. Renvoie 255, parce que les troisième et cinquième lignes ne correspondent pas à au moins un critère." ], "id_hash": -3296253579067716392, "content_hash": -3296253579067716392, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id27619246864839\nhelp.text", "note": "wCeGS", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7594, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://translations.documentfoundation.org/api/units/111184004/?format=api", "priority": 100, "id": 112282080, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=52415ad58a0f0cd8", "url": "https://translations.documentfoundation.org/api/units/112282080/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.480193Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<item type=\"input\">=SUMIFS(C2:C6;A2:A6;\"pen.*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=SOMME.SI.ENS(C2:C6;A2:A6;\"crayon.*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "id_hash": 993849274358828000, "content_hash": 993849274358828000, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id220502883332563\nhelp.text", "note": "tETJF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7595, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111184009/?format=api", "priority": 100, "id": 112282081, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=8dcadca63e700be0", "url": "https://translations.documentfoundation.org/api/units/112282081/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.481439Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "Calculates the sum of values of the range C2:C6 that correspond to all cells of the A2:A6 range starting with \"pen\" and to all cells of the B2:B6 range except its maximum. Returns 65, because only second row meets all criteria." ], "previous_source": "", "target": [ "Calcule la somme des valeurs de la plage C2:C6 qui correspondent à toutes les cellules de la plage A2:A6 commençant par \"crayon\" et à toutes les cellules de la plage B2:B6 excepté son maximum. Renvoie 65, parce que uniquement la seconde ligne correspond à tous les critères." ], "id_hash": -3162333369531084074, "content_hash": -3162333369531084074, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id15342189586295\nhelp.text", "note": "u7CDd", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7596, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://translations.documentfoundation.org/api/units/111184010/?format=api", "priority": 100, "id": 112282082, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=541d228e1fbc52d6", "url": "https://translations.documentfoundation.org/api/units/112282082/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.482654Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "Reference to a cell as a criterion" ], "previous_source": "", "target": [ "Référence à une cellule comme critère" ], "id_hash": 3615373838218159194, "content_hash": 3615373838218159194, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\nhd_id8168283329426\nhelp.text", "note": "dKeLC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7597, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/111184011/?format=api", "priority": 100, "id": 112282083, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=b22c6359cd3be45a", "url": "https://translations.documentfoundation.org/api/units/112282083/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.485806Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of the SUMIFS function. For example, the above function can be rewritten as follows:" ], "previous_source": "", "target": [ "Si vous avez besoin de modifier facilement un critère, vous le spécifiez dans une cellule séparée et utilisez une référence à cette cellule dans la condition de la fonction SOMME.SI.ENS. Par exemple, la fonction ci-dessous peut être réécrite de la façon suivante :" ], "id_hash": 2034425885526726680, "content_hash": 2034425885526726680, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id50762995519951\nhelp.text", "note": "NzNhA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7598, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://translations.documentfoundation.org/api/units/111184012/?format=api", "priority": 100, "id": 112282084, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=9c3bbb9064ae1818", "url": "https://translations.documentfoundation.org/api/units/112282084/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.487009Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<item type=\"input\">=SUMIFS(C2:C6;A2:A6;E2&\".*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=SOMME.SI.ENS(C2:C6;A2:A6;E2&\".*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "id_hash": 3624176247368206676, "content_hash": 3624176247368206676, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id135761606425300\nhelp.text", "note": "U2wwM", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7599, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111184013/?format=api", "priority": 100, "id": 112282085, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=b24ba91863ca4954", "url": "https://translations.documentfoundation.org/api/units/112282085/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.488472Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "If E2 = pen, the function returns 65, because the link to the cell is substituted with its content." ], "previous_source": "", "target": [ "Si E2=crayon, la fonction renvoie 65 parce que le lien à la cellule est substitué par son contenu." ], "id_hash": 814313685569042024, "content_hash": 814313685569042024, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id30574750215839\nhelp.text", "note": "wGhZA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7600, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/111184014/?format=api", "priority": 100, "id": 112282086, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=8b4d05fb8c14f668", "url": "https://translations.documentfoundation.org/api/units/112282086/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:19.490061Z" } ] }{ "count": 8439, "next": "