__ __ __ __ _____ _ _ _____ _ _ _ | \/ | \ \ / / | __ \ (_) | | / ____| | | | | | \ / |_ __\ V / | |__) | __ ___ ____ _| |_ ___ | (___ | |__ ___| | | | |\/| | '__|> < | ___/ '__| \ \ / / _` | __/ _ \ \___ \| '_ \ / _ \ | | | | | | |_ / . \ | | | | | |\ V / (_| | || __/ ____) | | | | __/ | | |_| |_|_(_)_/ \_\ |_| |_| |_| \_/ \__,_|\__\___| |_____/|_| |_|\___V 2.1 if you need WebShell for Seo everyday contact me on Telegram Telegram Address : @jackleetFor_More_Tools:
<!DOCTYPE html>
<html lang="es" dir="ltr">
<head>
<base href="../../../../">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Conditional Formatting - All cells</title>
<link rel="shortcut icon" href="media/navigation/favicon.ico">
<link type="text/css" href="normalize.css" rel="Stylesheet">
<link type="text/css" href="prism.css" rel="Stylesheet">
<link type="text/css" href="default.css" rel="Stylesheet">
<script type="text/javascript" src="polyfills.js"></script><script type="text/javascript" src="languages.js"></script><script type="text/javascript" src="es/langnames.js"></script><script type="text/javascript" src="flexsearch.debug.js"></script><script type="text/javascript" src="prism.js"></script><script type="text/javascript" src="help2.js" defer></script><script type="text/javascript" src="a11y-toggle.js" defer></script><script type="text/javascript" src="paginathing.js" defer></script><script type="text/javascript" src="es/bookmarks.js" defer></script><script type="text/javascript" src="es/contents.js" defer></script><script type="text/javascript" src="help.js" defer></script><meta name="viewport" content="width=device-width,initial-scale=1">
</head>
<body>
<header id="TopLeftHeader"><a class="symbol" href="es/text/shared/05/new_help.html"><div></div></a><a class="logo" href="es/text/shared/05/new_help.html"><p dir="auto">Ayuda de LibreOffice 25.2</p></a><div class="dropdowns"><div class="modules">
<button type="button" data-a11y-toggle="modules-nav" id="modules" aria-haspopup="true" aria-expanded="false" aria-controls="modules-nav">Módulo</button><nav id="modules-nav" hidden=""></nav>
</div></div></header><aside class="leftside"><input id="accordion-1" name="accordion-menu" type="checkbox"><label for="accordion-1" dir="auto">Contenido</label><div id="Contents" class="contents-treeview"></div></aside><div id="SearchFrame"><div id="Bookmarks">
<input id="search-bar" type="search" class="search" placeholder="Buscar en los marcadores del módulo elegido" dir="auto"><div class="nav-container" tabindex="0"><nav class="index" dir="auto"></nav></div>
</div></div>
<div id="DisplayArea" itemprop="softwareHelp" itemscope="true" itemtype="http://schema.org/SoftwareApplication">
<noscript><div id="WarnJS"><h1 dir="auto">Active JavaScript en el navegador para mostrar las páginas de ayuda de LibreOffice.</h1></div></noscript>
<a id="bm_id631700682986631"></a>
<a id="allcells"></a>
<h1 id="hd_id861662937013389" dir="auto">
<a id="h1"></a>Condition - All cells</h1>
<p id="par_id31662915586650" class="paragraph" dir="auto">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.</p>
<a id="colorscale"></a>
<h2 id="hd_id3147394" dir="auto"><a target="_top" href="es/text/scalc/01/05120400.html#colorscale">Color Scale</a></h2>
<p id="par_id3155602" class="paragraph" dir="auto">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.</p>
<a id="howtoget"></a><div class="howtoget">
<div><p class="howtogetheader" dir="auto"><a id="wie"></a>Para acceder a esta orden…</p></div>
<div class="howtogetbody">
<div class="embedded">
<a id="s_conditionalcolorscale"></a>
<div class="embedded">
<a id="from_menu_bar"></a><h4 id="par_id441684934473786" dir="auto">Desde la barra de menús:</h4>
</div>
<p id="par_id31663542115011" class="paragraph" dir="auto"><a id="conditionalcolorscale"></a>Vaya a <span class="menuitem">Formato ▸ Condicional ▸ Escala de colores</span></p>
<div class="embedded">
<a id="from_tabUI"></a><h4 id="par_id711684934483926" dir="auto">Desde la interfaz en pestañas:</h4>
</div>
<p id="par_id201700683098791" class="paragraph" dir="auto">Vaya a <span class="menuitem">Inicio ▸ Condicional ▸ Escala de colores</span>.</p>
<div class="embedded">
<a id="from_toolbars"></a><h4 id="par_id101684936253402" dir="auto">Desde las barras de herramientas:</h4>
</div>
<div class="icontable">
<div class="iconcell">
<p id="par_id431663540719713" class="paragraphintable" dir="auto"> <img src="media/icon-themes/cmd/lc_colorscaleformatdialog.svg" class="iconimage" alt="Icono Escala de colores" style="width:38px;height:38px" itemprop="icon" itemscope="true" itemtype="http://schema.org/ImageObject"></p>
</div>
<div class="iconcell">
<p id="par_id841663540719717" class="paragraphintable" dir="auto">Escala de colores</p>
</div>
</div>
</div>
</div>
</div>
<br>
<h3 id="hd_id541663598275609" dir="auto">Condiciones</h3>
<p id="par_id231663598294535" class="paragraph" dir="auto">The calculation of the color scale depends on 2 or 3 conditions, defined as follows:</p>
<ul itemprop="Unordered" itemscope="true" itemtype="http://schema.org/ItemList" dir="auto">
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/ItemListUnordered" dir="auto">
<p id="par_id701864449697771" class="listitem" dir="auto"><span class="emph">Min (Max)</span>: calculates using the minimum (maximum) values in the range.</p>
</li>
</ul>
<a id="commonconditions"></a>
<ul itemprop="Unordered" itemscope="true" itemtype="http://schema.org/ItemList" dir="auto">
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/ItemListUnordered" dir="auto">
<p id="par_id321663440728295" class="listitem" dir="auto"><span class="emph">Value</span>: a fixed value. Enter the value in the text box.</p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/ItemListUnordered" dir="auto">
<p id="par_id611663440697270" class="listitem" dir="auto"><span class="emph">Percentile</span>: 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.</p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/ItemListUnordered" dir="auto">
<p id="par_id211663440834104" class="listitem" dir="auto"><span class="emph">Percent</span>: 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.</p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/ItemListUnordered" dir="auto">
<p id="par_id961663440848168" class="listitem" dir="auto"><span class="emph">Formula</span>: 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.</p>
</li>
</ul>
<div class="embedded">
<a id="conditionalformatting"></a>
<p id="par_id591563765191143" class="paragraph" dir="auto"></p>
</div>
<a id="bm_id631700683284747"></a>
<a id="databar"></a>
<h2 id="par_id991609782427459" dir="auto"><a target="_top" href="es/text/scalc/01/05120400.html#databar">Barra de datos</a></h2>
<p id="par_id41609780964157" class="paragraph" dir="auto">Data bar option fills the cell with solid or gradient color corresponding to the numeric value in the cell.</p>
<a id="howtoget"></a><div class="howtoget">
<div><p class="howtogetheader" dir="auto"><a id="wie"></a>Para acceder a esta orden…</p></div>
<div class="howtogetbody">
<div class="embedded">
<a id="s_conditionaldatabar"></a>
<div class="embedded">
<a id="from_menu_bar"></a><h4 id="par_id441684934473786" dir="auto">Desde la barra de menús:</h4>
</div>
<p id="par_id491663542108169" class="paragraph" dir="auto"><a id="conditionaldatabar"></a>Vaya a <span class="menuitem">Formato ▸ Condicional ▸ Barra de datos</span></p>
<div class="embedded">
<a id="from_tabUI"></a><h4 id="par_id711684934483926" dir="auto">Desde la interfaz en pestañas:</h4>
</div>
<p id="par_id631700683863203" class="paragraph" dir="auto">Vaya a <span class="menuitem">Inicio ▸ Condicional ▸ Barra de datos</span>.</p>
<div class="embedded">
<a id="from_toolbars"></a><h4 id="par_id101684936253402" dir="auto">Desde las barras de herramientas:</h4>
</div>
<div class="icontable">
<div class="iconcell">
<p id="par_id301663541161943" class="paragraphintable" dir="auto"> <img src="media/icon-themes/cmd/lc_databarformatdialog.svg" class="iconimage" alt="Icono Barra de datos" style="width:38px;height:38px" itemprop="icon" itemscope="true" itemtype="http://schema.org/ImageObject"></p>
</div>
<div class="iconcell">
<p id="par_id101663541161947" class="paragraphintable" dir="auto">Barra de datos</p>
</div>
</div>
</div>
</div>
</div>
<br>
<h3 id="hd_id631663449553346" dir="auto">Condiciones</h3>
<p id="par_id931609781970981" class="paragraph" dir="auto">El cálculo del relleno del área de la barra depende de las condiciones enumeradas a continuación:</p>
<ul itemprop="Unordered" itemscope="true" itemtype="http://schema.org/ItemList" dir="auto">
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/ItemListUnordered" dir="auto">
<p id="par_id281663449673792" class="listitem" dir="auto"><span class="emph">Automatic</span>: calculates using the minimum and maximum values in the range.</p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/ItemListUnordered" dir="auto">
<p id="par_id701663449697771" class="listitem" dir="auto"><span class="emph">Min (Max)</span>: calculates using the minimum (maximum) values in the range.</p>
</li>
</ul>
<div class="embedded">
<a id="commonconditions"></a>
<ul itemprop="Unordered" itemscope="true" itemtype="http://schema.org/ItemList" dir="auto">
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/ItemListUnordered" dir="auto">
<p id="par_id321663440728295" class="listitem" dir="auto"><span class="emph">Value</span>: a fixed value. Enter the value in the text box.</p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/ItemListUnordered" dir="auto">
<p id="par_id611663440697270" class="listitem" dir="auto"><span class="emph">Percentile</span>: 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.</p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/ItemListUnordered" dir="auto">
<p id="par_id211663440834104" class="listitem" dir="auto"><span class="emph">Percent</span>: 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.</p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/ItemListUnordered" dir="auto">
<p id="par_id961663440848168" class="listitem" dir="auto"><span class="emph">Formula</span>: 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.</p>
</li>
</ul>
</div>
<h3 id="par_id281609781729359" dir="auto">Más opciones</h3>
<p id="par_id501663454998977" class="paragraph" dir="auto">The Data Bar dialog opens to add details on the display of data bars.</p>
<h4 id="hd_id221663453502042" dir="auto">Entry values</h4>
<p id="par_id891663453681870" class="paragraph" dir="auto">Same as the conditions above.</p>
<h4 id="hd_id511663453530293" dir="auto">Colores de barra</h4>
<p id="par_id371663453564807" class="paragraph" dir="auto">Elija el color de los valores positivos y negativos.</p>
<h4 id="hd_id891663453607961" dir="auto">Relleno</h4>
<ul itemprop="Unordered" itemscope="true" itemtype="http://schema.org/ItemList" dir="auto">
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/ItemListUnordered" dir="auto">
<p id="par_id671663453639829" class="listitem" dir="auto"><span class="emph">Gradient</span>: set a color scale between the color of positive (negative) values and white.</p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/ItemListUnordered" dir="auto">
<p id="par_id551663453647462" class="listitem" dir="auto"><span class="emph">Color</span>: use the positive (negative) color for the entire data bar, no fade out gradient.</p>
</li>
</ul>
<h4 id="hd_id701663453750779" dir="auto">Eje</h4>
<p id="par_id691663453763746" class="paragraph" dir="auto">Set the position of the vertical axis for the data bar. Values are</p>
<ul itemprop="Unordered" itemscope="true" itemtype="http://schema.org/ItemList" dir="auto">
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/ItemListUnordered" dir="auto">
<p id="par_id381663453792294" class="listitem" dir="auto"><span class="emph">Automatic:</span> position the vertical axis in the middle of the maximum and minimum values.</p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/ItemListUnordered" dir="auto">
<p id="par_id791663453800602" class="listitem" dir="auto"><span class="emph">Middle:</span> set the vertical axis in the middle of the column.</p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/ItemListUnordered" dir="auto">
<p id="par_id461663453808288" class="listitem" dir="auto"><span class="emph">Ninguno</span>: el eje vertical no es visible.</p>
</li>
</ul>
<h4 id="hd_id511663453851599" dir="auto">Longitudes de barras</h4>
<p id="par_id601663453865023" class="paragraph" dir="auto">Sets the minimum (maximum) length of the data bars, as a percentage of the column width.</p>
<h4 id="hd_id211663453914830" dir="auto">Display bars only</h4>
<p id="par_id561663453936590" class="paragraph" dir="auto">Do not display values in the cell, only the data bars.</p>
<div class="embedded">
<a id="conditionalformatting"></a>
<p id="par_id591563765191143" class="paragraph" dir="auto"></p>
</div>
<a id="bm_id61700683386598"></a>
<a id="iconset"></a>
<h2 id="hd_id3153709" dir="auto"><a target="_top" href="es/text/scalc/01/05120400.html#iconset">Conjunto de iconos</a></h2>
<p id="par_id3153764" class="paragraph" dir="auto">Añada un icono a la celda en función del valor y umbrales especificados. Hay varios conjuntos de iconos a su disposición.</p>
<a id="howtoget"></a><div class="howtoget">
<div><p class="howtogetheader" dir="auto"><a id="wie"></a>Para acceder a esta orden…</p></div>
<div class="howtogetbody">
<div class="embedded">
<a id="s_conditionaliconset"></a>
<div class="embedded">
<a id="from_menu_bar"></a><h4 id="par_id441684934473786" dir="auto">Desde la barra de menús:</h4>
</div>
<p id="par_id851663542093712" class="paragraph" dir="auto"><a id="conditionaliconset"></a>Choose <span class="menuitem">Format - Conditional - Icon Set</span></p>
<div class="embedded">
<a id="from_tabUI"></a><h4 id="par_id711684934483926" dir="auto">Desde la interfaz en pestañas:</h4>
</div>
<p id="par_id951700683459372" class="paragraph" dir="auto">Vaya a <span class="menuitem">Inicio ▸ Condicional ▸ Conjunto de iconos</span>.</p>
<div class="embedded">
<a id="from_toolbars"></a><h4 id="par_id101684936253402" dir="auto">Desde las barras de herramientas:</h4>
</div>
<div class="icontable">
<div class="iconcell">
<p id="par_id51663541228728" class="paragraphintable" dir="auto"> <img src="media/icon-themes/cmd/lc_iconsetformatdialog.svg" class="iconimage" alt="Icono Conjunto de iconos" style="width:38px;height:38px" itemprop="icon" itemscope="true" itemtype="http://schema.org/ImageObject"></p>
</div>
<div class="iconcell">
<p id="par_id61663541228732" class="paragraphintable" dir="auto">Conjunto de iconos</p>
</div>
</div>
</div>
</div>
</div>
<br>
<h3 id="hd_id191663440362309" dir="auto">Conjuntos de iconos disponibles</h3>
<ul itemprop="Unordered" itemscope="true" itemtype="http://schema.org/ItemList" dir="auto">
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/ItemListUnordered" dir="auto">
<p id="par_id31494140" class="listitem" dir="auto">3, 4 o 5: flechas</p>
<p id="par_id91663429174806" class="paragraph" dir="auto"> <img src="media/icon-themes/sc/res/icon-set-colorarrows-up.svg" class="iconimage" alt="Color arrow up" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"> <img src="media/icon-themes/sc/res/icon-set-colorarrows-slightly-up.svg" class="iconimage" alt="Color arrow slightly up" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"> <img src="media/icon-themes/sc/res/icon-set-colorarrows-same.svg" class="iconimage" alt="Color arrow same" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"> <img src="media/icon-themes/sc/res/icon-set-colorarrows-slightly-down.svg" class="iconimage" alt="Color arrow slightly down" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"> <img src="media/icon-themes/sc/res/icon-set-colorarrows-down.svg" class="iconimage" alt="Color arrow down" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"></p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/ItemListUnordered" dir="auto">
<p id="par_id31494141" class="listitem" dir="auto">3, 4 o 5: flechas grises</p>
<p id="par_id91661429174806" class="paragraph" dir="auto"> <img src="media/icon-themes/sc/res/icon-set-grayarrows-up.svg" class="iconimage" alt="Gray arrow up" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"> <img src="media/icon-themes/sc/res/icon-set-grayarrows-slightly-up.svg" class="iconimage" alt="Gray arrow slightly up" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"> <img src="media/icon-themes/sc/res/icon-set-grayarrows-same.svg" class="iconimage" alt="Gray arrow same" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"> <img src="media/icon-themes/sc/res/icon-set-grayarrows-slightly-down.svg" class="iconimage" alt="Gray arrow slightly down" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"> <img src="media/icon-themes/sc/res/icon-set-grayarrows-down.svg" class="iconimage" alt="Gray arrow down" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"></p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/ItemListUnordered" dir="auto">
<p id="par_id31494142" class="listitem" dir="auto">3: banderas</p>
<p id="par_id101663433624185" class="paragraph" dir="auto"> <img src="media/icon-themes/sc/res/icon-set-flags-yellow.svg" class="iconimage" alt="Yellow flag" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"> <img src="media/icon-themes/sc/res/icon-set-flags-red.svg" class="iconimage" alt="Red flag" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"> <img src="media/icon-themes/sc/res/icon-set-flags-green.svg" class="iconimage" alt="Green flag" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"></p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/ItemListUnordered" dir="auto">
<p id="par_id31494143" class="listitem" dir="auto">3: luces de semáforo 1 y 2 (dos diseños diferentes)</p>
<p id="par_id721663433917655" class="paragraph" dir="auto"> <img src="media/icon-themes/sc/res/icon-set-circles1-yellow.svg" class="iconimage" alt="Yellow traffic light 1" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"> <img src="media/icon-themes/sc/res/icon-set-circles1-red.svg" class="iconimage" alt="Red traffic light 1" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"> <img src="media/icon-themes/sc/res/icon-set-circles1-green.svg" class="iconimage" alt="Green traffic light 1" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"></p>
<p id="par_id501663433925207" class="paragraph" dir="auto"> <img src="media/icon-themes/sc/res/icon-set-trafficlights-yellow.svg" class="iconimage" alt="Yellow traffic light 2" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"> <img src="media/icon-themes/sc/res/icon-set-trafficlights-red.svg" class="iconimage" alt="Red traffic light 2" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"> <img src="media/icon-themes/sc/res/icon-set-trafficlights-green.svg" class="iconimage" alt="Green traffic light 2" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"></p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/ItemListUnordered" dir="auto">
<p id="par_id701663438522480" class="listitem" dir="auto">3 - Smileys 1 and 2</p>
<p id="par_id991663438568052" class="paragraph" dir="auto"> <img src="media/icon-themes/sc/res/icon-set-positive-yellow-smilie.svg" class="iconimage" alt="Yellow positive smiley" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"> <img src="media/icon-themes/sc/res/icon-set-neutral-yellow-smilie.svg" class="iconimage" alt="Yellow neutral smiley" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"> <img src="media/icon-themes/sc/res/icon-set-negative-yellow-smilie.svg" class="iconimage" alt="Yellow negative smiley" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"></p>
<p id="par_id991663438966721" class="paragraph" dir="auto"> <img src="media/icon-themes/sc/res/icon-set-positive-green-smilie.svg" class="iconimage" alt="Green positive smiley" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"> <img src="media/icon-themes/sc/res/icon-set-neutral-yellow-smilie.svg" class="iconimage" alt="Yellow neutral smiley" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"> <img src="media/icon-themes/sc/res/icon-set-negative-red-smilie.svg" class="iconimage" alt="Red negative smiley" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"></p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/ItemListUnordered" dir="auto">
<p id="par_id31494144" class="listitem" dir="auto">3 - symbols</p>
<p id="par_id421663434453517" class="paragraph" dir="auto"> <img src="media/icon-themes/sc/res/icon-set-shapes-triangle.svg" class="iconimage" alt="Shape triangle" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"> <img src="media/icon-themes/sc/res/icon-set-shapes-diamond.svg" class="iconimage" alt="Shape diamond" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"> <img src="media/icon-themes/sc/res/icon-set-shapes-circle.svg" class="iconimage" alt="Shape circle" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"></p>
<p id="par_id961663439450424" class="paragraph" dir="auto"> <img src="media/icon-themes/sc/res/icon-set-symbols1-exclamation-mark.svg" class="iconimage" alt="Exclamation mark" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"> <img src="media/icon-themes/sc/res/icon-set-symbols1-cross.svg" class="iconimage" alt="Cross" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"> <img src="media/icon-themes/sc/res/icon-set-symbols1-check.svg" class="iconimage" alt="Check mark" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"></p>
<p id="par_id1001663439805133" class="paragraph" dir="auto"> <img src="media/icon-themes/sc/res/icon-set-stars-empty.svg" class="iconimage" alt="Empty star" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"> <img src="media/icon-themes/sc/res/icon-set-stars-half.svg" class="iconimage" alt="Half star" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"> <img src="media/icon-themes/sc/res/icon-set-stars-full.svg" class="iconimage" alt="Full star" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"></p>
<p id="par_id171663440020964" class="paragraph" dir="auto"> <img src="media/icon-themes/sc/res/icon-set-triangles-up.svg" class="iconimage" alt="Triangle up" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"> <img src="media/icon-themes/sc/res/icon-set-triangles-same.svg" class="iconimage" alt="Same" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"> <img src="media/icon-themes/sc/res/icon-set-triangles-down.svg" class="iconimage" alt="Triangle down" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"></p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/ItemListUnordered" dir="auto">
<p id="par_id31494145" class="listitem" dir="auto">4: círculos de rojo a negro</p>
<p id="par_id481663434995022" class="paragraph" dir="auto"> <img src="media/icon-themes/sc/res/icon-set-circles2-dark-red.svg" class="iconimage" alt="Dark red" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"> <img src="media/icon-themes/sc/res/icon-set-circles2-light-red.svg" class="iconimage" alt="Light red" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"> <img src="media/icon-themes/sc/res/icon-set-circles2-light-gray.svg" class="iconimage" alt="Light gray" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"> <img src="media/icon-themes/sc/res/icon-set-circles2-dark-gray.svg" class="iconimage" alt="Dark gray" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"></p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/ItemListUnordered" dir="auto">
<p id="par_id31494146" class="listitem" dir="auto">4 o 5: valoraciones</p>
<p id="par_id631663435728155" class="paragraph" dir="auto"> <img src="media/icon-themes/sc/res/icon-set-bars-empty.svg" class="iconimage" alt="Empty bars" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"> <img src="media/icon-themes/sc/res/icon-set-bars-one-quarter.svg" class="iconimage" alt="One quarters bars" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"> <img src="media/icon-themes/sc/res/icon-set-bars-half.svg" class="iconimage" alt="Half bars" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"> <img src="media/icon-themes/sc/res/icon-set-bars-three-quarters.svg" class="iconimage" alt="Three quarters bars" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"> <img src="media/icon-themes/sc/res/icon-set-bars-full.svg" class="iconimage" alt="Full bars" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"></p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/ItemListUnordered" dir="auto">
<p id="par_id31494147" class="ilistitem" dir="auto">5: cuartos</p>
<p id="par_id741663436015689" class="paragraph" dir="auto"> <img src="media/icon-themes/sc/res/icon-set-pies-empty.svg" class="iconimage" alt="Empty" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"> <img src="media/icon-themes/sc/res/icon-set-pies-one-quarter.svg" class="iconimage" alt="One quarter" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"> <img src="media/icon-themes/sc/res/icon-set-pies-half.svg" class="iconimage" alt="Half" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"> <img src="media/icon-themes/sc/res/icon-set-pies-three-quarters.svg" class="iconimage" alt="Three quarters" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"> <img src="media/icon-themes/sc/res/icon-set-pies-full.svg" class="iconimage" alt="Full" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"></p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/ItemListUnordered" dir="auto">
<p id="par_id821663436639070" class="listitem" dir="auto">5 - boxes</p>
<p id="par_id811663438472751" class="paragraph" dir="auto"> <img src="media/icon-themes/sc/res/icon-set-squares-empty.svg" class="iconimage" alt="Empty" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"> <img src="media/icon-themes/sc/res/icon-set-squares-one-quarter.svg" class="iconimage" alt="One quarter" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"> <img src="media/icon-themes/sc/res/icon-set-squares-half.svg" class="iconimage" alt="Half" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"> <img src="media/icon-themes/sc/res/icon-set-squares-three-quarters.svg" class="iconimage" alt="Three quarters" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"> <img src="media/icon-themes/sc/res/icon-set-squares-full.svg" class="iconimage" alt="Full" style="width:38px;height:38px" itemprop="image" itemscope="true" itemtype="http://schema.org/ImageObject"></p>
</li>
</ul>
<h3 id="hd_id621663440395987" dir="auto">Conditions for thresholds</h3>
<p id="par_id3153765" class="paragraph" dir="auto">Conditions to set the thresholds for each icon can be specified as follows</p>
<div class="embedded">
<a id="commonconditions"></a>
<ul itemprop="Unordered" itemscope="true" itemtype="http://schema.org/ItemList" dir="auto">
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/ItemListUnordered" dir="auto">
<p id="par_id321663440728295" class="listitem" dir="auto"><span class="emph">Value</span>: a fixed value. Enter the value in the text box.</p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/ItemListUnordered" dir="auto">
<p id="par_id611663440697270" class="listitem" dir="auto"><span class="emph">Percentile</span>: 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.</p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/ItemListUnordered" dir="auto">
<p id="par_id211663440834104" class="listitem" dir="auto"><span class="emph">Percent</span>: 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.</p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/ItemListUnordered" dir="auto">
<p id="par_id961663440848168" class="listitem" dir="auto"><span class="emph">Formula</span>: 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.</p>
</li>
</ul>
</div>
<div class="embedded">
<a id="conditionalformatting"></a>
<p id="par_id591563765191143" class="paragraph" dir="auto"></p>
</div>
<a id="relatedtopics"></a><div class="relatedtopics">
<p class="related" itemprop="mentions" dir="auto"><a id="related"></a><span class="emph">Temas relacionados</span></p>
<div class="relatedbody" itemprop="mentions">
<p id="par_id471665407993996" class="paragraph" dir="auto"><a target="_top" href="es/text/scalc/01/05120000.html">Formato condicional</a></p>
<p id="par_id3155606" class="paragraph" dir="auto"><a target="_blank" href="https://wiki.documentfoundation.org/Faq/Calc/141">How to use Icon Set Conditional Formatting page</a> in TDF Wiki.</p>
<p id="par_id651663598549283" class="paragraph" dir="auto"><a target="_blank" href="https://wiki.documentfoundation.org/Faq/Calc/142">How to apply a Color Scale Conditional Formatting page</a> in TDF Wiki.</p>
</div>
</div>
</div>
<div id="DonationFrame"></div>
<footer><h2 style="text-align: center;"><a href="https://books.libreoffice.org" target="_blank">Libros de LibreOffice</a></h2>
<div class="noteicon" dir="auto" style="display:flex;justify-content:center;flex-wrap:wrap;row-gap:15px;">
<img src="media/navigation/libo-writer.svg" alt="Writer Icon" style="width:60px;height:60px;"><img src="media/navigation/libo-calc.svg" alt="Calc Icon" style="width:60px;height:60px;"><img src="media/navigation/libo-impress.svg" alt="Impress Icon" style="width:60px;height:60px;"><img src="media/navigation/libo-draw.svg" alt="Draw Icon" style="width:60px;height:60px;"><img src="media/navigation/libo-base.svg" alt="Base Icon" style="width:60px;height:60px;"><img src="media/navigation/libo-math.svg" alt="Math Icon" style="width:60px;height:60px;"><img src="media/navigation/libo-symbol-black.svg" alt="Getting Started Icon" style="width:60px;height:60px;">
</div>
<div id="DEBUG" class="debug">
<h3 class="bug">Help content debug info:</h3>
<p dir="auto">This page is: <a href="https://opengrok.libreoffice.org/xref/help/source/text/scalc/01/05120400.xhp" target="_blank">/text/scalc/01/05120400.xhp</a></p>
<p dir="auto">Title is: Conditional Formatting - All cells</p>
<p id="bm_module" dir="auto"></p>
<p id="bm_system" dir="auto"></p>
<p id="bm_HID" dir="auto"></p>
</div></footer>
</body>
</html>
| Name | Type | Size | Permission | Actions |
|---|---|---|---|---|
| 02110000.html | File | 15.01 KB | 0644 |
|
| 02120100.html | File | 15.22 KB | 0644 |
|
| 02140000.html | File | 8.61 KB | 0644 |
|
| 02140100.html | File | 5.82 KB | 0644 |
|
| 02140200.html | File | 5.36 KB | 0644 |
|
| 02140300.html | File | 5.34 KB | 0644 |
|
| 02140400.html | File | 5.36 KB | 0644 |
|
| 02140500.html | File | 7.47 KB | 0644 |
|
| 02140600.html | File | 11.4 KB | 0644 |
|
| 02140700.html | File | 15.08 KB | 0644 |
|
| 02150000.html | File | 8.98 KB | 0644 |
|
| 02160000.html | File | 9.58 KB | 0644 |
|
| 02170000.html | File | 6.17 KB | 0644 |
|
| 02180000.html | File | 7.52 KB | 0644 |
|
| 02190000.html | File | 5.06 KB | 0644 |
|
| 02190100.html | File | 5.23 KB | 0644 |
|
| 02190200.html | File | 5.36 KB | 0644 |
|
| 02200000.html | File | 3.83 KB | 0644 |
|
| 02210000.html | File | 6.42 KB | 0644 |
|
| 02220000.html | File | 5.46 KB | 0644 |
|
| 03070000.html | File | 6.75 KB | 0644 |
|
| 03080000.html | File | 7.86 KB | 0644 |
|
| 03090000.html | File | 6.58 KB | 0644 |
|
| 03100000.html | File | 7.02 KB | 0644 |
|
| 04010000.html | File | 5.67 KB | 0644 |
|
| 04010100.html | File | 5.82 KB | 0644 |
|
| 04010200.html | File | 5.86 KB | 0644 |
|
| 04020000.html | File | 8.72 KB | 0644 |
|
| 04030000.html | File | 6.69 KB | 0644 |
|
| 04040000.html | File | 6.88 KB | 0644 |
|
| 04050000.html | File | 8.82 KB | 0644 |
|
| 04050100.html | File | 6.46 KB | 0644 |
|
| 04060000.html | File | 17.69 KB | 0644 |
|
| 04060100.html | File | 7.6 KB | 0644 |
|
| 04060101.html | File | 92.45 KB | 0644 |
|
| 04060102.html | File | 16.35 KB | 0644 |
|
| 04060103.html | File | 73.88 KB | 0644 |
|
| 04060104.html | File | 58.8 KB | 0644 |
|
| 04060105.html | File | 25.5 KB | 0644 |
|
| 04060106.html | File | 114.69 KB | 0644 |
|
| 04060107.html | File | 88.93 KB | 0644 |
|
| 04060108.html | File | 9.29 KB | 0644 |
|
| 04060109.html | File | 90.86 KB | 0644 |
|
| 04060110.html | File | 27.9 KB | 0644 |
|
| 04060111.html | File | 27.19 KB | 0644 |
|
| 04060112.html | File | 39.33 KB | 0644 |
|
| 04060115.html | File | 31.23 KB | 0644 |
|
| 04060116.html | File | 32.39 KB | 0644 |
|
| 04060118.html | File | 70.86 KB | 0644 |
|
| 04060119.html | File | 69.42 KB | 0644 |
|
| 04060120.html | File | 11.5 KB | 0644 |
|
| 04060181.html | File | 73.46 KB | 0644 |
|
| 04060182.html | File | 53.23 KB | 0644 |
|
| 04060183.html | File | 32.85 KB | 0644 |
|
| 04060184.html | File | 73.4 KB | 0644 |
|
| 04060185.html | File | 86.6 KB | 0644 |
|
| 04060199.html | File | 22.62 KB | 0644 |
|
| 04070000.html | File | 6.6 KB | 0644 |
|
| 04070100.html | File | 11.97 KB | 0644 |
|
| 04070200.html | File | 6.49 KB | 0644 |
|
| 04070300.html | File | 6.52 KB | 0644 |
|
| 04070400.html | File | 11.24 KB | 0644 |
|
| 04080000.html | File | 8.23 KB | 0644 |
|
| 04090000.html | File | 7.6 KB | 0644 |
|
| 05020000.html | File | 9.9 KB | 0644 |
|
| 05020600.html | File | 5.66 KB | 0644 |
|
| 05030000.html | File | 6.54 KB | 0644 |
|
| 05030300.html | File | 7.95 KB | 0644 |
|
| 05030400.html | File | 7.88 KB | 0644 |
|
| 05040000.html | File | 6.1 KB | 0644 |
|
| 05050100.html | File | 8.08 KB | 0644 |
|
| 05050300.html | File | 7.06 KB | 0644 |
|
| 05060000.html | File | 10.1 KB | 0644 |
|
| 05070000.html | File | 11.12 KB | 0644 |
|
| 05070500.html | File | 11.38 KB | 0644 |
|
| 05080000.html | File | 7.02 KB | 0644 |
|
| 05080100.html | File | 5.51 KB | 0644 |
|
| 05080200.html | File | 5.47 KB | 0644 |
|
| 05080300.html | File | 14.18 KB | 0644 |
|
| 05080400.html | File | 5.48 KB | 0644 |
|
| 05120000.html | File | 13.6 KB | 0644 |
|
| 05120100.html | File | 21.06 KB | 0644 |
|
| 05120200.html | File | 4.96 KB | 0644 |
|
| 05120300.html | File | 8.32 KB | 0644 |
|
| 05120400.html | File | 37.45 KB | 0644 |
|
| 05120500.html | File | 6.2 KB | 0644 |
|
| 06020000.html | File | 6.76 KB | 0644 |
|
| 06030000.html | File | 9.52 KB | 0644 |
|
| 06030100.html | File | 7.29 KB | 0644 |
|
| 06030200.html | File | 6.47 KB | 0644 |
|
| 06030300.html | File | 7.19 KB | 0644 |
|
| 06030400.html | File | 6.41 KB | 0644 |
|
| 06030500.html | File | 6.2 KB | 0644 |
|
| 06030600.html | File | 6.13 KB | 0644 |
|
| 06030700.html | File | 6.59 KB | 0644 |
|
| 06030800.html | File | 6.65 KB | 0644 |
|
| 06030900.html | File | 6.32 KB | 0644 |
|
| 06031000.html | File | 6.28 KB | 0644 |
|
| 06040000.html | File | 8.51 KB | 0644 |
|
| 06050000.html | File | 8.79 KB | 0644 |
|
| 06060000.html | File | 6.66 KB | 0644 |
|
| 06060200.html | File | 7.88 KB | 0644 |
|
| 06070000.html | File | 5.51 KB | 0644 |
|
| 06080000.html | File | 8.48 KB | 0644 |
|
| 06130000.html | File | 7.74 KB | 0644 |
|
| 07080000.html | File | 7.05 KB | 0644 |
|
| 07090000.html | File | 6.47 KB | 0644 |
|
| 07090100.html | File | 5.89 KB | 0644 |
|
| 12010000.html | File | 12.29 KB | 0644 |
|
| 12020000.html | File | 6.25 KB | 0644 |
|
| 12030000.html | File | 6.9 KB | 0644 |
|
| 12030100.html | File | 11.82 KB | 0644 |
|
| 12030200.html | File | 11.19 KB | 0644 |
|
| 12040000.html | File | 6.41 KB | 0644 |
|
| 12040100.html | File | 11.27 KB | 0644 |
|
| 12040201.html | File | 9.67 KB | 0644 |
|
| 12040300.html | File | 14.61 KB | 0644 |
|
| 12040400.html | File | 5.23 KB | 0644 |
|
| 12040500.html | File | 5.89 KB | 0644 |
|
| 12050000.html | File | 7.65 KB | 0644 |
|
| 12050100.html | File | 6.12 KB | 0644 |
|
| 12050200.html | File | 8.12 KB | 0644 |
|
| 12060000.html | File | 8.46 KB | 0644 |
|
| 12070000.html | File | 9.58 KB | 0644 |
|
| 12070100.html | File | 5.06 KB | 0644 |
|
| 12080000.html | File | 7 KB | 0644 |
|
| 12080100.html | File | 6.16 KB | 0644 |
|
| 12080200.html | File | 6.53 KB | 0644 |
|
| 12080300.html | File | 7.12 KB | 0644 |
|
| 12080400.html | File | 6.51 KB | 0644 |
|
| 12080500.html | File | 8.2 KB | 0644 |
|
| 12080600.html | File | 4.77 KB | 0644 |
|
| 12080700.html | File | 5.02 KB | 0644 |
|
| 12090000.html | File | 7.41 KB | 0644 |
|
| 12090100.html | File | 9.3 KB | 0644 |
|
| 12090101.html | File | 6.11 KB | 0644 |
|
| 12090102.html | File | 13.21 KB | 0644 |
|
| 12090103.html | File | 7.55 KB | 0644 |
|
| 12090104.html | File | 5.53 KB | 0644 |
|
| 12090105.html | File | 12.58 KB | 0644 |
|
| 12090106.html | File | 8.52 KB | 0644 |
|
| 12090200.html | File | 8.03 KB | 0644 |
|
| 12090300.html | File | 7.63 KB | 0644 |
|
| 12090400.html | File | 6.12 KB | 0644 |
|
| 12100000.html | File | 5.91 KB | 0644 |
|
| 12120000.html | File | 7.49 KB | 0644 |
|
| 12120100.html | File | 14.13 KB | 0644 |
|
| 12120200.html | File | 6.51 KB | 0644 |
|
| 12120300.html | File | 10.14 KB | 0644 |
|
| Add.html | File | 4.41 KB | 0644 |
|
| DeleteAllNotes.html | File | 5.81 KB | 0644 |
|
| DeleteNote.html | File | 5.96 KB | 0644 |
|
| EditSelectMenu.html | File | 8.32 KB | 0644 |
|
| FieldMenu.html | File | 6.25 KB | 0644 |
|
| FormatSparklineMenu.html | File | 6.89 KB | 0644 |
|
| HandleDuplicateRecords.html | File | 5.57 KB | 0644 |
|
| HideNote.html | File | 5.69 KB | 0644 |
|
| InsertCurrentDate.html | File | 6.36 KB | 0644 |
|
| InsertCurrentTime.html | File | 6.36 KB | 0644 |
|
| JumpToNextTable.html | File | 5.01 KB | 0644 |
|
| JumpToNextTableSel.html | File | 5.15 KB | 0644 |
|
| JumpToPrevTable.html | File | 5.04 KB | 0644 |
|
| JumpToPrevTableSel.html | File | 5.16 KB | 0644 |
|
| ManageNames.html | File | 12.1 KB | 0644 |
|
| MergeCellsMenu.html | File | 5.8 KB | 0644 |
|
| NavigateMenu.html | File | 5.33 KB | 0644 |
|
| NormalViewMode.html | File | 5.89 KB | 0644 |
|
| ODFF.html | File | 4.38 KB | 0644 |
|
| SelectColumn.html | File | 6.35 KB | 0644 |
|
| SelectData.html | File | 6.96 KB | 0644 |
|
| SelectRow.html | File | 6.04 KB | 0644 |
|
| SelectUnprotectedCells.html | File | 5.15 KB | 0644 |
|
| SelectVisibleColumns.html | File | 5.34 KB | 0644 |
|
| SelectVisibleRows.html | File | 5.19 KB | 0644 |
|
| SetInputMode.html | File | 5.87 KB | 0644 |
|
| SheetCommentMenu.html | File | 6.04 KB | 0644 |
|
| ShowNote.html | File | 5.68 KB | 0644 |
|
| TableSelectAll.html | File | 6.32 KB | 0644 |
|
| ToggleFormula.html | File | 6.4 KB | 0644 |
|
| ToggleRelative.html | File | 5.9 KB | 0644 |
|
| ToggleSheetGrid.html | File | 6.29 KB | 0644 |
|
| ViewHiddenColRow.html | File | 5.18 KB | 0644 |
|
| calculate.html | File | 5.73 KB | 0644 |
|
| calculation_accuracy.html | File | 7.61 KB | 0644 |
|
| cell_styles.html | File | 12.48 KB | 0644 |
|
| common_func.html | File | 5.51 KB | 0644 |
|
| common_func_workdaysintl.html | File | 9.53 KB | 0644 |
|
| data_form.html | File | 10.23 KB | 0644 |
|
| databar_more_options.html | File | 9.39 KB | 0644 |
|
| database_table_reference.html | File | 31.35 KB | 0644 |
|
| default_number_formats.html | File | 28.72 KB | 0644 |
|
| duplicate_sheet.html | File | 5.66 KB | 0644 |
|
| events_sheet.html | File | 9.13 KB | 0644 |
|
| ex_data_stat_func.html | File | 13.74 KB | 0644 |
|
| exponsmooth_embd.html | File | 22.59 KB | 0644 |
|
| formula2value.html | File | 5.49 KB | 0644 |
|
| ful_func.html | File | 10.59 KB | 0644 |
|
| func_aggregate.html | File | 26.99 KB | 0644 |
|
| func_arabic.html | File | 6.55 KB | 0644 |
|
| func_asc.html | File | 6.94 KB | 0644 |
|
| func_averageif.html | File | 25.01 KB | 0644 |
|
| func_averageifs.html | File | 22.6 KB | 0644 |
|
| func_bahttext.html | File | 6.18 KB | 0644 |
|
| func_base.html | File | 6.89 KB | 0644 |
|
| func_ceiling.html | File | 25.59 KB | 0644 |
|
| func_char.html | File | 5.9 KB | 0644 |
|
| func_clean.html | File | 5.68 KB | 0644 |
|
| func_code.html | File | 6.13 KB | 0644 |
|
| func_color.html | File | 7.68 KB | 0644 |
|
| func_concat.html | File | 7.27 KB | 0644 |
|
| func_concatenate.html | File | 5.57 KB | 0644 |
|
| func_convert.html | File | 85.18 KB | 0644 |
|
| func_countifs.html | File | 23.09 KB | 0644 |
|
| func_date.html | File | 11.69 KB | 0644 |
|
| func_datedif.html | File | 17.29 KB | 0644 |
|
| func_datevalue.html | File | 12.73 KB | 0644 |
|
| func_day.html | File | 13.09 KB | 0644 |
|
| func_days.html | File | 13.11 KB | 0644 |
|
| func_days360.html | File | 12.78 KB | 0644 |
|
| func_decimal.html | File | 6.64 KB | 0644 |
|
| func_dollar.html | File | 6.67 KB | 0644 |
|
| func_eastersunday.html | File | 11.27 KB | 0644 |
|
| func_edate.html | File | 12.72 KB | 0644 |
|
| func_eomonth.html | File | 10.99 KB | 0644 |
|
| func_error_type.html | File | 11.54 KB | 0644 |
|
| func_exact.html | File | 5.59 KB | 0644 |
|
| func_filter.html | File | 18.15 KB | 0644 |
|
| func_find.html | File | 5.89 KB | 0644 |
|
| func_findb.html | File | 7.33 KB | 0644 |
|
| func_fixed.html | File | 7.75 KB | 0644 |
|
| func_floor.html | File | 22.37 KB | 0644 |
|
| func_forecastetsadd.html | File | 21.98 KB | 0644 |
|
| func_forecastetsmult.html | File | 22.02 KB | 0644 |
|
| func_forecastetspiadd.html | File | 23.88 KB | 0644 |
|
| func_forecastetspimult.html | File | 23.92 KB | 0644 |
|
| func_forecastetsseason.html | File | 20.3 KB | 0644 |
|
| func_forecastetsstatadd.html | File | 25.96 KB | 0644 |
|
| func_forecastetsstatmult.html | File | 26.09 KB | 0644 |
|
| func_fourier.html | File | 42.78 KB | 0644 |
|
| func_hour.html | File | 10.83 KB | 0644 |
|
| func_ifs.html | File | 7.86 KB | 0644 |
|
| func_imcos.html | File | 7.96 KB | 0644 |
|
| func_imcosh.html | File | 8.38 KB | 0644 |
|
| func_imcot.html | File | 8.2 KB | 0644 |
|
| func_imcsc.html | File | 8.33 KB | 0644 |
|
| func_imcsch.html | File | 8.39 KB | 0644 |
|
| func_imsec.html | File | 8.3 KB | 0644 |
|
| func_imsech.html | File | 8.38 KB | 0644 |
|
| func_imsin.html | File | 7.93 KB | 0644 |
|
| func_imsinh.html | File | 8.36 KB | 0644 |
|
| func_imtan.html | File | 8.17 KB | 0644 |
|
| func_isoweeknum.html | File | 13.54 KB | 0644 |
|
| func_jis.html | File | 6.85 KB | 0644 |
|
| func_left.html | File | 5.64 KB | 0644 |
|
| func_leftb.html | File | 6.34 KB | 0644 |
|
| func_len.html | File | 5.54 KB | 0644 |
|
| func_lenb.html | File | 5.87 KB | 0644 |
|
| func_let.html | File | 14.03 KB | 0644 |
|
| func_lower.html | File | 5.39 KB | 0644 |
|
| func_maxifs.html | File | 22.38 KB | 0644 |
|
| func_mid.html | File | 5.04 KB | 0644 |
|
| func_midb.html | File | 8.53 KB | 0644 |
|
| func_minifs.html | File | 22.19 KB | 0644 |
|
| func_minute.html | File | 10.95 KB | 0644 |
|
| func_month.html | File | 12.79 KB | 0644 |
|
| func_networkdays.html | File | 15.42 KB | 0644 |
|
| func_networkdays.intl.html | File | 21.94 KB | 0644 |
|
| func_now.html | File | 10.49 KB | 0644 |
|
| func_numbervalue.html | File | 8.8 KB | 0644 |
|
| func_opt_barrier.html | File | 13.26 KB | 0644 |
|
| func_opt_prob_hit.html | File | 10.58 KB | 0644 |
|
| func_opt_prob_inmoney.html | File | 11.6 KB | 0644 |
|
| func_opt_touch.html | File | 13.16 KB | 0644 |
|
| func_proper.html | File | 5.48 KB | 0644 |
|
| func_randarray.html | File | 8.73 KB | 0644 |
|
| func_rawsubtract.html | File | 7.33 KB | 0644 |
|
| func_regex.html | File | 9.95 KB | 0644 |
|
| func_replace.html | File | 6.68 KB | 0644 |
|
| func_replaceb.html | File | 7.32 KB | 0644 |
|
| func_rept.html | File | 5.53 KB | 0644 |
|
| func_right.html | File | 5.63 KB | 0644 |
|
| func_rightb.html | File | 6.35 KB | 0644 |
|
| func_roman.html | File | 7.34 KB | 0644 |
|
| func_rounddown.html | File | 8.55 KB | 0644 |
|
| func_roundsig.html | File | 7.93 KB | 0644 |
|
| func_search.html | File | 8.06 KB | 0644 |
|
| func_searchb.html | File | 7.07 KB | 0644 |
|
| func_second.html | File | 10.93 KB | 0644 |
|
| func_sequence.html | File | 9.21 KB | 0644 |
|
| func_skewp.html | File | 7.48 KB | 0644 |
|
| func_sort.html | File | 16.68 KB | 0644 |
|
| func_sortby.html | File | 7.37 KB | 0644 |
|
| func_style.html | File | 9.99 KB | 0644 |
|
| func_substitute.html | File | 6.32 KB | 0644 |
|
| func_sum.html | File | 7.9 KB | 0644 |
|
| func_sumif.html | File | 20.86 KB | 0644 |
|
| func_sumifs.html | File | 22.12 KB | 0644 |
|
| func_switch.html | File | 8.34 KB | 0644 |
|
| func_t.html | File | 5.77 KB | 0644 |
|
| func_text.html | File | 6.39 KB | 0644 |
|
| func_textjoin.html | File | 8.43 KB | 0644 |
|
| func_time.html | File | 10.77 KB | 0644 |
|
| func_timevalue.html | File | 11.01 KB | 0644 |
|
| func_today.html | File | 10.43 KB | 0644 |
|
| func_trim.html | File | 5.5 KB | 0644 |
|
| func_trunc.html | File | 7.82 KB | 0644 |
|
| func_unichar.html | File | 5.53 KB | 0644 |
|
| func_unicode.html | File | 5.55 KB | 0644 |
|
| func_unique.html | File | 23.63 KB | 0644 |
|
| func_upper.html | File | 5.45 KB | 0644 |
|
| func_value.html | File | 8.58 KB | 0644 |
|
| func_webservice.html | File | 12.84 KB | 0644 |
|
| func_weekday.html | File | 18.76 KB | 0644 |
|
| func_weeknum.html | File | 19.35 KB | 0644 |
|
| func_weeknum_ooo.html | File | 14.34 KB | 0644 |
|
| func_weeknumadd.html | File | 11.01 KB | 0644 |
|
| func_workday.html | File | 14.99 KB | 0644 |
|
| func_workday.intl.html | File | 21.74 KB | 0644 |
|
| func_xlookup.html | File | 21 KB | 0644 |
|
| func_xmatch.html | File | 17.68 KB | 0644 |
|
| func_year.html | File | 11.1 KB | 0644 |
|
| func_yearfrac.html | File | 14.19 KB | 0644 |
|
| hide_sheet.html | File | 7.27 KB | 0644 |
|
| live_data_stream.html | File | 10.76 KB | 0644 |
|
| recalculate_hard.html | File | 6.4 KB | 0644 |
|
| shared_spreadsheet.html | File | 7.87 KB | 0644 |
|
| sheet_tab_color.html | File | 5.49 KB | 0644 |
|
| sidebar_alignment.html | File | 26.21 KB | 0644 |
|
| sidebar_number_format.html | File | 12.1 KB | 0644 |
|
| solver.html | File | 15.83 KB | 0644 |
|
| solver_options.html | File | 8.63 KB | 0644 |
|
| solver_options_algo.html | File | 28.26 KB | 0644 |
|
| sparklines.html | File | 12.98 KB | 0644 |
|
| stat_data.html | File | 72.41 KB | 0644 |
|
| statistics.html | File | 10.48 KB | 0644 |
|
| statistics_anova.html | File | 26.29 KB | 0644 |
|
| statistics_correlation.html | File | 21.12 KB | 0644 |
|
| statistics_covariance.html | File | 20.66 KB | 0644 |
|
| statistics_descriptive.html | File | 25.98 KB | 0644 |
|
| statistics_exposmooth.html | File | 21.47 KB | 0644 |
|
| statistics_fourier.html | File | 42.77 KB | 0644 |
|
| statistics_movingavg.html | File | 20.75 KB | 0644 |
|
| statistics_regression.html | File | 13.2 KB | 0644 |
|
| statistics_sampling.html | File | 17.34 KB | 0644 |
|
| statistics_test_chisqr.html | File | 18.29 KB | 0644 |
|
| statistics_test_f.html | File | 21.5 KB | 0644 |
|
| statistics_test_t.html | File | 22.16 KB | 0644 |
|
| statistics_test_z.html | File | 20.87 KB | 0644 |
|
| text2columns.html | File | 8.6 KB | 0644 |
|
| xml_source.html | File | 9.84 KB | 0644 |
|
| zoom.html | File | 9.62 KB | 0644 |
|