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?
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.
You can switch with
Range contains column labels