I'm using NetAdvantage 10.1. In an UltraGrid I have one cell that contains multiple items formatted to appear on multiple lines within the cell. The content looks like this

Item 1<br />Item 2<br />Item 3<br />

That works great and appears like it should on the screen.

Since Excel doesn't recognize the HTML <br />, I use the CellExporting event to replace it with CR/LF. Unfortunately, this doesn't work. I've tried multiple variations (just CR, just LF) with no luck. Somewhere in the process the CR/LF gets replaced with a single space character so the exported cell contents end up like this

Item1 Item 2 Item 3

Does anyone know a workaround for this?