"Edit MySQL Data" modifies newline to "\n" but not backwards

[Werner Karl]

When I use "Edit MySQL Data" to edit my data, newlines are treated wrong.

A newline in a cell (entered with <ALT>-<Enter>) is converted to "\n" on the mysql server. This could work out correctly if MySQL for Excel converted "\n" back to newline when reading data back into the cell. But it doesn't. When I use "Edit MySQL Data" the next time, "\n" is displayed instead of a newline.

Under certain circumstances that I can't currently reproduce the edit/save/reload cycle produces double backslashes, i.e. "\n" becomes "\\n". However, these double backslashes do not double again at next edit (or I haven't managed it yet).