https://bugs.documentfoundation.org/show_bug.cgi?id=63416
--- Comment #29 from Heiko Tietze <heiko.tie...@user-prompt.com> --- To put it all together: 1. First row with text only -> make it a header, do not sort, do not hide on filter 2. First row with empty cells only -> make it a header using 'col XY' or the like, do not sort, do not hide on filter 3. First row with mixed content (text, numbers, and empty cells) -> make it a header, (temporarily) convert numbers into text, fill empty cells with col XY or the like, do not filter, do not sort 4. First row with numbers only -> make it a header, (temporarily) convert numbers into text, do not sort, do not filter Alternatively we could a) keep the current behavior, b) just add a first row, c) disable sort/filter if no header is present, d) move the autofilter stuff to the table header (column 'A' would be 'A' with a dropdown menu), or e) have the autofilter stuff somewhere else e.g. at the sidebar. But for consistency I'd use the same behavior in all cases, probably like Excel does (haven't one at hand). The question whether or not the first row should become the header would be obsolete. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
