Re: [dev] Calc, VLOOKUP 1.1 -> 2.0: Changing of default behaviour?

2005-11-14 Thread Niklas Nebel
Andrew Douglas Pitonyak wrote: When I created the document. I think that I noticed a behavior change NOT a specification change. In other words, I thought (correctly, or incorrectly) that it always assumed sorted, but the behavior changed when an unsorted list was incorrectly referenced as sort

Re: [dev] Calc, VLOOKUP 1.1 -> 2.0: Changing of default behaviour?

2005-11-13 Thread Andrew Douglas Pitonyak
Til Schubbe wrote: * 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) fun

Re: [dev] Calc, VLOOKUP 1.1 -> 2.0: Changing of default behaviour?

2005-11-13 Thread Til Schubbe
* 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 pa

Re: [dev] Calc, VLOOKUP 1.1 -> 2.0: Changing of default behaviour?

2005-11-12 Thread Andrew Douglas Pitonyak
Til Schubbe wrote: 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

[dev] Calc, VLOOKUP 1.1 -> 2.0: Changing of default behaviour?

2005-11-12 Thread Til Schubbe
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