[sc-issues] [Issue 48207] lookup() function broken from 1.1.4 -> 1.9.95

2005-06-06 Thread fst
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=48207


User fst changed the following:

  What|Old value |New value

Status|RESOLVED  |CLOSED





--- Additional comments from [EMAIL PROTECTED] Mon Jun  6 05:18:15 -0700 
2005 ---
closed invalid

-
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[sc-issues] [Issue 48207] lookup() function broken from 1.1.4 -> 1.9.95

2005-06-06 Thread fst
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=48207


User fst changed the following:

  What|Old value |New value

Status|UNCONFIRMED   |RESOLVED

Resolution|  |INVALID





--- Additional comments from [EMAIL PROTECTED] Mon Jun  6 05:17:56 -0700 
2005 ---
Hi,

sorry for the late reply.

The bug was in 1.1.4 as this version matched the hyperlink value against a
nummeric value in the search array. This isn't correct and was fixed with the
1.9.x versions.

So the hyperlink is text and the search column is nummeric, this doesn't match
and therefore the last entry is displayed. To solve the problem, make the whole
search and ID column a text or don't use hyperlinks.

Sorry for no better reply.

Frank

-
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[sc-issues] [Issue 48207] lookup() function broken from 1.1.4 -> 1.9.95

2005-05-01 Thread mike_jones
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=48207





--- Additional comments from [EMAIL PROTECTED] Sun May  1 11:52:44 -0700 
2005 ---
I don't think it's a duplicate of that issue because I'm not trying to do a 
partial match. The index column is all 4-digit numbers and I'm trying to use 
the 
same 4-digit number to do the lookup. There should only be one match in the 
target area, so first vs. last result return shouldn't matter.

-
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[sc-issues] [Issue 48207] lookup() function broken from 1.1.4 -> 1.9.95

2005-05-01 Thread maxweber
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=48207


User maxweber changed the following:

  What|Old value |New value

CC|''|'maxweber'

  Keywords|  |oooqa





--- Additional comments from [EMAIL PROTECTED] Sun May  1 11:44:58 -0700 
2005 ---
hi, i think this could be duplicate of issue 44990

-
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[sc-issues] [Issue 48207] lookup() function broken from 1.1.4 -> 1.9.95

2005-04-27 Thread mike_jones
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=48207





--- Additional comments from [EMAIL PROTECTED] Wed Apr 27 08:51:21 -0700 
2005 ---
I've attached the file that's giving me problems. If you look at the "Roster" 
sheet, the second row below the column headings demonstrates the problem. It 
had 
been looking up the correct values from the "ID" sheet, but when I added a 
hyperlink it incorrectly returns the last value from the range.

-
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[sc-issues] [Issue 48207] lookup() function broken from 1.1.4 -> 1.9.95

2005-04-27 Thread mike_jones
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=48207


User mike_jones changed the following:

  What|Old value |New value

   Attachment data|  |Created an attachment
  |  |(id=2) Test case
  |  |showing failure of
  |  |lookup() function with
  |  |hyperlinks.





--- Additional comments from [EMAIL PROTECTED] Wed Apr 27 08:48:59 -0700 
2005 ---
Created an attachment (id=2)
Test case showing failure of lookup() function with hyperlinks.


-
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[sc-issues] [Issue 48207] lookup() function broken from 1.1.4 -> 1.9.95

2005-04-27 Thread fst
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=48207





--- Additional comments from [EMAIL PROTECTED] Wed Apr 27 00:56:27 -0700 
2005 ---
Please attach a file showing this Problem. Without it we can't reproduce it.

Frank

-
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]