I am using Windows 10 x64, LibreOffice version Version: 126.96.36.199
So in my database, I have a certain field that I wanted to filter out. I was doing this in the Query mode. I said I wanted to exclude (or filter I guess I should say) some remark in a field that mentioned ‘APPLES’ (nothing else - just the word Apples) only but display everything else other than ‘APPLES’, so I said NOT LIKE ‘APPLES’. Unfortunately, I found out that when I did this, by default it considered the field that had NO DATA as a field that had ‘APPLES’ for some weird reason, which totally removed them too. It wasn’t until I went in the table and just hit space in each one of those empty fields that I was able to display this correctly.
Is this a bug in the program or is this the way it is suppose to work?