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/it/changes/?format=api&page=18
{ "count": 8481, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/it/changes/?format=api&page=19", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/it/changes/?format=api&page=17", "results": [ { "unit": "https://translations.documentfoundation.org/api/units/112427499/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.807939Z", "action": 59, "target": "<link href=\"text/scalc/01/04060110.xhp#concatenate\">CONCATENA</link>", "id": 50171078, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171078/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427498/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.807901Z", "action": 59, "target": "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/TEXTJOIN\">Pagina wiki relativa a TESTO.UNISCI</link> (in inglese).", "id": 50171077, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171077/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427497/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.807864Z", "action": 59, "target": "Se l'intervallo A1:B2 contiene rispettivamente \"Ecco\", \"che torna\", \"il\", \"sole\", <input>=TESTO.UNISCI(\"-\";1,A1:B2)</input> restituisce \"Ecco-che-torna-il-sole\" con il carattere trattino in qualità di delimitatore; le stringhe vuote vengono ignorate.", "id": 50171076, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171076/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427496/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.807829Z", "action": 59, "target": "<input>=TESTO.UNISCI(\" \"; 1; \"Ecco\", \"che torna\", \"il\", \"sole\")</input> restituisce \"Ecco che torna il sole\" con il carattere spazio in qualità di delimitatore; le stringhe vuote vengono ignorate.", "id": 50171075, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171075/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427495/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.807804Z", "action": 59, "target": "Se i delimitatori sono meno numerosi delle stringhe da unire verranno riutilizzati dall'inizio.", "id": 50171074, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171074/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427494/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.807782Z", "action": 59, "target": "Se i delimitatori sono più numerosi delle stringhe da unire, non verranno utilizzati tutti.", "id": 50171073, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171073/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427493/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.807760Z", "action": 59, "target": "Se il <emph>delimitatore</emph> è costituito da un intervallo di celle non deve necessariamente avere le stesse dimensioni del numero di stringhe da unire.", "id": 50171072, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171072/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427492/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.807739Z", "action": 59, "target": "Gli intervalli di celle vengono percorsi riga per riga (dall'alto in basso).", "id": 50171071, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171071/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427491/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.807717Z", "action": 59, "target": "<emph>Stringa 1[; Stringa 2][; … ;[Stringa 253]]</emph> sono stringhe, riferimenti a celle o a intervalli di celle di stringhe.", "id": 50171070, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171070/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427490/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.807695Z", "action": 59, "target": "<emph>salta_vuoto</emph> è un argomento logico. Se impostato a FALSO o 0, le stringhe vuote vengono considerate e possono portare a delimitatori contigui nella stringa restituita. Se impostati a qualsiasi altro valore (per esempio, VERO o 1) le stringhe vuote vengono ignorate.", "id": 50171069, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171069/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427489/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.807674Z", "action": 59, "target": "<emph>delimitatore</emph> è una stringa di testo e può essere un'area.", "id": 50171068, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171068/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427488/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.807651Z", "action": 59, "target": "TESTO.UNISCI( delimitatore, salta_vuoto, Stringa 1[; Stringa 2][; … ;[Stringa 253]] )", "id": 50171067, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171067/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427487/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.807625Z", "action": 59, "target": "<variable id=\"textjoinfunction\"><ahelp hid=\".\">Combina una o più stringhe e le separa con delimitatori.</ahelp></variable>", "id": 50171066, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171066/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427486/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.807592Z", "action": 59, "target": "<variable id=\"textjoinfunct\"><link href=\"text/scalc/01/func_textjoin.xhp\">TESTO.UNISCI</link></variable>", "id": 50171065, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171065/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427485/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.807557Z", "action": 59, "target": "<bookmark_value>TESTO.UNISCI, funzione</bookmark_value>", "id": 50171064, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171064/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427484/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.807521Z", "action": 59, "target": "Funzione TESTO.UNISCI", "id": 50171063, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171063/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427483/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.807485Z", "action": 59, "target": "<link href=\"text/scalc/01/04060105.xhp#Section4\">SE</link>", "id": 50171062, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171062/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427482/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.807461Z", "action": 59, "target": "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/SWITCH\">Pagina wiki relativa a SWITCH</link> (in inglese).", "id": 50171061, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171061/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427481/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.807438Z", "action": 59, "target": "<input>=SWITCH(MESE(A3),1,\"Gennaio\",2,\"Febbraio\",3,\"Marzo\",\"Nessuna corrispondenza\")</input> restituisce \"Gennaio\" quando A3 contiene una data in gennaio, \"Febbraio\" quando A3 contiene una data in febbraio, e via discorrendo...", "id": 50171060, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171060/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427480/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.807405Z", "action": 59, "target": "Se non vengono trovati <emph>valori</emph> corrispondenti all'<emph>espressione</emph> e non viene fornito alcun risultato predefinito, viene restituito un errore #N/D.", "id": 50171059, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171059/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427479/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.807364Z", "action": 59, "target": "<emph>risultato_predefinito</emph>: ogni valore o riferimento a una cella restituito in assenza di corrispondenze.", "id": 50171058, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171058/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427478/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.807326Z", "action": 59, "target": "<emph>risultato1, risultato2, ...</emph> corrisponde a un valore o al riferimento a una cella.", "id": 50171057, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171057/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427477/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.807284Z", "action": 59, "target": "<emph>valore1, valore2, ...</emph> corrisponde a un valore qualsiasi o a un riferimento a una cella. A ogni valore deve essere assegnato un risultato.", "id": 50171056, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171056/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427476/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.807244Z", "action": 59, "target": "Una <emph>espressione</emph> è una stringa testuale, numerica, logica, oppure è costituita da una data o da un riferimento a una cella.", "id": 50171055, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171055/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427475/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.807203Z", "action": 59, "target": "Se scegliete di non specificare un risultato predefinito, le 127 coppie valore / risultato potrebbero essere inserite come parametri. Se scegliete di includere un risultato predefinito alla fine dell'elenco dei parametri, allora potranno essere digitate solo 126 coppie valore / risultato.", "id": 50171054, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171054/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427474/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.807163Z", "action": 59, "target": "SWITCH(espressione; valore1; risultato1[; valore2; risultato2][; ... ; [valore127; risultato127][; risultato_predefinito]])", "id": 50171053, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171053/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427473/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.807124Z", "action": 59, "target": "<variable id=\"functionswitch\"><ahelp hid=\".\">SWITCH esegue un confronto valutativo di <emph>espressioni</emph> seguite da valori, da <emph>valore 1</emph> a <emph>valore n</emph>, e restituisce il risultato appartenente al primo valore corrispondente. Se non viene riscontrata alcuna corrispondenza verrà restituito un risultato predefinito.</ahelp></variable>", "id": 50171052, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171052/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427472/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.807085Z", "action": 59, "target": "<variable id=\"switchfunct\"><link href=\"text/scalc/01/func_switch.xhp\">SWITCH</link></variable>", "id": 50171051, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171051/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427471/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.807046Z", "action": 59, "target": "<bookmark_value>SWITCH, funzione</bookmark_value>", "id": 50171050, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171050/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427470/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.807008Z", "action": 59, "target": "Funzione SWITCH", "id": 50171049, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171049/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427469/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.806971Z", "action": 59, "target": "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/SUMIFS\">Pagina wiki relativa a SOMMA.PIÙ.SE</link> (in inglese).", "id": 50171048, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171048/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427468/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.806934Z", "action": 59, "target": "Se E2 = pen, la funzione restituisce 65, perché il collegamento alla cella è sostituito dal suo contenuto.", "id": 50171047, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171047/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427467/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.806896Z", "action": 59, "target": "<item type=\"input\">=SOMMA.PIÙ.SE(C2:C6;A2:A6;E2&\".*\";B2:B6;\"<\"&MAX(B2:B6))</item>", "id": 50171046, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171046/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427466/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.806859Z", "action": 59, "target": "Per cambiare in modo facile un criterio, potete specificarlo in una cella separata, utilizzando un riferimento alla cella all'interno della condizione della funzione SOMMA.PIÙ.SE. Per esempio, la funzione sopra citata può essere riscritta nel modo seguente:", "id": 50171045, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171045/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427465/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.806822Z", "action": 59, "target": "Fare riferimento a una cella come criterio", "id": 50171044, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171044/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427464/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.806784Z", "action": 59, "target": "Calcola la somma dei valori dell'intervallo C2:C6 che corrispondono a tutte le celle dell'intervallo A2:B6 che iniziano con \"pen\" e a tutte le celle dell'intervallo B2:B6, eccetto il suo massimo. Restituisce 65, perché solo la seconda riga soddisfa tutti i criteri.", "id": 50171043, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171043/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427463/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.806744Z", "action": 59, "target": "<item type=\"input\">=SOMMA.PIÙ.SE(C2:C6;A2:A6;\"pen.*\";B2:B6;\"<\"&MAX(B2:B6))</item>", "id": 50171042, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171042/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427462/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.806688Z", "action": 59, "target": "Calcola la somma dei valori dell'intervallo C2:C6 che corrispondono a tutti i valori dell'intervallo B2:B6, eccetto il suo minimo e massimo. Restituisce 255, perché la terza e la quinta riga non soddisfano almeno un criterio.", "id": 50171041, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171041/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427461/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.806647Z", "action": 59, "target": "<item type=\"input\">=SOMMA.PIÙ.SE(C2:C6;B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>", "id": 50171040, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171040/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427460/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.806619Z", "action": 59, "target": "Uso delle espressioni regolari e delle funzioni annidate", "id": 50171039, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171039/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427459/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.806596Z", "action": 59, "target": "Calcola la somma dei valori dell'intervallo C2:C6 maggiori di 70 e che corrispondono alle celle dell'intervallo B2:B6 con valori maggiori o uguali a 20. Restituisce 275, perché la seconda e la quinta riga non soddisfano almeno un criterio.", "id": 50171038, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171038/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427458/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.806575Z", "action": 59, "target": "<item type=\"input\">=SOMMA.PIÙ.SE(C2:C6;B2:B6;\">=20\";C2:C6;\">70\")</item>", "id": 50171037, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171037/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427457/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.806551Z", "action": 59, "target": "Calcola la somma dei valori dell'intervallo B2:B6, maggiori o uguali a 20. Restituisce 75, perché la quinta riga non soddisfa il criterio.", "id": 50171036, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171036/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427456/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.806521Z", "action": 59, "target": "<item type=\"input\">=SOMMA.PIÙ.SE(B2:B6;B2:B6;\">=20\")</item>", "id": 50171035, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171035/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427455/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.806483Z", "action": 59, "target": "Uso semplice", "id": 50171034, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171034/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427454/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.806454Z", "action": 59, "target": "<emph>Intervallo_Funz</emph> – argomento obbligatorio. È un intervallo di celle, il nome di un'area indicata, la dicitura di una colonna o di una riga che contiene valori per il calcolo della somma.", "id": 50171033, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171033/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427453/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.806432Z", "action": 59, "target": "SOMMA.PIÙ.SE(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)", "id": 50171032, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171032/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427452/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.806410Z", "action": 59, "target": "<ahelp hid=\".\"><variable id=\"sumifs_des\">Restituisce la somma dei valori delle celle in un intervallo che soddisfa più criteri in intervalli multipli.</variable></ahelp>", "id": 50171031, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171031/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427451/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.806382Z", "action": 59, "target": "<variable id=\"sumifs_head\"><link href=\"text/scalc/01/func_sumifs.xhp\">SOMMA.PIÙ.SE</link></variable>", "id": 50171030, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171030/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112427450/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.806345Z", "action": 59, "target": "<bookmark_value>SOMMA.PIÙ.SE, funzione</bookmark_value><bookmark_value>Somma;soddisfare le condizioni</bookmark_value>", "id": 50171029, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50171029/?format=api" } ] }