Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-24-2/textscalc01/ca/units/?format=api&page=35
{ "count": 8439, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/units/?format=api&page=36", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/units/?format=api&page=34", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Use the Fill Cell command with random numbers (<menuitem>Sheet - Fill Cells - Fill Random Numbers</menuitem>)." ], "previous_source": "", "target": [ "Utilitzeu l'ordre Emplena les cel·les amb nombres aleatoris (<menuitem>Full ▸ Emplena les cel·les ▸ Omple amb nombres aleatoris</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": 1701, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/110967792/?format=api", "priority": 100, "id": 111758578, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=17667064b474c300", "url": "https://translations.documentfoundation.org/api/units/111758578/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.468500Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Use the RAND.NV() function for non-volatile random numbers." ], "previous_source": "", "target": [ "Utilitzeu la funció RAND.NV() per a nombres aleatoris no volàtils." ], "id_hash": 5921886428075931338, "content_hash": 5921886428075931338, "location": "04060106.xhp", "context": "04060106.xhp\npar_id41590242118383\nhelp.text", "note": "o9wUN", "flags": "", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 1702, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/110967793/?format=api", "priority": 100, "id": 111758583, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=d22ec454b1ac36ca", "url": "https://translations.documentfoundation.org/api/units/111758583/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.470830Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<item type=\"input\">=RAND()</item> returns a random number between 0 and 1." ], "previous_source": "", "target": [ "<item type=\"input\">=ALEAT()</item> retorna un nombre aleatori entre 0 i 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": 1703, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/110967794/?format=api", "priority": 100, "id": 111758587, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=241ce507e6367b6c", "url": "https://translations.documentfoundation.org/api/units/111758587/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.472623Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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": [ "<unk>GA nombres aleatoris no volàtils;entre 0 i 1</bookmarkvalue><bookmarkvalue>funció RAND.NV </bookmarkvalue>" ], "id_hash": -1850599693947502347, "content_hash": -1850599693947502347, "location": "04060106.xhp", "context": "04060106.xhp\nbm_id341590241488944\nhelp.text", "note": "CqVpJ", "flags": "", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 1704, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/110967795/?format=api", "priority": 100, "id": 111758592, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=665159621cd000f5", "url": "https://translations.documentfoundation.org/api/units/111758592/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.474626Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "RAND.NV" ], "previous_source": "", "target": [ "RAND.NV" ], "id_hash": -4039084525790842478, "content_hash": -4039084525790842478, "location": "04060106.xhp", "context": "04060106.xhp\nhd_id71590238179170\nhelp.text", "note": "q9iLd", "flags": "", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 1705, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110967796/?format=api", "priority": 100, "id": 111758599, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=47f24a061675b192", "url": "https://translations.documentfoundation.org/api/units/111758599/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.477320Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_RAND_NV\">Returns a non-volatile random number between 0 and 1.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_RAND_NV\">Retorna un nombre aleatori no volàtil entre 0 i 1.</ahelp>" ], "id_hash": 3607807541087658864, "content_hash": 3607807541087658864, "location": "04060106.xhp", "context": "04060106.xhp\npar_id101590238875834\nhelp.text", "note": "Fc2hv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1706, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/110967797/?format=api", "priority": 100, "id": 111758604, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=b21181d7f8816370", "url": "https://translations.documentfoundation.org/api/units/111758604/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.479464Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "RAND.NV()" ], "previous_source": "", "target": [ "RAND.NV()" ], "id_hash": -1508896261787100160, "content_hash": -1508896261787100160, "location": "04060106.xhp", "context": "04060106.xhp\npar_id391590238945182\nhelp.text", "note": "dchBL", "flags": "", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 1707, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110967798/?format=api", "priority": 100, "id": 111758612, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=6b0f52d82943dc00", "url": "https://translations.documentfoundation.org/api/units/111758612/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.481982Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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": 1708, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 56, "source_unit": "https://translations.documentfoundation.org/api/units/110967799/?format=api", "priority": 100, "id": 111758614, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=3bc0d7e031393110", "url": "https://translations.documentfoundation.org/api/units/111758614/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.483502Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<input>=RAND.NV()</input> returns a non-volatile random number between 0 and 1." ], "previous_source": "", "target": [ "<unk>GA =RAND.NV()</input> retorna un nombre aleatori no volàtil entre 0 i 1." ], "id_hash": 3945876814046974734, "content_hash": 3945876814046974734, "location": "04060106.xhp", "context": "04060106.xhp\npar_id191590241215013\nhelp.text", "note": "sCwno", "flags": "", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 1709, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/110967800/?format=api", "priority": 100, "id": 111758617, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=b6c2920e64b8530e", "url": "https://translations.documentfoundation.org/api/units/111758617/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.485364Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Array Functions" ], "previous_source": "", "target": [ "Funcions matricials" ], "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": 1710, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110967801/?format=api", "priority": 100, "id": 111758625, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=0a2842f856598509", "url": "https://translations.documentfoundation.org/api/units/111758625/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.487764Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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": 1711, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/110967802/?format=api", "priority": 100, "id": 111758630, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=ee7967fbe46afa9d", "url": "https://translations.documentfoundation.org/api/units/111758630/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.489663Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<variable id=\"arrayfunctit\"><link href=\"text/scalc/01/04060107.xhp\">Array Functions</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"arrayfunctit\"><link href=\"text/scalc/01/04060107.xhp\">Funcions de matriu</link></variable>" ], "id_hash": 3906596139709364550, "content_hash": 3906596139709364550, "location": "04060107.xhp", "context": "04060107.xhp\nhd_id3147273\nhelp.text", "note": "8AUFn", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1712, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/110967803/?format=api", "priority": 100, "id": 111758641, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=b637047db449f946", "url": "https://translations.documentfoundation.org/api/units/111758641/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.494262Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<variable id=\"matrixtext\">This category contains the array functions.</variable>" ], "previous_source": "", "target": [ "<variable id=\"matrixtext\">Aquesta categoria conté les funcions matricials. </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": 1713, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/110967804/?format=api", "priority": 100, "id": 111758646, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=1d65699b3b247951", "url": "https://translations.documentfoundation.org/api/units/111758646/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.496842Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "What is an Array?" ], "previous_source": "", "target": [ "Què és una matriu?" ], "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": 1714, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/110967805/?format=api", "priority": 100, "id": 111758650, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=5565c135ef20b3be", "url": "https://translations.documentfoundation.org/api/units/111758650/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.499481Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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 matriu és un interval de cel·les enllaçades que contenen valors en un full de càlcul. </variable> Un interval quadrat de 3 files i 3 columnes és una matriu 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": 1715, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/110967806/?format=api", "priority": 100, "id": 111758654, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=dba5fd4a0795e3ab", "url": "https://translations.documentfoundation.org/api/units/111758654/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.504232Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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 matriu més petita possible és una matriu de 1 x 2 o 2 x 1 amb dues cel·les adjacents." ], "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": 1716, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/110967829/?format=api", "priority": 100, "id": 111758660, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=647d173b2f39abfd", "url": "https://translations.documentfoundation.org/api/units/111758660/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.509060Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "What is an array formula?" ], "previous_source": "", "target": [ "Què és 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": 1717, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110967963/?format=api", "priority": 100, "id": 111758664, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=ea5e20dae0844635", "url": "https://translations.documentfoundation.org/api/units/111758664/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.511618Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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": [ "Una fórmula matricial és una fórmula en què s'avaluen els valors individuals d'un interval de cel·les. La diferència entre una fórmula matricial i altres tipus de fórmules és que la fórmula matricial tracta diversos valors simultàniament, en comptes de tractar-ne només un." ], "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": 1718, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 43, "source_unit": "https://translations.documentfoundation.org/api/units/110968019/?format=api", "priority": 100, "id": 111758666, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=e01fb3e9a662ef9a", "url": "https://translations.documentfoundation.org/api/units/111758666/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.513315Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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 matricial no només pot processar diferents valors, sinó que també pot retornar-ne de diferents. Els resultats d'una fórmula matricial és també una matriu." ], "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": 1719, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/110968123/?format=api", "priority": 100, "id": 111758671, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=bb042f2370fa2942", "url": "https://translations.documentfoundation.org/api/units/111758671/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.516414Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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": [ "Per multiplicar els valors a les cel·les individuals per 10 a la matriu anterior no cal aplicar una fórmula a cada cel·la o valor individual. En canvi només cal utilitzar un interval de 3 x 3 cel·les en una altra part del full de càlcul introduïu la fórmula <item type=\"input\">=10*A1C3</item> i confirmeu aquesta entrada usant la combinació de tecles <switchinline select=\"sys\"><caseinline select=\"MAC\"> XYGX</defaultinline></switchinline><emph>+ Maj + Retorn</emph>. El resultat és una matriu de 3 x 3 en la qual els valors individuals a l'interval de cel·les (A1C3) es multipliquen per un factor de 10." ], "id_hash": -6612756508864884240, "content_hash": -6612756508864884240, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3158432\nhelp.text", "note": "hFrtB", "flags": "", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 1720, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 97, "source_unit": "https://translations.documentfoundation.org/api/units/110968152/?format=api", "priority": 100, "id": 111758677, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=243ac4fdb6f4d1f0", "url": "https://translations.documentfoundation.org/api/units/111758677/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.519238Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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": [ "A més de la multiplicació, també podeu utilitzar altres operadors en l'àrea de referència (una matriu). Amb el $[officename] Calc, podeu sumar (+), restar (-), multiplicar (*), dividir (/), utilitzar exponents (^), concatenació (&) i comparacions (=, <>, <, >, <=, >=). Els operadors es poden utilitzar en cada valor individual de l'àrea de les cel·les i retornar el resultat com una matriu si s'ha introduït la fórmula matricial." ], "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": 1721, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 68, "source_unit": "https://translations.documentfoundation.org/api/units/110968470/?format=api", "priority": 100, "id": 111758685, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=43c75736f6cc62eb", "url": "https://translations.documentfoundation.org/api/units/111758685/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.523144Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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": [ "Els operadors de comparació d'una fórmula matricial tracten les cel·les buides de la mateixa manera que en una fórmula normal, és a dir, com un zero o com una cadena buida. Per exemple, si les cel·les A1 i A2 són buides, les fórmules matricials <item type=\"input\">{=A1:A2=\"\"}</item> i <item type=\"input\">{=A1:A2=0}</item> retornaran una matriu d'una columna i dues línies que contindrà CERT." ], "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": 1722, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 58, "source_unit": "https://translations.documentfoundation.org/api/units/110968478/?format=api", "priority": 100, "id": 111758692, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=953bacb87b75bd8d", "url": "https://translations.documentfoundation.org/api/units/111758692/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.526216Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "When do you use array formulas?" ], "previous_source": "", "target": [ "Quan podeu utilitzar fórmules matricials?" ], "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": 1723, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110968479/?format=api", "priority": 100, "id": 111758699, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=9cbd1159e3dba9ec", "url": "https://translations.documentfoundation.org/api/units/111758699/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.530019Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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": [ "Utilitzeu fórmules matricials si heu de repetir càlculs amb valors diferents. Si decidiu canviar el mètode de càlcul més endavant, només caldrà que actualitzeu la fórmula matricial. Per afegir una fórmula matricial, seleccioneu tot l'interval de matriu i, tot seguit, <link href=\"text/scalc/01/04060107.xhp\">feu la modificació a la fórmula matricial</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": 1724, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 50, "source_unit": "https://translations.documentfoundation.org/api/units/110968480/?format=api", "priority": 100, "id": 111758704, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=be89674b9cf091d7", "url": "https://translations.documentfoundation.org/api/units/111758704/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.532371Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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 matricials també són una opció que estalvia espai quan s'han de calcular diversos valors, ja que no consumeixen gaire memòria. A més a més, les matrius són eines essencials per fer càlculs complexos, ja que podeu incloure diversos intervals de cel·les en els càlculs. El $[officename] disposa de diverses funcions matemàtiques per a les matrius, com ara la funció MULTM per multiplicar dues matrius o la funció SUMAPRODUCTE per calcular els productes escalars de dues matrius." ], "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": 1725, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 71, "source_unit": "https://translations.documentfoundation.org/api/units/110968481/?format=api", "priority": 100, "id": 111758709, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=88a90fea3322f84b", "url": "https://translations.documentfoundation.org/api/units/111758709/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.535742Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Using Array Formulas in $[officename] Calc" ], "previous_source": "", "target": [ "Ús de fórmules matricials al $[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": 1726, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110968482/?format=api", "priority": 100, "id": 111758719, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=ec4db47a19941fb7", "url": "https://translations.documentfoundation.org/api/units/111758719/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.540559Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Implicit intersection of array formulas" ], "previous_source": "", "target": [ "Intersecció implícita de fórmules matricials" ], "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": 1727, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110968483/?format=api", "priority": 100, "id": 111758725, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=c22565bc0e0cbf7d", "url": "https://translations.documentfoundation.org/api/units/111758725/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.542838Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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": 1728, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 80, "source_unit": "https://translations.documentfoundation.org/api/units/110968507/?format=api", "priority": 100, "id": 111758729, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=8b824298aacb53fd", "url": "https://translations.documentfoundation.org/api/units/111758729/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.545149Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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": 1729, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/110968513/?format=api", "priority": 100, "id": 111758733, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=bbf3163d73e248d0", "url": "https://translations.documentfoundation.org/api/units/111758733/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.547051Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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": 1730, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/110968555/?format=api", "priority": 100, "id": 111758736, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=15038fd9690f9238", "url": "https://translations.documentfoundation.org/api/units/111758736/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.548828Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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": 1731, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/110968575/?format=api", "priority": 100, "id": 111758738, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=51d57a1264e6b153", "url": "https://translations.documentfoundation.org/api/units/111758738/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.550681Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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": 1732, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/110968618/?format=api", "priority": 100, "id": 111758744, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=8a4be2b30e089cc9", "url": "https://translations.documentfoundation.org/api/units/111758744/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.553602Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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": 1733, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/110968639/?format=api", "priority": 100, "id": 111758747, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=8f1153f6d5aaff68", "url": "https://translations.documentfoundation.org/api/units/111758747/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.556033Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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": 1734, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/110968670/?format=api", "priority": 100, "id": 111758752, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=98f45938543e690c", "url": "https://translations.documentfoundation.org/api/units/111758752/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.558237Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Creating Array Formulas" ], "previous_source": "", "target": [ "Creació de fórmules matricials" ], "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": 1735, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110968747/?format=api", "priority": 100, "id": 111758758, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=943d7cc49736d40d", "url": "https://translations.documentfoundation.org/api/units/111758758/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.561931Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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": [ "Si creeu una fórmula matricial mitjançant l'<emph>Auxiliar de funcions</emph>, heu d'activar la casella de selecció <emph>Matriu</emph> cada vegada perquè es retornin els resultats en una matriu. Si no ho feu, només es retorna el valor de la cel·la superior esquerra de la matriu que es calcula." ], "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": 1736, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 43, "source_unit": "https://translations.documentfoundation.org/api/units/110968787/?format=api", "priority": 100, "id": 111758762, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=045980d55e0ae672", "url": "https://translations.documentfoundation.org/api/units/111758762/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.564449Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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": [ "Si introduïu la fórmula de matriu directament a la cel·la heu d'utilitzar la combinació de tecles <emph>Maj + </emph><switchinline select=\"sys\"><caseinline select=\"MAC\"><caseinline select=\"MAC\"> <emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph>+ Enter</emph>en comptes de la tecla <emph>Enter</emph>. Només llavors la fórmula es convertirà en una fórmula de matriu." ], "id_hash": 2721636926122805715, "content_hash": 2721636926122805715, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3153392\nhelp.text", "note": "G9EUo", "flags": "", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 1737, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/110968815/?format=api", "priority": 100, "id": 111758767, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=a5c5325d4d22c9d3", "url": "https://translations.documentfoundation.org/api/units/111758767/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.567343Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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 matricials apareixen entre claus al $[officename] Calc. No podeu crear fórmules matricials introduint-hi les claus manualment." ], "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": 1738, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/110968860/?format=api", "priority": 100, "id": 111758776, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=80a7478fac666ea8", "url": "https://translations.documentfoundation.org/api/units/111758776/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.572294Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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": 1739, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/110968886/?format=api", "priority": 100, "id": 111758781, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=bea93a458af414b0", "url": "https://translations.documentfoundation.org/api/units/111758781/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.574459Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Using Inline Array Constants in Formulas" ], "previous_source": "", "target": [ "Ús de constants de matriu en línia en fórmules" ], "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": 1740, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110968908/?format=api", "priority": 100, "id": 111758785, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=ed9b1be0bcaf9b9b", "url": "https://translations.documentfoundation.org/api/units/111758785/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.576414Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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": [ "El Calc admet constants de matriu en línia en les fórmules. Una matriu en línia es troba entre claudàtors '{' i '}'. Els elements poden ser nombres (inclosos els negatius), una constant lògica (CERT, FALS) o una cadena literal. No es permeten les expressions no constants. Es poden introduir les matrius en una fila o en més d'una, i en una columna o en més d'una. Totes les files han de constar del mateix nombre d'elements i totes les columnes han d'estar formades pel mateix nombre d'elements." ], "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": 1741, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 74, "source_unit": "https://translations.documentfoundation.org/api/units/110968970/?format=api", "priority": 100, "id": 111758789, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=94ce1ab9e2748a0d", "url": "https://translations.documentfoundation.org/api/units/111758789/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.578265Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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": [ "El separador de columnes (que separa els elements d'una fila) i el separador de files depenen de la llengua i de la configuració regional. Però al contingut d'aquesta ajuda, s'utilitzen el punt i coma ';' i el símbol de barra vertical '|' per indicar els separadors de columnes i de files, respectivament. Per exemple, en anglès s'utilitza la coma ',' com a separador de columnes i el punt i coma ';', com a separador de files." ], "id_hash": -1130093870058358447, "content_hash": -1130093870058358447, "location": "04060107.xhp", "context": "04060107.xhp\npar_id936613\nhelp.text", "note": "CYxYN", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1742, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 64, "source_unit": "https://translations.documentfoundation.org/api/units/110969017/?format=api", "priority": 100, "id": 111758794, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=7051199cd8533951", "url": "https://translations.documentfoundation.org/api/units/111758794/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.580325Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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": [ "És possible veure i modificar el separador de files i columnes a <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>%PRODUCTNAME ▸ Preferències</emph></caseinline><defaultinline><emph>Eines ▸ Opcions</emph></defaultinline></switchinline><emph> ▸ Calc ▸ Fórmula ▸ Separadors</emph>." ], "id_hash": 8587874512318753548, "content_hash": 8587874512318753548, "location": "04060107.xhp", "context": "04060107.xhp\npar_id936615\nhelp.text", "note": "4oGDs", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1743, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/110969047/?format=api", "priority": 100, "id": 111758798, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=f72e425e5263eb0c", "url": "https://translations.documentfoundation.org/api/units/111758798/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.582495Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Arrays can not be nested." ], "previous_source": "", "target": [ "No es poden incrustar les matrius." ], "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": 1744, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110969096/?format=api", "priority": 100, "id": 111758803, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=9209fd800493f40d", "url": "https://translations.documentfoundation.org/api/units/111758803/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.586275Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<emph>Examples:</emph>" ], "previous_source": "", "target": [ "<emph>Exemples:</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": 1745, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110969114/?format=api", "priority": 100, "id": 111758807, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=22ba301afacb4821", "url": "https://translations.documentfoundation.org/api/units/111758807/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.589280Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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": 1746, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110969206/?format=api", "priority": 100, "id": 111758811, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=340ed7d70ce4e54e", "url": "https://translations.documentfoundation.org/api/units/111758811/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.591401Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "An array with one row consisting of the three numbers 1, 2, and 3." ], "previous_source": "", "target": [ "Una matriu amb una fila formada pels nombres 1, 2 i 3." ], "id_hash": 4368698498817009668, "content_hash": 4368698498817009668, "location": "04060107.xhp", "context": "04060107.xhp\npar_id8207037\nhelp.text", "note": "CcDoT", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1747, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/110969285/?format=api", "priority": 100, "id": 111758815, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=bca0bc2368c52804", "url": "https://translations.documentfoundation.org/api/units/111758815/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.593119Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "To enter this array constant, you select three cells in a row, then you type the formula <item type=\"input\">={1;2;3}</item> using the curly braces and the semicolons, then press <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + Shift + Enter</emph>." ], "previous_source": "", "target": [ "Per introduir aquesta constant de matriu seleccioneu tres cel·les seguides després escriviu la fórmula <item type=\"input\">={1;2;3}</item> usant les claus i els punts i coma després premeu <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Ordre</emph></caseinline><defaultinline><emph> Ctrl</emph></defaultinline></switchinline><emph> + Maj + Retorn</emph>." ], "id_hash": -6166838000608858977, "content_hash": -6166838000608858977, "location": "04060107.xhp", "context": "04060107.xhp\npar_id6757103\nhelp.text", "note": "WhqRD", "flags": "", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 1748, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/110969319/?format=api", "priority": 100, "id": 111758821, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=2a6afd8302542c9f", "url": "https://translations.documentfoundation.org/api/units/111758821/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.594889Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "={1;2;3|4;5;6}" ], "previous_source": "", "target": [ "={1;2;3|4;5;6}" ], "id_hash": 3378176491584765927, "content_hash": 3378176491584765927, "location": "04060107.xhp", "context": "04060107.xhp\npar_id8868068\nhelp.text", "note": "uTzcj", "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/110969353/?format=api", "priority": 100, "id": 111758825, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=aee1b19ee97c3fe7", "url": "https://translations.documentfoundation.org/api/units/111758825/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.597522Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "An array with two rows and three values in each row." ], "previous_source": "", "target": [ "Una matriu amb dues files i tres valors en cada fila." ], "id_hash": 1733505000064845412, "content_hash": 1733505000064845412, "location": "04060107.xhp", "context": "04060107.xhp\npar_id6626483\nhelp.text", "note": "cTAWF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1750, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/110969398/?format=api", "priority": 100, "id": 111758832, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=980ea59cf13a8664", "url": "https://translations.documentfoundation.org/api/units/111758832/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.599610Z" } ] }