To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110119
------- Additional comments from ia...@openoffice.org Sun Mar 14 20:23:05 +0000 2010 ------- One can simulate this problem using the Bibliography database using the following query which works fine query designer and to the Datasource Explorer but not when dragging onto spreadsheet. SELECT "Identifier", "Type", "Author", "Month", "Number", "Publisher", "Year" FROM "biblio" WHERE "Publisher" = :CPub AND "Year" >= :AStartYear AND "Year" <= :BEndYear ORDER BY "Year" DESC Results in column headings loaded into spreadsheet but no data Remove/replace the prompts: SELECT "Identifier", "Type", "Author", "Month", "Number", "Publisher", "Year" FROM "biblio" WHERE "Publisher" = 'Eyrolles' AND "Year" >= '2005' AND "Year" <= '2007' ORDER BY "Year" DESC Drag onto spreadsheet et voila all is good So it appears this is not limited to JDBC datasource Rgds Ian Stuart --------------------------------------------------------------------- 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: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
