[sc-issues] [Issue 102750] DSUM, DGET and other D* d atabase functions don't work with external ref erences anymore.
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 e...@openoffice.org Fri Dec 3 11:31:49 + 2010 --- @elysch: please submit a new issue for that problem. - 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
[sc-issues] [Issue 102750] DSUM, DGET and other D* d atabase functions don't work with external ref erences anymore.
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 Fri Dec 3 16:02:14 + 2010 --- Done: http://www.openoffice.org/issues/show_bug.cgi?id=115906 - 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
[sc-issues] [Issue 102750] DSUM, DGET and other D* d atabase functions don't work with external ref erences anymore.
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 e...@openoffice.org Thu Dec 2 09:51:03 + 2010 --- @elysch: 1. For text values you need to use double quotes instead of single quotes = Test instead of 'Test'. 2. Then the expression returns Err502 because there is more than one entry with Month==2. DGET needs unique entries. - 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
[sc-issues] [Issue 102750] DSUM, DGET and other D* d atabase functions don't work with external ref erences anymore.
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:09 + 2010 --- Created an attachment (id=75224) Error in DGET when text is entered near the data range in the remote file - 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
[sc-issues] [Issue 102750] DSUM, DGET and other D* d atabase functions don't work with external ref erences anymore.
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 + 2010 --- @er 1. For text values you need to use double quotes instead of single quotes = Test instead of 'Test'. YEES... 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
[sc-issues] [Issue 102750] DSUM, DGET and other D* d atabase functions don't work with external ref erences anymore.
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:16:33 + 2010 --- wierd... I added text in A30 cell of DATA2-TEST.ods file and removed any other text in that column. DGET Formula still shows Err:504 in TEST.ods. - 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
[sc-issues] [Issue 102750] DSUM, DGET and other D* d atabase functions don't work with external ref erences anymore.
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:36:00 + 2010 --- I've found a new thing. The error I mentioned before appears also with the first two attachments of this issue, using the DSUM formula. To reproduce, add any random text in any one cell to the left of the remote (basetest.ods) database area, after the titles row (from row 3 on). The DSUM formula returns Err:504 too, when you reload bdsommetest.ods. I even added the random text in A1048576 (The las row) and got the same error - 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
[sc-issues] [Issue 102750] DSUM, DGET and other D* d atabase functions don't work with external ref erences anymore.
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 01:39:39
+ 2010 ---
Hello all.
I downloaded:
OOo_3.3.0rc7_20101126_Win_x86_install_en-US.exe
And DGET still doesn't work.
I downloaded the first two files,
a) changed the value of the search criteria: I placed a 9 in A2
b) Added the next formula:
=DGET('file:///C:/temp/basetest.ods'#$Feuille1.F2:G25;'Test';A1:A2)
I get:
Err:504
Instead of a 45
The DSUM formula works fine as long as I could see.
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
[sc-issues] [Issue 102750] DSUM, DGET and other D* d atabase functions don't work with external ref erences anymore.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102750 User elysch changed the following: What|Old value |New value CC|'er,jbfaure,kohei,wope' |'elysch,er,jbfaure,kohei,w | |ope' - 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
[sc-issues] [Issue 102750] DSUM, DGET and other D* d atabase functions don't work with external ref erences anymore.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102750 User wope changed the following: What|Old value |New value Status|VERIFIED |CLOSED --- Additional comments from w...@openoffice.org Sat May 1 19:41:06 + 2010 --- ok in DEV300m77 - 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
[sc-issues] [Issue 102750] DSUM, DGET and other D* d atabase functions don't work with external ref erences anymore.
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 w...@openoffice.org Sat May 1 22:38:45 + 2010 --- *** Issue 110972 has been marked as a duplicate of this issue. *** - 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
[sc-issues] [Issue 102750] DSUM, DGET and other D* d atabase functions don't work with external ref erences anymore.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102750 User kla changed the following: What|Old value |New value Status|RESOLVED |VERIFIED --- Additional comments from k...@openoffice.org Fri Feb 5 14:53:43 + 2010 --- Seen ok in cws kohei03 - verified - 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
[sc-issues] [Issue 102750] DSUM, DGET and other D* d atabase functions don't work with external ref erences anymore.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102750 User kohei changed the following: What|Old value |New value Assigned to|kohei |kla --- Additional comments from ko...@openoffice.org Sat Dec 19 01:55:07 + 2009 --- re-assigning for qa verification. - 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
[sc-issues] [Issue 102750] DSUM, DGET and other D* d atabase functions don't work with external ref erences anymore.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102750 User krinn changed the following: What|Old value |New value Status|RESOLVED |REOPENED Resolution|FIXED | --- Additional comments from kr...@openoffice.org Sun Nov 29 11:39:59 + 2009 --- Still doesn't work with Office 3.1.1 OOO310m19 (build: 9420) That version should have the bug fix ? Because it still doesn't work and you can still use the 3 files i have upload at first to see that the fix doesn't work. Now it's getting worst as gentoo push out previous openoffice versions i'm left with that one that doesn't work - 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
[sc-issues] [Issue 102750] DSUM, DGET and other D* d atabase functions don't work with external ref erences anymore.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102750 User kohei changed the following: What|Old value |New value Status|REOPENED |RESOLVED Resolution| |FIXED --- Additional comments from ko...@openoffice.org Sun Nov 29 15:01:00 + 2009 --- It's fixed in 3.3. Please don't re-open this unless it's broken in 3.3. - 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
[sc-issues] [Issue 102750] DSUM, DGET and other D* d atabase functions don't work with external ref erences anymore.
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 ko...@openoffice.org Wed Sep 16 19:22:29 + 2009 --- Ok. I'm almost finished. I modified and tested the following functions: DSUM, DCOUNT, DCOUNTA, DGET, DMAX, DMIN, DAVERAGE, DPRODUCT, DSTDEV, DSTDEVP, DVAR and DVARP, all of which rely on the same type of data structure / iterator pair internally. Let me do my last minute cleanup before calling it done. - 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
[sc-issues] [Issue 102750] DSUM, DGET and other D* d atabase functions don't work with external ref erences anymore.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102750 User kohei changed the following: What|Old value |New value Status|STARTED |RESOLVED Resolution| |FIXED --- Additional comments from ko...@openoffice.org Wed Sep 16 20:33:37 + 2009 --- Cleanup is done. Now I'm officially finished with this. Fixed in kohei03 cws. - 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
[sc-issues] [Issue 102750] DSUM, DGET and other D* d atabase functions don't work with external ref erences anymore.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102750 User kohei changed the following: What|Old value |New value Target milestone|OOo 3.2 |OOo 3.3 - 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
[sc-issues] [Issue 102750] DSUM, DGET and other D* d atabase functions don't work with external ref erences anymore.
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 ko...@openoffice.org Wed Sep 9 16:14:54 + 2009 --- Just FYI, fixing this will require a large amount of change in a lot of places. I'm working on this ATM in kohei03 cws, for 3.3. - 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
[sc-issues] [Issue 102750] DSUM, DGET and other D* d atabase functions don't work with external ref erences anymore.
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 e...@openoffice.org Fri Jul 17 11:05:40 + 2009 --- Well, we're both on IRC almost each day, so.. talk to me ;-) - 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
[sc-issues] [Issue 102750] DSUM, DGET and other D* d atabase functions don't work with external ref erences anymore.
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 ko...@openoffice.org Wed Jul 15 18:19:23 + 2009 --- COUNTIF falls under the category of not working with external references, too. A fix for that is forthcoming. - 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
[sc-issues] [Issue 102750] DSUM, DGET and other D* d atabase functions don't work with external ref erences anymore.
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 e...@openoffice.org Wed Jul 15 21:41:20 + 2009 --- @kohei: hold it ;-) I already fixed SUMIF and COUNTIF for issue 102388 in CWSs dr68ooo311 and calc51, both not integrated yet. - 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
[sc-issues] [Issue 102750] DSUM, DGET and other D* d atabase functions don't work with external ref erences anymore.
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 ko...@openoffice.org Wed Jul 15 22:09:03 + 2009 --- *sigh* I wish I'd known that 3 days ago - 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
[sc-issues] [Issue 102750] DSUM, DGET and other D* d atabase functions don't work with external ref erences anymore.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102750 User er changed the following: What|Old value |New value Ever confirmed| |1 Status|UNCONFIRMED |NEW --- Additional comments from e...@openoffice.org Mon Jun 29 10:19:54 + 2009 --- @krinn: it means that I don't know who would commit himself to fix it in which version. So, if someone jumps in and says yes, I'll do that for OOo3.2 then we'll probably have a fix for OOo3.2; if not, I'm not sure I could do it in the time frame for OOo3.2 because already too many things are piling up in front of me. - 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
[sc-issues] [Issue 102750] DSUM, DGET and other D* d atabase functions don't work with external ref erences anymore.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102750 User kohei changed the following: What|Old value |New value CC|'er,jbfaure,wope' |'er,jbfaure,kohei,wope' - 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
[sc-issues] [Issue 102750] DSUM, DGET and other D* d atabase functions don't work with external ref erences anymore.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102750 User kohei changed the following: What|Old value |New value Assigned to|oc|kohei --- Additional comments from ko...@openoffice.org Mon Jun 29 14:00:55 + 2009 --- let me grab this for the time being. I guess no one else is wiling to work on this. - 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
[sc-issues] [Issue 102750] DSUM, DGET and other D* d atabase functions don't work with external ref erences anymore.
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 kr...@openoffice.org Mon Jun 29 14:27:44 + 2009 --- Thank you for your effort kohei, i was thinking (except by lack of time as er) more persons would like to work on that issue, am i really the only one to think it's a serious flaw ? Without querying a tutorial on how to do things, is there another way to achieve my task without using an external file as i do ? (that could explain why no one else seems to think it's a big issue) - 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
[sc-issues] [Issue 102750] DSUM, DGET and other D* d atabase functions don't work with external ref erences anymore.
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 ko...@openoffice.org Mon Jun 29 14:34:05 + 2009 --- one thing you can try is to fetch the external values into cells first, then reference those cells from DSUM etc. That might work as a workaround until this issue gets fixed. - 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
[sc-issues] [Issue 102750] DSUM, DGET and other D* d atabase functions don't work with external ref erences anymore.
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 kr...@openoffice.org Mon Jun 29 14:54:34 + 2009 --- Created an attachment (id=63270) test files with base import - 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
[sc-issues] [Issue 102750] DSUM, DGET and other D* d atabase functions don't work with external ref erences anymore.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102750 User kohei changed the following: What|Old value |New value Status|NEW |STARTED Target milestone|OOo 3.x |OOo 3.2 --- Additional comments from ko...@openoffice.org Mon Jun 29 14:55:44 + 2009 --- I feel I'm morally obligated to fix this for 3.2. - 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
[sc-issues] [Issue 102750] DSUM, DGET and other D* d atabase functions don't work with external ref erences anymore.
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 kr...@openoffice.org Mon Jun 29 15:00:56 + 2009 --- it work, i have add dbasetestimport.ods where the datas are import in another sheet. Also good, if you move the dbasetest.ods away it still refind values where you update file location in links (as i work under linux and some computers are using windows, location is always different) bad thing: the imported values were 24 lines long in the test, i have import upto 40 lines (as i don't know how long the real database is as size move up and down depending on update). And the extra lines made the size from dbasetest.ods jump from 7.4bytes to 9.5bytes. Not an issue with the test file, but proof size will get real bigger in my real case. - 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
[sc-issues] [Issue 102750] DSUM, DGET and other D* d atabase functions don't work with external ref erences anymore.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102750 User er changed the following: What|Old value |New value CC|'jbfaure,wope'|'er,jbfaure,wope' Status|CLOSED|UNCONFIRMED Keywords| |regression OS/Version|Linux |All Priority|P1|P3 Platform|PC|All Resolution|DUPLICATE | Summary|Calc doesn't use values gr|DSUM, DGET and other D* da |ab from another .ods and i|tabase functions don't wor |ssue an error |k with external references | | anymore. Subcomponent|open-import |programming Target milestone|--- |OOo 3.x Version|1.0.0 |OOo 3.1 --- Additional comments from e...@openoffice.org Fri Jun 26 13:10:26 + 2009 --- Reopening because fix would be different from issue 102388 and too invasive for OOo3.1.1 - 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
[sc-issues] [Issue 102750] DSUM, DGET and other D* d atabase functions don't work with external ref erences anymore.
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 kr...@openoffice.org Fri Jun 26 23:35:41 + 2009 --- does the 3.x means that probability of a fix even for 3.2 is low ? :( - 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
