[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 --- 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 --- 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 --- 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 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
[sc-issues] [Issue 102750] Calc doesn't use values g rab from another .ods and issue an error
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 Sun Jun 14 23:46:33 + 2009 --- i also need to say that i made a mistake, it work ok with 3.0.1 and 3.0 (i don't know where i do a mistake when i test it with 3.0.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] Calc doesn't use values g rab from another .ods and issue an error
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 Sun Jun 14 23:40:39 + 2009 --- And thank you ! Someone pointed me out in forum to that issue, so i wish to add it here because i do think the root problem is also shared with that one (mark the 3 duplicates?) Anyway that might help you to know it too (at least my issue share the 504error with that one) issue: 102388 http://fr.openoffice.org/issues/show_bug.cgi?id=102388 - 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] Calc doesn't use values g rab from another .ods and issue an error
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 Sun Jun 14 08:50:31 +
2009 ---
Yes it looks like the issue you mention, but at least, i'm sure of one thing:
the way i use is legit and there's no controversy if i need ("A1") or (A1)
ref...
Because the way i create it, i simply hit function, then choose BDSOMME, then
when oocalc ask for ref i open the other file, and select my database, oocalc
put the ref (the file:///blahblah.ods...) itself.
Didn't really look at the doc to see if it's the way i should have done it, but
i suppose oocalc won't (shoudn't) allow me to do something bad itself. Some kind
of "hey don't do that with another file!" error message.
To be clear : it's a major issue for me, because i use an dbase.ods file that
hold datas that are use as database by 4 others .ods
It's an easy way to update the datas without having to change the 4 others .ods
files, once update i just have to spread the dbase.ods and all files are aware
of the changes.
i didn't tried it yet, but i guess that not only BDSOMME could be affect, and
the main reason is shared with the bug you mention about INDIRECT. Something
goes wrong with external files.
-
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] Calc doesn't use values g rab from another .ods and issue an error
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 Sat Jun 13 19:15:10 + 2009 --- Created an attachment (id=62973) test file that use the other file to important values - 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] Calc doesn't use values g rab from another .ods and issue an error
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 Sat Jun 13 19:14:38 + 2009 --- Created an attachment (id=62972) external file that hold values to test - 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] Calc doesn't use values g rab from another .ods and issue an error
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=102750
Issue #|102750
Summary|Calc doesn't use values grab from another .ods and iss
|ue an error
Component|Spreadsheet
Version|1.0.0
Platform|PC
URL|
OS/Version|Linux
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P1
Subcomponent|open-import
Assigned to|spreadsheet
Reported by|krinn
--- Additional comments from kr...@openoffice.org Sat Jun 13 19:13:28 +
2009 ---
Upto (at least) v3.0 calc was doing fine, but with 3.0.1 and 3.1 calc is affect
(using gentoo binary).
When trying to BDSOMME('file:///external.ods'#$Feuille1.A1:Z40;"test";A1:A2)
calc now fail to find the base in external.ods and issue an error instead of
finding the values, so BDSOMME fail.
Simple to see, but hard (for me) to explain :/
I could send 2 tests files that show the 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
