https://bugs.freedesktop.org/show_bug.cgi?id=63416
Priority: medium
Bug ID: 63416
Assignee: [email protected]
Summary: FILTER: autofilter -- first row lock
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.0.1.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 77794
--> https://bugs.freedesktop.org/attachment.cgi?id=77794&action=edit
autofiler example document: before, after, working
Problem description:
first noticed it in 4.0.1.2 rc -- seems to have been worked on but still
happening in 4.0.2.2 rc
The autofilter function doesn't work properly if the first row contains an
empty field (at first or after edit)
-- first row doesn't stay locked
-- the first complete (data) row is locked instead on the first row
Steps to reproduce:
1. create table with filter header row containing an empty field
2. apply autofilter
3. use the ascending / descending / empty auto filter sort
(in the example file use filter on "row1" 'sort ascending' then decending to
get to the example image)
Current behavior:
filter header row is itself sorted (made invisible)
-- treated like a data row
if all the fields in the first row are set (also when a sort puts one there)
gets locked
Expected behavior:
filter header row should stay locked even if it contains an empty field
(possibly an option to convert a header row into a data row)
Comments:
about "2. apply autofilter" -- if in 4.0.2.2 the header row contains an empty
field a dialog shows up
"first line to be used as column headers"?
-- but it doesn't have an effect
when the document is saved/reopened the autofilter is reset to the first row
Operating System: Windows 7
Version: 4.0.1.2 release
--
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
