[sc-features] changed/cws calcmultiline : Transporting newlines in spreadsheet formulas

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

[sc-features] changed/cws calcmultiline : Transporting newlines in spreadsheet formulas

eike.rathke


       Product: Spreadsheet
          Type: changed
         Title: Transporting newlines in spreadsheet formulas
     Posted by: [hidden email]
      Affected: sc
         TaskId: i35913
<http://www.openoffice.org/issues/show_bug.cgi?id=35913>
Effective from: cws calcmultiline
           CWS:
<http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300/calcmultiline>
    CWS status: integrated


*Flags*
-------
API/ BASIC [ ]
Configuration [ ]
File format change [ ]
Help/ Guide [x]
Performance test [ ]
Translation [ ]
UI relevant [ ]


*Description*
-------------
Newline characters (0x0A, decimal 10) created with Control+Enter in
multiline text cells are now preserved in spreadsheet formulas.
Previously the newline character was replaced by a space character.
The newline character can be searched for using the SEARCH or
[HV]LOOKUP or MATCH functions with the \n regular expression. A
newline character can be inserted in a formula using the CHAR(10)
function. If the result contains newline characters it is displayed as
a multiline cell. The multiline result is exported to file formats
capable handling newlines in cell data, such as CSV.



Send feedback to [hidden email]



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