<html>
    <head>
      <base href="https://bugs.documentfoundation.org/">
    </head>
    <body><span class="vcard"><a class="email" href="mailto:guilleron29@aol.com" title="Jacques Guilleron <guilleron29@aol.com>"> <span class="fn">Jacques Guilleron</span></a>
</span> changed
          <a class="bz_bug_link 
          bz_status_NEEDINFO "
   title="NEEDINFO - Autofilter is confuse cells with similar numbers"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=107917">bug 107917</a>
          <br>
             <table border="1" cellspacing="0" cellpadding="8">
          <tr>
            <th>What</th>
            <th>Removed</th>
            <th>Added</th>
          </tr>

         <tr>
           <td style="text-align:right;">CC</td>
           <td>
                
           </td>
           <td>guilleron29@aol.com
           </td>
         </tr></table>
      <p>
        <div>
            <b><a class="bz_bug_link 
          bz_status_NEEDINFO "
   title="NEEDINFO - Autofilter is confuse cells with similar numbers"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=107917#c3">Comment # 3</a>
              on <a class="bz_bug_link 
          bz_status_NEEDINFO "
   title="NEEDINFO - Autofilter is confuse cells with similar numbers"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=107917">bug 107917</a>
              from <span class="vcard"><a class="email" href="mailto:guilleron29@aol.com" title="Jacques Guilleron <guilleron29@aol.com>"> <span class="fn">Jacques Guilleron</span></a>
</span></b>
        <pre>Hi Tiago,

You try to filter the cell containing 1 by putting 1 into Search items... 
and you are surprised that all cells remain displayed. If it's not that,
correct me.

Search items in Autofilter are made to search text into the cells. So all cells
containing the character 1 will be found.
Enter 0 as item to search, you will get 10 and 100 in the same way.

To filter numeric values, use rather Standard filter with the right criterias.

Jacques</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>