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=130
{ "count": 8573, "next": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/units/?format=api&page=131", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/units/?format=api&page=129", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Andy" ], "previous_source": "", "target": [ "André" ], "id_hash": -4697024058665766079, "content_hash": -4697024058665766079, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3151240\nhelp.text", "note": "FUGeA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 524, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/45527462/?format=api", "priority": 100, "id": 45531606, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=3ed0d18129c37341", "url": "https://translations.documentfoundation.org/api/units/45531606/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.498406Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Betty" ], "previous_source": "", "target": [ "Betty" ], "id_hash": 8183219921110613641, "content_hash": 8183219921110613641, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3152870\nhelp.text", "note": "eQx2T", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 525, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/45527463/?format=api", "priority": 100, "id": 45531607, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=f190a32964b2be89", "url": "https://translations.documentfoundation.org/api/units/45531607/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.499707Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Charles" ], "previous_source": "", "target": [ "Charles" ], "id_hash": 5675380127604653403, "content_hash": 5675380127604653403, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3155596\nhelp.text", "note": "HKBAA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 526, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/45527464/?format=api", "priority": 100, "id": 45531608, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=cec30028172fbd5b", "url": "https://translations.documentfoundation.org/api/units/45531608/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.501107Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Daniel" ], "previous_source": "", "target": [ "Daniel" ], "id_hash": 5353091138760302245, "content_hash": 5353091138760302245, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3147296\nhelp.text", "note": "WCaYH", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 527, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/45527465/?format=api", "priority": 100, "id": 45531609, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=ca4a000760195ea5", "url": "https://translations.documentfoundation.org/api/units/45531609/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.502767Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Eva" ], "previous_source": "", "target": [ "Eva" ], "id_hash": -1326974050413721994, "content_hash": -1326974050413721994, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3150456\nhelp.text", "note": "L3gMx", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 528, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/45527466/?format=api", "priority": 100, "id": 45531610, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=6d95a421baedc676", "url": "https://translations.documentfoundation.org/api/units/45531610/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.504321Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Frank" ], "previous_source": "", "target": [ "Franck" ], "id_hash": 3392015103864033513, "content_hash": 3392015103864033513, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3145826\nhelp.text", "note": "bwR2v", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 529, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/45527467/?format=api", "priority": 100, "id": 45531611, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=af12dbc3ea9350e9", "url": "https://translations.documentfoundation.org/api/units/45531611/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.505708Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Greta" ], "previous_source": "", "target": [ "Aïcha" ], "id_hash": 2173543735952262568, "content_hash": 2173543735952262568, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3146137\nhelp.text", "note": "TwrgJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 530, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/45527468/?format=api", "priority": 100, "id": 45531612, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=9e29fa830d35c5a8", "url": "https://translations.documentfoundation.org/api/units/45531612/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.507062Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Harry" ], "previous_source": "", "target": [ "Pierre" ], "id_hash": -2523458783643405867, "content_hash": -2523458783643405867, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3153078\nhelp.text", "note": "TmomQ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 531, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/45527469/?format=api", "priority": 100, "id": 45531613, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=5cfadf9b2b9871d5", "url": "https://translations.documentfoundation.org/api/units/45531613/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.508458Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Irene" ], "previous_source": "", "target": [ "Irène" ], "id_hash": 4014037926274463887, "content_hash": 4014037926274463887, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3148761\nhelp.text", "note": "qBHps", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 532, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/45527470/?format=api", "priority": 100, "id": 45531614, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=b7b4ba3a0688f88f", "url": "https://translations.documentfoundation.org/api/units/45531614/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.509556Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "The following six examples use the database table above, combined with different search criteria areas." ], "previous_source": "", "target": [ "Les six exemples suivants utilisent la table de base de données ci-dessus, combinée avec différentes zones de critères de recherche." ], "id_hash": 2015398111079279618, "content_hash": 2015398111079279618, "location": "04060101.xhp", "context": "04060101.xhp\npar_id221616245476190\nhelp.text", "note": "UDuZW", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 533, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/45527471/?format=api", "priority": 100, "id": 45531615, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=9bf821e76bdfac02", "url": "https://translations.documentfoundation.org/api/units/45531615/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.510585Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Example 1" ], "previous_source": "", "target": [ "Exemple 1" ], "id_hash": -5234726468480303057, "content_hash": -5234726468480303057, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id861616245631924\nhelp.text", "note": "sPtvb", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 534, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/45527472/?format=api", "priority": 100, "id": 45531616, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=375a8402fde5802f", "url": "https://translations.documentfoundation.org/api/units/45531616/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.511648Z" }, { "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": -6059999396084010207, "content_hash": -6059999396084010207, "location": "04060101.xhp", "context": "04060101.xhp\npar_id891616245640933\nhelp.text", "note": "cEWAG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 535, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/45527473/?format=api", "priority": 100, "id": 45531617, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=2be68ea81154b321", "url": "https://translations.documentfoundation.org/api/units/45531617/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.512676Z" }, { "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": 3052647018479648550, "content_hash": 3052647018479648550, "location": "04060101.xhp", "context": "04060101.xhp\npar_id451616245640933\nhelp.text", "note": "AsoFd", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 536, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/45527474/?format=api", "priority": 100, "id": 45531618, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=aa5d2e4a29227f26", "url": "https://translations.documentfoundation.org/api/units/45531618/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.513914Z" }, { "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": -6154905933995018010, "content_hash": -6154905933995018010, "location": "04060101.xhp", "context": "04060101.xhp\npar_id151616245818988\nhelp.text", "note": "Dw3a2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 537, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/45527475/?format=api", "priority": 100, "id": 45531619, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=2a9561a9c24878e6", "url": "https://translations.documentfoundation.org/api/units/45531619/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.515123Z" }, { "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": 7894089805651260093, "content_hash": 7894089805651260093, "location": "04060101.xhp", "context": "04060101.xhp\npar_id481616245878460\nhelp.text", "note": "TdY66", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 538, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/45527476/?format=api", "priority": 100, "id": 45531620, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=ed8d70da82e032bd", "url": "https://translations.documentfoundation.org/api/units/45531620/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.516252Z" }, { "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": -6395470323821589166, "content_hash": -6395470323821589166, "location": "04060101.xhp", "context": "04060101.xhp\npar_id741616245891772\nhelp.text", "note": "ggUUj", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 539, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/45527477/?format=api", "priority": 100, "id": 45531621, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=273eb9a0090fcd52", "url": "https://translations.documentfoundation.org/api/units/45531621/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.517369Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "As in this simple example, it is sometimes desirable (but not essential) to place the search criteria area directly under the database table, with the columns of the two areas vertically aligned. Blank entries in the search criteria area are ignored. With the above example database table and this search criteria area, insert the formula <item type=\"input\">=DCOUNT(A1:E10;;A12:E14)</item> into an empty cell elsewhere in the sheet to count how many of Joe’s guests travel further than 600 meters to school. The value 5 is returned (counting Betty, Daniel, Eva, Harry, and Irene)." ], "previous_source": "", "target": [ "Comme dans cette exemple, il est parfois souhaitable (mais pas essentiel) de placer les critères de recherche directement sous la table de base de données, avec les colonnes des deux zones alignées verticalement. Les entrées vides dans la zone de critères de recherche sont ignorées. Avec l'exemple ci-dessus de table de base de données et de zone de critères de recherche, insérez la formule <item type=\"input\">=BDNB(A1;E10;A12:E14)</item> dans une cellule vide autre part dans la feuille opur compter combien des invités de Joe voyagent plus de 600 mètres pour se rendre à l'école. La valeur 5 est renvoyée (en comptant Betty, Daniel, Eva, Harry et Irène)." ], "id_hash": -2265215871166592434, "content_hash": -2265215871166592434, "location": "04060101.xhp", "context": "04060101.xhp\npar_id451616246535763\nhelp.text", "note": "4SkNQ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 540, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 91, "source_unit": "https://translations.documentfoundation.org/api/units/45527479/?format=api", "priority": 100, "id": 45531623, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=6090562ab389ca4e", "url": "https://translations.documentfoundation.org/api/units/45531623/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.519676Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Note also that the formula <item type=\"input\">=DCOUNT(A1:E10;;D12:D13)</item> returns exactly the same value, demonstrating that it is only necessary for the search criteria area to contain relevant column headings." ], "previous_source": "", "target": [ "Remarquez également que la formule <item type=\"input\">=BDNB(A1:E10;D12:D13)</item> renvoie exactement la même valeur, démontrant qu'il suffit que la zone des critères de recherche contienne des en-têtes de colonnes pertinents." ], "id_hash": -502229047337922985, "content_hash": -502229047337922985, "location": "04060101.xhp", "context": "04060101.xhp\npar_id731616246561901\nhelp.text", "note": "bBHFr", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 541, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/45527480/?format=api", "priority": 100, "id": 45531624, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=7907b957a58a4e57", "url": "https://translations.documentfoundation.org/api/units/45531624/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.521212Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Example 2" ], "previous_source": "", "target": [ "Exemple 2" ], "id_hash": 8586984018776430693, "content_hash": 8586984018776430693, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id191616246773750\nhelp.text", "note": "VyrBb", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 542, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/45527481/?format=api", "priority": 100, "id": 45531625, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=f72b187823201865", "url": "https://translations.documentfoundation.org/api/units/45531625/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.522423Z" }, { "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": -7039863768950871566, "content_hash": -7039863768950871566, "location": "04060101.xhp", "context": "04060101.xhp\npar_id71616246804093\nhelp.text", "note": "V4PCC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 543, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/45527482/?format=api", "priority": 100, "id": 45531626, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=1e4d6133708a69f2", "url": "https://translations.documentfoundation.org/api/units/45531626/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.523725Z" }, { "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": -7748343131352010190, "content_hash": -7748343131352010190, "location": "04060101.xhp", "context": "04060101.xhp\npar_id41616250394431\nhelp.text", "note": "KjH3p", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 544, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/45527483/?format=api", "priority": 100, "id": 45531627, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=14785af979ecf232", "url": "https://translations.documentfoundation.org/api/units/45531627/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.524781Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "In this example the search criteria area contains only two headings and these are not vertically aligned with the corresponding headings in the example database table. Since there are two conditions in the same row, these are connected by AND. With the above example database table and this search criteria area, insert the formula <item type=\"input\">=DCOUNT(A1:E10;;B12:C13)</item> into an empty cell elsewhere in the sheet to count how many of Joe’s guests are in grade 2 and greater than 7 years old. The value 2 is returned (counting Eva and Irene)." ], "previous_source": "", "target": [ "Dans cet exemple la zone de critères de recherche contient seulement deux en-têtes et ceux-ci ne sont pas alignés verticalement avec les en-têtes correspondants de la table de base de données exemple. Dans la mesure où il y a deux conditions sur la même ligne, ceux-ci sont connectés par ET. Avec la table de base de données exemple ci-dessus et cette zone de critères de recherche, insérez la formule <item type=\"input\">=BDNB(A1:E10;B12:C13)</item> dans une cellule vide autre part dans la feuille pour compter combien des invités de Joe sont au niveau d'étude 2 et âgés de plus de 7 ans. La valeur 2 est renvoyée (comptant Eva et Irène)." ], "id_hash": -8139039694367435245, "content_hash": -8139039694367435245, "location": "04060101.xhp", "context": "04060101.xhp\npar_id361616251794063\nhelp.text", "note": "hfPeb", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 545, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 90, "source_unit": "https://translations.documentfoundation.org/api/units/45527485/?format=api", "priority": 100, "id": 45531629, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=0f0c52853c6cd613", "url": "https://translations.documentfoundation.org/api/units/45531629/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.526945Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Example 3" ], "previous_source": "", "target": [ "Exemple 3" ], "id_hash": 911904328441734396, "content_hash": 911904328441734396, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id221616251986854\nhelp.text", "note": "6Tfyk", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 546, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/45527486/?format=api", "priority": 100, "id": 45531630, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=8ca7bc27bde924fc", "url": "https://translations.documentfoundation.org/api/units/45531630/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.528488Z" }, { "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": -4858803826530149922, "content_hash": -4858803826530149922, "location": "04060101.xhp", "context": "04060101.xhp\npar_id141616251871487\nhelp.text", "note": "kAXbc", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 547, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/45527487/?format=api", "priority": 100, "id": 45531631, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=3c920fa9ae5c99de", "url": "https://translations.documentfoundation.org/api/units/45531631/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.529865Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "In this example the search criteria area contains only one heading. Since there are two conditions in consecutive rows, these are connected by OR. With the above example database table and this search criteria area, insert the formula <item type=\"input\">=DCOUNT(A1:E10;;B12:B14)</item> into an empty cell elsewhere in the sheet to count how many of Joe’s guests are either 9 or 10 years old. The value 4 is returned (counting Andy, Betty, Charles, and Harry)." ], "previous_source": "", "target": [ "Dans cet exemple, la zone des critères de recherche ne contient qu'un seul en-tête. Puisqu'il y a deux conditions sur des lignes consécutives, celles-ci sont reliées par OU. Avec l'exemple de table de base de données ci-dessus et cette zone de critères de recherche, insérez la formule <item type=\"input\">=BDNB(A1:E10;B12:B14)</item> dans une cellule vide ailleurs dans la feuille pour compter combien d'invités de Joe sont âgés 9 ou 10 ans. La valeur 4 est renvoyée (en comptant Andy, Betty, Charles et Harry)." ], "id_hash": 2665154283656902008, "content_hash": 2665154283656902008, "location": "04060101.xhp", "context": "04060101.xhp\npar_id351616252313215\nhelp.text", "note": "CQA2G", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 548, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 73, "source_unit": "https://translations.documentfoundation.org/api/units/45527488/?format=api", "priority": 100, "id": 45531632, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=a4fc87b34cfaf578", "url": "https://translations.documentfoundation.org/api/units/45531632/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.531308Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Example 4" ], "previous_source": "", "target": [ "Exemple 4" ], "id_hash": -4662874895325839425, "content_hash": -4662874895325839425, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id71616252395407\nhelp.text", "note": "GFADM", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 549, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/45527489/?format=api", "priority": 100, "id": 45531633, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=3f4a23fcd8043fbf", "url": "https://translations.documentfoundation.org/api/units/45531633/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.532816Z" }, { "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": -5269598212477428295, "content_hash": -5269598212477428295, "location": "04060101.xhp", "context": "04060101.xhp\npar_id451616252413665\nhelp.text", "note": "kNw3F", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 550, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/45527490/?format=api", "priority": 100, "id": 45531634, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=36dea058643fddb9", "url": "https://translations.documentfoundation.org/api/units/45531634/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.534200Z" }, { "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": -2346374291651790593, "content_hash": -2346374291651790593, "location": "04060101.xhp", "context": "04060101.xhp\npar_id431616252540783\nhelp.text", "note": "QPqDb", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 551, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/45527491/?format=api", "priority": 100, "id": 45531635, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=5f7001036bfc78ff", "url": "https://translations.documentfoundation.org/api/units/45531635/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.535581Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "In this example the search criteria area contains two occurrences of the same heading. Since there are two conditions in the same row, these are connected by AND. With the above example database table and this search criteria area, insert the formula <item type=\"input\">=DCOUNT(A1:E10;;B12:C13)</item> into an empty cell elsewhere in the sheet to count how many of Joe’s guests are aged between 8 and 10 (inclusive). The value 6 is returned (counting Andy, Betty, Charles, Eva, Harry, and Irene)." ], "previous_source": "", "target": [ "Dans cet exemple, la zone des critères de recherche contient deux occurrences du même en-tête. Puisqu'il y a deux conditions sur la même ligne, elles sont reliées par ET. Avec l'exemple de table de base de données ci-dessus et cette zone de critères de recherche, insérez la formule <item type=\"input\">=BDNB(A1:E10;B12:C13)</item> dans une cellule vide ailleurs dans la feuille pour compter combien d'invités de Joe ont entre 8 et 10 ans (inclus). La valeur 6 est renvoyée (en comptant Andy, Betty, Charles, Eva, Harry et Irène)." ], "id_hash": -2146421101149350830, "content_hash": -2146421101149350830, "location": "04060101.xhp", "context": "04060101.xhp\npar_id991616252981928\nhelp.text", "note": "6Dk9D", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 552, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 79, "source_unit": "https://translations.documentfoundation.org/api/units/45527494/?format=api", "priority": 100, "id": 45531638, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=6236616177971452", "url": "https://translations.documentfoundation.org/api/units/45531638/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.538752Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Example 5" ], "previous_source": "", "target": [ "Exemple 5" ], "id_hash": -324658860970524845, "content_hash": -324658860970524845, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id561616253067881\nhelp.text", "note": "vgeRe", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 553, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/45527495/?format=api", "priority": 100, "id": 45531639, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=7b7e947c6eab3f53", "url": "https://translations.documentfoundation.org/api/units/45531639/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.539913Z" }, { "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": -2193654779250235911, "content_hash": -2193654779250235911, "location": "04060101.xhp", "context": "04060101.xhp\npar_id301616253073598\nhelp.text", "note": "yvXQo", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 554, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/45527496/?format=api", "priority": 100, "id": 45531640, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=618e9299caf3a5f9", "url": "https://translations.documentfoundation.org/api/units/45531640/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.540930Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Example 6" ], "previous_source": "", "target": [ "Exemple 6" ], "id_hash": 4840185821901800294, "content_hash": 4840185821901800294, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id121616253593255\nhelp.text", "note": "BAnVJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 556, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/45527499/?format=api", "priority": 100, "id": 45531643, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=c32bcb5c5156c366", "url": "https://translations.documentfoundation.org/api/units/45531643/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.544231Z" }, { "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": -7954698572275290402, "content_hash": -7954698572275290402, "location": "04060101.xhp", "context": "04060101.xhp\npar_id731616253599063\nhelp.text", "note": "3RcET", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 557, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/45527500/?format=api", "priority": 100, "id": 45531644, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=119b3bcb58396ede", "url": "https://translations.documentfoundation.org/api/units/45531644/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.545262Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DBANZAHL\">DCOUNT counts the number of cells (fields) of the specified column that contain numeric values, for all rows (database records) that match the specified search criteria.</ahelp> However, if no column is specified, DCOUNT returns the count of all records that match the specified search criteria irrespective of their contents." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_DBANZAHL\">BDNB compte le nombre de cellules (champs) de la colonne spécifiée qui contient les valeurs numériques, pour toutes les lignes (enregistrements de base de données) qui correspondent aux critères de recherche spécifiés.</ahelp> Cependant, si aucune colonne n'est spécifiée, BDNB renvoie le nombre de tous les enregistrements qui correspondent aux critères de recherche spécifiés quel que soit leur contenu." ], "id_hash": 1483139158921304215, "content_hash": 1483139158921304215, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3156133\nhelp.text", "note": "RAGuV", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 561, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 50, "source_unit": "https://translations.documentfoundation.org/api/units/45527504/?format=api", "priority": 100, "id": 45531648, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=94952b34fff9d897", "url": "https://translations.documentfoundation.org/api/units/45531648/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.550966Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:E13 are blank, except for cell D13 which should contain \">600\" (this search criterion will match records in the database table that have a value greater than 600 in the Distance column)." ], "previous_source": "", "target": [ "L'exemple de table de base de données donnant des informations sur les hôtes invités à la fête d'anniversaire de Joe (décrite ci-dessus) doit occuper les cellules A1:E10. Le contenu des cellules A12:E12 doit être identique aux étiquettes d'en-tête de la table de base de données dans les cellules A1:E1. Assurez-vous que les cellules A13:E13 sont vides, à l'exception de la cellule D13 qui doit contenir \">600\" (ce critère de recherche correspondra aux enregistrements de la table de base de données qui ont une valeur supérieure à 600 dans la colonne Distance)." ], "id_hash": -4908936595083014625, "content_hash": -4908936595083014625, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3153623\nhelp.text", "note": "KYvAJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 563, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 75, "source_unit": "https://translations.documentfoundation.org/api/units/45527505/?format=api", "priority": 100, "id": 45531649, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=3bdff42ce9294e1f", "url": "https://translations.documentfoundation.org/api/units/45531649/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.553398Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Insert the formula <input>=DCOUNT(A1:E10;; A12:E13)</input> into an empty cell elsewhere in the sheet to calculate how many of Joe’s party guests travel further than 600 meters to school. The value 5 is returned." ], "previous_source": "", "target": [ "Insérez la formule <input>=BDNB(A1:E10; A12:E13)</input> dans une cellule vide ailleurs dans la feuille pour calculer combien d'invités de Joe sont à plus de 600 mètres de l'école. La valeur 5 est renvoyée." ], "id_hash": 8615944371971135905, "content_hash": 8615944371971135905, "location": "04060101.xhp", "context": "04060101.xhp\npar_id441616368480646\nhelp.text", "note": "kVciZ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 564, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/45527506/?format=api", "priority": 100, "id": 45531650, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=f791fbc1cfdd99a1", "url": "https://translations.documentfoundation.org/api/units/45531650/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.554549Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "The same result is obtained if you use the formula <input>=DCOUNT(A1:E10; \"Distance\"; A12:E13)</input>, because all entries in the Distance column are numeric. However, if you use the formula <input>=DCOUNT(A1:E10; \"Name\"; A12:E13)</input>, the value 0 is returned because all entries in the Name column are non-numeric." ], "previous_source": "", "target": [ "Le même résultat est obtenu si vous utilisez la formule <input>=BDNB(A1:E10; \"Distance\"; A12:E13)</input>, car toutes les entrées de la colonne Distance sont numériques. Cependant, si vous utilisez la formule <input>=BDNB(A1:E10; \"Nom\"; A12:E13)</input>, la valeur 0 est renvoyée car toutes les entrées de la colonne Nom ne sont pas numériques." ], "id_hash": 4818335463995276433, "content_hash": 4818335463995276433, "location": "04060101.xhp", "context": "04060101.xhp\npar_id361616368488119\nhelp.text", "note": "UZFcp", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 565, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 45, "source_unit": "https://translations.documentfoundation.org/api/units/45527507/?format=api", "priority": 100, "id": 45531651, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=c2de2a936c1afc91", "url": "https://translations.documentfoundation.org/api/units/45531651/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.555662Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DBANZAHL2\">DCOUNTA counts the number of cells (fields) of the specified column that are not blank, for all rows (database records) that match the specified search criteria.</ahelp> Blank cells of the specified column are not counted. However, if no column is specified, DCOUNTA returns the count of all records that match the specified search criteria irrespective of their contents." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_DBANZAHL2\">BDNBVAL compte le nombre de cellules (champs) de la colonne spécifiée qui ne sont pas vides, pour toutes les lignes (enregistrements de base de données) qui correspondent aux critères de recherche spécifiés.</ahelp> Les cellules vides de la colonne spécifiée ne sont pas comptées. Cependant, si aucune colonne n'est spécifiée, BDNBVAL renvoie le nombre de tous les enregistrements qui correspondent aux critères de recherche spécifiés, quel que soit leur contenu." ], "id_hash": 7270039479559557665, "content_hash": 7270039479559557665, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3156110\nhelp.text", "note": "T7ebL", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 568, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 59, "source_unit": "https://translations.documentfoundation.org/api/units/45527509/?format=api", "priority": 100, "id": 45531653, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=e4e45e636a369221", "url": "https://translations.documentfoundation.org/api/units/45531653/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.559266Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:E13 are blank, except for cell D13 which should contain \">600\" (this search criterion will match records in the database table that have a value greater than 600 in the Distance column)." ], "previous_source": "", "target": [ "L'exemple de table de base de données donnant des informations sur les hôtes invités à la fête d'anniversaire de Joe (décrite ci-dessus) doit occuper les cellules A1:E10. Le contenu des cellules A12:E12 doit être identique aux étiquettes d'en-tête de la table de base de données dans les cellules A1:E1. Assurez-vous que les cellules A13:E13 sont vides, à l'exception de la cellule D13 qui doit contenir \">600\" (ce critère de recherche correspondra aux enregistrements de la table de base de données qui ont une valeur supérieure à 600 dans la colonne Distance)." ], "id_hash": -5841457304444537664, "content_hash": -5841457304444537664, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3153982\nhelp.text", "note": "dLvi2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 570, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 75, "source_unit": "https://translations.documentfoundation.org/api/units/45527510/?format=api", "priority": 100, "id": 45531654, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=2eeef987edf8f4c0", "url": "https://translations.documentfoundation.org/api/units/45531654/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.561976Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Insert the formula <input>=DCOUNTA(A1:E10;; A12:E13)</input> into an empty cell elsewhere in the sheet to calculate how many of Joe’s party guests travel further than 600 meters to school. The value 5 is returned." ], "previous_source": "", "target": [ "Insérez la formule <input>=BDNBVAL(A1:E10;A12:E13)</input> dans une cellule vide ailleurs dans la feuille de calcul pour calcule combien d'invités de Joe sont éloignés de plus de 600 mètres de l'école. La valeur 5 est renvoyée." ], "id_hash": 766938552696551172, "content_hash": 766938552696551172, "location": "04060101.xhp", "context": "04060101.xhp\npar_id61616368616093\nhelp.text", "note": "SSD7D", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 571, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/45527511/?format=api", "priority": 100, "id": 45531655, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=8aa4b68cde07b704", "url": "https://translations.documentfoundation.org/api/units/45531655/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.563535Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "The same result is obtained if you use the formula <input>=DCOUNTA(A1:E10; \"Distance\"; A12:E13)</input> or the formula <input>=DCOUNTA(A1:E10; \"Name\"; A12:E13)</input>. The latter case reflects that in contrast to DCOUNT, DCOUNTA counts both numeric and alphanumeric values in the column indicated by the <emph>DatabaseField</emph> argument." ], "previous_source": "", "target": [ "Le même résultat est obtenu si vous utilisez la formule <input>=BDNBVAL(A1:E10;\"Distance\";A12:E13)</input> ou la formule <input>=BDNBVAL(A1:E10; \"Nom\"; A12:E13)</input>. Le dernier cas reflète que contrairement à BDNB, BDNBVAL compte à la fois les valeurs numériques et alphanumériques dans la colonne indiquée par l'argument <emph>Champ de base de données</emph>." ], "id_hash": 7257426684067171338, "content_hash": 7257426684067171338, "location": "04060101.xhp", "context": "04060101.xhp\npar_id841616368623207\nhelp.text", "note": "WyEGc", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 572, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 43, "source_unit": "https://translations.documentfoundation.org/api/units/45527512/?format=api", "priority": 100, "id": 45531656, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=e4b78f1e1f43cc0a", "url": "https://translations.documentfoundation.org/api/units/45531656/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.565001Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DBAUSZUG\">DGET returns the contents of the cell (field) of the specified column, for the single row (database record) that matches the specified search criteria.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_DBAUSZUG\">BDLIRE renvoie le contenu des cellules (champs) de la colonne spécifié, pour une seule ligne (enregistrement de base de données) qui correspond aux critères de recherche spécifiés.</ahelp>" ], "id_hash": -8754729041208694592, "content_hash": -8754729041208694592, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3152801\nhelp.text", "note": "WwRCV", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 575, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/45527514/?format=api", "priority": 100, "id": 45531658, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=0680f45251f5a8c0", "url": "https://translations.documentfoundation.org/api/units/45531658/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.569556Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Calc reports Err:502 (invalid argument) if multiple matches are found, or a #VALUE! error (wrong data type) if no matches are found. A #VALUE! error is also reported if a single match is found but the relevant cell is empty." ], "previous_source": "", "target": [ "Calc renvoie une Err:502 (argument incorrect) si plusieurs correspondances sont trouvées, ou une erreur #VALEUR! (mauvais type de données) si aucune correspondance n'est trouvée. Une erreur #VALEUR! est également renvoyée si une seule correspondance est trouvée mais que la cellule correspondante est vide." ], "id_hash": 4751847368264665738, "content_hash": 4751847368264665738, "location": "04060101.xhp", "context": "04060101.xhp\npar_id171616180137385\nhelp.text", "note": "GxBWY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 576, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 40, "source_unit": "https://translations.documentfoundation.org/api/units/45527515/?format=api", "priority": 100, "id": 45531659, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=c1f1f4014c4a4a8a", "url": "https://translations.documentfoundation.org/api/units/45531659/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.570862Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:E13 are blank, except for cell C13 which should contain \"11\" (this search criterion will match records in the database table that have a value of 11 in the Age column)." ], "previous_source": "", "target": [ "L'exemple de table de base de données donnant des informations sur les hôtes invités à la fête d'anniversaire de Joe (décrite ci-dessus) doit occuper les cellules A1:E10. Le contenu des cellules A12:E12 doit être identique aux étiquettes d'en-tête de la table de base de données dans les cellules A1:E1. Assurez-vous que les cellules A13:E13 sont vides, à l'exception de la cellule C13 qui doit contenir \"11\" (ce critère de recherche correspondra aux enregistrements de la table de base de données qui ont une valeur de 11 dans la colonne Âge)." ], "id_hash": 6083915940761712785, "content_hash": 6083915940761712785, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3155388\nhelp.text", "note": "G2EsJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 578, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 74, "source_unit": "https://translations.documentfoundation.org/api/units/45527516/?format=api", "priority": 100, "id": 45531660, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=d46e69506c703891", "url": "https://translations.documentfoundation.org/api/units/45531660/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.573305Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Insert the formula <input>=DGET(A1:E10; \"Name\"; A12:E13)</input> into an empty cell elsewhere in the sheet to find the name of Joe’s party guest who is age 11. The name Daniel is returned." ], "previous_source": "", "target": [ "Insérez la formule <input>=BDLIRE(A1:E10;\"Nom\"; A12:E13)</input> dans une cellule vide ailleurs dans la feuille pour trouver le nom de l'invité de Joe qui a 11 ans. Le nom Daniel est renvoyé." ], "id_hash": 1756185399227638645, "content_hash": 1756185399227638645, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3153096\nhelp.text", "note": "A942C", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 579, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/45527517/?format=api", "priority": 100, "id": 45531661, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=985f3950e0b0e375", "url": "https://translations.documentfoundation.org/api/units/45531661/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.574735Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "If you change the value in cell C13 to “10”, then the formula <input>=DGET(A1:E10; \"Name\"; A12:E13)</input> returns an invalid argument error (Err:502). The reflects that multiple records match the specified criterion (both Betty and Charles are age 10)." ], "previous_source": "", "target": [ "Si vous modifiez la valeur de la cellule C13 à \"10\", alors la formule <input>=BDLIRE(A1:E10;\"Nom\";A12:E13)</input> renvoie une erreur d'argument invalide (Err:502). Cela reflète que plusieurs enregistrement correspondent au critère spécifique (Betty et Charles ont tous les deux 10 ans)." ], "id_hash": 8525727055743563041, "content_hash": 8525727055743563041, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3150524\nhelp.text", "note": "6AKoj", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 580, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/45527518/?format=api", "priority": 100, "id": 45531662, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=f651779601883521", "url": "https://translations.documentfoundation.org/api/units/45531662/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:29.575845Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DBMAX\">DMAX calculates the maximum value across the cells (fields) of the specified column that contain numeric values, for all rows (database records) that match the specified search criteria.</ahelp> Blank cells or cells containing non-numeric characters are not included." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_DBMAX\">BDMAX calcule la valeur maximale à travers les cellules (champs) de la colonne spécifiée qui contient des valeurs numériques, pour toutes les lignes (enregistrements de base de données) qui correspondent au critère de recherche spécifique.</ahelp> Les cellules vides ou les cellules contenant des caractères non numériques ne sont pas incluses." ], "id_hash": 5866006761851499666, "content_hash": 5866006761851499666, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3154903\nhelp.text", "note": "9ek2J", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 583, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://translations.documentfoundation.org/api/units/45527520/?format=api", "priority": 100, "id": 45531664, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=d1683e120a32b492", "url": "https://translations.documentfoundation.org/api/units/45531664/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:30.069201Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Returns 0 if no matches are found, or if there are no non-zero numeric values in the cells of the specified column for the matching records." ], "previous_source": "", "target": [ "Renvoie 0 si aucune correspondance n'est trouvée, ou s'il n'y a pas de valeurs numériques différentes de zéro dans les cellules de la colonne spécifiée pour les enregistrements correspondants." ], "id_hash": 461198565969660414, "content_hash": 461198565969660414, "location": "04060101.xhp", "context": "04060101.xhp\npar_id51616180409281\nhelp.text", "note": "pUGwd", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 584, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/45527521/?format=api", "priority": 100, "id": 45531665, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=866681a6f78a89fe", "url": "https://translations.documentfoundation.org/api/units/45531665/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:30.071114Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:E13 are blank, except for cell D13 which should contain \">0\" (this search criterion is intended to match all records in the database table)." ], "previous_source": "", "target": [ "L'exemple de table de base de données donnant des informations sur les hôtes invités à la fête d'anniversaire de Joe (décrite ci-dessus) doit occuper les cellules A1:E10. Le contenu des cellules A12:E12 doit être identique aux étiquettes d'en-tête de la table de base de données dans les cellules A1:E1. Assurez-vous que les cellules A13:E13 sont vides, à l'exception de la cellule D13 qui doit contenir \">0\" (ce critère de recherche est destiné à correspondre à tous les enregistrements de la table de la base de données)." ], "id_hash": 171330541003347509, "content_hash": 171330541003347509, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3148442\nhelp.text", "note": "S57iG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 586, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 67, "source_unit": "https://translations.documentfoundation.org/api/units/45527522/?format=api", "priority": 100, "id": 45531666, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=8260b03823ae1635", "url": "https://translations.documentfoundation.org/api/units/45531666/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:30.074907Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Insert the formula <input>=DMAX(A1:E10; \"Distance\"; A12:E13)</input> into an empty cell elsewhere in the sheet to find the maximum distance in meters that any of Joe’s party guests travel to school. The value 1200 is returned." ], "previous_source": "", "target": [ "Insérez la formule <input>=DMAX(A1:E10;\"Distance\";A12:E13)</input> dans une cellule vide ailleurs dans la feuille pour trouver la distance maximale en mètres que les invités de la fête de Joe parcourent pour se rendre à l'école. La valeur 1200 est renvoyée." ], "id_hash": 4686675797043308700, "content_hash": 4686675797043308700, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3148804\nhelp.text", "note": "Mqocw", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 587, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/45527523/?format=api", "priority": 100, "id": 45531667, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=c10a6ace6c2fe89c", "url": "https://translations.documentfoundation.org/api/units/45531667/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:42:30.076303Z" } ] }