Changes
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-7-6/textscalc01/ca/changes/?format=api&page=129
https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/changes/?format=api&page=130", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ca/changes/?format=api&page=128", "results": [ { "unit": "https://translations.documentfoundation.org/api/units/99913526/?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.100954Z", "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": 37316694, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316694/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913523/?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.100929Z", "action": 59, "target": "", "id": 37316693, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316693/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913521/?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.100904Z", "action": 59, "target": "", "id": 37316692, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316692/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913515/?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.100878Z", "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": 37316691, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316691/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913510/?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.100852Z", "action": 59, "target": "COINCIDEIX", "id": 37316690, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316690/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913505/?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.100826Z", "action": 59, "target": "<bookmark_value>funció COINCIDEIX</bookmark_value>", "id": 37316689, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316689/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913500/?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.100801Z", "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": 37316688, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316688/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913495/?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.100775Z", "action": 59, "target": "<emph>Referència</emph> és la referència a un full o a una àrea. Aquest paràmetre és opcional.", "id": 37316687, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316687/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913490/?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.100748Z", "action": 59, "target": "SHEETS([Referència])", "id": 37316686, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316686/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913480/?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.100720Z", "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": 37316685, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316685/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913475/?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.100694Z", "action": 59, "target": "FULLS", "id": 37316684, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316684/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913465/?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.100668Z", "action": 59, "target": "<bookmark_value>número de fulls; funció</bookmark_value><bookmark_value>funció FULLS</bookmark_value>", "id": 37316683, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316683/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913461/?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.100642Z", "action": 59, "target": "", "id": 37316682, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316682/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913457/?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.100617Z", "action": 59, "target": "", "id": 37316681, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316681/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913453/?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.100590Z", "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": 37316680, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316680/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913448/?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.100563Z", "action": 59, "target": "FULL([Referència])", "id": 37316679, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316679/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913445/?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.100537Z", "action": 59, "target": "", "id": 37316678, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316678/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913440/?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.100510Z", "action": 59, "target": "FULL", "id": 37316677, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316677/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913436/?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.100484Z", "action": 59, "target": "<bookmark_value>números de full; cerca</bookmark_value><bookmark_value>funció FULL</bookmark_value>", "id": 37316676, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316676/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913433/?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.100455Z", "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": 37316675, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316675/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913430/?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.100427Z", "action": 59, "target": "<item type=\"input\">=CONSULTAV(A1;D1:E100;2)</item>", "id": 37316674, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316674/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913428/?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.100389Z", "action": 59, "target": "Introduïu la fórmula següent a B1:", "id": 37316673, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316673/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913425/?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.100346Z", "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": 37316672, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316672/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913421/?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.100303Z", "action": 59, "target": "", "id": 37316671, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316671/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913418/?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.100256Z", "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": 37316670, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316670/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913412/?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.100230Z", "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": 37316669, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316669/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913410/?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.100203Z", "action": 59, "target": "", "id": 37316668, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316668/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913407/?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.100177Z", "action": 59, "target": "", "id": 37316667, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316667/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913403/?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.100149Z", "action": 59, "target": "", "id": 37316666, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316666/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913400/?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.100124Z", "action": 59, "target": "CONSULTAV", "id": 37316665, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316665/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913397/?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.100099Z", "action": 59, "target": "<bookmark_value>funció de cerca vertical</bookmark_value><bookmark_value>funció CONSULTAV</bookmark_value>", "id": 37316664, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316664/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913393/?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.100073Z", "action": 59, "target": "<item type=\"input\">=COLUMNES(Conill)</item> retorna 2 si <item type=\"literal\">Conill</item> és l'interval anomenat (C1:D3).", "id": 37316663, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316663/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913389/?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.100048Z", "action": 59, "target": "<item type=\"input\">=COLUMNES(A1:C5)</item> és igual a 3. La referència comprèn tres columnes.", "id": 37316662, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316662/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913380/?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.100021Z", "action": 59, "target": "<item type=\"input\">=COLUMNES(B5)</item> retorna 1 perquè una cel·la només conté una columna.", "id": 37316661, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316661/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913377/?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.099995Z", "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": 37316660, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316660/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913374/?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.099970Z", "action": 59, "target": "COLUMNES(Matriu)", "id": 37316659, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316659/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913370/?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.099943Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_SPALTEN\">Retorna el nombre de columnes de la referència determinada.</ahelp>", "id": 37316658, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316658/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913368/?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.099918Z", "action": 59, "target": "COLUMNES", "id": 37316657, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316657/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913366/?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.099892Z", "action": 59, "target": "<bookmark_value>funció COLUMNES</bookmark_value>", "id": 37316656, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316656/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913363/?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.099862Z", "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": 37316655, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316655/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913358/?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.099834Z", "action": 59, "target": "<item type=\"input\">=COLUMNA()</item> retorna 3 si s'ha introduït la fórmula a la columna C.", "id": 37316654, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316654/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913354/?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.099808Z", "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": 37316653, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316653/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913349/?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.099781Z", "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": 37316652, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316652/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913347/?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.099755Z", "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": 37316651, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316651/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913342/?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.099727Z", "action": 59, "target": "<item type=\"input\">=COLUMNA(A1)</item> és igual a 1. La columna A és la primera columna de la taula.", "id": 37316650, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316650/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913338/?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.099690Z", "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": 37316649, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316649/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913332/?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.099647Z", "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": 37316648, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316648/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913329/?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.099605Z", "action": 59, "target": "COLUMNA([Referència])", "id": 37316647, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316647/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913326/?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.099561Z", "action": 59, "target": "", "id": 37316646, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316646/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99913322/?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.099521Z", "action": 59, "target": "COLUMNA", "id": 37316645, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37316645/?format=api" } ] }{ "count": 8501, "next": "