Re: [office-formula] 6.18.10 LEFT and large Length argument

["David A. Wheeler" <dwheeler@dwheeler.com>]

> Section 6.18.10 LEFT states in the testcases that
> 
>     =LEN(LEFT("xxx";2^15-1))
> 
>     Needs to return empty string at level > 1.
> 
> I think that is wrong. If Length is greater than the numbers of
> characters of text, the full text must be returned, same as with
> RIGHT().
> 
> Opinions?

You're correct, that's an error in the spec.  Thankfully, it's a really obvious one, because the test fails on every app I know of (I've been concentrating more on the tests where the results vary).  But by all means, fix it in your copy and then send it in.

--- David A. Wheeler