To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=63901 Issue #:|63901 Summary:|Formula VERWEIS doesn't work properly Component:|Spreadsheet Version:|OOo 2.0 Platform:|All URL:| OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|editing Assigned to:|spreadsheet Reported by:|frank_heitbrock
------- Additional comments from [EMAIL PROTECTED] Sun Apr 2 02:32:42 -0800 2006 ------- Enter for example the following values in a spreadsheet: >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> A B 1 Kd-Nr Kd-Name 2 86756 Tank-Treff-Vellahn714341 3 121675 TOTAL -Tankstelle 4 128458 Raiffeisen Tankstelle 5 146023 Raiffeisen TS 6 145996 Jet Oezkoek 7 97009 ARAL Station 8 113337 Freie Tankstelle Ohde GmbH <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< Enter below that matrix in a cell (for example cell "B13" a formula which contains the link formule "=WENN(C13="";"";VERWEIS(C13;$Tabelle1.$A$1: $Tabelle1.$A$31988;$Tabelle1.$B$1:$Tabelle1.$B$31988))" In cell "C13" copy the customer number from cell "A7". You will get a wrong result "Tank-Treff-Vellahn714341" instead of "ARAL Station". In OpenOffice 1.1.4 this works fine. It is only tested with SuSE Linux 10.0 on AMD64, but i guess, this effects all OS on all platforms. --------------------------------------------------------------------- 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]