Posted: Sat Mar 07, 2015 8:20 pm Post subject: Fix for querying null values in spreadsheet data sources
A user discovered a bug when querying for rows with "null" cells in a spreadsheet data source. The bug causes empty cells in the spreadsheet to be treated as if they are not null so querying for null cells always returns no rows.
This bug only occurs if a data source's .odb file stores its data in a Calc .ods file. It does not occur in any .odb files that store their data in HSQLDB, JDBC, or ODBC databases.
This is a bug in NeoOffice's underlying OpenOffice 3.1.1 code. Fortunately, the OpenOffice engineers fixed this bug in a later version of OpenOffice so I have backported the fix from the latest OpenOffice code.
You can get the fix by installing one of the following test patches:
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You cannot download files in this forum