OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

 


Help: OASIS Mailing Lists Help | MarkMail Help

office-comment message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]


Subject: 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

PGP signature



[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]