Subject: 6.18.10 LEFT and large Length argument
Hi, 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? Eike -- Automatic string conversions considered dangerous. They are the GOTO statements of spreadsheets. --Robert Weir on the OpenDocument formula subcommittee's list.