Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Mon May 07, 2012 1:52 pm

Hello,

I have a case where I would like to enter 2 lines in 1 single line in a cell.

This is supported by Excel if you hit ALT+ENTER

However, I cannot find how to generate that behavior with Spire...

So far I tried with \n and \r\n but it failed.

Any idea?

Thanks

slx
 
Posts: 1
Joined: Mon Mar 05, 2012 12:06 pm

Tue May 08, 2012 3:26 am

Hi slx,

You need to set the cell can wraptext, so please try the following codes:

sheet.Range["A1"].Text = "Hello\r\nWorld!";
sheet.Range["A1"].Style.WrapText = true;
Best regards

Eric
E-iceblue support
E-iceblue Co.,Ltd

Eric
 
Posts: 17
Joined: Tue Apr 24, 2012 4:53 am

Return to Spire.XLS