__  __    __   __  _____      _            _          _____ _          _ _ 
 |  \/  |   \ \ / / |  __ \    (_)          | |        / ____| |        | | |
 | \  / |_ __\ V /  | |__) | __ ___   ____ _| |_ ___  | (___ | |__   ___| | |
 | |\/| | '__|> <   |  ___/ '__| \ \ / / _` | __/ _ \  \___ \| '_ \ / _ \ | |
 | |  | | |_ / . \  | |   | |  | |\ V / (_| | ||  __/  ____) | | | |  __/ | |
 |_|  |_|_(_)_/ \_\ |_|   |_|  |_| \_/ \__,_|\__\___| |_____/|_| |_|\___V 2.1
 if you need WebShell for Seo everyday contact me on Telegram
 Telegram Address : @jackleet
        
        

            For_More_Tools:
            
                Telegram: @jackleet | Bulk Smtp support mail sender  | Business Mail Collector  |  Mail Bouncer All Mail | Bulk Office Mail Validator | Html Letter private

Upload:

Command:

[email protected]: ~ $ 
<!DOCTYPE html>
<html lang="es" dir="ltr">
<head>
<base href="../../../../">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Funciones definidas por el usuario</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_id3155411"></a><meta itemprop="keywords" content="funciones,del usuario">
<meta itemprop="keywords" content="funciones del usuario">
<meta itemprop="keywords" content="EDI de BASIC para funciones del usuario">
<meta itemprop="keywords" content="EDI,EDI de BASIC">
<meta itemprop="keywords" content="programar,funciones">
<h1 id="hd_id3155411" dir="auto">
<a id="userdefined_function"></a>Funciones definidas por el usuario</h1>
<p id="par_id3153969" class="paragraph" dir="auto">Las funciones personalizadas se pueden utilizar en LibreOffice Calc de las siguientes maneras:</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_id3145366" class="listitem" dir="auto">Mediante el EDI de BASIC se pueden definir funciones propias, aun sin tener conocimientos avanzados de programación.</p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/ItemListUnordered" dir="auto">
<p id="par_id3153768" class="listitem" dir="auto">Las funciones se pueden programar como <a target="_top" href="es/text/scalc/01/04060111.html">complementos</a>. Este método exige conocimientos avanzados de programación.</p>
</li>
</ul>
<h2 id="hd_id3149260" dir="auto">Definir una función con LibreOffice Basic</h2>
<ol itemprop="HowTo" itemscope="true" itemtype="http://schema.org/HowToSection" dir="auto">
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/HowToStep" dir="auto">
    <p id="par_id3148456" class="listitem" dir="auto">Vaya a <span class="menuitem">Herramientas ▸ Macros ▸ Editar macros</span>.</p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/HowToStep" dir="auto">
<p id="par_id3154510" class="listitem" dir="auto">Aparecerá el EDI de BASIC.</p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/HowToStep" dir="auto">
<p id="par_id651603905832952" class="paragraph" dir="auto">In the Object Catalog window, double-click on the module where you want to store your macro.</p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/HowToStep" dir="auto">
<p id="par_id3150327" class="listitem" dir="auto">Enter the function code. In this example, we define a <span class="literal">VOL(a; b; c)</span> function that calculates the volume of a rectangular solid with side lengths <span class="literal">a</span>, <span class="literal">b</span> and <span class="literal">c</span>:</p>
</li>
</ol>
<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 VOL(a, b, c)
        VOL = a*b*c
    End Function
</code></pre></div>
<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_id3155443" class="listitem" dir="auto">Cierre la ventana del EDI de Basic.</p>
<p id="par_id3150043" class="listitem" dir="auto">Your function is automatically saved in the selected module and is now available. If you apply the function in a Calc document that is to be used on another computer, you can copy the function to the Calc document as described in the next section.</p>
</li>
</ul>
<h2 id="hd_id3147340" dir="auto">Copiar una función en un documento</h2>
<p id="par_id3145232" class="paragraph" dir="auto">En la etapa 2 de «Definir una función con LibreOffice Basic», pulsó en el botón <span class="emph">Editar</span> del cuadro de diálogo <span class="emph">Macro</span>. De manera predeterminada, en el campo <span class="emph">Macro desde</span> se encuentra seleccionado el módulo <span class="emph">Mis macros ▸ Estándar ▸ Módulo1</span>. La biblioteca <span class="emph">Estándar</span> se encuentra en el directorio del usuario de manera local.</p>
<p id="par_id3154022" class="paragraph" dir="auto">Si desea copiar la función definida por el usuario en un documento de Calc:</p>
<ol itemprop="HowTo" itemscope="true" itemtype="http://schema.org/HowToSection" dir="auto">
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/HowToStep" dir="auto">
    <p id="par_id3150304" class="listitem" dir="auto">Vaya a <span class="menuitem">Herramientas ▸ Macros ▸ Organizar macros ▸ BASIC</span>.</p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/HowToStep" dir="auto">
<p id="par_id3150086" class="listitem" dir="auto">En el campo <span class="emph">Macro desde</span>, seleccione <span class="emph">Mis macros ▸ Estándar ▸ Módulo1</span> y pulse en <span class="emph">Editar</span>.</p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/HowToStep" dir="auto">
<p id="par_id3166430" class="listitem" dir="auto">En el EDI de BASIC, seleccione el origen de la función definida por el usuario y cópielo en el portapapeles.</p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/HowToStep" dir="auto">
<p id="par_idN1081D" class="listitem" dir="auto">Cierre el EDI de BASIC.</p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/HowToStep" dir="auto">
<p id="par_id3150517" class="listitem" dir="auto">Vaya a <span class="menuitem">Herramientas ▸ Macros ▸ Organizar macros ▸ BASIC</span>.</p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/HowToStep" dir="auto">
<p id="par_id3145384" class="listitem" dir="auto">En el campo <span class="emph">Macro desde</span>, seleccione <span class="emph">(Nombre de documento de Calc) ▸ Estándar ▸ Módulo1</span>. Pulse en <span class="emph">Editar</span>.</p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/HowToStep" dir="auto">
<p id="par_id3148699" class="listitem" dir="auto">Pegue el contenido del portapapeles en la ventana del EDI de BASIC del documento.</p>
</li>
</ol>
<h2 id="hd_id3153305" dir="auto">Aplicar una función definida por el usuario en LibreOffice Calc</h2>
<p id="par_id3148869" class="paragraph" dir="auto">Once you have defined the function <span class="literal">VOL(a; b; c)</span> in the Basic-IDE, you can apply it the same way as the built-in functions of LibreOffice Calc.</p>
<ol itemprop="HowTo" itemscope="true" itemtype="http://schema.org/HowToSection" dir="auto">
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/HowToStep" dir="auto">
<p id="par_id3148606" class="listitem" dir="auto">Open a Calc document and enter numbers for the function parameters <span class="literal">a</span>, <span class="literal">b</span> and <span class="literal">c</span> in cells A1, B1, and C1.</p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/HowToStep" dir="auto">
<p id="par_id3156019" class="listitem" dir="auto">Coloque el cursor en otra celda e introduzca lo siguiente:</p>
<p id="par_id3155264" class="paragraph" dir="auto"><span class="input" data-tooltip="Pulse en el texto para copiarlo en el portapapeles">=VOL(A1;B1;C1)</span></p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/HowToStep" dir="auto">
<p id="par_id3146776" class="listitem" dir="auto">La función se evalúa y el resultado se observa en la celda seleccionada.</p>
</li>
</ol>
<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">
<div class="embedded"><p class="embedded" dir="auto"><a target="_top" href="es/text/scalc/guide/calculate.html">Calcular en una hoja de cálculo</a></p></div>
<div class="embedded"><p class="embedded" dir="auto"><a target="_top" href="es/text/scalc/guide/formula_enter.html">Introducir fórmulas</a></p></div>
<div class="embedded"><p class="embedded" dir="auto"><a target="_top" href="es/text/sbasic/guide/basic_2_python.html">Invocar secuencias de Python desde Basic</a></p></div>
</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/guide/userdefined_function.xhp" target="_blank">/text/scalc/guide/userdefined_function.xhp</a></p>
<p dir="auto">Title is: Funciones definidas por el usuario</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>

Filemanager

DIR : / usr/ share/ libreoffice/ help/ es/ text/ scalc/ guide/
Name Type Size Permission Actions
address_auto.html File 8.38 KB 0644
auto_off.html File 8.69 KB 0644
autofilter.html File 9.01 KB 0644
autoformat.html File 8.89 KB 0644
background.html File 7.14 KB 0644
borders.html File 19.28 KB 0644
calc_date.html File 7.81 KB 0644
calc_series.html File 10.44 KB 0644
calc_timevalues.html File 5.14 KB 0644
calculate.html File 6.74 KB 0644
cell_enter.html File 7.3 KB 0644
cell_protect.html File 10.78 KB 0644
cell_unprotect.html File 5.62 KB 0644
cellcopy.html File 7.74 KB 0644
cellreference_dragdrop.html File 7.72 KB 0644
cellreferences.html File 11.9 KB 0644
cellreferences_url.html File 7.96 KB 0644
cellstyle_by_formula.html File 7.65 KB 0644
cellstyle_conditional.html File 15.61 KB 0644
cellstyle_minusvalue.html File 6.35 KB 0644
change_image_anchor.html File 6.32 KB 0644
consolidate.html File 10.92 KB 0644
csv_files.html File 11.55 KB 0644
csv_formula.html File 10.76 KB 0644
currency_format.html File 8.22 KB 0644
database_define.html File 7.69 KB 0644
database_filter.html File 9.68 KB 0644
database_sort.html File 6.41 KB 0644
datapilot.html File 6.16 KB 0644
datapilot_createtable.html File 10.48 KB 0644
datapilot_deletetable.html File 6.3 KB 0644
datapilot_edittable.html File 7.81 KB 0644
datapilot_filtertable.html File 10.38 KB 0644
datapilot_formatting.html File 8.92 KB 0644
datapilot_grouping.html File 7.26 KB 0644
datapilot_tipps.html File 6.88 KB 0644
datapilot_updatetable.html File 6.19 KB 0644
dbase_files.html File 11.02 KB 0644
design.html File 7.99 KB 0644
edit_multitables.html File 6.62 KB 0644
filters.html File 7.62 KB 0644
finding.html File 10.58 KB 0644
format_table.html File 8.82 KB 0644
format_value.html File 7.63 KB 0644
format_value_userdef.html File 9.76 KB 0644
formula_copy.html File 7.72 KB 0644
formula_enter.html File 8.59 KB 0644
formula_value.html File 6.03 KB 0644
formulas.html File 8.04 KB 0644
fraction_enter.html File 5.9 KB 0644
goalseek.html File 8.18 KB 0644
html_doc.html File 7.58 KB 0644
integer_leading_zero.html File 8.69 KB 0644
keyboard.html File 11.18 KB 0644
line_fix.html File 7.31 KB 0644
main.html File 22.03 KB 0644
mark_cells.html File 9.18 KB 0644
matrixformula.html File 6.91 KB 0644
move_dragdrop.html File 12.43 KB 0644
multi_tables.html File 7.63 KB 0644
multioperation.html File 13.52 KB 0644
multitables.html File 6.77 KB 0644
note_insert.html File 7.54 KB 0644
numbers_text.html File 12.24 KB 0644
pivotchart.html File 6.17 KB 0644
pivotchart_create.html File 7.84 KB 0644
pivotchart_delete.html File 5.96 KB 0644
pivotchart_edit.html File 9.88 KB 0644
pivotchart_filter.html File 6.71 KB 0644
pivotchart_update.html File 6.06 KB 0644
print_details.html File 7.93 KB 0644
print_exact.html File 6.63 KB 0644
print_landscape.html File 9.3 KB 0644
print_title_row.html File 8.69 KB 0644
printranges.html File 10.55 KB 0644
relativ_absolut_ref.html File 15.06 KB 0644
remove_duplicates.html File 7.93 KB 0644
rename_table.html File 11.37 KB 0644
rounding_numbers.html File 8.35 KB 0644
row_height.html File 7.27 KB 0644
scenario.html File 9.74 KB 0644
sorted_list.html File 6.63 KB 0644
specialfilter.html File 14.18 KB 0644
subtotaltool.html File 9.5 KB 0644
super_subscript.html File 5.9 KB 0644
table_cellmerge.html File 13.29 KB 0644
table_rotate.html File 6.15 KB 0644
table_view.html File 6.5 KB 0644
text_numbers.html File 6.6 KB 0644
text_rotate.html File 5.76 KB 0644
text_wrap.html File 6.23 KB 0644
userdefined_function.html File 11.89 KB 0644
validity.html File 10.36 KB 0644
value_with_name.html File 10.87 KB 0644
webquery.html File 10.32 KB 0644
wildcards.html File 12.76 KB 0644
year2000.html File 5.59 KB 0644

Copyright reserved © 2026 xtooler.online Shell Coded By Mr.X

Filemanager