Changes
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/components/libo_help-master/textscalc01/changes/?format=api&page=5805
{ "count": 309542, "next": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/changes/?format=api&page=5806", "previous": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/changes/?format=api&page=5804", "results": [ { "unit": "https://translations.documentfoundation.org/api/units/1538135/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:37:52.959728Z", "action": 2, "target": "<item type=\"input\">= UPPER (\\ \"Good Morning\") </item> dá BO DÍA.", "id": 1049458, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049458/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1538110/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:30:24.823475Z", "action": 2, "target": "<item type=\"input\"> = TEXT (12,34567;\"000.00\")</item> devolve o texto 012,35", "id": 1049434, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049434/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1538109/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:29:49.696379Z", "action": 2, "target": "<item type=\"input\"> = TEXT (12,34567;\". ### ##\") </item> devolve o texto 12,35", "id": 1049431, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049431/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1538102/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:29:32.428830Z", "action": 2, "target": "<item type=\"input\"> = T (\\ \"12345\") </item> dá a secuencia 12345.", "id": 1049428, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049428/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1538101/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:29:21.648270Z", "action": 2, "target": "<item type=\"input\"> = T (12345) </item> devolve unha cadea baleira.", "id": 1049425, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049425/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1538095/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:29:10.459772Z", "action": 2, "target": "<item type=\"input\"> = Suplente (\\ \"123123123\";\"3\";\"abc\"; 2) </item> dá 12312abc123.", "id": 1049422, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049422/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1538094/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:29:02.439039Z", "action": 2, "target": "<item type=\"input\"> = Suplente (\\ \"123123123\";\"3\";\"abc\") </item> dá 12abc12abc12abc.", "id": 1049419, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049419/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1538085/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:28:54.257075Z", "action": 2, "target": "<item type=\"input\">= SEARCH (54; 998.877.665.544) </item> dá 10.", "id": 1049416, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049416/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1538064/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:28:37.011489Z", "action": 2, "target": "<item type=\"input\"> LenB (\\ \"oficina\") </item> Devolve 6 (seis caracteres non DBCS cada unha composta por un byte).", "id": 1049410, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049410/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1538004/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:28:29.011626Z", "action": 2, "target": "<item type=\"input\"> = MID (\\ \"oficina\"; 2; 2) </item> dá ff.", "id": 1049407, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049407/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1537990/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:28:19.771773Z", "action": 2, "target": "<item type=\"input\">= LenB (12.345,67) </item> dá 8.", "id": 1049404, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049404/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1537989/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:28:06.419060Z", "action": 2, "target": "<item type=\"input\">= LenB (\\ \"Boa Tarde\") </item> dá 14.", "id": 1049401, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049401/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1537988/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:27:57.364788Z", "action": 2, "target": "<item type=\"input\">LenB (\\ \"oficina\") </item> Devolve 6 (seis caracteres non DBCS cada unha composta por un byte).", "id": 1049398, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049398/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1537987/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:27:47.542268Z", "action": 2, "target": "<item type=\"input\"> LenB (\\ \"中国\") </item> dá 4 (2 DBCS caracteres cada composto por 2 bytes).", "id": 1049395, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049395/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1537986/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:27:35.062187Z", "action": 2, "target": "<item type=\"input\"> LenB (\\ \"中\") </item> dá 2 (1 carácter DBCS que consiste en 2 bytes).", "id": 1049392, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049392/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1537979/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:27:21.847862Z", "action": 2, "target": "<item type=\"input\">= LEN (\\ \"Boa Tarde\") </item> dá 14.", "id": 1049389, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049389/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1537962/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:27:03.271664Z", "action": 2, "target": "<item type=\"input\">= LEFT (\\ \"saída\"; 3) </item> retorno \"out\".", "id": 1049383, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049383/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1537947/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:26:43.275688Z", "action": 2, "target": "<item type=\"input\">= FIXO (1.234.567,89; 3) </item> dá 1,234,567.890 como unha cadea de texto.", "id": 1049377, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049377/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1537939/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:26:34.232237Z", "action": 2, "target": "<item type=\"input\"> = find (76; 998.877.665.544) </item> 6 retorno.", "id": 1049374, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049374/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1537931/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:26:25.732273Z", "action": 2, "target": "<item type=\"input\"> = exacto (\\ \"microssistemas\";\"Microsystems\") </item> dá FALSE.", "id": 1049371, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049371/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1537914/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:25:48.586403Z", "action": 2, "target": "<item type=\"input\"> = decimal (\\ \"CARA\"; 16) </item> dá 64.206.", "id": 1049365, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049365/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1537898/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:25:39.388311Z", "action": 2, "target": "<item type=\"input\"> = CÓDIGO (\\ \"Hieronymus\") </item> dá 72, <item type=\"input\">= CÓDIGO (\\ \"\\ xeroglífica\") </item> retorno 104.", "id": 1049362, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049362/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1537880/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:25:12.685079Z", "action": 2, "target": "<item type=\"input\"> = BASE (255; 16; 4) </item> dá 00FF no sistema hexadecimal.", "id": 1049359, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049359/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1537878/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:25:01.286113Z", "action": 2, "target": "<item type=\"input\">= BASE (17, 2) </item> dá 10001 no sistema binario.", "id": 1049356, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049356/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1537876/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:24:53.908728Z", "action": 2, "target": "<item type=\"input\">= BASE (17; 10; 4) </item> dá 0017 no sistema decimal.", "id": 1049353, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049353/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1537842/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:24:34.625144Z", "action": 2, "target": "Cada unha das outras entradas especifica unha restrición na forma <item type =\"literal\"> O campo [Item] </item> (con carácteres literais [e]), ou soamente <item type =\"literal\"> elemento </item> se o nome do elemento é único dentro de todos os campos que se usan na táboa dinámica.", "id": 1049347, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049347/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1537807/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:23:42.538177Z", "action": 2, "target": "<item type=\"input\"> = Liñas (B5) </item> dá 1 porque unha célula contén só unha liña.", "id": 1049338, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049338/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1537800/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:23:33.489189Z", "action": 2, "target": "<item type=\"input\"> = Row () </item> dá 3, a fórmula foi inserido na liña 3.", "id": 1049335, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049335/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1537799/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:23:25.514060Z", "action": 2, "target": "<item type=\"input\"> {= Row (A1: E1)} </item> e <item type=\"input\"> = Row (A1: E1) </item> tanto voltar 1 porque o referencia contén só a liña 1 como a primeira liña na táboa. (Como as áreas de unha soa liña só ten un número de liña non fai calquera diferenza se ou non a fórmula é usada como unha fórmula de matriz.)", "id": 1049332, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049332/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1537798/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:23:05.803989Z", "action": 2, "target": "<item type=\"input\"> = Row (D5: D8) </item> dá 5 porque a función ROW non é utilizada como fórmula de matriz e só o número da primeira liña da referencia é dáda.", "id": 1049328, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049328/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1537797/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:22:56.166190Z", "action": 2, "target": "<item type=\"input\">{= Row (D5: D8)} </item> dá a matriz de columna única (5, 6, 7, 8), porque a referencia especificada contén liñas de 5 a 8.", "id": 1049324, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049324/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1537796/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:22:48.371871Z", "action": 2, "target": "<item type=\"input\"> = Row (B3) </item> dá 3 porque a referencia remite á terceira liña na táboa.", "id": 1049320, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049320/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1537795/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:22:38.509128Z", "action": 2, "target": "Se non indicar unha referencia, o número da liña da célula en que a fórmula é inserida será atopado. <item type =\"productname\">%PRODUCTNAME </item> Calc define automaticamente a referencia para a célula actual.", "id": 1049317, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049317/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1537766/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:21:55.818045Z", "action": 2, "target": "<item type=\"input\">= lookup (A1; D1: D100; F1: F100) </item> busca a célula correspondente na franxa D1: D100 ao número introducido na A1. Para o exemplo atopado, o índice é determinada, por exemplo, a cela 12 nesta gama. A continuación, o contido da cela 12 son devoltas como o valor da función (en resultado do vector).", "id": 1049311, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049311/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1537756/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:21:44.292576Z", "action": 2, "target": "<item type=\"input\"> = SUM (offset (A1; 2; 2; 5; 6)) </item> determina o total da área que comeza na cela C3 e ten unha altura de 5 liñas e un ancho de 6 columnas (área = C3: H7).", "id": 1049308, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049308/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1537755/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:21:35.406519Z", "action": 2, "target": "<item type=\"input\"> = offset (B2: C3; 1; 0; 3; 4) </item> devolve unha referencia para B2: C3 movido para abaixo por unha liña redimensionada para 3 liñas e 4 columnas (B2 : E4).", "id": 1049305, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049305/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1537754/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:21:26.898191Z", "action": 2, "target": "<item type=\"input\"> = offset (B2: C3; 0; 0; 3; 4) </item> devolve unha referencia para B2: C3 redimensionada para 3 liñas e 4 columnas (B2: E4).", "id": 1049302, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049302/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1537753/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:21:18.543843Z", "action": 2, "target": "<item type=\"input\"> = offset (B2: C3; -1; -1) </item> devolve unha referencia para B2: C3 subiu por unha liña e unha columna á esquerda (A1: B2) .", "id": 1049299, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049299/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1537752/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:21:10.286857Z", "action": 2, "target": "<item type=\"input\"> = offset (B2: C3; 1; 1) </item> devolve unha referencia para B2: C3 descendeu por unha liña e unha columna á dereita (C3: D4).", "id": 1049296, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049296/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1537751/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:21:01.020874Z", "action": 2, "target": "<item type=\"input\"> = offset (A1; 2; 2) </item> devolve o valor na célula C3 (A1 movida por dúas liñas e dúas columnas abaixo). Se C3 contén o valor <item type=\"input\">100 </item> Esta función devolve o valor 100.", "id": 1049293, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049293/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1537739/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:20:35.801052Z", "action": 2, "target": "<item type=\"input\"> = MATCHES (200; D1: D100) </item> investigación a área D1: D100, que se clasifica por columna D, para o valor 200. Así que ese valor é atinxido, o número da liña na que se atopou é dádo. Un valor máis alto se atopou durante a busca na columna, o número da liña anterior é devolto.", "id": 1049290, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049290/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1537729/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:20:26.862279Z", "action": 2, "target": "<item type=\"input\"> = Sheets (Sheet1.A1: Sheet3.G12) </item> dá 3, se Folha1, Folha2 e Folha3 existen na secuencia indicada.", "id": 1049287, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049287/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1537715/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:20:08.526047Z", "action": 2, "target": "<item type=\"input\"> = PROCV (A1; D1: E100, 2) </item>", "id": 1049281, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049281/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1537704/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:20:00.078107Z", "action": 2, "target": "<item type=\"input\"> = COLUMNAS (Rabbit) </item> retorno 2 <item type =\"literal\"> Rabbit </item> é o intervalo nomeado (C1: D3).", "id": 1049278, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049278/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1537703/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:19:37.325678Z", "action": 2, "target": "<item type=\"input\"> = COLUMNAS (A1: C5) </item> é igual a 3. A referencia está composta por tres columnas.", "id": 1049275, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049275/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1537702/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:19:25.611066Z", "action": 2, "target": "<item type=\"input\"> = COLUMNAS (B5) </item> dá 1 porque unha célula contén só unha columna.", "id": 1049272, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049272/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1537695/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:19:16.817898Z", "action": 2, "target": "<item type=\"input\"> = COLUMN () </item> dá 3, a fórmula fose inserida na columna C.", "id": 1049269, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049269/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1537694/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:19:07.718554Z", "action": 2, "target": "<item type=\"input\">{= COLUMN (B2: B7)} </item> e <item type=\"input\"> = COLUMN (B2: B7) </item> ambos dán 2 xa que o referencia contén só a columna B como a segunda columna da táboa. Como as áreas de unha única columna ten só un número de columna, non fai diferenzas se a fórmula é usada como unha fórmula de matriz.", "id": 1049266, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049266/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1537693/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:18:46.883609Z", "action": 2, "target": "<item type=\"input\"> = COLUMN (D3: G10) </item> retorno 4 porque a columna D é a cuarta columna na táboa ea función de columna non é utilizada como unha fórmula de matriz. (Neste caso, o primeiro valor da matriz é sempre usado como o resultado.)", "id": 1049263, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049263/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1537692/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/gl/?format=api", "user": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "author": "https://translations.documentfoundation.org/api/users/sophie/?format=api", "timestamp": "2020-07-14T14:18:38.114501Z", "action": 2, "target": "<item type=\"input\">= COLUMN (C3: E3) </item> é igual a 3. A columna C é a terceira columna na táboa.", "id": 1049260, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/1049260/?format=api" } ] }