Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-7-6/textscalcguide/ast/units/?format=api&page=31
{ "count": 1558, "next": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/units/?format=api&page=32", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/units/?format=api&page=30", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "With the help of the <emph>Web Page Query ($[officename] Calc)</emph> import filter, you can insert tables from HTML documents in a Calc spreadsheet." ], "previous_source": "", "target": [ "Por aciu el filtru d'importación <emph>Consulta de páxina Web ($[officename] Calc)</emph>, pue inxertar tables de documentu HTML nuna fueya de cálculu de Calc." ], "id_hash": -1754040601858356598, "content_hash": -1754040601858356598, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3155131\nhelp.text", "note": "Uf8QW", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1501, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/99055139/?format=api", "priority": 100, "id": 99091456, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=67a8655dac9eca8a", "url": "https://translations.documentfoundation.org/api/units/99091456/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.014527Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "You can use the same method to insert ranges defined by name from a Calc or Microsoft Excel spreadsheet." ], "previous_source": "", "target": [ "Pue utilizase el mesmu métodu pa inxertar árees con nome dende una fueya de cálculu de Calc o de Microsoft Excel." ], "id_hash": -5329861810833699027, "content_hash": -5329861810833699027, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3148575\nhelp.text", "note": "eBygd", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1502, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/99055170/?format=api", "priority": 100, "id": 99091461, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=360886ebff564f2d", "url": "https://translations.documentfoundation.org/api/units/99091461/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.016014Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "The following insert methods are available:" ], "previous_source": "", "target": [ "Esisten los siguientes métodos d'inxertamientu:" ], "id_hash": -391306406609619005, "content_hash": -391306406609619005, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3149664\nhelp.text", "note": "odxLF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1503, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/99055195/?format=api", "priority": 100, "id": 99091464, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=7a91cce57bb2f7c3", "url": "https://translations.documentfoundation.org/api/units/99091464/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.031395Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "Inserting by Dialog" ], "previous_source": "", "target": [ "Insertamientu por aciu diálogu" ], "id_hash": 5827784301768704225, "content_hash": 5827784301768704225, "location": "webquery.xhp", "context": "webquery.xhp\nhd_id3146976\nhelp.text", "note": "kNB42", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1504, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99055250/?format=api", "priority": 100, "id": 99091468, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=d0e072f20e8580e1", "url": "https://translations.documentfoundation.org/api/units/99091468/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.033678Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "Set the cell cursor at the cell where the new content will be inserted." ], "previous_source": "", "target": [ "Asitie'l cursor de caxelles na caxella na que deseya inxertar el conteníu nuevo." ], "id_hash": 368152759068690997, "content_hash": 368152759068690997, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3154319\nhelp.text", "note": "WJEih", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1505, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/99055283/?format=api", "priority": 100, "id": 99091473, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=851bf0fbdb5e8a35", "url": "https://translations.documentfoundation.org/api/units/99091473/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.035796Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "Choose <emph>Sheet - External Links</emph>. This opens the <link href=\"text/scalc/01/04090000.xhp\">External Data</link> dialog." ], "previous_source": "", "target": [ "" ], "id_hash": -7616409846319291075, "content_hash": -7616409846319291075, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3145750\nhelp.text", "note": "SCn3P", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1506, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/99055319/?format=api", "priority": 100, "id": 99091477, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=164d13992659e53d", "url": "https://translations.documentfoundation.org/api/units/99091477/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.037952Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "Enter the URL of the HTML document or the name of the spreadsheet. Press Enter when finished. Click the <emph>Browse</emph> button to open a file selection dialog." ], "previous_source": "", "target": [ "Especifique la URL del documentu HTML o'l nome de la fueya de cálculu. Calque Entrar cuando fine.! Faiga clic nel botón <emph>...</emph> p'abrir un diálogu de seleición de ficheros." ], "id_hash": -8100371161362078385, "content_hash": -8100371161362078385, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3149958\nhelp.text", "note": "AGj3g", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1507, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/99055396/?format=api", "priority": 100, "id": 99091483, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=0f95b358aa31e54f", "url": "https://translations.documentfoundation.org/api/units/99091483/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.039777Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "In the large list box of the dialog, select the named ranges or tables you want to insert." ], "previous_source": "", "target": [ "Nel cuadru grande de llista del diálogu, escueya les árees o tables con nome que deseye inxertar." ], "id_hash": -7837232548087131163, "content_hash": -7837232548087131163, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3149400\nhelp.text", "note": "5b5MC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1508, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/99055410/?format=api", "priority": 100, "id": 99091491, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=133c8e855d2313e5", "url": "https://translations.documentfoundation.org/api/units/99091491/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.042102Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "You can also specify that the ranges or tables are updated every n seconds." ], "previous_source": "", "target": [ "Pue especificar que les árees o tables actualícense cada n segundos." ], "id_hash": -2554167218865827598, "content_hash": -2554167218865827598, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3155064\nhelp.text", "note": "Kegfn", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1509, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/99055476/?format=api", "priority": 100, "id": 99091496, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=5c8dc6726e8e10f2", "url": "https://translations.documentfoundation.org/api/units/99091496/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.043795Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "The import filter can create names for cell ranges on the fly. As much formatting as possible is retained, while the filter intentionally does not load any images." ], "previous_source": "", "target": [ "El filtru d'importación pue crear nomes pa árees de caxelles sobre la marcha. Caltiense'l máximu formatu posible, pero'l filtru torga explícitamente la carga d'imaxes." ], "id_hash": -356872810792596919, "content_hash": -356872810792596919, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3155443\nhelp.text", "note": "ywoJU", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1510, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/99055509/?format=api", "priority": 100, "id": 99091503, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=7b0c2211c2b64a49", "url": "https://translations.documentfoundation.org/api/units/99091503/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.045403Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "Inserting by Navigator" ], "previous_source": "", "target": [ "Insertamientu por aciu el Navegador" ], "id_hash": 6041129146140853600, "content_hash": 6041129146140853600, "location": "webquery.xhp", "context": "webquery.xhp\nhd_id3149021\nhelp.text", "note": "HA9v2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1511, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99055540/?format=api", "priority": 100, "id": 99091508, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=d3d666f37dfc0560", "url": "https://translations.documentfoundation.org/api/units/99091508/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.047018Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "Open two documents: the $[officename] Calc spreadsheet in which the external data is to be inserted (target document) and the document from which the external data derives (source document)." ], "previous_source": "", "target": [ "Abra dos documentos: la fueya de cálculu de $[officename] Calc na que deseya inxertar los datos esternos (documentu destín) y el documentu del que procedan los datos esternos (documentu fonte)." ], "id_hash": 5609490903737553245, "content_hash": 5609490903737553245, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3153965\nhelp.text", "note": "KpQYC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1512, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/99055572/?format=api", "priority": 100, "id": 99091515, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=cdd8ea41b00fd15d", "url": "https://translations.documentfoundation.org/api/units/99091515/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.048471Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "In the target document open the Navigator." ], "previous_source": "", "target": [ "Abra'l Navegador nel documentu destín." ], "id_hash": -4314306922810746572, "content_hash": -4314306922810746572, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3150205\nhelp.text", "note": "ekAUo", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1513, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/99055605/?format=api", "priority": 100, "id": 99091521, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=442080b63ddb5934", "url": "https://translations.documentfoundation.org/api/units/99091521/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.049911Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "In the lower combo box of the Navigator select the source document. The Navigator now shows the range names and database ranges or the tables contained in the source document." ], "previous_source": "", "target": [ "Escueya nel campu combinao inferior del Navegador el documentu fonte. El Navegador va amosar agora los nomes d'árees conteníos nel documentu fonte y les árees de bases de datos, esto ye, les tables." ], "id_hash": 2800687121260673831, "content_hash": 2800687121260673831, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3152990\nhelp.text", "note": "z9DtM", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1514, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/99055642/?format=api", "priority": 100, "id": 99091527, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=a6de0a191dc0fb27", "url": "https://translations.documentfoundation.org/api/units/99091527/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.051151Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "In the Navigator select the <emph>Insert as link</emph> drag mode <image id=\"img_id3152985\" src=\"sw/res/sc20238.png\" width=\"0.222inch\" height=\"0.222inch\"><alt id=\"alt_id3152985\">Icon</alt></image>." ], "previous_source": "", "target": [ "" ], "id_hash": -9132184343404615382, "content_hash": -9132184343404615382, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3148842\nhelp.text", "note": "ZDFsw", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1515, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/99055677/?format=api", "priority": 100, "id": 99091531, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=0143f6b95bfbe92a", "url": "https://translations.documentfoundation.org/api/units/99091531/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.059540Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "Drag the desired external data from the Navigator into the target document." ], "previous_source": "", "target": [ "Arrastre los datos esternos que deseye del Navegador al documentu de destín." ], "id_hash": 3362152370996996680, "content_hash": 3362152370996996680, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3157978\nhelp.text", "note": "LS3Wf", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1516, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/99055704/?format=api", "priority": 100, "id": 99091539, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=aea8c3c49a036a48", "url": "https://translations.documentfoundation.org/api/units/99091539/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.061331Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "If you have loaded an HTML document with the <emph>Web Page Query</emph> filter as the source document, you will find the tables in the Navigator, named continuously from \"HTML_table1\" onwards, and also two range names that have been created:" ], "previous_source": "", "target": [ "Si cargó un documentu HTML col filtru <emph>Consulta de páxina web</emph> como documentu fonte, va atopar nel Navegador les tables llamaes \"HTML_table1\", \"HTML_table2\", etc. amás de dos nomes d'área creaos:" ], "id_hash": 2359732934821486848, "content_hash": 2359732934821486848, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3144768\nhelp.text", "note": "9GfqA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1517, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://translations.documentfoundation.org/api/units/99055741/?format=api", "priority": 100, "id": 99091545, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=a0bf749a10d32100", "url": "https://translations.documentfoundation.org/api/units/99091545/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.062873Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "<item type=\"literal\">HTML_all</item> - designates the entire document" ], "previous_source": "", "target": [ "<item type=\"literal\">HTML_all</item>: designa tol documentu" ], "id_hash": -6219590455625739876, "content_hash": -6219590455625739876, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3152873\nhelp.text", "note": "rcjUt", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1518, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/99055770/?format=api", "priority": 100, "id": 99091553, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=29af936ef404919c", "url": "https://translations.documentfoundation.org/api/units/99091553/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.064996Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "<item type=\"literal\">HTML_tables</item> - designates all HTML tables in the document" ], "previous_source": "", "target": [ "<item type=\"literal\">HTML_tables</item>: designa toles tables HTML del documentu" ], "id_hash": 6160391056425820477, "content_hash": 6160391056425820477, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3149897\nhelp.text", "note": "ecFZG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1519, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/99055779/?format=api", "priority": 100, "id": 99091557, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=d57e1b06d3c1213d", "url": "https://translations.documentfoundation.org/api/units/99091557/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.066856Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "Editing the external data" ], "previous_source": "", "target": [ "Edición de los datos esternos" ], "id_hash": -5310202282854161437, "content_hash": -5310202282854161437, "location": "webquery.xhp", "context": "webquery.xhp\nhd_id3149126\nhelp.text", "note": "TGhCr", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1520, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99055839/?format=api", "priority": 100, "id": 99091563, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=364e5f288d0263e3", "url": "https://translations.documentfoundation.org/api/units/99091563/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.068378Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "Open <emph>Edit - Links</emph>. Here you can edit the link to the external data." ], "previous_source": "", "target": [ "Active'l diálogu <emph>Editar - Enllaces</emph>. Equí va poder editar l'enllaz a los datos esternos." ], "id_hash": -3508314855120126624, "content_hash": -3508314855120126624, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3159228\nhelp.text", "note": "GEeyF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1521, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/99055865/?format=api", "priority": 100, "id": 99091570, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=4f4ff63a2456bd60", "url": "https://translations.documentfoundation.org/api/units/99091570/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.069921Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "<link href=\"text/scalc/01/04090000.xhp\">External data dialog</link>" ], "previous_source": "", "target": [ "<link href=\"text/scalc/01/04090000.xhp\">Diálogu Datos esternos</link>" ], "id_hash": 4295650489344367897, "content_hash": 4295650489344367897, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3154650\nhelp.text", "note": "xJkAV", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1522, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99055892/?format=api", "priority": 100, "id": 99091574, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=bb9d375c589a9d19", "url": "https://translations.documentfoundation.org/api/units/99091574/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.072368Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "Using Wildcards in Formulas" ], "previous_source": "", "target": [ "" ], "id_hash": -5005700669383186358, "content_hash": -5005700669383186358, "location": "wildcards.xhp", "context": "wildcards.xhp\ntit\nhelp.text", "note": "GnXq4", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1523, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99055932/?format=api", "priority": 100, "id": 99091582, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=3a882dc3357ae84a", "url": "https://translations.documentfoundation.org/api/units/99091582/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.077440Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "<bookmark_value>wildcards in formulas</bookmark_value> <bookmark_value>wildcards;examples</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -87740389075183146, "content_hash": -87740389075183146, "location": "wildcards.xhp", "context": "wildcards.xhp\nbm_id3152149\nhelp.text", "note": "kZVe7", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1524, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99055976/?format=api", "priority": 100, "id": 99091585, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=7ec84894bcb819d6", "url": "https://translations.documentfoundation.org/api/units/99091585/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.078930Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "<variable id=\"wildcards_h1\"><link href=\"text/scalc/guide/wildcards.xhp\">Using Wildcards in Formulas</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -5670285201306416073, "content_hash": -5670285201306416073, "location": "wildcards.xhp", "context": "wildcards.xhp\nhd_id941629155075179\nhelp.text", "note": "ynEWi", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1525, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/99055988/?format=api", "priority": 100, "id": 99091588, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=314f19a6e0fa0c37", "url": "https://translations.documentfoundation.org/api/units/99091588/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.080250Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "Wildcards are special characters that can be used in search strings that are passed as arguments to some Calc functions. They can also be used to define search criteria in the <emph>Find & Replace</emph> dialog. The use of wildcards enables the definition of more advanced search parameters with a single search string." ], "previous_source": "", "target": [ "" ], "id_hash": 7463590612251979732, "content_hash": 7463590612251979732, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id571629155308959\nhelp.text", "note": "yqMKw", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1526, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 52, "source_unit": "https://translations.documentfoundation.org/api/units/99056007/?format=api", "priority": 100, "id": 99091591, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=e794001e38382fd4", "url": "https://translations.documentfoundation.org/api/units/99091591/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.081445Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "%PRODUCTNAME Calc supports either <emph>wildcards</emph> or <emph>regular expressions</emph> as arguments depending on the current application settings. By default %PRODUCTNAME Calc is set to support wildcards instead of regular expressions." ], "previous_source": "", "target": [ "" ], "id_hash": 5064096850254554775, "content_hash": 5064096850254554775, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id391629156224638\nhelp.text", "note": "vQrdp", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1527, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/99056041/?format=api", "priority": 100, "id": 99091599, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=c64749412b98e697", "url": "https://translations.documentfoundation.org/api/units/99091599/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.083715Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "To make sure wildcards are supported, go to <switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences - %PRODUCTNAME Calc - Calculate</menuitem></caseinline><defaultinline><menuitem>Tools - Options - %PRODUCTNAME Calc - Calculate</menuitem></defaultinline></switchinline> and check if the option <emph>Enable wildcards in formulas</emph> is selected. Note that you can use this dialog to switch to regular expressions by choosing <emph>Enable regular expressions in formulas</emph> or choose to support neither wildcards nor regular expressions." ], "previous_source": "", "target": [ "" ], "id_hash": -3460086000889230492, "content_hash": -3460086000889230492, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id551629156504794\nhelp.text", "note": "GVpD7", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1528, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 64, "source_unit": "https://translations.documentfoundation.org/api/units/99056068/?format=api", "priority": 100, "id": 99091604, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=4ffb4e1d50b20b64", "url": "https://translations.documentfoundation.org/api/units/99091604/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.085512Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "The following wildcards are supported:" ], "previous_source": "", "target": [ "" ], "id_hash": -6048104167055417892, "content_hash": -6048104167055417892, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id141629156913731\nhelp.text", "note": "BHJzs", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1529, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/99056114/?format=api", "priority": 100, "id": 99091612, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=2c10d14de61a1ddc", "url": "https://translations.documentfoundation.org/api/units/99091612/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.087741Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "Wildcard" ], "previous_source": "", "target": [ "" ], "id_hash": 2587470424937536780, "content_hash": 2587470424937536780, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id801629209195110\nhelp.text", "note": "tbbPM", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1530, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99056172/?format=api", "priority": 100, "id": 99091615, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=a3e88aa4793b1d0c", "url": "https://translations.documentfoundation.org/api/units/99091615/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.089398Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "Description" ], "previous_source": "", "target": [ "Descripción" ], "id_hash": -3386886951337921064, "content_hash": -3386886951337921064, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id861629209212608\nhelp.text", "note": "7PmfG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1531, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99056206/?format=api", "priority": 100, "id": 99091628, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=50ff5c432318f5d8", "url": "https://translations.documentfoundation.org/api/units/99091628/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.093142Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "<emph>? (question mark)</emph>" ], "previous_source": "", "target": [ "" ], "id_hash": 1367802715639150884, "content_hash": 1367802715639150884, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id591629209073388\nhelp.text", "note": "DfkJA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1532, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99056230/?format=api", "priority": 100, "id": 99091659, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=92fb6952ac7c7924", "url": "https://translations.documentfoundation.org/api/units/99091659/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.527788Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "Matches any single character. For example, the search string \"b?g\" matches “bag” and “beg” but will not match \"boog\" or \"mug\"." ], "previous_source": "", "target": [ "" ], "id_hash": 7041916686652994117, "content_hash": 7041916686652994117, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id31629209073388\nhelp.text", "note": "F2wmk", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1533, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/99056268/?format=api", "priority": 100, "id": 99091664, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=e1b9e9eab5d8f245", "url": "https://translations.documentfoundation.org/api/units/99091664/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.530208Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "Note that it will not match \"bg\" as well, since \"?\" must match exactly <emph>one</emph> character. The \"?\" wildcard does not correspond to a zero-character match." ], "previous_source": "", "target": [ "" ], "id_hash": -8049554309637757072, "content_hash": -8049554309637757072, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id121629209114452\nhelp.text", "note": "pi9ik", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1534, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/99056296/?format=api", "priority": 100, "id": 99091671, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=104a3d00f5d3a770", "url": "https://translations.documentfoundation.org/api/units/99091671/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.532762Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "<emph>* (asterisk)</emph>" ], "previous_source": "", "target": [ "" ], "id_hash": 8119798833534327055, "content_hash": 8119798833534327055, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id981629209073388\nhelp.text", "note": "PmsQL", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1535, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99056334/?format=api", "priority": 100, "id": 99091675, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=f0af5204c071d90f", "url": "https://translations.documentfoundation.org/api/units/99091675/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.535328Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "Matches any sequence of characters, including an empty string. For example, the search string \"*cast\" will match “cast”, “forecast”, and “outcast”, but will not match \"forecaster\" using default %PRODUCTNAME settings." ], "previous_source": "", "target": [ "" ], "id_hash": -7378209189522020058, "content_hash": -7378209189522020058, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id51629209073388\nhelp.text", "note": "6V7SE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1536, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/99056356/?format=api", "priority": 100, "id": 99091681, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=199b55d564046926", "url": "https://translations.documentfoundation.org/api/units/99091681/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.537137Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "If the option <menuitem>Search criteria = and <> must apply to whole cells</menuitem> is disabled in <switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences - %PRODUCTNAME Calc - Calculate</menuitem></caseinline><defaultinline><menuitem>Tools - Options - %PRODUCTNAME Calc - Calculate</menuitem></defaultinline></switchinline>, then \"forecaster\" will be a match using the \"*cast\" search string." ], "previous_source": "", "target": [ "" ], "id_hash": -8978826758868014212, "content_hash": -8978826758868014212, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id351629209153307\nhelp.text", "note": "fDuhF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1537, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 44, "source_unit": "https://translations.documentfoundation.org/api/units/99056386/?format=api", "priority": 100, "id": 99091684, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=0364cca279e66b7c", "url": "https://translations.documentfoundation.org/api/units/99091684/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.538701Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "<emph>~ (tilde)</emph>" ], "previous_source": "", "target": [ "" ], "id_hash": 5698902020506067604, "content_hash": 5698902020506067604, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id181629209277556\nhelp.text", "note": "ek6t7", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1538, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99056418/?format=api", "priority": 100, "id": 99091687, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=cf1691318e052294", "url": "https://translations.documentfoundation.org/api/units/99091687/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.540125Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "Escapes the special meaning of a question mark, asterisk, or tilde character that follows immediately after the tilde character." ], "previous_source": "", "target": [ "" ], "id_hash": -171331213962108521, "content_hash": -171331213962108521, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id881629209280877\nhelp.text", "note": "F3Tuy", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1539, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/99056427/?format=api", "priority": 100, "id": 99091690, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=7d9f4f2b2cda2197", "url": "https://translations.documentfoundation.org/api/units/99091690/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.541334Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "For example, the search string \"why~?\" matches “why?” but will not match \"whys\" nor \"why~s\"." ], "previous_source": "", "target": [ "" ], "id_hash": -6370547938320465758, "content_hash": -6370547938320465758, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id861629209431020\nhelp.text", "note": "P35Fo", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1540, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/99056456/?format=api", "priority": 100, "id": 99091699, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=2797446717cfc0a2", "url": "https://translations.documentfoundation.org/api/units/99091699/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.544782Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "Wildcards are supported in %PRODUCTNAME Calc and in Microsoft Excel. Therefore, if interoperability between both applications is needed, choose to work with wildcards instead of regular expressions. Conversely, if interoperability is not necessary, consider using regular expressions for more powerful search capabilities." ], "previous_source": "", "target": [ "" ], "id_hash": -5964869332902390194, "content_hash": -5964869332902390194, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id1001629157561261\nhelp.text", "note": "aCtpj", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1541, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://translations.documentfoundation.org/api/units/99056472/?format=api", "priority": 100, "id": 99091704, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=2d3886f1e8bb564e", "url": "https://translations.documentfoundation.org/api/units/99091704/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.547172Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "Supported Spreadsheet Functions" ], "previous_source": "", "target": [ "Funciones de fueya de cálculu almitíes" ], "id_hash": 5891635516654216372, "content_hash": 5891635516654216372, "location": "wildcards.xhp", "context": "wildcards.xhp\nhd_id671629158766165\nhelp.text", "note": "Dwt2G", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1542, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99056495/?format=api", "priority": 100, "id": 99091717, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=d1c34b49843fe4b4", "url": "https://translations.documentfoundation.org/api/units/99091717/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.551588Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "Wildcards are supported by the following spreadsheet functions:" ], "previous_source": "", "target": [ "" ], "id_hash": 1835502012934031260, "content_hash": 1835502012934031260, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id161629158785887\nhelp.text", "note": "YF9FB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1543, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/99056515/?format=api", "priority": 100, "id": 99091724, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=9979035b1972879c", "url": "https://translations.documentfoundation.org/api/units/99091724/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.554236Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "<emph>Database functions:</emph> DAVERAGE, DCOUNT, DCOUNTA, DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR and DVARP." ], "previous_source": "", "target": [ "" ], "id_hash": 3127945581634036648, "content_hash": 3127945581634036648, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id441629158810517\nhelp.text", "note": "rRPbf", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1544, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/99056531/?format=api", "priority": 100, "id": 99091730, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=ab68b1ef160ca3a8", "url": "https://translations.documentfoundation.org/api/units/99091730/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.556139Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "<emph>Conditional functions:</emph> AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS, MAXIFS, MINIFS, SUMIF and SUMIFS." ], "previous_source": "", "target": [ "" ], "id_hash": -6089227121165517641, "content_hash": -6089227121165517641, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id321629158810916\nhelp.text", "note": "gfUGT", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1545, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/99056546/?format=api", "priority": 100, "id": 99091737, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=2b7eb83206413cb7", "url": "https://translations.documentfoundation.org/api/units/99091737/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.558304Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "<emph>Lookup functions:</emph> HLOOKUP, LOOKUP and VLOOKUP." ], "previous_source": "", "target": [ "" ], "id_hash": 3295165819044073315, "content_hash": 3295165819044073315, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id941629158811325\nhelp.text", "note": "oUwuB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1546, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/99056557/?format=api", "priority": 100, "id": 99091742, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=adbac7da98218f63", "url": "https://translations.documentfoundation.org/api/units/99091742/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.559584Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "<emph>Other functions:</emph> MATCH and SEARCH." ], "previous_source": "", "target": [ "" ], "id_hash": 2201669383780484478, "content_hash": 2201669383780484478, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id41629158919808\nhelp.text", "note": "Ka6SK", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1547, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/99056562/?format=api", "priority": 100, "id": 99091754, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=9e8de6a3bd16c57e", "url": "https://translations.documentfoundation.org/api/units/99091754/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.562755Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "Examples of Wildcards in Formulas" ], "previous_source": "", "target": [ "" ], "id_hash": -4189228146545035537, "content_hash": -4189228146545035537, "location": "wildcards.xhp", "context": "wildcards.xhp\nhd_id701629159564269\nhelp.text", "note": "2ZGuQ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1548, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/99056611/?format=api", "priority": 100, "id": 99091757, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=45dcdf323a1d76ef", "url": "https://translations.documentfoundation.org/api/units/99091757/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.616002Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "The following examples consider that the options <menuitem>Enable wildcards in formulas</menuitem> and <menuitem>Search criteria = and <> must apply to whole cells</menuitem> are enabled in <switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences - %PRODUCTNAME Calc - Calculate</menuitem></caseinline><defaultinline><menuitem>Tools - Options - %PRODUCTNAME Calc - Calculate</menuitem></defaultinline></switchinline>." ], "previous_source": "", "target": [ "" ], "id_hash": 2360364391115031712, "content_hash": 2360364391115031712, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id121629289062103\nhelp.text", "note": "3WVEm", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1549, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://translations.documentfoundation.org/api/units/99056636/?format=api", "priority": 100, "id": 99091762, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=a0c1b2e870e484a0", "url": "https://translations.documentfoundation.org/api/units/99091762/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.618521Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "<input>=COUNTIF(A1:A10;\"Chi*\")</input> counts the number of cells in the range <emph>A1:A10</emph> containing strings that start with \"Chi\" followed by zero or more characters." ], "previous_source": "", "target": [ "" ], "id_hash": 3488233408497834845, "content_hash": 3488233408497834845, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id271629159111490\nhelp.text", "note": "znKay", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1550, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/99056663/?format=api", "priority": 100, "id": 99091768, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=b068b1cdb729db5d", "url": "https://translations.documentfoundation.org/api/units/99091768/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:15.620939Z" } ] }