tdf#138301 - clarification of Data Validity example
Change-Id: I20035ef3fad94c83ce06c8380f8c691cd85c7f83
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/108714
Tested-by: Jenkins
Reviewed-by: Seth Chaiklin <sdc.blanco@youmail.dk>
diff --git a/source/text/scalc/01/12120100.xhp b/source/text/scalc/01/12120100.xhp
index c08a975..0bf964d 100644
--- a/source/text/scalc/01/12120100.xhp
+++ b/source/text/scalc/01/12120100.xhp
@@ -123,7 +123,7 @@
</tablecell>
<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 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>
<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>
</tablecell>
</tablerow>
</table>
