To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=74243
Issue #|74243
Summary|Calc - Vlookup seems to return on-disk data, not what
|is in memory.
Component|Spreadsheet
Version|OOo 2.1
Platform|All
URL|
OS/Version|All
Status|NEW
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P2
Subcomponent|ui
Assigned to|spreadsheet
Reported by|kpalagin
------- Additional comments from [EMAIL PROTECTED] Tue Feb 6 21:03:19 +0000
2007 -------
Vlookup function (and probably other reference functions) in Calc seems to
return data from file, not from memory. Repro steps:
1. Start Calc, enter (all without quotes) "abc" in A1, "2" in B1, "3" in C1.
Save the file as "source.ods", replace "2" with anything else, do not save the
file.
2. Open new workbook and enter vlookup formula "VLOOKUP
("abc";'file:///D:/Documents and Settings/ksp/My
Documents/source.ods'#$Sheet1.A1:G1;2;0)"
(basically search for "abc" in first line of file "source.ods" and return
value from second column).
3. Note that function returns "2" (which is wrong), and not what is visible in
B1.
Setting P2 as this seems to be nasty surprise for users.
---------------------------------------------------------------------
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]
