Changes

HTTP 200 OK
Allow: GET, HEAD, OPTIONS
Content-Type: application/json
Vary: Accept

{
    "count": 8501,
    "next": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/changes/?format=api&page=129",
    "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/changes/?format=api&page=127",
    "results": [
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913771/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.102385Z",
            "action": 59,
            "target": "Símbol",
            "id": 37316744,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316744/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913765/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.102359Z",
            "action": 59,
            "target": "Oganessó",
            "id": 37316743,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316743/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913760/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.102333Z",
            "action": 59,
            "target": "Liti",
            "id": 37316742,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316742/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913757/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.102306Z",
            "action": 59,
            "target": "Heli",
            "id": 37316741,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316741/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913753/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.102279Z",
            "action": 59,
            "target": "Hidrogen",
            "id": 37316740,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316740/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913748/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.102250Z",
            "action": 59,
            "target": "Element",
            "id": 37316739,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316739/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913743/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.102204Z",
            "action": 59,
            "target": "",
            "id": 37316738,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316738/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913738/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.102161Z",
            "action": 59,
            "target": "Per obtenir una explicació sobre els paràmetres vegeu <link href=\"text/scalc/01/04060109.xhp#Section9\">VLOOKUP</link> (es canvien columnes i files)",
            "id": 37316737,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316737/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913735/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.102120Z",
            "action": 59,
            "target": "",
            "id": 37316736,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316736/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913729/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.102077Z",
            "action": 59,
            "target": "<ahelp hid=\"HID_FUNC_WVERWEIS\">Cerca un valor i una referència en les cel·les situades sota l'àrea seleccionada.</ahelp> Aquesta funció verifica si la primera fila d'una matriu conté un valor determinat. Tot seguit, la funció retorna el valor en una fila de la matriu, anomenada en l'<emph>Índex</emph>, en la mateixa columna.",
            "id": 37316735,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316735/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913724/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.102035Z",
            "action": 59,
            "target": "CONSULTAH",
            "id": 37316734,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316734/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913720/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.101991Z",
            "action": 59,
            "target": "<bookmark_value>funció CONSULTAH</bookmark_value>",
            "id": 37316733,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316733/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913716/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.101949Z",
            "action": 59,
            "target": "<item type=\"input\">=TRIA(A1;B1;B2;B3;\"Avui\";\"Ahir\";\"Demà\")</item>, per exemple, retorna el contingut de la cel·la B2 per a A1 = 2; per a A1 = 4, la funció retorna el text \"Avui\".",
            "id": 37316732,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316732/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913711/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.101910Z",
            "action": 59,
            "target": "<unk>GA Valor 1 Valor 2 Valor 30</emph> és la llista de valors introduïts com a referència a una cel·la o com a valors individuals.",
            "id": 37316731,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316731/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913705/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.101884Z",
            "action": 59,
            "target": "<emph>Índex</emph> és una referència o un nombre entre 1 i 30 que indica quin valor s'ha d'extreure de la llista.",
            "id": 37316730,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316730/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913701/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.101858Z",
            "action": 59,
            "target": "CHOOSE(Index; Valor 1 [; Valor 2 [; [; Valor 30<unk>)",
            "id": 37316729,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316729/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913696/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.101832Z",
            "action": 59,
            "target": "<ahelp hid=\"HID_FUNC_WAHL\">Utilitza un índex per retornar un valor d'una llista de fins a 30 valors.</ahelp>",
            "id": 37316728,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316728/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913692/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.101805Z",
            "action": 59,
            "target": "TRIA",
            "id": 37316727,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316727/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913687/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.101779Z",
            "action": 59,
            "target": "<bookmark_value>funció TRIA</bookmark_value>",
            "id": 37316726,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316726/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913680/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.101751Z",
            "action": 59,
            "target": "<item type=\"input\">=CONSULTA(A1;D1:D100;F1:F100)</item> cerca la cel·la corresponent de l'interval D1:D100 per al nombre que heu introduït a A1. Es determina l'índex de la instància que s'ha trobat; per exemple, la 12a cel·la de l'interval. Tot seguit, es retornen els continguts de la 12a cel·la com el valor de la funció (en el vector resultant).",
            "id": 37316725,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316725/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913675/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.101725Z",
            "action": 59,
            "target": "<emph>VectorResultant</emph> és un altre interval d'una sola fila o d'una sola columna d'on s'extreu el resultat de la funció. El resultat és la cel·la del vector resultant amb el mateix índex que la instància trobada en el vector de cerca.",
            "id": 37316724,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316724/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913670/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.101699Z",
            "action": 59,
            "target": "<emph>VectorDeCerca</emph> és l'àrea d'una fila o d'una columna que s'ha de cercar.",
            "id": 37316723,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316723/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913666/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.101673Z",
            "action": 59,
            "target": "",
            "id": 37316722,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316722/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913662/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.101648Z",
            "action": 59,
            "target": "",
            "id": 37316721,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316721/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913657/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.101622Z",
            "action": 59,
            "target": "Si CONSULTA no pot trobar el criteri de cerca, coincideix amb el valor més gran del vector de cerca que sigui més petit o igual que el criteri de cerca.",
            "id": 37316720,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316720/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913652/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.101595Z",
            "action": 59,
            "target": "<ahelp hid=\"HID_FUNC_VERWEIS\">Retorna els continguts d'una cel·la, ja sigui d'un interval d'una fila o d'una columna.</ahelp> Opcionalment, es retorna el valor assignat (del mateix índex) en una columna i una fila diferent. Contràriament a <link href=\"text/scalc/01/04060109.xhp#Section9\">CONSULTAV</link> i a <link href=\"text/scalc/01/04060109.xhp#Section17\">CONSULTAH</link>, el vector de cerca i el resultant es poden trobar en posicions diferents; no cal que siguin adjacents. A més, el vector de cerca de la funció CONSULTA ha d'estar ordenat de manera ascendent; si no ho està, la cerca no retornarà cap resultat utilitzable.",
            "id": 37316719,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316719/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913649/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.101569Z",
            "action": 59,
            "target": "CONSULTA",
            "id": 37316718,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316718/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913643/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.101544Z",
            "action": 59,
            "target": "<bookmark_value>funció CONSULTA</bookmark_value>",
            "id": 37316717,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316717/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913630/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.101517Z",
            "action": 59,
            "target": "Si s'hi especifiquen l'<emph>Amplada</emph> o l'<emph>Alçada</emph>, la funció DESPLAÇAMENT retorna una referència a un interval de cel·les. Si <emph>Referència</emph> és una referència a una única cel·la y s'ometen tant <emph>Amplada</emph> com <emph>Alçada</emph>, es retorna una referència a una única cel·la.",
            "id": 37316716,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316716/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913626/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.101492Z",
            "action": 59,
            "target": "<item type=\"input\">=SUMA(DESPLAÇAMENT(A1;2;2;5;6))</item> determina el total de l'àrea que comença a la cel·la C3, i que té una alçada de 5 files i una amplada de 6 columnes (àrea=C3:H7).",
            "id": 37316715,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316715/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913621/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.101467Z",
            "action": 59,
            "target": "<item type=\"input\">=DESPLAÇAMENT(B2:C3;1;0;3;4)</item> retorna una referència a B2:C3 desplaçada una fila redimensionada en 3 files i 4 columnes (B3:E5).",
            "id": 37316714,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316714/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913615/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.101441Z",
            "action": 59,
            "target": "<item type=\"input\">=DESPLAÇAMENT(B2:C3;0;0;3;4)</item> retorna una referència cap a l'interval B2:C3 redimensionada a 3 files i 4 columnes (B2:E4).",
            "id": 37316713,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316713/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913610/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.101416Z",
            "action": 59,
            "target": "<item type=\"input\">=DESPLAÇAMENT(B2:C3;-1;-1)</item> retorna una referència a B2:C3 desplaçada una fila cap amunt i una columna cap a l'esquerra (A1:B2).",
            "id": 37316712,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316712/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913605/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.101391Z",
            "action": 59,
            "target": "<item type=\"input\">=DESPLAÇAMENT(B2:C3;1;1)</item> retorna una referència a B2:C3 desplaçada 1 fila i 1 columna cap a la dreta (C3:D4).",
            "id": 37316711,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316711/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913600/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.101365Z",
            "action": 59,
            "target": "<item type=\"input\">=DESPLAÇAMENT(A1;2;2)</item> retorna el valor de la cel·la C3 (A1 desplaçada dues files i dues columnes cap avall). Si C3 conté el valor <item type=\"input\">100</item>, la funció retorna el valor 100.",
            "id": 37316710,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316710/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913597/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.101340Z",
            "action": 59,
            "target": "Els arguments <emph>Alçada</emph> i <emph>Amplada</emph> no han de conduir a zero o a un comptatge negatiu de files o de columnes.",
            "id": 37316709,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316709/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913593/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.101316Z",
            "action": 59,
            "target": "Els arguments <emph>Files</emph> i <emph>Columnes</emph> no han de conduir a zero o a un inici negatiu de fila o de columna.",
            "id": 37316708,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316708/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913588/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.101290Z",
            "action": 59,
            "target": "<emph>Amplada</emph> (opcional) és l'amplada horitzontal d'una àrea que comença en la nova posició de referència.",
            "id": 37316707,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316707/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913583/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.101264Z",
            "action": 59,
            "target": "<emph>Alçada</emph> (opcional) és l'alçada vertical d'una àrea que comença en la posició de referència nova.",
            "id": 37316706,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316706/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913577/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.101239Z",
            "action": 59,
            "target": "<emph>Files</emph> és el nombre de files amb què s'ha corregit la referència cap amunt (valor negatiu) o cap avall.",
            "id": 37316705,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316705/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913572/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.101213Z",
            "action": 59,
            "target": "<emph>Files</emph> és el nombre de files amb què s'ha corregit la referència cap amunt (valor negatiu) o cap avall.",
            "id": 37316704,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316704/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913564/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.101188Z",
            "action": 59,
            "target": "<emph>Referència</emph> és la referència a partir de la qual la funció cerca la referència nova.",
            "id": 37316703,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316703/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913560/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.101162Z",
            "action": 59,
            "target": "DESPLAÇAMENT(Referència; Files; Columnes [; Alçada [; Amplada]])",
            "id": 37316702,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316702/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913554/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.101135Z",
            "action": 59,
            "target": "<ahelp hid=\"HID_FUNC_VERSCHIEBUNG\">Retorna el valor d'un desplaçament de cel·la d'un nombre determinat de files i columnes a partir d'un punt de referència indicat.</ahelp>",
            "id": 37316701,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316701/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913548/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.101110Z",
            "action": 59,
            "target": "DESPLAÇAMENT",
            "id": 37316700,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316700/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913542/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.101085Z",
            "action": 59,
            "target": "<bookmark_value>funció DESPLAÇAMENT</bookmark_value>",
            "id": 37316699,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316699/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913539/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.101058Z",
            "action": 59,
            "target": "<item type=\"input\">=COINCIDEIX(200;D1:D100)</item> cerca el valor 200 en l'àrea D1:D100, que s'ha ordenat per la columna D. Tan bon punt es troba aquest valor, es retorna el nombre de la fila on s'ha trobat. Si es troba un valor més gran durant la cerca a la columna, es retorna el nombre de la fila anterior.",
            "id": 37316698,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316698/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913537/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.101032Z",
            "action": 59,
            "target": "",
            "id": 37316697,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316697/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913534/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.101005Z",
            "action": 59,
            "target": "Si Tipus = 0 només es troben coincidències exactes. Si el criteri de cerca es troba més d'una vegada la funció retorna l'índex del primer valor coincident. Només si Tipus = 0 podeu cercar expressions regulars (si està habilitat en opcions de càlcul) o comodins (si està habilitat en opcions de càlcul).",
            "id": 37316696,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316696/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99913529/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T23:11:25.100979Z",
            "action": 59,
            "target": "<emph>Tipus</emph> pot tenir els valors 1, 0 o -1. Si Tipus = 1 o si manca aquest paràmetre opcional, s'assumeix que la primera columna de la matriu de cerca està ordenada de manera ascendent. Si Tipus = -1 s'assumeix que la columna està ordenada de manera descendent. Això correspon a la mateixa funció del Microsoft Excel.",
            "id": 37316695,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/37316695/?format=api"
        }
    ]
}