Guida di LibreOffice 7.5
Applies the conditional formatting to the set of cells defined in the selected range. The formatting is applied based on the contents of the whole range.
Applies a color scale to a range consisting of displaying a bicolor or tricolor gradient on this range depending on the value of each cell.
The calculation of the color scale depends on 2 or 3 conditions, defined as follows:
Min (Max): effettua il calcolo utilizzando i valori minimi (massimi) dell'intervallo.
Value: a fixed value. Enter the value in the text box.
Percentile: A percentile is each of the 99 values which divide the sorted data in 100 equal parts, so that each part represents 1/100 of the sample population. A percentile return the value for a data series going from the smallest to the largest value in a set of data. For P = 25, the percentile means the first quartile. P = 50 is also the MEDIAN of the data set. Enter the percentile value in the text box. Valid values are from 0 to 100.
Percent: a fixed value representing the percentage of the minimum (maximum) of the length defined by minimum and maximum values in the range. A minimum of 10% selects the values below 10% of the segment [Min,Max]. A maximum of 80% select values above 80% of the segment [Min,Max]. Valid values are from 0 (zero) to 100. Do not enter a percent (%) sign.
Formula: A formula expression starting with the equal sign (=) that calculates a numeric value. Values can be numbers, dates or time. Enter the formula expression in the text box.
Data bar option will fill the cell with solid or gradient color corresponding to the numeric value in the cell.
The calculation of the bar area fill is based on the conditions below:
Automatico: esegue il calcolo utilizzando i valori minimi e massimi dell'intervallo.
Min (Max): esegue il calcolo utilizzando i valori minimi (massimi) dell'intervallo.
The Data Bar dialog opens to add details on the display of data bars.
Same as the conditions above.
Choose the color for positive and negative values.
Gradient: set a color scale between the color of positive (negative) values and white.
Color: use the positive (negative) color for the entire data bar, no fade out gradient.
Impostare la posizione dell'asse verticale per la barra dei dati. I valori sono
Automatic: position the vertical axis in the middle of the maximum and minimum values.
Middle: set the vertical axis in the middle of the column.
None: do not display a vertical axis.
Impostare la lunghezza minima (massima) delle barre dati in percentuale alla larghezza della colonna.
Do not display values in the cell, only the data bars.
Aggiunge un'icona alla cella in base al valore relativo alle soglie specificate. Sono disponibili diversi set di icone.
3, 4 or 5 - arrows
3, 4 or 5 - gray arrows
3 - flags
3 - semafori 1 e 2 (due modelli diversi)
3 - Faccine 1 e 2
3 - symbols
4 - circles from red to black
4 or 5 - ratings
5 - quarters
5 - boxes
Conditions to set the thresholds for each icon can be specified as follows