How to simulate the ALT-ENTER in excel when adding data

29417

Maya Kirova posted over 12 years ago

I am creating an Worksheet and attempting to add data to a cell. I want to pass what Excel uses as alt enter (chr(10)) so that my data shows up as multiple lines within a single cell. How can this be done?

Parents

29417

Offline Maya Kirova posted over 12 years ago

Hello,

The new line that get created when you use alt+enter is actually a “/r/n” string when represented as a cell value. So to add such value you just need to add “/r/n” where you need the new line in the cell. So for example:

cell2.Value = "Sample Text , Sample Text \r\n \r\n \r\n Some more text \r\n Custom text";

Would generate a text in a cell with new lines. Also keep in mind that the WrapText property needs to be set to true:

cell2.CellFormat.WrapText = ExcelDefaultableBoolean.True;

Best Regards,

Maya Kirova

Developer Support Engineer

Infragistics, Inc.

http://ko.infragistics.com/support
Cancel
Cancel

Reply

44743

Mike Dour posted over 12 years ago in reply to Maya Kirova

FYI, due to a fix for issue 103739 in the latest SR of versions 11.1 and later, the cell's WrapText value will be automatically set to True when it is Default and text with newlines is set on the cell. This is mimic how MS Excel automatically turns on wrap text for a cell when Alt+Enter is used to add newlines in that cell.
Cancel
Cancel

Children

No Data