Product: Spreadsheet
Type: changed
Title: Transporting newlines in spreadsheet formulas
Posted by: [email protected]
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: new
*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 [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
