https://bugs.freedesktop.org/show_bug.cgi?id=77479
V Stuart Foote <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|REOPENED |NEW Version|4.2.3.3 release |4.1.5.3 release --- Comment #11 from V Stuart Foote <[email protected]> --- OK, now I can appreciate the issue. Issue is the selection being filtered and sorted. Missed it because the default sort applies to occupied rows of cells on the entire sheet, including the row of column labels that holds the AutoFilter buttons. It works correctly if the entire table is selected for sort. But, if using AutoFilter to hide rows, if a sort is then applied against only selected rows that are showing, the rows hidden by AutoFilter action stay hidden but during the sort the AutoFilter button for each colunm is turned off including the marker (blue) identifying which columns AutoFilter has been applied. Losing that filter state, while rows/columns are still hidden, can not be recovered. So you must re-enable the AutoFilter and select the All check box on any column to bring up all records and get back to a known state with all records (post sort) showing. The hidden data is sorted, as the sort applies to the entire selected range including rows that are hidden, but with AutoFilter state details being cleared--you can not selectively expose the hidden rows. Disruptive of works flows. That is what is wrong, losing the state of the applied AutoFilter(s). Rather it should be retained and restored for use after the sort operation completes. Confirming and setting to NEW. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
