[Libreoffice-bugs] [Bug 118625] AutoFilter is lost when selecting blank values with no header

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=118625

b. <newbie-02 at gmx.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |newbie-02 at gmx.de

--- Comment #7 from b. <newbie-02 at gmx.de> ---
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 <data - autofilter> 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 <menu - data - autofilter> 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 <data - more filters - reset filter> 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 <data -
define range>, 
- <data - define range> 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200518/bf57ca43/attachment.htm>