https://bugs.documentfoundation.org/show_bug.cgi?id=172448
ady <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Ever confirmed|1 |0 Status|NEEDINFO |UNCONFIRMED --- Comment #5 from ady <[email protected]> --- For Calc to easily identify the Headers of the list, it would be helpful to have a "consistent" layout of the list. Generally speaking, the adjacent row above the Headers should be empty. If you have "upper" layers" on your headers (e.g. "Schub" in the G2:K2 range), I would suggest leaving one (tiny) empty row in-between. It might even work correctly when such "empty" row is hidden, but I have not specifically tested this. It is also helpful to have all the Headers named. A header that is an empty cell might introduce inconsistencies too. Additionally, the items in the list should rather have at least one column "complete", preferably the first/left one – a kind of "index" column – with no empty items in the "middle" of that column. That way, the user does not need to specifically select the area to be filtered. All _current_ items will be part of the list, and all Headers will be correctly identified. It is always preferable to specifically select the relevant area before executing an(y) action on a spreadsheet, instead of leaving to the tool to "read the mind" of the user. If possible, I would suggest teaching your users (but I indeed understand the reluctance). As for improving the current heuristics, I don't know whether it requires UX team, or Calc developers, or both. -- You are receiving this mail because: You are the assignee for the bug.
