Wrap spreadsheet and table content

Wrap content option decides how cells behave when cell content is too long, the following example shows both options:

 

Left - not wrapped, Right wrapped

If there are newline characters in the text (you can use them using char(10) formula), they will be displayed, only when "Wrap content" option is checked. When this option isn't checked, newline characters will be displayed as space.