Description: In LibreOffice Calc, select a set of rows and columns, apply the auto-filter (using Ctrl+Shift+L) and then try to sort; It will sort the remaining rows as well (which were not included while applying auto-filter. Example: Populate data in 4 to 5 columns, consider the first row as the header row, 10 data rows and the last one assumed as the footer row (with totals, average, etc.). Now, select the header row, 10 data rows and create an auto-filter. (Remember: the last / footer row was not selected while creating this auto-filter). Now, try and sort on any column; it will also consider the last row (which was not selected while creating auto-filter) in that sorting! Interestingly, if the last row had some totals or averages, then the whole calculation will go for a toss due to shuffling of rows. :-) Basically, the auto-filter should be applied to only those rows and columns which were selected while creating the auto-filter. Steps to Reproduce: 1. Select a set of rows and columns (excluding the last row, which has auto-calculated fields) and create an auto-filter (Ctrl+Shift+L) 2. Sort on any columns, and it will include the last row as well! Actual Results: Includes the rows which were not selected for auto-filter Expected Results: Only those rows should be selected for auto-filter which were selected Reproducible: Always User Profile Reset: No Additional Info: In MS Excel, they create a filter on only those rows & columns which we select
Please attach a sample file to test.
Created attachment 175869 [details] Screenshot Please check the attached screenshot
[Automated Action] NeedInfo-To-Unconfirmed
(In reply to 123devang from comment #2) > Created attachment 175869 [details] > Screenshot > > Please check the attached screenshot Please attach an example Calc document, so we can test more quickly. Also, many auto-filter bugs were fixed in the recent releases, so please test with 7.4. Set to NEEDINFO. Change back to UNCONFIRMED, if the problem persists. Change to RESOLVED WORKSFORME, if the problem went away.
Dear 123devang, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping
Dear 123devang, Please read this message in its entirety before proceeding. Your bug report is being closed as INSUFFICIENTDATA due to inactivity and a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided): a) Provide details of your system including your operating system and the latest version of LibreOffice that you have confirmed the bug to be present b) Provide easy to reproduce steps – the simpler the better c) Provide any test case(s) which will help us confirm the problem d) Provide screenshots of the problem if you think it might help e) Read all comments and provide any requested information Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue. Please do not: a) respond via email b) update the version field in the bug or any of the other details on the top section of our bug tracker Warm Regards, QA Team MassPing-NeedInfo-FollowUp