Product: Spreadsheet
Type: changed
Title: TEXT returns text if text passed
Posted by: [email protected]
Affected: sc
TaskId: i108385
<http://www.openoffice.org/issues/show_bug.cgi?id=108385>
Effective from: CWS calc56
CWS:
<http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=OOO330/calc56>
CWS status: ready for QA
*Flags*
-------
API/ BASIC [ ]
Configuration [ ]
File format change [ ]
Help/ Guide [x]
Performance test [ ]
Translation [ ]
UI relevant [ ]
*Description*
-------------
The spreadsheet function TEXT now returns text if text is passed as
the first argument, instead of numeric 0. Additionally, only if the
first argument is text, if the format code passed as second parameter
is a text format code, i.e. contains an unquoted @ text placeholder
code, the result string is adapted accordingly. This change enhances
MS-Excel interoperability.
Examples:
=TEXT(1;"00") => "01"
=TEXT(1;"""foo""@""bar""") => "1"
=TEXT("x";"00") => "x"
=TEXT("x";"""foo""@""bar""") => "foo x bar"
OOo3.2 and OOo3.2.1 had a bug that if text was passed as the first
argument the function returned a #VALUE! error.
Send feedback to [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
