Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-master/textscalc01/fr/units/?format=api&page=129
{ "count": 8573, "next": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/units/?format=api&page=130", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/units/?format=api&page=128", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<input>=HYPERLINK(\"http://www.example.org\";\"Click here\")</input> displays the text \"Click here\" in the cell and executes the hyperlink http://www.example.org when clicked." ], "previous_source": "", "target": [ "<input>=LIEN.HYPERTEXTE(\"http://www.exemple.org\";\"Cliquez ici\")</input> affiche le texte \"cliquez ici\" dans la cellule exécute le lien hypertexte http://www.exemple.org lorsqu'il est cliqué." ], "id_hash": 1277222501774768595, "content_hash": 1277222501774768595, "location": "04060109.xhp", "context": "04060109.xhp\npar_idN1182A\nhelp.text", "note": "wHG7A", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2174, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/45493584/?format=api", "priority": 100, "id": 45494146, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=91b99b192d6bb9d3", "url": "https://translations.documentfoundation.org/api/units/45494146/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-19T17:56:52.281840Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<input>=HYPERLINK(\"http://www.example.org\";12345)</input> displays the number 12345 and executes the hyperlink http://www.example.org when clicked." ], "previous_source": "", "target": [ "<input>=LIEN.HYPERTEXTE(\"http://www.exemple.org\";12345)</input> affiche le nombre 12345 et exécute le lien hypertexte http://www.exemple.org lorsqu'il est cliqué." ], "id_hash": -2085945883601083680, "content_hash": -2085945883601083680, "location": "04060109.xhp", "context": "04060109.xhp\npar_id0907200912224534\nhelp.text", "note": "jamR2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2175, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/45493585/?format=api", "priority": 100, "id": 45494147, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=630d3b454b44e2e0", "url": "https://translations.documentfoundation.org/api/units/45494147/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-19T17:56:52.283052Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<input>=HYPERLINK($B4)</input> where cell B4 contains <literal>http://www.example.org</literal>. The function adds http://www.example.org to the URL of the hyperlink cell and returns the same text which is used as formula result." ], "previous_source": "", "target": [ "<input>=LIEN.HYPERTEXTE($B4)</input> où la cellule B4 contient <literal>http://www.exemple.org</literal>. La fonction ajoute http://www.exemple.org à l'URL de la cellule contenant le lien et renvoie le même texte qui est utilisé comme résultat de la formule." ], "id_hash": -45593686545329457, "content_hash": -45593686545329457, "location": "04060109.xhp", "context": "04060109.xhp\npar_idN1182D\nhelp.text", "note": "qLdBN", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2176, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/45493586/?format=api", "priority": 100, "id": 45494148, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=7f5e04c89d7712cf", "url": "https://translations.documentfoundation.org/api/units/45494148/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-19T17:56:52.284332Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<input>=HYPERLINK(\"http://www.\";\"Click \") & \"example.org\"</input> displays the text Click example.org in the cell and executes the hyperlink http://www.example.org when clicked." ], "previous_source": "", "target": [ "<input>=LIEN.HYPERTEXTE(\"http://www.\";\"Cliquer sur\") & \"exemple.org\" </input> affiche le texte Cliquer sur exemple.org dans la cellule et exécute le lien hypertexte http://www.exemple.org lorsque cliqué." ], "id_hash": 2830691007777424645, "content_hash": 2830691007777424645, "location": "04060109.xhp", "context": "04060109.xhp\npar_idN11830\nhelp.text", "note": "cWDrv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2177, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/45493587/?format=api", "priority": 100, "id": 45494149, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=a748a27953774505", "url": "https://translations.documentfoundation.org/api/units/45494149/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-19T17:56:52.285649Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<input>=HYPERLINK(\"#Sheet1.A1\";\"Go to top\")</input> displays the text Go to top and jumps to cell Sheet1.A1 in this document." ], "previous_source": "", "target": [ "<input>=LIEN.HYPERTEXTE(\"#Feuille1.A1\";\"Aller en haut\")</input> affiche le texte Aller en haut et saute à la cellule Feuille1.A1 dans le document." ], "id_hash": 1869041006723579226, "content_hash": 1869041006723579226, "location": "04060109.xhp", "context": "04060109.xhp\npar_id8859523\nhelp.text", "note": "DDEtK", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2178, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/45493588/?format=api", "priority": 100, "id": 45494150, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=99f02ae49c65bd5a", "url": "https://translations.documentfoundation.org/api/units/45494150/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-19T17:56:52.286956Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<input>=HYPERLINK(\"file:///C:/writer.odt#Specification\";\"Go to Writer bookmark\")</input> displays the text \"Go to Writer bookmark\", loads the specified text document and jumps to bookmark \"Specification\"." ], "previous_source": "", "target": [ "<input>=LIEN.HYPERTEXTE(\"file:///C:/writer.odt#Spécification\";\"Aller au repère de texte Writer\")</input> affiche le texte Aller au repère de texte Writer, charge le document texte spécifié et atteint le repère de texte \"Spécification\"." ], "id_hash": 2843765593580861418, "content_hash": 2843765593580861418, "location": "04060109.xhp", "context": "04060109.xhp\npar_id2958769\nhelp.text", "note": "CoMEq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2179, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/45493589/?format=api", "priority": 100, "id": 45494151, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=a77715bd8ddd77ea", "url": "https://translations.documentfoundation.org/api/units/45494151/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-19T17:56:52.288225Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<input>=HYPERLINK(\"file:///C:/Documents/\";\"Open Documents folder\")</input> displays the text \"Open Documents folder\" and shows the folder contents using the standard file manager in your operating system." ], "previous_source": "", "target": [ "<input>=HYPERLINK(\"file:///C:/Documents/\";\"Ouvrir le dossier des documents\")</input> affiche le texte \"Ouvrir le dossier des documents\" et affiche le contenu du dossier en utilisant le gestionnaire de fichiers standards du système d'exploitation." ], "id_hash": 1287100061349521092, "content_hash": 1287100061349521092, "location": "04060109.xhp", "context": "04060109.xhp\npar_id321615667588042\nhelp.text", "note": "Ky2xV", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2180, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/45493590/?format=api", "priority": 100, "id": 45494152, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=91dcb2afbb1f26c4", "url": "https://translations.documentfoundation.org/api/units/45494152/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-19T17:56:52.289373Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<input>=TEXTJOIN(\" \"; 1; \"Here\"; \"comes\"; \"the\"; \"sun\")</input> returns \"Here comes the sun\" with space character as delimiter and empty strings are ignored." ], "previous_source": "", "target": [ "<input>=JOINDRE.TEXTE(\" \",1,\"Voila\",\"le\",\"soleil\")</input> renvoie \"Voilà le soleil\" avec le caractère espace comme séparateur et les chaînes vides sont ignorées." ], "id_hash": 18671159055134695, "content_hash": 18671159055134695, "location": "func_textjoin.xhp", "context": "func_textjoin.xhp\npar_id441556229012536\nhelp.text", "note": "QaJCw", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7709, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/45512082/?format=api", "priority": 100, "id": 45512134, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=80425551fb06afe7", "url": "https://translations.documentfoundation.org/api/units/45512134/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-23T11:42:07.296362Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "if A1:B2 contains \"Here\", \"comes\", \"the\", \"sun\" respectively, <input>=TEXTJOIN(\"-\";1;A1:B2)</input> returns \"Here-comes-the-sun\" with dash character as delimiter and empty strings are ignored." ], "previous_source": "", "target": [ "Si A1:B2 contient \"Voilà\", \"le\", \"soleil\" respectivement, <input>=JOINDRE.TEXTE(\"-\";1;A1:B2)</input> renvoie \"Voilà-le-soleil\" avec le caractère tiret comme séparateur et les chaînes vides sont ignorées." ], "id_hash": -8803580722366995579, "content_hash": -8803580722366995579, "location": "func_textjoin.xhp", "context": "func_textjoin.xhp\npar_id441556239012536\nhelp.text", "note": "39FPP", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7710, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/45512083/?format=api", "priority": 100, "id": 45512135, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=05d365f9f3d6a385", "url": "https://translations.documentfoundation.org/api/units/45512135/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-23T11:42:07.298081Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<bookmark_value>Function Wizard; databases</bookmark_value> <bookmark_value>functions; database functions</bookmark_value> <bookmark_value>databases; functions in $[officename] Calc</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>Assistant Fonctions;bases de données</bookmark_value><bookmark_value>Fonctions;fonctions de base de données</bookmark_value><bookmark_value>Bases de données;fonctions dans $[officename] Calc</bookmark_value>" ], "id_hash": -4675263538054526505, "content_hash": -4675263538054526505, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3148946\nhelp.text", "note": "ASfzE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 479, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/45527418/?format=api", "priority": 100, "id": 45531562, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=3f1e20952eec89d7", "url": "https://translations.documentfoundation.org/api/units/45531562/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.439385Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Overview" ], "previous_source": "", "target": [ "Généralités" ], "id_hash": -1957506965020947932, "content_hash": -1957506965020947932, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id721616440441374\nhelp.text", "note": "v9KEM", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 481, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/45527419/?format=api", "priority": 100, "id": 45531563, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=64d589c96092ca24", "url": "https://translations.documentfoundation.org/api/units/45531563/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.441833Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<variable id=\"datenbanktext\">The twelve functions in the Database category help you to analyze a simple database that occupies a rectangular spreadsheet area comprising columns and rows, with the data organized as one row for each record.</variable> The header cell of each column displays the name of the column and that name usually reflects the contents of each cell in that column." ], "previous_source": "", "target": [ "<variable id=\"datenbanktext\">Les douze fonctions dans la base de données Bases de données aident à analyser une simple base de données qui occupe une zone de feuille de calcul rectangulaire comprenant des colonnes et des lignes, dont les données sont organisées a raison d'une ligne par enregistrement.</variable> La cellule d'en-tête de chaque colonne affiche le nom de la colonne et ce nom reflète généralement le contenu de chaque cellule dans cette colonne." ], "id_hash": 7858397836453741158, "content_hash": 7858397836453741158, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3145173\nhelp.text", "note": "RGkxy", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 482, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 60, "source_unit": "https://translations.documentfoundation.org/api/units/45527420/?format=api", "priority": 100, "id": 45531564, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=ed0ea33259860266", "url": "https://translations.documentfoundation.org/api/units/45531564/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.443002Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "The functions in the Database category take three arguments as follows:" ], "previous_source": "", "target": [ "Les fonctions de la catégorie Base de données prennent trois arguments comme suit :" ], "id_hash": -3153047564112727307, "content_hash": -3153047564112727307, "location": "04060101.xhp", "context": "04060101.xhp\npar_id631615842419413\nhelp.text", "note": "8NQZ9", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 483, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/45527421/?format=api", "priority": 100, "id": 45531565, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=543e1ff22d2672f5", "url": "https://translations.documentfoundation.org/api/units/45531565/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.444283Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<emph>Database</emph>. The cell range of the database." ], "previous_source": "", "target": [ "<emph>Base de données</emph>, la plage de cellules de la base de données." ], "id_hash": -277843361464821272, "content_hash": -277843361464821272, "location": "04060101.xhp", "context": "04060101.xhp\npar_id761615842549780\nhelp.text", "note": "pmE4Y", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 484, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/45527422/?format=api", "priority": 100, "id": 45531566, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=7c24e6ef50b059e8", "url": "https://translations.documentfoundation.org/api/units/45531566/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.445447Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<emph>DatabaseField</emph>. The column containing the data to be used in the function’s calculations." ], "previous_source": "", "target": [ "<emph>ChampBase de données</emph>, la colonne contenant les données à utiliser dans les calculs de la fonction." ], "id_hash": 7732379606245571435, "content_hash": 7732379606245571435, "location": "04060101.xhp", "context": "04060101.xhp\npar_id601615842657372\nhelp.text", "note": "nw3ya", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 485, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/45527423/?format=api", "priority": 100, "id": 45531567, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=eb4eee48b2bdfb6b", "url": "https://translations.documentfoundation.org/api/units/45531567/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.446751Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<emph>SearchCriteria</emph>. The cell range of a separate area of the spreadsheet containing search criteria." ], "previous_source": "", "target": [ "<emph>CritèreRecherche</emph>, la plage de cellules d'une zone séparée de la feuille de calcul contenant le critère de recherche." ], "id_hash": 714861080541909581, "content_hash": 714861080541909581, "location": "04060101.xhp", "context": "04060101.xhp\npar_id471615842721059\nhelp.text", "note": "D5P4G", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 486, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/45527424/?format=api", "priority": 100, "id": 45531568, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=89ebb25d8173d24d", "url": "https://translations.documentfoundation.org/api/units/45531568/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.447841Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "These arguments are described more fully below." ], "previous_source": "", "target": [ "Ces arguments sont décrits plus en détails ci-dessous." ], "id_hash": -6858934655711832832, "content_hash": -6858934655711832832, "location": "04060101.xhp", "context": "04060101.xhp\npar_id101615842794525\nhelp.text", "note": "RT3mc", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 487, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/45527425/?format=api", "priority": 100, "id": 45531569, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=20d02b4554ae1500", "url": "https://translations.documentfoundation.org/api/units/45531569/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.449256Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "All functions have the same outline concept of operation. The first logical step is to use the specified <emph>SearchCriteria</emph> to identify the subset of records in the <emph>Database</emph> that are to be used during subsequent calculations. The second step is to extract the data values and perform the calculations associated with the specific function (average, sum, product, and so on). The values processed are those in the <emph>DatabaseField</emph> column of the selected records." ], "previous_source": "", "target": [ "Toutes les fonctions ont le même concept de fonctionnement. La première étape logique consiste à utiliser les <emph>CritèresRecherch</emph> spécifiés pour identifier le sous-ensemble d'enregistrements de la <emph>Base de données</emph> à utiliser lors des calculs ultérieurs. La deuxième étape consiste à extraire les valeurs des données et à effectuer les calculs associés à la fonction spécifique (moyenne, somme, produit, etc.). Les valeurs traitées sont celles de la colonne <emph> ChampBase de données</emph> des enregistrements sélectionnés." ], "id_hash": 784813443191290384, "content_hash": 784813443191290384, "location": "04060101.xhp", "context": "04060101.xhp\npar_id241615842810077\nhelp.text", "note": "ykxDt", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 488, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 73, "source_unit": "https://translations.documentfoundation.org/api/units/45527426/?format=api", "priority": 100, "id": 45531570, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=8ae437ab205e3a10", "url": "https://translations.documentfoundation.org/api/units/45531570/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.450670Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Calc treats dates and logical values (TRUE and FALSE) as numeric when calculating with these functions." ], "previous_source": "", "target": [ "Calc traite les dates et les valeurs logiques (VRAI et FAUX) comme des valeurs numériques lors du calcul de ces fonctions." ], "id_hash": -1893961540072631828, "content_hash": -1893961540072631828, "location": "04060101.xhp", "context": "04060101.xhp\npar_id981615978852310\nhelp.text", "note": "oErum", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 489, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/45527427/?format=api", "priority": 100, "id": 45531571, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=65b74c0391b811ec", "url": "https://translations.documentfoundation.org/api/units/45531571/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.452168Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Database Function Arguments" ], "previous_source": "", "target": [ "Arguments des fonctions de base de données :" ], "id_hash": -2033458607046480747, "content_hash": -2033458607046480747, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id911615888814785\nhelp.text", "note": "qZFoo", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 490, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/45527428/?format=api", "priority": 100, "id": 45531572, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=63c7b42bad88ac95", "url": "https://translations.documentfoundation.org/api/units/45531572/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.453787Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "The following argument definitions apply for all functions in the Database category:" ], "previous_source": "", "target": [ "Les définitions d'argument suivantes s'appliquent à toutes les fonctions de la catégorie Base de données :" ], "id_hash": 2662524854335701609, "content_hash": 2662524854335701609, "location": "04060101.xhp", "context": "04060101.xhp\npar_id911615888833104\nhelp.text", "note": "XzUDg", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 491, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/45527429/?format=api", "priority": 100, "id": 45531573, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=a4f3303f94540269", "url": "https://translations.documentfoundation.org/api/units/45531573/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.455208Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<emph>Database argument</emph>" ], "previous_source": "", "target": [ "<emph>Argument de base de données</emph>" ], "id_hash": 2126155397356967751, "content_hash": 2126155397356967751, "location": "04060101.xhp", "context": "04060101.xhp\npar_id21615889071992\nhelp.text", "note": "EHkEz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 492, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/45527430/?format=api", "priority": 100, "id": 45531574, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=9d819f11acbdd747", "url": "https://translations.documentfoundation.org/api/units/45531574/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.456412Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<emph>Database</emph> specifies the range of cells occupied by the database table. The first row of the range contains the field names, and subsequent rows are records with corresponding field values." ], "previous_source": "", "target": [ "<emph>Base de données</emph> spécifie la plage de cellules occupée par la table de base de données. La première ligne de la plage contient les noms de champs, et les lignes suivantes sont des enregistrements avec des valeurs de champ correspondantes." ], "id_hash": 3070758380286137900, "content_hash": 3070758380286137900, "location": "04060101.xhp", "context": "04060101.xhp\npar_id31615889105463\nhelp.text", "note": "fxMgf", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 493, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/45527431/?format=api", "priority": 100, "id": 45531575, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=aa9d867a3002562c", "url": "https://translations.documentfoundation.org/api/units/45531575/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.457466Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "One way of defining the range of cells is to enter the cell reference for the upper left-hand cell, followed by a colon (:), and then the lower right-hand cell reference. An example might be A1:E10." ], "previous_source": "", "target": [ "Une façon de définir la plage de cellules consiste à entrer la référence de cellule pour la cellule supérieure gauche, suivie de deux-points (:), puis de la référence de cellule inférieure droite. Un exemple pourrait être A1:E10." ], "id_hash": 2971570413341076938, "content_hash": 2971570413341076938, "location": "04060101.xhp", "context": "04060101.xhp\npar_id521615889152497\nhelp.text", "note": "zpzi9", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 494, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/45527432/?format=api", "priority": 100, "id": 45531576, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=a93d238c00416dca", "url": "https://translations.documentfoundation.org/api/units/45531576/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.458733Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "The <emph>Database</emph> argument may also be specified by passing the name of a named range or database range. Using a meaningful name to define the cell range can enhance formula readability and document maintenance. If the name does not match the name of a defined range, Calc reports a #NAME? error." ], "previous_source": "", "target": [ "L'argument <emph>Base de données</emph> peut également être spécifié en passant le nom d'une plage nommée ou d'une plage de base de données. L'utilisation d'un nom significatif pour définir la plage de cellules peut améliorer la lisibilité des formules et la maintenance des documents. Si le nom ne correspond pas au nom d'une plage définie, Calc signale une erreur #NOM?." ], "id_hash": 3380758416767590307, "content_hash": 3380758416767590307, "location": "04060101.xhp", "context": "04060101.xhp\npar_id761615889163416\nhelp.text", "note": "WD55p", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 495, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 51, "source_unit": "https://translations.documentfoundation.org/api/units/45527433/?format=api", "priority": 100, "id": 45531577, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=aeeaddde36d81fa3", "url": "https://translations.documentfoundation.org/api/units/45531577/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.459852Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Other errors that might be reported as a result of an invalid <emph>Database</emph> argument are #VALUE! and Err:504 (error in parameter list)." ], "previous_source": "", "target": [ "D'autres erreurs pouvant être signalées à la suite d'un argument <emph>Base de données</emph> non valide sont #VALEUR ! et Err:504 (erreur dans la liste des paramètres)." ], "id_hash": 1142464629432627618, "content_hash": 1142464629432627618, "location": "04060101.xhp", "context": "04060101.xhp\npar_id601615889176137\nhelp.text", "note": "7L4XM", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 496, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/45527434/?format=api", "priority": 100, "id": 45531578, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=8fdad98705c7b1a2", "url": "https://translations.documentfoundation.org/api/units/45531578/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.460989Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<emph>DatabaseField argument</emph>" ], "previous_source": "", "target": [ "<emph>Argument Champ de base de donnée</emph>" ], "id_hash": -1242531801510591990, "content_hash": -1242531801510591990, "location": "04060101.xhp", "context": "04060101.xhp\npar_id201615889390777\nhelp.text", "note": "rsj3e", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 497, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/45527435/?format=api", "priority": 100, "id": 45531579, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=6ec1a3e8e4d5c20a", "url": "https://translations.documentfoundation.org/api/units/45531579/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.462271Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<emph>DatabaseField</emph> specifies the column which the function will use for its calculations after the search criteria have been applied and the data rows have been selected. It is not related to the search criteria." ], "previous_source": "", "target": [ "<emph>Champ de base de données</emph> spécifie la colonne que la fonction utilisera pour ses calculs une fois les critères de recherche appliqués et les lignes de données sélectionnées. Il n'est pas lié aux critères de recherche." ], "id_hash": -725583538232430489, "content_hash": -725583538232430489, "location": "04060101.xhp", "context": "04060101.xhp\npar_id431615889426480\nhelp.text", "note": "7Eorp", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 498, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/45527436/?format=api", "priority": 100, "id": 45531580, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=75ee359dc4c8f067", "url": "https://translations.documentfoundation.org/api/units/45531580/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.463335Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Specify the <emph>DatabaseField</emph> argument in any of the following ways:" ], "previous_source": "", "target": [ "Spécifiez l'argument <emph>Champ de base de données</emph> de l'une des manières suivantes :" ], "id_hash": 1408688388918389759, "content_hash": 1408688388918389759, "location": "04060101.xhp", "context": "04060101.xhp\npar_id661615889458032\nhelp.text", "note": "Z9Qfp", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 499, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/45527437/?format=api", "priority": 100, "id": 45531581, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=938caaa04cb2abff", "url": "https://translations.documentfoundation.org/api/units/45531581/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.464702Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "By entering a reference to a header cell within the <emph>Database</emph> area. Alternatively, if the cell has been given a meaningful name as a named range or database range, enter that name. If the name does not match the name of a defined range, Calc reports a #NAME? error. If the name is valid but does not correspond to one cell only, Calc reports Err:504 (error in parameter list)." ], "previous_source": "", "target": [ "En saisissant une référence à une cellule d'en-tête dans la zone <emph>Base de données</emph>. Alternativement, si la cellule a reçu un nom significatif en tant que plage nommée ou plage de base de données, saisissez ce nom. Si le nom ne correspond pas au nom d'une plage définie, Calc signale une erreur #NOM?. Si le nom est valide mais ne correspond pas à une seule cellule, Calc rapporte Err:504 (erreur dans la liste des paramètres)." ], "id_hash": 5919490496530924238, "content_hash": 5919490496530924238, "location": "04060101.xhp", "context": "04060101.xhp\npar_id981615889517841\nhelp.text", "note": "RMwzE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 500, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 69, "source_unit": "https://translations.documentfoundation.org/api/units/45527438/?format=api", "priority": 100, "id": 45531582, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=d226413e6906c2ce", "url": "https://translations.documentfoundation.org/api/units/45531582/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.466115Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "By entering a number to specify the column within the <emph>Database</emph> area, starting with 1. For example, if a <emph>Database</emph> occupied the cell range D6:H123, then enter 3 to indicate the header cell at F6. Calc expects an integer value that lies between 1 and the number of columns defined within <emph>Database</emph> and ignores any digits after a decimal point. If the value is less than 1, Calc reports Err:504 (error in parameter list). If the value is greater than the number of columns in <emph>Database</emph>, Calc reports a #VALUE! error." ], "previous_source": "", "target": [ "En saisissant un nombre pour spécifier la colonne dans la zone <emph>Base de données</emph>, en commençant par 1. Par exemple, si une <emph>Base de données</emph> occupait la plage de cellules D6:H123, entrez 3 pour indiquer la cellule d'en-tête en F6. Calc attend une valeur entière comprise entre 1 et le nombre de colonnes définies dans la <emph>Base de données</emph> et ignore les chiffres après une virgule. Si la valeur est inférieure à 1, Calc signale Err:504 (erreur dans la liste des paramètres). Si la valeur est supérieure au nombre de colonnes dans la <emph>Base de données</emph>, Calc rapporte une erreur #VALEUR!" ], "id_hash": 6301850524598392620, "content_hash": 6301850524598392620, "location": "04060101.xhp", "context": "04060101.xhp\npar_id551615889661457\nhelp.text", "note": "6EGoq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 501, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 91, "source_unit": "https://translations.documentfoundation.org/api/units/45527439/?format=api", "priority": 100, "id": 45531583, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=d774aba9da4bd72c", "url": "https://translations.documentfoundation.org/api/units/45531583/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.467851Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "By entering the literal column header name from the first row of the <emph>Database</emph> range, placing quotation marks around the header name. For example, “Distance to School”. If the string does not match one of the <emph>Database</emph> area’s column headings, Calc reports Err:504 (error in parameter list). You can also provide a reference to an arbitrary cell (not within the <emph>Database</emph> and <emph>SearchCriteria</emph> areas) that contains the required string." ], "previous_source": "", "target": [ "En saisissant le nom d'en-tête de colonne littéral à partir de la première ligne de la plage <emph>Base de données</emph>, en plaçant des guillemets autour du nom d'en-tête. Par exemple, « Distance de l'école ». Si la chaîne ne correspond pas à l'un des en-têtes de colonne de la zone <emph>Base de données</emph>, Calc signale Err:504 (erreur dans la liste des paramètres). Vous pouvez également fournir une référence à une cellule arbitraire (sauf dans les zones <emph>Base de données</emph> et <emph>Critère de recherche</emph>) qui contient la chaîne requise." ], "id_hash": -6611146221033473048, "content_hash": -6611146221033473048, "location": "04060101.xhp", "context": "04060101.xhp\npar_id561615889738472\nhelp.text", "note": "qSkvo", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 502, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 69, "source_unit": "https://translations.documentfoundation.org/api/units/45527440/?format=api", "priority": 100, "id": 45531584, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=24407d8a11223be8", "url": "https://translations.documentfoundation.org/api/units/45531584/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.469405Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "The <emph>DatabaseField</emph> argument is optional for the DCOUNT and DCOUNTA functions but it is required for the other ten Database functions." ], "previous_source": "", "target": [ "L'argument <emph>Champ de base de donnés</emph> est facultatif pour les fonctions BDNB et BDNBVAL mais est nécessaire pour les dix autres fonctions de base de données." ], "id_hash": 3916181623576523120, "content_hash": 3916181623576523120, "location": "04060101.xhp", "context": "04060101.xhp\npar_id181615889841279\nhelp.text", "note": "AUEy6", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 503, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/45527441/?format=api", "priority": 100, "id": 45531585, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=b65912701530f170", "url": "https://translations.documentfoundation.org/api/units/45531585/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.471115Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<emph>SearchCriteria argument</emph>" ], "previous_source": "", "target": [ "<emph>Argument Critère de recherche</emph>" ], "id_hash": -6712446939540357011, "content_hash": -6712446939540357011, "location": "04060101.xhp", "context": "04060101.xhp\npar_id841615891322513\nhelp.text", "note": "Af4va", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 504, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/45527442/?format=api", "priority": 100, "id": 45531586, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=22d89912930a006d", "url": "https://translations.documentfoundation.org/api/units/45531586/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.472566Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<emph>SearchCriteria</emph> specifies the range of cells containing search criteria. Like <emph>Database</emph>, its first row is also field names, and subsequent rows are conditions for related fields. The <emph>Database</emph> and <emph>SearchCriteria</emph> areas need not be adjacent, or even on the same sheet." ], "previous_source": "", "target": [ "<emph>Critère de recherche</emph> spécifie la plage de cellules contenant le critère de recherche. Comme pour <emph>Base de données</emph>, sa première ligne contient aussi les noms de champ et les lignes suivantes sont des conditions des champs relatifs. Les zone <emph>Base de données</emph> et <emph>Critère de recherche</emph> n'ont pas besoin d'être adjacentes ou encore sur la même feuille." ], "id_hash": 4907926215799424979, "content_hash": 4907926215799424979, "location": "04060101.xhp", "context": "04060101.xhp\npar_id351615891337585\nhelp.text", "note": "9eBBv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 505, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://translations.documentfoundation.org/api/units/45527443/?format=api", "priority": 100, "id": 45531587, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=c41c74e3d48d47d3", "url": "https://translations.documentfoundation.org/api/units/45531587/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.473654Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "One way of defining the range of cells is to enter the cell reference for the upper left-hand cell, followed by a colon (:), and then the lower right-hand cell reference. For example, A13:B14. The cell range may also be specified by passing the name of a defined named range or database range. If the name does not match the name of a defined range, Calc reports a #NAME? error." ], "previous_source": "", "target": [ "Une façon de définir la plage de cellules est de saisir la référence de cellule pour la cellule en haut à gauche, suivie par deux points (:), puis la référence de cellule en bas à droite. Par exemple, A13:B14. La plage de cellule peut aussi être spécifié en passant le nom d'une plage nommée définie ou d'une plage de base de données. Si le nom ne correspond pas au nom d'une plage définie, Calc renvoie une erreur #NOM?." ], "id_hash": -4850323850409429821, "content_hash": -4850323850409429821, "location": "04060101.xhp", "context": "04060101.xhp\npar_id401615891342289\nhelp.text", "note": "iuFJF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 506, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 70, "source_unit": "https://translations.documentfoundation.org/api/units/45527444/?format=api", "priority": 100, "id": 45531588, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=3cb03027fabdb4c3", "url": "https://translations.documentfoundation.org/api/units/45531588/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.474962Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Err:504 (error in parameter list) may also be reported as a result of an invalid <emph>SearchCriteria</emph> argument." ], "previous_source": "", "target": [ "Err:504 (erreur dans la liste des paramètres) peut aussi être renvoyé comme résultat d'un argument <emph>Critère de recherche</emph> incorrect." ], "id_hash": 2877331431087781332, "content_hash": 2877331431087781332, "location": "04060101.xhp", "context": "04060101.xhp\npar_id861615891345281\nhelp.text", "note": "2BE4W", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 507, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/45527445/?format=api", "priority": 100, "id": 45531589, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=a7ee55b11b0db5d4", "url": "https://translations.documentfoundation.org/api/units/45531589/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.476230Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "The contents of the <emph>SearchCriteria</emph> area are described in more detail in the next section." ], "previous_source": "", "target": [ "Le contenu de la zone <emph>Critère de recherche</emph> est décrit plus en détail dans la section suivante." ], "id_hash": -7207744305524884627, "content_hash": -7207744305524884627, "location": "04060101.xhp", "context": "04060101.xhp\npar_id901615891349688\nhelp.text", "note": "D6TBP", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 508, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/45527446/?format=api", "priority": 100, "id": 45531590, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=1bf8f2be0d583b6d", "url": "https://translations.documentfoundation.org/api/units/45531590/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.477654Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Defining Search Criteria" ], "previous_source": "", "target": [ "Définir un critère de recherche" ], "id_hash": -2034915429092646211, "content_hash": -2034915429092646211, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id481615892281210\nhelp.text", "note": "vj96q", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 509, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/45527447/?format=api", "priority": 100, "id": 45531591, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=63c28732dcf8a2bd", "url": "https://translations.documentfoundation.org/api/units/45531591/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.478999Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "The number of columns occupied by the <emph>SearchCriteria</emph> area need not be the same as the width of the <emph>Database</emph> area. All headings that appear in the first row of <emph>SearchCriteria</emph> must be identical to headings in the first row of <emph>Database</emph>. However, not all headings in <emph>Database</emph> need appear in the first row of <emph>SearchCriteria</emph>, while a heading in <emph>Database</emph> can appear multiple times in the first row of <emph>SearchCriteria</emph>." ], "previous_source": "", "target": [ "Le nombre de colonnes occupé par la zone <emph>Critère de recherche</emph> doit être de la même largeur que la zone <emph>Base de données</emph>. Tous les en-têtes qui apparaissent dans la première ligne de <emph>Critère de recherche</emph> doivent être identiques aux en-têtes de la première de <emph>Base de données</emph>. Cependant, tous les en-têtes dans <emph>Base de données</emph> n'ont pas besoin d'apparaître dans la première ligne de <emph>Critère de recherche</emph>, alors qu'un en-tête dans <emph>Base de données</emph> peut apparaître plusieurs fois dans la première ligne de <emph>Critère de recherche</emph>." ], "id_hash": 1961310625488083016, "content_hash": 1961310625488083016, "location": "04060101.xhp", "context": "04060101.xhp\npar_id691615892329680\nhelp.text", "note": "zTQX5", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 510, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 71, "source_unit": "https://translations.documentfoundation.org/api/units/45527448/?format=api", "priority": 100, "id": 45531592, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=9b37f99f566a9848", "url": "https://translations.documentfoundation.org/api/units/45531592/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.480173Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Search criteria are entered into the cells of the second and subsequent rows of the <emph>SearchCriteria</emph> area, below the row containing headings. Blank cells within the <emph>SearchCriteria</emph> area are ignored." ], "previous_source": "", "target": [ "Les critères de recherche sont saisis dans les cellules de la seconde ligne et des lignes suivantes de la zone <emph>Critère de recherche</emph>, en-dessous de la ligne contenant les en-têtes. Les cellules vides dans la zone <emph>Critère de recherche</emph> sont ignorées." ], "id_hash": 1891804170936273536, "content_hash": 1891804170936273536, "location": "04060101.xhp", "context": "04060101.xhp\npar_id541615892358897\nhelp.text", "note": "AeGHn", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 511, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/45527449/?format=api", "priority": 100, "id": 45531593, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=9a4109dec9424a80", "url": "https://translations.documentfoundation.org/api/units/45531593/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.481675Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Create criteria in the cells of the <emph>SearchCriteria</emph> area using the comparison operators <, <=, =, <>, >=, and >. = is assumed if a cell is not empty but does not start with a comparison operator." ], "previous_source": "", "target": [ "Créez les critères dans les cellules de la zone <emph>Critère de recherche</emph> en utilisant les opérateurs de comparaison <, <=, =, <>, >=, et >. = est supposé si une cellule n'est pas vide mais ne commence pas par un opérateur de comparaison." ], "id_hash": -7933197297307004627, "content_hash": -7933197297307004627, "location": "04060101.xhp", "context": "04060101.xhp\npar_id151615892882441\nhelp.text", "note": "MddCQ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 512, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/45527450/?format=api", "priority": 100, "id": 45531594, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=11e79f1708ed512d", "url": "https://translations.documentfoundation.org/api/units/45531594/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.483448Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "If you write several criteria in one row, they are connected by AND. If you write several criteria in different rows, they are connected by OR." ], "previous_source": "", "target": [ "Si vous écrivez plusieurs critères dans une ligne, ils sont connectés par ET. Si vous écrivez plusieurs critère sur plusieurs lignes, ils sont connectés par OU." ], "id_hash": -495884645594427569, "content_hash": -495884645594427569, "location": "04060101.xhp", "context": "04060101.xhp\npar_id561615893059337\nhelp.text", "note": "4NDMd", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 513, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/45527451/?format=api", "priority": 100, "id": 45531595, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=791e438ac9c60f4f", "url": "https://translations.documentfoundation.org/api/units/45531595/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.485095Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Examples of Database Function Use" ], "previous_source": "", "target": [ "Exemples d'utilisation de fonctions de base de données" ], "id_hash": 82263698742247016, "content_hash": 82263698742247016, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id3150329\nhelp.text", "note": "4sbmh", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 517, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/45527455/?format=api", "priority": 100, "id": 45531599, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=81244265ed70fe68", "url": "https://translations.documentfoundation.org/api/units/45531599/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.490654Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "The following table provides an example database table that is utilized to demonstrate how to use the functions in the Database category. The cell range A1:E10 contains fictitious information about the guests invited to Joe's birthday party. The following information is given for each guest - name, school grade, age in years, distance to school in meters, and weight in kilograms." ], "previous_source": "", "target": [ "Le tableau suivant fournit un exemple de table de base de données qui est utilisé pour démontrer comment utiliser les fonctions dans la catégorie Base de données. La plage de cellules A1:E10 contient des informations fictives à propos d'invités à la fête d'anniversaire de Joe. Les informations suivantes sont données pour chaque invité - nom, niveau d'étude, âge en années, distance de l'école en mètres et poids en kilos." ], "id_hash": -3706208478196243706, "content_hash": -3706208478196243706, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3153713\nhelp.text", "note": "hyFuY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 518, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 61, "source_unit": "https://translations.documentfoundation.org/api/units/45527456/?format=api", "priority": 100, "id": 45531600, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=4c90e70681926306", "url": "https://translations.documentfoundation.org/api/units/45531600/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.491713Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<emph>Name</emph>" ], "previous_source": "", "target": [ "<emph>Nom</emph>" ], "id_hash": 2489576286236621176, "content_hash": 2489576286236621176, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3152992\nhelp.text", "note": "Y2HFt", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 519, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/45527457/?format=api", "priority": 100, "id": 45531601, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=a28cc071265eb978", "url": "https://translations.documentfoundation.org/api/units/45531601/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.492859Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<emph>Grade</emph>" ], "previous_source": "", "target": [ "<emph>Grade</emph>" ], "id_hash": -6820550023249619522, "content_hash": -6820550023249619522, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3155532\nhelp.text", "note": "ChBDv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 520, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/45527458/?format=api", "priority": 100, "id": 45531602, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=215889e4036c95be", "url": "https://translations.documentfoundation.org/api/units/45531602/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.494026Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<emph>Age</emph>" ], "previous_source": "", "target": [ "<emph>Âge</emph>" ], "id_hash": -7493683945518605092, "content_hash": -7493683945518605092, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3156448\nhelp.text", "note": "mt5xM", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 521, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/45527459/?format=api", "priority": 100, "id": 45531603, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=18011627a050dcdc", "url": "https://translations.documentfoundation.org/api/units/45531603/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.495042Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<emph>Distance</emph>" ], "previous_source": "", "target": [ "<emph>Distance</emph>" ], "id_hash": -5376794179463292024, "content_hash": -5376794179463292024, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3154486\nhelp.text", "note": "Svp8Q", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 522, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/45527460/?format=api", "priority": 100, "id": 45531604, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=3561ca2e66b3db88", "url": "https://translations.documentfoundation.org/api/units/45531604/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.496095Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<emph>Weight</emph>" ], "previous_source": "", "target": [ "<emph>Poids</emph>" ], "id_hash": -7607628693707007851, "content_hash": -7607628693707007851, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3152899\nhelp.text", "note": "BShmH", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 523, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/45527461/?format=api", "priority": 100, "id": 45531605, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=166c460290865895", "url": "https://translations.documentfoundation.org/api/units/45531605/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.497363Z" } ] }