Summary: | Standard filter / remember setting when whole column is selected | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | raal <raal> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | ||
Severity: | enhancement | CC: | newbie-02, raal |
Priority: | medium | ||
Version: | 6.1.0.0.alpha1+ | ||
Hardware: | All | ||
OS: | All | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 109326 |
Description
raal
2018-05-22 14:45:04 UTC
As there is acknowledgement from Eike, let's set to NEW. the behaviour is not consistent, as soon as empty cells / rows are contained in the selection above, in or below the data when defining the filter, the filter criteria are remembered by calc (they are stored in 'content.xml' when saving the file), but with a new call of [data - filter - standard filter] only sometimes suggested again, but mostly not. The workflow seems to be that 'filter' first tries to define a range of criteria itself instead of checking if the current selection is in a range for which a filter is already defined. As long as a 'keep filter criteria' option is offered and activated a normal user expects a different behaviour... insofar: 'bug'. add. - you can! get the filter definition back / get it as suggestion for a new filter, also for ranges with 'empty' on top or bottom or inbetween, if you select the identical range e.g. by keying it in into the 'name box' instead of letting calc try to find it, and for that you have to know what this range was, with ver 7.1 when selecting a whole column for a filter this selection is shrinked to the last cell containing data once you start defining the filter, while a selection of e.g. B1:B1048575 is respected, intentional? but sometimes the filter conditions are messed up, e.g. i observed '= not empty' changed to '= 67' after save-load, whatever that means, but it was written into the filter definition on save ... additional there is mentioned '!empty', but after load '= 67' is evaluated ... whatever it means ... <table:filter-condition table:field-number="0" table:data-type="number" table:value="67" table:operator="!empty"/> and there may be other quirks, not tested, this area needs a rework ... reproduced with: Version: 7.3.0.0.alpha0+ / LibreOffice Community Build ID: 94d552f94b427f884c004dba5d4619ecf729d605 CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2021-06-18_13:30:27 Calc: threaded |