update translations for master

and force-fix errors using pocheck Change-Id: I6b444d20d156df4126666efaeb30a0902054362b
author: Christian Lohmaier <lohmaier+LibreOffice@googlemail.com> 2018-11-12 23:58:17 +0100
committer: Christian Lohmaier <lohmaier+LibreOffice@googlemail.com> 2018-11-13 00:04:09 +0100
commit: dee42a39ff84aae292b56cf83137983da5c28975 (patch)
tree: d60b875d95ccd2f4b5b2157824ba2b2cebcc7b2a /source/it/helpcontent2
parent: f14221545cf5a1be2c6f74915bcaff29db79a85d (diff)
10 files changed, 596 insertions, 764 deletions
diff --git a/source/it/helpcontent2/source/text/scalc/01.po b/source/it/helpcontent2/source/text/scalc/01.po
index 15497353f04..efff3b3b7f8 100644
--- a/source/it/helpcontent2/source/text/scalc/01.po
+++ b/source/it/helpcontent2/source/text/scalc/01.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: \n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2018-10-21 20:57+0200\n"
+"POT-Creation-Date: 2018-11-12 12:22+0100\n"
 "PO-Revision-Date: 2018-08-24 19:04+0000\n"
 "Last-Translator: Valter Mura <valtermura@gmail.com>\n"
 "Language-Team: Italian <l10n@it.libreoffice.org>\n"
@@ -13909,8 +13909,8 @@ msgctxt ""
 "04060107.xhp\n"
 "bm_id3147273\n"
 "help.text"
-msgid "<bookmark_value>matrices; functions</bookmark_value>  <bookmark_value>Function Wizard; arrays</bookmark_value>  <bookmark_value>array formulas</bookmark_value>  <bookmark_value>inline array constants</bookmark_value>  <bookmark_value>formulas;arrays</bookmark_value>  <bookmark_value>functions;array functions</bookmark_value>  <bookmark_value>editing; array formulas</bookmark_value>  <bookmark_value>copying; array formulas</bookmark_value>  <bookmark_value>adjusting array ranges</bookmark_value>  <bookmark_value>calculating;conditional calculations</bookmark_value>  <bookmark_value>matrices; calculations</bookmark_value>  <bookmark_value>conditional calculations with arrays</bookmark_value>  <bookmark_value>implicit array handling</bookmark_value>  <bookmark_value>forced array handling</bookmark_value>"
-msgstr "<bookmark_value>Matrice; funzioni</bookmark_value> <bookmark_value>Creazione guidata funzione; vettori</bookmark_value> <bookmark_value>Vettore; formule</bookmark_value> <bookmark_value>Inline;vettori di costanti</bookmark_value> <bookmark_value>Formula;vettori</bookmark_value> <bookmark_value>Funzione;funzioni vettoriali</bookmark_value> <bookmark_value>Modificare; formule vettoriali</bookmark_value> <bookmark_value>Copiare; formule vettoriali</bookmark_value> <bookmark_value>Adattare aree dati vettoriali</bookmark_value> <bookmark_value>Calcolare; calcoli condizionali</bookmark_value> <bookmark_value>Matrice; calcoli</bookmark_value> <bookmark_value>Condizionale;calcoli con vettori</bookmark_value> <bookmark_value>Implicita;manipolazione di un vettore</bookmark_value> <bookmark_value>Forzata;manipolazione di un vettore</bookmark_value>"
+msgid "<bookmark_value>matrices; functions</bookmark_value><bookmark_value>Function Wizard; arrays</bookmark_value><bookmark_value>array formulas</bookmark_value><bookmark_value>inline array constants</bookmark_value><bookmark_value>formulas; arrays</bookmark_value><bookmark_value>functions; array functions</bookmark_value><bookmark_value>editing; array formulas</bookmark_value><bookmark_value>copying; array formulas</bookmark_value><bookmark_value>adjusting array ranges</bookmark_value><bookmark_value>calculating; conditional calculations</bookmark_value><bookmark_value>matrices; calculations</bookmark_value><bookmark_value>conditional calculations with arrays</bookmark_value><bookmark_value>implicit array handling</bookmark_value><bookmark_value>forced array handling</bookmark_value>"
+msgstr ""
 
 #: 04060107.xhp
 msgctxt ""
@@ -14101,8 +14101,8 @@ msgctxt ""
 "04060107.xhp\n"
 "par_id3158432\n"
 "help.text"
-msgid "To multiply the values in the individual cells by 10 in the above array, you do not need to apply a formula to each individual cell or value. Instead you just need to use a single array formula. Select a range of 3 x 3 cells on another part of the spreadsheet, enter the formula <item type=\"input\">=10*A1:C3</item> and confirm this entry using the key combination <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Enter. The result is a 3 x 3 array in which the individual values in the cell range (A1:C3) are multiplied by a factor of 10."
-msgstr "Ad esempio, nella matrice qui sopra, per moltiplicare i valori nelle singole celle per 10 non dovrete più creare una formula per ciascuna cella o valore, ma potrete semplicemente utilizzare un'unica formula di matrice. Selezionate un'area di 3 x 3 celle in un'altra parte del foglio elettronico, inserite la formula <item type=\"input\">=10*A1:C3</item> e confermate i valori digitati premendo la combinazione di tasti <switchinline select=\"sys\"><caseinline select=\"MAC\">Comando</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Maiusc+Invio. Il risultato è una matrice 3 x 3 in cui i singoli valori nell'area di celle (A1:C3) sono stati moltiplicati per 10."
+msgid "To multiply the values in the individual cells by 10 in the above array, you do not need to apply a formula to each individual cell or value. Instead you just need to use a single array formula. Select a range of 3 x 3 cells on another part of the spreadsheet, enter the formula <item type=\"input\">=10*A1:C3</item> and confirm this entry using the key combination <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + Shift + Enter</emph>. The result is a 3 x 3 array in which the individual values in the cell range (A1:C3) are multiplied by a factor of 10."
+msgstr ""
 
 #: 04060107.xhp
 msgctxt ""
@@ -14181,8 +14181,8 @@ msgctxt ""
 "04060107.xhp\n"
 "par_id3153392\n"
 "help.text"
-msgid "If you enter the array formula directly into the cell, you must use the key combination Shift+<switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Enter instead of the Enter key. Only then does the formula become an array formula."
-msgstr "Se inserite una formula di matrice direttamente nella cella, dovete utilizzare la combinazione di tasti Maiusc+<switchinline select=\"sys\"><caseinline select=\"MAC\">Comando</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Invio invece del solo tasto Invio. Solo in questo modo la formula diventa una formula di matrice."
+msgid "If you enter the array formula directly into the cell, you must use the key combination <emph>Shift + </emph><switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + Enter</emph> instead of the <emph>Enter</emph> key. Only then does the formula become an array formula."
+msgstr ""
 
 #: 04060107.xhp
 msgctxt ""
@@ -14269,8 +14269,8 @@ msgctxt ""
 "04060107.xhp\n"
 "par_id6757103\n"
 "help.text"
-msgid "To enter this array constant, you select three cells in a row, then you type the formula <item type=\"input\">={1;2;3}</item> using the curly braces and the semicolons, then press <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Enter."
-msgstr "Per inserire questo vettore di costante, selezionate tre celle in una riga, digitate la formula <item type=\"input\">={1;2;3}</item> usando le parentesi graffe e i punti e virgola, quindi premete <switchinline select=\"sys\"><caseinline select=\"MAC\">Comando</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Maiusc+Invio."
+msgid "To enter this array constant, you select three cells in a row, then you type the formula <item type=\"input\">={1;2;3}</item> using the curly braces and the semicolons, then press <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + Shift + Enter</emph>."
+msgstr ""
 
 #: 04060107.xhp
 msgctxt ""
@@ -14333,24 +14333,24 @@ msgctxt ""
 "04060107.xhp\n"
 "par_id3149241\n"
 "help.text"
-msgid "Select the cell range or array containing the array formula. To select the whole array, position the cell cursor inside the array range, then press <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+/, where / is the Division key on the numeric keypad."
-msgstr "Selezionate l'area della cella o della matrice che contiene la formula di matrice. Per selezionare l'intera matrice, posizionate il cursore all'interno dell'area della matrice, quindi premete <switchinline select=\"sys\"><caseinline select=\"MAC\">Comando</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+/, in cui / è il tasto della operazione della divisione nel tastierino numerico."
+msgid "Select the cell range or array containing the array formula. To select the whole array, position the cell cursor inside the array range, then press <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + /</emph>, where <emph>/</emph> is the <emph>Division</emph> key on the numeric keypad."
+msgstr ""
 
 #: 04060107.xhp
 msgctxt ""
 "04060107.xhp\n"
 "par_id3143274\n"
 "help.text"
-msgid "Either press F2 or position the cursor in the input line. Both of these actions let you edit the formula."
-msgstr "Ora premete F2 o posizionate il cursore nella riga di digitazione. Entrambe le azioni hanno lo stesso effetto: adesso potete modificare la formula."
+msgid "Either press <emph>F2</emph> or position the cursor in the input line. Both of these actions let you edit the formula."
+msgstr ""
 
 #: 04060107.xhp
 msgctxt ""
 "04060107.xhp\n"
 "par_id3154798\n"
 "help.text"
-msgid "After you have made changes, press <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Enter."
-msgstr "Dopo che avete eseguito le modifiche, confermate con <switchinline select=\"sys\"><caseinline select=\"MAC\">Comando</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Maiusc+Invio."
+msgid "After you have made changes, press <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + Shift + Enter</emph>."
+msgstr ""
 
 #: 04060107.xhp
 msgctxt ""
@@ -14381,32 +14381,32 @@ msgctxt ""
 "04060107.xhp\n"
 "par_id3154619\n"
 "help.text"
-msgid "Either press F2 or position the cursor in the input line."
-msgstr "Ora premete F2 o posizionate il cursore nella riga di digitazione."
+msgid "Either press <emph>F2</emph> or position the cursor in the input line."
+msgstr ""
 
 #: 04060107.xhp
 msgctxt ""
 "04060107.xhp\n"
 "par_id3150994\n"
 "help.text"
-msgid "Copy the formula into the input line by pressing <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+C."
-msgstr "Copiate la formula dalla riga di digitazione con <switchinline select=\"sys\"><caseinline select=\"MAC\">Comando</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+C."
+msgid "Copy the formula into the input line by pressing <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + C</emph>."
+msgstr ""
 
 #: 04060107.xhp
 msgctxt ""
 "04060107.xhp\n"
 "par_id3146787\n"
 "help.text"
-msgid "Select a range of cells where you want to insert the array formula and either press F2 or position the cursor in the input line."
-msgstr "Selezionate l'area di celle nella quale desiderate inserire la formula di matrice, quindi premete F2 oppure posizionate il cursore nella riga di digitazione."
+msgid "Select a range of cells where you want to insert the array formula and either press <emph>F2</emph> or position the cursor in the input line."
+msgstr ""
 
 #: 04060107.xhp
 msgctxt ""
 "04060107.xhp\n"
 "par_id3154419\n"
 "help.text"
-msgid "Paste the formula by pressing <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+V in the selected space and confirm it by pressing <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Enter. The selected range now contains the array formula."
-msgstr "Incollate la formula nello spazio selezionato premendo <switchinline select=\"sys\"><caseinline select=\"MAC\">Comando</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+V, quindi confermate premendo <switchinline select=\"sys\"><caseinline select=\"MAC\">Comando</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Maiusc+Invio. L'area selezionata contiene ora la formula di matrice."
+msgid "Paste the formula by pressing <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + V</emph> in the selected space and confirm it by pressing <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + Shift + Enter</emph>. The selected range now contains the array formula."
+msgstr ""
 
 #: 04060107.xhp
 msgctxt ""
@@ -14453,8 +14453,8 @@ msgctxt ""
 "04060107.xhp\n"
 "par_id3146080\n"
 "help.text"
-msgid "By holding down the <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> key, you can create a copy of the array formula in the given range."
-msgstr "Tenendo premuto il tasto <switchinline select=\"sys\"><caseinline select=\"MAC\">Comando</caseinline><defaultinline>Ctrl</defaultinline></switchinline>, potete creare una copia della formula di matrice nell'intervallo prestabilito."
+msgid "By holding down the <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline> key, you can create a copy of the array formula in the given range."
+msgstr ""
 
 #: 04060107.xhp
 msgctxt ""
@@ -14853,7 +14853,7 @@ msgctxt ""
 "04060107.xhp\n"
 "par_id3150403\n"
 "help.text"
-msgid "You can also enter the <item type=\"input\">=MUNIT(5)</item> formula in the last cell of the selected range (E5), and press <switchinline select=\"sys\"><caseinline select=\"MAC\"><item type=\"keycode\">Shift+Command+Enter</item>            </caseinline><defaultinline><item type=\"keycode\">Shift+Ctrl+Enter</item></defaultinline></switchinline>."
+msgid "You can also enter the <item type=\"input\">=MUNIT(5)</item> formula in the last cell of the selected range (E5), and press <switchinline select=\"sys\"><caseinline select=\"MAC\"><item type=\"keycode\">Shift + Command + Enter</item></caseinline><defaultinline><item type=\"keycode\">Shift + Ctrl + Enter</item></defaultinline></switchinline>."
 msgstr ""
 
 #: 04060107.xhp
@@ -14885,8 +14885,8 @@ msgctxt ""
 "04060107.xhp\n"
 "par_id3145777\n"
 "help.text"
-msgid "<ahelp hid=\"HID_FUNC_HAEUFIGKEIT\">Indicates the frequency distribution in a one-column-array.</ahelp> The function counts the number of values in the Data array that are within the values given by the Classes array."
-msgstr "<ahelp hid=\"HID_FUNC_HAEUFIGKEIT\">Indica la distribuzione della frequenza in una matrice di una sola colonna.</ahelp> La funzione conta il numero di valori presenti nella matrice Dati che sono inclusi tra i valori della matrice Classi."
+msgid "<ahelp hid=\"HID_FUNC_HAEUFIGKEIT\">Indicates the frequency distribution in a one-column-array.</ahelp> The function counts the number of values in the <emph>Data</emph> array that are within the values given by the <emph>Classes</emph> array."
+msgstr ""
 
 #: 04060107.xhp
 msgctxt ""
@@ -15237,8 +15237,8 @@ msgctxt ""
 "04060107.xhp\n"
 "bm_id3151030\n"
 "help.text"
-msgid "<bookmark_value>MDETERM function</bookmark_value>  <bookmark_value>determinants</bookmark_value>"
-msgstr "<bookmark_value>MATR.DETERM, funzione</bookmark_value> <bookmark_value>Determinante</bookmark_value>"
+msgid "<bookmark_value>MDETERM function</bookmark_value><bookmark_value>determinants</bookmark_value>"
+msgstr ""
 
 #: 04060107.xhp
 msgctxt ""
@@ -15285,8 +15285,8 @@ msgctxt ""
 "04060107.xhp\n"
 "bm_id3151348\n"
 "help.text"
-msgid "<bookmark_value>MINVERSE function</bookmark_value>  <bookmark_value>inverse arrays</bookmark_value>"
-msgstr "<bookmark_value>MATR.INVERSA, funzione</bookmark_value> <bookmark_value>Inversa;matrice</bookmark_value>"
+msgid "<bookmark_value>MINVERSE function</bookmark_value><bookmark_value>inverse arrays</bookmark_value>"
+msgstr ""
 
 #: 04060107.xhp
 msgctxt ""
@@ -15437,8 +15437,8 @@ msgctxt ""
 "04060107.xhp\n"
 "par_id3159366\n"
 "help.text"
-msgid "In the spreadsheet, select the range in which the transposed array can appear. If the original array has n rows and m columns, your selected range must have at least m rows and n columns. Then enter the formula directly, select the original array and press <switchinline select=\"sys\"><caseinline select=\"MAC\">Shift+Command+Enter</caseinline><defaultinline>Shift+Ctrl+Enter</defaultinline></switchinline>. Or, if you are using the <emph>Function Wizard</emph>, mark the <emph>Array</emph> check box. The transposed array appears in the selected target range and is protected automatically against changes."
-msgstr "Nel foglio elettronico, selezionate l'area in cui dovrà comparire la matrice trasposta. Se la matrice originale contiene \"n\" righe e \"m\" colonne, l'area selezionata deve contenere almeno \"m\" righe e \"n\" colonne. Digitate direttamente la formula, selezionate la matrice originale e premete Maiusc+<switchinline select=\"sys\"><caseinline select=\"MAC\">Comando</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Invio. In alternativa, se state usando la <emph>Creazione guidata funzione</emph>, selezionate la casella di controllo <emph>Matrice</emph>. La matrice trasposta compare nell'area di destinazione selezionata e viene protetta automaticamente dalle modifiche."
+msgid "In the spreadsheet, select the range in which the transposed array can appear. If the original array has n rows and m columns, your selected range must have at least m rows and n columns. Then enter the formula directly, select the original array and press <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Shift + Command + Enter</emph></caseinline><defaultinline><emph>Shift + Ctrl + Enter</emph></defaultinline></switchinline>. Or, if you are using the <emph>Function Wizard</emph>, mark the <emph>Array</emph> check box. The transposed array appears in the selected target range and is protected automatically against changes."
+msgstr ""
 
 #: 04060107.xhp
 msgctxt ""
@@ -15461,8 +15461,8 @@ msgctxt ""
 "04060107.xhp\n"
 "par_id3178518\n"
 "help.text"
-msgid "Then <emph>make sure to enter it as matrix formula with </emph><switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Shift+Command+Enter</emph></caseinline><defaultinline><emph>Shift+Ctrl+Enter</emph></defaultinline></switchinline>. The result will be as follows:"
-msgstr "<emph>Assicuratevi, poi, di digitarla come formula matrice con <switchinline select=\"sys\"><caseinline select=\"MAC\">Maiusc+Comando+Invio</caseinline><defaultinline>Maiusc+Ctrl+Invio</defaultinline></switchinline></emph>. Il risultato sarà il seguente:"
+msgid "Then <emph>make sure to enter it as matrix formula with </emph><switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Shift + Command + Enter</emph></caseinline><defaultinline><emph>Shift + Ctrl + Enter</emph></defaultinline></switchinline>. The result will be as follows:"
+msgstr ""
 
 #: 04060107.xhp
 msgctxt ""
@@ -15541,8 +15541,8 @@ msgctxt ""
 "04060107.xhp\n"
 "par_id0811200804502261\n"
 "help.text"
