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=37
{ "count": 8439, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/units/?format=api&page=38", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/units/?format=api&page=36", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Select a square range within the spreadsheet, for example, from A1 to E5." ], "previous_source": "", "target": [ "Seleccioneu un interval quadrat en el full de càlcul; per exemple, d'A1 a E5." ], "id_hash": 4995572374736268346, "content_hash": 4995572374736268346, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3150949\nhelp.text", "note": "UQDNX", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1801, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/110970715/?format=api", "priority": 100, "id": 111759079, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=c553d69b6de8ec3a", "url": "https://translations.documentfoundation.org/api/units/111759079/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.711086Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Without deselecting the range, select the MUNIT function. Mark the <emph>Array</emph> check box. Enter the desired dimensions for the array unit, in this case <item type=\"input\">5</item>, and click <emph>OK</emph>." ], "previous_source": "", "target": [ "Sense desseleccionar l'interval, seleccioneu la funció MUNIT. Activeu la casella de selecció <emph>Matriu</emph>. Introduïu les dimensions de la unitat de matriu, en aquest cas <item type=\"input\">5</item>, i feu clic a <emph>D'acord</emph>." ], "id_hash": 148286346009985841, "content_hash": 148286346009985841, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3151260\nhelp.text", "note": "YABET", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1802, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/110970724/?format=api", "priority": 100, "id": 111759085, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=820ed1a562f74331", "url": "https://translations.documentfoundation.org/api/units/111759085/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.713040Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "You can also enter the <item type=\"input\">=MUNIT(5)</item> formula in the last cell of the selected range (E5), and press <switchinline select=\"sys\"><caseinline select=\"MAC\"><item type=\"keycode\">Shift + Command + Enter</item></caseinline><defaultinline><item type=\"keycode\">Shift + Ctrl + Enter</item></defaultinline></switchinline>." ], "previous_source": "", "target": [ "També podeu introduir la fórmula <item type=\"input\">=BUIT(5)</item> en l'última cel·la de l'interval seleccionat (E5) i prémer <switchinline select=\"sys\"><caseinline select=\"MAC\"><item type=\"keycode\">Maj + Ordre +</item></caseinline><defaultinline><item type=\"keycode\">Maj + Ctrl +</item></defaultinline></switchinline> ." ], "id_hash": 5950655144809398805, "content_hash": 5950655144809398805, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3150403\nhelp.text", "note": "yywEQ", "flags": "", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 1803, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/110970737/?format=api", "priority": 100, "id": 111759089, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=d294f95387370215", "url": "https://translations.documentfoundation.org/api/units/111759089/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.715665Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "You now see a unit array with a range of A1:E5." ], "previous_source": "", "target": [ "Es mostra una matriu unitària amb l'interval A1:E5." ], "id_hash": 4452572060584765420, "content_hash": 4452572060584765420, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3156143\nhelp.text", "note": "gB9Be", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1804, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/110970742/?format=api", "priority": 100, "id": 111759094, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=bdcab6b2c7fbe7ec", "url": "https://translations.documentfoundation.org/api/units/111759094/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.718338Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<bookmark_value>FREQUENCY function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>funció FREQUENCIA</bookmark_value>" ], "id_hash": 8142432594890535510, "content_hash": 8142432594890535510, "location": "04060107.xhp", "context": "04060107.xhp\nbm_id3159084\nhelp.text", "note": "Gf6DP", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1805, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110970750/?format=api", "priority": 100, "id": 111759100, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=f0ffbb4dfa033256", "url": "https://translations.documentfoundation.org/api/units/111759100/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.720544Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "FREQUENCY" ], "previous_source": "", "target": [ "FREQUENCIA" ], "id_hash": -710275675019728560, "content_hash": -710275675019728560, "location": "04060107.xhp", "context": "04060107.xhp\nhd_id3159084\nhelp.text", "note": "z7DBb", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1806, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110970761/?format=api", "priority": 100, "id": 111759103, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=7624980969d92950", "url": "https://translations.documentfoundation.org/api/units/111759103/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.722364Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_HAEUFIGKEIT\">Indicates the frequency distribution in a one-column-array.</ahelp> The function counts the number of values in the <emph>Data</emph> array that are within the values given by the <emph>Classes</emph> array." ], "previous_source": "", "target": [ "<unk>GA Indica la distribució de freqüències en una taula d'una columna.</ahelp> La funció compta el nombre de valors en la matriu <emph>Data</emph> que estan dins dels valors donats per la matriu <emph>Classes</emph>." ], "id_hash": -6647354263480438571, "content_hash": -6647354263480438571, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3145777\nhelp.text", "note": "CgxiG", "flags": "", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 1807, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/110970762/?format=api", "priority": 100, "id": 111759107, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=23bfda843d11f0d5", "url": "https://translations.documentfoundation.org/api/units/111759107/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.723952Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "FREQUENCY(Data; Classes)" ], "previous_source": "", "target": [ "FREQUENCIA(Dades; Classes)" ], "id_hash": 1095757615970668888, "content_hash": 1095757615970668888, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3155498\nhelp.text", "note": "NFDXK", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1808, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110970763/?format=api", "priority": 100, "id": 111759111, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=8f34e9bf03dc5158", "url": "https://translations.documentfoundation.org/api/units/111759111/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.726622Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<emph>Data</emph> represents the reference to the values to be counted." ], "previous_source": "", "target": [ "<emph>Dades</emph> representa la referència cap als valors que s'han de comptar." ], "id_hash": -6333398160981785226, "content_hash": -6333398160981785226, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3154352\nhelp.text", "note": "NCyy5", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1809, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/110970764/?format=api", "priority": 100, "id": 111759115, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=281b3feda9918576", "url": "https://translations.documentfoundation.org/api/units/111759115/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.728983Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<emph>Classes</emph> represents the array of the limit values." ], "previous_source": "", "target": [ "<emph>Classes</emph> representa la matriu dels valors límit." ], "id_hash": -8208174206377725218, "content_hash": -8208174206377725218, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3148402\nhelp.text", "note": "b3WxQ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1810, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/110970788/?format=api", "priority": 100, "id": 111759121, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=0e16b50c4e54f2de", "url": "https://translations.documentfoundation.org/api/units/111759121/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.731692Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "You can find a general introduction to Array functions at the top of this page." ], "previous_source": "", "target": [ "Trobareu una introducció general a les funcions matricials a la part superior d'aquesta pàgina." ], "id_hash": 6526065144972771671, "content_hash": 6526065144972771671, "location": "04060107.xhp", "context": "04060107.xhp\npar_idN10D71\nhelp.text", "note": "Wew2J", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1811, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/110970831/?format=api", "priority": 100, "id": 111759127, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=da913dac3b290157", "url": "https://translations.documentfoundation.org/api/units/111759127/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.733379Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "In the following table, column A lists unsorted measurement values. Column B contains the upper limit you entered for the classes into which you want to divide the data in column A. According to the limit entered in B1, the FREQUENCY function returns the number of measured values less than or equal to 5. As the limit in B2 is 10, the FREQUENCY function returns the second result as the number of measured values that are greater than 5 and less than or equal to 10. The text you entered in B6, \">25\", is only for reference purposes." ], "previous_source": "", "target": [ "A la taula següent, la columna A mostra valors de mesura sense ordenar. La columna B conté el límit superior que heu introduït per a les classes en què voleu dividir les dades de la columna A. En funció del límit que hàgiu introduït a B1, la funció FREQUENCIA retorna el nombre de valors mesurats que són més petits o iguals que 5. Com que el límit de B2 és 10, la funció FREQUENCIA retorna el segon resultat com el nombre de valors mesurats que són majors de 5 i menors o iguals a 10. El text que heu introduït a B6, \">25\", només s'utilitza com a referència." ], "id_hash": -4762112679162973017, "content_hash": -4762112679162973017, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3155904\nhelp.text", "note": "h7yjC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1812, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 98, "source_unit": "https://translations.documentfoundation.org/api/units/110970854/?format=api", "priority": 100, "id": 111759132, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=3de993bfc21b74a7", "url": "https://translations.documentfoundation.org/api/units/111759132/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.735623Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Select a single column range in which to enter the frequency according to the class limits. You must select one field more than the class ceiling. In this example, select the range C1:C6. Call up the FREQUENCY function in the <emph>Function Wizard</emph>. Select the <emph>Data</emph> range in (A1:A11), and then the <emph>Classes</emph> range in which you entered the class limits (B1:B6). Select the <emph>Array</emph> check box and click <emph>OK</emph>. You will see the frequency count in the range C1:C6." ], "previous_source": "", "target": [ "Seleccioneu un interval, en una sola columna, on s'introduirà la freqüència en funció dels límits de classe. Heu de seleccionar un camp més que el camp superior de la classe. En aquest exemple, seleccioneu l'interval C1:C6. Activeu la funció FREQUENCIA des de l'<emph>Auxiliar de funcions</emph>. Seleccioneu l'interval <emph>Dades</emph> a (A1:A11) i, tot seguit, seleccioneu l'interval <emph>Classes</emph> en el qual hàgiu introduït els límits de classe (B1:B6). Activeu la casella de selecció <emph>Matriu</emph> i feu clic a <emph>D'acord</emph>. Apareixerà el comptatge de la freqüència en l'interval C1:C6." ], "id_hash": -3352523897385939758, "content_hash": -3352523897385939758, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3150312\nhelp.text", "note": "tVPA4", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1813, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 79, "source_unit": "https://translations.documentfoundation.org/api/units/110970903/?format=api", "priority": 100, "id": 111759143, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=517971471b4d8cd2", "url": "https://translations.documentfoundation.org/api/units/111759143/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.739212Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<bookmark_value>MDETERM function</bookmark_value><bookmark_value>determinants</bookmark_value>" ], "previous_source": "", "target": [ "funció MDETERM <bookmarkvalue>determinantS</bookmarkvalue><bookmarkvalue></bookmarkvalue>" ], "id_hash": 1585903397263469851, "content_hash": 1585903397263469851, "location": "04060107.xhp", "context": "04060107.xhp\nbm_id3151030\nhelp.text", "note": "shMJG", "flags": "", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 1814, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110970918/?format=api", "priority": 100, "id": 111759152, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=960242bcc1f96d1b", "url": "https://translations.documentfoundation.org/api/units/111759152/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.742030Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "MDETERM" ], "previous_source": "", "target": [ "DETERMM" ], "id_hash": -2445687314194589761, "content_hash": -2445687314194589761, "location": "04060107.xhp", "context": "04060107.xhp\nhd_id3151030\nhelp.text", "note": "vg6ML", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1815, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110970957/?format=api", "priority": 100, "id": 111759158, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=5e0f2c5875c097bf", "url": "https://translations.documentfoundation.org/api/units/111759158/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.744789Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_MDET\">Returns the array determinant of an array.</ahelp> This function returns a value in the current cell; it is not necessary to define a range for the results." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_MDET\">Retorna la matriu determinant d'una matriu.</ahelp> Aquesta funció retorna un valor en la cel·la actual; no cal definir una àrea per als resultats." ], "id_hash": 8974652980787548357, "content_hash": 8974652980787548357, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3154073\nhelp.text", "note": "KPSAt", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1816, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/110970999/?format=api", "priority": 100, "id": 111759163, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=fc8c5f56163e10c5", "url": "https://translations.documentfoundation.org/api/units/111759163/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.746717Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "MDETERM(Array)" ], "previous_source": "", "target": [ "DETERMM(Matriu)" ], "id_hash": -583566507205215409, "content_hash": -583566507205215409, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3156380\nhelp.text", "note": "Zahsu", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1817, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110971037/?format=api", "priority": 100, "id": 111759168, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=77e6c15a8337bb4f", "url": "https://translations.documentfoundation.org/api/units/111759168/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.749208Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<emph>Array</emph> represents a square array in which the determinants are defined." ], "previous_source": "", "target": [ "<emph>Matriu</emph> representa una matriu quadrada en la qual es defineixen els determinants." ], "id_hash": 4694972610548389703, "content_hash": 4694972610548389703, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3150290\nhelp.text", "note": "GEptz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1818, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/110971062/?format=api", "priority": 100, "id": 111759174, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=c127e4b6d9ecd747", "url": "https://translations.documentfoundation.org/api/units/111759174/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.751172Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "You can find a general introduction to using Array functions on top of this page." ], "previous_source": "", "target": [ "Trobareu una introducció general a l'ús de les funcions matricials a la part superior d'aquesta pàgina." ], "id_hash": -371856835586357134, "content_hash": -371856835586357134, "location": "04060107.xhp", "context": "04060107.xhp\npar_idN11635\nhelp.text", "note": "MbKkA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1819, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/110971072/?format=api", "priority": 100, "id": 111759177, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=7ad6e62d9f930872", "url": "https://translations.documentfoundation.org/api/units/111759177/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.753061Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<bookmark_value>MINVERSE function</bookmark_value><bookmark_value>inverse arrays</bookmark_value>" ], "previous_source": "", "target": [ "Funció <bookmarkvalue>MINVERSE</bookmarkvalue><bookmarkvalue>matrius inverses </bookmarkvalue>" ], "id_hash": 8110889270787779914, "content_hash": 8110889270787779914, "location": "04060107.xhp", "context": "04060107.xhp\nbm_id3151348\nhelp.text", "note": "y56Lm", "flags": "", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 1820, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110971088/?format=api", "priority": 100, "id": 111759181, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=f08faad185d52d4a", "url": "https://translations.documentfoundation.org/api/units/111759181/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.755728Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "MINVERSE" ], "previous_source": "", "target": [ "MINVERSA" ], "id_hash": 6842765923517752215, "content_hash": 6842765923517752215, "location": "04060107.xhp", "context": "04060107.xhp\nhd_id3151348\nhelp.text", "note": "xTHGA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1821, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110971107/?format=api", "priority": 100, "id": 111759186, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=def6635a586c6397", "url": "https://translations.documentfoundation.org/api/units/111759186/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.758426Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_MINV\">Returns the inverse array.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_MINV\">Retorna la matriu inversa.</ahelp>" ], "id_hash": 8865420723181032812, "content_hash": 8865420723181032812, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3145569\nhelp.text", "note": "mnbtj", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1822, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110971132/?format=api", "priority": 100, "id": 111759193, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=fb084d2d3d97956c", "url": "https://translations.documentfoundation.org/api/units/111759193/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.763459Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "MINVERSE(Array)" ], "previous_source": "", "target": [ "MINVERSA(Matriu)" ], "id_hash": -7242856928532995719, "content_hash": -7242856928532995719, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3156085\nhelp.text", "note": "A3Hyn", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1823, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110971215/?format=api", "priority": 100, "id": 111759196, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=1b7c33ff6fd06179", "url": "https://translations.documentfoundation.org/api/units/111759196/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.765542Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<emph>Array</emph> represents a square array that is to be inverted." ], "previous_source": "", "target": [ "<emph>Matriu</emph> representa una matriu quadrada que s'ha d'invertir." ], "id_hash": 3365850788233071950, "content_hash": 3365850788233071950, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3157849\nhelp.text", "note": "ajEGo", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1824, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/110971257/?format=api", "priority": 100, "id": 111759209, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=aeb5e7757799cd4e", "url": "https://translations.documentfoundation.org/api/units/111759209/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.772057Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Select a square range and select MINVERSE. Select the output array, select the <emph>Array</emph> field and click <emph>OK</emph>." ], "previous_source": "", "target": [ "Seleccioneu un interval quadrat i trieu MINVERSA. Seleccioneu la matriu obtinguda, seleccioneu el camp <emph>Matriu</emph> i feu clic a <emph>D'acord</emph>." ], "id_hash": -2596689228904447608, "content_hash": -2596689228904447608, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3149638\nhelp.text", "note": "YgTJD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1825, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/110971267/?format=api", "priority": 100, "id": 111759213, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=5bf6b4e777114188", "url": "https://translations.documentfoundation.org/api/units/111759213/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.774015Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<bookmark_value>MMULT function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>funció MULTM</bookmark_value>" ], "id_hash": -7220892740750655627, "content_hash": -7220892740750655627, "location": "04060107.xhp", "context": "04060107.xhp\nbm_id3148546\nhelp.text", "note": "c2Z39", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1826, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110971268/?format=api", "priority": 100, "id": 111759218, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=1bca3c4f6a5c3f75", "url": "https://translations.documentfoundation.org/api/units/111759218/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.775841Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "MMULT" ], "previous_source": "", "target": [ "MULTM" ], "id_hash": 5716176331420781543, "content_hash": 5716176331420781543, "location": "04060107.xhp", "context": "04060107.xhp\nhd_id3148546\nhelp.text", "note": "cvame", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1827, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110971269/?format=api", "priority": 100, "id": 111759221, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=cf53f0167bd4cbe7", "url": "https://translations.documentfoundation.org/api/units/111759221/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.777446Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_MMULT\">Calculates the array product of two arrays.</ahelp> The number of columns for array 1 must match the number of rows for array 2. The square array has an equal number of rows and columns." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_MMULT\">Calcula el producte de dues matrius.</ahelp> El nombre de columnes de la matriu 1 ha de coincidir amb el nombre de files de la matriu 2. La matriu quadrada té el mateix nombre de files i de columnes." ], "id_hash": 3860570566369463632, "content_hash": 3860570566369463632, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3148518\nhelp.text", "note": "mWLDh", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1828, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/110971296/?format=api", "priority": 100, "id": 111759225, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=b5938079d6c7cd50", "url": "https://translations.documentfoundation.org/api/units/111759225/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.779144Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "MMULT(Array 1; Array 2)" ], "previous_source": "", "target": [ "MMULT(Matriu 1; Matriu 2)" ], "id_hash": 6657565538323348128, "content_hash": 6657565538323348128, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3150798\nhelp.text", "note": "JUTAD", "flags": "", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 1829, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/110971344/?format=api", "priority": 100, "id": 111759233, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=dc646c9574a53aa0", "url": "https://translations.documentfoundation.org/api/units/111759233/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.781479Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<emph>Array 1</emph> represents the first array used in the array product." ], "previous_source": "", "target": [ "Matriu <emph>1</emph> representa la primera matriu utilitzada en el producte de matriu." ], "id_hash": 8801872775390109445, "content_hash": 8801872775390109445, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3150812\nhelp.text", "note": "DqghH", "flags": "", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 1830, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/110971398/?format=api", "priority": 100, "id": 111759237, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=fa2688a7a74f1f05", "url": "https://translations.documentfoundation.org/api/units/111759237/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.783361Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<emph>Array 2</emph> represents the second array with the same number of rows." ], "previous_source": "", "target": [ "Matriu <emph>2</emph> representa la segona matriu amb el mateix nombre de files." ], "id_hash": -4103538142168824319, "content_hash": -4103538142168824319, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3152553\nhelp.text", "note": "FDfwg", "flags": "", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 1831, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/110971406/?format=api", "priority": 100, "id": 111759241, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=470d4dcd19c2c601", "url": "https://translations.documentfoundation.org/api/units/111759241/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.785255Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Select a square range. Choose the MMULT function. Select <emph>Array 1</emph>, then select <emph>Array 2</emph>. Using the <emph>Function Wizard</emph>, mark the <emph>Array</emph> check box. Click <emph>OK</emph>. The output array will appear in the first selected range." ], "previous_source": "", "target": [ "Seleccioneu un interval quadrat. Trieu la funció MMULT. Seleccioneu Matriu <emph>1</emph> després seleccioneu Matriu <emph>2</emph>. Utilitzant la casella de selecció</emph> de l'Auxiliar de funcions <emph>activeu la casella de selecció Matriu <emph>. Feu clic a <emph>OK</emph>. La matriu de sortida apareixerà al primer interval seleccionat." ], "id_hash": 7423099569750159916, "content_hash": 7423099569750159916, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3146826\nhelp.text", "note": "CuGxm", "flags": "", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 1832, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/110971409/?format=api", "priority": 100, "id": 111759249, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=e70425babb50322c", "url": "https://translations.documentfoundation.org/api/units/111759249/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.793044Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<bookmark_value>TRANSPOSE function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>funció TRANSPOSA</bookmark_value>" ], "id_hash": -8562216521522707766, "content_hash": -8562216521522707766, "location": "04060107.xhp", "context": "04060107.xhp\nbm_id3154970\nhelp.text", "note": "vPBWq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1833, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110971469/?format=api", "priority": 100, "id": 111759258, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=092ce57030a882ca", "url": "https://translations.documentfoundation.org/api/units/111759258/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.796229Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "TRANSPOSE" ], "previous_source": "", "target": [ "TRANSPOSA" ], "id_hash": -9059069159958823443, "content_hash": -9059069159958823443, "location": "04060107.xhp", "context": "04060107.xhp\nhd_id3154970\nhelp.text", "note": "5Tcfr", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1834, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110971474/?format=api", "priority": 100, "id": 111759263, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=0247b89894f53ded", "url": "https://translations.documentfoundation.org/api/units/111759263/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.798304Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_MTRANS\">Transposes the rows and columns of an array.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_MTRANS\">Transposa les files i les columnes d'una matriu.</ahelp>" ], "id_hash": 1205755394283778475, "content_hash": 1205755394283778475, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3155276\nhelp.text", "note": "DQZoL", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1835, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/110971514/?format=api", "priority": 100, "id": 111759269, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=90bbb4248a4bb1ab", "url": "https://translations.documentfoundation.org/api/units/111759269/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.800644Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "TRANSPOSE(Array)" ], "previous_source": "", "target": [ "TRANSPOSA(Matriu)" ], "id_hash": 8912536025662324048, "content_hash": 8912536025662324048, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3153843\nhelp.text", "note": "yX4Fn", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1836, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110971535/?format=api", "priority": 100, "id": 111759273, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=fbafb04b71797d50", "url": "https://translations.documentfoundation.org/api/units/111759273/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.858786Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<emph>Array</emph> represents the array in the spreadsheet that is to be transposed." ], "previous_source": "", "target": [ "<emph>Matriu</emph> representa la matriu del full de càlcul que s'ha de transposar." ], "id_hash": 7453167012197632144, "content_hash": 7453167012197632144, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3153857\nhelp.text", "note": "FHbAX", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1837, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/110971562/?format=api", "priority": 100, "id": 111759277, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=e76ef7e8b5b30890", "url": "https://translations.documentfoundation.org/api/units/111759277/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.862237Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "You can find a general introduction to using Array functions on top of this page." ], "previous_source": "", "target": [ "Trobareu una introducció general a l'ús de les funcions matricials a la part superior d'aquesta pàgina." ], "id_hash": 1648868859262944956, "content_hash": 1648868859262944956, "location": "04060107.xhp", "context": "04060107.xhp\npar_idN11035\nhelp.text", "note": "eBkbU", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1838, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/110971582/?format=api", "priority": 100, "id": 111759280, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=96e1f57dcd9246bc", "url": "https://translations.documentfoundation.org/api/units/111759280/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.864878Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "In the spreadsheet, select the range in which the transposed array can appear. If the original array has n rows and m columns, your selected range must have at least m rows and n columns. Then enter the formula directly, select the original array and press <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Shift + Command + Enter</emph></caseinline><defaultinline><emph>Shift + Ctrl + Enter</emph></defaultinline></switchinline>. Or, if you are using the <emph>Function Wizard</emph>, mark the <emph>Array</emph> check box. The transposed array appears in the selected target range and is protected automatically against changes." ], "previous_source": "", "target": [ "Al full de càlcul seleccioneu l'interval en què pot aparèixer la matriu transposada. Si la matriu original té n files i m columnes l'interval seleccionat ha de tenir com a mínim m files i n columnes. A continuació introduïu la fórmula directament seleccioneu la matriu original i premeu <switchinline select=\"sys\"></emph></emph>XYGD<defaultinline></switchinline> . O si utilitzeu la casella de selecció <emph></defaultinline></emph> XYGN. La matriu transposada apareix a l'interval de destinació seleccionat i està protegida automàticament contra els canvis." ], "id_hash": -2644686900828749544, "content_hash": -2644686900828749544, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3159366\nhelp.text", "note": "TdFfe", "flags": "", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 1839, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 85, "source_unit": "https://translations.documentfoundation.org/api/units/110971605/?format=api", "priority": 100, "id": 111759284, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=5b4c2f469df94118", "url": "https://translations.documentfoundation.org/api/units/111759284/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.867457Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "The above table is 2 rows, 4 columns. In order to transpose it, you must select 4 rows, 2 columns. Assuming you want to transpose the above table to the range A7:B10 (4 rows, 2 columns) you must select the entire range and then enter the following:" ], "previous_source": "", "target": [ "La taula de dalt és 2 files 4 columnes. Per tal de transposar-la heu de seleccionar 4 files 2 columnes. Suposant que vulgueu transposar la taula de dalt a l'interval A7B10 (4 files 2 columnes) haureu de seleccionar tot l'interval i a continuació introduir el següent" ], "id_hash": -4076377293153858736, "content_hash": -4076377293153858736, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3168518\nhelp.text", "note": "3oHh6", "flags": "", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 1840, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 47, "source_unit": "https://translations.documentfoundation.org/api/units/110971662/?format=api", "priority": 100, "id": 111759291, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=476dcc730f188b50", "url": "https://translations.documentfoundation.org/api/units/111759291/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.871007Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "TRANSPOSE(A1:D2)" ], "previous_source": "", "target": [ "TRANSPOSA(A1:D2)" ], "id_hash": -5093802787855449029, "content_hash": -5093802787855449029, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3166145\nhelp.text", "note": "FVsQ9", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1841, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110971689/?format=api", "priority": 100, "id": 111759297, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=394f2d5a41fb443b", "url": "https://translations.documentfoundation.org/api/units/111759297/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.873664Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Then <emph>make sure to enter it as matrix formula with </emph><switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Shift + Command + Enter</emph></caseinline><defaultinline><emph>Shift + Ctrl + Enter</emph></defaultinline></switchinline>. The result will be as follows:" ], "previous_source": "", "target": [ "Llavors <emph>assegura't d'introduir-lo com a fórmula matricial amb </emph><switchinline select=\"sys\"><caseinline select=\"MAC\"><caseinline select=\"MAC\"> <emph>Maj + Command + Enter</emph></caseinline><defaultinline><emph>Maj + Ctrl + ENter</emph></defaultinline></switchinline>. El resultat serà el següent" ], "id_hash": -3633348049108799986, "content_hash": -3633348049108799986, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3178518\nhelp.text", "note": "EaoXz", "flags": "", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 1842, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/110971716/?format=api", "priority": 100, "id": 111759300, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=4d93c1331b82ee0e", "url": "https://translations.documentfoundation.org/api/units/111759300/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.875496Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<bookmark_value>LINEST function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>funció ESTLIN</bookmark_value>" ], "id_hash": 2094836678207242220, "content_hash": 2094836678207242220, "location": "04060107.xhp", "context": "04060107.xhp\nbm_id3109846\nhelp.text", "note": "CGWog", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1843, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110971744/?format=api", "priority": 100, "id": 111759305, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=9d125adc23007fec", "url": "https://translations.documentfoundation.org/api/units/111759305/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.878088Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "LINEST" ], "previous_source": "", "target": [ "ESTLIN" ], "id_hash": 2950296115947186308, "content_hash": 2950296115947186308, "location": "04060107.xhp", "context": "04060107.xhp\nhd_id3109846\nhelp.text", "note": "KKgvt", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1844, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110971779/?format=api", "priority": 100, "id": 111759310, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=a8f18eafa53f2884", "url": "https://translations.documentfoundation.org/api/units/111759310/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.880756Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_RGP\">Returns a table of statistics for a straight line that best fits a data set.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_RGP\">Retorna una taula d'estadístiques per a la línia recta que encaixa millor amb el grup de dades.</ahelp>" ], "id_hash": 522958529102162779, "content_hash": 522958529102162779, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3144733\nhelp.text", "note": "GECEu", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1845, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/110971808/?format=api", "priority": 100, "id": 111759315, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=8741ec02ef652b5b", "url": "https://translations.documentfoundation.org/api/units/111759315/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.883717Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "LINEST(data_Y [; data_X [; linearType [; stats]]])" ], "previous_source": "", "target": [ "ESTLIN(dataY [; dataX [; linealType [; estadístiques<unk>)" ], "id_hash": -8727105688685488250, "content_hash": -8727105688685488250, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3152839\nhelp.text", "note": "7YFEn", "flags": "", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 1846, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/110971818/?format=api", "priority": 100, "id": 111759321, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=06e3179d449c5786", "url": "https://translations.documentfoundation.org/api/units/111759321/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.885688Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<emph>data_Y</emph> is a single row or column range specifying the y coordinates in a set of data points." ], "previous_source": "", "target": [ "<emph>Dades_Y</emph> és una sola fila o un interval de columnes que indica les coordenades y en un conjunt de punts de dades." ], "id_hash": 4954147987989488301, "content_hash": 4954147987989488301, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3152853\nhelp.text", "note": "M2QFp", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1847, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/110971829/?format=api", "priority": 100, "id": 111759326, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=c4c0ab58ccd462ad", "url": "https://translations.documentfoundation.org/api/units/111759326/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.887683Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<emph>data_X</emph> is a corresponding single row or column range specifying the x coordinates. If <emph>data_X</emph> is omitted it defaults to <item type=\"literal\">1, 2, 3, ..., n</item>. If there is more than one set of variables <emph>data_X</emph> may be a range with corresponding multiple rows or columns." ], "previous_source": "", "target": [ "<emph>Dades_X</emph> és una fila única o un interval de columnes corresponent que especifica les coordenades x. Si s'omet <emph>Dades_X</emph>, es prendrà <item type=\"literal\">1, 2, 3, ..., n</item> per defecte. Si hi ha més d'un conjunt de variables, <emph>Dades_X</emph> pot ser un interval amb files o columnes múltiples corresponents." ], "id_hash": 4032295208113418981, "content_hash": 4032295208113418981, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3154428\nhelp.text", "note": "pKKLj", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1848, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 46, "source_unit": "https://translations.documentfoundation.org/api/units/110971839/?format=api", "priority": 100, "id": 111759335, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=b7f59720b51c32e5", "url": "https://translations.documentfoundation.org/api/units/111759335/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.890087Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "LINEST finds a straight line <item type=\"literal\">y = a + bx</item> that best fits the data, using linear regression (the \"least squares\" method). With more than one set of variables the straight line is of the form <item type=\"literal\">y = a + b1x1 + b2x2 ... + bnxn</item>." ], "previous_source": "", "target": [ "ESTLIN cerca la línia recta <item type=\"literal\">y = a + bx</item> que encaixi millor amb les dades mitjançant la regressió lineal (el mètode dels mínims quadrats). Si hi ha més d'un conjunt de variables, la línia recta serà <item type=\"literal\">y = a + b1x1 + b2x2 ... + bnxn</item>." ], "id_hash": -120599993402932320, "content_hash": -120599993402932320, "location": "04060107.xhp", "context": "04060107.xhp\npar_id0811200804502119\nhelp.text", "note": "BWBpx", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1849, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 48, "source_unit": "https://translations.documentfoundation.org/api/units/110971840/?format=api", "priority": 100, "id": 111759341, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=7e538af1e94dc3a0", "url": "https://translations.documentfoundation.org/api/units/111759341/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.892517Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "If <emph>linearType</emph> is FALSE the straight line found is forced to pass through the origin (the constant a is zero; y = bx). If omitted, <emph>linearType</emph> defaults to TRUE (the line is not forced through the origin)." ], "previous_source": "", "target": [ "Si <emph>linearType</emph> és FALS la línia recta trobada es força a passar a través de l'origen (la constant a és zero; y = bx). Si s'omet <emph>linealType</emph> per defecte és CERT (la línia no es força a través de l'origen)." ], "id_hash": -3333308165750642180, "content_hash": -3333308165750642180, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3154448\nhelp.text", "note": "VG9J7", "flags": "", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 1850, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/110971898/?format=api", "priority": 100, "id": 111759352, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=51bdb5e2458629fc", "url": "https://translations.documentfoundation.org/api/units/111759352/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:15.896410Z" } ] }