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/en/units/?format=api&page=31
{ "count": 1558, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/units/?format=api&page=32", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/units/?format=api&page=30", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?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": [ "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." ], "id_hash": -1754040601858356598, "content_hash": -1754040601858356598, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3155131\nhelp.text", "note": "Uf8QW", "flags": "", "labels": [], "state": 100, "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": 110841967, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=67a8655dac9eca8a", "url": "https://translations.documentfoundation.org/api/units/110841967/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.373408Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?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": [ "You can use the same method to insert ranges defined by name from a Calc or Microsoft Excel spreadsheet." ], "id_hash": -5329861810833699027, "content_hash": -5329861810833699027, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3148575\nhelp.text", "note": "eBygd", "flags": "", "labels": [], "state": 100, "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": 110841993, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=360886ebff564f2d", "url": "https://translations.documentfoundation.org/api/units/110841993/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.386448Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "The following insert methods are available:" ], "previous_source": "", "target": [ "The following insert methods are available:" ], "id_hash": -391306406609619005, "content_hash": -391306406609619005, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3149664\nhelp.text", "note": "odxLF", "flags": "", "labels": [], "state": 100, "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": 110842039, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=7a91cce57bb2f7c3", "url": "https://translations.documentfoundation.org/api/units/110842039/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.414020Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Inserting by Dialog" ], "previous_source": "", "target": [ "Inserting by Dialog" ], "id_hash": 5827784301768704225, "content_hash": 5827784301768704225, "location": "webquery.xhp", "context": "webquery.xhp\nhd_id3146976\nhelp.text", "note": "kNB42", "flags": "", "labels": [], "state": 100, "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": 110842063, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=d0e072f20e8580e1", "url": "https://translations.documentfoundation.org/api/units/110842063/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.438706Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Set the cell cursor at the cell where the new content will be inserted." ], "previous_source": "", "target": [ "Set the cell cursor at the cell where the new content will be inserted." ], "id_hash": 368152759068690997, "content_hash": 368152759068690997, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3154319\nhelp.text", "note": "WJEih", "flags": "", "labels": [], "state": 100, "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": 110842100, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=851bf0fbdb5e8a35", "url": "https://translations.documentfoundation.org/api/units/110842100/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.465735Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?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": [ "Choose <emph>Sheet - External Links</emph>. This opens the <link href=\"text/scalc/01/04090000.xhp\">External Data</link> dialog." ], "id_hash": -7616409846319291075, "content_hash": -7616409846319291075, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3145750\nhelp.text", "note": "SCn3P", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 110842107, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=164d13992659e53d", "url": "https://translations.documentfoundation.org/api/units/110842107/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.474936Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?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": [ "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." ], "id_hash": -8100371161362078385, "content_hash": -8100371161362078385, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3149958\nhelp.text", "note": "AGj3g", "flags": "", "labels": [], "state": 100, "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": 110842119, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=0f95b358aa31e54f", "url": "https://translations.documentfoundation.org/api/units/110842119/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.489888Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "In the large list box of the dialog, select the named ranges or tables you want to insert." ], "previous_source": "", "target": [ "In the large list box of the dialog, select the named ranges or tables you want to insert." ], "id_hash": -7837232548087131163, "content_hash": -7837232548087131163, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3149400\nhelp.text", "note": "5b5MC", "flags": "", "labels": [], "state": 100, "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": 110842148, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=133c8e855d2313e5", "url": "https://translations.documentfoundation.org/api/units/110842148/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.513207Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "You can also specify that the ranges or tables are updated every n seconds." ], "previous_source": "", "target": [ "You can also specify that the ranges or tables are updated every n seconds." ], "id_hash": -2554167218865827598, "content_hash": -2554167218865827598, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3155064\nhelp.text", "note": "Kegfn", "flags": "", "labels": [], "state": 100, "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": 110842180, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=5c8dc6726e8e10f2", "url": "https://translations.documentfoundation.org/api/units/110842180/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.553953Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?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": [ "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." ], "id_hash": -356872810792596919, "content_hash": -356872810792596919, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3155443\nhelp.text", "note": "ywoJU", "flags": "", "labels": [], "state": 100, "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": 110842204, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=7b0c2211c2b64a49", "url": "https://translations.documentfoundation.org/api/units/110842204/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.569227Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Inserting by Navigator" ], "previous_source": "", "target": [ "Inserting by Navigator" ], "id_hash": 6041129146140853600, "content_hash": 6041129146140853600, "location": "webquery.xhp", "context": "webquery.xhp\nhd_id3149021\nhelp.text", "note": "HA9v2", "flags": "", "labels": [], "state": 100, "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": 110842229, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=d3d666f37dfc0560", "url": "https://translations.documentfoundation.org/api/units/110842229/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.582389Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?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": [ "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)." ], "id_hash": 5609490903737553245, "content_hash": 5609490903737553245, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3153965\nhelp.text", "note": "KpQYC", "flags": "", "labels": [], "state": 100, "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": 110842253, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=cdd8ea41b00fd15d", "url": "https://translations.documentfoundation.org/api/units/110842253/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.596657Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "In the target document open the Navigator." ], "previous_source": "", "target": [ "In the target document open the Navigator." ], "id_hash": -4314306922810746572, "content_hash": -4314306922810746572, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3150205\nhelp.text", "note": "ekAUo", "flags": "", "labels": [], "state": 100, "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": 110842286, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=442080b63ddb5934", "url": "https://translations.documentfoundation.org/api/units/110842286/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.614053Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?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": [ "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." ], "id_hash": 2800687121260673831, "content_hash": 2800687121260673831, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3152990\nhelp.text", "note": "z9DtM", "flags": "", "labels": [], "state": 100, "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": 110842306, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=a6de0a191dc0fb27", "url": "https://translations.documentfoundation.org/api/units/110842306/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.625598Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?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": [ "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>." ], "id_hash": -9132184343404615382, "content_hash": -9132184343404615382, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3148842\nhelp.text", "note": "ZDFsw", "flags": "", "labels": [], "state": 100, "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": 110842324, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=0143f6b95bfbe92a", "url": "https://translations.documentfoundation.org/api/units/110842324/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.642527Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Drag the desired external data from the Navigator into the target document." ], "previous_source": "", "target": [ "Drag the desired external data from the Navigator into the target document." ], "id_hash": 3362152370996996680, "content_hash": 3362152370996996680, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3157978\nhelp.text", "note": "LS3Wf", "flags": "", "labels": [], "state": 100, "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": 110842352, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=aea8c3c49a036a48", "url": "https://translations.documentfoundation.org/api/units/110842352/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.673361Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?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": [ "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:" ], "id_hash": 2359732934821486848, "content_hash": 2359732934821486848, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3144768\nhelp.text", "note": "9GfqA", "flags": "", "labels": [], "state": 100, "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": 110842361, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=a0bf749a10d32100", "url": "https://translations.documentfoundation.org/api/units/110842361/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.685322Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "<item type=\"literal\">HTML_all</item> - designates the entire document" ], "previous_source": "", "target": [ "<item type=\"literal\">HTML_all</item> - designates the entire document" ], "id_hash": -6219590455625739876, "content_hash": -6219590455625739876, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3152873\nhelp.text", "note": "rcjUt", "flags": "", "labels": [], "state": 100, "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": 110842370, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=29af936ef404919c", "url": "https://translations.documentfoundation.org/api/units/110842370/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.694604Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?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> - designates all HTML tables in the document" ], "id_hash": 6160391056425820477, "content_hash": 6160391056425820477, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3149897\nhelp.text", "note": "ecFZG", "flags": "", "labels": [], "state": 100, "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": 110842380, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=d57e1b06d3c1213d", "url": "https://translations.documentfoundation.org/api/units/110842380/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.718074Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Editing the external data" ], "previous_source": "", "target": [ "Editing the external data" ], "id_hash": -5310202282854161437, "content_hash": -5310202282854161437, "location": "webquery.xhp", "context": "webquery.xhp\nhd_id3149126\nhelp.text", "note": "TGhCr", "flags": "", "labels": [], "state": 100, "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": 110842408, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=364e5f288d0263e3", "url": "https://translations.documentfoundation.org/api/units/110842408/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.741732Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Open <emph>Edit - Links</emph>. Here you can edit the link to the external data." ], "previous_source": "", "target": [ "Open <emph>Edit - Links</emph>. Here you can edit the link to the external data." ], "id_hash": -3508314855120126624, "content_hash": -3508314855120126624, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3159228\nhelp.text", "note": "GEeyF", "flags": "", "labels": [], "state": 100, "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": 110842432, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=4f4ff63a2456bd60", "url": "https://translations.documentfoundation.org/api/units/110842432/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.753971Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "<link href=\"text/scalc/01/04090000.xhp\">External data dialog</link>" ], "previous_source": "", "target": [ "<link href=\"text/scalc/01/04090000.xhp\">External data dialog</link>" ], "id_hash": 4295650489344367897, "content_hash": 4295650489344367897, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3154650\nhelp.text", "note": "xJkAV", "flags": "", "labels": [], "state": 100, "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": 110842445, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=bb9d375c589a9d19", "url": "https://translations.documentfoundation.org/api/units/110842445/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.764816Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Using Wildcards in Formulas" ], "previous_source": "", "target": [ "Using Wildcards in Formulas" ], "id_hash": -5005700669383186358, "content_hash": -5005700669383186358, "location": "wildcards.xhp", "context": "wildcards.xhp\ntit\nhelp.text", "note": "GnXq4", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 110842461, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=3a882dc3357ae84a", "url": "https://translations.documentfoundation.org/api/units/110842461/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.841783Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "<bookmark_value>wildcards in formulas</bookmark_value> <bookmark_value>wildcards;examples</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>wildcards in formulas</bookmark_value> <bookmark_value>wildcards;examples</bookmark_value>" ], "id_hash": -87740389075183146, "content_hash": -87740389075183146, "location": "wildcards.xhp", "context": "wildcards.xhp\nbm_id3152149\nhelp.text", "note": "kZVe7", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 110842546, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=7ec84894bcb819d6", "url": "https://translations.documentfoundation.org/api/units/110842546/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.899559Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "<variable id=\"wildcards_h1\"><link href=\"text/scalc/guide/wildcards.xhp\">Using Wildcards in Formulas</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"wildcards_h1\"><link href=\"text/scalc/guide/wildcards.xhp\">Using Wildcards in Formulas</link></variable>" ], "id_hash": -5670285201306416073, "content_hash": -5670285201306416073, "location": "wildcards.xhp", "context": "wildcards.xhp\nhd_id941629155075179\nhelp.text", "note": "ynEWi", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 110842576, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=314f19a6e0fa0c37", "url": "https://translations.documentfoundation.org/api/units/110842576/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.914247Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?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": [ "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." ], "id_hash": 7463590612251979732, "content_hash": 7463590612251979732, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id571629155308959\nhelp.text", "note": "yqMKw", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 110842609, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=e794001e38382fd4", "url": "https://translations.documentfoundation.org/api/units/110842609/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.927610Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?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": [ "%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." ], "id_hash": 5064096850254554775, "content_hash": 5064096850254554775, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id391629156224638\nhelp.text", "note": "vQrdp", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 110842648, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=c64749412b98e697", "url": "https://translations.documentfoundation.org/api/units/110842648/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.955281Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?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": [ "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." ], "id_hash": -3460086000889230492, "content_hash": -3460086000889230492, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id551629156504794\nhelp.text", "note": "GVpD7", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 110842683, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=4ffb4e1d50b20b64", "url": "https://translations.documentfoundation.org/api/units/110842683/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.976847Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "The following wildcards are supported:" ], "previous_source": "", "target": [ "The following wildcards are supported:" ], "id_hash": -6048104167055417892, "content_hash": -6048104167055417892, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id141629156913731\nhelp.text", "note": "BHJzs", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 110842703, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=2c10d14de61a1ddc", "url": "https://translations.documentfoundation.org/api/units/110842703/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.991840Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Wildcard" ], "previous_source": "", "target": [ "Wildcard" ], "id_hash": 2587470424937536780, "content_hash": 2587470424937536780, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id801629209195110\nhelp.text", "note": "tbbPM", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 110842738, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=a3e88aa4793b1d0c", "url": "https://translations.documentfoundation.org/api/units/110842738/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:07.007823Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Description" ], "previous_source": "", "target": [ "Description" ], "id_hash": -3386886951337921064, "content_hash": -3386886951337921064, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id861629209212608\nhelp.text", "note": "7PmfG", "flags": "", "labels": [], "state": 100, "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": 110842791, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=50ff5c432318f5d8", "url": "https://translations.documentfoundation.org/api/units/110842791/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:07.038018Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "<emph>? (question mark)</emph>" ], "previous_source": "", "target": [ "<emph>? (question mark)</emph>" ], "id_hash": 1367802715639150884, "content_hash": 1367802715639150884, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id591629209073388\nhelp.text", "note": "DfkJA", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 110842810, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=92fb6952ac7c7924", "url": "https://translations.documentfoundation.org/api/units/110842810/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:07.052063Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?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": [ "Matches any single character. For example, the search string \"b?g\" matches “bag” and “beg” but will not match \"boog\" or \"mug\"." ], "id_hash": 7041916686652994117, "content_hash": 7041916686652994117, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id31629209073388\nhelp.text", "note": "F2wmk", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 110842827, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=e1b9e9eab5d8f245", "url": "https://translations.documentfoundation.org/api/units/110842827/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:07.078932Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?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": [ "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." ], "id_hash": -8049554309637757072, "content_hash": -8049554309637757072, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id121629209114452\nhelp.text", "note": "pi9ik", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 110842850, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=104a3d00f5d3a770", "url": "https://translations.documentfoundation.org/api/units/110842850/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:07.094103Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "<emph>* (asterisk)</emph>" ], "previous_source": "", "target": [ "<emph>* (asterisk)</emph>" ], "id_hash": 8119798833534327055, "content_hash": 8119798833534327055, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id981629209073388\nhelp.text", "note": "PmsQL", "flags": "", "labels": [], "state": 100, "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": 110842879, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=f0af5204c071d90f", "url": "https://translations.documentfoundation.org/api/units/110842879/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:07.108739Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?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": [ "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." ], "id_hash": -7378209189522020058, "content_hash": -7378209189522020058, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id51629209073388\nhelp.text", "note": "6V7SE", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 110842919, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=199b55d564046926", "url": "https://translations.documentfoundation.org/api/units/110842919/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:07.143094Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?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": [ "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." ], "id_hash": -8978826758868014212, "content_hash": -8978826758868014212, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id351629209153307\nhelp.text", "note": "fDuhF", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 110842942, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=0364cca279e66b7c", "url": "https://translations.documentfoundation.org/api/units/110842942/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:07.164210Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "<emph>~ (tilde)</emph>" ], "previous_source": "", "target": [ "<emph>~ (tilde)</emph>" ], "id_hash": 5698902020506067604, "content_hash": 5698902020506067604, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id181629209277556\nhelp.text", "note": "ek6t7", "flags": "", "labels": [], "state": 100, "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": 110842957, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=cf1691318e052294", "url": "https://translations.documentfoundation.org/api/units/110842957/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:07.176302Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?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": [ "Escapes the special meaning of a question mark, asterisk, or tilde character that follows immediately after the tilde character." ], "id_hash": -171331213962108521, "content_hash": -171331213962108521, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id881629209280877\nhelp.text", "note": "F3Tuy", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 110843001, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=7d9f4f2b2cda2197", "url": "https://translations.documentfoundation.org/api/units/110843001/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:07.214507Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "For example, the search string \"why~?\" matches “why?” but will not match \"whys\" nor \"why~s\"." ], "previous_source": "", "target": [ "For example, the search string \"why~?\" matches “why?” but will not match \"whys\" nor \"why~s\"." ], "id_hash": -6370547938320465758, "content_hash": -6370547938320465758, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id861629209431020\nhelp.text", "note": "P35Fo", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 110843018, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=2797446717cfc0a2", "url": "https://translations.documentfoundation.org/api/units/110843018/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:07.228109Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?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": [ "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." ], "id_hash": -5964869332902390194, "content_hash": -5964869332902390194, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id1001629157561261\nhelp.text", "note": "aCtpj", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 110843049, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=2d3886f1e8bb564e", "url": "https://translations.documentfoundation.org/api/units/110843049/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:07.245548Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Supported Spreadsheet Functions" ], "previous_source": "", "target": [ "Supported Spreadsheet Functions" ], "id_hash": 5891635516654216372, "content_hash": 5891635516654216372, "location": "wildcards.xhp", "context": "wildcards.xhp\nhd_id671629158766165\nhelp.text", "note": "Dwt2G", "flags": "", "labels": [], "state": 100, "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": 110843073, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=d1c34b49843fe4b4", "url": "https://translations.documentfoundation.org/api/units/110843073/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:07.272489Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Wildcards are supported by the following spreadsheet functions:" ], "previous_source": "", "target": [ "Wildcards are supported by the following spreadsheet functions:" ], "id_hash": 1835502012934031260, "content_hash": 1835502012934031260, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id161629158785887\nhelp.text", "note": "YF9FB", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 110843109, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=9979035b1972879c", "url": "https://translations.documentfoundation.org/api/units/110843109/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:07.288917Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "<emph>Database functions:</emph> DAVERAGE, DCOUNT, DCOUNTA, DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR and DVARP." ], "previous_source": "", "target": [ "<emph>Database functions:</emph> DAVERAGE, DCOUNT, DCOUNTA, DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR and DVARP." ], "id_hash": 3127945581634036648, "content_hash": 3127945581634036648, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id441629158810517\nhelp.text", "note": "rRPbf", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 110843142, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=ab68b1ef160ca3a8", "url": "https://translations.documentfoundation.org/api/units/110843142/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:07.308590Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "<emph>Conditional functions:</emph> AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS, MAXIFS, MINIFS, SUMIF and SUMIFS." ], "previous_source": "", "target": [ "<emph>Conditional functions:</emph> AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS, MAXIFS, MINIFS, SUMIF and SUMIFS." ], "id_hash": -6089227121165517641, "content_hash": -6089227121165517641, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id321629158810916\nhelp.text", "note": "gfUGT", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 110843158, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=2b7eb83206413cb7", "url": "https://translations.documentfoundation.org/api/units/110843158/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:07.324979Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "<emph>Lookup functions:</emph> HLOOKUP, LOOKUP and VLOOKUP." ], "previous_source": "", "target": [ "<emph>Lookup functions:</emph> HLOOKUP, LOOKUP and VLOOKUP." ], "id_hash": 3295165819044073315, "content_hash": 3295165819044073315, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id941629158811325\nhelp.text", "note": "oUwuB", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 110843179, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=adbac7da98218f63", "url": "https://translations.documentfoundation.org/api/units/110843179/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:07.336898Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "<emph>Other functions:</emph> MATCH and SEARCH." ], "previous_source": "", "target": [ "<emph>Other functions:</emph> MATCH and SEARCH." ], "id_hash": 2201669383780484478, "content_hash": 2201669383780484478, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id41629158919808\nhelp.text", "note": "Ka6SK", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 110843205, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=9e8de6a3bd16c57e", "url": "https://translations.documentfoundation.org/api/units/110843205/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:07.356349Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Examples of Wildcards in Formulas" ], "previous_source": "", "target": [ "Examples of Wildcards in Formulas" ], "id_hash": -4189228146545035537, "content_hash": -4189228146545035537, "location": "wildcards.xhp", "context": "wildcards.xhp\nhd_id701629159564269\nhelp.text", "note": "2ZGuQ", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 110843223, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=45dcdf323a1d76ef", "url": "https://translations.documentfoundation.org/api/units/110843223/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:07.367213Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?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": [ "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>." ], "id_hash": 2360364391115031712, "content_hash": 2360364391115031712, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id121629289062103\nhelp.text", "note": "3WVEm", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 110843243, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=a0c1b2e870e484a0", "url": "https://translations.documentfoundation.org/api/units/110843243/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:07.389070Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?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": [ "<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." ], "id_hash": 3488233408497834845, "content_hash": 3488233408497834845, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id271629159111490\nhelp.text", "note": "znKay", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 110843260, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=b068b1cdb729db5d", "url": "https://translations.documentfoundation.org/api/units/110843260/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:07.403273Z" } ] }