[sc-features] changed/CWS calc56 : TEXT returns text if text passed

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

[sc-features] changed/CWS calc56 : TEXT returns text if text passed


       Product: Spreadsheet
          Type: changed
         Title: TEXT returns text if text passed
     Posted by: [hidden email]
      Affected: sc
         TaskId: i108385
Effective from: CWS calc56
    CWS status: ready for QA

Configuration [ ]
File format change [ ]
Help/ Guide [x]
Performance test [ ]
Translation [ ]
UI relevant [ ]

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.

=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 [hidden email]

To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]