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=35
{ "count": 8352, "next": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/units/?format=api&page=36", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/units/?format=api&page=34", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "RAND()" ], "previous_source": "", "target": [ "ALEATORIU( )" ], "id_hash": 2576394956774026887, "content_hash": 2576394956774026887, "location": "04060106.xhp", "context": "04060106.xhp\npar_id3164884\nhelp.text", "note": "frWts", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1701, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99135473/?format=api", "priority": 100, "id": 99494668, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=a3c13190179fae87", "url": "https://translations.documentfoundation.org/api/units/99494668/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.060801Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "This function produces a new random number each time Calc recalculates. To force Calc to recalculate manually press F9." ], "previous_source": "", "target": [ "" ], "id_hash": -7134952938802336385, "content_hash": -7134952938802336385, "location": "04060106.xhp", "context": "04060106.xhp\npar_id5092318\nhelp.text", "note": "hMfj3", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1702, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/99135504/?format=api", "priority": 100, "id": 99494673, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=1cfb8e1ad18ead7f", "url": "https://translations.documentfoundation.org/api/units/99494673/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.061985Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "To generate random numbers which never recalculate, either:" ], "previous_source": "", "target": [ "Pa xenerar númberos aleatorios que nun se recalculen, sigue unu d'estos procedimientos:" ], "id_hash": -3771036219443803368, "content_hash": -3771036219443803368, "location": "04060106.xhp", "context": "04060106.xhp\npar_id9312417\nhelp.text", "note": "HAWnR", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1703, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/99135534/?format=api", "priority": 100, "id": 99494678, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=4baa9689c8eb8b18", "url": "https://translations.documentfoundation.org/api/units/99494678/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.063152Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Copy cells each containing =RAND(), and use <menuitem>Edit - Paste Special</menuitem> (with <emph>Paste All</emph> and <emph>Formulas</emph> not marked and <emph>Numbers</emph> marked)." ], "previous_source": "", "target": [ "" ], "id_hash": -7363111822371922792, "content_hash": -7363111822371922792, "location": "04060106.xhp", "context": "04060106.xhp\npar_id451590242105253\nhelp.text", "note": "Ap4DT", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1704, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/99135563/?format=api", "priority": 100, "id": 99494681, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=19d0f8cf1a0adc98", "url": "https://translations.documentfoundation.org/api/units/99494681/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.064460Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Use the Fill Cell command with random numbers (<menuitem>Sheet - Fill Cells - Fill Random Numbers</menuitem>)." ], "previous_source": "", "target": [ "Usa l'orde Rellenar caxelles con númberos aleatorios (<menuitem>Fueya - Rellenar caxelles - Rellenar númberos aleatorios</menuitem>)" ], "id_hash": -7537213348531354880, "content_hash": -7537213348531354880, "location": "04060106.xhp", "context": "04060106.xhp\npar_id801590242114296\nhelp.text", "note": "zEFCC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1705, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/99135582/?format=api", "priority": 100, "id": 99494686, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=17667064b474c300", "url": "https://translations.documentfoundation.org/api/units/99494686/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.066138Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Use the RAND.NV() function for non-volatile random numbers." ], "previous_source": "", "target": [ "" ], "id_hash": 5921886428075931338, "content_hash": 5921886428075931338, "location": "04060106.xhp", "context": "04060106.xhp\npar_id41590242118383\nhelp.text", "note": "o9wUN", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1706, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/99135625/?format=api", "priority": 100, "id": 99494689, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=d22ec454b1ac36ca", "url": "https://translations.documentfoundation.org/api/units/99494689/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.067475Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=RAND()</item> returns a random number between 0 and 1." ], "previous_source": "", "target": [ "<item type=\"input\">=ALEATORIU()</item> da como resultáu un númberu aleatoriu ente 0 y 1." ], "id_hash": -6621165530051609748, "content_hash": -6621165530051609748, "location": "04060106.xhp", "context": "04060106.xhp\npar_id9569078\nhelp.text", "note": "BLkte", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1707, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/99135642/?format=api", "priority": 100, "id": 99494692, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=241ce507e6367b6c", "url": "https://translations.documentfoundation.org/api/units/99494692/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.068794Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>random numbers non-volatile;between 0 and 1</bookmark_value><bookmark_value>RAND.NV function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -1850599693947502347, "content_hash": -1850599693947502347, "location": "04060106.xhp", "context": "04060106.xhp\nbm_id341590241488944\nhelp.text", "note": "CqVpJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1708, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/99135707/?format=api", "priority": 100, "id": 99494697, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=665159621cd000f5", "url": "https://translations.documentfoundation.org/api/units/99494697/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.070618Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "RAND.NV" ], "previous_source": "", "target": [ "" ], "id_hash": -4039084525790842478, "content_hash": -4039084525790842478, "location": "04060106.xhp", "context": "04060106.xhp\nhd_id71590238179170\nhelp.text", "note": "q9iLd", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1709, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99135750/?format=api", "priority": 100, "id": 99494702, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=47f24a061675b192", "url": "https://translations.documentfoundation.org/api/units/99494702/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.154294Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_RAND_NV\">Returns a non-volatile random number between 0 and 1.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 3607807541087658864, "content_hash": 3607807541087658864, "location": "04060106.xhp", "context": "04060106.xhp\npar_id101590238875834\nhelp.text", "note": "Fc2hv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1710, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/99135774/?format=api", "priority": 100, "id": 99494706, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=b21181d7f8816370", "url": "https://translations.documentfoundation.org/api/units/99494706/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.163849Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "RAND.NV()" ], "previous_source": "", "target": [ "" ], "id_hash": -1508896261787100160, "content_hash": -1508896261787100160, "location": "04060106.xhp", "context": "04060106.xhp\npar_id391590238945182\nhelp.text", "note": "dchBL", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1711, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99135793/?format=api", "priority": 100, "id": 99494709, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=6b0f52d82943dc00", "url": "https://translations.documentfoundation.org/api/units/99494709/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.165188Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "This function produces a non-volatile random number on input. A non-volatile function is not recalculated at new input events. The function does not recalculate when pressing <keycode>F9</keycode>, except when the cursor is on the cell containing the function or using the <link href=\"text/scalc/01/recalculate_hard.xhp\"><menuitem>Recalculate Hard</menuitem></link> command (<keycode>Shift</keycode>+<switchinline select=\"sys\"><caseinline select=\"MAC\"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline>+<keycode>F9</keycode>). The function is recalculated when opening the file." ], "previous_source": "", "target": [ "" ], "id_hash": -4917693435190103792, "content_hash": -4917693435190103792, "location": "04060106.xhp", "context": "04060106.xhp\npar_id271590239748534\nhelp.text", "note": "7pUhN", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1712, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 56, "source_unit": "https://translations.documentfoundation.org/api/units/99135818/?format=api", "priority": 100, "id": 99494712, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=3bc0d7e031393110", "url": "https://translations.documentfoundation.org/api/units/99494712/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.166469Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<input>=RAND.NV()</input> returns a non-volatile random number between 0 and 1." ], "previous_source": "", "target": [ "" ], "id_hash": 3945876814046974734, "content_hash": 3945876814046974734, "location": "04060106.xhp", "context": "04060106.xhp\npar_id191590241215013\nhelp.text", "note": "sCwno", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1713, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/99135831/?format=api", "priority": 100, "id": 99494716, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=b6c2920e64b8530e", "url": "https://translations.documentfoundation.org/api/units/99494716/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.167851Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Array Functions" ], "previous_source": "", "target": [ "Funciones de matriz" ], "id_hash": -8491463463039040247, "content_hash": -8491463463039040247, "location": "04060107.xhp", "context": "04060107.xhp\ntit\nhelp.text", "note": "Zsp2R", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1714, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99135871/?format=api", "priority": 100, "id": 99494719, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=0a2842f856598509", "url": "https://translations.documentfoundation.org/api/units/99494719/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.169143Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>matrices; functions</bookmark_value><bookmark_value>Function Wizard; arrays</bookmark_value><bookmark_value>array formulas</bookmark_value><bookmark_value>inline array constants</bookmark_value><bookmark_value>formulas; arrays</bookmark_value><bookmark_value>functions; array functions</bookmark_value><bookmark_value>editing; array formulas</bookmark_value><bookmark_value>copying; array formulas</bookmark_value><bookmark_value>deleting; array formulas</bookmark_value><bookmark_value>adjusting array ranges</bookmark_value><bookmark_value>calculating; conditional calculations</bookmark_value><bookmark_value>matrices; calculations</bookmark_value><bookmark_value>conditional calculations with arrays</bookmark_value><bookmark_value>implicit array handling</bookmark_value><bookmark_value>forced array handling</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 7960508147920730781, "content_hash": 7960508147920730781, "location": "04060107.xhp", "context": "04060107.xhp\nbm_id3147273\nhelp.text", "note": "BB9Ze", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1715, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/99135909/?format=api", "priority": 100, "id": 99494723, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=ee7967fbe46afa9d", "url": "https://translations.documentfoundation.org/api/units/99494723/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.170845Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<variable id=\"arrayfunctit\"><link href=\"text/scalc/01/04060107.xhp\">Array Functions</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 3906596139709364550, "content_hash": 3906596139709364550, "location": "04060107.xhp", "context": "04060107.xhp\nhd_id3147273\nhelp.text", "note": "8AUFn", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1716, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99135954/?format=api", "priority": 100, "id": 99494727, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=b637047db449f946", "url": "https://translations.documentfoundation.org/api/units/99494727/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.172407Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<variable id=\"matrixtext\">This category contains the array functions.</variable>" ], "previous_source": "", "target": [ "<variable id=\"matrixtext\">Esta categoría contién les funciones de matriz. </variable>" ], "id_hash": -7105156721673995951, "content_hash": -7105156721673995951, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3154744\nhelp.text", "note": "BDGKz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1717, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/99136015/?format=api", "priority": 100, "id": 99494730, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=1d65699b3b247951", "url": "https://translations.documentfoundation.org/api/units/99494730/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.173814Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "What is an Array?" ], "previous_source": "", "target": [ "¿Qué ye una matriz?" ], "id_hash": -3069835133593799746, "content_hash": -3069835133593799746, "location": "04060107.xhp", "context": "04060107.xhp\nhd_id3146084\nhelp.text", "note": "sWmxg", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1718, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99136041/?format=api", "priority": 100, "id": 99494733, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=5565c135ef20b3be", "url": "https://translations.documentfoundation.org/api/units/99494733/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.175646Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<variable id=\"wasmatrix\">An array is a linked range of cells on a spreadsheet containing values.</variable> A square range of 3 rows and 3 columns is a 3 x 3 array:" ], "previous_source": "", "target": [ "<variable id=\"wasmatrix\">Una matriz ye una área de caxelles enllazada d'una fueya de cálculu, que les sos caxelles contienen valores. </variable> files y 3 columnes ye una matriz de 3 x 3:" ], "id_hash": 6603962923005371307, "content_hash": 6603962923005371307, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3154298\nhelp.text", "note": "kisLJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1719, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/99136066/?format=api", "priority": 100, "id": 99494737, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=dba5fd4a0795e3ab", "url": "https://translations.documentfoundation.org/api/units/99494737/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.177315Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "The smallest possible array is a 1 x 2 or 2 x 1 array with two adjacent cells." ], "previous_source": "", "target": [ "La mínima matriz posible son dos caxelles axacentes, 1 x 2 o 2 x 1." ], "id_hash": -1982402718010332163, "content_hash": -1982402718010332163, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3153583\nhelp.text", "note": "NYW8Q", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1720, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/99136094/?format=api", "priority": 100, "id": 99494741, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=647d173b2f39abfd", "url": "https://translations.documentfoundation.org/api/units/99494741/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.179373Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "What is an array formula?" ], "previous_source": "", "target": [ "¿Qué ye una fórmula matricial?" ], "id_hash": 7664599740272887349, "content_hash": 7664599740272887349, "location": "04060107.xhp", "context": "04060107.xhp\nhd_id3148474\nhelp.text", "note": "9rqkN", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1721, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/99136123/?format=api", "priority": 100, "id": 99494745, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=ea5e20dae0844635", "url": "https://translations.documentfoundation.org/api/units/99494745/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.181541Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "A formula in which the individual values in a cell range are evaluated is referred to as an array formula. The difference between an array formula and other formulas is that the array formula deals with several values simultaneously instead of just one." ], "previous_source": "", "target": [ "Denominar fórmula de matriz la que dexa evaluar los valores individuales d'una área de caxelles. La diferencia ente una fórmula de matriz y otru tipu de fórmula ye qu'aquélla nun emplega un únicu valor, sinón dellos valores simultáneamente." ], "id_hash": 6926452568019365786, "content_hash": 6926452568019365786, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3155355\nhelp.text", "note": "EBQsz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1722, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 43, "source_unit": "https://translations.documentfoundation.org/api/units/99136150/?format=api", "priority": 100, "id": 99494749, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=e01fb3e9a662ef9a", "url": "https://translations.documentfoundation.org/api/units/99494749/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.183011Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Not only can an array formula process several values, but it can also return several values. The results of an array formula is also an array." ], "previous_source": "", "target": [ "Una fórmula de matriz non yá pue procesar dellos valores, sinón tamién devolver delles resultancies. La resultancia d'una fórmula de matriz tamién ye una matriz." ], "id_hash": 4252575777410394434, "content_hash": 4252575777410394434, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3151052\nhelp.text", "note": "UMVaF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1723, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/99136189/?format=api", "priority": 100, "id": 99494754, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=bb042f2370fa2942", "url": "https://translations.documentfoundation.org/api/units/99494754/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.291316Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "To multiply the values in the individual cells by 10 in the above array, you do not need to apply a formula to each individual cell or value. Instead you just need to use a single array formula. Select a range of 3 x 3 cells on another part of the spreadsheet, enter the formula <item type=\"input\">=10*A1:C3</item> and confirm this entry using the key combination <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + Shift + Enter</emph>. The result is a 3 x 3 array in which the individual values in the cell range (A1:C3) are multiplied by a factor of 10." ], "previous_source": "", "target": [ "" ], "id_hash": -6612756508864884240, "content_hash": -6612756508864884240, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3158432\nhelp.text", "note": "hFrtB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1724, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 97, "source_unit": "https://translations.documentfoundation.org/api/units/99136226/?format=api", "priority": 100, "id": 99494761, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=243ac4fdb6f4d1f0", "url": "https://translations.documentfoundation.org/api/units/99494761/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.295579Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "In addition to multiplication, you can also use other operators on the reference range (an array). With $[officename] Calc, you can add (+), subtract (-), multiply (*), divide (/), use exponents (^), concatenation (&) and comparisons (=, <>, <, >, <=, >=). The operators can be used on each individual value in the cell range and return the result as an array if the array formula was entered." ], "previous_source": "", "target": [ "Puen utilizase otru operadores, amás de la multiplicación, nel área (matriz) de referencia. $[officename] Calc dexa sumar (+), restar (-), multiplicar (*), estremar (/), alzar a potencies (^), concatenar (&) y comparar (=, <>, <, >, <=, >=). Los operadores puen utilizase en cada unu de los valores individuales del área de caxelles; devuelven la resultancia en forma de matriz, si la fórmula escribióse como fórmula de matriz." ], "id_hash": -4339403822367743253, "content_hash": -4339403822367743253, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3149156\nhelp.text", "note": "8NCA2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1725, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 68, "source_unit": "https://translations.documentfoundation.org/api/units/99136303/?format=api", "priority": 100, "id": 99494769, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=43c75736f6cc62eb", "url": "https://translations.documentfoundation.org/api/units/99494769/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.300159Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Comparison operators in an array formula treat empty cells in the same way as in a normal formula, that is, either as zero or as an empty string. For example, if cells A1 and A2 are empty the array formulas <item type=\"input\">{=A1:A2=\"\"}</item> and <item type=\"input\">{=A1:A2=0}</item> will both return a 1 column 2 row array of cells containing TRUE." ], "previous_source": "", "target": [ "Comparancia d'operadores nuna formula natriz trata les caxelles baleres del mesmu mou que nuna formula normal, eso ye, tantu como cero o como una cadena balera. Por exemplu, si les caxelles A1 y A2 tán baleres en formular <item type=\"input\">{=A1:A2=\"\"}</item> y <item type=\"input\">{=A1:A2=0}</item> dambes tornen 1 columan 2 files de matriz y caxelles conteniendo VERDADERU." ], "id_hash": 1530006406767689101, "content_hash": 1530006406767689101, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3166456\nhelp.text", "note": "eFkfc", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1726, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 58, "source_unit": "https://translations.documentfoundation.org/api/units/99136317/?format=api", "priority": 100, "id": 99494775, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=953bacb87b75bd8d", "url": "https://translations.documentfoundation.org/api/units/99494775/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.302624Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "When do you use array formulas?" ], "previous_source": "", "target": [ "¿Cuándo se deben utilizar fórmules de matriz?" ], "id_hash": 2070830481432881644, "content_hash": 2070830481432881644, "location": "04060107.xhp", "context": "04060107.xhp\nhd_id3150713\nhelp.text", "note": "rDSKx", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1727, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/99136393/?format=api", "priority": 100, "id": 99494779, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=9cbd1159e3dba9ec", "url": "https://translations.documentfoundation.org/api/units/99494779/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.304956Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Use array formulas if you have to repeat calculations using different values. If you decide to change the calculation method later, you only have to update the array formula. To add an array formula, select the entire array range and then <link href=\"text/scalc/01/04060107.xhp\">make the required change to the array formula</link>." ], "previous_source": "", "target": [ "Utilice fórmules de matriz si tien de repitir los mesmos cálculos con valores distintos. Si más palantre decide camudar el métodu de cálculu, namái tendrá de modificar la fórmula de matriz. P'amestar una fórmula de matriz, escueya tola matriz y <link href=\"text/scalc/01/04060107.xhp\">faiga los cambeos necesarios na fórmula</link>." ], "id_hash": 4506246476614111703, "content_hash": 4506246476614111703, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3149787\nhelp.text", "note": "iQ9Nx", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1728, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 50, "source_unit": "https://translations.documentfoundation.org/api/units/99136442/?format=api", "priority": 100, "id": 99494786, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=be89674b9cf091d7", "url": "https://translations.documentfoundation.org/api/units/99494786/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.306662Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Array formulas are also a space saving option when several values must be calculated, since they are not very memory-intensive. In addition, arrays are an essential tool for carrying out complex calculations, because you can have several cell ranges included in your calculations. $[officename] has different math functions for arrays, such as the MMULT function for multiplying two arrays or the SUMPRODUCT function for calculating the scalar products of two arrays." ], "previous_source": "", "target": [ "Les fórmules de matriz representen un aforru d'espaciu cuando se deben calcular munchos valores, yá que utilicen una cantidá amenorgada de memoria. Coles mesmes, les matrices son una ferramienta fundamental pa llevar a cabo cálculu complexos, yá que dexen incluyir delles árees de caxelles nos cálculos. $[officename] dispon de diverses funciones matemátiques pa matrices, como la función MMULT pa multiplicar dos matrices o SUMA.PRODUCTU pa calcular el productu escalar de dos matrices." ], "id_hash": 624047521922218059, "content_hash": 624047521922218059, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3149798\nhelp.text", "note": "vRLSR", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1729, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 71, "source_unit": "https://translations.documentfoundation.org/api/units/99136480/?format=api", "priority": 100, "id": 99494790, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=88a90fea3322f84b", "url": "https://translations.documentfoundation.org/api/units/99494790/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.308876Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Using Array Formulas in $[officename] Calc" ], "previous_source": "", "target": [ "Usu de fórmules matriciales en $[officename] Calc" ], "id_hash": 7804092165811085239, "content_hash": 7804092165811085239, "location": "04060107.xhp", "context": "04060107.xhp\nhd_id3155588\nhelp.text", "note": "BU7BQ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1730, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/99136513/?format=api", "priority": 100, "id": 99494796, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=ec4db47a19941fb7", "url": "https://translations.documentfoundation.org/api/units/99494796/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.311141Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Implicit intersection of array formulas" ], "previous_source": "", "target": [ "Interseición implícita de fórmules matriciales" ], "id_hash": 4766327639005511549, "content_hash": 4766327639005511549, "location": "04060107.xhp", "context": "04060107.xhp\nhd_id651668200191409\nhelp.text", "note": "NJc9B", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1731, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/99136544/?format=api", "priority": 100, "id": 99494800, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=c22565bc0e0cbf7d", "url": "https://translations.documentfoundation.org/api/units/99494800/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.312799Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "You can also create a \"normal\" formula in which the reference range, such as parameters, indicate an array formula. This formula is also known as \"implicit intersection\" of array formula. The result is obtained from the intersection of the reference range and the rows or columns in which the formula is found. If there is no intersection or if the range at the intersection covers several rows or columns, a #VALUE! error message appears. The following example illustrates this concept:" ], "previous_source": "", "target": [ "" ], "id_hash": 829298504857506813, "content_hash": 829298504857506813, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3152876\nhelp.text", "note": "M2BM4", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1732, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 80, "source_unit": "https://translations.documentfoundation.org/api/units/99136574/?format=api", "priority": 100, "id": 99494803, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=8b824298aacb53fd", "url": "https://translations.documentfoundation.org/api/units/99494803/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.314505Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "In the table above, place the array formula in D1:" ], "previous_source": "", "target": [ "" ], "id_hash": 4319820920771463376, "content_hash": 4319820920771463376, "location": "04060107.xhp", "context": "04060107.xhp\npar_id631668200233375\nhelp.text", "note": "Et4mZ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1733, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/99136602/?format=api", "priority": 100, "id": 99494807, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=bbf3163d73e248d0", "url": "https://translations.documentfoundation.org/api/units/99494807/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.316093Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Cells D1, D2, D3 have values 107, 195, 105 respectively." ], "previous_source": "", "target": [ "" ], "id_hash": -7709159973194853832, "content_hash": -7709159973194853832, "location": "04060107.xhp", "context": "04060107.xhp\npar_id641668200266239\nhelp.text", "note": "Fb5iF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1734, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/99136641/?format=api", "priority": 100, "id": 99494810, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=15038fd9690f9238", "url": "https://translations.documentfoundation.org/api/units/99494810/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.317573Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Insert the formula below in E2, do not enter as array formula." ], "previous_source": "", "target": [ "" ], "id_hash": -3326618530322402989, "content_hash": -3326618530322402989, "location": "04060107.xhp", "context": "04060107.xhp\npar_id231668200272420\nhelp.text", "note": "EpsqN", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1735, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/99136685/?format=api", "priority": 100, "id": 99494814, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=51d57a1264e6b153", "url": "https://translations.documentfoundation.org/api/units/99494814/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.318999Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Cells E1 and E3 are empty, Cell E2 has value 195. This is the implicit intersection of array formulas." ], "previous_source": "", "target": [ "" ], "id_hash": 741935822295047369, "content_hash": 741935822295047369, "location": "04060107.xhp", "context": "04060107.xhp\npar_id681668200283910\nhelp.text", "note": "PhpAa", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1736, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/99136727/?format=api", "priority": 100, "id": 99494816, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=8a4be2b30e089cc9", "url": "https://translations.documentfoundation.org/api/units/99494816/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.320412Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Insert formula below in E4, as in E2." ], "previous_source": "", "target": [ "" ], "id_hash": 1085741304784813928, "content_hash": 1085741304784813928, "location": "04060107.xhp", "context": "04060107.xhp\npar_id161668200288651\nhelp.text", "note": "KdBwt", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1737, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/99136745/?format=api", "priority": 100, "id": 99494818, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=8f1153f6d5aaff68", "url": "https://translations.documentfoundation.org/api/units/99494818/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.322203Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Cell E4 display #VALUE!. Row 4 is out of the range A1:A3 of the formula." ], "previous_source": "", "target": [ "" ], "id_hash": 1798160249694087436, "content_hash": 1798160249694087436, "location": "04060107.xhp", "context": "04060107.xhp\npar_id711668200299613\nhelp.text", "note": "G8xZf", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1738, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/99136786/?format=api", "priority": 100, "id": 99494822, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=98f45938543e690c", "url": "https://translations.documentfoundation.org/api/units/99494822/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.324148Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Creating Array Formulas" ], "previous_source": "", "target": [ "Crear fórmules matriciales" ], "id_hash": 1458459038130295821, "content_hash": 1458459038130295821, "location": "04060107.xhp", "context": "04060107.xhp\nhd_id3151271\nhelp.text", "note": "EcJu6", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1739, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99136827/?format=api", "priority": 100, "id": 99494825, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=943d7cc49736d40d", "url": "https://translations.documentfoundation.org/api/units/99494825/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.325679Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "If you create an array formula using the <emph>Function Wizard</emph>, you must mark the <emph>Array</emph> check box each time so that the results are returned in an array. Otherwise, only the value in the upper-left cell of the array being calculated is returned." ], "previous_source": "", "target": [ "Pa crear una fórmula de matriz por aciu el <emph>Asistente pa funciones</emph>, tendrá d'escoyer el caxellu de verificación <emph>Matriz</emph> por que les resultancies devolver nuna matriz. En casu contrariu, namái se va devolver el valor correspondiente a la caxella cimera esquierda de la matriz." ], "id_hash": -8909948733881653646, "content_hash": -8909948733881653646, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3149102\nhelp.text", "note": "keWKE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1740, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 43, "source_unit": "https://translations.documentfoundation.org/api/units/99136874/?format=api", "priority": 100, "id": 99494829, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=045980d55e0ae672", "url": "https://translations.documentfoundation.org/api/units/99494829/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.327469Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "If you enter the array formula directly into the cell, you must use the key combination <emph>Shift + </emph><switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + Enter</emph> instead of the <emph>Enter</emph> key. Only then does the formula become an array formula." ], "previous_source": "", "target": [ "" ], "id_hash": 2721636926122805715, "content_hash": 2721636926122805715, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3153392\nhelp.text", "note": "G9EUo", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1741, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/99136923/?format=api", "priority": 100, "id": 99494834, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=a5c5325d4d22c9d3", "url": "https://translations.documentfoundation.org/api/units/99494834/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.332768Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Array formulas appear in braces in $[officename] Calc. You cannot create array formulas by manually entering the braces." ], "previous_source": "", "target": [ "Les fórmules de matriz amosar en $[officename] Calc ente llaves. Nun ye posible crear fórmules de matriz escribiendo les llaves manualmente." ], "id_hash": 47085003508969128, "content_hash": 47085003508969128, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3151120\nhelp.text", "note": "iGmCa", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1742, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/99137009/?format=api", "priority": 100, "id": 99494839, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=80a7478fac666ea8", "url": "https://translations.documentfoundation.org/api/units/99494839/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.334224Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "The cells in a results array are automatically protected against changes. However, you can edit, delete or copy the array formula by selecting the entire array cell range." ], "previous_source": "", "target": [ "" ], "id_hash": 4515204171774039216, "content_hash": 4515204171774039216, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3154342\nhelp.text", "note": "6zGAy", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1743, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/99137048/?format=api", "priority": 100, "id": 99494860, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=bea93a458af414b0", "url": "https://translations.documentfoundation.org/api/units/99494860/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.599793Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Using Inline Array Constants in Formulas" ], "previous_source": "", "target": [ "Utilizando Constantes de Matrices En llinia en Formules" ], "id_hash": 7897937023576546203, "content_hash": 7897937023576546203, "location": "04060107.xhp", "context": "04060107.xhp\nhd_id8834803\nhelp.text", "note": "2tDZj", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1744, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/99137095/?format=api", "priority": 100, "id": 99494867, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=ed9b1be0bcaf9b9b", "url": "https://translations.documentfoundation.org/api/units/99494867/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.602019Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Calc supports inline matrix/array constants in formulas. An inline array is surrounded by curly braces '{' and '}'. Elements can be each a number (including negatives), a logical constant (TRUE, FALSE), or a literal string. Non-constant expressions are not allowed. Arrays can be entered with one or more rows, and one or more columns. All rows must consist of the same number of elements, all columns must consist of the same number of elements." ], "previous_source": "", "target": [ "Calc sofita constantes de matrices en llinia en formules. Un matriz en llinia ye arrodiáu por llaves, '{' y '}'. Los elementos pue ser caúna un númberu (inclusive negativos), una constante lóxica (TRUE, FALSE), o una cadena lliteral. Espresiones non-constantes nun tán dexáu. Los matrices pue ser entrada nuna ó más files, y una ó más columnes. Toles fileres tien que tener igual númberu d'elementos, toes columnes debe consista de la mesma númberu d'elementos." ], "id_hash": 1499165111631514125, "content_hash": 1499165111631514125, "location": "04060107.xhp", "context": "04060107.xhp\npar_id985747\nhelp.text", "note": "fuAHa", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1745, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 74, "source_unit": "https://translations.documentfoundation.org/api/units/99137140/?format=api", "priority": 100, "id": 99494872, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=94ce1ab9e2748a0d", "url": "https://translations.documentfoundation.org/api/units/99494872/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.603969Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "The column separator (separating elements in one row) and the row separator are language and locale dependent. But in this help content, the ';' semicolon and '|' pipe symbol are used to indicate the column and row separators, respectively. For example, in the English locale, the ',' comma is used as the column separator, while the ';' semicolon is used as the row separator." ], "previous_source": "", "target": [ "" ], "id_hash": -1130093870058358447, "content_hash": -1130093870058358447, "location": "04060107.xhp", "context": "04060107.xhp\npar_id936613\nhelp.text", "note": "CYxYN", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1746, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 64, "source_unit": "https://translations.documentfoundation.org/api/units/99137201/?format=api", "priority": 100, "id": 99494878, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=7051199cd8533951", "url": "https://translations.documentfoundation.org/api/units/99494878/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.606393Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "You can view and change the row and column separator in <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - Calc - Formula - Separators</emph>." ], "previous_source": "", "target": [ "" ], "id_hash": 8587874512318753548, "content_hash": 8587874512318753548, "location": "04060107.xhp", "context": "04060107.xhp\npar_id936615\nhelp.text", "note": "4oGDs", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1747, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/99137246/?format=api", "priority": 100, "id": 99494884, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=f72e425e5263eb0c", "url": "https://translations.documentfoundation.org/api/units/99494884/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.608098Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Arrays can not be nested." ], "previous_source": "", "target": [ "Les matrices nun puen tar añeraes." ], "id_hash": 1299848693747545101, "content_hash": 1299848693747545101, "location": "04060107.xhp", "context": "04060107.xhp\npar_id1877498\nhelp.text", "note": "pseAZ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1748, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/99137284/?format=api", "priority": 100, "id": 99494890, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=9209fd800493f40d", "url": "https://translations.documentfoundation.org/api/units/99494890/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.609787Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Examples:</emph>" ], "previous_source": "", "target": [ "<emph>Exemplu:</emph>" ], "id_hash": -6721006601462134751, "content_hash": -6721006601462134751, "location": "04060107.xhp", "context": "04060107.xhp\npar_id4262520\nhelp.text", "note": "frzGa", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1749, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99137345/?format=api", "priority": 100, "id": 99494896, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=22ba301afacb4821", "url": "https://translations.documentfoundation.org/api/units/99494896/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.611508Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "={1;2;3}" ], "previous_source": "", "target": [ "={1;2;3}" ], "id_hash": -5472199178574305970, "content_hash": -5472199178574305970, "location": "04060107.xhp", "context": "04060107.xhp\npar_id9387493\nhelp.text", "note": "Adzmh", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1750, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99137384/?format=api", "priority": 100, "id": 99494902, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=340ed7d70ce4e54e", "url": "https://translations.documentfoundation.org/api/units/99494902/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:37.613567Z" } ] }