Multiline cell
Posted: Tue Dec 08, 2015 3:25 pm
Dear all,
I try to set the string value of a cell on multiple lines. For this I use "#13+#10" caractères (CR/LF) This way :
When I open the xlsx file, the data are in one line "TESTTEST 2"
But as soon as I double click on the cell, the data goes in edit mode and without doing anything, they appears on 2 lines
What can I do on my Delphi code for this problem to be solved?
THanks a lot
Noémie
I try to set the string value of a cell on multiple lines. For this I use "#13+#10" caractères (CR/LF) This way :
Code: Select all
XLSReadWriteII51[0].AsString[Col,Row]:='TEST'+#13+#10+'TEST 2';
XLSReadWriteII51[0].Rows[Row].Height:=4000;
But as soon as I double click on the cell, the data goes in edit mode and without doing anything, they appears on 2 lines
What can I do on my Delphi code for this problem to be solved?
THanks a lot
Noémie