Changes
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-master/textsbasicshared03/it/changes/?format=api&page=95
{ "count": 11310, "next": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/changes/?format=api&page=96", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/changes/?format=api&page=94", "results": [ { "unit": "https://translations.documentfoundation.org/api/units/67213898/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-16T13:24:29.048905Z", "action": 4, "target": "<emph>rowfields:</emph> una singola stringa o una matrice con i nomi dei campi da usare per le righe della tabella pivot.", "id": 3394602, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3394602/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67213897/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-16T13:23:13.854837Z", "action": 4, "target": "Le funzioni consentite sono: <literal>Sum</literal>, <literal>Count</literal>, <literal>Average</literal>, <literal>Max</literal>, <literal>Min</literal>, <literal>Product</literal>, <literal>CountNums</literal>, <literal>StDev</literal>, <literal>StDevP</literal>, <literal>Var</literal>, <literal>VarP</literal> e <literal>Median</literal>. I nomi delle funzioni devono essere indicati in inglese. Quano tutti i valori sono numerici la funzione predefinita è <literal>Sum</literal>, altrimenti è <literal>Count</literal>.", "id": 3394601, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3394601/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67213896/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-16T13:21:08.219901Z", "action": 4, "target": "<emph>datafields:</emph> può essere sia una singola stringa, sia una matrice contenente le stringhe che definiscono i nomi dei campi e le funzioni da applicata. Se è specificata una matrice, deve rispettare la sintassi <input>Array(\"FieldName[;Function]\", ...)</input>.", "id": 3394600, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3394600/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67213895/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-16T13:19:33.790849Z", "action": 4, "target": "<emph>targetcell:</emph> la prima cella in alto a sinistra in cui sarà posizionata la nuova tabella pivot. Se è specificato un intervallo, viene presa in considerazione solamente la sua prima cella in alto a sinistra.", "id": 3394599, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3394599/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67213894/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-16T13:17:53.935297Z", "action": 4, "target": "<emph>sourcerange:</emph> l'intervallo contenente i dati grezzi, in formato stringa. Si presume che la prima riga contenga i nomi dei campi usati dalla tabella pivot.", "id": 3394598, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3394598/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67213893/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-16T13:16:43.756620Z", "action": 4, "target": "<emph>pivottablename:</emph> il nome definito dall'utente per la nuova tabella pivot.", "id": 3394597, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3394597/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67213892/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-16T13:16:18.092054Z", "action": 4, "target": "Questo metodo restituisce una stringa contenente l'intervallo in cui è stata posizionata la nuova tabella pivot.", "id": 3394596, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3394596/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67213891/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-16T13:15:40.126329Z", "action": 4, "target": "Deve essere fornito un nome per la tabella pivot. Se nel foglio di destinazione esiste già una tabella pivot con lo stesso nome, questa viene sostituita senza avvertimenti.", "id": 3394595, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3394595/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67213890/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-16T13:14:21.151212Z", "action": 4, "target": "Crea una nuova tabella pivot con le proprietà definite dagli argomenti passati al metodo.", "id": 3394594, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3394594/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67169179/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-16T13:13:48.674229Z", "action": 4, "target": "newrange = myDoc.CompactUp(\"Sheet1.G1:L10\", filterformula = '=(MOD(SUM(G1:L1);2)=1)')", "id": 3394593, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3394593/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67169178/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-16T13:13:42.586248Z", "action": 4, "target": "newrange = myDoc.CompactUp(\"Sheet1.G1:L10\", filterformula = '=(G1=\"X\")')", "id": 3394592, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3394592/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67169177/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-16T13:13:37.466370Z", "action": 4, "target": "newrange = myDoc.CompactUp(\"Sheet1.G1:L10\", wholerow = True)", "id": 3394591, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3394591/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67169176/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-16T13:13:31.654477Z", "action": 4, "target": "newrange = myDoc.CompactUp(\"Sheet1.G1:L10\")", "id": 3394590, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3394590/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67169175/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-16T13:13:27.162009Z", "action": 4, "target": "newrange = oDoc.CompactUp(\"Sheet1.G1:L10\", FilterFormula := \"=(MOD(SUM(G1:L1);2)=1)\")", "id": 3394589, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3394589/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67169174/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-16T13:13:22.341643Z", "action": 4, "target": "' Elimina tutte le righe in cui la somma dei valori della riga è dispari", "id": 3394588, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3394588/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67169173/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-16T13:12:51.293655Z", "action": 4, "target": "newrange = oDoc.CompactUp(\"Sheet1.G1:L10\", FilterFormula := \"=(G1=\"\"X\"\")\")", "id": 3394587, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3394587/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67169172/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-16T13:12:45.412153Z", "action": 4, "target": "' Elimina tutte le righe nelle quali la prima colonna è contrassegnata con una \"X\"", "id": 3394586, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3394586/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67169171/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-16T13:12:04.934660Z", "action": 4, "target": "newrange = oDoc.CompactUp(\"Sheet1.G1:L10\", WholeRow := True)", "id": 3394585, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3394585/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67169170/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-16T13:12:00.402013Z", "action": 4, "target": "' L'esempio seguente è simile, ma elimina l'intera riga dal foglio", "id": 3394584, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3394584/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67169169/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-16T12:39:09.334075Z", "action": 4, "target": "newrange = oDoc.CompactUp(\"Sheet1.G1:L10\")", "id": 3394583, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3394583/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67169168/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-16T12:39:04.149392Z", "action": 4, "target": "' Elimina tutte le righe vuote nell'intervallo G1:L10 del foglio Sheet1", "id": 3394582, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3394582/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67169167/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-16T12:38:32.078360Z", "action": 4, "target": "Per esempio, supponendo che sia selezionato l'intervallo <emph>A1:J200</emph> (larghezza = 10), la formula predefinità sarà <emph>=(COUNTBLANK(A1:J1)=10)</emph>. Questo significa che se tutte le 10 celle della prima riga (Riga 1) sono vuote, allora la riga sarà eliminata. Da notare che la formula espressa fa riferimento solo alla prima riga. Internamento il metodo <literal>CompactUp</literal> generalizzerà questa formula per tutte le righe restanti.", "id": 3394581, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3394581/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67169166/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-16T12:32:09.429174Z", "action": 4, "target": "<emph>filterformula</emph>: il filtro da applicare ad ogni riga per determinare se questa sarà eliminata o meno. Il filtro è espresso come formula di Calc da applicare alla prima riga. Se la formula restiuisce <emph>True</emph> per una riga, questa sarà eliminata. Il filtro predefinito elimina tutte le righe vuote.", "id": 3394580, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3394580/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67169165/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-16T12:26:02.555593Z", "action": 4, "target": "<emph>wholerow</emph>: se questa opzione è impostata a <literal>True</literal> l'intera riga sarà eliminata dal foglio. Il valore predefinito è <literal>False</literal>, che significa che le righe eliminate si limiteranno alla larghezza dell'<literal>intervallo</literal> specificato.", "id": 3394579, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3394579/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67169162/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-16T12:23:58.404516Z", "action": 4, "target": "Se è selezionato un intervallo di celle, la chiamata a questo metodo non avrà effetto sulla selezione.", "id": 3394578, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3394578/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67169161/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-16T12:23:09.669667Z", "action": 4, "target": "Questo metodo restituisce una stringa con l'indirizzo dell'intervallo compattato. Se vengono eliminate tutte le righe, sarà restituita una stringa vuota.", "id": 3394577, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3394577/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67169159/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-16T12:21:57.471271Z", "action": 4, "target": "Le righe eliminate possono limitarsi alla larghezza dell'intervallo specificato o estendersi alla larghezza dell'intero foglio, eliminando quindi righe intere.", "id": 3394576, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3394576/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67169158/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-16T12:20:18.844365Z", "action": 4, "target": "Elimina tutte le righe di un intervallo specificato che rispettano le condizioni di un filtro espresso come formula di Calc. Il filtro è applicato ad ogni riga per decidere se questa sarà eliminata o meno.", "id": 3394575, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3394575/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67169157/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-16T12:18:28.248050Z", "action": 4, "target": "newrange = myDoc.CompactLeft(\"Sheet1.G1:L10\", filterformula = '=(MOD(SUM(G1:G10);2)=1)')", "id": 3394574, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3394574/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67169156/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-16T12:18:21.400044Z", "action": 4, "target": "newrange = myDoc.CompactLeft(\"Sheet1.G1:L10\", filterformula = '=(G1=\"X\")')", "id": 3394573, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3394573/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67169155/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-16T12:18:15.765942Z", "action": 4, "target": "newrange = myDoc.CompactLeft(\"Sheet1.G1:L10\", wholecolumn = True)", "id": 3394572, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3394572/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67169154/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-16T12:18:08.989238Z", "action": 4, "target": "newrange = myDoc.CompactLeft(\"Sheet1.G1:L10\")", "id": 3394571, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3394571/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67169153/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-16T12:18:04.036810Z", "action": 4, "target": "newrange = oDoc.CompactLeft(\"Sheet1.G1:L10\", FilterFormula := \"=(MOD(SUM(G1:G10);2)=1)\")", "id": 3394570, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3394570/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67169152/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-16T12:17:55.083170Z", "action": 4, "target": "' Elimina tutte le colonne in cui la somma dei valori della colonna è dispari", "id": 3394569, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3394569/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67169151/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-16T12:16:41.059015Z", "action": 4, "target": "newrange = oDoc.CompactLeft(\"Sheet1.G1:L10\", FilterFormula := \"=(G1=\"\"X\"\")\")", "id": 3394568, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3394568/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67169150/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-16T12:16:33.432035Z", "action": 4, "target": "' Elimina tutte le colonne in cui la prima cella è contrassegnata con una \"X\"", "id": 3394567, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3394567/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67169149/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-16T12:16:00.984137Z", "action": 4, "target": "newrange = oDoc.CompactLeft(\"Sheet1.G1:L10\", WholeColumn := True)", "id": 3394565, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3394565/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67169148/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-16T12:15:50.972481Z", "action": 4, "target": "' L'esempio seguente è simile, ma l'intera colonna viene eliminata dal foglio", "id": 3394564, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3394564/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67169147/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-16T12:14:50.479928Z", "action": 4, "target": "newrange = oDoc.CompactLeft(\"Sheet1.G1:L10\")", "id": 3394563, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3394563/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67169146/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-16T12:14:30.807971Z", "action": 4, "target": "' Elimina tutte le colonne vuote nell'intervallo G1:L10 del foglio Sheet1", "id": 3394562, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3394562/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67169146/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-16T12:14:18.830641Z", "action": 26, "target": "' Elimina tutte le colonne vuote nell'intervallo G1:L10 di foglio Sheet1", "id": 3394561, "action_name": "Suggestion removed", "url": "https://translations.documentfoundation.org/api/changes/3394561/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67169146/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-16T12:14:04.275381Z", "action": 4, "target": "' Elimina tutte le colonne vuote nell'intervallo G1:L10 di foglio Sheet1", "id": 3394560, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3394560/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67169145/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-16T12:13:33.985794Z", "action": 4, "target": "Per esempio, supponendo che sia selezionato l'intervallo <emph>A1:J200</emph> (altezza = 200), la formula predefinita è <emph>=(COUNTBLANK(A1:A200)=200)</emph>. Questo significa che se tutte le 200 celle della prima colonna sono vuote (Colonna A), la colonna sarà eliminata. Da notare che la formula espressa fa riferimento solo alla prima colonna. Internamente il metodo <literal>CompactLeft</literal> generalizzerà questa formula per tutte le colonne rimanenti.", "id": 3394559, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3394559/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67169144/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-16T12:09:02.873932Z", "action": 4, "target": "<emph>filterformula</emph>: il filtro da applicare a ciascuna colonna per determinare se dev'essere eliminata o meno Il filtro è espresso come una formula di Calc da applicare alla prima colonna. Se la formula restituisce <emph>True</emph> per una colonna, questa sarà eliminata. Il filtro predefinito elimina tutte le colonne vuote.", "id": 3394557, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3394557/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67241519/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-11T21:06:54.566978Z", "action": 4, "target": "1) '$FoglioX'.A:A (colonna A)<br/>2) 3:5 (righe da 3 a 5)", "id": 3385853, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3385853/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67241518/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-11T21:06:29.593158Z", "action": 4, "target": "$'FoglioX'.*", "id": 3385851, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3385851/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67241517/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-11T21:06:15.433370Z", "action": 4, "target": "1) '$FoglioX'.D2:F6<br/>2) D2:D10", "id": 3385850, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3385850/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67241516/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-11T21:05:34.419559Z", "action": 4, "target": "1) $'FoglioX'.D2<br/>2) $D$2", "id": 3385848, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3385848/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67241515/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-11T21:04:53.948735Z", "action": 4, "target": "' L'uso delle virgolette semplici è necessario", "id": 3385845, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3385845/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/67241514/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textsbasicshared03/it/?format=api", "user": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "author": "https://translations.documentfoundation.org/api/users/akurery/?format=api", "timestamp": "2022-07-11T21:04:28.508118Z", "action": 4, "target": "' L'uso delle virgolette semplici è opzionale", "id": 3385843, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3385843/?format=api" } ] }