A spreadsheet has only the entries TRUE and FALSE.

TRUE TRUE TRUE TRUE TRUE FALSE

Which has been set up by entering TRUE in the top position an pulling it down into the rest of the column. To count the number of TRUE entries, which here is 5, the formula =COUNTIF(A1:A6,TRUE) applied to the column should work, but it always returns the result 1. On the other hand, the formula =COUNTIF(A1:A6,FALSE) works correctly on a similar column got by pulling down FALSE.

If a column is set up by actually entering the entries one after another, say

TRUE FALSE FALSE TRUE TRUE

COUNTIF() works properly. I suspect that the problem is that LibreOffice is entering different **kinds** of TRUE, because when I apply Data->Filter->Standard_Filter to the first column (all TRUE), I see a large number of entries all TRUE.

What’s going on? Is there any way to set up the column correctly? “Pulling down” TRUE() seems to have its own problems.