A sample that works for me is in GridCtrl.cpp, function GridCtrl::SetClipboard, where the separation between rows is with \r\n and between columns is with \t.
This way the cells are pasted well in MS Excel and in Open Office.
A thing to care with is not to add aditional tabs per row as in GridCtrl. This additional tab deletes the next column in Excel.