Interesting. Either Excel version 1803 (from Office 365) behaves differently, or retrieving from DB2 instead of Excel behaves differently.

I changed my query to use CHR(13), just like your example, and I get the same results. Double-clicking in a cell merely puts me in Edit mode for the cell contents - it does not change or expand the newline characters.