← Prev in month ← Prev in thread
Next in thread → Next in month →

Comment on test case for LEFT()

From
Brad Hards <>
Date
2006-12-21T01:47:27+00:00
ID
Thread
Comment on test case for LEFT()
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
← Prev in month ← Prev in thread
Next in thread → Next in month →