Comment on test case for LEFT()

[Brad Hards <bradh@frogmouth.net>]

Section 6.19.10 "Left" has this test case:

Expression: =LEN(LEFT("xxx";-0.1))
Result: Error
Level: 1
Comment: It makes no sense to request a negative number of characters.  Length 
is converted using INT, towards negative infinity, so Length becomes -1

That is a bit subtle, and doesn't just test LEFT(). In particular, it will 
fail if the implicit conversion goes to 0 instead of -1.

Suggest that the expression should be: =LEFT("xxx";-1)
which would just test LEFT.

Brad

PGP signature