-msgid "LINEST returns a table (array) of statistics as below and must be entered as an array formula (for example by using <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Return rather than just Return)."
-msgstr "REGR.LIN restituisce una tabella (matrice) di statistica come mostrato sotto e deve essere inserita come una formula di matrice (usando, ad esempio, <switchinline select=\"sys\"><caseinline select=\"MAC\">Comando</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Maiusc+Invio anziché soltanto Invio)."
+msgid "LINEST returns a table (array) of statistics as below and must be entered as an array formula (for example by using <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + Shift + Return</emph> rather than just <emph>Return</emph>)."
+msgstr ""
 
 #: 04060107.xhp
 msgctxt ""
@@ -16061,8 +16061,8 @@ msgctxt ""
 "04060107.xhp\n"
 "par_id3158106\n"
 "help.text"
-msgid "The formula in the <emph>Formula</emph> Bar corresponds to each cell of the LINEST array <item type=\"input\">{=LINEST(C2:C8;A2:B8;1;1)}</item>"
-msgstr "La formula che compare nella <emph>barra di calcolo</emph> corrisponde a ogni cella della matrice REGR.LIN <item type=\"input\">{=REGR.LIN(C2:C8;A2:B8;1;1)}</item>"
+msgid "The formula in the <emph>Formula</emph> bar corresponds to each cell of the LINEST array <item type=\"input\">{=LINEST(C2:C8;A2:B8;1;1)}</item>."
+msgstr ""
 
 #: 04060107.xhp
 msgctxt ""
@@ -16077,8 +16077,8 @@ msgctxt ""
 "04060107.xhp\n"
 "bm_id3158146\n"
 "help.text"
-msgid "<bookmark_value>slopes, see also regression lines</bookmark_value>  <bookmark_value>regression lines;LINEST function</bookmark_value>"
-msgstr "<bookmark_value>Pendenza, vedere anche Retta di regressione</bookmark_value> <bookmark_value>Regressione,retta di;funzione REGR.LIN</bookmark_value>"
+msgid "<bookmark_value>slopes, see also regression lines</bookmark_value><bookmark_value>regression lines; LINEST function</bookmark_value>"
+msgstr ""
 
 #: 04060107.xhp
 msgctxt ""
@@ -16101,8 +16101,8 @@ msgctxt ""
 "04060107.xhp\n"
 "bm_id3158204\n"
 "help.text"
-msgid "<bookmark_value>standard errors;array functions</bookmark_value>"
-msgstr "<bookmark_value>Standard,errore; funzioni vettoriali</bookmark_value>"
+msgid "<bookmark_value>standard errors; array functions</bookmark_value>"
+msgstr ""
 
 #: 04060107.xhp
 msgctxt ""
@@ -16253,8 +16253,8 @@ msgctxt ""
 "04060107.xhp\n"
 "bm_id3163286\n"
 "help.text"
-msgid "<bookmark_value>SUMPRODUCT function</bookmark_value>  <bookmark_value>scalar products</bookmark_value>  <bookmark_value>dot products</bookmark_value>  <bookmark_value>inner products</bookmark_value>"
-msgstr "<bookmark_value>MATR.SOMMA.PRODOTTO, funzione</bookmark_value> <bookmark_value>Scalare;prodotto</bookmark_value> <bookmark_value>Punto;prodotto scalare</bookmark_value> <bookmark_value>Interno;prodotto scalare</bookmark_value>"
+msgid "<bookmark_value>SUMPRODUCT function</bookmark_value><bookmark_value>scalar products</bookmark_value><bookmark_value>dot products</bookmark_value><bookmark_value>inner products</bookmark_value>"
+msgstr ""
 
 #: 04060107.xhp
 msgctxt ""
@@ -16277,16 +16277,16 @@ msgctxt ""
 "04060107.xhp\n"
 "par_id3163347\n"
 "help.text"
-msgid "SUMPRODUCT(Array1; Array2...Array30)"
-msgstr "MATR.SOMMA.PRODOTTO(Matrice 1; Matrice 2...Matrice 30)"
+msgid "SUMPRODUCT(Array1; Array2; ...; Array30)"
+msgstr ""
 
 #: 04060107.xhp
 msgctxt ""
 "04060107.xhp\n"
 "par_id3163362\n"
 "help.text"
-msgid "<emph>Array1, Array2...Array30</emph> represent arrays whose corresponding elements are to be multiplied."
-msgstr "<emph>Matrice 1, Matrice 2...Matrice 30</emph> rappresentano le matrici di cui devono essere moltiplicati gli elementi corrispondenti."
+msgid "<emph>Array1, Array2; ...; Array30</emph> represent arrays whose corresponding elements are to be multiplied."
+msgstr ""
 
 #: 04060107.xhp
 msgctxt ""
@@ -16685,24 +16685,24 @@ msgctxt ""
 "04060107.xhp\n"
 "par_id3166196\n"
 "help.text"
-msgid "<emph>LinearType</emph>(Optional). If LinearType = 0, then lines will be calculated through the zero point. Otherwise, offset lines will also be calculated. The default is LinearType <> 0."
-msgstr "<emph>Tipo retta</emph> (opzionale). Se Tipo retta = 0, verranno calcolate le linee che intersecano il punto zero. Diversamente, vengono calcolate anche le linee di scarto. L'impostazione predefinita è Tipo retta <> 0."
+msgid "<emph>LinearType</emph> (optional). If LinearType = 0, then lines will be calculated through the zero point. Otherwise, offset lines will also be calculated. The default is LinearType <> 0."
+msgstr ""
 
 #: 04060107.xhp
 msgctxt ""
 "04060107.xhp\n"
 "par_id3166245\n"
 "help.text"
-msgid "Select a spreadsheet range in which the trend data will appear. Select the function. Enter the output data or select it with the mouse. Mark the <emph>Array</emph> field. click <emph>OK</emph>. The trend data calculated from the output data is displayed."
-msgstr "Selezionate un'area del foglio elettronico in cui dovranno comparire i dati della tendenza. Selezionate la funzione. Digitate o selezionate con il mouse i dati di uscita. Selezionate il campo <emph>Matrice</emph> e fate clic su <emph>OK</emph>. Vengono visualizzati i dati di tendenza calcolati in base ai dati di uscita."
+msgid "Select a spreadsheet range in which the trend data will appear. Select the function. Enter the output data or select it with the mouse. Mark the <emph>Array</emph> field, click <emph>OK</emph>. The trend data calculated from the output data is displayed."
+msgstr ""
 
 #: 04060107.xhp
 msgctxt ""
 "04060107.xhp\n"
 "bm_id3166317\n"
 "help.text"
-msgid "<bookmark_value>GROWTH function</bookmark_value>  <bookmark_value>exponential trends in arrays</bookmark_value>"
-msgstr "<bookmark_value>CRESCITA, funzione</bookmark_value> <bookmark_value>Esponenziale; tendenza in matrici</bookmark_value>"
+msgid "<bookmark_value>GROWTH function</bookmark_value><bookmark_value>exponential trends in arrays</bookmark_value>"
+msgstr ""
 
 #: 04060107.xhp
 msgctxt ""
@@ -16757,16 +16757,16 @@ msgctxt ""
 "04060107.xhp\n"
 "par_id3173817\n"
 "help.text"
-msgid "<emph>FunctionType</emph>(optional). If FunctionType = 0, functions in the form y = m^x will be calculated. Otherwise, y = b*m^x functions will be calculated."
-msgstr "<emph>Tipo funzione</emph> (opzionale). Se Tipo funzione = 0, vengono calcolate le funzioni con forma y = m^x. Diversamente, vengono calcolate le funzioni y = b*m^x."
+msgid "<emph>FunctionType</emph> (optional). If FunctionType = 0, functions in the form y = m^x will be calculated. Otherwise, y = b*m^x functions will be calculated."
+msgstr ""
 
 #: 04060107.xhp
 msgctxt ""
 "04060107.xhp\n"
 "par_id3173852\n"
 "help.text"
-msgid "This function returns an array and is handled in the same way as the other array functions. Select a range where you want the answers to appear and select the function. Select DataY. Enter any other parameters, mark <emph>Array</emph> and click <emph>OK</emph>."
-msgstr "Questa funzione restituisce una matrice e viene gestita allo stesso modo delle altre funzioni di matrice. Selezionare l'area in cui dovranno comparire le risposte e scegliete la funzione. Selezionate Dati Y, digitate gli altri eventuali parametri, selezionate <emph>Matrice</emph> e fate clic su <emph>OK</emph>."
+msgid "This function returns an array and is handled in the same way as the other array functions. Select a range where you want the answers to appear and select the function. Select <emph>DataY</emph>. Enter any other parameters, mark <emph>Array</emph> and click <emph>OK</emph>."
+msgstr ""
 
 #: 04060108.xhp
 msgctxt ""
@@ -24325,8 +24325,8 @@ msgctxt ""
 "04060115.xhp\n"
 "par_id3156294\n"
 "help.text"
-msgid "<emph>UpperLimit</emph> is optional. It is the upper limit of the integral. If this value is missing, the calculation takes places between 0 and the lower limit."
-msgstr "<emph>Limite superiore</emph> è il limite superiore dell'integrale (opzionale). Se questo valore non viene specificato, il calcolo viene eseguito nell'intervallo compreso tra 0 e il limite inferiore."
+msgid "<emph>UpperLimit</emph> is optional. It is the upper limit of the integral. If this value is missing, the calculation takes place between 0 and the lower limit."
+msgstr ""
 
 #: 04060115.xhp
 msgctxt ""
@@ -24373,8 +24373,8 @@ msgctxt ""
 "04060115.xhp\n"
 "par_id2949715\n"
 "help.text"
-msgid "<emph>LowerLimit</emph> is the limit of the integral. The calculation takes places between 0 and this limit."
-msgstr "<emph>Limite inferiore</emph> è il limite inferiore d'integrazione. Il calcolo viene eseguito tra 0 e questo limite."
+msgid "<emph>LowerLimit</emph> is the limit of the integral. The calculation takes place between 0 and this limit."
+msgstr ""
 
 #: 04060115.xhp
 msgctxt ""
@@ -59662,8 +59662,8 @@ msgctxt ""
 "xml_source.xhp\n"
 "hd_id240920171003006302\n"
 "help.text"
-msgid "<link href=\"text/scalc/01/xml_source.xhp\">XML Source (Experimental)</link>"
-msgstr ""
+msgid "<link href=\"text/scalc/01/xml_source.xhp\">XML Source</link>"
+msgstr "<link href=\"text/scalc/01/xml_source.xhp\">Sorgente XML</link>"
 
 #: xml_source.xhp
 msgctxt ""
diff --git a/source/it/helpcontent2/source/text/shared/01.po b/source/it/helpcontent2/source/text/shared/01.po
index 9b55b40a9af..f80578234ee 100644
--- a/source/it/helpcontent2/source/text/shared/01.po
+++ b/source/it/helpcontent2/source/text/shared/01.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: \n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2018-10-21 20:57+0200\n"
+"POT-Creation-Date: 2018-11-12 12:22+0100\n"
 "PO-Revision-Date: 2018-06-10 12:13+0000\n"
 "Last-Translator: Valter Mura <valtermura@gmail.com>\n"
 "Language-Team: Italian <l10n@it.libreoffice.org>\n"
@@ -37968,6 +37968,110 @@ msgctxt ""
 msgid "<link href=\"text/shared/01/packagemanager.xhp\">Extension Manager</link>"
 msgstr "<link href=\"text/shared/01/packagemanager.xhp\">Gestione estensioni</link>"
 
+#: font_features.xhp
+msgctxt ""
+"font_features.xhp\n"
+"tit\n"
+"help.text"
+msgid "OpenType Font Features"
+msgstr ""
+
+#: font_features.xhp
+msgctxt ""
+"font_features.xhp\n"
+"bm_id991541772077660\n"
+"help.text"
+msgid "<bookmark_value>font features</bookmark_value>        <bookmark_value>font features;OpenType</bookmark_value>        <bookmark_value>OpenType;font features</bookmark_value>"
+msgstr ""
+
+#: font_features.xhp
+msgctxt ""
+"font_features.xhp\n"
+"hd_id581541769624076\n"
+"help.text"
+msgid "<link href=\"text/shared/01/font_features.xhp\" name=\"Features\">Font Features</link>"
+msgstr ""
+
+#: font_features.xhp
+msgctxt ""
+"font_features.xhp\n"
+"par_id501541769624078\n"
+"help.text"
+msgid "<variable id=\"variable name\"><ahelp hid=\".\">Select and apply font typographical features to characters.</ahelp></variable>"
+msgstr ""
+
+#: font_features.xhp
+msgctxt ""
+"font_features.xhp\n"
+"par_id661541784477179\n"
+"help.text"
+msgid "Then press <emph>Features...</emph>"
+msgstr ""
+
+#: font_features.xhp
+msgctxt ""
+"font_features.xhp\n"
+"par_id321541773889428\n"
+"help.text"
+msgid "%PRODUCTNAME supports OpenType font format. The two main benefits of the OpenType format are its cross-platform compatibility, and its ability to support widely expanded character sets and layout features, which provide richer linguistic support and advanced typographic control."
+msgstr ""
+
+#: font_features.xhp
+msgctxt ""
+"font_features.xhp\n"
+"par_id531541778397964\n"
+"help.text"
+msgid "OpenType fonts can include an expanded character set and layout features, providing broader linguistic support and more precise typographic control."
+msgstr ""
+
+#: font_features.xhp
+msgctxt ""
+"font_features.xhp\n"
+"par_id31541774826256\n"
+"help.text"
+msgid "The features displayed in the Font Features dialog depends on the selected font."
+msgstr ""
+
+#: font_features.xhp
+msgctxt ""
+"font_features.xhp\n"
+"hd_id81541778714507\n"
+"help.text"
+msgid "Font features box"
+msgstr ""
+
+#: font_features.xhp
+msgctxt ""
+"font_features.xhp\n"
+"par_id991541778707882\n"
+"help.text"
+msgid "The font features box contains the configurable features available for the font."
+msgstr ""
+
+#: font_features.xhp
+msgctxt ""
+"font_features.xhp\n"
+"hd_id511541778721077\n"
+"help.text"
+msgid "Font feature visualization window"
+msgstr ""
+
+#: font_features.xhp
+msgctxt ""
+"font_features.xhp\n"
+"par_id31541778666390\n"
+"help.text"
+msgid "The feature visualization window displays a default text where the selected features can be inspected."
+msgstr ""
+
+#: font_features.xhp
+msgctxt ""
+"font_features.xhp\n"
+"par_id801541774734588\n"
+"help.text"
+msgid "<link href=\"https://en.wikipedia.org/wiki/OpenType\" name=\"OpenType\">Wikipedia on OpenType</link>"
+msgstr ""
+
 #: formatting_mark.xhp
 msgctxt ""
 "formatting_mark.xhp\n"
@@ -39069,8 +39173,8 @@ msgctxt ""
 "moviesound.xhp\n"
 "bm_id1907712\n"
 "help.text"
-msgid "<bookmark_value>inserting;movies/sounds</bookmark_value>         <bookmark_value>sound files</bookmark_value>         <bookmark_value>playing movies and sound files</bookmark_value>         <bookmark_value>videos</bookmark_value>         <bookmark_value>movies</bookmark_value>         <bookmark_value>audio</bookmark_value>         <bookmark_value>music</bookmark_value>"
-msgstr "<bookmark_value>Inserire;filmati/suoni</bookmark_value><bookmark_value>Suono, file</bookmark_value><bookmark_value>Riproduzione di file audio e video</bookmark_value><bookmark_value>Video</bookmark_value><bookmark_value>Filmati</bookmark_value><bookmark_value>Audio</bookmark_value><bookmark_value>Musica</bookmark_value>"
+msgid "<bookmark_value>inserting; movies/sounds</bookmark_value><bookmark_value>sound files</bookmark_value><bookmark_value>playing movies and sound files</bookmark_value><bookmark_value>videos</bookmark_value><bookmark_value>movies</bookmark_value><bookmark_value>audio</bookmark_value><bookmark_value>music</bookmark_value>"
+msgstr ""
 
 #: moviesound.xhp
 msgctxt ""
@@ -39109,16 +39213,16 @@ msgctxt ""
 "moviesound.xhp\n"
 "par_idN1068E\n"
 "help.text"
-msgid "Choose <emph>Insert - Media - Audio or Video</emph>. For %PRODUCTNAME Impress, choose <emph>Insert - Audio or video</emph>."
-msgstr "Scegliete <emph>Inserisci - Media - Audio o video</emph>. Per %PRODUCTNAME Impress, scegliete <emph>Inserisci - Audio o video</emph>."
+msgid "Choose <emph>Insert - Media - Audio or Video</emph>. For %PRODUCTNAME Impress, choose <emph>Insert - Audio or Video</emph>."
+msgstr ""
 
 #: moviesound.xhp
 msgctxt ""
 "moviesound.xhp\n"
 "par_idN10696\n"
 "help.text"
-msgid "In the File Open dialog, select the file that you want to insert."
-msgstr "Nella finestra di dialogo Apri file, selezionate il file che volete inserire."
+msgid "In the <emph>File Open</emph> dialog, select the file that you want to insert."
+msgstr ""
 
 #: moviesound.xhp
 msgctxt ""
@@ -39149,8 +39253,8 @@ msgctxt ""
 "moviesound.xhp\n"
 "par_id0120200912190948\n"
 "help.text"
-msgid "Alternatively, you can choose <item type=\"menuitem\">Tools - Media Player</item> to open the Media Player. Use the Media Player to preview all supported media files. Click the Apply button in the Media Player window to insert the current media file into your document."
-msgstr "Altrimenti potete scegliere <item type=\"menuitem\">Strumenti - Riproduttore multimediale</item> per aprire il riproduttore multimediale. Utilizzatelo per vedere in anteprima tutti i file multimediali supportati. Nella finestra Riproduttore multimediale, fate clic sul pulsante Applica per inserire all'interno del documento il file multimediale selezionato."
+msgid "Alternatively, you can choose <emph>Tools - Media Player</emph> to open the Media Player. Use the Media Player to preview all supported media files. Click the <emph>Apply</emph> button in the Media Player window to insert the current media file into your document."
+msgstr ""
 
 #: moviesound.xhp
 msgctxt ""
@@ -39173,8 +39277,8 @@ msgctxt ""
 "moviesound.xhp\n"
 "par_id0120200912190940\n"
 "help.text"
-msgid "If the icon is arranged on the background, hold down Ctrl while you click."
-msgstr "Se l'icona è sistemata nello sfondo, tenete premuto Ctrl quando fate clic."
+msgid "If the icon is arranged on the background, hold down <emph>Ctrl</emph> while you click."
+msgstr ""
 
 #: moviesound.xhp
 msgctxt ""
@@ -39205,8 +39309,8 @@ msgctxt ""
 "moviesound.xhp\n"
 "par_idN106D0\n"
 "help.text"
