Procedure to reproduce: Step 1: Open a new spreadsheet with at least 2 sheets Enter some values in column A (Sheet1) Apply the AutoFilter to this column Select a value - click OK > Observed result: correct, the line with the selected value displays only in Sheet1. Step 2: Activate the AutoFilter Select the Standard Filter from the dialogue box of the AutoFilter More options > Activate check box "Copy results to ..." and select for example cell $Sheet2.$B$4 - click OK > Observed result: correct, Sheet2 is selected and the result is copied in the chosen location. Step 3: Return to Sheet1 to activate the AutoFilter Select new values - click OK > Observed result: Sheet2 is selected and the values are copied towards Sheet2 in the previously defined location > Expected result: stay in Sheet1 and display lines containing the selected values, as in step 1. Step 4: To find the expected result, re-select the Standard Filter and inactivate check box "Copy results to …" Now the AutoFilter will work as in step 1. This does not occur on LibO 3.4 because the check box "Copy results to ..." is automatically inactivated when switching from Standard Filter to AutoFilter on the same selection. The behaviour of the version 3.4 is logical and must be preserved, because this option is not visible from the AutoFilter. Thank you for looking at that.
Hello I confirm with LibO 3.5 & Windows 7 64 bits Steps to reproduce : 1. Open the attached spreadsheet (Sheet1 contains data with Autofilter on) 2. A1 Click on the list 3. Selected "Bass" for instance 4. Click on Ok Expected result : rows filtered on Sheet1 Actual result : rows filtered on Sheet2 Explanation : Data> Filter> Standard filter > More options > "Copy results to" is enabled with $Sheet2.$A$1 Does not occur on LibO 3.4 : regression or new feature ? As Michel says the behaviour of the version 3.4 seems logical and might be preserved, because this option (copy results to) is not visible from the AutoFilter. Additional Information: Reproduced on [fr-discuss] Best regards
Created attachment 57193 [details] Testing spreadsheet
Of course reproducible on Ubuntu. Even in LO 3.5.1 rc0+ (LibreOffice 3.5.1rc0+ Version ID : c3f76c5-fe97bc5-f9b8d0b-f269e46-24eb504) and the master (LibreOffice 3.6.0alpha0+ Version ID : cdf0c78-babed3d-39746e8-f0d66fd-fefd87) Set OS to All Kohei: I think it is in your area. Please feel free to reassign if you can't handle this. Best regards. JBF
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.