To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115906 Issue #|115906 Summary|DSUM, DGET and other D* database functions don't work |with external references anymore. Component|Spreadsheet Version|OOo 3.3 RC7 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|programming Assigned to|spreadsheet Reported by|elysch
------- Additional comments from [email protected] Fri Dec 3 15:58:58 +0000 2010 ------- When Using DSUM or DGET functions (at least) an "Err:504" is received when the remote file contains text on cells to the left and bellow the titles row of the "database" area. This is related to "DSUM, DGET and other D* database functions don't work with external references anymore." at http://www.openoffice.org/issues/show_bug.cgi? id=102750 I'm attaching tree files: DATA-TEST.ods, DATA2-TEST.ods and TEST.ods (in a zip) The only difference between the first two is cell A3. It has some random text in DATA2-TEST.ods If you see the formulas in TEST.ods the formula with reference to DATA2-TEST.ods returns "Err:504" (Cell C10). If you simply delete that random text, save the file and reload the TEST.ods file, the error goes away. In the other hand, if you add any text anywhere in the range A3:A13 in any one of the two "DATA" files, then save it and reload the TEST.ods file, the error appears. Any ideas about what is going on? Ely. --------------------------------------------------------------------- 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
