source/text/scalc/01/func_lambda.xhp | 26 +++++++++++++++----------- 1 file changed, 15 insertions(+), 11 deletions(-)
New commits: commit 28b3e1d798e24001d79c116d89a049f28aba81df Author: Olivier Hallot <[email protected]> AuthorDate: Tue Sep 22 14:54:06 2026 -0300 Commit: Olivier Hallot <[email protected]> CommitDate: Tue Sep 22 19:56:36 2026 +0200 Add precision on interoperability issues for LAMBDA functions. Change-Id: I4fb658e4e9cbd4fa5a48f437b9e28d02f48d0bf1 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/211329 Reviewed-by: Olivier Hallot <[email protected]> Tested-by: Jenkins diff --git a/source/text/scalc/01/func_lambda.xhp b/source/text/scalc/01/func_lambda.xhp index a0d19f3b88..e0806497f5 100644 --- a/source/text/scalc/01/func_lambda.xhp +++ b/source/text/scalc/01/func_lambda.xhp @@ -29,27 +29,31 @@ <paragraph role="paragraph" id="par_id111783708627795"><emph>Parameter 1</emph>: (required) The name of the first parameter to the function. The name must follow the <link href="text/scalc/guide/value_with_name.xhp">range naming rules</link> and cannot be the output of a reference or text formula. The scope of the parameter name is restricted to the LAMBDA function.</paragraph> <paragraph role="paragraph" id="par_id751783708895171"><emph>Parameter 2; ...; n </emph>: (optional). Additional parameters for the function. The same naming rules for <emph>Parameter 1</emph> applies.</paragraph> <paragraph role="paragraph" id="par_id701783709031402"><emph>Formula</emph>: a formula expression. It must be the last argument of the function.</paragraph> -<note id="par_id331783710050170">By default, the LAMBDA function displays the Greek character lambda (λ) in the cell.</note> + <h2 id="hd_id831783710257485">Usage</h2> +<note id="par_id531790097828614">For interoperability with other office suites, the LAMBDA function must be entered as a <link href="text/scalc/01/04070100.xhp">named formula</link>.</note> <list type="ordered"> <listitem> - <paragraph id="par_id321783710660632" role="listitem">For better readability, it is recommended (though optional) to assign a name to the cell containing the LAMBDA function.</paragraph> + <paragraph id="par_id161790098010052" role="listitem">Open menu <menuitem>Sheets - Named Range and Expressions - Define</menuitem>.</paragraph> + </listitem> + <listitem> + <paragraph id="par_id321783710660632" role="listitem">Assign a name to the expression.</paragraph> </listitem> <listitem> - <paragraph id="par_id881783710653711" role="listitem">Create the LAMBDA function expression in the named cell above (by default, the cell will display the character <emph>λ</emph>).</paragraph> + <paragraph id="par_id881783710653711" role="listitem">Write the LAMBDA function expression in the <menuitem>Range or formula expression</menuitem> box.</paragraph> </listitem> <listitem> - <paragraph id="par_id831783710666038" role="listitem">Use the named cell, passing the parameters for the LAMBDA function.</paragraph> + <paragraph id="par_id831783710666038" role="listitem">Use the named expression, passing the parameters for the LAMBDA function.</paragraph> </listitem> </list> <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <h4 id="hd_id821783715660204">Example of a simple geometric mean</h4> <list type="ordered"> <listitem> - <paragraph id="par_id301783712620663" role="listitem">Assign name MY_MEAN to cell A1.</paragraph> + <paragraph id="par_id301783712620663" role="listitem">Assign name MY_MEAN as a named expression.</paragraph> </listitem> <listitem> - <paragraph id="par_id971783712627758" role="listitem">Enter <input>=LAMBDA(Number1;Number2;SQRT(Number1*Number2))</input> in cell A1.</paragraph> + <paragraph id="par_id971783712627758" role="listitem">Enter <input>=LAMBDA(Number1;Number2;SQRT(Number1*Number2))</input> in the <menuitem>Range or formula expression</menuitem> box.</paragraph> </listitem> <listitem> <paragraph id="par_id741783712635060" role="listitem">In cell B1, enter <input>=MY_MEAN(2;3)</input>.</paragraph> @@ -58,14 +62,14 @@ <paragraph id="par_id191783712640914" role="listitem">Cell B1 displays the number 2.44948974278318, the square root of 2 times 3.</paragraph> </listitem> </list> -<note id="par_id981783715329179">If you don’t assign a name to the cell containing the LAMBDA function, you can still use it by entering the formula <input>=A1(2;3)</input> in B1. However, this makes the formula less readable.</note> +<note id="par_id981783715329179">If you don’t assign a name to LAMBDA expression, you can still use it by entering the formula in cell A1 and enter <input>=A1(2;3)</input> in B1. The LAMBDA function displays the Greek character lambda (λ) in cell A1. However, this makes the formula less readable and will cause interoperability issues with other office suites.</note> <h4 id="hd_id281783715637980">Example of a recursive call of a LAMBDA function</h4> <list type="ordered"> <listitem> - <paragraph id="par_id951783714102933" role="listitem">Assign name MY_FACTORIAL to cell A1</paragraph> + <paragraph id="par_id951783714102933" role="listitem">Assign name MY_FACTORIAL to a named expression</paragraph> </listitem> <listitem> - <paragraph id="par_id261783714109684" role="listitem">Enter <input>=LAMBDA(n;IF(n>1;n*MY_FACTORIAL(n-1);1))</input> in cell A1</paragraph> + <paragraph id="par_id261783714109684" role="listitem">Enter <input>=LAMBDA(n;IF(n>1;n*MY_FACTORIAL(n-1);1))</input> in the <menuitem>Range or formula expression</menuitem> box.</paragraph> </listitem> <listitem> <paragraph id="par_id921783714125947" role="listitem">Enter <input>=MY_FACTORIAL(5)</input> in cell B1</paragraph> @@ -75,11 +79,11 @@ </listitem> </list> <h4 id="hd_id331783717131876">Using ISOMITTED in function LAMBDA</h4> -<paragraph role="paragraph" id="par_id911783717111321">The ISOMITTED function allows you to handle missing parameters in a LAMBDA function. For example, the LAMBDA function in cell A1:</paragraph> +<paragraph role="paragraph" id="par_id911783717111321">The ISOMITTED function allows you to handle missing parameters in a LAMBDA function. For example, the LAMBDA function named MY_FUNCT:</paragraph> <paragraph role="paragraph" id="par_id501783717973525"><input>=LAMBDA(_n1; _n2; IF(ISOMITTED(_n2), "Missing second parameter"; _n1/_n2))</input></paragraph> -<paragraph role="paragraph" id="par_id91783717979957">returns "Missing second parameter" if the LAMBDA function is called as <input>=A1(3;)</input>. <emph>Note</emph>: The trailing argument separator (;) must be included in the function call.</paragraph> +<paragraph role="paragraph" id="par_id91783717979957">returns "Missing second parameter" if the LAMBDA function is called as <input>=MY_FUNCT(3;)</input>. <emph>Note</emph>: The trailing argument separator (;) must be included in the function call.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> <embed href="text/scalc/00/avail_release.xhp#27.2"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/>
