Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-24-2/textsbasicshared03/fr/units/?format=api&page=13
{ "count": 4173, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/units/?format=api&page=14", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/units/?format=api&page=12", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "Clears the values and formulas in the given range." ], "previous_source": "", "target": [ "Efface les valeurs et les formules dans la plage donnée." ], "id_hash": -211947956509725497, "content_hash": -211947956509725497, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id841592919928169\nhelp.text", "note": "sMwMp", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 601, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/110306114/?format=api", "priority": 100, "id": 110978331, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=7d0f0274dd5e2cc7", "url": "https://translations.documentfoundation.org/api/units/110978331/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.314107Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "A filter formula can be specified to determine which cells shall be affected." ], "previous_source": "", "target": [ "Une formule de filtre peut être spécifiée pour déterminer quelles cellules seront affectées." ], "id_hash": -1998467332129551900, "content_hash": -1998467332129551900, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id961670941801218\nhelp.text", "note": "te7oW", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 602, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/110306142/?format=api", "priority": 100, "id": 110978357, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=6444048cbd3209e4", "url": "https://translations.documentfoundation.org/api/units/110978357/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.362655Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "<emph>range</emph>: The range whose values and formulas are to be cleared, as a string." ], "previous_source": "", "target": [ "<emph>plage</emph> : la plage dont les valeurs et les formules doivent être effacées, sous forme de chaîne." ], "id_hash": -7769254828280313876, "content_hash": -7769254828280313876, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id771592919928320\nhelp.text", "note": "eEGn9", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 603, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/110306163/?format=api", "priority": 100, "id": 110978362, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=142e0fe59edd07ec", "url": "https://translations.documentfoundation.org/api/units/110978362/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.365371Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "Refer to the <link href=\"text/sbasic/shared/03/sf_calc.xhp#ClearAll\"><literal>ClearAll</literal></link> method documentation for examples on how to use the arguments <literal>filterformula</literal> and <literal>filterscope</literal>." ], "previous_source": "", "target": [ "Reportez-vous à la documentation de la méthode <link href=\"text/sbasic/shared/03/sf_calc.xhp#ClearAll\"><literal>ClearAll</literal></link> pour des exemples d'utilisation des arguments <literal>filterformula</literal> et <literal>filterscope</literal>." ], "id_hash": 8216444303221636011, "content_hash": 8216444303221636011, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id461670942483664\nhelp.text", "note": "ZhT2V", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 604, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/110306182/?format=api", "priority": 100, "id": 110978366, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=f206ac8faa4ebbab", "url": "https://translations.documentfoundation.org/api/units/110978366/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.367941Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "Deletes the columns of a specified range that match a filter expressed as a Calc formula. The filter is applied to each column to decide whether it will be deleted or not." ], "previous_source": "", "target": [ "Supprime les colonnes d'une plage spécifiée qui correspondent à un filtre exprimé sous forme de formule Calc. Le filtre est appliqué à chaque colonne pour décider si elle sera supprimée ou non." ], "id_hash": -4428709390617110551, "content_hash": -4428709390617110551, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id841592919903025\nhelp.text", "note": "JWFDb", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 605, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/110306195/?format=api", "priority": 100, "id": 110978381, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=428a104606d497e9", "url": "https://translations.documentfoundation.org/api/units/110978381/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.385161Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "The deleted column can be limited to the height of the specified range or span to the height of the entire sheet, thus deleting whole columns." ], "previous_source": "", "target": [ "La colonne supprimée peut être limitée à la hauteur de la plage spécifiée ou s'étendre à la hauteur de la feuille entière, supprimant ainsi des colonnes entières." ], "id_hash": 5080325284826677507, "content_hash": 5080325284826677507, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id601652269911029\nhelp.text", "note": "4JWnp", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 606, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/110306211/?format=api", "priority": 100, "id": 110978390, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=c680f0ee09878103", "url": "https://translations.documentfoundation.org/api/units/110978390/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.392782Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "This method returns a string with the range address of the compacted range. If all columns are deleted, then an empty string is returned." ], "previous_source": "", "target": [ "Cette méthode renvoie une chaîne avec l'adresse de plage de la plage compactée. Si toutes les colonnes sont supprimées, une chaîne vide est renvoyée." ], "id_hash": 722958235720951935, "content_hash": 722958235720951935, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id701652271281106\nhelp.text", "note": "VAVU3", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 607, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/110306235/?format=api", "priority": 100, "id": 110978394, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=8a0876af5b97287f", "url": "https://translations.documentfoundation.org/api/units/110978394/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.395551Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "If a range of cells is selected, calling this method will not impact the selection." ], "previous_source": "", "target": [ "Si une plage de cellules est sélectionnée, l'appel de cette méthode n'aura pas d'impact sur la sélection." ], "id_hash": 6729834233954197878, "content_hash": 6729834233954197878, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id191652271892064\nhelp.text", "note": "j2GAb", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 608, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/110306462/?format=api", "priority": 100, "id": 110978396, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=dd652c94601a6176", "url": "https://translations.documentfoundation.org/api/units/110978396/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.397640Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "<emph>range</emph>: The range from which columns will be deleted, as a string." ], "previous_source": "", "target": [ "<emph>range</emph> : la plage à partir de laquelle les colonnes seront supprimées, sous forme de chaîne." ], "id_hash": -8113506369559715658, "content_hash": -8113506369559715658, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id771592919922181\nhelp.text", "note": "WsrKe", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 609, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/110306480/?format=api", "priority": 100, "id": 110978401, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=0f6708f1af8620b6", "url": "https://translations.documentfoundation.org/api/units/110978401/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.401971Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "<emph>wholecolumn</emph>: If this option is set to <literal>True</literal> the entire column will be deleted from the sheet. The default value is <literal>False</literal>, which means that the deleted column will be limited to the height of the specified <literal>range</literal>." ], "previous_source": "", "target": [ "<emph>wholecolumn</emph> : si cette option est définie sur <literal>True</literal>, la colonne entière sera supprimée de la feuille. La valeur par défaut est <literal>False</literal>, ce qui signifie que la colonne supprimée sera limitée à la hauteur de la <literal>plage</literal> spécifiée." ], "id_hash": -4559422940038411441, "content_hash": -4559422940038411441, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id771592919932260\nhelp.text", "note": "Q9QBp", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 610, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/110306487/?format=api", "priority": 100, "id": 110978403, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=40b9acfe2e3e4b4f", "url": "https://translations.documentfoundation.org/api/units/110978403/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.404621Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "<emph>filterformula</emph>: The filter to be applied to each column to determine whether or not it will be deleted. The filter is expressed as a Calc formula that should be applied to the first column. When the formula returns <emph>True</emph> for a column, that column will be deleted. The default filter deletes all empty columns." ], "previous_source": "", "target": [ "<emph>filterformula</emph> : le filtre à appliquer à chaque colonne pour déterminer si elle sera supprimée ou non. Le filtre est exprimé sous la forme d'une formule Calc qui doit être appliquée à la première colonne. Lorsque la formule renvoie <emph>True</emph> pour une colonne, cette colonne sera supprimée. Le filtre par défaut supprime toutes les colonnes vides." ], "id_hash": -7737930351596275317, "content_hash": -7737930351596275317, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id771592919915974\nhelp.text", "note": "M7qto", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 611, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 54, "source_unit": "https://translations.documentfoundation.org/api/units/110306497/?format=api", "priority": 100, "id": 110978408, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=149d5957b063f98b", "url": "https://translations.documentfoundation.org/api/units/110978408/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.407359Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "For example, suppose range <emph>A1:J200</emph> is selected (height = 200), so the default formula is <emph>=(COUNTBLANK(A1:A200)=200)</emph>. This means that if all 200 cells are empty in the first column (Column A), then the column is deleted. Note that the formula is expressed with respect to the first column only. Internally the <literal>CompactLeft</literal> method will generalize this formula for all the remaining columns." ], "previous_source": "", "target": [ "Par exemple, supposons que la plage <emph>A1:J200</emph> est sélectionnée (hauteur = 200), la formule par défaut est donc <emph>=(COUNTBLANK(A1:A200)=200)</emph>. Cela signifie que si les 200 cellules sont vides dans la première colonne (colonne A), la colonne est supprimée. Notez que la formule est exprimée par rapport à la première colonne uniquement. En interne, la méthode <literal>CompactLeft</literal> généralisera cette formule pour toutes les colonnes restantes." ], "id_hash": 2650059504089948226, "content_hash": 2650059504089948226, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id361652271022647\nhelp.text", "note": "8sYWa", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 612, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 62, "source_unit": "https://translations.documentfoundation.org/api/units/110306507/?format=api", "priority": 100, "id": 110978411, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=a4c6e7140eede042", "url": "https://translations.documentfoundation.org/api/units/110978411/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.409556Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "Calc functions used in the <literal>filterformula</literal> argument must be expressed using their English names. Visit the Wiki page <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/List_of_Functions\">List of Calc Functions</link> for a complete list of Calc functions in English." ], "previous_source": "", "target": [ "Les fonctions Calc utilisées dans l'argument <literal>filterformula</literal> doivent être exprimées en utilisant leurs noms anglais. Visitez la page Wiki <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/List_of_Functions\">Liste des fonctions Calc</link> pour une liste complète des fonctions Calc en anglais." ], "id_hash": -6271886129733203222, "content_hash": -6271886129733203222, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id431657568414625\nhelp.text", "note": "LQz5G", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 613, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/110306508/?format=api", "priority": 100, "id": 110978422, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=28f5c8cb7d8d8aea", "url": "https://translations.documentfoundation.org/api/units/110978422/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.423341Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "' Delete all empty columns in the range G1:L10 from Sheet1" ], "previous_source": "", "target": [ "' Supprimer toutes les colonnes vides dans la plage G1:L10 de Sheet1" ], "id_hash": -2423653425892021502, "content_hash": -2423653425892021502, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id941652271391005\nhelp.text", "note": "FDspT", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 614, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/110306509/?format=api", "priority": 100, "id": 110978424, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=5e5d740cdb0c2b02", "url": "https://translations.documentfoundation.org/api/units/110978424/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.426340Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "newrange = oDoc.CompactLeft(\"Sheet1.G1:L10\")" ], "previous_source": "", "target": [ "newrange = oDoc.CompactLeft(\"Sheet1.G1:L10\")" ], "id_hash": -7871940921999183396, "content_hash": -7871940921999183396, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id691652271390762\nhelp.text", "note": "huH9x", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 615, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110306518/?format=api", "priority": 100, "id": 110978428, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=12c13f705360b1dc", "url": "https://translations.documentfoundation.org/api/units/110978428/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.431675Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "' The example below is similar, but the entire column is deleted from the sheet" ], "previous_source": "", "target": [ "' L'exemple ci-dessous est similaire, mais toute la colonne est supprimée de la feuille" ], "id_hash": -2214787741373783576, "content_hash": -2214787741373783576, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id921652271392627\nhelp.text", "note": "2BkcC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 616, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/110306528/?format=api", "priority": 100, "id": 110978434, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=61437e489e86a1e8", "url": "https://translations.documentfoundation.org/api/units/110978434/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.439719Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "newrange = oDoc.CompactLeft(\"Sheet1.G1:L10\", WholeColumn := True)" ], "previous_source": "", "target": [ "newrange = oDoc.CompactLeft(\"Sheet1.G1:L10\", WholeColumn := True)" ], "id_hash": -8199235931352615224, "content_hash": -8199235931352615224, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id941652271392873\nhelp.text", "note": "6GoCu", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 617, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110306529/?format=api", "priority": 100, "id": 110978437, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=0e36765ca21bb6c8", "url": "https://translations.documentfoundation.org/api/units/110978437/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.445104Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "' Deletes all columns where the first row is marked with an \"X\"" ], "previous_source": "", "target": [ "' Supprime toutes les colonnes dont la première ligne est marquée d'un \"X\"" ], "id_hash": -6393219210901577659, "content_hash": -6393219210901577659, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id751652271393226\nhelp.text", "note": "KfQRA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 618, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/110306537/?format=api", "priority": 100, "id": 110978445, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=2746b9001b022045", "url": "https://translations.documentfoundation.org/api/units/110978445/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.453354Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "newrange = oDoc.CompactLeft(\"Sheet1.G1:L10\", FilterFormula := \"=(G1=\"\"X\"\")\")" ], "previous_source": "", "target": [ "newrange = oDoc.CompactLeft(\"Sheet1.G1:L10\", FilterFormula := \"=(G1=\"\"X\"\")\")" ], "id_hash": -6863213641985775653, "content_hash": -6863213641985775653, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id761652271393514\nhelp.text", "note": "fLJ7y", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 619, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110306548/?format=api", "priority": 100, "id": 110978446, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=20c0f78e33d2a7db", "url": "https://translations.documentfoundation.org/api/units/110978446/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.455428Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "' Deletes all columns where the sum of values in the column is odd" ], "previous_source": "", "target": [ "' Supprime toutes les colonnes où la somme des valeurs de la colonne est impaire" ], "id_hash": 7986409728897918979, "content_hash": 7986409728897918979, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id241652271725676\nhelp.text", "note": "UqpQB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 620, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/110306568/?format=api", "priority": 100, "id": 110978450, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=eed56d55a9af2803", "url": "https://translations.documentfoundation.org/api/units/110978450/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.458908Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "newrange = oDoc.CompactLeft(\"Sheet1.G1:L10\", FilterFormula := \"=(MOD(SUM(G1:G10);2)=1)\")" ], "previous_source": "", "target": [ "newrange = oDoc.CompactLeft(\"Sheet1.G1:L10\", FilterFormula := \"=(MOD(SUM(G1:G10);2)=1)\")" ], "id_hash": -2238566094311306114, "content_hash": -2238566094311306114, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id531652271726131\nhelp.text", "note": "5rxDM", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 621, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110306578/?format=api", "priority": 100, "id": 110978454, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=60ef03ff66574c7e", "url": "https://translations.documentfoundation.org/api/units/110978454/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.460698Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "newrange = myDoc.CompactLeft(\"Sheet1.G1:L10\")" ], "previous_source": "", "target": [ "newrange = myDoc.CompactLeft(\"Sheet1.G1:L10\")" ], "id_hash": 8483081248151677601, "content_hash": 8483081248151677601, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npyc_id451621536612334\nhelp.text", "note": "i4ux6", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 622, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110306588/?format=api", "priority": 100, "id": 110978456, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=f5b9f5732cdbaaa1", "url": "https://translations.documentfoundation.org/api/units/110978456/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.462946Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "newrange = myDoc.CompactLeft(\"Sheet1.G1:L10\", wholecolumn = True)" ], "previous_source": "", "target": [ "newrange = myDoc.CompactLeft(\"Sheet1.G1:L10\", wholecolumn = True)" ], "id_hash": -6176077132474310113, "content_hash": -6176077132474310113, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npyc_id201652272121176\nhelp.text", "note": "j5kGd", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 623, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110306598/?format=api", "priority": 100, "id": 110978458, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=2a4a2a91fd74a21f", "url": "https://translations.documentfoundation.org/api/units/110978458/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.465330Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "newrange = myDoc.CompactLeft(\"Sheet1.G1:L10\", filterformula = '=(G1=\"X\")')" ], "previous_source": "", "target": [ "newrange = myDoc.CompactLeft(\"Sheet1.G1:L10\", filterformula = '=(G1=\"X\")')" ], "id_hash": -7443583005571695783, "content_hash": -7443583005571695783, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npyc_id781652272122794\nhelp.text", "note": "pBca4", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 624, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110306607/?format=api", "priority": 100, "id": 110978461, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=18b314b1b8c3bb59", "url": "https://translations.documentfoundation.org/api/units/110978461/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.467835Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "newrange = myDoc.CompactLeft(\"Sheet1.G1:L10\", filterformula = '=(MOD(SUM(G1:G10);2)=1)')" ], "previous_source": "", "target": [ "newrange = myDoc.CompactLeft(\"Sheet1.G1:L10\", filterformula = '=(MOD(SUM(G1:G10);2)=1)')" ], "id_hash": -5888400473604330416, "content_hash": -5888400473604330416, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npyc_id731652272123209\nhelp.text", "note": "VGAj6", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 625, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110306616/?format=api", "priority": 100, "id": 110978466, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=2e4832f7a3926c50", "url": "https://translations.documentfoundation.org/api/units/110978466/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.780015Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "Deletes the rows of a specified range that match a filter expressed as a Calc formula. The filter is applied to each row to decide whether it will be deleted or not." ], "previous_source": "", "target": [ "Supprime les lignes d'une plage spécifiée qui correspondent à un filtre exprimé sous forme de formule Calc. Le filtre est appliqué à chaque ligne pour décider si elle sera supprimée ou non." ], "id_hash": -89305867692239344, "content_hash": -89305867692239344, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id841592919903699\nhelp.text", "note": "vqJ5B", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 626, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/110306626/?format=api", "priority": 100, "id": 110978473, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=7ec2b8c957d89610", "url": "https://translations.documentfoundation.org/api/units/110978473/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.783562Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "The deleted rows can be limited to the width of the specified range or span to the width of the entire sheet, thus deleting whole rows." ], "previous_source": "", "target": [ "Les lignes supprimées peuvent être limitées à la largeur de la plage spécifiée ou s'étendre à la largeur de la feuille entière, supprimant ainsi des lignes entières." ], "id_hash": -2893638114323152427, "content_hash": -2893638114323152427, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id601652269910091\nhelp.text", "note": "RhiRD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 627, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/110306642/?format=api", "priority": 100, "id": 110978477, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=57d7bb77573cc1d5", "url": "https://translations.documentfoundation.org/api/units/110978477/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.786015Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "This method returns a string with the range address of the compacted range. If all rows are deleted, then an empty string is returned." ], "previous_source": "", "target": [ "Cette méthode renvoie une chaîne avec l'adresse de plage de la plage compactée. Si toutes les lignes sont supprimées, une chaîne vide est renvoyée." ], "id_hash": -5849820052738525597, "content_hash": -5849820052738525597, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id701652271283456\nhelp.text", "note": "Yw3WB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 628, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/110306659/?format=api", "priority": 100, "id": 110978479, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=2ed143a7dc903663", "url": "https://translations.documentfoundation.org/api/units/110978479/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.788194Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "If a range of cells is selected, calling this method will not impact the selection." ], "previous_source": "", "target": [ "Si une plage de cellules est sélectionnée, l'appel de cette méthode n'aura pas d'impact sur la sélection." ], "id_hash": -862300146471571957, "content_hash": -862300146471571957, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id191652271893913\nhelp.text", "note": "RtGtW", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 629, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/110306673/?format=api", "priority": 100, "id": 110978482, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=74087e95dfcb6e0b", "url": "https://translations.documentfoundation.org/api/units/110978482/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.868315Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "<emph>range</emph>: The range from which rows will be deleted, as a string." ], "previous_source": "", "target": [ "<emph>plage</emph> : la plage à partir de laquelle les lignes seront supprimées, sous forme de chaîne." ], "id_hash": 5701245945931448460, "content_hash": 5701245945931448460, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id771592919922080\nhelp.text", "note": "X3Ekj", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 630, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/110306682/?format=api", "priority": 100, "id": 110978486, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=cf1ee4fb3861408c", "url": "https://translations.documentfoundation.org/api/units/110978486/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.870666Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "<emph>wholerow</emph>: If this option is set to <literal>True</literal> the entire row will be deleted from the sheet. The default value is <literal>False</literal>, which means that the deleted row will be limited to the width of the specified <literal>range</literal>." ], "previous_source": "", "target": [ "<emph>wholerow</emph> : si cette option est définie sur <literal>True</literal>, la ligne entière sera supprimée de la feuille. La valeur par défaut est <literal>False</literal>, ce qui signifie que la ligne supprimée sera limitée à la largeur de la <literal>plage</literal> spécifiée." ], "id_hash": 3269168695087870556, "content_hash": 3269168695087870556, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id771592919921160\nhelp.text", "note": "sAtHM", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 631, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/110306696/?format=api", "priority": 100, "id": 110978496, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=ad5e6b9b7d8a325c", "url": "https://translations.documentfoundation.org/api/units/110978496/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.876527Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "<emph>filterformula</emph>: The filter to be applied to each row to determine whether or not it will be deleted. The filter is expressed as a Calc formula that should be applied to the first row. When the formula returns <emph>True</emph> for a row, that row will be deleted. The default filter deletes all empty rows." ], "previous_source": "", "target": [ "<emph>filterformula</emph> : Le filtre à appliquer à chaque ligne pour déterminer si elle sera supprimée ou non. Le filtre est exprimé sous la forme d'une formule Calc qui doit être appliquée à la première ligne. Lorsque la formule renvoie <emph>True</emph> pour une ligne, cette ligne sera supprimée. Le filtre par défaut supprime toutes les lignes vides." ], "id_hash": -3615818996323342432, "content_hash": -3615818996323342432, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id771592919926374\nhelp.text", "note": "pKXWR", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 632, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 54, "source_unit": "https://translations.documentfoundation.org/api/units/110306707/?format=api", "priority": 100, "id": 110978501, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=4dd207c7c009a7a0", "url": "https://translations.documentfoundation.org/api/units/110978501/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.879857Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "For example, suppose range <emph>A1:J200</emph> is selected (width = 10), so the default formula is <emph>=(COUNTBLANK(A1:J1)=10)</emph>. This means that if all 10 cells are empty in the first row (Row 1), then the row is deleted. Note that the formula is expressed with respect to the first row only. Internally the <literal>CompactUp</literal> method will generalize this formula for all the remaining rows." ], "previous_source": "", "target": [ "Par exemple, supposons que la plage <emph>A1:J200</emph> est sélectionnée (largeur = 10), la formule par défaut est donc <emph>=(COUNTBLANK(A1:J1)=10)</emph>. Cela signifie que si les 10 cellules sont vides dans la première ligne (ligne 1), la ligne est supprimée. Notez que la formule est exprimée par rapport à la première ligne uniquement. En interne, la méthode <literal>CompactUp</literal> généralisera cette formule pour toutes les lignes restantes." ], "id_hash": -5711268816450555653, "content_hash": -5711268816450555653, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id361652271022681\nhelp.text", "note": "2DsWD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 633, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 62, "source_unit": "https://translations.documentfoundation.org/api/units/110306716/?format=api", "priority": 100, "id": 110978508, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=30bd7f4562b2f0fb", "url": "https://translations.documentfoundation.org/api/units/110978508/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.882700Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "The Calc functions used in the formula specified in the <literal>filterformula</literal> argument must be expressed using their English names. Visit the Wiki page <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/List_of_Functions\">List of Calc Functions</link> for a complete list of Calc functions in English." ], "previous_source": "", "target": [ "Les fonctions Calc utilisées dans la formule spécifiée dans l'argument <literal>filterformula</literal> doivent être exprimées en utilisant leurs noms anglais. Visitez la page Wiki <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/List_of_Functions\">Liste des fonctions Calc</link> pour une liste complète des fonctions Calc en anglais." ], "id_hash": 3013074956827737999, "content_hash": 3013074956827737999, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id431657568414714\nhelp.text", "note": "BxmHj", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 634, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/110306729/?format=api", "priority": 100, "id": 110978515, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=a9d097b59357bf8f", "url": "https://translations.documentfoundation.org/api/units/110978515/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.885746Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "' Delete all empty rows in the range G1:L10 from Sheet1" ], "previous_source": "", "target": [ "' Supprimer toutes les lignes vides dans la plage G1:L10 de Sheet1" ], "id_hash": -2727294934140530946, "content_hash": -2727294934140530946, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id941652271391554\nhelp.text", "note": "GuWzD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 635, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/110306738/?format=api", "priority": 100, "id": 110978519, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=5a26b3b50cd4cefe", "url": "https://translations.documentfoundation.org/api/units/110978519/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.888546Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "newrange = oDoc.CompactUp(\"Sheet1.G1:L10\")" ], "previous_source": "", "target": [ "newrange = oDoc.CompactUp(\"Sheet1.G1:L10\")" ], "id_hash": -8929835591995383767, "content_hash": -8929835591995383767, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id691652271390789\nhelp.text", "note": "GBrKx", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 636, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110306755/?format=api", "priority": 100, "id": 110978523, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=0412d9d76479a029", "url": "https://translations.documentfoundation.org/api/units/110978523/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.890584Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "' The example below is similar, but the entire row is deleted from the sheet" ], "previous_source": "", "target": [ "' L'exemple ci-dessous est similaire, mais la ligne entière est supprimée de la feuille" ], "id_hash": 5214667006128657360, "content_hash": 5214667006128657360, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id921652271392567\nhelp.text", "note": "FV3Ev", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 637, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/110306764/?format=api", "priority": 100, "id": 110978527, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=c85e38037a3f93d0", "url": "https://translations.documentfoundation.org/api/units/110978527/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.892328Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "newrange = oDoc.CompactUp(\"Sheet1.G1:L10\", WholeRow := True)" ], "previous_source": "", "target": [ "newrange = oDoc.CompactUp(\"Sheet1.G1:L10\", WholeRow := True)" ], "id_hash": 8964155468349609497, "content_hash": 8964155468349609497, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id941652271392553\nhelp.text", "note": "Y5YVh", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 638, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110306774/?format=api", "priority": 100, "id": 110978530, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=fc6713e7825a9619", "url": "https://translations.documentfoundation.org/api/units/110978530/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.893471Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "' Deletes all rows where the first column is marked with an \"X\"" ], "previous_source": "", "target": [ "' Supprime toutes les lignes dont la première colonne est marquée d'un \"X\"" ], "id_hash": 1242996516193379019, "content_hash": 1242996516193379019, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id751652271393117\nhelp.text", "note": "mFqmA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 639, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/110306784/?format=api", "priority": 100, "id": 110978534, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=914002beecc122cb", "url": "https://translations.documentfoundation.org/api/units/110978534/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.894809Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "newrange = oDoc.CompactUp(\"Sheet1.G1:L10\", FilterFormula := \"=(G1=\"\"X\"\")\")" ], "previous_source": "", "target": [ "newrange = oDoc.CompactUp(\"Sheet1.G1:L10\", FilterFormula := \"=(G1=\"\"X\"\")\")" ], "id_hash": 329102456707195155, "content_hash": 329102456707195155, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id761652271393034\nhelp.text", "note": "gJQRm", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 640, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110306795/?format=api", "priority": 100, "id": 110978536, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=849134f0d2bda113", "url": "https://translations.documentfoundation.org/api/units/110978536/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.895921Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "' Deletes all rows where the sum of values in the row is odd" ], "previous_source": "", "target": [ "' Supprime toutes les lignes où la somme des valeurs de la ligne est impaire" ], "id_hash": 5607681209357476903, "content_hash": 5607681209357476903, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id241652271725065\nhelp.text", "note": "DoDfJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 641, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/110306805/?format=api", "priority": 100, "id": 110978540, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=cdd27c596162a427", "url": "https://translations.documentfoundation.org/api/units/110978540/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.897222Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "newrange = oDoc.CompactUp(\"Sheet1.G1:L10\", FilterFormula := \"=(MOD(SUM(G1:L1);2)=1)\")" ], "previous_source": "", "target": [ "newrange = oDoc.CompactUp(\"Sheet1.G1:L10\", FilterFormula := \"=(MOD(SUM(G1:L1);2)=1)\")" ], "id_hash": 4994279823937581359, "content_hash": 4994279823937581359, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id531652271726010\nhelp.text", "note": "zXErV", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 642, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110306823/?format=api", "priority": 100, "id": 110978544, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=c54f3f09feb3312f", "url": "https://translations.documentfoundation.org/api/units/110978544/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.898307Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "newrange = myDoc.CompactUp(\"Sheet1.G1:L10\")" ], "previous_source": "", "target": [ "newrange = myDoc.CompactUp(\"Sheet1.G1:L10\")" ], "id_hash": -7607904910709507304, "content_hash": -7607904910709507304, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npyc_id451621536612227\nhelp.text", "note": "Mcwq5", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 643, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110306869/?format=api", "priority": 100, "id": 110978546, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=166b4acac835bb18", "url": "https://translations.documentfoundation.org/api/units/110978546/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.899692Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "newrange = myDoc.CompactUp(\"Sheet1.G1:L10\", wholerow = True)" ], "previous_source": "", "target": [ "newrange = myDoc.CompactUp(\"Sheet1.G1:L10\", wholerow = True)" ], "id_hash": -870256884412136325, "content_hash": -870256884412136325, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npyc_id201652272121288\nhelp.text", "note": "tXmJD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 644, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110307011/?format=api", "priority": 100, "id": 110978550, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=73ec39f97546c47b", "url": "https://translations.documentfoundation.org/api/units/110978550/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.900979Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "newrange = myDoc.CompactUp(\"Sheet1.G1:L10\", filterformula = '=(G1=\"X\")')" ], "previous_source": "", "target": [ "newrange = myDoc.CompactUp(\"Sheet1.G1:L10\", filterformula = '=(G1=\"X\")')" ], "id_hash": -2487474386496005270, "content_hash": -2487474386496005270, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npyc_id781652272122931\nhelp.text", "note": "WZ3XF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 645, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110307033/?format=api", "priority": 100, "id": 110978553, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=5d7ab7398505db6a", "url": "https://translations.documentfoundation.org/api/units/110978553/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.902266Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "newrange = myDoc.CompactUp(\"Sheet1.G1:L10\", filterformula = '=(MOD(SUM(G1:L1);2)=1)')" ], "previous_source": "", "target": [ "newrange = myDoc.CompactUp(\"Sheet1.G1:L10\", filterformula = '=(MOD(SUM(G1:L1);2)=1)')" ], "id_hash": 3615956503382873091, "content_hash": 3615956503382873091, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npyc_id731652272123109\nhelp.text", "note": "4DfG9", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 646, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110307036/?format=api", "priority": 100, "id": 110978557, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=b22e75481b665403", "url": "https://translations.documentfoundation.org/api/units/110978557/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.903605Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "Copies a specified sheet before an existing sheet or at the end of the list of sheets. The sheet to be copied may be contained inside any <emph>open</emph> Calc document. Returns <literal>True</literal> if successful." ], "previous_source": "", "target": [ "Copie une feuille spécifiée avant une feuille existante ou à la fin de la liste des feuilles. La feuille à copier peut être contenue dans n'importe quel document Calc <emph>ouvert</emph>. Renvoie <literal>True</literal> en cas de succès." ], "id_hash": 6352430218308344905, "content_hash": 6352430218308344905, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id591591631693816\nhelp.text", "note": "n6vJD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 647, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/110307037/?format=api", "priority": 100, "id": 110978561, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=d8285da07eb9dc49", "url": "https://translations.documentfoundation.org/api/units/110978561/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.905048Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "<emph>sheetname</emph>: The name of the sheet to be copied as a string or its reference as an object." ], "previous_source": "", "target": [ "<emph>sheetname</emph> : Le nom de la feuille à copier sous forme de chaîne ou sa référence en tant qu'objet." ], "id_hash": -822798553372762257, "content_hash": -822798553372762257, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id871591631693741\nhelp.text", "note": "YqGL2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 648, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/110307039/?format=api", "priority": 100, "id": 110978565, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=7494d5133882df6f", "url": "https://translations.documentfoundation.org/api/units/110978565/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.906532Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "<emph>newname</emph>: The name of the sheet to insert. The name must not be in use in the document." ], "previous_source": "", "target": [ "<emph>newname</emph> : le nom de la feuille à insérer. Le nom ne doit pas être utilisé dans le document." ], "id_hash": 264246308134559973, "content_hash": 264246308134559973, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id351591632126180\nhelp.text", "note": "5cEGG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 649, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/110307118/?format=api", "priority": 100, "id": 110978567, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=83aaca9e0191a0e5", "url": "https://translations.documentfoundation.org/api/units/110978567/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.907815Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/fr/?format=api", "source": [ "<emph>beforesheet</emph>: The name (string) or index (numeric, starting from 1) of the sheet before which to insert the copied sheet. This argument is optional and the default behavior is to add the copied sheet at the last position." ], "previous_source": "", "target": [ "<emph>beforesheet</emph> : le nom (chaîne) ou l'index (numérique, à partir de 1) de la feuille avant laquelle insérer la feuille copiée. Cet argument est facultatif et le comportement par défaut consiste à ajouter la feuille copiée à la dernière position." ], "id_hash": -7351251077577507457, "content_hash": -7351251077577507457, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id211591632192379\nhelp.text", "note": "8sSno", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 650, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/110307157/?format=api", "priority": 100, "id": 110978569, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/fr/?checksum=19fb1c17f248fd7f", "url": "https://translations.documentfoundation.org/api/units/110978569/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:03.909040Z" } ] }