Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-7-6/textscalc01/ast/units/?format=api&page=44
{ "count": 8352, "next": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/units/?format=api&page=45", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/units/?format=api&page=43", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Symbol" ], "previous_source": "", "target": [ "Símbolu" ], "id_hash": -2741696328488591392, "content_hash": -2741696328488591392, "location": "04060109.xhp", "context": "04060109.xhp\npar_id341612978329327\nhelp.text", "note": "4H4fa", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2151, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99154469/?format=api", "priority": 100, "id": 99496621, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=59f389b72271dfe0", "url": "https://translations.documentfoundation.org/api/units/99496621/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.568796Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Atomic Number" ], "previous_source": "", "target": [ "Númberu atómicu" ], "id_hash": 8197228261284471071, "content_hash": 8197228261284471071, "location": "04060109.xhp", "context": "04060109.xhp\npar_id601612978601591\nhelp.text", "note": "jVBoy", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2152, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99154506/?format=api", "priority": 100, "id": 99496623, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=f1c267ac40a7611f", "url": "https://translations.documentfoundation.org/api/units/99496623/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.570355Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Relative Atomic Mass" ], "previous_source": "", "target": [ "Masa atómica relativa" ], "id_hash": -3629097185374679292, "content_hash": -3629097185374679292, "location": "04060109.xhp", "context": "04060109.xhp\npar_id751612978603374\nhelp.text", "note": "WjrrE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2153, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99154536/?format=api", "priority": 100, "id": 99496625, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=4da2db56725f4f04", "url": "https://translations.documentfoundation.org/api/units/99496625/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.571894Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<input>=HLOOKUP(\"Lead\"; $A$1:$DO$4; 2; 0)</input> returns “Pb”, the symbol for lead." ], "previous_source": "", "target": [ "" ], "id_hash": 6194904089656399110, "content_hash": 6194904089656399110, "location": "04060109.xhp", "context": "04060109.xhp\npar_id51612447346319\nhelp.text", "note": "Cb3HA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2154, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/99154570/?format=api", "priority": 100, "id": 99496626, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=d5f8b87291959506", "url": "https://translations.documentfoundation.org/api/units/99496626/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.573355Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<input>=HLOOKUP(\"Gold\"; $A$1:$DO$4; 3; 0)</input> returns 79, the atomic number for gold." ], "previous_source": "", "target": [ "" ], "id_hash": -6964637376951726322, "content_hash": -6964637376951726322, "location": "04060109.xhp", "context": "04060109.xhp\npar_id291612447349416\nhelp.text", "note": "Fa8kD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2155, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/99154590/?format=api", "priority": 100, "id": 99496627, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=1f58a334b5624f0e", "url": "https://translations.documentfoundation.org/api/units/99496627/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.574735Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<input>=HLOOKUP(\"Carbon\"; $A$1:$DO$4; 4; 0)</input> returns 12.011, the relative atomic mass of carbon." ], "previous_source": "", "target": [ "" ], "id_hash": -4588238262470200363, "content_hash": -4588238262470200363, "location": "04060109.xhp", "context": "04060109.xhp\npar_id971612447352912\nhelp.text", "note": "LbWuo", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2156, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/99154624/?format=api", "priority": 100, "id": 99496630, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=40534d9c1c9bb3d5", "url": "https://translations.documentfoundation.org/api/units/99496630/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.576069Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>ROW function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>FILA</bookmark_value>" ], "id_hash": -2361118716865256180, "content_hash": -2361118716865256180, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3147321\nhelp.text", "note": "B4DL3", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2157, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99154646/?format=api", "priority": 100, "id": 99496633, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=5f3b9f0968b8650c", "url": "https://translations.documentfoundation.org/api/units/99496633/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.577423Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "ROW" ], "previous_source": "", "target": [ "ROW" ], "id_hash": -345179335225695980, "content_hash": -345179335225695980, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3147321\nhelp.text", "note": "Dk854", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2158, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99154674/?format=api", "priority": 100, "id": 99496635, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=7b35ad3934112114", "url": "https://translations.documentfoundation.org/api/units/99496635/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.579118Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_ZEILE\">Returns the row number of a cell reference.</ahelp> If the reference is a cell, it returns the row number of the cell. If the reference is a cell range, it returns the corresponding row numbers in a one-column <link href=\"text/scalc/01/04060107.xhp#wasmatrix\">Array</link> if the formula is entered <link href=\"text/scalc/01/04060107.xhp#creating_array_formulas\">as an array formula</link>. If the ROW function with a range reference is not used in an array formula, only the row number of the first range cell will be returned." ], "previous_source": "", "target": [ "" ], "id_hash": -3064035665891014416, "content_hash": -3064035665891014416, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154564\nhelp.text", "note": "VAtaY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2159, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 78, "source_unit": "https://translations.documentfoundation.org/api/units/99154718/?format=api", "priority": 100, "id": 99496638, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=557a5bcbbb7048f0", "url": "https://translations.documentfoundation.org/api/units/99496638/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.580688Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "ROW([Reference])" ], "previous_source": "", "target": [ "" ], "id_hash": 2805314088482138516, "content_hash": 2805314088482138516, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154916\nhelp.text", "note": "97EEE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2160, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99154738/?format=api", "priority": 100, "id": 99496641, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=a6ee7a4cdf606994", "url": "https://translations.documentfoundation.org/api/units/99496641/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.582232Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Reference</emph> is a cell, an area, or the name of an area." ], "previous_source": "", "target": [ "<emph>Referencia</emph> ye una caxella, una área o'l nome d'una área." ], "id_hash": 5194788869710857183, "content_hash": 5194788869710857183, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3156336\nhelp.text", "note": "mSqrb", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2161, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/99154788/?format=api", "priority": 100, "id": 99496644, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=c81798f42e44c3df", "url": "https://translations.documentfoundation.org/api/units/99496644/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.583637Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "If you do not indicate a reference, the row number of the cell in which the formula is entered will be found. <item type=\"productname\">%PRODUCTNAME</item> Calc automatically sets the reference to the current cell." ], "previous_source": "", "target": [ "Si nun indica una referencia, alcontrarase'l númberu de filera de la caxella na que s'introduz la fórmula. <item type=\"productname\">%PRODUCTNAME</item> Calc establez automáticamente la referencia a la caxella actual." ], "id_hash": 3720755741605929069, "content_hash": 3720755741605929069, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3151109\nhelp.text", "note": "eUXYG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2162, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/99154811/?format=api", "priority": 100, "id": 99496650, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=b3a2c7a2326aa06d", "url": "https://translations.documentfoundation.org/api/units/99496650/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.587759Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=ROW(B3)</item> returns 3 because the reference refers to the third row in the table." ], "previous_source": "", "target": [ "<item type=\"input\">=FILA(B3)</item> devuelve 3 porque la referencia fai mención a la tercer filera de la tabla." ], "id_hash": -2177386009179408488, "content_hash": -2177386009179408488, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154830\nhelp.text", "note": "GwuVx", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2163, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/99154823/?format=api", "priority": 100, "id": 99496653, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=61c85ef5fff4b798", "url": "https://translations.documentfoundation.org/api/units/99496653/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.589888Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">{=ROW(D5:D8)}</item> returns the single-column array (5, 6, 7, 8) because the reference specified contains rows 5 through 8." ], "previous_source": "", "target": [ "<item type=\"input\">{=FILA(D5:D8)}</item> devuelve la matriz d'una columna (5, 6, 7, 8) porque la referencia especificada contién les fileres 5 a 8." ], "id_hash": -2042965818137793533, "content_hash": -2042965818137793533, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3147094\nhelp.text", "note": "FDCdZ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2164, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/99154867/?format=api", "priority": 100, "id": 99496656, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=63a5ed6999a1ac03", "url": "https://translations.documentfoundation.org/api/units/99496656/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.591881Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=ROW(D5:D8)</item> returns 5 because the ROW function is not used as array formula and only the number of the first row of the reference is returned." ], "previous_source": "", "target": [ "<item type=\"input\">=FILA(D5:D8)</item> devuelve 5 porque la función FILA nun s'utiliza como fórmula de matriz y namái se devuelve'l númberu de la primer filera de la referencia." ], "id_hash": -3337638330205888383, "content_hash": -3337638330205888383, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153701\nhelp.text", "note": "CWNY7", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2165, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/99154896/?format=api", "priority": 100, "id": 99496666, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=51ae539f4b59a081", "url": "https://translations.documentfoundation.org/api/units/99496666/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.596709Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">{=ROW(A1:E1)}</item> and <item type=\"input\">=ROW(A1:E1)</item> both return 1 because the reference only contains row 1 as the first row in the table. (Because single-row areas only have one row number it does not make any difference whether or not the formula is used as an array formula.)" ], "previous_source": "", "target": [ "<item type=\"input\">{=FILA(A1:Y1)}</item> y <item type=\"input\">=FILA(A1:Y1)</item> devuelven 1 porque la referencia namái contién la filera 1 como la primer filera de la tabla. Por cuenta de que les árees d'una sola filera namái tienen un númberu de filera, nun hai nenguna diferencia en si la fórmula utilízase como fórmula de matriz." ], "id_hash": -2173364650780142435, "content_hash": -2173364650780142435, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150996\nhelp.text", "note": "LpXFL", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2166, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 47, "source_unit": "https://translations.documentfoundation.org/api/units/99154923/?format=api", "priority": 100, "id": 99496671, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=61d6a85d76dbd49d", "url": "https://translations.documentfoundation.org/api/units/99496671/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.602068Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=ROW()</item> returns 3 if the formula was entered in row 3." ], "previous_source": "", "target": [ "<item type=\"input\">=FILA()</item> devuelve 3 si la fórmula especificar na filera 3." ], "id_hash": -1963376887368523013, "content_hash": -1963376887368523013, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153671\nhelp.text", "note": "ABQhH", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2167, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/99154944/?format=api", "priority": 100, "id": 99496672, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=64c0af1f942fe2fb", "url": "https://translations.documentfoundation.org/api/units/99496672/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.606020Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">{=ROW(Rabbit)}</item> returns the single-column array (1, 2, 3) if \"Rabbit\" is the named area (C1:D3)." ], "previous_source": "", "target": [ "<item type=\"input\">{=FILA(Coneyu)}</item> devuelve la matriz d'una columna (1, 2, 3) si \"Coneyu\" ye l'área con nome (C1:D3)." ], "id_hash": 3342202309377560900, "content_hash": 3342202309377560900, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153790\nhelp.text", "note": "d8Kuj", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2168, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/99154951/?format=api", "priority": 100, "id": 99496678, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=ae61e34ae9f09144", "url": "https://translations.documentfoundation.org/api/units/99496678/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.611778Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>ROWS function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>Función FILES</bookmark_value>" ], "id_hash": 3782444169566703013, "content_hash": 3782444169566703013, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3145772\nhelp.text", "note": "RF4C9", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2169, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99154981/?format=api", "priority": 100, "id": 99496683, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=b47df0ee95c54da5", "url": "https://translations.documentfoundation.org/api/units/99496683/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.613946Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "ROWS" ], "previous_source": "", "target": [ "FILES" ], "id_hash": 1939762464644556811, "content_hash": 1939762464644556811, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3145772\nhelp.text", "note": "EURAZ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2170, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99155006/?format=api", "priority": 100, "id": 99496687, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=9aeb6baf2dc6680b", "url": "https://translations.documentfoundation.org/api/units/99496687/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.617800Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_ZEILEN\">Returns the number of rows in a reference or array.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_ZEILEN\">Devuelve'l númberu de fileres d'una referencia o matriz.</ahelp>" ], "id_hash": 1978530240890796127, "content_hash": 1978530240890796127, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3148971\nhelp.text", "note": "wniFN", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2171, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/99155022/?format=api", "priority": 100, "id": 99496691, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=9b7526c579a9f85f", "url": "https://translations.documentfoundation.org/api/units/99496691/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.619959Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "ROWS(Array)" ], "previous_source": "", "target": [ "FILES(Matriz)" ], "id_hash": 4290910996493570120, "content_hash": 4290910996493570120, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154357\nhelp.text", "note": "UHLW7", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2172, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99155026/?format=api", "priority": 100, "id": 99496693, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=bb8c60d12cd11048", "url": "https://translations.documentfoundation.org/api/units/99496693/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.621848Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Array</emph> is the reference or named area whose total number of rows is to be determined." ], "previous_source": "", "target": [ "<emph>Matriz</emph> ye la referencia o área con nome que'l so númberu total de fileres va determinase." ], "id_hash": -8166631567841135854, "content_hash": -8166631567841135854, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3155942\nhelp.text", "note": "SDyoR", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2173, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/99155029/?format=api", "priority": 100, "id": 99496695, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=0eaa4bdb93567312", "url": "https://translations.documentfoundation.org/api/units/99496695/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.623303Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=Rows(B5)</item> returns 1 because a cell only contains one row." ], "previous_source": "", "target": [ "<item type=\"input\">=Files(B5)</item> devuelve 1 porque una caxella contién solamente una filera." ], "id_hash": 3179259141443047493, "content_hash": 3179259141443047493, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154725\nhelp.text", "note": "vLpxF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2174, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/99155056/?format=api", "priority": 100, "id": 99496698, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=ac1eff583ea05045", "url": "https://translations.documentfoundation.org/api/units/99496698/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.625189Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=ROWS(A10:B12)</item> returns 3." ], "previous_source": "", "target": [ "<item type=\"input\">=FILES(A10:B12)</item> devuelve 3." ], "id_hash": 8726325246435246997, "content_hash": 8726325246435246997, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150102\nhelp.text", "note": "j27bq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2175, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99155102/?format=api", "priority": 100, "id": 99496701, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=f91a2293dc4bc395", "url": "https://translations.documentfoundation.org/api/units/99496701/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.627053Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=ROWS(Rabbit)</item> returns 3 if \"Rabbit\" is the named area (C1:D3)." ], "previous_source": "", "target": [ "<item type=\"input\">=FILES(Coneyu)</item> devuelve 3 si \"Coneyu\" ye l'área con nome (C1:D3)." ], "id_hash": -1013333620181692939, "content_hash": -1013333620181692939, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3155143\nhelp.text", "note": "4AmXS", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2176, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/99155254/?format=api", "priority": 100, "id": 99496704, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=71efea70fa1c0df5", "url": "https://translations.documentfoundation.org/api/units/99496704/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.628844Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>HYPERLINK function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>Función HIPERVÍNCULO</bookmark_value>" ], "id_hash": 2418601881341008658, "content_hash": 2418601881341008658, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id9959410\nhelp.text", "note": "Wncoz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2177, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99155264/?format=api", "priority": 100, "id": 99496706, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=a1909998c66c1b12", "url": "https://translations.documentfoundation.org/api/units/99496706/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.630808Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "HYPERLINK" ], "previous_source": "", "target": [ "HIPERVÍNCULO" ], "id_hash": -772613790251597624, "content_hash": -772613790251597624, "location": "04060109.xhp", "context": "04060109.xhp\npar_idN11798\nhelp.text", "note": "CDw2x", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2178, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99155266/?format=api", "priority": 100, "id": 99496708, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=75471fd9eb7c40c8", "url": "https://translations.documentfoundation.org/api/units/99496708/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.632728Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_HYPERLINK\">When you click a cell that contains the HYPERLINK function, the hyperlink opens.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_HYPERLINK\">Al faer clic nuna caxella que contién la función HIPERVÍNCULO, ábrese'l hiperenllaz.</ahelp>" ], "id_hash": 4534164272395009121, "content_hash": 4534164272395009121, "location": "04060109.xhp", "context": "04060109.xhp\npar_idN117F1\nhelp.text", "note": "GAJeF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2179, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/99155267/?format=api", "priority": 100, "id": 99496710, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=beec9661f95f3c61", "url": "https://translations.documentfoundation.org/api/units/99496710/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.634436Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "If you use the optional <emph>CellValue</emph> parameter, the formula locates the URL, and then displays the text or number." ], "previous_source": "", "target": [ "" ], "id_hash": 218980914375213094, "content_hash": 218980914375213094, "location": "04060109.xhp", "context": "04060109.xhp\npar_idN11800\nhelp.text", "note": "ciAoA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2180, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/99155268/?format=api", "priority": 100, "id": 99496714, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=8309f9fb3decc026", "url": "https://translations.documentfoundation.org/api/units/99496714/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.636536Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "To open a hyperlinked cell with the keyboard, select the cell, press F2 to enter the Edit mode, move the cursor in front of the hyperlink, press Shift+F10, and then choose <emph>Open Hyperlink</emph>." ], "previous_source": "", "target": [ "P'abrir col tecláu una caxella con hiperenllaz, escueya la caxella, calque F2 p'aportar al mou d'edición, mueva'l cursor delantre del hiperenllaz, calque Mayús + F10 y, de siguío, escueya <emph>Abrir hiperenllaz</emph>." ], "id_hash": 6220766120926062383, "content_hash": 6220766120926062383, "location": "04060109.xhp", "context": "04060109.xhp\npar_idN11803\nhelp.text", "note": "7DGBz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2181, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/99155269/?format=api", "priority": 100, "id": 99496716, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=d65499d3f495272f", "url": "https://translations.documentfoundation.org/api/units/99496716/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.638152Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "HYPERLINK(\"URL\" [; CellValue])" ], "previous_source": "", "target": [ "" ], "id_hash": -8168208340886170970, "content_hash": -8168208340886170970, "location": "04060109.xhp", "context": "04060109.xhp\npar_idN1180E\nhelp.text", "note": "YFNSo", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2182, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99155270/?format=api", "priority": 100, "id": 99496720, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=0ea4b1ca7e18d2a6", "url": "https://translations.documentfoundation.org/api/units/99496720/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.641462Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>URL</emph> specifies the link target. The optional <emph>CellValue</emph> parameter is the text or a number that is displayed in the cell and will be returned as the result. If the <emph>CellValue</emph> parameter is not specified, the <emph>URL</emph> is displayed in the cell text and will be returned as the result." ], "previous_source": "", "target": [ "" ], "id_hash": -6880188934720839068, "content_hash": -6880188934720839068, "location": "04060109.xhp", "context": "04060109.xhp\npar_idN11811\nhelp.text", "note": "weY4K", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2183, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 50, "source_unit": "https://translations.documentfoundation.org/api/units/99155271/?format=api", "priority": 100, "id": 99496722, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=2084a89dde642264", "url": "https://translations.documentfoundation.org/api/units/99496722/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.835624Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "The number 0 is returned for empty cells and matrix elements." ], "previous_source": "", "target": [ "Devuélvese'l númberu 0 pa les caxelles y los elementos de matriz baleros." ], "id_hash": 9183508396406512454, "content_hash": 9183508396406512454, "location": "04060109.xhp", "context": "04060109.xhp\npar_id0907200912224576\nhelp.text", "note": "GdBa8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2184, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/99155272/?format=api", "priority": 100, "id": 99496725, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=ff72603aefa09b46", "url": "https://translations.documentfoundation.org/api/units/99496725/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.841905Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<input>=HYPERLINK(\"http://www.example.org\")</input> displays the text \"http://www.example.org\" in the cell and executes the hyperlink http://www.example.org when clicked." ], "previous_source": "", "target": [ "" ], "id_hash": -6685719284871824382, "content_hash": -6685719284871824382, "location": "04060109.xhp", "context": "04060109.xhp\npar_idN11827\nhelp.text", "note": "frvbX", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2185, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/99155273/?format=api", "priority": 100, "id": 99496727, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=23378dbb9d3c7c02", "url": "https://translations.documentfoundation.org/api/units/99496727/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.845879Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<input>=HYPERLINK(\"http://www.example.org\";\"Click here\")</input> displays the text \"Click here\" in the cell and executes the hyperlink http://www.example.org when clicked." ], "previous_source": "", "target": [ "" ], "id_hash": 1277222501774768595, "content_hash": 1277222501774768595, "location": "04060109.xhp", "context": "04060109.xhp\npar_idN1182A\nhelp.text", "note": "wHG7A", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2186, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/99155274/?format=api", "priority": 100, "id": 99496734, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=91b99b192d6bb9d3", "url": "https://translations.documentfoundation.org/api/units/99496734/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.853683Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<input>=HYPERLINK(\"http://www.example.org\";12345)</input> displays the number 12345 and executes the hyperlink http://www.example.org when clicked." ], "previous_source": "", "target": [ "" ], "id_hash": -2085945883601083680, "content_hash": -2085945883601083680, "location": "04060109.xhp", "context": "04060109.xhp\npar_id0907200912224534\nhelp.text", "note": "jamR2", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2187, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/99155275/?format=api", "priority": 100, "id": 99496736, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=630d3b454b44e2e0", "url": "https://translations.documentfoundation.org/api/units/99496736/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.855370Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<input>=HYPERLINK($B4)</input> where cell B4 contains <literal>http://www.example.org</literal>. The function adds http://www.example.org to the URL of the hyperlink cell and returns the same text which is used as formula result." ], "previous_source": "", "target": [ "" ], "id_hash": -45593686545329457, "content_hash": -45593686545329457, "location": "04060109.xhp", "context": "04060109.xhp\npar_idN1182D\nhelp.text", "note": "qLdBN", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2188, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/99155276/?format=api", "priority": 100, "id": 99496737, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=7f5e04c89d7712cf", "url": "https://translations.documentfoundation.org/api/units/99496737/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.856784Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<input>=HYPERLINK(\"http://www.\";\"Click \") & \"example.org\"</input> displays the text Click example.org in the cell and executes the hyperlink http://www.example.org when clicked." ], "previous_source": "", "target": [ "" ], "id_hash": 2830691007777424645, "content_hash": 2830691007777424645, "location": "04060109.xhp", "context": "04060109.xhp\npar_idN11830\nhelp.text", "note": "cWDrv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2189, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/99155277/?format=api", "priority": 100, "id": 99496739, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=a748a27953774505", "url": "https://translations.documentfoundation.org/api/units/99496739/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.858158Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<input>=HYPERLINK(\"#Sheet1.A1\";\"Go to top\")</input> displays the text Go to top and jumps to cell Sheet1.A1 in this document." ], "previous_source": "", "target": [ "" ], "id_hash": 1869041006723579226, "content_hash": 1869041006723579226, "location": "04060109.xhp", "context": "04060109.xhp\npar_id8859523\nhelp.text", "note": "DDEtK", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2190, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/99155278/?format=api", "priority": 100, "id": 99496740, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=99f02ae49c65bd5a", "url": "https://translations.documentfoundation.org/api/units/99496740/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.859518Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<input>=HYPERLINK(\"file:///C:/writer.odt#Specification\";\"Go to Writer bookmark\")</input> displays the text \"Go to Writer bookmark\", loads the specified text document and jumps to bookmark \"Specification\"." ], "previous_source": "", "target": [ "" ], "id_hash": 2843765593580861418, "content_hash": 2843765593580861418, "location": "04060109.xhp", "context": "04060109.xhp\npar_id2958769\nhelp.text", "note": "CoMEq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2191, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/99155310/?format=api", "priority": 100, "id": 99496742, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=a77715bd8ddd77ea", "url": "https://translations.documentfoundation.org/api/units/99496742/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.861033Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<input>=HYPERLINK(\"file:///C:/Documents/\";\"Open Documents folder\")</input> displays the text \"Open Documents folder\" and shows the folder contents using the standard file manager in your operating system." ], "previous_source": "", "target": [ "" ], "id_hash": 1287100061349521092, "content_hash": 1287100061349521092, "location": "04060109.xhp", "context": "04060109.xhp\npar_id321615667588042\nhelp.text", "note": "Ky2xV", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2192, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/99155340/?format=api", "priority": 100, "id": 99496744, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=91dcb2afbb1f26c4", "url": "https://translations.documentfoundation.org/api/units/99496744/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.862478Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>GETPIVOTDATA function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>función GETPIVOTDATA</bookmark_value>" ], "id_hash": -946151325930625045, "content_hash": -946151325930625045, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id7682424\nhelp.text", "note": "ubKsF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2193, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99155369/?format=api", "priority": 100, "id": 99496745, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=72de9861ca23e7eb", "url": "https://translations.documentfoundation.org/api/units/99496745/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.863905Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "GETPIVOTDATA" ], "previous_source": "", "target": [ "GETPIVOTDATA" ], "id_hash": 5240299382109462377, "content_hash": 5240299382109462377, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3747062\nhelp.text", "note": "3ndfJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2194, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99155401/?format=api", "priority": 100, "id": 99496748, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=c8b9488613555f69", "url": "https://translations.documentfoundation.org/api/units/99496748/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.866035Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<ahelp hid=\".\">The GETPIVOTDATA function returns a result value from a pivot table. The value is addressed using field and item names, so it remains valid if the layout of the pivot table changes.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\".\">La función GETPIVOTDATA torna un valor de resultaos d'una tabla de Tabla dinámica. El valor ye señaláu usando'l campu y el nome de los elementos, d'esti mou permanez válidu si l'esplegue de la tabla del Tabla dinámica camuda.</ahelp>" ], "id_hash": 5187296786357012091, "content_hash": 5187296786357012091, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3593859\nhelp.text", "note": "MoLqJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2195, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/99155429/?format=api", "priority": 100, "id": 99496752, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=c7fcfaf19755c67b", "url": "https://translations.documentfoundation.org/api/units/99496752/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.870072Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Two different syntax definitions can be used:" ], "previous_source": "", "target": [ "Pue usase dos distintos definiciones na sintaxis:" ], "id_hash": -6279826677705307235, "content_hash": -6279826677705307235, "location": "04060109.xhp", "context": "04060109.xhp\npar_id909451\nhelp.text", "note": "k6kQB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2196, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/99155463/?format=api", "priority": 100, "id": 99496756, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=28d992e8985a8b9d", "url": "https://translations.documentfoundation.org/api/units/99496756/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.873697Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "GETPIVOTDATA(TargetField; pivot table[; Field 1; Item 1][; ... [Field 126; Item 126]])" ], "previous_source": "", "target": [ "" ], "id_hash": 1808508286739262810, "content_hash": 1808508286739262810, "location": "04060109.xhp", "context": "04060109.xhp\npar_id1665089\nhelp.text", "note": "V3C9Q", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2197, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/99155483/?format=api", "priority": 100, "id": 99496759, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=99191cb47471ad5a", "url": "https://translations.documentfoundation.org/api/units/99496759/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.876611Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "or" ], "previous_source": "", "target": [ "" ], "id_hash": -1930907858890907289, "content_hash": -1930907858890907289, "location": "04060109.xhp", "context": "04060109.xhp\npar_id661585662472832\nhelp.text", "note": "3kCjF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2198, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99155510/?format=api", "priority": 100, "id": 99496764, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=6534098860cc2167", "url": "https://translations.documentfoundation.org/api/units/99496764/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.997108Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "GETPIVOTDATA(pivot table; Constraints)" ], "previous_source": "", "target": [ "GETPIVOTDATA(Tabla dinámica; Restricciones)" ], "id_hash": -611817698728201602, "content_hash": -611817698728201602, "location": "04060109.xhp", "context": "04060109.xhp\npar_id4997100\nhelp.text", "note": "QnCVY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2199, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99155525/?format=api", "priority": 100, "id": 99496766, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=7782630b6802327e", "url": "https://translations.documentfoundation.org/api/units/99496766/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.998711Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "The second syntax is assumed if exactly two parameters are given, of which the first parameter is a cell or cell range reference. The first syntax is assumed in all other cases. The Function Wizard shows the first syntax." ], "previous_source": "", "target": [ "Asumir la segunda sitaxis son esactamente dos parametros que se dan, de la cual el primera parametro d'una caxella o rangu de caxella referenciada. La primer sintaxis asumir que estan n'otros casos. L'asistente pa funciones amuesa la primer sintaxis." ], "id_hash": 5193858182333926414, "content_hash": 5193858182333926414, "location": "04060109.xhp", "context": "04060109.xhp\npar_id1672109\nhelp.text", "note": "LJFgA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2200, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://translations.documentfoundation.org/api/units/99155555/?format=api", "priority": 100, "id": 99496768, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=c8144a7fa3c50c0e", "url": "https://translations.documentfoundation.org/api/units/99496768/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:43.000134Z" } ] }