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: TEXT has two parameters


Hi,

6.18.22 TEXT is defined with one parameter and has a

| TODO: Excel 2003' “TEXT” function is different from other spreadsheets
| and previous versions of Excel.  It has a REQUIRED format parameter as
| the second parameter.  VALUE has better portability.

Well, actually Kspread is the only application that implements TEXT with
only one parameter; Gnumeric, OOo and Excel (AFAIK already since Biff2)
require two parameters. I'll adapt that spec to reality..

  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]