To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109726 Issue #|109726 Summary|Empty cell vs empty string in the spreadsheet driver Component|Database access Version|OOo 3.1.1 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|villeroy
------- Additional comments from [email protected] Tue Mar 2 08:35:43 +0000 2010 ------- The spreadsheet driver imports empty cells as empty strings. A numeric column with gaps imports as numbers or dates. Strangely, you need to test for empty strings when filtering these row sets: WHERE "Numbers"='' WHERE "Numbers" IS NULL fails. As a matter of fact, many spreadsheets contain calculated empty strings in numeric columns. For instance: =IF(B2 ; A2/B2 ; "") returns an empty string if B2 evaluates to False (zero or text). There is no way to make a sheet cell pretend to be empty. The Base driver treats this column as text. Base treats empty cells as empty strings but refuses to treat empty strings like empty cells. There have are complaints about this in the context of mail merges with calculated date fields (or empty string). --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
