Line Breaks in cells
Posted: Sun Jul 19, 2020 12:11 pm
Hi,
How can I insert a line break in a cell in a way that it is displayed correctly?
I tried: AsString[0,0] := 'line1' + sLinebreak + 'line2';
When I open the excel file, the content of the first cell is "line1line2".
But when I simply click into the cell and press F2 and Enter, then the text is displayed correctly with the line break.
So, it somehow works to a certain extent.
I want Excel to show the line break right after opening the file without any unnecessary clicking.
How can this be done?
Thanks
Schmulm
How can I insert a line break in a cell in a way that it is displayed correctly?
I tried: AsString[0,0] := 'line1' + sLinebreak + 'line2';
When I open the excel file, the content of the first cell is "line1line2".
But when I simply click into the cell and press F2 and Enter, then the text is displayed correctly with the line break.
So, it somehow works to a certain extent.
I want Excel to show the line break right after opening the file without any unnecessary clicking.
How can this be done?
Thanks
Schmulm