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.