https://bz.apache.org/ooo/show_bug.cgi?id=126754
orcmid <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #9 from orcmid <[email protected]> --- (In reply to Kay from comment #8) > I've never used the TEXT function in Calc but here is the definition from: > > http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2. > html#__RefHeading__1018004_715980110 > > >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> > 6.20.23 TEXT > > Summary: Return the value converted to a text. > > Syntax: TEXT( Scalar X ; Text FormatCode ) > > Returns: Text > > Constraints: The FormatCode is a sequence of characters with an > implementation-defined meaning. > > Semantics: Converts the value X to a Text according to the rules of a number > format code passed as FormatCode and returns it. > > See also N 6.13.26, T 6.20.22 > <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< > > This definition could be quite different from what is defined in Excel. Also, the definition of Scalar for OpenFormula is any single value of one of the scalar types Number (including complex), Logical, and Text. Since FormatCode is implementation-defined, we need to look at what those definitions are for Apache OpenOffice. (The implementation is required to have a specification for that definition.) I expect that some harmony with Excel is intended but it is not clear what the extent of it is, nor how a Text value is handled when the FormatCode applies to Number values although the definition for the FormatCode could decide the matter. -- You are receiving this mail because: You are the assignee for the issue.
