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) 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.
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 sorted.
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]
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info: http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
