To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92104
User regina changed the following: What |Old value |New value ================================================================================ CC|'' |'regina' -------------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED -------------------------------------------------------------------------------- Keywords| |oooqa -------------------------------------------------------------------------------- Resolution| |WORKSFORME -------------------------------------------------------------------------------- ------- Additional comments from [EMAIL PROTECTED] Thu Jul 24 20:06:23 +0000 2008 ------- If you will use a word for the boolean value, than you must use the language of your "local setting" in tools > Options > Language Settings > Language. So I have to use WAHR and FALSCH for my German local. It makes sense to change such words to 0 and 1 to make the document independent of the "local setting". If you do not like 0 and 1 as logical values, you can use the functions FALSE() and TRUE() (or FALSO() and VERDADERO()for Spanish, I guess). The name of the functions as they are shown, depends on the UI language, not on the "local setting". So there is no error in the way VLOOKUP works. --------------------------------------------------------------------- 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]