<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - Option "Search criteria = and <> must apply to whole cells" doesn't affect to calculation as must." href="https://bugs.documentfoundation.org/show_bug.cgi?id=139612#c5">Comment # 5</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - Option "Search criteria = and <> must apply to whole cells" doesn't affect to calculation as must." href="https://bugs.documentfoundation.org/show_bug.cgi?id=139612">bug 139612</a> from <a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> Mike Kaganski</a> <pre>(In reply to Igor from <a href="show_bug.cgi?id=139612#c3">comment #3</a>) > Advanced or Standard filters work correctly. Please clarify when you assert something; at least provide the version you test, and also listing the steps you tried would be good. Specifically, with the version mentioned in <a href="show_bug.cgi?id=139612#c1">comment 1</a>, doing this: 1. Select A1:E10 2. Data->More Filters->Advanced Filter 3. Read Filter Criteria From -> Лист3!$A$13:$E$14 -> OK results in rows 2 to 10 all hidden, i.e. it filters out all rows. However, this works (keeps row 3 shown) in Version: 5.0.0.5 (x64) Build ID: 1b1a90865e348b492231e1c451437d7a15bb262b Locale: ru-RU (ru_RU), which means there's a way to bibisect this specific part of the problem (and possibly find the relevant code).</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>