* On 13.11. Andrew Douglas Pitonyak ([EMAIL PROTECTED]) muttered: > Til Schubbe wrote:
> >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. > > > Huh? No it is not. Probably you got me wrong. I meant that asuming an unsorted table is the default behaviour in Calc 1.1.x. > http://www.pitonyak.org/database/Calc_As_A_Simple_Database.odt > The final column, sort_order, is optional. The default value for > sort_order is 1, which specifies that the first column is sorted in > ascending order; The document you stated referes to Calc 2.x. > The beahavior changed, I think, in version 2.0. Yes, that's what I noticed. To illustrate the problem: In http://schubbe.org/test/OOo/vlookup-test.sxc (created with OOo 1.1.4) you can see an unsorted table (A6:D16) - you have to open it with OOo 1.1 of course. The cells D1 and E1 are refering to the unsorted table. Both VLOOKUPs are only called with 3 parameters and the results are correct: D1 shows "c2" and E1 shows "d11". In contrast to the 1.1.4 spreadsheet http://schubbe.org/test/OOo/vlookup-test.ods (created with OOo 2.0.0) contains the same data and formulars. But D1 shows "c4" and E1 shows "d8". Both results differ (and are wrong) from the results in the 1.1.4 spreadsheet. The same formular used in different program versions should either result in the same outcome. Or the newer program version must convert the formular (in an older spreadsheet opened with the newer program version) so that the formular shows the same result as the spreadsheet in the original (old) version does. Doing neither is a bug. Regards Til --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
