To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102750
------- Additional comments from ely...@openoffice.org Thu Dec 2 18:06:26 +0000 2010 ------- @er > 1. For text values you need to use double quotes instead of single quotes > => "Test" instead of 'Test'. YEESSSSS... That did the trick in that example. > 2. Then the expression returns Err502 because there is more than one entry > with Month==2. DGET needs unique entries. Yes, that's why I changed the value to 9. There is still a problem though. I've been trying to find out the reason for a few hours by now, without luck. I have some calc files since before v3.0.1. This particular file still has a problem with dget formula, and I can't figure it out why. 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: 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