-msgid "You can also use the Media Playback Bar to pause, to stop, to loop, as well as to adjust the volume or to mute the playback of the file. The current playback position in the file is indicated on the left slider. Use the right slider to adjust the playback volume. For movie files, the bar also contains a list box where you can select the zoom factor for the playback."
-msgstr "Potete inoltre utilizzare la barra Riproduzione disco per interrompere temporaneamente, fermare o ripetere la riproduzione del file, nonché per regolare il volume o azzerare l'audio. Il cursore a scorrimento sulla sinistra mostra la posizione di riproduzione attuale nel file. Il cursore a destra consente invece di regolare il volume di riproduzione. Per i filmati, la barra include anche una casella di riepilogo dalla quale potete selezionare il fattore di zoom per la riproduzione."
+msgid "You can also use the <emph>Media Playback</emph> bar to pause, to stop, to loop, as well as to adjust the volume or to mute the playback of the file. The current playback position in the file is indicated on the left slider. Use the right slider to adjust the playback volume. For movie files, the bar also contains a list box where you can select the zoom factor for the playback."
+msgstr ""
 
 #: moviesound.xhp
 msgctxt ""
@@ -39229,16 +39333,16 @@ msgctxt ""
 "moviesound.xhp\n"
 "par_id231511209745892\n"
 "help.text"
-msgid "<emph>For Microsoft Windows</emph>: %PRODUCTNAME can open anything for which <emph>DirectShow</emph> filters are installed (<link href=\"http://msdn.microsoft.com/en-us/library/ms787745%28VS.85%29.aspx\" name=\"linkname\">list of default formats</link>)."
-msgstr "<emph>In Microsoft Windows</emph>: %PRODUCTNAME è in grado di aprire qualsiasi formato supportato dai filtri installati con <emph>DirectShow</emph> (<link href=\"http://msdn.microsoft.com/en-us/library/ms787745%28VS.85%29.aspx\" name=\"linkname\">elenco dei formati predefiniti, in inglese</link>)."
+msgid "<emph>For Microsoft Windows</emph>: %PRODUCTNAME can open anything for which <emph>DirectShow</emph> filters are installed (<link href=\"https://msdn.microsoft.com/en-us/library/ms787745%28VS.85%29.aspx\" name=\"linkname\">list of default formats</link>)."
+msgstr ""
 
 #: moviesound.xhp
 msgctxt ""
 "moviesound.xhp\n"
 "par_id601511209768414\n"
 "help.text"
-msgid "<emph>For GNU/Linux</emph>: %PRODUCTNAME uses <emph>gstreamer</emph>, so whatever you can play using gstreamer can be used with %PRODUCTNAME (<link href=\"http://gstreamer.freedesktop.org/data/doc/gstreamer/head/pwg/html/section-types-definitions.html\" name=\"linkname\">list of defined types</link>)."
-msgstr "<emph>In GNU/Linux</emph>: %PRODUCTNAME usa <emph>gstreamer</emph>, dunque tutto quello che sarà riproducibile utilizzando gstreamer sarà fruibile in %PRODUCTNAME (<link href=\"http://gstreamer.freedesktop.org/data/doc/gstreamer/head/pwg/html/section-types-definitions.html\" name=\"linkname\">elenco dei tipi definiti, in inglese</link>)."
+msgid "<emph>For GNU/Linux</emph>: %PRODUCTNAME uses <emph>gstreamer</emph>, so whatever you can play using gstreamer can be used with %PRODUCTNAME (<link href=\"https://gstreamer.freedesktop.org/documentation/plugin-development/advanced/media-types.html#list-of-defined-types\" name=\"linkname\">list of defined types</link>)."
+msgstr ""
 
 #: moviesound.xhp
 msgctxt ""
@@ -39253,16 +39357,16 @@ msgctxt ""
 "moviesound.xhp\n"
 "par_id391511209364018\n"
 "help.text"
-msgid "<link href=\"http://msdn.microsoft.com/en-us/library/ms787745%28VS.85%29.aspx\" name=\"linkname\">List of default formats for Microsoft Windows DirectShow </link>."
-msgstr "<link href=\"http://msdn.microsoft.com/en-us/library/ms787745%28VS.85%29.aspx\" name=\"linkname\">Elenco dei formati predefiniti per Microsoft Windows DirectShow </link> (in inglese)."
+msgid "<link href=\"https://msdn.microsoft.com/en-us/library/ms787745%28VS.85%29.aspx\" name=\"linkname\">List of default formats for Microsoft Windows DirectShow</link>."
+msgstr ""
 
 #: moviesound.xhp
 msgctxt ""
 "moviesound.xhp\n"
 "par_id921511209448360\n"
 "help.text"
-msgid "<link href=\"http://gstreamer.freedesktop.org/data/doc/gstreamer/head/pwg/html/section-types-definitions.html\" name=\"linkname\">List of defined types for gstreamer in GNU/Linux </link>."
-msgstr "<link href=\"http://gstreamer.freedesktop.org/data/doc/gstreamer/head/pwg/html/section-types-definitions.html\" name=\"linkname\">Elenco dei tipi definiti per gstreamer in GNU/Linux</link> (in inglese)."
+msgid "<link href=\"https://gstreamer.freedesktop.org/documentation/plugin-development/advanced/media-types.html#list-of-defined-types\" name=\"linkname\">List of defined types for gstreamer in GNU/Linux</link>."
+msgstr ""
 
 #: moviesound.xhp
 msgctxt ""
diff --git a/source/it/helpcontent2/source/text/shared/02.po b/source/it/helpcontent2/source/text/shared/02.po
index 10422f92b06..b8dae96c654 100644
--- a/source/it/helpcontent2/source/text/shared/02.po
+++ b/source/it/helpcontent2/source/text/shared/02.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: \n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2018-09-07 12:46+0200\n"
+"POT-Creation-Date: 2018-11-05 17:38+0100\n"
 "PO-Revision-Date: 2018-06-10 21:22+0000\n"
 "Last-Translator: Valter Mura <valtermura@gmail.com>\n"
 "Language-Team: Italian <l10n@it.libreoffice.org>\n"
@@ -885,8 +885,8 @@ msgctxt ""
 "01170000.xhp\n"
 "par_id3149123\n"
 "help.text"
-msgid "<ahelp hid=\".uno:RadioButton\">Creates an option button.</ahelp> Option buttons enable the user to choose one of several options. Option buttons with the same functionality are given the same name (<link href=\"text/shared/02/01170101.xhp\" name=\"Name\"><emph>Name</emph></link><emph>property</emph>). Normally, they are given a <link href=\"text/shared/02/01170000.xhp\" name=\"group box\">group box</link>."
-msgstr "<ahelp hid=\".uno:RadioButton\">Crea un pulsante di scelta.</ahelp> I pulsanti di scelta permettono di scegliere una delle diverse opzioni disponibili. I pulsanti di scelta con la stessa funzionalità vengono identificati con lo stesso nome (<link href=\"text/shared/02/01170101.xhp\" name=\"Nome\"><emph>Nome</emph></link><emph>proprietà</emph>). Normalmente, questi pulsanti vengono associati a una <link href=\"text/shared/02/01170000.xhp\" name=\"casella di gruppo\">casella di gruppo</link>."
+msgid "<ahelp hid=\".uno:RadioButton\">Creates an option button.</ahelp> Option buttons enable the user to choose one of several options. Option buttons with the same functionality are given the same name (<link href=\"text/shared/02/01170101.xhp\" name=\"Name\"><emph>Name</emph></link> <emph>property</emph>). Normally, they are given a <link href=\"text/shared/02/01170000.xhp\" name=\"group box\">group box</link>."
+msgstr ""
 
 #: 01170000.xhp
 msgctxt ""
@@ -15509,8 +15509,8 @@ msgctxt ""
 "18030000.xhp\n"
 "par_id3150040\n"
 "help.text"
-msgid "<image src=\"cmd/sc_spellonline.png\" id=\"img_id3150808\"><alt id=\"alt_id3150808\">Icon</alt></image>"
-msgstr "<image src=\"cmd/sc_spellonline.png\" id=\"img_id3150808\"><alt id=\"alt_id3150808\">Icona</alt></image>"
+msgid "<image src=\"cmd/sc_spellonline.png\" id=\"img_id3150808\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3150808\">Automatic Spell Checking On/Off</alt></image>"
+msgstr ""
 
 #: 18030000.xhp
 msgctxt ""
diff --git a/source/it/helpcontent2/source/text/shared/explorer/database.po b/source/it/helpcontent2/source/text/shared/explorer/database.po
index 4d442d826ce..ac016526e20 100644
--- a/source/it/helpcontent2/source/text/shared/explorer/database.po
+++ b/source/it/helpcontent2/source/text/shared/explorer/database.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: \n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2018-05-16 16:54+0200\n"
+"POT-Creation-Date: 2018-11-05 17:38+0100\n"
 "PO-Revision-Date: 2018-07-26 20:32+0000\n"
 "Last-Translator: serval2412 <serval2412@yahoo.fr>\n"
 "Language-Team: Italian <l10n@it.libreoffice.org>\n"
@@ -13,7 +13,7 @@ msgstr ""
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=2; plural=(n != 1);\n"
 "X-Accelerator-Marker: ~\n"
-"X-Generator: Pootle 2.8\n"
+"X-Generator: LibreOffice\n"
 "X-POOTLE-MTIME: 1532637125.000000\n"
 
 #: 02000000.xhp
@@ -45,8 +45,8 @@ msgctxt ""
 "02000000.xhp\n"
 "par_id3150499\n"
 "help.text"
-msgid "A \"query\" is a special view of a table. A query can display chosen records or chosen fields within records; it can also sort those records. A query can apply to one table to multiple tables, if they are linked by common data fields."
-msgstr "Una \"ricerca\" è una vista speciale di una tabella. Le ricerche permettono di visualizzare determinati record o un sottoinsieme di campi di ogni record e, se necessario, di ordinare le voci visualizzate. Ogni ricerca può essere applicata a una sola tabella o a più tabelle collegate da campi di dati comuni."
+msgid "A \"query\" is a special view of a table. A query can display chosen records or chosen fields within records; it can also sort those records. A query can apply to one table or to multiple tables, if they are linked by common data fields."
+msgstr ""
 
 #: 02000000.xhp
 msgctxt ""
@@ -405,8 +405,8 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3150255\n"
 "help.text"
-msgid "The lower pane of the Design View is where you <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"define\">define</link> the query. To define a query, specify the database <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"field names\">field names</link> to include and the <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"criteria\">criteria</link> for displaying the fields. To rearrange the columns in the lower pane of the Design View, drag a column header to a new location, or select the column and press <switchinline select=\"sys\"><caseinline select=\"MAC\">Command </caseinline><defaultinline>Ctrl</defaultinline></switchinline>+arrow key."
-msgstr "La parte inferiore della vista struttura è l'area in cui potete <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"definire\">definire</link> la ricerca. A tale scopo, specificate i <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"nomi dei campi\">nomi dei campi</link> del database da includere e i <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"criteri\">criteri</link> per la loro visualizzazione. Per ridisporre le colonne nella parte inferiore della vista struttura, trascinate l'intestazione di una colonna nella posizione desiderata, oppure selezionate la colonna e premete <switchinline select=\"sys\"><caseinline select=\"MAC\">Comando </caseinline><defaultinline>Ctrl</defaultinline></switchinline>+tasto freccia."
+msgid "The lower pane of the Design View is where you <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"define\">define</link> the query. To define a query, specify the database <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"field names\">field names</link> to include and the <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"criteria\">criteria</link> for displaying the fields. To rearrange the columns in the lower pane of the Design View, drag a column header to a new location, or select the column and press <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+arrow key."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -581,16 +581,16 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3152577\n"
 "help.text"
-msgid "If, for example, you have a spreadsheet for articles identified by an article number, and a spreadsheet for customers in which you record all articles that a customer orders using the corresponding article numbers, then there is a relationship between the two \"article number\" data fields. If you now want to create a query that returns all articles that a customer has ordered, you must retrieve data from two spreadsheets. To do this, you must tell $[officename] what the relationship exists between the data in the two spreadsheets."
-msgstr "Se, ad esempio, usate un foglio elettronico per gli articoli, in cui ognuno viene identificato da un numero di codice, e un altro foglio elettronico per i clienti, nel quale registrate tutti gli articoli ordinati da ogni cliente usando i rispettivi numeri di codice, esiste una relazione tra i due campi di dati \"numero di codice\". Se volete creare una ricerca che restituisca tutti gli articoli ordinati da un cliente, dovete richiamare i dati di entrambi i fogli elettronici. A tale scopo, dovete indicare a $[officename] il tipo di relazione esistente tra i dati dei due fogli elettronici."
+msgid "If, for example, you have a spreadsheet for articles identified by an article number, and a spreadsheet for customers in which you record all articles that a customer orders using the corresponding article numbers, then there is a relationship between the two \"article number\" data fields. If you now want to create a query that returns all articles that a customer has ordered, you must retrieve data from two spreadsheets. To do this, you must inform $[officename] about the relationship which exists between the data in the two spreadsheets."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
 "par_id3155302\n"
 "help.text"
-msgid "To do this, click a field name in a table (for example, the field name \"Item-Number\" from the Customer table), hold down the mouse button and then drag the field name to the field name of the other table (\"Item-Number\" from the Item table). When you release the mouse button, a line connecting the two fields in the two windows appears. The corresponding condition that the content of the two field names must be identical is entered in the resulting SQL query."
-msgstr "Per eseguire questa operazione fate clic su un campo di dati di una tabella (ad esempio il campo di dati \"Numero articolo\" nella tabella clienti) e trascinate con il mouse il campo di dati nell'altra tabella (\"Numero articolo\" nella tabella articoli). Rilasciando ora il pulsante del mouse, viene visualizzata una linea che collega i due campi nelle due finestre. Nella risultante ricerca SQL viene inserita la condizioni in base alla quale il contenuto di entrambi i campi di dati deve essere identico."
+msgid "To do this, click a field name in a table (for example, the field name \"Item-Number\" from the Customer table), hold down the mouse button and then drag the field name to the field name of the other table (\"Item-Number\" from the Item table). When you release the mouse button, a line connecting the two fields between the two table windows appears. The corresponding condition that the content of the two field names must be identical is entered in the resulting SQL query."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -613,16 +613,16 @@ msgctxt ""
 "02010100.xhp\n"
 "hd_id3153279\n"
 "help.text"
-msgid "Specifying link type"
-msgstr "Stabilire il tipo di collegamento"
+msgid "Specifying the relation type"
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
 "par_id3154791\n"
 "help.text"
-msgid "If you double-click the line connecting two linked fields or call the menu command <emph>Insert - New Relation</emph>, you can specify the type of link in the <link href=\"text/shared/explorer/database/02010101.xhp\" name=\"Relations\"><emph>Relations</emph></link> dialog."
-msgstr "Facendo doppio clic sulla linea che collega due campi correlati tra loro, o richiamando il comando <emph>Inserisci - Nuova relazione</emph>, potete specificare il tipo di collegamento desiderato nella finestra di dialogo <link href=\"text/shared/explorer/database/02010101.xhp\" name=\"Relazioni\"><emph>Relazioni</emph></link>."
+msgid "If you double-click on the line connecting two linked fields or call the menu command <emph>Insert - New Relation</emph>, you can specify the type of relation in the <link href=\"text/shared/explorer/database/02010101.xhp\" name=\"Relations\"><emph>Relations</emph></link> dialog."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -661,8 +661,8 @@ msgctxt ""
 "02010100.xhp\n"
 "hd_id3151208\n"
 "help.text"
-msgid "Define query"
-msgstr "Definire la ricerca"
+msgid "Defining the query"
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -677,16 +677,16 @@ msgctxt ""
 "02010100.xhp\n"
 "hd_id3154161\n"
 "help.text"
-msgid "Specify field name"
-msgstr "Stabilite i campi di dati"
+msgid "Specifying field names"
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
 "par_id3146791\n"
 "help.text"
-msgid "First, select all field names from the tables that you want to add to the query. You can do this either with drag-and-drop or by double-clicking a field name in the table window. With the drag-and-drop method, use the mouse to drag a field name from the table window into the lower area of the query design. As you do this, you can decide which column you want to add the field to. Select a field name by double-clicking. It will then be added to the next free column."
-msgstr "Per prima cosa, selezionate i nomi dei campi delle tabelle che volete usare per la ricerca. Potete usare il metodo Drag&Drop oppure fare doppio clic sui nomi dei campi nella finestra della tabella. Per usare il metodo Drag&Drop, trascinate con il mouse il nome di un campo dalla finestra della tabella alla parte inferiore della struttura ricerca. Con questo procedimento potete decidere durante l'operazione a quale colonna aggiungere il campo. Selezionate il nome di un campo con un doppio clic. Il campo così selezionato verrà aggiunto alla prima colonna libera."
+msgid "First, select all field names from the tables that you want to add to the query. You can do this either by drag-and-drop or by double-clicking a field name in the table window. With the drag-and-drop method, use the mouse to drag a field name from the table window into the lower area of the query design window. As you do this, you can decide which column in the query design window will receive the selected field. A field name can also be selected by double-clicking. It will then be added to the next free column in the query design window."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -709,16 +709,16 @@ msgctxt ""
 "02010100.xhp\n"
 "hd_id3155764\n"
 "help.text"
-msgid "Save query"
-msgstr "Salvate la ricerca"
+msgid "Saving the query"
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
 "par_id3148481\n"
 "help.text"
-msgid "Use the <emph>Save</emph> icon on the Standard Bar to save the query. You see a dialog that asks you to enter a name for the query. If the database supports schemas, you can also enter a schema."
-msgstr "Facendo clic sull'icona <emph>Salva</emph> della barra standard, la ricerca viene salvata. Viene visualizzata una finestra di dialogo in cui dovete inserire il nome della ricerca. Se il database supporta gli schemi, potete inserire anche uno schema:"
+msgid "Use the <emph>Save</emph> icon on the Standard toolbar to save the query. You will see a dialog that asks you to enter a name for the query. If the database supports schemas, you can also enter a schema name."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -765,8 +765,8 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3154964\n"
 "help.text"
-msgid "To filter data for the query, set the desired preferences in the lower area of the Design View. The following lines are available:"
-msgstr "Per filtrare i dati per la ricerca, impostate le preferenze desiderate nell'area inferiore della vista Struttura. Sono disponibili le seguenti righe:"
+msgid "To filter data for the query, set the desired criteria in the lower area of the query design window. The following options are available:"
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -781,8 +781,8 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3156372\n"
 "help.text"
