I have a text value which is multiple lines (As shown in VS text visualizer is attached image) and I'm trying to put the contents into a Syncfusion spreadsheet (I've shown in the other image what is in an Excel Cell). Howver I seem to lose the multiple lines when I set the cell using the following call. (Attached Image 3)
Dim sfv = Chr(34) & s.ToString & Chr(34)
Am I using the wrong method to set the value and hence losing the formatting or do I need to encode in a different way to preserve the multiple lines ?
You can achieve your requirement of multi-line text in Spreadsheet by using AutofitRows method and you can set the cell value using SetCellValue method of SpreadsheetGrid. Please find the code example for reference,