<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - HELP: description of "criterion" is missing"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=131995">131995</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>HELP: description of "criterion" is missing
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>unspecified
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Documentation
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>mikekaganski@hotmail.com
</td>
</tr>
<tr>
<th>CC</th>
<td>olivier.hallot@libreoffice.org
</td>
</tr></table>
<p>
<div>
<pre>Many spreadsheet functions (e.g., SUMIF [1]) allow using "search criterion" (a
special pseudotype defined in ODF [2]), which has some not obvious rules. The
current help only tangentially mentions one aspect from there, namely that the
text is attempted to be converted to number before being used as a regular
expression.
The dedicated description of "search criterion" is needed, and added to the
functions using it.
[1]
<a href="https://help.libreoffice.org/6.4/en-US/text/scalc/01/04060106.html?&DbPAR=CALC#Section15">https://help.libreoffice.org/6.4/en-US/text/scalc/01/04060106.html?&DbPAR=CALC#Section15</a>
[2]
<a href="http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__434502_49873571">http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__434502_49873571</a></pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>