-msgid "<ahelp hid=\"HID_QRYDGN_ROW_FIELD\">Enter the name of the data field that you referred to in the Query. All settings made in the lower rows refer to this field.</ahelp> If you activate a cell with a mouse click you'll see an arrow button, which enables you to select a field. The \"Table name.*\" option selects all data fields and the criteria is valid for all table fields."
-msgstr "<ahelp hid=\"HID_QRYDGN_ROW_FIELD\">Inserire il nome del campo di dati a cui fa riferimento la ricerca. Tutte le impostazioni definite nelle righe inferiori faranno riferimento a questo campo.</ahelp> Attivando una cella con un clic del mouse compare un pulsante a freccia che permette di selezionare un campo. L'opzione \"Nome tabella.*\" seleziona tutti i campi di dati e applica i criteri a tutti i campi della tabella."
+msgid "<ahelp hid=\"HID_QRYDGN_ROW_FIELD\">Enter the name of the data field that is referred to in the Query. All settings made in the filter option rows refer to this field.</ahelp> If you activate a cell here with a mouse click you'll see an arrow button, which enables you to select a field. The \"Table name.*\" option selects all data fields with the effect that the specified criteria will be applied to all table fields."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -797,16 +797,16 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3146315\n"
 "help.text"
-msgid "<ahelp hid=\"HID_QRYDGN_ROW_ALIAS\">Specifies an alias. This alias will be listed in a query instead of the field name. This makes it possible to use user-defined column labels.</ahelp> For example, if the data field has the name PtNo and, instead of that name, you would like to have PartNum appear in the query, enter PartNum as alias."
-msgstr "<ahelp hid=\"HID_QRYDGN_ROW_ALIAS\">È possibile specificare un alias per il campo. L'alias definito viene visualizzato nella ricerca al posto del nome del campo. Questa funzione permette di usare intestazioni personalizzate per le colonne.</ahelp> Se, ad esempio, il nome del campo dati è NumArt e volete invece che nella ricerca, al posto di questo nome, compaia il nome NumeroArticolo, potete specificare quest'ultimo come alias."
+msgid "<ahelp hid=\"HID_QRYDGN_ROW_ALIAS\">Specifies an alias. This alias will be listed in the query instead of the field name. This makes it possible to use user-defined column labels.</ahelp> For example, if the data field is named PtNo and, instead of that name, you would like to have PartNum appear in the query, enter PartNum as the alias."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
 "par_id3155959\n"
 "help.text"
-msgid "In an SQL statement, aliases are defined as following:"
-msgstr "In un'istruzione SQL gli alias vengono definiti nel modo seguente:"
+msgid "In a SQL statement, aliases are defined as follows:"
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -845,8 +845,8 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3163665\n"
 "help.text"
-msgid "<ahelp hid=\"HID_QRYDGN_ROW_TABLE\">The corresponding database table of the selected data field is listed here.</ahelp> If you activate the a cell with a mouse click, an arrow will appear which enables you to select another table of the current query."
-msgstr "<ahelp hid=\"HID_QRYDGN_ROW_TABLE\">Qui compare la tabella del database corrispondente al campo dati selezionato.</ahelp> Attivando una cella con un clic del mouse, compare una freccia che permette di selezionare un'altra tabella della ricerca attuale."
+msgid "<ahelp hid=\"HID_QRYDGN_ROW_TABLE\">The corresponding database table of the selected data field is listed here.</ahelp> If you activate this cell with a mouse click, an arrow will appear which enables you to select a different table for the current query."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -861,8 +861,8 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3150979\n"
 "help.text"
-msgid "<ahelp hid=\"HID_QRYDGN_ROW_ORDER\">If you click the cell, you can select among the sorting options: ascending, descending and not sorted.</ahelp> Text fields will be sorted alphabetically and numerical fields numerically. For most databases, administrators can set the sorting options."
-msgstr "<ahelp hid=\"HID_QRYDGN_ROW_ORDER\">Se si fa clic sulla cella, è possibile scegliere diverse opzioni di ordinamento: ascendente, discendente e non ordinata.</ahelp> I campi di testo saranno ordinati alfabeticamente e quelli numerici numericamente. Gli amministratori possono impostare le opzioni di ordinamento per la maggior parte dei database."
+msgid "<ahelp hid=\"HID_QRYDGN_ROW_ORDER\">If you click on this cell, you can choose a sort option: ascending, descending and unsorted.</ahelp> Text fields will be sorted alphabetically and numerical fields numerically. For most databases, administrators can set the sorting options at the database level."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -877,8 +877,8 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3146133\n"
 "help.text"
-msgid "<ahelp hid=\"HID_QRYDGN_ROW_VISIBLE\">If you mark the <emph>Visible</emph> property for a data field, that field will be visible in the query</ahelp>. If you only use a data field to formulate a condition, you do not necessarily need to show it."
-msgstr "<ahelp hid=\"HID_QRYDGN_ROW_VISIBLE\">Se si seleziona la proprietà <emph>Visibile</emph> per un campo di dati, questo sarà visibile anche nella ricerca</ahelp>. Se utilizzate il campo di dati solo per la formulazione di una condizione, non è necessario sia visibile per la ricerca."
+msgid "<ahelp hid=\"HID_QRYDGN_ROW_VISIBLE\">If you mark the <emph>Visible</emph> property for a data field, that field will be visibly displayed in the resulting query</ahelp>. If you are only using a data field to formulate a condition or make a calculation, you do not necessarily need to display it."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -893,8 +893,8 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3145134\n"
 "help.text"
-msgid "<ahelp hid=\"HID_QRYDGN_ROW_CRIT\">Specifies the <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"criteria \">criteria </link>by which the content of the data field should be filtered.</ahelp>"
-msgstr "<ahelp hid=\"HID_QRYDGN_ROW_CRIT\">Specifica i <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"criteri\">criteri</link> in base ai quali dovrà essere filtrato il contenuto del campo dati.</ahelp>"
+msgid "<ahelp hid=\"HID_QRYDGN_ROW_CRIT\">Specifies a first <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"criteria \">criteria </link>by which the content of the data field is to be filtered.</ahelp>"
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -909,16 +909,16 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3154585\n"
 "help.text"
-msgid "Here you can enter one additional criterion for filtering in each line. Multiple criteria in one column will be connected by an OR link."
-msgstr "In questa cella potete digitare in ogni riga un ulteriore criterio per il filtro. Più criteri in una colonna vengono collegati con o."
+msgid "Here you can enter one additional filter criterion for each line. Multiple criteria in a single column will be interpreted as boolean OR."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
 "par_id3148800\n"
 "help.text"
-msgid "You can also use the context menu of the line headers in the lower area of the query design to insert another line for functions:"
-msgstr "Inoltre tramite il menu di contesto delle intestazioni delle righe potete inserire un'ulteriore riga per le funzioni nell'area inferiore della struttura ricerca:"
+msgid "You can also use the context menu of the line headers in the lower area of the query design window to insert a filter based on a function:"
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -933,16 +933,16 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3153233\n"
 "help.text"
-msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\" visibility=\"hidden\">Select a function to run in the query here.</ahelp> The functions you can run here depend on the database."
-msgstr "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\" visibility=\"hidden\">Qui è possibile selezionare una funzione che deve essere eseguita nella ricerca.</ahelp> In una ricerca potete eseguire funzioni, tuttavia le diverse possibilità dipendono dal sistema database utilizzato."
+msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\" visibility=\"hidden\">Select a function to run in the query.</ahelp> The functions which are available here depend on those provided by the database engine."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
 "par_id8760818\n"
 "help.text"
-msgid "If you are working with the HSQL database, the list box in the <emph>Function</emph> row offers you the following options:"
-msgstr "Se state lavorando con dei database HSQL, la casella di riepilogo nella riga <emph>Funzione</emph> vi offre le seguenti opzioni:"
+msgid "If you are working with the embedded HSQL database, the list box in the <emph>Function</emph> row offers you the following options:"
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -955,14 +955,6 @@ msgstr "Opzione"
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
-"par_id3166430\n"
-"help.text"
-msgid "SQL"
-msgstr "SQL"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
 "par_id3152993\n"
 "help.text"
 msgid "Effect"
@@ -995,14 +987,6 @@ msgstr "Media"
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
-"par_id3145268\n"
-"help.text"
-msgid "AVG"
-msgstr "AVG"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
 "par_id3154486\n"
 "help.text"
 msgid "Calculates the arithmetic mean of a field."
@@ -1019,18 +1003,10 @@ msgstr "Conteggio"
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
-"par_id3154260\n"
-"help.text"
-msgid "COUNT"
-msgstr "COUNT"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
 "par_id3155810\n"
 "help.text"
-msgid "Determines the number of records in the table. Empty fields can either be counted (a) or not (b)."
-msgstr "Determina il numero di record della tabella. I campi vuoti possono essere conteggiati (a) o non conteggiati (b)."
+msgid "Determines the number of records in the table. Empty fields can either be counted (a) or excluded (b)."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -1045,8 +1021,8 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3152889\n"
 "help.text"
-msgid "b) COUNT(column): Passing a field name as an argument counts only fields in which the field name in question contains a value. Null values (empty fields) will not be counted."
-msgstr "b) COUNT(column): se indicate un campo di dati, vengono contati solo i campi in cui il rispettivo campo di dati contiene un valore. I valori pari a zero (campi vuoti) non vengono inclusi nel conteggio."
+msgid "b) COUNT(column): Passing a field name as an argument counts only those records for fields in which the field name in question contains a value. Records with fields having Null values (i.e. fields containing no characters) will not be counted."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -1059,18 +1035,10 @@ msgstr "Massimo"
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
-"par_id3148840\n"
-"help.text"
-msgid "MAX"
-msgstr "MAX"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
 "par_id3159221\n"
 "help.text"
-msgid "Determines the highest value of a field."
-msgstr "Rileva il valore massimo di un campo."
+msgid "Determines the highest value of a record for that field."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -1083,18 +1051,10 @@ msgstr "Minimo."
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
-"par_id3148604\n"
-"help.text"
-msgid "MIN"
-msgstr "MIN"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
 "par_id3157982\n"
 "help.text"
-msgid "Determines the lowest value of a field."
-msgstr "Rileva il valore minimo di un campo."
+msgid "Determines the lowest value of a record for that field."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -1107,18 +1067,10 @@ msgstr "Somma"
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
-"par_id3147070\n"
-"help.text"
-msgid "SUM"
-msgstr "SUM"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
 "par_id3154536\n"
 "help.text"
-msgid "Calculates the sum of values of associated fields."
-msgstr "Calcola la somma dei valori del campo."
+msgid "Calculates the sum of the values of records for the associated fields."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -1131,18 +1083,10 @@ msgstr "Gruppo"
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
-"par_id3145375\n"
-"help.text"
-msgid "GROUP BY"
-msgstr "GROUP BY"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
 "par_id3149438\n"
 "help.text"
-msgid "Groups query data according to the field name selected. Functions are executed according to the specified groups. In SQL, this option corresponds to the GROUP BY clause. If a criterion is added, this entry appears in the SQL HAVING."
-msgstr "Raggruppa i dati della ricerca in base al nome del campo selezionato. Le funzioni vengono eseguite in base ai gruppi specificati. In SQL, questa opzione corrisponde alla clausola GROUP BY. Aggiungendo un criterio, la nuova voce compare in SQL HAVING."
+msgid "Groups query data according to the selected field name. Functions are executed according to the specified groups. In SQL, this option corresponds to the GROUP BY clause. If a criterion is added, this entry appears in the SQL HAVING sub-clause."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -1181,24 +1125,24 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3159205\n"
 "help.text"
-msgid "Except for the <emph>Group</emph> function, the above functions are so-called Aggregate functions. These are functions that calculate data to create summaries from the results. Additional functions that are not listed in the list box might be also possible. These depend on the specific database system in use and on the current state of the Base driver."
-msgstr "Fatta eccezione per la funzione <emph>Gruppo</emph>, le funzioni sopra elencate sono le cosiddette funzioni aggregate. Si tratta di funzioni che raggruppano i dati in risultati tramite un calcolo. Sono inoltre possibili anche altre funzioni, che non sono elencate nella casella di riepilogo. Queste dipendono dagli specifici sistemi database utilizzati dall'utente e dallo stato dei driver di Base."
+msgid "Except for the <emph>Group</emph> function, the above functions are called Aggregate functions. These are functions that calculate data to create summaries from the results. Additional functions that are not listed in the list box might be also possible. These depend on the specific database engine in use and on the current functionality provided by the Base driver used to connect to that database engine."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
 "par_id3148651\n"
 "help.text"
-msgid "To use other functions not listed in the list box, you must enter them under <emph>Field</emph>."
-msgstr "Per utilizzare le altre funzioni non elencate, dovete immetterle come <emph>campi</emph>."
+msgid "To use other functions not listed in the list box, you must enter them manually under <emph>Field</emph>."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
 "par_id3155098\n"
 "help.text"
-msgid "You can also assign aliases to function calls. If the query is not to be displayed in the column header, enter the desired name under <emph>Alias</emph>."
-msgstr "Per avviare la funzione potete utilizzare nomi alias. Se la ricerca non deve visualizzare la funzione nell'intestazione di colonna, digitate il nome desiderato in <emph>Alias</emph>."
+msgid "You can also assign aliases to function calls. If you not wish the query string to be displayed in the column header, enter a desired substitute name under <emph>Alias</emph>."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -1237,8 +1181,8 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3154610\n"
 "help.text"
-msgid "If you run this function, you cannot insert any additional columns for the query other than receiving these columns as a \"Group\" function."
-msgstr "Se eseguite una funzione, non potete inserire più nessuna ulteriore colonna per la ricerca, a meno che queste colonne abbiamo la funzione \"Gruppo\"."
+msgid "If you run such a function, you cannot insert any additional columns for the query other than as an argument in a \"Group\" function."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -1285,8 +1229,8 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3161652\n"
 "help.text"
-msgid "Double-click the \"Item_No\" field from the \"Item\" table. Display the <emph>Function</emph> line using the context menu and select the Count function."
-msgstr "Fate doppio clic sul campo \"Nr_Articolo\" della tabella \"Articoli\". Tramite il menu di contesto visualizzate la riga <emph>Funzione</emph> e selezionate la funzione Quantità."
+msgid "Double-click on the \"Item_No\" field from the \"Item\" table. Display the <emph>Function</emph> line using the context menu and select the Count function."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -1389,8 +1333,8 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3150414\n"
 "help.text"
-msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Shows or hides a row for selection of functions.</ahelp>"
-msgstr "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Visualizza o nasconde una riga per le funzioni.</ahelp>"
+msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Shows or hides a row for the selection of functions.</ahelp>"
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -1437,8 +1381,8 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3147500\n"
 "help.text"
-msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Applies only distinct values to the query.</ahelp> This applies to records containing data that appears several times in the selected fields. If the <emph>Distinct Values</emph> command is active, you will see only one record in the query (DISTINCT). Otherwise, you will see all records corresponding to the query criteria (ALL)."
-msgstr "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Applica solo valori distinti alla ricerca.</ahelp> Questo comando ha effetto sui record il cui contenuto compare diverse volte nei campi selezionati. Se il comando <emph>Valori distinti</emph> è attivo, nella ricerca compare un solo record (DISTINCT). Diversamente, vengono visualizzati tutti i record corrispondenti ai criteri della ricerca (ALL)."
+msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Retrieves only distinct values from the query.</ahelp> This applies to multiple records that might contain several repeating occurrences of data in the selected fields. If the <emph>Distinct Values</emph> command is active, you should only see one record in the query (DISTINCT). Otherwise, you will see all records corresponding to the query criteria (ALL)."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -1477,16 +1421,16 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3147501\n"
 "help.text"
-msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Allows you to maximize the number of records with which query returns.</ahelp>"
-msgstr "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Permette di massimizzare il numero di record da restituire con la ricerca.</ahelp>"
+msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Allows you to limit the maximum number of records returned by a query.</ahelp>"
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
 "par_id3152350\n"
 "help.text"
-msgid "If there is added a <emph>Limit</emph>, you will get at most as many rows as the number you specify. Otherwise, you will see all records corresponding to the query criteria."
-msgstr "Se viene aggiunto un <emph>limite</emph>, otterrete tante righe quante quelle che avete specificato. In alternativa, vi appariranno tutti i record corrispondenti al criterio di ricerca."
+msgid "If a <emph>Limit</emph> construction is added, you will get at most as many rows as the number you specify. Otherwise, you will see all records corresponding to the query criteria."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -1501,8 +1445,8 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3153162\n"
 "help.text"
-msgid "When formulating filter conditions, various operators and commands are available to you. Apart from the relational operators, there are SQL-specific commands that query the content of database fields. If you use these commands in the $[officename] syntax, $[officename] automatically converts these into the corresponding SQL syntax. You can also enter the SQL command directly. The following tables give an overview of the operators and commands:"
-msgstr "Per formulare le condizioni di filtro potete utilizzare vari comandi e operatori. Oltre agli operatori relazionali, esistono comandi specifici di SQL che ricercano nel contenuto dei campi del database. Utilizzando questi comandi nella sintassi di $[officename], quest'ultimo li converte automaticamente nella sintassi SQL corrispondente. Potete anche inserire direttamente il comando SQL. Le tabelle seguenti riassumono gli operatori e i comandi disponibili:"
+msgid "When formulating filter conditions, various operators and commands are available to you. Apart from the relational operators, there are SQL-specific commands that query the content of database fields. If you use these commands in the $[officename] syntax, $[officename] automatically converts these into the corresponding SQL syntax via an internal parser. You can also enter the SQL command directly and bypass the internal parser. The following tables give an overview of the operators and commands:"
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -1531,14 +1475,6 @@ msgstr "La condizione è soddisfatta se..."
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
-"par_id3156161\n"
-"help.text"
-msgid "="
-msgstr "="
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
 "par_id3153026\n"
 "help.text"
 msgid "equal to"
@@ -1557,16 +1493,8 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3153120\n"
 "help.text"
-msgid "The operator = will not be displayed in the query fields. If you enter a value without any operator, the operator = will be automatically adopted."
-msgstr "L'operatore = non viene visualizzato nei campi di ricerca; se digitate un valore senza operatore, viene accettato l'operatore =."
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3150470\n"
-"help.text"
-msgid "<>"
-msgstr "<>"
+msgid "The operator = will not be displayed in the query fields. If you enter a value without any operator, the = operator is automatically assumed."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -1587,14 +1515,6 @@ msgstr "... il contenuto del campo non corrisponde all'espressione indicata."
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
-"par_id3153015\n"
-"help.text"
-msgid ">"
-msgstr ">"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
 "par_id3146815\n"
 "help.text"
 msgid "greater than"
@@ -1611,14 +1531,6 @@ msgstr "... il contenuto del campo è maggiore dell'espressione indicata."
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
-"par_id3147270\n"
-"help.text"
-msgid "<"
-msgstr "<"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
 "par_id3147379\n"
 "help.text"
 msgid "less than"
@@ -1635,14 +1547,6 @@ msgstr "... il contenuto del campo è minore dell'espressione indicata."
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
-"par_id3149787\n"
-"help.text"
-msgid ">="
-msgstr ">="
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
 "par_id3150636\n"
 "help.text"
 msgid "greater than or equal to"
