Hello, the last parameter of VLOOKUP tells Calc if the referenced table is sorted.
I have a Calc document (OOo 1.1.4) which contains some VLOOKUP (in the German version SVERWEIS) functions passing 3 parameters to it. The referenced table is unsorted. The default behaviour of VLOOKUP for omitting the 4th parameter is to asume an unsorted table. This works fine in 1.1.4. Opening the same document with 2.0 (Debian unstable 2.0.0-1) leads to weird results. I added a 0 as 4th parameter to VLOOKUP for testing and got the correct results. In 2.0 the default behaviour of VLOOKUP (with 3 parameters) to asume an (un)sorted table seems to have changed. Can someone confirm this? If the default behaviour has changed, the function in 2.0 which converts v1.1 documents into v2.0 documents for initial opening must add a 0 as 4th parameter to every VLOOKUP function only containing 3 parameters. Shall I report a bug? Regards Til --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
