To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113889 Issue #|113889 Summary|Database functions do not accept formula results as cr |iteria Component|Spreadsheet Version|1.0.0 Platform|PC URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|ui Assigned to|spreadsheet Reported by|th3pr0ph3t
------- Additional comments from th3pr0p...@openoffice.org Sat Aug 14 19:14:41 +0000 2010 ------- The result of formulas such as `=D4` or `HOY()`/`TODAY()` cannot be used in the range of cells used as the criteria in database functions such as BDSUMA() or BDCONTAR() (possibly DBSUM and DBCOUNT in the english version). For example, the formula `=BDSUM(BILLS, "Amount", H1:H2)` will work okay if you write today's date as a value such as `2010-08-14`, but if you use `=TODAY()` no results will be returned. --------------------------------------------------------------------- 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...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org