@@ -1659,14 +1563,6 @@ msgstr "... il contenuto del campo è maggiore o uguale all'espressione indicata
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
-"par_id3157964\n"
-"help.text"
-msgid "<="
-msgstr "<="
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
 "par_id3154052\n"
 "help.text"
 msgid "less than or equal to"
@@ -1715,22 +1611,6 @@ msgstr "La condizione è soddisfatta se..."
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
-"par_id3154275\n"
-"help.text"
-msgid "IS EMPTY"
-msgstr "È VUOTO"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3149893\n"
-"help.text"
-msgid "IS NULL"
-msgstr "È ZERO"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
 "par_id3143236\n"
 "help.text"
 msgid "is null"
@@ -1741,24 +1621,8 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3154744\n"
 "help.text"
-msgid "... The value of the field is empty. For Yes/No fields with three states, this command automatically queries the undetermined state (neither Yes nor No)."
-msgstr "... il valore del campo di dati è vuoto. Nei campi Sì/No con tre stati questo comando esamina lo stato indefinito (né sì, né no)."
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3146940\n"
-"help.text"
-msgid "IS NOT EMPTY"
-msgstr "NON È VUOTO"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3147471\n"
-"help.text"
-msgid "IS NOT NULL"
-msgstr "NON È ZERO"
+msgid "... the field contains no data. For Yes/No fields with three possible states, this command automatically queries the undetermined state (neither Yes nor No)."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -1773,40 +1637,24 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3145304\n"
 "help.text"
-msgid "... the field name is not empty."
-msgstr "...il campo di dati non è vuoto."
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3153578\n"
-"help.text"
-msgid "LIKE"
-msgstr "COME"
+msgid "... the field is not empty, i.e it contains data."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
 "par_id3153891\n"
 "help.text"
-msgid "(placeholder * for any number of characters"
-msgstr "(segnaposto * per qualsiasi numero di caratteri"
+msgid "placeholder (*) for any number of characters"
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
 "par_id3148887\n"
 "help.text"
-msgid "placeholder ? for exactly one character)"
-msgstr "segnaposto ? per un solo carattere)"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3148623\n"
-"help.text"
-msgid "LIKE"
-msgstr "COME"
+msgid "placeholder (?) for exactly one character"
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -1821,16 +1669,16 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3157985\n"
 "help.text"
-msgid "(% placeholder for any number of characters"
-msgstr "(segnaposto % per qualsiasi numero di caratteri"
+msgid "placeholder (%) for any number of characters"
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
 "par_id3147422\n"
 "help.text"
-msgid "Placeholder _ for exactly one character)"
-msgstr "segnaposto _ per un solo esatto carattere)"
+msgid "Placeholder (_) for exactly one character"
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -1845,32 +1693,16 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3156130\n"
 "help.text"
-msgid "... the data field contains the indicated expression. The (*) placeholder indicates whether the expression x occurs at the beginning of (x*), at the end of (*x) or inside the field content (*x*). You can enter as a placeholder in SQL queries either the SQL % character or the familiar (*) file system placeholder in the $[officename] interface."
-msgstr "... il campo di dati contiene l'espressione indicata. I segnaposto (*) indicano qui se l'espressione x compare all'inizio (x*), alla fine (*x) o all'interno del contenuto del campo (*x*). Nelle ricerche SQL potete digitare come segnaposto il carattere SQL %, mentre nell'interfaccia di $[officename] è necessario digitare i segnaposto tipici del file system (*)."
+msgid "... the data field must contain the indicated search string in the order given. The position of the (*) placeholder indicates whether the searched for string (x) occurs before the placeholder (x*), after the placeholder (*x) or between the placeholders (*x*). Instead of the familiar file system (*) placeholder, you can also use the SQL (%) character as a placeholder in SQL queries in the $[officename] interface."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
 "par_id3150271\n"
 "help.text"
-msgid "The * or % placeholder stands for any number of characters. The question mark (?) in the $[officename] interface or the underscore (_) in SQL queries is used to represent exactly one character."
-msgstr "Il segnaposto * o % viene utilizzato a piacere per molti caratteri. Nell'interfaccia di $[officename] il punto interrogativo (?) viene utilizzato come segnaposto per un solo carattere, mentre nelle ricerche SQL viene utilizzato il carattere (_)."
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3152954\n"
-"help.text"
-msgid "NOT LIKE"
-msgstr "NON COME"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3161669\n"
-"help.text"
-msgid "NOT LIKE"
-msgstr "NON COME"
+msgid "The (*) or (%) placeholder stands for any number of characters. The question mark (?) in the $[officename] interface or the underscore (_) in SQL queries is used to represent exactly one character."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -1885,24 +1717,8 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3161664\n"
 "help.text"
-msgid "... the field name does not contain the specified expression."
-msgstr "... il campo di dati non contiene l'espressione indicata."
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3149185\n"
-"help.text"
-msgid "BETWEEN x AND y"
-msgstr "TRA x E y"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3151259\n"
-"help.text"
-msgid "BETWEEN x AND y"
-msgstr "TRA x E y"
+msgid "... the field does not contain data having the specified expression."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -1917,24 +1733,8 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3154395\n"
 "help.text"
-msgid "... the field name contains a value that lies between the two values x and y."
-msgstr "... il campo di dati contiene un valore, compreso tra i due valori x e y."
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3154561\n"
-"help.text"
-msgid "NOT BETWEEN x AND y"
-msgstr "NON TRA x E y"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3148753\n"
-"help.text"
-msgid "NOT BETWEEN x AND y"
-msgstr "NON TRA x E y"
+msgid "... the field contains a data value that lies between the two values x and y."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -1949,32 +1749,16 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3148992\n"
 "help.text"
-msgid "... the field name contains a value that does not lie between the two values x and y."
-msgstr "... il campo di dati contiene un valore che non è compreso tra i due valori x e y."
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3149995\n"
-"help.text"
-msgid "IN (a; b; c...)"
-msgstr "IN (a; b; c...)"
+msgid "... the field contains a data value that does not lie between the two values x and y."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
 "par_id3159167\n"
 "help.text"
-msgid "Note that the semicolons are used as separators in all value lists!"
-msgstr "Fate attenzione al punto e virgola come separatore in tutti gli elenchi valori."
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3159085\n"
-"help.text"
-msgid "IN (a, b, c...)"
-msgstr "IN (a, b, c...)"
+msgid "Note that semicolons are used as separators in all value lists!"
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -1989,24 +1773,8 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3148399\n"
 "help.text"
-msgid "... the field name contains one of the specified expressions a, b, c,... Any number of expressions can be specified, and the result of the query is determined by an Or link. The expressions a, b, c... can be either numbers or characters"
-msgstr "... il campo di dati contiene una delle espressioni indicate a, b, c,... . È possibile indicare a piacere più espressioni, il risultato della ricerca viene comunicato con un collegamento O. Le espressioni a, b, c... possono essere sia numeri, sia caratteri."
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3154112\n"
-"help.text"
-msgid "NOT IN (a; b; c...)"
-msgstr "NON IN (a; b; c...)"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3153544\n"
-"help.text"
-msgid "NOT IN (a, b, c...)"
-msgstr "NOT IN (a, b, c...)"
+msgid "... the field name contains one of the specified expressions a, b, c,... Any number of expressions can be specified, and the result of the query is determined by a boolean OR operator. The expressions a, b, c... can be either numbers or characters"
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -2021,24 +1789,8 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3158439\n"
 "help.text"
-msgid "... the field name does not contain one of the specified expressions a, b, c,..."
-msgstr "... il campo di dati non contiene una delle espressioni indicate a, b, c,..."
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3145145\n"
-"help.text"
-msgid "= TRUE"
-msgstr "= VERO"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3146804\n"
-"help.text"
-msgid "= TRUE"
-msgstr "= VERO"
+msgid "... the field does not contain one of the specified expressions a, b, c,..."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -2059,22 +1811,6 @@ msgstr "... il campo di dati ha il valore True."
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
-"par_id3159212\n"
-"help.text"
-msgid "= FALSE"
-msgstr "= FALSO"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3144751\n"
-"help.text"
-msgid "= FALSE"
-msgstr "= FALSO"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
 "par_id3149955\n"
 "help.text"
 msgid "has the value false"
@@ -2085,8 +1821,8 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3146850\n"
 "help.text"
-msgid "... the field name has the value false."
-msgstr "... il campo di dati ha il valore False."
+msgid "... the field data value is set to false."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -2099,14 +1835,6 @@ msgstr "Esempi"
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
-"par_id3153792\n"
-"help.text"
-msgid "='Ms.'"
-msgstr "='Donna'"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
 "par_id3150948\n"
 "help.text"
 msgid "returns field names with the field content \"Ms.\""
@@ -2115,14 +1843,6 @@ msgstr "restituisce campi di dati con il contenuto di campo \"Donna\"."
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
-"par_id315379A\n"
-"help.text"
-msgid "<'2001-01-10'"
-msgstr "<'10-01-2001'"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
 "par_id315094A\n"
 "help.text"
 msgid "returns dates that occurred before January 10, 2001"
@@ -2131,82 +1851,42 @@ msgstr "restituisce le date verificatesi prima del 10 gennaio 2001"
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
-"par_id3150333\n"
-"help.text"
-msgid "LIKE 'g?ve'"
-msgstr "COME 'd?re'"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
 "par_id3147332\n"
 "help.text"
-msgid "returns field names with field content such as \"give\" and \"gave\"."
-msgstr "restituisce i nomi dei campi il cui contenuto è \"dire\" o \"dare\"."
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3146062\n"
-"help.text"
-msgid "LIKE 'S*'"
-msgstr "COME 'S*'"
+msgid "returns records with field content such as \"give\" and \"gave\"."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
 "par_id3155350\n"
 "help.text"
-msgid "returns data fields with field contents such as \"Sun\"."
-msgstr "restituisce campi di dati con contenuti di campo come \"Sun\"."
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3152883\n"
-"help.text"
-msgid "BETWEEN 10 AND 20"
-msgstr "TRA 10 E 20"
+msgid "returns records with field contents such as \"Sun\"."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
 "par_id3159406\n"
 "help.text"
-msgid "returns field names with field content between the values 10 and 20. (The fields can be either text fields or number fields)."
-msgstr "restituisce campi di dati con i contenuti di campo tra i valori 10 e 20. (In questo caso può trattarsi sia di campi di testo, che di campi numerici)."
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3148765\n"
-"help.text"
-msgid "IN (1; 3; 5; 7)"
-msgstr "IN (1; 3; 5; 7) 3; 5; 7)"
+msgid "returns records with field content between the values 10 and 20. (The fields can be either text fields or number fields)."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
 "par_id3149712\n"
 "help.text"
-msgid "returns field names with the values 1, 3, 5, 7. If the field name contains an item number, for example, you can create a query that returns the item having the specified number."
-msgstr "restituisce dati di campo con i valori 1, 3, 5, 7. Se ad esempio il campo di dati contiene un numero di articolo, potete creare una ricerca che restituisce l'articolo specifico per il numero indicato."
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3152948\n"
-"help.text"
-msgid "NOT IN ('Smith')"
-msgstr "NON IN ('Rossi')"
+msgid "returns records with the values 1, 3, 5, 7. If the field name contains an item number, for example, you can create a query that returns the item having the specified number."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
 "par_id3147279\n"
 "help.text"
-msgid "returns field names that do not contain \"Smith\"."
-msgstr "restituisce campi di dati che non contengono \"Rossi\"."
+msgid "returns records that do not contain \"Smith\"."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -2261,8 +1941,8 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3149134\n"
 "help.text"
-msgid "To query the content of a text field, you must put the expression between single quotes. The distinction between uppercase and lowercase letters depends on the database in use. LIKE, by definition, is case-sensitive (though some databases don't see it that strict)."
-msgstr "Per esaminare il contenuto di un campo di testo, dovete impostare l'espressione all'interno delle virgolette semplici. Non viene fatta alcuna differenza tra le maiuscole e le minuscole. LIKE, per definizione, distingue tra maiuscole e minuscole (sebbene alcuni database non lo considerino in maniera così ristretta)."
+msgid "To query the content of a text field, you must put the expression between single quotes. The distinction between uppercase and lowercase letters depends on the database in use. LIKE, by definition, is case-sensitive (though some databases don't interpret this strictly)."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -2323,30 +2003,6 @@ msgstr "Data"
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
-"par_id315913112\n"
-"help.text"
-msgid "{D'YYYY-MM-DD'}"
-msgstr "{D'AAAA-MM-GG'}"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id314975313\n"
-"help.text"
-msgid "{d 'YYYY-MM-DD'}"
-msgstr "{d 'AAAA-MM-GG'}"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id314975314\n"
-"help.text"
-msgid "'YYYY-MM-DD'"
-msgstr "'AAAA-MM-GG'"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
 "par_id31559471\n"
 "help.text"
 msgid "Time"
@@ -2355,30 +2011,6 @@ msgstr "Ora"
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
-"par_id31559472\n"
-"help.text"
-msgid "{D'HH:MM:SS'}"
-msgstr "{D'HH:MM:SS'}"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id31559473\n"
-"help.text"
-msgid "{t 'HH:MI:SS[.SS]'}"
-msgstr "{t 'HH:MI:SS[.SS]'}"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id31559474\n"
-"help.text"
-msgid "'HH:MI:SS[.SS]'"
-msgstr "'HH:MI:SS[.SS]'"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
 "par_id31509641\n"
 "help.text"
 msgid "DateTime"
@@ -2387,30 +2019,6 @@ msgstr "DataOra"
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
-"par_id31509642\n"
-"help.text"
-msgid "{D'YYYY-MM-DD HH:MM:SS'}"
-msgstr "{D'AAAA-MM-GG HH:MM:SS'}"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id31509643\n"
-"help.text"
-msgid "{ts 'YYYY-MM-DD HH:MI:SS[.SS]'}"
-msgstr "{ts 'AAAA-MM-GG HH:MI:SS[.SS]'}"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id31509644\n"
-"help.text"
-msgid "'YYYY-MM-DD HH:MI:SS[.SS]'"
-msgstr "'AAAA-MM-GG HH:MI:SS[.SS]'"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
 "par_id3149539\n"
 "help.text"
 msgid "Example: select {d '1999-12-31'} from world.years"
@@ -2429,8 +2037,8 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3150510\n"
 "help.text"
-msgid "All date expressions (literals) must be enclosed with single quotation marks. (Consult the reference for the particular database and connector you are using for more details.)"
-msgstr "Tutte le espressioni di data (letterali) devono essere racchiuse tra virgolette singole (per ulteriori informazioni, consultate la documentazione relativa allo specifico database e al connettore che state utilizzando)."
+msgid "All date expressions (date literals) must be enclosed with single quotation marks. (Consult the reference for the particular database and connector you are using for more details.)"
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -2661,32 +2269,32 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3152570\n"
 "help.text"
-msgid "In $[officename] you do not need any knowledge of SQL for most queries, since you do not have to enter the SQL code. If you create a query in the query design, $[officename] automatically converts your instructions into the corresponding SQL syntax. If, with the help of the <emph>Switch Design View On/Off </emph>button, you change to the SQL view, you can see the SQL commands for a query that has been created previously."
-msgstr "In $[officename], per la maggior parte delle ricerche non è necessario che conosciate il linguaggio SQL, poiché non dovete inserire il codice SQL. Se create una ricerca nella struttura ricerca, $[officename] converte automaticamente le vostre istruzioni nella sintassi SQL corrispondente. Attivando la vista SQL con il pulsante <emph>Vista struttura sì/no</emph>, potete vedere i comandi SQL per le ricerche create in precedenza."
+msgid "In $[officename] you do not need any knowledge of SQL for most queries, since you do not have to enter the SQL code. If you create a query in the query designer, $[officename] automatically converts your instructions into the corresponding SQL syntax. If, with the help of the <emph>Switch Design View On/Off </emph>button, you change to the SQL view, you can see the SQL commands for a query that has already been created."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
 "par_id3152412\n"
 "help.text"
-msgid "You can formulate your query directly in the SQL code. Note, however, that the special syntax is dependent upon the database system that you use."
-msgstr "Potete formulare la ricerca direttamente in codice SQL. In questo caso è opportuno ricordare che la sintassi speciale dipende dal sistema di database in uso."
+msgid "You can formulate your query directly in SQL code. Note, however, that the special syntax is dependent upon the database system that you use."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
 "par_id3146842\n"
 "help.text"
-msgid "If you enter the SQL code manually, you can create SQL-specific queries that are not supported by the graphical interface in <emph>Query design</emph>. These queries must be executed in native SQL mode."
-msgstr "Se inserite manualmente il codice SQL, potete creare ricerche SQL specifiche che non devono essere supportate dall'interfaccia grafica della <emph>struttura Ricerca</emph>. Queste ricerche devono essere eseguite in modo SQL nativo."
+msgid "If you enter the SQL code manually, you can create SQL-specific queries that are not supported by the graphical interface in the <emph>Query designer</emph>. These queries must be executed in native SQL mode."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
 "par_id3149632\n"
 "help.text"
-msgid "By clicking the <link href=\"text/shared/02/14030000.xhp\" name=\"Run SQL command directly\"><emph>Run SQL command directly</emph></link> icon in the SQL view, you can formulate a query that is not processed by $[officename]."
-msgstr "Facendo clic sull'icona <link href=\"text/shared/02/14030000.xhp\" name=\"Esegui direttamente comando SQL\"><emph>Esegui direttamente il comando SQL</emph></link> nella vista SQL, potete formulare una ricerca che non venga elaborata da $[officename]."
+msgid "By clicking the <link href=\"text/shared/02/14030000.xhp\" name=\"Run SQL command directly\"><emph>Run SQL command directly</emph></link> icon in the SQL view, you can formulate a query that is not processed by $[officename]and sent directly to the database engine."
+msgstr ""
 
 #: 02010101.xhp
 msgctxt ""
@@ -2773,8 +2381,8 @@ msgctxt ""
 "02010101.xhp\n"
 "par_id3152482\n"
 "help.text"
-msgid "<ahelp hid=\"dbaccess/ui/joindialog/type\">Specifies the link type of the selected link.</ahelp> Some databases support only a subset of the possible types."
-msgstr "<ahelp hid=\"dbaccess/ui/joindialog/type\">Specifica di che tipo è il collegamento selezionato.</ahelp> Alcuni database supportano solo un sottoinsieme di tipi possibili."
+msgid "<ahelp hid=\"dbaccess/ui/joindialog/type\">Specifies the join type of the selected join.</ahelp> Some databases support only a subset of the various possible types."
+msgstr ""
 
 #: 02010101.xhp
 msgctxt ""
@@ -2789,8 +2397,8 @@ msgctxt ""
 "02010101.xhp\n"
 "par_id3155936\n"
 "help.text"
