source/text/scalc/01/12120100.xhp | 1 +
1 file changed, 1 insertion(+)
New commits:
commit bedc78ea365c832245bea752d832257bd5b3513b
Author: Pierre F <f...@bger.ch>
AuthorDate: Fri Aug 2 09:47:37 2024 +0200
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Mon Aug 5 14:36:15 2024 +0200
add note on "Custom" limitation. tdf#153345
Change-Id: I39a2bbd4143e3fcb43e4a5139b56b059836f2397
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/171363
Tested-by: Olivier Hallot <olivier.hal...@libreoffice.org>
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/01/12120100.xhp
b/source/text/scalc/01/12120100.xhp
index bb65301a1d..0b9aeb437a 100644
--- a/source/text/scalc/01/12120100.xhp
+++ b/source/text/scalc/01/12120100.xhp
@@ -124,6 +124,7 @@
<tablecell>
<paragraph id="par_id101607384677959" role="tablecontent">Only allow values
that result in the formula entered in the <emph>Formula</emph> box to return
<literal>TRUE</literal>, when the formula is calculated with the entered value.
The formula can be any expression that evaluates to a boolean value of
<literal>TRUE</literal> or <literal>FALSE</literal>, or returns a numerical
value, where a nonzero value is interpreted as <literal>TRUE</literal> and
<literal>0</literal> is interpreted as <literal>FALSE</literal>.</paragraph>
<paragraph role="tablecontent" id="par_id461607565255803">Formulas can use
relative referencing. For example, if cells <literal>A1:A4</literal> were
selected, the cursor is in cell <literal>A1</literal> and
<input>ISODD(A1)</input> is entered into the <emph>Formula</emph> box, then
only odd numbers could be entered into cells <literal>A1</literal> through
<literal>A4</literal>.</paragraph>
+<note id="par_id221603980244055">Only up to 255 characters are saved, when
using Excel format.</note>
</tablecell>
</tablerow>
</table>
