Handling of \r and \n in xlsx export

[OPY]

Hi!

It seems that SmartGWT will export both \r and \n as Line Feed character (\r not export as Carriage Return character) when export to xlsx (tested on SmartGWT 6.0p 2019-02-09 release).

This is the sample UI:

This is the sheet1.xml extracted from the xlsx. All \n and \r combination are exported as "

":
sheet1.xml

Following is sample codes:
client: FrmMainSearch.java
ds: customDataSource_user.ds.xml
server: UserDataSource.java

As different version of Microsoft Excel will handle cell containing <CR> and <LF> in xlsx differently, I would like to be able to export \n as Line Feed character and \r as Carriage Return character, but tested many ways with no success. Any suggestion how I can achieve that?

Thank you very much!

[Isomorphic]

We are not reproducing this issue and we are not involved in the character conversion, it is done by Apache POI. In our tests \r and \n characters where exported correctly. This means that most likely something is different in your environment. This may be different POI lib version (not the one we ship), unusual JVM encoding setting or even something on Excel part. If you can show us how to reproduce the problem, we can take another look, but currently there's nothing more we can do.

[OPY]

Thank you very much for your information, I will test further on this.