__ __ __ __ _____ _ _ _____ _ _ _ | \/ | \ \ / / | __ \ (_) | | / ____| | | | | | \ / |_ __\ 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>Aviso de error</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_id3156024"></a>
<a id="bm_id3156024"></a>
<a id="error_alert"></a>
<h1 id="hd_id3153821" dir="auto">Aviso de error</h1>
<p id="par_id3153379" class="paragraph" dir="auto"><span class="avis">Permite definir el mensaje de error que se debe mostrar cuando se introducen datos incorrectos en una celda.</span></p>
<p id="par_id3154138" class="paragraph" dir="auto">También se puede ejecutar una macro con un mensaje de error. Al final de esta página se muestra una macro de ejemplo.</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="error_alert"></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_id3154486" class="paragraph" dir="auto"><a id="datengueltigfehler"></a>Vaya a <span class="emph">Datos ▸ Validez ▸</span> pestaña <span class="emph">Aviso de error</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_id951704303538788" class="paragraph" dir="auto">On the <span class="menuitem">Data</span> menu of the <span class="menuitem">Data</span> tab, choose <span class="menuitem">Validity - Error Alert</span> tab.</p>
</div>
</div>
</div>
<br>
<a id="bm_id3154908"></a>
<h2 id="hd_id3156280" dir="auto">Mostrar mensaje de error al introducir valores no válidos</h2>
<p id="par_id3150768" class="paragraph" dir="auto"><span class="avis">Muestra el mensaje de error que se introduce en la sección <span class="emph">Contenido</span> al ingresar datos no válidos en una celda.</span> El mensaje se muestra para prevenir la introducción de datos no válidos cuando está activada esta opción.</p>
<p id="par_id3146984" class="paragraph" dir="auto">En ambos casos, si selecciona la opción "Detener" la entrada incorrecta se borra y se restablece en la celda el valor anterior. Lo mismo sucede si cierra los diálogos "Advertencia" e "Información" pulsando el botón <span class="emph">Cancelar</span>. Si cierra los diálogos con el botón <span class="emph">Aceptar</span>, la entrada incorrecta no se borra.</p>
<h2 id="hd_id3152460" dir="auto">Contenido</h2>
<a id="bm_id3154014"></a>
<h3 id="hd_id3148646" dir="auto">Acción</h3>
<p id="par_id3151115" class="paragraph" dir="auto"><span class="avis">Seleccione la acción que deberá producirse al introducir datos no válidos en una celda.</span> La acción «Detener» rechazará la entrada incorrecta y mostrará un cuadro de diálogo que el usuario deberá cerrar pulsando en <span class="emph">Aceptar</span>. Las acciones «Aviso» e «Información» mostrarán un cuadro de diálogo con los botones <span class="emph">Aceptar</span> y <span class="emph">Cancelar</span>, y la entrada incorrecta se rechazará solo si el usuario pulsa en <span class="emph">Cancelar</span>.</p>
<a id="bm_id3154729"></a>
<h3 id="hd_id3156441" dir="auto">Examinar</h3>
<p id="par_id3153160" class="paragraph" dir="auto"><span class="avis">Abre el diálogo <a target="_top" href="es/text/shared/01/06130000.html">Macro</a>, donde puede seleccionar la macro que se ejecutará al introducir datos incorrectos en una celda. La macro se ejecuta después de mostrar el mensaje de error.</span></p>
<a id="bm_id3149958"></a>
<h3 id="hd_id3153876" dir="auto">Título</h3>
<p id="par_id3149410" class="paragraph" dir="auto"><span class="avis">Escriba el título de la macro o el mensaje de error que desea que se muestre al introducir datos incorrectos en una celda.</span></p>
<a id="bm_id3153836"></a>
<h3 id="hd_id3154510" dir="auto">Mensaje de error</h3>
<p id="par_id3149122" class="paragraph" dir="auto"><span class="avis">Escriba el mensaje que desea que se muestre al introducir datos incorrectos en una celda.</span></p>
<h3 id="hd_id881545240342781" dir="auto">Macro de muestra:</h3>
<p id="par_id521625929022780" class="paragraph" dir="auto">A continuación se muestra una función de ejemplo que puede ser llamada cuando se produce un error. Tenga en cuenta que la macro toma dos parámetros que son pasados por LibreOffice cuando se llama a la funció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_id981625929097216" class="listitem" dir="auto"><span class="emph">Valor de la celda</span>: El valor introducido por el usuario, en forma de cadena.</p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/ItemListUnordered" dir="auto">
<p id="par_id421625929100152" class="listitem" dir="auto"><span class="emph">Dirección de Celda</span>: La dirección de la celda donde se introdujo el valor, como una Cadena prefijada con el nombre de la hoja (por ejemplo: "Hoja1.A1").</p>
</li>
</ul>
<p id="par_id101625929384030" class="paragraph" dir="auto">La función debe devolver un valor booleano. Si devuelve <span class="literal">Verdadero</span>, se mantiene el valor introducido. Si la función devuelve <span class="literal">Falsó</span>, el valor introducido se borra y se restaura el valor anterior.</p>
<div class="bascode" itemscope="true" itemtype="http://schema.org/SoftwareSourceCode" itemprop="codeSampleType" content="snippet" data-tooltip="Pulse en el texto para copiarlo en el portapapeles"><pre dir="auto"><code class="language-visual-basic line-numbers">
Function ExampleValidity(CellValue as String, CellAddress as String) as Boolean
Dim msg as String
Dim iAnswer as Integer
Dim MB_FLAGS as Integer
msg = "Valor no válido: " & "'" & CellValue & "'"
msg = msg & " en la celda: " & "'" & CellAddress & "'"
msg = msg & Chr(10) & "¿Quiere aceptarlo de todos modos?"
MB_FLAGS = MB_YESNO + MB_ICONEXCLAMATION + MB_DEFBUTTON2
iAnswer = MsgBox (msg , MB_FLAGS, "Mensaje de error")
ExampleValidity = (iAnswer = IDYES)
End Function
</code></pre></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_id91704303891085" class="paragraph" dir="auto"><a target="_top" href="es/text/scalc/01/12120000.html">Validez</a></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/12120300.xhp" target="_blank">/text/scalc/01/12120300.xhp</a></p>
<p dir="auto">Title is: Aviso de error</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 |
|