[Libreoffice-bugs] [Bug 118625] AutoFilter is lost when selecting blank values with no header
https://bugs.documentfoundation.org/show_bug.cgi?id=118625 --- Comment #8 from b. --- autofilter also acts differently depending on the data provided, e.g. with a literal or alphanumeric 'header row' (a, b, c or a1, b2, c3), numeric data below that, and no predifined ranges: 'contains header' is automatically assumed and applied without asking the user, thus preventing to produce the situation of the OP -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 118625] AutoFilter is lost when selecting blank values with no header
https://bugs.documentfoundation.org/show_bug.cgi?id=118625 b. changed: What|Removed |Added CC||newbie...@gmx.de --- Comment #7 from b. --- still an issue in 7.0.0.0.a1+, afaics it's not 'the autofilter' being lost but 'only' it's representation on screen (the UI), as well the dropdown buttons are gone as the option looks unchecked, but the filtering is! applied correctly, and if you click again on the supposedly switched off option autofilter the filtration is removed in the same manner as if you had the buttons visible and unfiltered using them, (the option and the checkbox for it's state on/off (a real checkbox in linux, i had difficulties to spot it in windows, indicator for on/off is the background of the filter symbol becoming a little darker) are a special issue, my impression is that they are only checked for filtering ranges 'with headers', and stay unchecked for 'without'? in lin as well as in win, intentional?) or with you get back the unfiltered state with autofilter applied and dropdown buttons visible, note that the disappearing of the dropboxes doesn't depend on filtering for 'empty', they are also gone sometimes when you filter for one of the random values, and mostly after replacing the rand() values with fixed values, note that the autofilter reacts differently depending on whether you activate it: - with or without a header row (mentioned in the OP), - on an automatically selected range or have previously defined a , - also differentiates between with or without column headers, see options, - it even makes a difference if an automatically defined area has ever been used on a sheet, my experience is that the 'anonymouns database area' is never deleted but only changed after it's first use, and it partly influences the filters operations, - the filter also acts differently if you filter or sort, i have even seen the dropdown buttons from the top row appearing in cells somewhere down in the list after sort, when working on this area one should pay attention to a consistent user interface, it might be relevant when programming to note #132488, different results before and after save-load cycles can be quite confusing ... my testing with: Version: 7.0.0.0.alpha1 Build ID: 6a03b2a54143a9bc0c6d4c7f1... CPU threads: 8; OS: Linux 4.19; UI render: default; VCL: gtk3; Locale: de-DE (en_US.UTF-8); UI: en-US Calc: threaded and with the same ver. for win -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 118625] AutoFilter is lost when selecting blank values with no header
https://bugs.documentfoundation.org/show_bug.cgi?id=118625 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added OS|Linux (All) |All --- Comment #6 from Roman Kuznetsov <79045_79...@mail.ru> --- confirm on Windows too Version: 6.4.0.0.alpha0+ (x86) Build ID: ca6df519a78e5bfc96030c916f242b86306194e5 CPU threads: 4; OS: Windows 6.1; UI render: default; VCL: win; Locale: ru-RU (ru_RU); UI-Language: en-US Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 118625] AutoFilter is lost when selecting blank values with no header
https://bugs.documentfoundation.org/show_bug.cgi?id=118625 Thomas Lendo changed: What|Removed |Added Blocks||103512 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=103512 [Bug 103512] [META] AutoFilter-related bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 118625] AutoFilter is lost when selecting blank values with no header
https://bugs.documentfoundation.org/show_bug.cgi?id=118625 Xisco Faulí changed: What|Removed |Added Ever confirmed|0 |1 CC||er...@redhat.com Status|UNCONFIRMED |NEW Version|6.0.5.2 release |Inherited From OOo --- Comment #5 from Xisco Faulí --- I can reproduce it in Version: 6.2.0.0.alpha0+ Build ID: 67f3063b7c334d4d5c59132d90b938671aad09f0 CPU threads: 4; OS: Linux 4.13; UI render: default; VCL: gtk3; Locale: ca-ES (ca_ES.UTF-8); Calc: group threaded and back to LibreOffice 3.3.0 OOO330m19 (Build:6) tag libreoffice-3.3.0.4 @Eike, I thought you could be interested in this issue... -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 118625] AutoFilter is lost when selecting blank values with no header
https://bugs.documentfoundation.org/show_bug.cgi?id=118625 --- Comment #4 from david.cortes.riv...@gmail.com --- (In reply to Xisco Faulí from comment #1) > Thank you for reporting the bug. Please attach a sample document, as this > makes it easier for us to verify the bug. > (Please note that the attachment will be public, remove any sensitive > information before attaching it. > See > https://wiki.documentfoundation.org/QA/ > FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help > on how to do so.) Added a sample document and a gif video showing how the bug happens. Note that using a header row in the autofilter prevents this behavior. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 118625] AutoFilter is lost when selecting blank values with no header
https://bugs.documentfoundation.org/show_bug.cgi?id=118625 --- Comment #3 from david.cortes.riv...@gmail.com --- Created attachment 143404 --> https://bugs.documentfoundation.org/attachment.cgi?id=143404=edit short video reproducing the bug -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 118625] AutoFilter is lost when selecting blank values with no header
https://bugs.documentfoundation.org/show_bug.cgi?id=118625 --- Comment #2 from david.cortes.riv...@gmail.com --- Created attachment 143403 --> https://bugs.documentfoundation.org/attachment.cgi?id=143403=edit spreadsheet with non-working autofilter -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 118625] AutoFilter is lost when selecting blank values with no header
https://bugs.documentfoundation.org/show_bug.cgi?id=118625 Xisco Faulí changed: What|Removed |Added CC||xiscofa...@libreoffice.org --- Comment #1 from Xisco Faulí --- Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.) -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs