Steps to reproduce: 1 Open new spreadsheet. 2 Enter the following data into A1:C8. -------------------------- date product number 14/11/1 product1 2 14/11/1 product2 4 14/11/1 product1 1 14/11/2 product2 5 14/11/2 product1 4 14/11/3 product2 2 14/11/3 product1 1 -------------------------- 3 Select A1 and then click [Data]-[Filter]-[AutoFilter]. 4 Filter data by selecting "2014-11-01"(2014-Nobember-1) in "data" column, "product1" in "product" column. 5 Buttons of column A and B become blue, and only the second and fourth rows are displayed. 6 Save the document as ODS. 7 Click [File]-[Reload]. Now buttons of column A and B become black. If you check [Data]-[Filter]-[Standard Filter], you can find that the filter operation has changed to "OR" from "AND". Also if you click [Data]-[Refresh Range], the result will change. Versions checked with the issue. 4.1.6 4.2.7 4.3.4
Hi @HD thanks for reporting. Reproducible: Win7x64Ultimate Version: 4.3.5.1 Build ID: 8fd0451cc08e6a5310bed8b7ad1c46b93c1c6889 Version: 4.5.0.0.alpha0+ Build ID: 90fe751ab381cf59e87b79d921b3773567774af2 TinderBox: Win-x86@39, Branch:master, Time: 2014-11-27_05:30:25 Filter in saved file: " ranges><table:database-range table:name="__Anonymous_Sheet_DB__0" table:target-range-address="Sheet1.A1:Sheet1.C8" table:display-filter-buttons="true"><table:filter><table:filter-and><table:filter-condition table:field-number="0" table:value="01/11/2014" table:operator="="/><table:filter-condition table:field-number="1" table:value="product1" table:operator="="/></table:filter-and></table:filter></table:database-range></table:database-ranges></office:spreadsheet></office:body></office:document-content> "
MAB => highest
At least since 4.1.x
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=b500e60b32b5cf8fd61beb7476c2c29e65aee3e4 resolved fdo#86809 connect filter conditions correctly It will be available in 4.5.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-4-4": http://cgit.freedesktop.org/libreoffice/core/commit/?id=ff62f81e6795b68e53b2f96963745c4e98d9aaf7&h=libreoffice-4-4 resolved fdo#86809 connect filter conditions correctly It will be available in 4.4.0.0.beta3. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Pending review https://gerrit.libreoffice.org/13449 for 4-3
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-4-3": http://cgit.freedesktop.org/libreoffice/core/commit/?id=1b9bcc2e7f31e880e71c8d2a2aaf1b2839d4d32a&h=libreoffice-4-3 resolved fdo#86809 connect filter conditions correctly It will be available in 4.3.6. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-4-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=08f89a78e899b1f463d78fe31696418f7ba07ea7&h=libreoffice-4-2 resolved fdo#86809 connect filter conditions correctly It will be available in 4.2.9. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.