-msgid "<ahelp hid=\"dbaccess/ui/joindialog/type\">With the internal join, the results table contains only the records for which the content of the linked fields is the same.</ahelp> In $[officename] SQL this type of link is created by a corresponding WHERE clause."
-msgstr "<ahelp hid=\"dbaccess/ui/joindialog/type\">Selezionando la relazione interna, la tabella dei risultati contiene solo i record i cui campi collegati presentano lo stesso contenuto.</ahelp> In SQL di $[officename], questo tipo di relazione viene creato mediante una corrispondente clausola WHERE."
+msgid "<ahelp hid=\"dbaccess/ui/joindialog/type\">In an inner join, the results table contains only those records for which the content of the linked fields is the same.</ahelp> In $[officename] SQL this type of link is created by a corresponding WHERE clause."
+msgstr ""
 
 #: 02010101.xhp
 msgctxt ""
@@ -2805,8 +2413,8 @@ msgctxt ""
 "02010101.xhp\n"
 "par_id3166450\n"
 "help.text"
-msgid "<ahelp hid=\"dbaccess/ui/joindialog/type\">With the left join, the results table contains all fields of the left table and only those fields of the right table for which the content of the linked fields is the same.</ahelp> In $[officename] SQL this type of link corresponds to the LEFT OUTER JOIN command."
-msgstr "<ahelp hid=\"dbaccess/ui/joindialog/type\">Selezionando la relazione sinistra, la tabella dei risultati contiene tutti i campi della tabella a sinistra e quei campi della tabella a destra i cui campi collegati presentano lo stesso contenuto.</ahelp> In SQL di $[officename], questo tipo di relazione corrisponde al comando LEFT OUTER JOIN."
+msgid "<ahelp hid=\"dbaccess/ui/joindialog/type\">In a left join, the results table contains all records of the queried fields from the left table and only those records of the queried fields from the right table for which the content of the linked fields is the same.</ahelp> In $[officename] SQL this type of link corresponds to the LEFT OUTER JOIN command."
+msgstr ""
 
 #: 02010101.xhp
 msgctxt ""
@@ -2821,8 +2429,8 @@ msgctxt ""
 "02010101.xhp\n"
 "par_id3150647\n"
 "help.text"
-msgid "<ahelp hid=\"dbaccess/ui/joindialog/type\">With the right join, the results table contains all fields of the right table and only those fields of the left table for which the content of the linked fields is the same.</ahelp> In $[officename] SQL this type of link corresponds to the RIGHT OUTER JOIN command."
-msgstr "<ahelp hid=\"dbaccess/ui/joindialog/type\">Selezionando la relazione destra, la tabella dei risultati contiene tutti i campi della tabella a destra e quei campi della tabella a sinistra i cui campi collegati presentano lo stesso contenuto.</ahelp> In SQL di $[officename], questo tipo di relazione corrisponde al comando RIGHT OUTER JOIN."
+msgid "<ahelp hid=\"dbaccess/ui/joindialog/type\">In a right join, the results table contains all records of the queried fields from the right table and only those records of the queried fields from the left table for which the content of the linked fields is the same.</ahelp> In $[officename] SQL this type of link corresponds to the RIGHT OUTER JOIN command."
+msgstr ""
 
 #: 02010101.xhp
 msgctxt ""
@@ -2837,8 +2445,8 @@ msgctxt ""
 "02010101.xhp\n"
 "par_id3163665\n"
 "help.text"
-msgid "<ahelp hid=\"dbaccess/ui/joindialog/type\">For a full join, the results table contains all fields of the left and right tables.</ahelp> In the SQL of $[officename] this type of link corresponds to the FULL OUTER JOIN command."
-msgstr "<ahelp hid=\"dbaccess/ui/joindialog/type\">Selezionando la relazione completa, la tabella dei risultati conterrà tutti i campi delle tabelle a destra e a sinistra.</ahelp> In SQL di $[officename], questo tipo di relazione corrisponde al comando FULL OUTER JOIN."
+msgid "<ahelp hid=\"dbaccess/ui/joindialog/type\">In a full join, the results table contains all records of the queried fields from the left and right tables.</ahelp> In the SQL of $[officename] this type of link corresponds to the FULL OUTER JOIN command."
+msgstr ""
 
 #: 02010101.xhp
 msgctxt ""
@@ -2853,8 +2461,8 @@ msgctxt ""
 "02010101.xhp\n"
 "par_id0305200912031977\n"
 "help.text"
-msgid "<ahelp hid=\".\">Inserts the keyword NATURAL into the SQL statement that defines the relation. The relation joins all columns that have the same column name in both tables. The resulting joined table contains only one column for each pair of equally named columns.</ahelp>"
-msgstr "<ahelp hid=\".\">Inserire la parola chiave NATURAL nell'istruzione SQL che definisce la relazione. La relazione unisce tutte le colonne che hanno lo stesso nome in entrambe le tabelle. La tabella di unione risultante contiene solo una colonna per ogni coppia di colonne con lo stesso nome.</ahelp>"
+msgid "<ahelp hid=\".\">In a natural join, the keyword NATURAL in inserted into the SQL statement that defines the relation. The relation joins all columns that have the same column name in both tables. The resulting joined table contains only one column for each pair of equally named columns.</ahelp>"
+msgstr ""
 
 #: 04000000.xhp
 msgctxt ""
@@ -2909,8 +2517,8 @@ msgctxt ""
 "04000000.xhp\n"
 "par_id3156156\n"
 "help.text"
-msgid "The Form Controls toolbar offers the tools required to create a form in a text, table, drawing, or presentation document."
-msgstr "La barra degli strumenti Controlli per formulario vi offre gli strumenti necessari per creare un formulario in un documento di testo, in un foglio elettronico, in un disegno o in una presentazione."
+msgid "The Form Controls toolbar provides the tools required to create a form in a text, table, drawing, or presentation document."
+msgstr ""
 
 #: 04000000.xhp
 msgctxt ""
@@ -2997,32 +2605,32 @@ msgctxt ""
 "04030000.xhp\n"
 "par_id3153146\n"
 "help.text"
-msgid "In the form design you can <link href=\"text/shared/02/01170000.xhp\" name=\"include controls\">include controls</link>, <link href=\"text/shared/02/01170100.xhp\" name=\"apply properties\">apply properties</link> to them, define <link href=\"text/shared/02/01170200.xhp\" name=\"Form properties\">Form properties</link>, and <link href=\"text/shared/02/01170203.xhp\" name=\"define subforms\">define subforms</link>."
-msgstr "Nella struttura del formulario potete <link href=\"text/shared/02/01170000.xhp\" name=\"includere controlli\">includere controlli</link>, <link href=\"text/shared/02/01170100.xhp\" name=\"applicare proprietà\">applicare proprietà</link> ai controlli, definire le <link href=\"text/shared/02/01170200.xhp\" name=\"proprietà del formulario\">proprietà del formulario</link> e <link href=\"text/shared/02/01170203.xhp\" name=\"definire dei formulari secondari\">definire dei formulari secondari</link>."
+msgid "In form design mode you can <link href=\"text/shared/02/01170000.xhp\" name=\"include controls\">include controls</link>, <link href=\"text/shared/02/01170100.xhp\" name=\"apply properties\">apply properties</link> to them, define <link href=\"text/shared/02/01170200.xhp\" name=\"Form properties\">Form properties</link>, and <link href=\"text/shared/02/01170203.xhp\" name=\"define subforms\">define subforms</link>."
+msgstr ""
 
 #: 04030000.xhp
 msgctxt ""
 "04030000.xhp\n"
 "par_id3154924\n"
 "help.text"
-msgid "The<emph> Form Navigator</emph> icon <image id=\"img_id3156002\" src=\"cmd/sc_showfmexplorer.png\" width=\"4.23mm\" height=\"4.23mm\"><alt id=\"alt_id3156002\">Icon</alt></image> on the Form Design bar opens the <link href=\"text/shared/02/01170600.xhp\" name=\"Form Navigator\"><emph>Form Navigator</emph></link>."
-msgstr "L'icona <emph>Navigatore formulario</emph> <image id=\"img_id3156002\" src=\"cmd/sc_showfmexplorer.png\" width=\"4.23mm\" height=\"4.23mm\"><alt id=\"alt_id3156002\">Icona</alt></image> della barra degli strumenti Struttura del formulario apre il <link href=\"text/shared/02/01170600.xhp\" name=\"Navigatore formulario\"><emph>Navigatore formulario</emph></link>."
+msgid "The<emph> Form Navigator</emph> icon<image id=\"img_id3156002\" src=\"cmd/sc_showfmexplorer.png\" width=\"4.23mm\" height=\"4.23mm\"><alt id=\"alt_id3156002\">Icon</alt></image> on the Form Design bar opens the <link href=\"text/shared/02/01170600.xhp\" name=\"Form Navigator\"><emph>Form Navigator</emph></link>."
+msgstr ""
 
 #: 04030000.xhp
 msgctxt ""
 "04030000.xhp\n"
 "par_id3153968\n"
 "help.text"
-msgid "The <link href=\"text/shared/02/01171000.xhp\" name=\"Open in Design Mode\"><emph>Open in Design Mode</emph></link> icon <image id=\"img_id1871395\" src=\"cmd/sc_openreadonly.png\" width=\"5.59mm\" height=\"5.59mm\"><alt id=\"alt_id1871395\">Icon</alt></image> allows you to save a form document so that it always opens in editing mode."
-msgstr "L'icona <link href=\"text/shared/02/01171000.xhp\" name=\"Apri in vista struttura\"><emph>Apri in vista struttura</emph></link> <image id=\"img_id1871395\" src=\"cmd/sc_openreadonly.png\" width=\"5.59mm\" height=\"5.59mm\"><alt id=\"alt_id1871395\"> Icona</alt></image> vi consente di salvare un formulario in modo che si apra sempre in modo modifica."
+msgid "The <link href=\"text/shared/02/01171000.xhp\" name=\"Open in Design Mode\"><emph>Open in Design Mode</emph></link> icon<image id=\"img_id1871395\" src=\"cmd/sc_openreadonly.png\" width=\"5.59mm\" height=\"5.59mm\"><alt id=\"alt_id1871395\">Icon</alt></image> allows you to save a form document so that it always opens in form design mode."
+msgstr ""
 
 #: 04030000.xhp
 msgctxt ""
 "04030000.xhp\n"
 "par_id3154948\n"
 "help.text"
-msgid "If there is an error when assigning properties to the objects contained in the form (for example, when assigning a non-existent database table to an object), a corresponding error message appears. This error message may contain a <emph>More</emph> button. <ahelp hid=\"dummy\">If you click <emph>More</emph>, a dialog displaying more information about the current problem appears.</ahelp>"
-msgstr "In caso di errore durante l'assegnazione delle proprietà agli oggetti contenuti nel formulario (ad esempio, quando si assegna una tabella di database inesistente a un oggetto), viene visualizzato il relativo messaggio di errore. Questo messaggio può contenere anche un pulsante <emph>Extra</emph>. <ahelp hid=\"dummy\">Facendo clic su <emph>Extra</emph> si apre una finestra di dialogo con ulteriori informazioni sul problema attualmente riscontrato.</ahelp>"
+msgid "If there is an error when assigning properties to the objects contained in the form (for example, when assigning a non-existent database table to an object), a corresponding error message appears. This error message may contain a <emph>More</emph> button. <ahelp hid=\"dummy\">If you click on <emph>More</emph>, a dialog displaying more information about the current problem appears.</ahelp>"
+msgstr ""
 
 #: 05000000.xhp
 msgctxt ""
@@ -3045,8 +2653,8 @@ msgctxt ""
 "05000000.xhp\n"
 "par_id3147102\n"
 "help.text"
-msgid "Data sources tables allow you see your data line by line. You can make new entries and deletions."
-msgstr "Le tabelle delle sorgenti dati permettono di visualizzare i dati riga per riga. Potete inserire nuove voci o eliminare quelle esistenti."
+msgid "Table data edit mode allows you to see your data as rows of records, with optional filtering and sorting of that data. In this mode, you can also enter new records, make changes to, and delete existing records."
+msgstr ""
 
 #: 05000000.xhp
 msgctxt ""
@@ -3101,16 +2709,16 @@ msgctxt ""
 "05000001.xhp\n"
 "par_id3163829\n"
 "help.text"
-msgid "The context menu of the table container offers various functions that apply to all database tables. To edit a special table within the database, select the corresponding table and open its context menu."
-msgstr "Il menu contestuale del contenitore tabelle offre varie funzioni che potete applicare in generale a tutte le tabelle del database. Per modificare una determinata tabella all'interno del database, selezionate la tabella ed aprite il relativo menu contestuale."
+msgid "The context menu of the table container offers various functions that apply to all database tables. To edit a particular table within the database, select the corresponding table and open its context menu."
+msgstr ""
 
 #: 05000001.xhp
 msgctxt ""
 "05000001.xhp\n"
 "par_id3146958\n"
 "help.text"
-msgid "Depending on the context, it is possible that not all the functions for your current database are listed in the context menus. For example, the <emph>Relationships</emph> command for defining relationships between various tables is only available with relational databases."
-msgstr "A seconda del contesto, è possibile che i menu contestuali non visualizzino tutte le funzioni per il database attuale. Ad esempio, il comando <emph>Relazioni</emph> per la definizione delle relazioni tra le varie tabelle è disponibile soltanto per database relazionali."
+msgid "Depending on the context, it is possible that not all the functions for your current database will be listed in the context menus. For example, the <emph>Relationships</emph> command for defining relationships between various tables is only available with relational databases."
+msgstr ""
 
 #: 05000001.xhp
 msgctxt ""
@@ -3149,8 +2757,8 @@ msgctxt ""
 "05000003.xhp\n"
 "par_id3148520\n"
 "help.text"
-msgid "Allows you to enter and confirm a new or changed password. If you have defined a new user, enter the user's name in this dialog."
-msgstr "Permette di inserire e confermare una password nuova o modificata. Se avete definito un nuovo utente, inserite il nome dell'utente in questa finestra di dialogo."
+msgid "Allows you to enter and confirm a new or changed password. If you have defined a new user, enter the user name in this dialog."
+msgstr ""
 
 #: 05000003.xhp
 msgctxt ""
@@ -3181,8 +2789,8 @@ msgctxt ""
 "05000003.xhp\n"
 "par_id3147576\n"
 "help.text"
-msgid "<ahelp hid=\"dbaccess/ui/password/oldpassword\">Enter the old password.</ahelp> This field is visible when you have started the dialog via <emph>Change password</emph>."
-msgstr "<ahelp hid=\"dbaccess/ui/password/oldpassword\">Inserire la vecchia password.</ahelp> Questo campo è visualizzato solo quando avete aperto la finestra di dialogo tramite l'opzione <emph>Cambia password</emph>."
+msgid "<ahelp hid=\"dbaccess/ui/password/oldpassword\">Enter the old password here.</ahelp> This field is visible when you have opened the dialog via <emph>Change password</emph>."
+msgstr ""
 
 #: 05000003.xhp
 msgctxt ""
@@ -3237,8 +2845,8 @@ msgctxt ""
 "05010000.xhp\n"
 "par_id3152363\n"
 "help.text"
-msgid "In the <emph>Table Design</emph> window you define new tables or edit the structure of a table."
-msgstr "Nella finestra <emph>Struttura tabella</emph> potete creare nuove tabelle o modificare la struttura di una tabella esistente."
+msgid "In the <emph>Table Design</emph> window you define new tables or edit the structure of an existing table."
+msgstr ""
 
 #: 05010000.xhp
 msgctxt ""
@@ -3277,8 +2885,8 @@ msgctxt ""
 "05010000.xhp\n"
 "par_id3156113\n"
 "help.text"
-msgid "<ahelp hid=\"HID_TABDESIGN_NAMECELL\">Specifies the name of the data field. Note the database restrictions, such as the length of the name, special characters and spaces.</ahelp>"
-msgstr "<ahelp hid=\"HID_TABDESIGN_NAMECELL\">Inserisce il nome del campo di dati. Prestare attenzione alle limitazioni relative ai database, quali la lunghezza del nome, caratteri speciali e spazi.</ahelp>"
+msgid "<ahelp hid=\"HID_TABDESIGN_NAMECELL\">Specifies the name of the data field. The database engine may impose restrictions on the length of the table name, and the use of special characters and spaces within the table name.</ahelp>"
+msgstr ""
 
 #: 05010000.xhp
 msgctxt ""
@@ -3293,8 +2901,8 @@ msgctxt ""
 "05010000.xhp\n"
 "par_id3154897\n"
 "help.text"
-msgid "<ahelp hid=\"HID_TABDESIGN_TYPECELL\">Specifies the field type.</ahelp>"
-msgstr "<ahelp hid=\"HID_TABDESIGN_TYPECELL\">Seleziona il tipo di campo.</ahelp>"
+msgid "<ahelp hid=\"HID_TABDESIGN_TYPECELL\">Specifies the field type. The available field types are limited by the database engine being used.</ahelp>"
+msgstr ""
 
 #: 05010000.xhp
 msgctxt ""
@@ -3309,8 +2917,8 @@ msgctxt ""
 "05010000.xhp\n"
 "par_id3145315\n"
 "help.text"
-msgid "<ahelp hid=\"HID_TABDESIGN_COMMENTCELL\">Specifies an optional description.</ahelp>"
-msgstr "<ahelp hid=\"HID_TABDESIGN_COMMENTCELL\">Inserisce una descrizione facoltativa.</ahelp>"
+msgid "<ahelp hid=\"HID_TABDESIGN_COMMENTCELL\">Specifies an optional description for each field.</ahelp>"
+msgstr ""
 
 #: 05010000.xhp
 msgctxt ""
@@ -3397,8 +3005,8 @@ msgctxt ""
 "05010000.xhp\n"
 "par_id3149456\n"
 "help.text"
-msgid "<ahelp hid=\"SID_TABLEDESIGN_INSERTROWS\">Inserts an empty row above the current row, if the table has not been saved. Inserts an empty row at the end of the table if the table has been saved.</ahelp>"
-msgstr "<ahelp hid=\"SID_TABLEDESIGN_INSERTROWS\">Inserisce una riga vuota sopra la riga attiva, se la tabella non è stata salvata. Inserisce una riga vuota alla fine della tabella se la tabella è stata salvata.</ahelp>"
+msgid "<ahelp hid=\"SID_TABLEDESIGN_INSERTROWS\">Inserts an empty row above the current row, if the table has not been saved. Inserts an empty row at the end of the table if the table has already been saved.</ahelp>"
+msgstr ""
 
 #: 05010000.xhp
 msgctxt ""
@@ -3413,8 +3021,8 @@ msgctxt ""
 "05010000.xhp\n"
 "par_id3150398\n"
 "help.text"
