Export Excel ~ Alt + Enter in one cell

[kc.chau]

Hi everyone, 

New to JS and Java. Working on a project to export JS to Excel. (version 6.0.0.final)

A few questions about exporting to Excel.:

1. Could I add a chr(10) from the Design view? (Using eclipse + derby + .jrxml file)? If so, how?

p.s. Couldn't find a way to do add a chr(10) from design view. But then I try to add the chr(10) from the data. e.g. add chr(10) at the end of the column from sql. (seem not a normal way of doing it ?)

2. Display Two lines in one cell in Excel. e.g. alt + enter in excel cell to wrap text into two lines manually. (that's y I need to add chr(10) in question one)

p.s. 1 the chr(10) become a space when I export the jasperreport to excel if I set the Markup to 'none' 

p.s. 2 the text after chr(10) disappear when I export the jasperreport to excel if I set the Markup to 'styled' or 'html' 

Many Thanks