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=36
{ "count": 8598, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/changes/?format=api&page=37", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/changes/?format=api&page=35", "results": [ { "unit": "https://translations.documentfoundation.org/api/units/111783055/?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:30.951252Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_DATWERT\">Retorna el nombre de data interna del text entre cometes.</ahelp>", "id": 49523302, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523302/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111783051/?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:30.951230Z", "action": 59, "target": "<variable id=\"datevalue\"><link href=\"text/scalc/01/func_datevalue.xhp\">VALORDATA</link></variable>", "id": 49523301, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523301/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111783045/?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:30.951208Z", "action": 59, "target": "<bookmark_value>funció VALORDATA</bookmark_value>", "id": 49523300, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523300/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111783041/?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:30.951186Z", "action": 59, "target": "VALORDATA", "id": 49523299, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523299/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111783038/?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:30.951164Z", "action": 59, "target": "", "id": 49523298, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523298/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111783034/?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:30.951142Z", "action": 59, "target": "<unk>GA =DATEIF(\"1974-0414-17\";DATE(2012;06;13;\"yd\") dóna 57 anys fa 57 dies.", "id": 49523297, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523297/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111783026/?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:30.951120Z", "action": 59, "target": "<item type=\"input\">=DIFDATES(\"17/04/1974\";\"13/06/2012\";\"d\")</item> dona 13937. Per tant, ha viscut 13937 dies.", "id": 49523296, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523296/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111783022/?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:30.951098Z", "action": 59, "target": "<unk>GA =DATEIF(DATE(197417);\"2012-06-13\";\"m\")</item> dóna 457 anys de vida.", "id": 49523295, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523295/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111783016/?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:30.951075Z", "action": 59, "target": "Així que té 38 anys 1 mes i 27 dies.", "id": 49523294, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523294/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111783011/?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:30.951053Z", "action": 59, "target": "<unk>GA =DATEIF(\"1974-0474-17\";\"2012-06-13\";\"md\")</item> dóna 27.", "id": 49523293, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523293/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111783004/?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:30.951030Z", "action": 59, "target": "<unk>GA =DATEIF(\"1974-0474-17\";\"2012-06-13\";\"ym\")</item> dóna 1.", "id": 49523292, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523292/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111782997/?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:30.951007Z", "action": 59, "target": "<unk>GA =DATEIF(\"1974-0474-17\";\"2012-06-13\";\"y\")</item> dóna 38.", "id": 49523291, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523291/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111782992/?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:30.950984Z", "action": 59, "target": "Càlcul de la data de naixement. Una persona va néixer el 17/04/1974. Avui és el 13/06/2012.", "id": 49523290, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523290/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111782988/?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:30.950962Z", "action": 59, "target": "Nombre de dies complets en restar els anys de la diferència entre la Data inicial i la Data final.", "id": 49523289, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523289/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111782983/?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:30.950940Z", "action": 59, "target": "Nombre de dies complets en restar els anys i els mesos de la diferència entre la Data inicial i la Data final.", "id": 49523288, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523288/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111782978/?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:30.950918Z", "action": 59, "target": "Nombre de mesos complets en restar els anys de la diferència entre la Data inicial i la Data final.", "id": 49523287, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523287/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111782974/?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:30.950895Z", "action": 59, "target": "Nombre d'anys complets entre la Data inicial i la Data final.", "id": 49523286, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523286/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111782969/?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:30.950872Z", "action": 59, "target": "Nombre de mesos complets entre la Data inicial i la Data final.", "id": 49523285, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523285/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111782964/?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:30.950850Z", "action": 59, "target": "Nombre de dies complets entre la Data inicial i la Data final.", "id": 49523284, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523284/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111782959/?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:30.950828Z", "action": 59, "target": "Valor de retorn", "id": 49523283, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523283/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111782954/?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:30.950806Z", "action": 59, "target": "Valor d'«Interval»", "id": 49523282, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523282/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111782950/?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:30.950785Z", "action": 59, "target": "", "id": 49523281, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523281/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111782944/?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:30.950762Z", "action": 59, "target": "<emph>Data final</emph> és la data fins a la qual es fa el càlcul. La Data final ha de ser posterior a la Data inicial.", "id": 49523280, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523280/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111782939/?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:30.950733Z", "action": 59, "target": "<emph>Data inicial</emph> és la data a partir de la qual es duu a terme el càlcul.", "id": 49523279, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523279/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111782934/?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:30.950686Z", "action": 59, "target": "", "id": 49523278, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523278/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111782929/?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:30.950664Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_DATEDIF\">Aquesta funció retorna el nombre de dies, mesos o anys complets entre la data inicial i la data final.</ahelp>", "id": 49523277, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523277/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111782924/?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:30.950641Z", "action": 59, "target": "<variable id=\"datedif\"><link href=\"text/scalc/01/func_datedif.xhp\">DIFDATES</link></variable>", "id": 49523276, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523276/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111782917/?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:30.950615Z", "action": 59, "target": "<bookmark_value>funció DIFDATES</bookmark_value>", "id": 49523275, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523275/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111782913/?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:30.950579Z", "action": 59, "target": "DIFDATES", "id": 49523274, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523274/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111782907/?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:30.950542Z", "action": 59, "target": "", "id": 49523273, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523273/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111782896/?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:30.950506Z", "action": 59, "target": "<item type=\"input\">=DATA(00;1;31)</item> dona 31/01/00 si la configuració del format de la cel·la és DD/MM/YY.", "id": 49523272, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523272/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111782891/?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:30.950469Z", "action": 59, "target": "Si els valors per al mes i el dia estan fora dels límits, passen al dígit següent. Si introduïu <item type=\"input\">=DATA(00;12;31)</item> el resultat serà 31/12/00. Si, d'altra banda, introduïu <item type=\"input\">=DATA(00;13;31)</item> el resultat serà 31/01/01.", "id": 49523271, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523271/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111782886/?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:30.950433Z", "action": 59, "target": "<emph>Dia</emph> és un nombre entre 1 i 31 que indica el dia del mes.", "id": 49523270, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523270/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111782882/?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:30.950397Z", "action": 59, "target": "<emph>Mes</emph> és un enter que indica el mes.", "id": 49523269, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523269/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111782876/?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:30.950360Z", "action": 59, "target": "A <switchinline select=\"sys\"><caseinline select=\"MAC\"><item type=\"menuitem\">%PRODUCTNAME ▸ Preferències</item></caseinline><defaultinline><item type=\"menuitem\">Eines ▸ Opcions</item></defaultinline></switchinline><item type=\"menuitem\"> ▸ $[officename] ▸ General</item> podeu definir a partir de quin any es reconeix una entrada de dos dígits com a 20xx.", "id": 49523268, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523268/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111782870/?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:30.950323Z", "action": 59, "target": "<emph>Any</emph> és un enter entre 1583 i 9957 o entre 0 i 99.", "id": 49523267, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523267/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111782867/?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:30.950287Z", "action": 59, "target": "DATA(Any; Mes; Dia)", "id": 49523266, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523266/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111782860/?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:30.950250Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_DATUM\">Aquesta funció calcula una data indicada per any, mes o dia i la mostra a la formatació de la cel·la.</ahelp> El format per defecte d'una cel·la que conté la funció DATA és el format de data, però podeu formatar les cel·les amb qualsevol altre format numèric.", "id": 49523265, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523265/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111782842/?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:30.950213Z", "action": 59, "target": "<variable id=\"date\"><link href=\"text/scalc/01/func_date.xhp\">DATA</link></variable>", "id": 49523264, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523264/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111782840/?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:30.950176Z", "action": 59, "target": "<bookmark_value>funció DATA</bookmark_value>", "id": 49523263, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523263/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111782834/?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:30.950142Z", "action": 59, "target": "DATA", "id": 49523262, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523262/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111782829/?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:30.950108Z", "action": 59, "target": "", "id": 49523261, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523261/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111782825/?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:30.950074Z", "action": 59, "target": "Si E2 = llapis, la funció retorna 1, perquè l'enllaç a la cel·la se substitueix amb el seu contingut i funciona com a funció a dalt.", "id": 49523260, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523260/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111782819/?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:30.950040Z", "action": 59, "target": "<item type=\"input\">=COMPTASICONJUNT(A2:A6;E2&\".*\";B2:B6;\"<\"&MAX(B2:B6))</item>", "id": 49523259, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523259/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111782815/?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:30.950006Z", "action": 59, "target": "Si heu de canviar el criteri fàcilment, potser voleu indicar-lo en una cel·la separada i usar una referència a aquesta cel·la en la condició de la funció SUMASI. Per exemple, la funció superior es pot reescriure com a:", "id": 49523258, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523258/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111782807/?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:30.949973Z", "action": 59, "target": "Referència a una cel·la com a criteri", "id": 49523257, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523257/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111782803/?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:30.949939Z", "action": 59, "target": "Compta la quantitat de files que corresponen a totes les cel·les de l'interval A2:A6 començant per \"llapis\" i a totes les cel·les de l'interval B2:B6 excepte el màxim. Retorna 1, perquè només la segona fila compleix tots els criteris.", "id": 49523256, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523256/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111782799/?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:30.949905Z", "action": 59, "target": "<item type=\"input\">=COMPTASICONJUNT(A2:A6;\"pen.*\";B2:B6;\"<\"&MAX(B2:B6))</item>", "id": 49523255, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523255/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111782792/?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:30.949870Z", "action": 59, "target": "Compta la quantitat de files de l'interval B2:B6 excloent les files amb valors mínims i màxims d'aquest interval. Retorna 2, perquè la tercera, la cinquena i la sisena files no compleixen com a mínim un criteri.", "id": 49523254, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523254/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/111782787/?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:30.949834Z", "action": 59, "target": "<item type=\"input\">=COMPTASICONJUNT(B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>", "id": 49523253, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49523253/?format=api" } ] }