[sc-issues] [Issue 105246] lookup function doesn't w ork in 3.1 and does not work in 3.2.1 either
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105246 --- Additional comments from e...@openoffice.org Fri Dec 3 12:03:34 + 2010 --- The range A2:A40 accessed as search vector is not sorted. In Depot_Consor data is sorted in A2:A29, in Depot_Sparka data is sorted in A2:A33, both followed by empty cells included in the search range. A binary search on such arrangement yields unusable values. So actually this is a request to ignore empty cells in the search vector. - 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 105246] lookup function doesn't w ork in 3.1 and does not work in 3.2.1 either
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105246 User er changed the following: What|Old value |New value CC|'brinzing,regina' |'brinzing,er,regina' - 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 105246] lookup function doesn't w ork in 3.1 and does not work in 3.2.1 either
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105246 --- Additional comments from ggoe...@openoffice.org Fri Dec 3 16:22:12 + 2010 --- The Files Depot.. which update akteuro are not always withe the same number of lines. e.g. when you add a line (buy some add. shares) or delete lines beacause you have sold the shares. That would always require changes in the formula of the master. And that is certainly not the way electr. data processing should be done. I could agree on some form of end delimitter to signal the final of the 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 105246] lookup function doesn't w ork in 3.1 and does not work in 3.2.1 either
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105246 User ggoebel changed the following: What|Old value |New value Status|CLOSED|REOPENED Resolution|INVALID | --- Additional comments from ggoe...@openoffice.org Thu Dec 2 22:57:34 + 2010 --- sorry i can not accept your comments dec 1. both linked files are sorted as required. i have reduced the search vector to A$2:A$40 and the resultvector to E$2:E$40 so it should only search in that lines. However if in the depotSparka file the sppakt is in line 45 (but outside the search and result area)the result are empty cells. It does make sense to define an search area when the programm still looks for other lines. And in the Depotconsor file the last value for WCH888 is returning a wrong result. Should be 133,5 but is 1,32 I have found another error which is in rel. 3.0.1 already and in the newer releases as well. If the search vektor is not found e.g. A0RNHR in line 71 it returns a value . it should return an error like not found or N/A and not any value. - 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 105246] lookup function doesn't w ork in 3.1 and does not work in 3.2.1 either
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105246 --- Additional comments from ggoe...@openoffice.org Wed Dec 1 15:27:17 + 2010 --- I have tested 3.4dev300m94build9547. With my testfile i had sent it works. Testing with the complete working file it's still not ok. To me it seems oo has problems with letters e.g WCH888. I sent you the complete files for testing. i have marked the lines in yellow where the problem occurs. - 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 105246] lookup function doesn't w ork in 3.1 and does not work in 3.2.1 either
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105246 --- Additional comments from ggoe...@openoffice.org Wed Dec 1 15:29:17 + 2010 --- Created an attachment (id=75205) Masterfile to be updatedt - 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 105246] lookup function doesn't w ork in 3.1 and does not work in 3.2.1 either
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105246 --- Additional comments from ggoe...@openoffice.org Wed Dec 1 15:30:02 + 2010 --- Created an attachment (id=75206) update info 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 105246] lookup function doesn't w ork in 3.1 and does not work in 3.2.1 either
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105246 --- Additional comments from ggoe...@openoffice.org Wed Dec 1 15:30:45 + 2010 --- Created an attachment (id=75207) update 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 105246] lookup function doesn't w ork in 3.1 and does not work in 3.2.1 either
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105246 User er changed the following: What|Old value |New value Status|NEW |RESOLVED Resolution| |INVALID --- Additional comments from e...@openoffice.org Wed Dec 1 17:59:54 + 2010 --- For LOOKUP the search vector must be sorted, which it is not in both linked files. The vector is defined as A2:A110 and contains empty cells at the end, and additionally a SPPakt text in A46 of Depot_Sparka_26.11.10.ods in between the empty cells. - 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 105246] lookup function doesn't w ork in 3.1 and does not work in 3.2.1 either
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105246 User er changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from e...@openoffice.org Wed Dec 1 18:00:14 + 2010 --- Closing. - 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 105246] lookup function doesn't w ork in 3.1 and does not work in 3.2.1 either
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105246 --- Additional comments from vitr...@openoffice.org Tue Nov 30 08:21:45 + 2010 --- It seems working fine for me on 3.3 RC7 (OOO330m17) under Win Vista. G column looks complete. - 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 105246] lookup function doesn't w ork in 3.1 and does not work in 3.2.1 either
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105246 User brinzing changed the following: What|Old value |New value CC|'regina' |'brinzing,regina' --- Additional comments from brinz...@openoffice.org Tue Nov 30 11:46:09 + 2010 --- . - 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 105246] lookup function doesn't w ork in 3.1 and does not work in 3.2.1 either
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105246 --- Additional comments from m...@openoffice.org Mon Nov 29 15:08:32 + 2010 --- *** Issue 115824 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 105246] lookup function doesn't w ork in 3.1 and does not work in 3.2.1 either
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105246 --- Additional comments from m...@openoffice.org Mon Nov 29 15:10:56 + 2010 --- @ggoebel: please can you test the reported issue in the latest developer milestone (see: http://download.openoffice.org/next;), is it still occurring for you? - 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 105246] lookup function doesn't w ork in 3.1 and does not work in 3.2.1 either
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105246 User ggoebel changed the following: What|Old value |New value Summary|lookup function doesn't wo|lookup function doesn't wo |rk in 3.1 |rk in 3.1 and does not wor | |k in 3.2.1 either Version|OOo 3.1 |OOo 3.2.1 --- Additional comments from ggoe...@openoffice.org Mon Jul 19 12:13:33 + 2010 --- I have tested the new version 3.2.1 same problem as before. lokup does not return anything in the cell. Only version 3.0 does what it is supposed to do - 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 105246] lookup function doesn't w ork in 3.1 and does not work in 3.2.1 either
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105246 --- Additional comments from e...@openoffice.org Mon Jul 19 12:32:54 + 2010 --- I see no empty cells in DEV300m84 after having updated the links. - 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