I need to embed linefeeds in cells in an Excel sheet generated by LibXLMBS. If I create a csv file or simply paste text into a cell in Excel, Chr(10) is respected and I get a multi-line cell. When I embed Chr(10) inside a string and use XLSheetMBS.WriteString, however, the linefeeds are ignored and all text is on one line in the cell.
Any known workarounds?