Hi Guillaume,
I have checked your scenarios, and what you describe does happen. In looking at the code we get the cell back from Excel complete with CR/LF’s that we may have put in e.g. on export. However, I noticed that if I did a cut and paste from a document to a cell it looks like Excel removes the CR, and it looks like this is an issue for EA. I did some further digging and indeed Excel will on data entry substitute LF to replace CR + LF!!
To verify I did a test by checking for LF’s and adding a CR, if not present. and that seemed to do the trick.
Before making any changes I’ll have to work through other scenarios and do some checking but looks like there may be a solution in the future.
But back to the now – not sure how to force Excel to include both CR/LF in the cell.
I’ll take a look and see whether i can find a way in Excel e.g. a macro that could be run to reintroduce the CR as it looks that we have no issues with exporting CR LF into a cell – it seems to be the cut and paste of data into the cells.
Regards
Adrian
