Ask Your Question

Standard Filter Can't Select Column

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 close merge delete

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
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 178 times

Last updated: Mar 04 '17