To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103331
------- Additional comments from [email protected] Wed Jul 29 14:35:17 +0000 2009 ------- I don't know if this is the same problem, but it sounds like (to me). If you thing I need to open a new issue, let me know. I also get Err:504 using DGET. But it was working just fine up until version 3.0.1 It can be reproduced (almost) the same way, as metioned before. 1) Create a new calc document 2) Fill in a simple table with "field names": Add col1, 1, 2, 3 to A1, A2, A3 and A4 respectively; col2, a, b, c to B1, B2, B3 and B4 respectively. 3) Save it with the default name (Untitled 1.ods) 4) Create a second calc document. (There is no need to save it.) 5) In the second document, enter col1 in A1 and 2 in A2 6) In the second document, select cell C1 of sheet1. Use the function wizard to enter function DGET. 6.a) Click on "Database" edit box, then go to the first document and select A1:B4 6.b) Click on "Database field" edit box, and enter "col2" (with double quotes) 6.c) Click on "Search criteria" edit box, and select A1:A2 in the same document. The formula should be similar to: =DGET('file:///C:/Documents%20and%20Settings/Ely/Escritorio/Untitled% 201.ods'#$Sheet1.A1:B4;"col2";A1:A2) When you click on the "ok" button, you get the ERR:504 error instead of the letter "b" If you put almost the same formula in the first document, you get the expected value. That is: Enter col1 in D1 and 2 in D2 of Untitled 1.ods in the first sheet. Then do the step number 6 I've just described, but all in the Untitled 1.ods file, and replacing A1:A2 in step 6.c for D1:D2... and you get the expected letter "b" at C1. The resulting formula looks like: =DGET(A1:B4;"col2";D1:D2) I hope I made myself clear. 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]
