Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-master/textscalcguide/gl/units/?format=api&page=26
{ "count": 1559, "next": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/units/?format=api&page=27", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/units/?format=api&page=25", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?format=api", "source": [ "In the <emph>Name</emph> box of the <emph>Add AutoFormat</emph> dialog, enter a name for the new AutoFormat style." ], "previous_source": "", "target": [ "Na opción <emph>Nome</emph> da caixa de diálogo <emph>Engadir formato automático</emph>, introduza un nome para o formato novo." ], "id_hash": -4837248562555428723, "content_hash": -4837248562555428723, "location": "autoformat.xhp", "context": "autoformat.xhp\npar_idN10760\nhelp.text", "note": "GxXmX", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 61, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/55980277/?format=api", "priority": 100, "id": 55983439, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=3cdea40faa9d608d", "url": "https://translations.documentfoundation.org/api/units/55983439/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-10T22:59:12.662186Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?format=api", "source": [ "Click <emph>OK</emph> and close the dialog." ], "previous_source": "", "target": [ "Prema en <emph>Aceptar</emph> e peche a caixa de diálogo." ], "id_hash": -5293421348899267328, "content_hash": -5293421348899267328, "location": "autoformat.xhp", "context": "autoformat.xhp\npar_idN107C3\nhelp.text", "note": "pMxn9", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 62, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/55980278/?format=api", "priority": 100, "id": 55983440, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=3689fd543463dd00", "url": "https://translations.documentfoundation.org/api/units/55983440/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-10T22:59:12.662874Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?format=api", "source": [ "The new AutoFormat styles created using the steps above can be applied to any %PRODUCTNAME Calc file. Hence they are not limited to the file where the style was created." ], "previous_source": "", "target": [ "Os estilos de formato automático novos creados empregado os pasos anteriores pódense aplicar a calquera ficheiro do Calc do %PRODUCTNAME. Por tanto, non están limitados ao ficheiro no que se creou o estilo." ], "id_hash": 4052177063758461334, "content_hash": 4052177063758461334, "location": "autoformat.xhp", "context": "autoformat.xhp\npar_id51630343134146\nhelp.text", "note": "HJiDi", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 63, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/55980279/?format=api", "priority": 100, "id": 55983441, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=b83c3991f44ef996", "url": "https://translations.documentfoundation.org/api/units/55983441/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-10T22:59:12.663527Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?format=api", "source": [ "<bookmark_value>cells;borders</bookmark_value> <bookmark_value>line arrangements with cells</bookmark_value> <bookmark_value>borders;cells</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>celas;bordos</bookmark_value> <bookmark_value>disposición de liñas con celas</bookmark_value> <bookmark_value>bordos;celas</bookmark_value>" ], "id_hash": 1752626492941895369, "content_hash": 1752626492941895369, "location": "borders.xhp", "context": "borders.xhp\nbm_id3457441\nhelp.text", "note": "RRraV", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 81, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/55980280/?format=api", "priority": 100, "id": 55983442, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=985294826fbd86c9", "url": "https://translations.documentfoundation.org/api/units/55983442/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-10T22:59:12.665479Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?format=api", "source": [ "<bookmark_value>adjacent cells;remove border</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>celas adxacentes;retirar bordo</bookmark_value>" ], "id_hash": -3251202385246212860, "content_hash": -3251202385246212860, "location": "borders.xhp", "context": "borders.xhp\nbm_id151630452717743\nhelp.text", "note": "KKHLH", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 138, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/55980286/?format=api", "priority": 100, "id": 55983443, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=52e168a7fe7f2d04", "url": "https://translations.documentfoundation.org/api/units/55983443/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-10T22:59:12.684124Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?format=api", "source": [ "Adjacent Cells" ], "previous_source": "", "target": [ "Celas adxacentes" ], "id_hash": -5030411594797092697, "content_hash": -5030411594797092697, "location": "borders.xhp", "context": "borders.xhp\nhd_id861630451554176\nhelp.text", "note": "eEE4F", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 139, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/55980294/?format=api", "priority": 100, "id": 55983444, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=3a30634e8a1cf0a7", "url": "https://translations.documentfoundation.org/api/units/55983444/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-10T22:59:12.684900Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?format=api", "source": [ "This option becomes available when formatting a range of cells that already have borders and the new format defined for the range involves removing outer borders." ], "previous_source": "", "target": [ "Esta opción está dispoñíbel ao formatar un intervalo de celas que xa teñan bordos e cando o novo formato definido para o intervalo implica a retirada dos bordos exteriores." ], "id_hash": 7171703041391866782, "content_hash": 7171703041391866782, "location": "borders.xhp", "context": "borders.xhp\npar_id231630451548190\nhelp.text", "note": "k8s2o", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 140, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/55980297/?format=api", "priority": 100, "id": 55983445, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=e38701eb38c0339e", "url": "https://translations.documentfoundation.org/api/units/55983445/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-10T22:59:12.685539Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?format=api", "source": [ "By default the option <emph>Remove border</emph> is disabled and the borders at the edges of the selected range are left unchanged. Check this option if the borders at the edge of the selection should be removed." ], "previous_source": "", "target": [ "Por omisión, a opción <emph>Retirar bordo</emph> está desactivada e os bordos nos límites do intervalo seleccionado fican inalterados. Marque esta opción se desexa que se retiren os bordos no límite da selección." ], "id_hash": 6335542091060662861, "content_hash": 6335542091060662861, "location": "borders.xhp", "context": "borders.xhp\npar_id931630451706604\nhelp.text", "note": "xADD4", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 141, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/55980298/?format=api", "priority": 100, "id": 55983446, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=d7ec5df6f534d24d", "url": "https://translations.documentfoundation.org/api/units/55983446/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-10T22:59:12.686228Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?format=api", "source": [ "If the preset <emph>No Borders</emph> is chosen then the <emph>Remove border</emph> option is enabled." ], "previous_source": "", "target": [ "Se a opción predeterminada <emph>Sen bordes</emph> estiver escollida, actívase a opción <emph>Retirar bordo</emph>." ], "id_hash": 6734814408994981843, "content_hash": 6734814408994981843, "location": "borders.xhp", "context": "borders.xhp\npar_id641630452272324\nhelp.text", "note": "V8sNd", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 142, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/55980299/?format=api", "priority": 100, "id": 55983447, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=dd76de05bc5407d3", "url": "https://translations.documentfoundation.org/api/units/55983447/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-10T22:59:12.686891Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?format=api", "source": [ "Removing Duplicate Values" ], "previous_source": "", "target": [ "" ], "id_hash": -2983475880029248536, "content_hash": -2983475880029248536, "location": "remove_duplicates.xhp", "context": "remove_duplicates.xhp\ntit\nhelp.text", "note": "kAFBF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1211, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/55980330/?format=api", "priority": 100, "id": 55983451, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=5698907e86e923e8", "url": "https://translations.documentfoundation.org/api/units/55983451/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-10T22:59:13.143957Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?format=api", "source": [ "<bookmark_value>filters; removing duplicates</bookmark_value> <bookmark_value>filters; finding unique values</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 23690743095814838, "content_hash": 23690743095814838, "location": "remove_duplicates.xhp", "context": "remove_duplicates.xhp\nbm_id3153896\nhelp.text", "note": "hGQvA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1212, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/55980331/?format=api", "priority": 100, "id": 55983452, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=80542a9af6b0eab6", "url": "https://translations.documentfoundation.org/api/units/55983452/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-10T22:59:13.144721Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?format=api", "source": [ "Consider a single column with values where some may be duplicates. To remove duplicate values and obtain only the unique entries in the column:" ], "previous_source": "", "target": [ "" ], "id_hash": 754058445884186353, "content_hash": 754058445884186353, "location": "remove_duplicates.xhp", "context": "remove_duplicates.xhp\npar_id3150869\nhelp.text", "note": "ocizx", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1214, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/55980333/?format=api", "priority": 100, "id": 55983454, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=8a76f4294ecf5ef1", "url": "https://translations.documentfoundation.org/api/units/55983454/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-10T22:59:13.146097Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?format=api", "source": [ "Select the range of values from which duplicate values are to be removed. The values have to be arranged in a single column." ], "previous_source": "", "target": [ "" ], "id_hash": 5042633706603181686, "content_hash": 5042633706603181686, "location": "remove_duplicates.xhp", "context": "remove_duplicates.xhp\npar_id631630021463659\nhelp.text", "note": "omVUk", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1215, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/55980334/?format=api", "priority": 100, "id": 55983455, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=c5fb08a39e7e7676", "url": "https://translations.documentfoundation.org/api/units/55983455/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-10T22:59:13.146773Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?format=api", "source": [ "In <emph>Field Name</emph> make sure that the selected column is the column where the values are stored. If a single column is selected this field will be set automatically." ], "previous_source": "", "target": [ "" ], "id_hash": -2821781971743155161, "content_hash": -2821781971743155161, "location": "remove_duplicates.xhp", "context": "remove_duplicates.xhp\npar_id801630022108301\nhelp.text", "note": "EVEzq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1217, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/55980336/?format=api", "priority": 100, "id": 55983457, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=58d7043f44a5dc27", "url": "https://translations.documentfoundation.org/api/units/55983457/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-10T22:59:13.148134Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?format=api", "source": [ "In <emph>Condition</emph> choose the option <emph>=</emph> (equals sign), which is the default option." ], "previous_source": "", "target": [ "" ], "id_hash": -6045815243940888930, "content_hash": -6045815243940888930, "location": "remove_duplicates.xhp", "context": "remove_duplicates.xhp\npar_id461630022298515\nhelp.text", "note": "TesFn", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1218, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/55980337/?format=api", "priority": 100, "id": 55983458, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=2c18f3115742fe9e", "url": "https://translations.documentfoundation.org/api/units/55983458/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-10T22:59:13.148821Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?format=api", "source": [ "In <emph>Value</emph> choose the option <emph>Not Empty</emph>." ], "previous_source": "", "target": [ "" ], "id_hash": -7720909804198355217, "content_hash": -7720909804198355217, "location": "remove_duplicates.xhp", "context": "remove_duplicates.xhp\npar_id261630022372414\nhelp.text", "note": "nWrGh", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1219, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/55980338/?format=api", "priority": 100, "id": 55983459, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=14d9d170b1ed1eef", "url": "https://translations.documentfoundation.org/api/units/55983459/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-10T22:59:13.149483Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?format=api", "source": [ "Click <emph>Options</emph> and select <emph>No duplications</emph>. If the first value is the column header check <emph>Range contains column labels</emph>." ], "previous_source": "", "target": [ "" ], "id_hash": -1077046548573044368, "content_hash": -1077046548573044368, "location": "remove_duplicates.xhp", "context": "remove_duplicates.xhp\npar_id441630022436605\nhelp.text", "note": "fFZRM", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1220, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/55980339/?format=api", "priority": 100, "id": 55983460, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=710d8fded9be4170", "url": "https://translations.documentfoundation.org/api/units/55983460/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-10T22:59:13.150136Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?format=api", "source": [ "Check <emph>Copy results</emph> and use the input box below it to inform a cell address where the unique entries are to be entered." ], "previous_source": "", "target": [ "" ], "id_hash": -697069813290261053, "content_hash": -697069813290261053, "location": "remove_duplicates.xhp", "context": "remove_duplicates.xhp\npar_id841630022924442\nhelp.text", "note": "sdBSD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1221, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/55980340/?format=api", "priority": 100, "id": 55983461, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=765382b2b32fa5c3", "url": "https://translations.documentfoundation.org/api/units/55983461/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-10T22:59:13.150801Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?format=api", "source": [ "Click <emph>OK</emph>. The unique values in the range will be entered starting with the cell selected in the previous step." ], "previous_source": "", "target": [ "" ], "id_hash": 8693133264239808428, "content_hash": 8693133264239808428, "location": "remove_duplicates.xhp", "context": "remove_duplicates.xhp\npar_id61630023053412\nhelp.text", "note": "DJcXh", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1222, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/55980341/?format=api", "priority": 100, "id": 55983462, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=f8a436a548254fac", "url": "https://translations.documentfoundation.org/api/units/55983462/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-10T22:59:13.151495Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?format=api", "source": [ "The <emph>No duplications</emph> option is case sensitive. Therefore, values \"A\" and \"a\" are each considered as unique values." ], "previous_source": "", "target": [ "" ], "id_hash": 6660648956453329420, "content_hash": 6660648956453329420, "location": "remove_duplicates.xhp", "context": "remove_duplicates.xhp\npar_id81630022708336\nhelp.text", "note": "3qh4V", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1223, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/55980342/?format=api", "priority": 100, "id": 55983463, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=dc6f60efaefa1a0c", "url": "https://translations.documentfoundation.org/api/units/55983463/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-10T22:59:13.152170Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?format=api", "source": [ "Applying Advanced Filters" ], "previous_source": "", "target": [ "Aplicar filtros avanzados" ], "id_hash": -3660555054599967222, "content_hash": -3660555054599967222, "location": "specialfilter.xhp", "context": "specialfilter.xhp\ntit\nhelp.text", "note": "6GdiT", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1311, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/55980343/?format=api", "priority": 100, "id": 55983464, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=4d33189281ceee0a", "url": "https://translations.documentfoundation.org/api/units/55983464/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-10T22:59:13.190838Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?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": 1524, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/55980346/?format=api", "priority": 100, "id": 55983466, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=3a882dc3357ae84a", "url": "https://translations.documentfoundation.org/api/units/55983466/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-10T22:59:13.281242Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?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": 1527, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 52, "source_unit": "https://translations.documentfoundation.org/api/units/55980349/?format=api", "priority": 100, "id": 55983469, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=e794001e38382fd4", "url": "https://translations.documentfoundation.org/api/units/55983469/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-10T22:59:13.283359Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?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": 1528, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/55980350/?format=api", "priority": 100, "id": 55983470, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=c64749412b98e697", "url": "https://translations.documentfoundation.org/api/units/55983470/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-10T22:59:13.284042Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?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": 1530, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/55980352/?format=api", "priority": 100, "id": 55983472, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=2c10d14de61a1ddc", "url": "https://translations.documentfoundation.org/api/units/55983472/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-10T22:59:13.285449Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?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": 1531, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/55980353/?format=api", "priority": 100, "id": 55983473, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=a3e88aa4793b1d0c", "url": "https://translations.documentfoundation.org/api/units/55983473/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-10T22:59:13.286083Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?format=api", "source": [ "Description" ], "previous_source": "", "target": [ "" ], "id_hash": -3386886951337921064, "content_hash": -3386886951337921064, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id861629209212608\nhelp.text", "note": "7PmfG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1532, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/55980354/?format=api", "priority": 100, "id": 55983474, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=50ff5c432318f5d8", "url": "https://translations.documentfoundation.org/api/units/55983474/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-10T22:59:13.286725Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?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": 1533, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/55980357/?format=api", "priority": 100, "id": 55983475, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=92fb6952ac7c7924", "url": "https://translations.documentfoundation.org/api/units/55983475/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-10T22:59:13.287360Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?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": 1534, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/55980360/?format=api", "priority": 100, "id": 55983476, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=e1b9e9eab5d8f245", "url": "https://translations.documentfoundation.org/api/units/55983476/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-10T22:59:13.288010Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?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": 1535, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/55980361/?format=api", "priority": 100, "id": 55983477, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=104a3d00f5d3a770", "url": "https://translations.documentfoundation.org/api/units/55983477/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-10T22:59:13.288678Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?format=api", "source": [ "<emph>* (asterisk)</emph>" ], "previous_source": "", "target": [ "" ], "id_hash": 8119798833534327055, "content_hash": 8119798833534327055, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id981629209073388\nhelp.text", "note": "PmsQL", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1536, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/55980362/?format=api", "priority": 100, "id": 55983478, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=f0af5204c071d90f", "url": "https://translations.documentfoundation.org/api/units/55983478/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-10T22:59:13.289342Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?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": 1537, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/55980363/?format=api", "priority": 100, "id": 55983479, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=199b55d564046926", "url": "https://translations.documentfoundation.org/api/units/55983479/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-10T22:59:13.289993Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?format=api", "source": [ "<emph>~ (tilde)</emph>" ], "previous_source": "", "target": [ "" ], "id_hash": 5698902020506067604, "content_hash": 5698902020506067604, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id181629209277556\nhelp.text", "note": "ek6t7", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1539, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/55980365/?format=api", "priority": 100, "id": 55983481, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=cf1691318e052294", "url": "https://translations.documentfoundation.org/api/units/55983481/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-10T22:59:13.291375Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?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": 1540, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/55980366/?format=api", "priority": 100, "id": 55983482, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=7d9f4f2b2cda2197", "url": "https://translations.documentfoundation.org/api/units/55983482/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-10T22:59:13.292021Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?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": 1541, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/55980367/?format=api", "priority": 100, "id": 55983483, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=2797446717cfc0a2", "url": "https://translations.documentfoundation.org/api/units/55983483/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-10T22:59:13.292709Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?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": 1542, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://translations.documentfoundation.org/api/units/55980368/?format=api", "priority": 100, "id": 55983484, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=2d3886f1e8bb564e", "url": "https://translations.documentfoundation.org/api/units/55983484/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-10T22:59:13.293359Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?format=api", "source": [ "Supported Spreadsheet Functions" ], "previous_source": "", "target": [ "" ], "id_hash": 5891635516654216372, "content_hash": 5891635516654216372, "location": "wildcards.xhp", "context": "wildcards.xhp\nhd_id671629158766165\nhelp.text", "note": "Dwt2G", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1543, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/55980369/?format=api", "priority": 100, "id": 55983485, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=d1c34b49843fe4b4", "url": "https://translations.documentfoundation.org/api/units/55983485/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-10T22:59:13.294553Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?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": 1544, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/55980370/?format=api", "priority": 100, "id": 55983486, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=9979035b1972879c", "url": "https://translations.documentfoundation.org/api/units/55983486/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-10T22:59:13.295195Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?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": 1545, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/55980371/?format=api", "priority": 100, "id": 55983487, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=ab68b1ef160ca3a8", "url": "https://translations.documentfoundation.org/api/units/55983487/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-10T22:59:13.295858Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?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": 1546, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/55980372/?format=api", "priority": 100, "id": 55983488, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=2b7eb83206413cb7", "url": "https://translations.documentfoundation.org/api/units/55983488/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-10T22:59:13.296505Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?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": 1549, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/55980375/?format=api", "priority": 100, "id": 55983491, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=45dcdf323a1d76ef", "url": "https://translations.documentfoundation.org/api/units/55983491/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-10T22:59:13.298446Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?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": 1551, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/55980377/?format=api", "priority": 100, "id": 55983493, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=b068b1cdb729db5d", "url": "https://translations.documentfoundation.org/api/units/55983493/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-10T22:59:13.299799Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?format=api", "source": [ "<input>=SUMIF(A1:A5;\"A??\";B1:B5)</input> sums the values in <emph>B1:B5</emph> whose corresponding values in <emph>A1:A5</emph> start with \"A\" followed by exactly two other characters." ], "previous_source": "", "target": [ "" ], "id_hash": 6848237223235082099, "content_hash": 6848237223235082099, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id741629159343415\nhelp.text", "note": "TPRuA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1552, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/55980378/?format=api", "priority": 100, "id": 55983494, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=df09d3789488d773", "url": "https://translations.documentfoundation.org/api/units/55983494/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-10T22:59:13.300489Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?format=api", "source": [ "Wildcard comparisons are <emph>not</emph> case sensitive, hence \"A?\" will match both \"A1\" and \"a1\"." ], "previous_source": "", "target": [ "" ], "id_hash": -2703376618820200673, "content_hash": -2703376618820200673, "location": "wildcards.xhp", "context": "wildcards.xhp\npar_id141629159465592\nhelp.text", "note": "7GqMs", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1553, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/55980379/?format=api", "priority": 100, "id": 55983495, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=5a7bad49cd20171f", "url": "https://translations.documentfoundation.org/api/units/55983495/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-10T22:59:13.301163Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?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": 1525, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/56146979/?format=api", "priority": 100, "id": 56147346, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=7ec84894bcb819d6", "url": "https://translations.documentfoundation.org/api/units/56147346/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-28T20:39:01.145071Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?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": 1529, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 64, "source_unit": "https://translations.documentfoundation.org/api/units/56146980/?format=api", "priority": 100, "id": 56147347, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=4ffb4e1d50b20b64", "url": "https://translations.documentfoundation.org/api/units/56147347/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-28T20:39:01.146419Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?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": 1538, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 44, "source_unit": "https://translations.documentfoundation.org/api/units/56146981/?format=api", "priority": 100, "id": 56147348, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=0364cca279e66b7c", "url": "https://translations.documentfoundation.org/api/units/56147348/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-28T20:39:01.147842Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?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": 1550, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://translations.documentfoundation.org/api/units/56146982/?format=api", "priority": 100, "id": 56147349, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=a0c1b2e870e484a0", "url": "https://translations.documentfoundation.org/api/units/56147349/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-09-28T20:39:01.149540Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?format=api", "source": [ "Merge and Unmerge Cells" ], "previous_source": "", "target": [ "Combinar e desunir celas" ], "id_hash": 2873287511080926629, "content_hash": 2873287511080926629, "location": "table_cellmerge.xhp", "context": "table_cellmerge.xhp\ntit\nhelp.text", "note": "2wVQM", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1364, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/56159389/?format=api", "priority": 100, "id": 56159989, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=a7dff7c49b8b7da5", "url": "https://translations.documentfoundation.org/api/units/56159989/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-10-04T19:11:35.840700Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?format=api", "source": [ "You can select a range of cells, then merge them into a single cell. Conversely, you can take a previously merged cell and divide it back into individual cells." ], "previous_source": "", "target": [ "" ], "id_hash": 6361149359386861100, "content_hash": 6361149359386861100, "location": "table_cellmerge.xhp", "context": "table_cellmerge.xhp\npar_id8049867\nhelp.text", "note": "Hht67", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1367, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/56159392/?format=api", "priority": 100, "id": 56159992, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=d84757a3b9751e2c", "url": "https://translations.documentfoundation.org/api/units/56159992/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-10-04T19:11:35.843102Z" } ] }