Ask Your Question

Standard Filter Can't Select Column [closed]

asked 2017-03-03 22:44:45 +0200

talkinggoat gravatar image

I have column A1 selected, but whenever I go to Data > Standard Filter, the field name is the contents of the first column of A1, not "Column A". If I select column B, the field name shows "Column B". Can someone explain why?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-26 16:53:37.988650

2 Answers

Sort by » oldest newest most voted

answered 2017-03-03 23:15:16 +0200

Lupp gravatar image

updated 2017-03-03 23:20:38 +0200

With LibO V 5.3.0 Calc I get offered text from the first row as column identifiers if the selected range for ALL its columns contains text in the first row that can be supposed to be the column label the user chose. As soon as there is at least one number in the first row I get the column headers of the sheet for all the columns offered for the filtering conditions. I would judge this is the most expectable behaviour of filters for the average user.

edit flag offensive delete link more

answered 2017-03-04 08:22:21 +0200

pierre-yves samyn gravatar image


You can switch with DataMore FiltersOptionsRange contains column labels


edit flag offensive delete link more

Question Tools

1 follower


Asked: 2017-03-03 22:44:45 +0200

Seen: 336 times

Last updated: Mar 04 '17