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

 


Help: OASIS Mailing Lists Help | MarkMail Help

office-formula message

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


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.


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