← Prev in month
← Prev in thread
Next in thread →
Next in month →
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 →