[sc-issues] [Issue 116217] Cell Ranges/Named Ranges/ Data Ranges defined in OOO300 aren't shown in OOO330m17 calc
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=116217 --- Additional comments from ely...@openoffice.org Thu Dec 23 16:56:31 + 2010 --- Created an attachment (id=75404) Calc file created in OOO300 containing named ranges that are not shown in OOO330m17 - 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 116217] Cell Ranges/Named Ranges/ Data Ranges defined in OOO300 aren't shown in OOO330m17 calc
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=116217 Issue #|116217 Summary|Cell Ranges/Named Ranges/Data Ranges defined in OOO300 | aren't shown in OOO330m17 calc Component|Spreadsheet Version|OOO330m17 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|ui Assigned to|spreadsheet Reported by|elysch --- Additional comments from ely...@openoffice.org Thu Dec 23 16:54:23 + 2010 --- Hi all. When I open an OOO3.0.0 calc file in OOO330m17, the “Define Range...” and “Select Range...” don't show any previously defined ranges. But they are there, since a macro I have use them and still works. I'm attaching an example file: If you press the buton in “DatosRecibo” Sheet, it creates a new row in “ListaRecibosArrendamiento” Sheet. I'm selecting "ui" subcomponent, but I'm not sure if it's right. 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 115906] DSUM, DGET and other D* d atabase functions don't work with external ref erences when any text is entered in some cells outside the "database" area
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115906 --- Additional comments from ely...@openoffice.org Sun Dec 12 01:29:20 + 2010 --- Great - 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 115906] DSUM, DGET and other D* d atabase functions don't work with external ref erences when any text is entered in some cells outside the "database" area
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115906 --- Additional comments from ely...@openoffice.org Fri Dec 3 16:11:35 + 2010 --- In fact, the error appears by adding any text anywhere in the range A3:A1048576 in any one of the two "DATA" files. I also confirmed DSUM also behaves the same way. - 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 115906] DSUM, DGET and other D* d atabase functions don't work with external ref erences when any text is entered in some cells outside the "database" area
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115906 User elysch changed the following: What|Old value |New value Summary|DSUM, DGET and other D* da|DSUM, DGET and other D* da |tabase functions don't wor|tabase functions don't wor |k with external references|k with external references | anymore. | when any text is entered | |in some cells outside the | |"database" area - 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 115906] 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=115906 --- Additional comments from ely...@openoffice.org Fri Dec 3 16:01:05 + 2010 --- Created an attachment (id=75233) Error 504 in DGET when text is entered outside the "database" area on the remote file in certain positions. - 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 115906] 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=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 ely...@openoffice.org Fri Dec 3 15:58:58 + 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: 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 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: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: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 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
--- 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 3740] Named ranges in spreadsheet cannot be accessed from another one
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=3740 --- Additional comments from ely...@openoffice.org Wed Sep 22 16:34:11 + 2010 --- I saw today there is already a beta version for OOv3.3. Does it happen to store the names in the ODF alerady? Is there annother issue where we can track the specification/implementation progress for storing external defined name references in the ODF? - 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 3740] Named ranges in spreadsheet cannot be accessed from another one
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=3740 --- Additional comments from ely...@openoffice.org Thu Feb 4 00:08:45 + 2010 --- So... Any ideas about when will we see this 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 103331] OFFSET returns Err:504 on reference to another calc file
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 ely...@openoffice.org Thu Jul 30 03:32:59 + 2009 --- Thank you "er" I'll copy my post there. - 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 103331] OFFSET returns Err:504 on reference to another calc file
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103331 User elysch changed the following: What|Old value |New value CC|'kohei' |'elysch,kohei' --- Additional comments from ely...@openoffice.org Wed Jul 29 14:36:08 + 2009 --- Added me as cc - 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 103331] OFFSET returns Err:504 on reference to another calc file
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 ely...@openoffice.org Wed Jul 29 14:35:17
+ 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: 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 3740] Named ranges in spreadsheet cannot be accessed from another one
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=3740 User elysch changed the following: What|Old value |New value CC|'discoleo,er,fabianfinlay'|'discoleo,elysch,er,fabian | |finlay' - 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
