Consulta la guida di stile del progetto. Se riscontri errori/refusi nella traduzione, invia un messaggio alla mailing list della localizzazione l10n@it.libreoffice.org. Grazie per la tua preziosa collaborazione!

Overview

Project website www.libreoffice.org
Translation process
  • Translations can be made directly.
  • Translation suggestions can be made.
  • Any authenticated user can contribute.
  • The translation uses bilingual files.
Translation license Mozilla Public License 2.0
Filemask */helpcontent2/source/text/scalc/guide.po
Translation file Download it/helpcontent2/source/text/scalc/guide.po
Last change Jan. 17, 2022, 10:09 p.m.
Last author Valter Mura

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 1,536 25,079 199,645
Translated 100% 1,536 100% 25,079 100% 199,645
Needs editing 0% 0 0% 0 0% 0
Failing checks 1% 5 1% 6 1% 48
Strings with suggestions 0% 0 0% 0 0% 0
Not translated strings 0% 0 0% 0 0% 0
Last year Previous

Activity in last 12 months

2 changes 97 changes 4 changes 2 changes 0 changes 4 changes 2 changes 2 changes 0 changes 0 changes 32 changes 0 changes 24 changes 37 changes 29 changes 44 changes 0 changes 4 changes 3 changes 4 changes 2 changes 0 changes 4 changes 23 changes
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

Quick numbers

25,079
Hosted words
1,536
Hosted strings
100%
Translated
1
Contributors
and previous 30 days

Trends of last 30 days

—
Hosted words
—
—
Hosted strings
—
+5%
Translated
—
+100%
Contributors
—
User avatar valtermura

Translation uploaded

LibreOffice Help - master / text/scalc/guide — Italian

Wildcard comparisons are <emph>not</emph> case sensitive, hence "A?" will match both "A1" and "a1".
I confronti con caratteri jolly <emph>non</emph> distinguono tra maiuscole e minuscole, dunque "A?" individuerà sia "A1", sia "a1".
6 hours ago
User avatar valtermura

Translation uploaded

LibreOffice Help - master / text/scalc/guide — Italian

<input>=SUMIF(A1:A5;"A??";B1:B5)</input> sums the values in <emph>B1:B5</emph> whose corresponding values in <emph>A1:A5</emph> start with "A" followed by exactly two other characters.
<input>=SOMMA.SE(A1:A5;"A??";B1:B5)</input> somma i valori nell'intervallo <emph>B1:B5</emph> i cui valori corrispondenti in <emph>A1:A5</emph> iniziano per "A" seguito esattamente da altri due caratteri.
6 hours ago
User avatar valtermura

Translation uploaded

LibreOffice Help - master / text/scalc/guide — Italian

<input>=COUNTIF(A1:A10;"Chi*")</input> counts the number of cells in the range <emph>A1:A10</emph> containing strings that start with "Chi" followed by zero or more characters.
<input>=CONTA.SE(A1:A10;"Chi*")</input> conta il numero di celle nell'intervallo <emph>A1:A10</emph> contenente le stringhe che iniziano per "Chi" seguito da zero o più caratteri.
6 hours ago
User avatar valtermura

Translation uploaded

LibreOffice Help - master / text/scalc/guide — Italian

The following examples consider that the options <menuitem>Enable wildcards in formulas</menuitem> and <menuitem>Search criteria = and <> must apply to whole cells</menuitem> are enabled in <switchinline select="sys"><caseinline select="MAC"><menuitem>%PRODUCTNAME - Preferences - %PRODUCTNAME Calc - Calculate</menuitem></caseinline><defaultinline><menuitem>Tools - Options - %PRODUCTNAME Calc - Calculate</menuitem></defaultinline></switchinline>.
Gli esempi che seguono considerano che siano abilitate le opzioni <menuitem>Permetti caratteri jolly nelle formule</menuitem> e <menuitem>I criteri di ricerca = e <> devono riferirsi a celle intere</menuitem> in <switchinline select="sys"><caseinline select="MAC"><menuitem>%PRODUCTNAME - Preferenze - %PRODUCTNAME Calc - Calcola</menuitem></caseinline><defaultinline><menuitem>Strumenti - Opzioni - %PRODUCTNAME Calc - Calcola</menuitem></defaultinline></switchinline>.
6 hours ago
User avatar valtermura

Translation uploaded

LibreOffice Help - master / text/scalc/guide — Italian

<emph>Other functions:</emph> MATCH and SEARCH.
<emph>Altre funzioni:</emph> CONFRONTA e RICERCA.
6 hours ago
User avatar valtermura

Translation uploaded

LibreOffice Help - master / text/scalc/guide — Italian

<emph>Lookup functions:</emph> HLOOKUP, LOOKUP and VLOOKUP.
<emph>Funzioni di ricerca:</emph> CERCA.ORIZZ, CERCA e CERCA.VERT.
6 hours ago
User avatar valtermura

Translation uploaded

LibreOffice Help - master / text/scalc/guide — Italian

<emph>Conditional functions:</emph> AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS, MAXIFS, MINIFS, SUMIF and SUMIFS.
<emph>Funzioni condizionali:</emph> MEDIA.SE, MEDIA.PIÙ.SE, CONTA.SE, CONTA.PIÙ.SE, MAX.PIÙ.SE, MIN.PIÙ.SE, SOMMA.SE e SOMMA.PIÙ.SE.
6 hours ago
User avatar valtermura

Translation uploaded

LibreOffice Help - master / text/scalc/guide — Italian

<emph>Database functions:</emph> DAVERAGE, DCOUNT, DCOUNTA, DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR and DVARP.
<emph>Funzioni di database:</emph> DB.MEDIA, DB.CONTA.NUMERI, DB.CONTA.VALORI, DB.VALORI, DB.MAX, DB.MIN, DB.PRODOTTO, DB.DEV.ST, DB.DEV.ST.POP, DB.SOMMA, DB.VAR e DB.VAR.POP.
6 hours ago
User avatar valtermura

Translation uploaded

LibreOffice Help - master / text/scalc/guide — Italian

Wildcards are supported by the following spreadsheet functions:
I caratteri jolly sono supportati dalle seguenti funzioni per foglio elettronico:
6 hours ago
User avatar valtermura

Translation uploaded

LibreOffice Help - master / text/scalc/guide — Italian

Wildcards are supported in %PRODUCTNAME Calc and in Microsoft Excel. Therefore, if interoperability between both applications is needed, choose to work with wildcards instead of regular expressions. Conversely, if interoperability is not necessary, consider using regular expressions for more powerful search capabilities.
I caratteri jolly sono supportati sia in %PRODUCTNAME Calc, sia in Microsoft Excel. Se è necessaria l'interoperabilità tra le due applicazioni, scegliete dunque di lavorare con i caratteri jolly anziché le espressioni regolari. Al contrario, se l'interoperabilità non è necessaria potete utilizzare le espressioni regolari, che possiedono una capacità di ricerca superiore.
6 hours ago
Browse all translation changes