Welcome to NeoOffice developer notes and announcements
NeoOffice
Developer notes and announcements
 
 

This website is an archive and is no longer active
NeoOffice announcements have moved to the NeoOffice News website


Support
· Forums
· NeoOffice Support
· NeoWiki


Announcements
· Twitter @NeoOffice


Downloads
· Download NeoOffice


  
NeoOffice :: View topic - Fix for querying null values in spreadsheet data sources
Fix for querying null values in spreadsheet data sources
 
   NeoOffice Forum Index -> NeoOffice Testing
View previous topic :: View next topic  
Author Message
pluby
The Architect
The Architect


Joined: Jun 16, 2003
Posts: 11949

PostPosted: 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:

NeoOffice 2014.7:
http://nick.neooffice.org/test/NeoOffice-2014.8-Test-3-Intel.dmg

NeoOffice 2014.7 Free Edition:
http://nick.neooffice.org/test/NeoOffice-2014.8_Free_Edition-Test-3-Intel.dmg

NeoOffice 3.4.1:
http://nick.neooffice.org/test/NeoOffice-3.4.1-Patch-12-Test-3-Intel.dmg

Patrick
Back to top
pluby
The Architect
The Architect


Joined: Jun 16, 2003
Posts: 11949

PostPosted: Mon Mar 16, 2015 5:06 pm    Post subject:

FYI. I have included the fix for this bug in NeoOffice 2014.9 which is available in Apple's Mac App Store.

I have also included the fix in NeoOffice 3.4.1 Patch 13 which can be downloaded from the NeoOffice patch download page.

Patrick
Back to top
Display posts from previous:   
   NeoOffice Forum Index -> NeoOffice Testing All times are GMT - 7 Hours
Page 1 of 1

 
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

Powered by phpBB © 2001, 2005 phpBB Group

All logos and trademarks in this site are property of their respective owner. The comments are property of their posters, all the rest © Planamesa Inc.
NeoOffice is a registered trademark of Planamesa Inc. and may not be used without permission.
PHP-Nuke Copyright © 2005 by Francisco Burzi. This is free software, and you may redistribute it under the GPL. PHP-Nuke comes with absolutely no warranty, for details, see the license.