Changes
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/changes/?format=api&page=131
{ "count": 8598, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/changes/?format=api&page=132", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/changes/?format=api&page=130", "results": [ { "unit": "https://translations.documentfoundation.org/api/units/111760928/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.687109Z", "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": 49518552, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518552/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760923/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.687087Z", "action": 59, "target": "<emph>MatriuDeCerca</emph> és la referència que se cerca. Una matriu de cerca pot constar d'una sola fila o columna, o bé pot formar part d'una sola fila o columna.", "id": 49518551, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518551/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760919/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.687063Z", "action": 59, "target": "", "id": 49518550, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518550/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760918/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.687041Z", "action": 59, "target": "", "id": 49518549, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518549/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760913/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.687019Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_VERGLEICH\">Retorna la posició relativa d'un element contingut en una matriu que coincideixi amb un valor determinat.</ahelp> La funció retorna la posició del valor que s'ha trobat en la matriu_de_cerca en forma de nombre.", "id": 49518548, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518548/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760909/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.686996Z", "action": 59, "target": "COINCIDEIX", "id": 49518547, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518547/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760904/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.686973Z", "action": 59, "target": "<bookmark_value>funció COINCIDEIX</bookmark_value>", "id": 49518546, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518546/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760902/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.686950Z", "action": 59, "target": "<item type=\"input\">=FULLS(Full1.A1:Full3.G12)</item> retorna 3 si el Full1, el Full2 i el Full3 existeixen en la seqüència indicada.", "id": 49518545, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518545/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760897/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.686928Z", "action": 59, "target": "<emph>Referència</emph> és la referència a un full o a una àrea. Aquest paràmetre és opcional.", "id": 49518544, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518544/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760894/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.686906Z", "action": 59, "target": "SHEETS([Referència])", "id": 49518543, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518543/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760891/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.686883Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_TABELLEN\">Determina el nombre de fulls d'una referència.</ahelp> Si no introduïu cap paràmetre, retorna el nombre de fulls del document actual.", "id": 49518542, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518542/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760889/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.686860Z", "action": 59, "target": "FULLS", "id": 49518541, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518541/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760887/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.686838Z", "action": 59, "target": "<bookmark_value>número de fulls; funció</bookmark_value><bookmark_value>funció FULLS</bookmark_value>", "id": 49518540, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518540/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760886/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.686815Z", "action": 59, "target": "", "id": 49518539, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518539/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760884/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.686791Z", "action": 59, "target": "", "id": 49518538, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518538/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760880/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.686760Z", "action": 59, "target": "<emph>Referència</emph> és opcional i és la referència a una cel·la, a una àrea o a una cadena de nom de full.", "id": 49518537, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518537/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760876/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.686720Z", "action": 59, "target": "FULL([Referència])", "id": 49518536, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518536/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760873/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.686676Z", "action": 59, "target": "", "id": 49518535, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518535/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760868/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.686646Z", "action": 59, "target": "FULL", "id": 49518534, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518534/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760863/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.686624Z", "action": 59, "target": "<bookmark_value>números de full; cerca</bookmark_value><bookmark_value>funció FULL</bookmark_value>", "id": 49518533, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518533/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760856/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.686601Z", "action": 59, "target": "Tan bon punt introduïu un nombre a A1, B1 mostrarà el text corresponent que apareix a la segona columna de la referència D1:E100. Si introduïu un nombre que no existeix, apareixerà el text del nombre inferior següent. Per evitar que això passi, introduïu FALS com a últim paràmetre de la fórmula perquè es generi un missatge d'error quan s'introdueixi un nombre no existent.", "id": 49518532, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518532/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760852/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.686578Z", "action": 59, "target": "<item type=\"input\">=CONSULTAV(A1;D1:E100;2)</item>", "id": 49518531, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518531/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760847/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.686556Z", "action": 59, "target": "Introduïu la fórmula següent a B1:", "id": 49518530, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518530/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760842/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.686534Z", "action": 59, "target": "Voleu introduir el nombre d'un plat al menú a la cel·la A1 i el nom del plat apareixerà com a text a la cel·la veïna (B1) immediatament. L'assignació Nombre a nom està continguda a la matriu D1E100. D1 conté <item type=\"input\">100</item> E1 conté el nom <item type=\"input\">Vegetable Sopa</item> i així successivament per a 100 elements del menú. Els números a la columna D s'ordenen en ordre ascendent; per tant el paràmetre <item type=\"literal\">opcional Ordenat</item> no és necessari.", "id": 49518529, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518529/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760839/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.686511Z", "action": 59, "target": "", "id": 49518528, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518528/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760835/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.686489Z", "action": 59, "target": "<emph>Índex</emph> és el número de la columna de la matriu que conté el valor que s'ha de retornar. La primera columna té el número 1.", "id": 49518527, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518527/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760832/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.686466Z", "action": 59, "target": "<unk>GA Array</emph> és la referència que ha de comprendre almenys tantes columnes com el nombre passat a l'argument Index.", "id": 49518526, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518526/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760830/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.686444Z", "action": 59, "target": "", "id": 49518525, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518525/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760827/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.686422Z", "action": 59, "target": "", "id": 49518524, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518524/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760823/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.686400Z", "action": 59, "target": "", "id": 49518523, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518523/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760821/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.686377Z", "action": 59, "target": "CONSULTAV", "id": 49518522, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518522/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760817/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.686355Z", "action": 59, "target": "<bookmark_value>funció de cerca vertical</bookmark_value><bookmark_value>funció CONSULTAV</bookmark_value>", "id": 49518521, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518521/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760812/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.686332Z", "action": 59, "target": "<item type=\"input\">=COLUMNES(Conill)</item> retorna 2 si <item type=\"literal\">Conill</item> és l'interval anomenat (C1:D3).", "id": 49518520, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518520/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760807/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.686304Z", "action": 59, "target": "<item type=\"input\">=COLUMNES(A1:C5)</item> és igual a 3. La referència comprèn tres columnes.", "id": 49518519, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518519/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760801/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.686266Z", "action": 59, "target": "<item type=\"input\">=COLUMNES(B5)</item> retorna 1 perquè una cel·la només conté una columna.", "id": 49518518, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518518/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760774/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.686228Z", "action": 59, "target": "<emph>Matriu</emph> és la referència d'un interval de cel·les el nombre total de columnes del qual cal trobar. L'argument pot ser una única cel·la.", "id": 49518517, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518517/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760767/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.686189Z", "action": 59, "target": "COLUMNES(Matriu)", "id": 49518516, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518516/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760763/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.686158Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_SPALTEN\">Retorna el nombre de columnes de la referència determinada.</ahelp>", "id": 49518515, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518515/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760753/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.686134Z", "action": 59, "target": "COLUMNES", "id": 49518514, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518514/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760749/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.686112Z", "action": 59, "target": "<bookmark_value>funció COLUMNES</bookmark_value>", "id": 49518513, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518513/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760744/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.686091Z", "action": 59, "target": "<item type=\"input\">{=COLUMNA(Conill)}</item> retorna la matriu d'una sola fila (3, 4) si \"Conill\" és l'àrea anomenada (C1:D3).", "id": 49518512, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518512/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760740/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.686069Z", "action": 59, "target": "<item type=\"input\">=COLUMNA()</item> retorna 3 si s'ha introduït la fórmula a la columna C.", "id": 49518511, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518511/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760735/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.686047Z", "action": 59, "target": "<item type=\"input\">{=COLUMNA(B2:B7)}</item> i <item type=\"input\">=COLUMNA(B2:B7)</item> retornen 2 perquè la referència només conté la columna B com la segona columna de la taula. Atès que les àrees d'una sola columna només tenen un número de columna, és indiferent si la fórmula s'utilitza com a fórmula matricial o no.", "id": 49518510, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518510/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760730/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.686025Z", "action": 59, "target": "<item type=\"input\">=COLUMNA(D3:G10)</item> retorna 4 perquè la columna D és la quarta columna de la taula i la funció COLUMNA no s'utilitza com a fórmula matricial. (En aquest cas, el primer valor de la matriu sempre s'utilitza com a resultat.)", "id": 49518509, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518509/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760725/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.686004Z", "action": 59, "target": "<item type=\"input\">=COLUMNA(C3:E3)</item> és igual a 3. La columna C és la tercera columna de la taula.", "id": 49518508, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518508/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760718/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.685982Z", "action": 59, "target": "<item type=\"input\">=COLUMNA(A1)</item> és igual a 1. La columna A és la primera columna de la taula.", "id": 49518507, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518507/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760711/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.685960Z", "action": 59, "target": "Si no indiqueu cap referència, se cercarà el número de columna de la cel·la on s'introdueixi la fórmula. El <item type=\"productname\">%PRODUCTNAME</item> Calc defineix automàticament la referència de la cel·la actual.", "id": 49518506, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518506/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760704/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.685939Z", "action": 59, "target": "<emph>Referència</emph> és la referència a una cel·la o a una àrea de cel·les de la qual s'ha de cercar el número de la primera columna.", "id": 49518505, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518505/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760691/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.685917Z", "action": 59, "target": "COLUMNA([Referència])", "id": 49518504, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518504/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111760685/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:56:25.685895Z", "action": 59, "target": "", "id": 49518503, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49518503/?format=api" } ] }