-msgid "<ahelp hid=\"SID_TABLEDESIGN_TABED_PRIMARYKEY\">If this command has a check mark, the data field in this line is a primary key.</ahelp> By clicking the command you activate/deactivate the status. The command is only visible if the data source supports primary keys."
-msgstr "<ahelp hid=\"SID_TABLEDESIGN_TABED_PRIMARYKEY\">Se questo comando è contrassegnato da un segno di spunta, il campo di dati in questa riga è una chiave primaria.</ahelp> Facendo clic sul comando potete attivare o disattivare il relativo stato. Il comando è visibile solo se la sorgente dati supporta chiavi primarie."
+msgid "<ahelp hid=\"SID_TABLEDESIGN_TABED_PRIMARYKEY\">If this command has a check mark, the data field is defined as a primary key.</ahelp> By clicking the command you activate/deactivate the primary key definition of the field. The command is only visible if the data source supports primary keys."
+msgstr ""
 
 #: 05010000.xhp
 msgctxt ""
@@ -3445,8 +3053,8 @@ msgctxt ""
 "05010000.xhp\n"
 "par_id3144761\n"
 "help.text"
-msgid "Specifies the length of the data field."
-msgstr "Indica la lunghezza del campo di dati."
+msgid "Specifies the maximum number of characters allowed for data entry of the corresponding data field including any spaces or special characters."
+msgstr ""
 
 #: 05010000.xhp
 msgctxt ""
@@ -3493,8 +3101,8 @@ msgctxt ""
 "05010000.xhp\n"
 "par_id3155131\n"
 "help.text"
-msgid "<ahelp hid=\"HID_TAB_ENT_FORMAT_SAMPLE\">Displays the format code that you can select with the<emph> ... </emph>button.</ahelp>"
-msgstr "<ahelp hid=\"HID_TAB_ENT_FORMAT_SAMPLE\">Visualizza il codice formato selezionabile con il pulsante <emph>...</emph></ahelp>"
+msgid "<ahelp hid=\"HID_TAB_ENT_FORMAT_SAMPLE\">Displays the format code to assign to the field value that you can select with the<emph> ... </emph>button.</ahelp>"
+msgstr ""
 
 #: 05010000.xhp
 msgctxt ""
@@ -3525,8 +3133,8 @@ msgctxt ""
 "05010000.xhp\n"
 "par_id3150685\n"
 "help.text"
-msgid "<ahelp hid=\"HID_TABLE_DESIGN_HELP_WINDOW\">Displays help texts.</ahelp>"
-msgstr "<ahelp hid=\"HID_TABLE_DESIGN_HELP_WINDOW\">Visualizza i testi della Guida.</ahelp>"
+msgid "<ahelp hid=\"HID_TABLE_DESIGN_HELP_WINDOW\">Displays a help string or hint defined by the database designer for the given field.</ahelp>"
+msgstr ""
 
 #: 05010100.xhp
 msgctxt ""
@@ -3549,8 +3157,8 @@ msgctxt ""
 "05010100.xhp\n"
 "par_id3166460\n"
 "help.text"
-msgid "<ahelp hid=\".uno:DBIndexDesign\">The <emph>Index Design </emph>dialog allows you edit the indexes for the current table.</ahelp>"
-msgstr "<ahelp hid=\".uno:DBIndexDesign\">La finestra di dialogo <emph>Struttura indice</emph> consente di modificare gli indici per la tabella attiva.</ahelp>"
+msgid "<ahelp hid=\".uno:DBIndexDesign\">The <emph>Index Design </emph>dialog allows you to define and edit the indexes for the current table.</ahelp>"
+msgstr ""
 
 #: 05010100.xhp
 msgctxt ""
@@ -3565,8 +3173,8 @@ msgctxt ""
 "05010100.xhp\n"
 "par_id3155342\n"
 "help.text"
-msgid "<ahelp hid=\"dbaccess/ui/indexdesigndialog/INDEX_LIST\">Displays the available indexes. Select an index from the list to edit. The details of the selected index are displayed in the dialog.</ahelp>"
-msgstr "<ahelp hid=\"dbaccess/ui/indexdesigndialog/INDEX_LIST\">Visualizza gli indici disponibili. Selezionare un indice dall'elenco per modificarlo. I dettagli relativi all'indice selezionato vengono visualizzati nella finestra di dialogo.</ahelp>"
+msgid "<ahelp hid=\"dbaccess/ui/indexdesigndialog/INDEX_LIST\">Displays a list of available indexes. Select an index from the list to edit. The details of the selected index are displayed in the dialog.</ahelp>"
+msgstr ""
 
 #: 05010100.xhp
 msgctxt ""
@@ -3661,8 +3269,8 @@ msgctxt ""
 "05010100.xhp\n"
 "par_id3154938\n"
 "help.text"
-msgid "As soon as you change a detail of the current index and then select another index, the change is immediately passed to the data source. You can only leave the dialog, or select another index, if the change has been successfully acknowledged by the data source. However, you can undo the change by clicking the <emph>Reset Current Index </emph>icon."
-msgstr "Quando modificate un dettaglio dell'indice in uso e quindi selezionate un altro indice, la modifica è immediatamente trasferita alla sorgente dati. Potete chiudere la finestra di dialogo o selezionare un altro indice solo se la modifica è stata accettata dalla sorgente dati. Potete comunque annullare la modifica facendo clic sull'icona <emph>Ripristina l'indice attuale</emph>."
+msgid "As soon as you change a detail of the current index and then select another index, the change is immediately passed on to the data source. You can only leave the dialog, or select another index, if the change has been successfully acknowledged by the data source. However, you can undo the change by clicking the <emph>Reset Current Index </emph>icon."
+msgstr ""
 
 #: 05010100.xhp
 msgctxt ""
@@ -3725,8 +3333,8 @@ msgctxt ""
 "05010100.xhp\n"
 "par_id3149561\n"
 "help.text"
-msgid "<ahelp hid=\"HID_DLGINDEX_INDEXDETAILS_SORTORDER\">Determines the sort order.</ahelp>"
-msgstr "<ahelp hid=\"HID_DLGINDEX_INDEXDETAILS_SORTORDER\">Determina la sequenza di ordinamento.</ahelp>"
+msgid "<ahelp hid=\"HID_DLGINDEX_INDEXDETAILS_SORTORDER\">Determines the sort order of the indexes.</ahelp>"
+msgstr ""
 
 #: 05010100.xhp
 msgctxt ""
@@ -3797,8 +3405,8 @@ msgctxt ""
 "05020000.xhp\n"
 "par_id3149235\n"
 "help.text"
-msgid "When you choose <emph>Tools - Relationships</emph>, a window opens in which all the existing relationships between the tables of the current database are shown. If no relationships have been defined, or if you want to relate other tables of the database to each other, then click the <emph>Add Tables</emph> icon. The <link href=\"text/shared/02/14020100.xhp\" name=\"Add Tables\">Add Tables</link> dialog opens in which you can select the tables that you want."
-msgstr "Scegliendo <emph>Strumenti - Relazioni</emph>, si apre una finestra che presenta tutte le relazioni esistenti tra le tabelle del database attivo. Se non è stata definita alcuna relazione, o se volete correlare tra loro altre tabelle del database, fate clic sull'icona <emph>Aggiungi tabelle</emph>. Si apre la finestra di dialogo <link href=\"text/shared/02/14020100.xhp\" name=\"Aggiungi tabelle\">Aggiungi tabelle</link>, in cui potete selezionare le tabelle desiderate."
+msgid "When you choose <emph>Tools - Relationships</emph>, a window opens in which all the existing relationships between the tables of the current database are shown. If no relationships have been defined, or if you want to relate other tables of the database to each other, then click on the <emph>Add Tables</emph> icon. The <link href=\"text/shared/02/14020100.xhp\" name=\"Add Tables\">Add Tables</link> dialog opens in which you can select the tables with which to create a relation."
+msgstr ""
 
 #: 05020000.xhp
 msgctxt ""
@@ -3813,8 +3421,8 @@ msgctxt ""
 "05020000.xhp\n"
 "par_id3150541\n"
 "help.text"
-msgid "The selected tables are shown in the top area of the design view. You can close a table window through the context menu or with the Delete key."
-msgstr "Le tabelle selezionate vengono visualizzate nell'area superiore della vista struttura. Potete eliminare una finestra della tabella con il menu di contesto o con il tasto Canc."
+msgid "The selected tables are shown in the top area of the relation design view. You can close a table window through the context menu or with the Delete key."
+msgstr ""
 
 #: 05020000.xhp
 msgctxt ""
@@ -3829,16 +3437,16 @@ msgctxt ""
 "05020000.xhp\n"
 "hd_id3148922\n"
 "help.text"
-msgid "Primary key and other key"
-msgstr "Chiave primaria e chiave esterna"
+msgid "Primary key and foreign keys"
+msgstr ""
 
 #: 05020000.xhp
 msgctxt ""
 "05020000.xhp\n"
 "par_id3149168\n"
 "help.text"
-msgid "If you want to define a relation among the different tables, you should enter a <link href=\"text/shared/00/00000005.xhp#primaerschluessel\" name=\"primary key\">primary key</link> that clearly identifies a data field of the existing table. You can refer to the primary key from other tables to access the data of this table. All data fields referring to this primary key will be identified as an external key."
-msgstr "Se volete definire una relazione tra tabelle differenti, dovete inserire una <link href=\"text/shared/00/00000005.xhp#primaerschluessel\" name=\"chiave primaria\">chiave primaria</link> che identifichi chiaramente un campo di dati della tabella esistente. Per accedere ai dati di questa tabella, potete fare riferimento alla chiave primaria da altre tabelle. Tutti i campi di dati che fanno riferimento a questa chiave primaria verranno identificati come chiavi esterne."
+msgid "If you want to define a relation among the various tables, you should enter a <link href=\"text/shared/00/00000005.xhp#primaerschluessel\" name=\"primary key\">primary key</link> that uniquely identifies a data field of an existing table. You can refer to the primary key from other tables to access the data of this table. All data fields referring to this primary key will be identified as a foreign key."
+msgstr ""
 
 #: 05020000.xhp
 msgctxt ""
@@ -3869,8 +3477,8 @@ msgctxt ""
 "05020000.xhp\n"
 "par_id3155430\n"
 "help.text"
-msgid "All existing relations are shown in the relations windows by a line that connects the primary and other key fields. You can add a relation by using drag-and-drop to drop the field of one table onto the field of the other table. A relation is removed again by selecting it and pressing the Delete key."
-msgstr "Nelle finestre, le relazioni esistenti vengono rappresentate con una linea di collegamento tra la chiave primaria e gli altri campi chiave. Per aggiungere una relazione, potete trascinare un campo di una tabella su un campo di un'altra tabella. Per rimuovere una relazione, selezionatela e premete il tasto Canc."
+msgid "All existing relations are shown in the relations windows by a line that connects the primary and foreign key fields. You can add a relation by using drag-and-drop to drop the field of one table onto the field of the other table. A relation is removed again by selecting it and pressing the Delete key."
+msgstr ""
 
 #: 05020000.xhp
 msgctxt ""
@@ -3885,8 +3493,8 @@ msgctxt ""
 "05020000.xhp\n"
 "par_id3153093\n"
 "help.text"
-msgid "If you use $[officename] as the front-end for a relational database, the creation and deletion of relationships is not placed in an intermediate memory by $[officename], but is forwarded directly to the external database."
-msgstr "Se utilizzate $[officename] come interfaccia per un database relazionale, la creazione e l'eliminazione delle relazioni non vengono eseguite in un'area di memoria intermedia di $[officename], bensì vengono inoltrate direttamente al database esterno."
+msgid "If you use $[officename] as the front-end for a relational database, the creation and deletion of relationships is not placed in an intermediate memory by $[officename], but is forwarded directly to the database."
+msgstr ""
 
 #: 05020000.xhp
 msgctxt ""
@@ -11016,6 +10624,158 @@ msgctxt ""
 msgid "You can click the date or time field and drag to another position within the same area, or edit the properties in the Properties window."
 msgstr "Potete fare clic sui campi data e ora e trascinarli in un'altra posizione all'interno della stessa area, oppure modificarne le proprietà nella finestra Proprietà."
 
+#: rep_insertfield.xhp
+msgctxt ""
+"rep_insertfield.xhp\n"
+"tit\n"
+"help.text"
+msgid "Insert Fields"
+msgstr ""
+
+#: rep_insertfield.xhp
+msgctxt ""
+"rep_insertfield.xhp\n"
+"bm_id61540566967968\n"
+"help.text"
+msgid "<bookmark_value>insert fields;in report design</bookmark_value>            <bookmark_value>add fields;in report design</bookmark_value>            <bookmark_value>report design;add fields to report</bookmark_value>"
+msgstr ""
+
+#: rep_insertfield.xhp
+msgctxt ""
+"rep_insertfield.xhp\n"
+"hd_id361540562942432\n"
+"help.text"
+msgid "<variable id=\"addfields\"><link href=\"text/shared/explorer/database/rep_insertfield.xhp\" name=\"Add Fields\">Add fields to report</link></variable>"
+msgstr ""
+
+#: rep_insertfield.xhp
+msgctxt ""
+"rep_insertfield.xhp\n"
+"par_id3587145\n"
+"help.text"
+msgid "<ahelp hid=\".\">The Add Field window helps you to insert the table entries in the report.</ahelp>"
+msgstr ""
+
+#: rep_insertfield.xhp
+msgctxt ""
+"rep_insertfield.xhp\n"
+"par_id4503921\n"
+"help.text"
+msgid "The Add Field window is shown automatically when you have selected a table in the Contents box and leave that box."
+msgstr ""
+
+#: rep_insertfield.xhp
+msgctxt ""
+"rep_insertfield.xhp\n"
+"par_id171540674707522\n"
+"help.text"
+msgid "Choose <item type=\"menuitem\">View - Add Field</item>."
+msgstr ""
+
+#: rep_insertfield.xhp
+msgctxt ""
+"rep_insertfield.xhp\n"
+"par_id991540674901837\n"
+"help.text"
+msgid "<image src=\"media/icon-themes/cmd/lc_addfield.svg\" id=\"img_id621540674901837\" width=\"1.0cm\" height=\"1.0cm\"><alt id=\"alt_id491540674901837\">Add field icon</alt></image>"
+msgstr ""
+
+#: rep_insertfield.xhp
+msgctxt ""
+"rep_insertfield.xhp\n"
+"par_id121540674874655\n"
+"help.text"
+msgid "Click the Add Field icon on the toolbar."
+msgstr ""
+
+#: rep_insertfield.xhp
+msgctxt ""
+"rep_insertfield.xhp\n"
+"par_id141540563922693\n"
+"help.text"
+msgid "Select the field in the Add Field dialog and click <emph>Insert</emph>. You can select multiples fields pressing the <switchinline select=\"sys\">                    <caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline>                    </switchinline> key while clicking on the fields name or using the Shift key while pressing the mouse button. Click <emph>Insert</emph> in the toolbar to add the fields to the report."
+msgstr ""
+
+#: rep_insertfield.xhp
+msgctxt ""
+"rep_insertfield.xhp\n"
+"par_id4051026\n"
+"help.text"
+msgid "Drag and drop the field names one by one from the Add Field window into the Detail area of the report. Position the fields as you like. Use the icons in the toolbars to align the fields."
+msgstr ""
+
+#: rep_insertfield.xhp
+msgctxt ""
+"rep_insertfield.xhp\n"
+"par_id3397320\n"
+"help.text"
+msgid "It is not possible to overlap the fields. If you drop a table field on the Detail area, then a label and a text box are inserted."
+msgstr ""
+
+#: rep_insertfield.xhp
+msgctxt ""
+"rep_insertfield.xhp\n"
+"par_id3059785\n"
+"help.text"
+msgid "You can also insert text that should be the same on every page of the report. Click the Label Field icon <image id=\"img_id5605334\" src=\"media/icon-themes/cmd/lc_addfield.svg\" width=\"0.566cm\" height=\"0.566cm\" localize=\"true\"><alt id=\"alt_id5605334\">Icon</alt></image>, then drag a rectangle in the Page Header or Page Footer area. Edit the Label property to show the text you want."
+msgstr ""
+
+#: rep_insertfield.xhp
+msgctxt ""
+"rep_insertfield.xhp\n"
+"hd_id251540563929787\n"
+"help.text"
+msgid "Sorting fields names"
+msgstr ""
+
+#: rep_insertfield.xhp
+msgctxt ""
+"rep_insertfield.xhp\n"
+"par_id651540564204840\n"
+"help.text"
+msgid "<image src=\"media/icon-themes/cmd/sc_sortascending.svg\" id=\"img_id631540564204841\" width=\"1.0cm\" height=\"1.0cm\"><alt id=\"alt_id141540564204841\">Sort Ascending icon</alt></image>"
+msgstr ""
+
+#: rep_insertfield.xhp
+msgctxt ""
+"rep_insertfield.xhp\n"
+"par_id401540563992665\n"
+"help.text"
+msgid "Sort names ascending."
+msgstr ""
+
+#: rep_insertfield.xhp
+msgctxt ""
+"rep_insertfield.xhp\n"
+"par_id811540564184191\n"
+"help.text"
+msgid "<image src=\"media/icon-themes/cmd/sc_sortdescending.svg\" id=\"img_id391540564184192\" width=\"1.0cm\" height=\"1.0cm\"><alt id=\"alt_id571540564184192\">Sort descending icon</alt></image>"
+msgstr ""
+
+#: rep_insertfield.xhp
+msgctxt ""
+"rep_insertfield.xhp\n"
+"par_id401540563942665\n"
+"help.text"
+msgid "Sort names descending,"
+msgstr ""
+
+#: rep_insertfield.xhp
+msgctxt ""
+"rep_insertfield.xhp\n"
+"par_id851540564212907\n"
+"help.text"
+msgid "<image src=\"media/icon-themes/cmd/lc_removefiltersort.svg\" id=\"img_id41540564212907\" width=\"1.0cm\" height=\"1.0cm\"><alt id=\"alt_id421540564212908\">Undo sorting icon</alt></image>"
+msgstr ""
+
+#: rep_insertfield.xhp
+msgctxt ""
+"rep_insertfield.xhp\n"
+"par_id401540533942665\n"
+"help.text"
+msgid "Restore original sorting"
+msgstr ""
+
 #: rep_main.xhp
 msgctxt ""
 "rep_main.xhp\n"
@@ -11277,48 +11037,8 @@ msgctxt ""
 "rep_main.xhp\n"
 "par_id2531815\n"
 "help.text"
