https://bugs.freedesktop.org/show_bug.cgi?id=81336
--- Comment #8 from JuergenD <[email protected]> --- (In reply to comment #7) > I see that the attached .odb is over a .ods as the backend. Does a > spreadsheet have the concept of NULL (as opposed to merely empty)? I > think not. I used "IS NULL" and "IS NOT NULL" for filtering empty and undefined fields, because the database returns "NULL" for empty fields and single compares like "=''" and "!=''" doesn't work. > With what backend did your "IS NULL" criterion work? The spreadsheet is mainly a more than 10 years old adress database with currently 28 columns and only 144 rows. I am using the database with more than 20 queries for some macros, serial mails, with report builder and drag and drop actions from View > Data Source. The table structure changes from time to time and the spreadsheet gives me the flexibility to work with different versions of LibreOffice, OpenOffice and NeoOffice. Juergen -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
