Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-24-2/textscalcguide/ca/units/?format=api&page=31
https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/units/?format=api&page=32", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/units/?format=api&page=30", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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": [ "Amb l'ajuda del filtre d'importació <emph>Consulta de pàgina web ($[officename] Calc)</emph> podeu inserir taules de documents HTML en un full de càlcul del 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/110841967/?format=api", "priority": 100, "id": 110974567, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=67a8655dac9eca8a", "url": "https://translations.documentfoundation.org/api/units/110974567/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.448855Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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": [ "Podeu utilitzar el mateix mètode per inserir intervals definits per un nom des d'un full de càlcul del Calc o del 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/110841993/?format=api", "priority": 100, "id": 110974573, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=360886ebff564f2d", "url": "https://translations.documentfoundation.org/api/units/110974573/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.455634Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "source": [ "The following insert methods are available:" ], "previous_source": "", "target": [ "Estan disponibles els mètodes d'inserció següents:" ], "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/110842039/?format=api", "priority": 100, "id": 110974582, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=7a91cce57bb2f7c3", "url": "https://translations.documentfoundation.org/api/units/110974582/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.459626Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "source": [ "Inserting by Dialog" ], "previous_source": "", "target": [ "Inserció mitjançant un diàleg" ], "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/110842063/?format=api", "priority": 100, "id": 110974588, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=d0e072f20e8580e1", "url": "https://translations.documentfoundation.org/api/units/110974588/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.461504Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "source": [ "Set the cell cursor at the cell where the new content will be inserted." ], "previous_source": "", "target": [ "Situeu el cursor de la cel·la dins la cel·la on s'inserirà el contingut nou." ], "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/110842100/?format=api", "priority": 100, "id": 110974592, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=851bf0fbdb5e8a35", "url": "https://translations.documentfoundation.org/api/units/110974592/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.463234Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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/110842107/?format=api", "priority": 100, "id": 110974598, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=164d13992659e53d", "url": "https://translations.documentfoundation.org/api/units/110974598/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.468658Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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": [ "Introduïu l'URL del document HTML o el nom del full de càlcul. Premeu Retorn quan acabeu. Feu clic al botó <emph>...</emph> per obrir un diàleg de selecció de fitxers." ], "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/110842119/?format=api", "priority": 100, "id": 110974610, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=0f95b358aa31e54f", "url": "https://translations.documentfoundation.org/api/units/110974610/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.476557Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "source": [ "In the large list box of the dialog, select the named ranges or tables you want to insert." ], "previous_source": "", "target": [ "En el quadre de llista gran del diàleg, seleccioneu els intervals o les taules amb nom que voleu inserir." ], "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/110842148/?format=api", "priority": 100, "id": 110974617, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=133c8e855d2313e5", "url": "https://translations.documentfoundation.org/api/units/110974617/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.480485Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "source": [ "You can also specify that the ranges or tables are updated every n seconds." ], "previous_source": "", "target": [ "També podeu indicar que els intervals o les taules s'actualitzin cada n segons." ], "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/110842180/?format=api", "priority": 100, "id": 110974625, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=5c8dc6726e8e10f2", "url": "https://translations.documentfoundation.org/api/units/110974625/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.484293Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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 filtre d'importació pot crear noms per a intervals de cel·les de manera immediata. Es reté la màxima formatació, mentre que el filtre no carrega cap imatge intencionadament." ], "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/110842204/?format=api", "priority": 100, "id": 110974631, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=7b0c2211c2b64a49", "url": "https://translations.documentfoundation.org/api/units/110974631/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.486718Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "source": [ "Inserting by Navigator" ], "previous_source": "", "target": [ "Inserció mitjançant 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/110842229/?format=api", "priority": 100, "id": 110974639, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=d3d666f37dfc0560", "url": "https://translations.documentfoundation.org/api/units/110974639/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.488882Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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": [ "Obriu dos documents: el full de càlcul del $[officename] Calc on s'han d'inserir les dades externes (document de destinació) i el document del qual provenen les dades externes (document d'origen)." ], "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/110842253/?format=api", "priority": 100, "id": 110974643, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=cdd8ea41b00fd15d", "url": "https://translations.documentfoundation.org/api/units/110974643/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.490594Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "source": [ "In the target document open the Navigator." ], "previous_source": "", "target": [ "Obriu el Navegador en el document de destinació." ], "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/110842286/?format=api", "priority": 100, "id": 110974646, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=442080b63ddb5934", "url": "https://translations.documentfoundation.org/api/units/110974646/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.492365Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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": [ "Seleccioneu el document d'origen en el quadre combinat inferior del Navegador perquè mostri els noms dels intervals i els intervals de la base de dades o les taules que conté el document d'origen." ], "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/110842306/?format=api", "priority": 100, "id": 110974652, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=a6de0a191dc0fb27", "url": "https://translations.documentfoundation.org/api/units/110974652/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.493914Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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": [ "Al Navegador, seleccioneu el mode d'arrossegament <emph>Insereix com a enllaç</emph> <image id=\"img_id3152985\" src=\"sw/res/sc20238.png\" width=\"0.222inch\" height=\"0.222inch\"><alt id=\"alt_id3152985\">Icona</alt></image>." ], "id_hash": -9132184343404615382, "content_hash": -9132184343404615382, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3148842\nhelp.text", "note": "ZDFsw", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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/110842324/?format=api", "priority": 100, "id": 110974659, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=0143f6b95bfbe92a", "url": "https://translations.documentfoundation.org/api/units/110974659/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.499594Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "source": [ "Drag the desired external data from the Navigator into the target document." ], "previous_source": "", "target": [ "Arrossegueu les dades externes que vulgueu des del Navegador fins al document de destinació." ], "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/110842352/?format=api", "priority": 100, "id": 110974661, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=aea8c3c49a036a48", "url": "https://translations.documentfoundation.org/api/units/110974661/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.501925Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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 heu carregat un document HTML amb el filtre <emph>Consulta de pàgina web</emph> com a document d'origen, trobareu les taules al Navegador, designades de manera contínua des de \"taula1_HTML\" en endavant, i també dos noms d'intervals que s'hauran creat:" ], "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/110842361/?format=api", "priority": 100, "id": 110974664, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=a0bf749a10d32100", "url": "https://translations.documentfoundation.org/api/units/110974664/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.503792Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "source": [ "<item type=\"literal\">HTML_all</item> - designates the entire document" ], "previous_source": "", "target": [ "<item type=\"literal\">tot_HTML</item>: denomina tot el document" ], "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/110842370/?format=api", "priority": 100, "id": 110974670, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=29af936ef404919c", "url": "https://translations.documentfoundation.org/api/units/110974670/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.506041Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "source": [ "<item type=\"literal\">HTML_tables</item> - designates all HTML tables in the document" ], "previous_source": "", "target": [ "<item type=\"literal\">taules_HTML</item>: denomina totes les taules HTML en el document" ], "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/110842380/?format=api", "priority": 100, "id": 110974675, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=d57e1b06d3c1213d", "url": "https://translations.documentfoundation.org/api/units/110974675/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.509402Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "source": [ "Editing the external data" ], "previous_source": "", "target": [ "Edició de dades externes" ], "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/110842408/?format=api", "priority": 100, "id": 110974682, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=364e5f288d0263e3", "url": "https://translations.documentfoundation.org/api/units/110974682/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.511957Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "source": [ "Open <emph>Edit - Links</emph>. Here you can edit the link to the external data." ], "previous_source": "", "target": [ "Obriu <emph>Edita ▸ Enllaços</emph>. Aquí podreu editar l'enllaç a les dades externes." ], "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/110842432/?format=api", "priority": 100, "id": 110974686, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=4f4ff63a2456bd60", "url": "https://translations.documentfoundation.org/api/units/110974686/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.513887Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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àleg de dades externes</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/110842445/?format=api", "priority": 100, "id": 110974690, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=bb9d375c589a9d19", "url": "https://translations.documentfoundation.org/api/units/110974690/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.515998Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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/110842461/?format=api", "priority": 100, "id": 110974693, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=3a882dc3357ae84a", "url": "https://translations.documentfoundation.org/api/units/110974693/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.518089Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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/110842546/?format=api", "priority": 100, "id": 110974697, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=7ec84894bcb819d6", "url": "https://translations.documentfoundation.org/api/units/110974697/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.519726Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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/110842576/?format=api", "priority": 100, "id": 110974700, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=314f19a6e0fa0c37", "url": "https://translations.documentfoundation.org/api/units/110974700/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.521250Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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/110842609/?format=api", "priority": 100, "id": 110974704, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=e794001e38382fd4", "url": "https://translations.documentfoundation.org/api/units/110974704/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.522726Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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/110842648/?format=api", "priority": 100, "id": 110974708, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=c64749412b98e697", "url": "https://translations.documentfoundation.org/api/units/110974708/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.528878Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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/110842683/?format=api", "priority": 100, "id": 110974714, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=4ffb4e1d50b20b64", "url": "https://translations.documentfoundation.org/api/units/110974714/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.534258Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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/110842703/?format=api", "priority": 100, "id": 110974719, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=2c10d14de61a1ddc", "url": "https://translations.documentfoundation.org/api/units/110974719/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.538744Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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/110842738/?format=api", "priority": 100, "id": 110974721, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=a3e88aa4793b1d0c", "url": "https://translations.documentfoundation.org/api/units/110974721/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.540518Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "source": [ "Description" ], "previous_source": "", "target": [ "Descripció" ], "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/110842791/?format=api", "priority": 100, "id": 110974725, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=50ff5c432318f5d8", "url": "https://translations.documentfoundation.org/api/units/110974725/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.542205Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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/110842810/?format=api", "priority": 100, "id": 110974729, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=92fb6952ac7c7924", "url": "https://translations.documentfoundation.org/api/units/110974729/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.544204Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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/110842827/?format=api", "priority": 100, "id": 110974734, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=e1b9e9eab5d8f245", "url": "https://translations.documentfoundation.org/api/units/110974734/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.546027Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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/110842850/?format=api", "priority": 100, "id": 110974740, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=104a3d00f5d3a770", "url": "https://translations.documentfoundation.org/api/units/110974740/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.547986Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "source": [ "<emph>* (asterisk)</emph>" ], "previous_source": "", "target": [ "<emph>* (asterisc)</emph>" ], "id_hash": 8119798833534327055, "content_hash": 8119798833534327055, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id981629209073388\nhelp.text", "note": "PmsQL", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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/110842879/?format=api", "priority": 100, "id": 110974746, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=f0af5204c071d90f", "url": "https://translations.documentfoundation.org/api/units/110974746/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.549857Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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/110842919/?format=api", "priority": 100, "id": 110974755, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=199b55d564046926", "url": "https://translations.documentfoundation.org/api/units/110974755/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.557021Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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/110842942/?format=api", "priority": 100, "id": 110974767, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=0364cca279e66b7c", "url": "https://translations.documentfoundation.org/api/units/110974767/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.564152Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "source": [ "<emph>~ (tilde)</emph>" ], "previous_source": "", "target": [ "<emph>~ (titlla)</emph>" ], "id_hash": 5698902020506067604, "content_hash": 5698902020506067604, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id181629209277556\nhelp.text", "note": "ek6t7", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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/110842957/?format=api", "priority": 100, "id": 110974769, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=cf1691318e052294", "url": "https://translations.documentfoundation.org/api/units/110974769/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.566134Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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/110843001/?format=api", "priority": 100, "id": 110974772, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=7d9f4f2b2cda2197", "url": "https://translations.documentfoundation.org/api/units/110974772/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.568385Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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/110843018/?format=api", "priority": 100, "id": 110974776, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=2797446717cfc0a2", "url": "https://translations.documentfoundation.org/api/units/110974776/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.570287Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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/110843049/?format=api", "priority": 100, "id": 110974781, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=2d3886f1e8bb564e", "url": "https://translations.documentfoundation.org/api/units/110974781/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.572329Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "source": [ "Supported Spreadsheet Functions" ], "previous_source": "", "target": [ "Funcions de full de càlcul admeses" ], "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/110843073/?format=api", "priority": 100, "id": 110974787, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=d1c34b49843fe4b4", "url": "https://translations.documentfoundation.org/api/units/110974787/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.574665Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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/110843109/?format=api", "priority": 100, "id": 110974793, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=9979035b1972879c", "url": "https://translations.documentfoundation.org/api/units/110974793/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.576597Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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/110843142/?format=api", "priority": 100, "id": 110974797, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=ab68b1ef160ca3a8", "url": "https://translations.documentfoundation.org/api/units/110974797/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.578328Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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/110843158/?format=api", "priority": 100, "id": 110974801, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=2b7eb83206413cb7", "url": "https://translations.documentfoundation.org/api/units/110974801/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.580120Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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/110843179/?format=api", "priority": 100, "id": 110974819, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=adbac7da98218f63", "url": "https://translations.documentfoundation.org/api/units/110974819/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.592435Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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/110843205/?format=api", "priority": 100, "id": 110974824, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=9e8de6a3bd16c57e", "url": "https://translations.documentfoundation.org/api/units/110974824/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.594316Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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/110843223/?format=api", "priority": 100, "id": 110974827, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=45dcdf323a1d76ef", "url": "https://translations.documentfoundation.org/api/units/110974827/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.596108Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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/110843243/?format=api", "priority": 100, "id": 110974831, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=a0c1b2e870e484a0", "url": "https://translations.documentfoundation.org/api/units/110974831/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.597977Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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/110843260/?format=api", "priority": 100, "id": 110974835, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=b068b1cdb729db5d", "url": "https://translations.documentfoundation.org/api/units/110974835/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:55.599949Z" } ] }{ "count": 1558, "next": "