-msgid "The Add Field window opens automatically and shows all fields of the selected table."
-msgstr "La finestra Comandi di campo si apre automaticamente e mostra tutti i campi della tabella selezionata."
-
-#: rep_main.xhp
-msgctxt ""
-"rep_main.xhp\n"
-"par_id5927304\n"
-"help.text"
-msgid "To insert fields into the report"
-msgstr "Per inserire dei campi all'interno del rapporto"
-
-#: rep_main.xhp
-msgctxt ""
-"rep_main.xhp\n"
-"par_id4503921\n"
-"help.text"
-msgid "The Add Field window helps you to insert the table entries in the report. Click the Add Field icon in the toolbar to open the Add Field window."
-msgstr "La finestra di dialogo Aggiungi campo vi aiuta a inserire le voci di tabella all'interno del rapporto. Per aprire la finestra Aggiungi campo, fate clic sull'icona corrispondente nella barra degli strumenti."
-
-#: rep_main.xhp
-msgctxt ""
-"rep_main.xhp\n"
-"par_id4051026\n"
-"help.text"
-msgid "Drag and drop the field names one by one from the Add Field window into the Detail area of the report. Position the fields as you like. Use the icons in the toolbars to align the fields."
-msgstr "Trascinate e copiate singolarmente i nomi dei campi dalla finestra Aggiungi campo all'interno dell'area Dettaglio del rapporto. Disponete i campi nel modo desiderato. Usate le icone nella barra degli strumenti per allineare i campi."
-
-#: rep_main.xhp
-msgctxt ""
-"rep_main.xhp\n"
-"par_id3397320\n"
-"help.text"
-msgid "It is not possible to overlap the fields. If you drop a table field on the Detail area, then a label and a text box are inserted."
-msgstr "Non è possibile sovrapporre i campi. Se copiate un campo tabella nell'area Dettaglio, vi saranno anche inseriti una didascalia e una casella di testo."
-
-#: rep_main.xhp
-msgctxt ""
-"rep_main.xhp\n"
-"par_id3059785\n"
-"help.text"
-msgid "You can also insert text that should be the same on every page of the report. Click the Label Field icon<image id=\"img_id5605334\" src=\"cmd/sc_label.png\" width=\"0.566cm\" height=\"0.566cm\" localize=\"true\"><alt id=\"alt_id5605334\">Icon</alt></image>, then drag a rectangle in the Page Header or Page Footer area. Edit the Label property to show the text you want."
-msgstr "Potete anche inserire testo che dovrà essere uguale per qualsiasi pagina del rapporto. Fate clic sull'icona Didascalia <image id=\"img_id5605334\" src=\"cmd/sc_label.png\" width=\"0.566cm\" height=\"0.566cm\" localize=\"true\"><alt id=\"alt_id5605334\">Icona</alt></image>, poi trascinate un rettangolo nell'area d'intestazione della pagina o del piè di pagina. Modificate la proprietà della didascalia per visualizzare il testo desiderato."
+msgid "The <embedvar href=\"text/shared/explorer/database/rep_insertfield.xhp#addfields\" markup=\"ignore\"/> window opens automatically and shows all fields of the selected table."
+msgstr ""
 
 #: rep_main.xhp
 msgctxt ""
@@ -12029,8 +11749,8 @@ msgctxt ""
 "rep_prop.xhp\n"
 "par_id3587145\n"
 "help.text"
-msgid "<ahelp hid=\".\">The Add Field window is shown automatically when you have selected a table in the Contents box and leave that box. You can also click the Add Field icon on the toolbar, or choose <item type=\"menuitem\">View - Add Field</item>.</ahelp>"
-msgstr "<ahelp hid=\".\">La finestra Aggiungi campo appare automaticamente quando si seleziona una tabella nella casella Contenuto e poi si chiude la casella. Si può anche fare clic sull'icona Aggiungi campo nella barra degli strumenti, o scegliere <item type=\"menuitem\">Visualizza - Aggiungi campo</item>.</ahelp>"
+msgid "<ahelp hid=\".\">The <embedvar href=\"text/shared/explorer/database/rep_insertfield.xhp#addfields\" markup=\"ignore\"/>  window is shown automatically when you have selected a table in the Contents box and leave that box. You can also click the Add Field icon on the toolbar, or choose <item type=\"menuitem\">View - Add Field</item>.</ahelp>"
+msgstr ""
 
 #: rep_prop.xhp
 msgctxt ""
diff --git a/source/it/helpcontent2/source/text/shared/guide.po b/source/it/helpcontent2/source/text/shared/guide.po
index 2d6f9be2252..736df5ad172 100644
--- a/source/it/helpcontent2/source/text/shared/guide.po
+++ b/source/it/helpcontent2/source/text/shared/guide.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: \n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2018-09-03 13:23+0200\n"
+"POT-Creation-Date: 2018-11-12 12:23+0100\n"
 "PO-Revision-Date: 2018-09-03 10:49+0000\n"
 "Last-Translator: Valter Mura <valtermura@gmail.com>\n"
 "Language-Team: Italian <l10n@it.libreoffice.org>\n"
@@ -19253,8 +19253,8 @@ msgctxt ""
 "version_number.xhp\n"
 "par_id3147008\n"
 "help.text"
-msgid "<link href=\"http://www.libreoffice.org/about-us/credits/\">See lists of code and Wiki contributors</link> on the LibreOffice website."
-msgstr "<link href=\"http://www.libreoffice.org/about-us/credits/\">Consultate la lista dei contributori di codice e del wiki </link> sul sito di LibreOffice."
+msgid "<link href=\"https://www.libreoffice.org/about-us/credits/\">See lists of code and Wiki contributors</link> on the LibreOffice website."
+msgstr ""
 
 #: viewing_file_properties.xhp
 msgctxt ""
@@ -19709,8 +19709,8 @@ msgctxt ""
 "xsltfilter_create.xhp\n"
 "bm_id7007583\n"
 "help.text"
-msgid "<bookmark_value>testing XML filters</bookmark_value><bookmark_value>XML filters;creating/testing</bookmark_value>"
-msgstr "<bookmark_value>Verifica dei filtri XML </bookmark_value><bookmark_value>Filtro XML ;creazione/verifica</bookmark_value>"
+msgid "<bookmark_value>testing XML filters</bookmark_value><bookmark_value>XML filters; creating/testing</bookmark_value>"
+msgstr ""
 
 #: xsltfilter_create.xhp
 msgctxt ""
@@ -19741,8 +19741,8 @@ msgctxt ""
 "xsltfilter_create.xhp\n"
 "par_idN109B0\n"
 "help.text"
-msgid "For more information about the OpenDocument XML format, go to <link href=\"http://xml.openoffice.org/\">http://xml.openoffice.org/</link>."
-msgstr "Per ulteriori informazioni sul formato XML OpenDocument, consultate <link href=\"http://xml.openoffice.org/\">http://xml.openoffice.org/</link>."
+msgid "For more information about the OpenDocument XML format, go to <link href=\"https://www.openoffice.org/xml/\">https://www.openoffice.org/xml/</link>."
+msgstr ""
 
 #: xsltfilter_create.xhp
 msgctxt ""
@@ -19973,8 +19973,8 @@ msgctxt ""
 "xsltfilter_create.xhp\n"
 "par_idN10A82\n"
 "help.text"
-msgid "To test an <emph>Export</emph> Filter, do one of the following in the <emph>Export</emph> area of the dialog:"
-msgstr "Per verificare il funzionamento di un filtro di <emph>esportazione</emph>, nell'area <emph>Esporta</emph> della finestra di dialogo utilizzate una delle procedure seguenti:"
+msgid "To test an <emph>Export</emph> filter, do one of the following in the <emph>Export</emph> area of the dialog:"
+msgstr ""
 
 #: xsltfilter_create.xhp
 msgctxt ""
@@ -19997,8 +19997,8 @@ msgctxt ""
 "xsltfilter_create.xhp\n"
 "par_idN10A99\n"
 "help.text"
-msgid "To test an <emph>Import</emph> Filter, click <emph>Browse</emph> in the <emph>Import</emph> area of the dialog, select a document, and click <emph>Open</emph>."
-msgstr "Per verificare un filtro di <emph>importazione</emph>, fate clic su <emph>Sfoglia</emph> nell'area <emph>Importa</emph> della finestra di dialogo, selezionate un documento e fate clic su <emph>Apri</emph>."
+msgid "To test an <emph>Import</emph> filter, click <emph>Browse</emph> in the <emph>Import</emph> area of the dialog, select a document, and click <emph>Open</emph>."
+msgstr ""
 
 #: xsltfilter_create.xhp
 msgctxt ""
diff --git a/source/it/helpcontent2/source/text/shared/help.po b/source/it/helpcontent2/source/text/shared/help.po
index 736d54c43f6..65ab52bca3b 100644
--- a/source/it/helpcontent2/source/text/shared/help.po
+++ b/source/it/helpcontent2/source/text/shared/help.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2018-09-03 13:23+0200\n"
+"POT-Creation-Date: 2018-11-12 12:23+0100\n"
 "PO-Revision-Date: 2018-06-12 12:27+0000\n"
 "Last-Translator: Valter Mura <valtermura@gmail.com>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -53,7 +53,7 @@ msgctxt ""
 "browserhelp.xhp\n"
 "par_id601525734140935\n"
 "help.text"
-msgid "<variable id=\"index\">Index</variable>"
+msgid "<variable id=\"index\">Index of chosen module</variable>"
 msgstr ""
 
 #: browserhelp.xhp
diff --git a/source/it/helpcontent2/source/text/shared/optionen.po b/source/it/helpcontent2/source/text/shared/optionen.po
index 9c6f8479540..8986f807b91 100644
--- a/source/it/helpcontent2/source/text/shared/optionen.po
+++ b/source/it/helpcontent2/source/text/shared/optionen.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: \n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2018-10-02 17:56+0200\n"
+"POT-Creation-Date: 2018-11-12 12:23+0100\n"
 "PO-Revision-Date: 2018-06-13 12:49+0000\n"
 "Last-Translator: Valter Mura <valtermura@gmail.com>\n"
 "Language-Team: Italian <l10n@it.libreoffice.org>\n"
@@ -7499,6 +7499,14 @@ msgstr "<ahelp hid=\"modules/swriter/ui/optcaptionpage/level\">Specifica il live
 #: 01041100.xhp
 msgctxt ""
 "01041100.xhp\n"
+"hd_id661541680699404\n"
+"help.text"
+msgid "Separator"
+msgstr ""
+
+#: 01041100.xhp
+msgctxt ""
+"01041100.xhp\n"
 "par_id3153524\n"
 "help.text"
 msgid "<ahelp hid=\"modules/swriter/ui/optcaptionpage/chapseparator\">Defines the character to be displayed after the number of the heading or chapter level.</ahelp>"
@@ -7525,8 +7533,8 @@ msgctxt ""
 "01041100.xhp\n"
 "par_idN106B4\n"
 "help.text"
-msgid "<ahelp hid=\".\">Specifies the character style.</ahelp>"
-msgstr "<ahelp hid=\".\">Specifica lo stile di carattere.</ahelp>"
+msgid "<ahelp hid=\".\">Specifies the character style of the caption paragraph.</ahelp>"
+msgstr ""
 
 #: 01041100.xhp
 msgctxt ""
diff --git a/source/it/helpcontent2/source/text/smath.po b/source/it/helpcontent2/source/text/smath.po
index 80ae26f54f3..4b95b57332a 100644
--- a/source/it/helpcontent2/source/text/smath.po
+++ b/source/it/helpcontent2/source/text/smath.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2018-10-21 20:57+0200\n"
+"POT-Creation-Date: 2018-11-12 12:23+0100\n"
 "PO-Revision-Date: 2017-01-03 16:07+0000\n"
 "Last-Translator: Valter Mura <valtermura@gmail.com>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -61,8 +61,8 @@ msgctxt ""
 "main0000.xhp\n"
 "par_id3143269\n"
 "help.text"
-msgid "Have a look at <link href=\"http://www.dmaths.org\">www.dmaths.org</link> for a set of additional %PRODUCTNAME Math icons and macros."
-msgstr "Vedere <link href=\"http://www.dmaths.org\">www.dmaths.org</link> per altre icone e macro di %PRODUCTNAME Math."
+msgid "Have a look at <link href=\"https://www.dmaths.org\">www.dmaths.org</link> for a set of additional %PRODUCTNAME Math icons and macros."
+msgstr ""
 
 #: main0100.xhp
 msgctxt ""
diff --git a/source/it/helpcontent2/source/text/smath/01.po b/source/it/helpcontent2/source/text/smath/01.po
index f7f98277339..c0ca0c77313 100644
--- a/source/it/helpcontent2/source/text/smath/01.po
+++ b/source/it/helpcontent2/source/text/smath/01.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: \n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2018-07-31 14:10+0200\n"
+"POT-Creation-Date: 2018-11-12 12:23+0100\n"
 "PO-Revision-Date: 2018-08-24 19:09+0000\n"
 "Last-Translator: Valter Mura <valtermura@gmail.com>\n"
 "Language-Team: Italian <l10n@it.libreoffice.org>\n"
@@ -13,7 +13,7 @@ msgstr ""
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=2; plural=(n != 1);\n"
 "X-Accelerator-Marker: ~\n"
-"X-Generator: Pootle 2.8\n"
+"X-Generator: LibreOffice\n"
 "X-POOTLE-MTIME: 1535137771.000000\n"
 
 #: 02080000.xhp
@@ -12365,16 +12365,16 @@ msgctxt ""
 "06020000.xhp\n"
 "par_id3153916\n"
 "help.text"
-msgid "The <emph>Insert</emph> dialog is set up like the <link href=\"text/shared/01/01020000.xhp\" name=\"Open\">Open</link> dialog under <emph>File</emph>. Use the <emph>Insert</emph> dialog to load, edit and display a formula saved as a file in the <emph>Commands</emph> window."
-msgstr "La finestra di dialogo <emph>Inserisci</emph> è analoga alla finestra di dialogo <link href=\"text/shared/01/01020000.xhp\" name=\"Apri\">Apri</link> del menu <emph>File</emph> e vi consente di caricare, modificare e visualizzare una formula salvata come file nella finestra <emph>Comandi</emph>."
+msgid "The <emph>Insert</emph> dialog is set up like the <link href=\"text/shared/01/01020000.xhp\" name=\"Open\"><emph>Open</emph></link> dialog under <emph>File</emph>. Use the <emph>Insert</emph> dialog to load, edit and display a formula saved as a file in the <emph>Commands</emph> window."
+msgstr ""
 
 #: 06020000.xhp
 msgctxt ""
 "06020000.xhp\n"
 "par_id3153917\n"
 "help.text"
-msgid "You can import MathML files created by other applications as well. The MathML source must have a <item type=\"code\">math</item> element with an <item type=\"code\">xmlns</item> attribute with value \"http://www.w3.org/1998/Math/MathML\". The languages MathML and StarMath are not fully compatible, therefore you should revise the import result. For details about the language MathML see its <link href=\"http://www.w3.org/TR/#tr_MathML\">specification</link>."
-msgstr "Potete anche importare i file MathML creati da altre applicazioni. L'origine MathML deve contenere un elemento <item type=\"code\">math</item> con un attributo <item type=\"code\">xmlns</item> con valore \"http://www.w3.org/1998/Math/MathML\". I linguaggi MathML e StarMath non sono totalmente compatibili, dunque dovrete controllare il risultato dell'importazione. Per dettagli sul linguaggio MathML consultate le sue <link href=\"http://www.w3.org/TR/#tr_MathML\">specifiche</link>."
+msgid "You can import MathML files created by other applications as well. The MathML source must have a <item type=\"code\">math</item> element with an <item type=\"code\">xmlns</item> attribute with value \"http://www.w3.org/1998/Math/MathML\". The languages MathML and StarMath are not fully compatible, therefore you should revise the import result. For details about the language MathML see its <link href=\"https://www.w3.org/TR/#tr_MathML\">specification</link>."
+msgstr ""
 
 #: 06020000.xhp
 msgctxt ""
@@ -12421,5 +12421,5 @@ msgctxt ""
 "06020000.xhp\n"
 "par_id3153919\n"
 "help.text"
-msgid "This command handles only MathML content. If you have copied a %PRODUCTNAME Math formula to clipboard, insert it using the command <link href=\"text/shared/01/02060000.xhp\" name=\"Paste\">Paste</link> under <emph>Edit</emph>."
-msgstr "Questo comando gestisce solo contenuto MathML. Se avete copiato una formula %PRODUCTNAME Math negli appunti, inseritela utilizzando il comando <link href=\"text/shared/01/02060000.xhp\" name=\"Incolla\">Incolla</link> sotto <emph>Modifica</emph>."
+msgid "This command handles only MathML content. If you have copied a %PRODUCTNAME Math formula to clipboard, insert it using the command <link href=\"text/shared/01/02060000.xhp\" name=\"Paste\"><emph>Paste</emph></link> under <emph>Edit</emph>."
+msgstr ""
diff --git a/source/it/helpcontent2/source/text/swriter/guide.po b/source/it/helpcontent2/source/text/swriter/guide.po
index aa2653a5955..452db48295f 100644
--- a/source/it/helpcontent2/source/text/swriter/guide.po
+++ b/source/it/helpcontent2/source/text/swriter/guide.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: \n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2018-09-03 13:23+0200\n"
+"POT-Creation-Date: 2018-11-05 17:38+0100\n"
 "PO-Revision-Date: 2018-04-11 13:02+0000\n"
 "Last-Translator: Valter Mura <valtermura@gmail.com>\n"
 "Language-Team: Italian <l10n@it.libreoffice.org>\n"
@@ -7550,8 +7550,8 @@ msgctxt ""
 "indices_literature.xhp\n"
 "par_id3155900\n"
 "help.text"
-msgid "Choose <emph>Insert - Record</emph>."
-msgstr "Scegliete <emph>Inserisci - Record di dati</emph>."
+msgid "Choose <emph>Data - Record</emph>."
+msgstr ""
 
 #: indices_literature.xhp
 msgctxt ""
@@ -10934,8 +10934,8 @@ msgctxt ""
 "print_preview.xhp\n"
 "par_id3149847\n"
 "help.text"
-msgid "Choose <emph>File</emph> - <emph>Print Preview</emph>."
-msgstr "Selezionate il comando <emph>Anteprima di stampa </emph> dal menu <emph>File</emph>."
+msgid "Choose <emph>File - Print Preview</emph>."
+msgstr ""
 
 #: print_preview.xhp
 msgctxt ""
author	Christian Lohmaier <lohmaier+LibreOffice@googlemail.com>	2018-11-12 23:58:17 +0100
committer	Christian Lohmaier <lohmaier+LibreOffice@googlemail.com>	2018-11-13 00:04:09 +0100
commit	dee42a39ff84aae292b56cf83137983da5c28975 (patch)
tree	d60b875d95ccd2f4b5b2157824ba2b2cebcc7b2a /source/it/helpcontent2
parent	f14221545cf5a1be2c6f74915bcaff29db79a85d (diff)