We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Line Break in Cells and '' as leading Character

Thread ID:

Created:

Updated:

Platform:

Replies:

31237 Jul 4,2005 08:02 AM Jul 13,2005 04:39 PM Windows Forms 1
loading
Tags: XlsIO
Kai Wachter
Asked On July 4, 2005 08:02 AM

Hi, i have problem with LineBreak in Cells and a Leading ''. when i Try to insert the following text in Range it does not Appear correctly: lrange.Text = "''Test with LineBreak." & vbcrlf & " this should appear in a new Row" The Range has a named CellStyle applied on it. when i open this Excel File you can see the Leading '' and the text in cell is in one line. When i enter the cell in edit mode and press enter, the cell is diaplayed as desired. Thanks for your help. Best regards. Kai wAchter

Administrator [Syncfusion]
Replied On July 13, 2005 04:39 PM

Hi Kai, Please set wraptext property to true. Here is a sample code snippet mySheet.Range("A1").Text = "Hello" & Constants.vbLf & "World" mySheet.Range("A1").CellStyle.WrapText = True Thanks, Stephen. >Hi, > >i have problem with LineBreak in Cells and a Leading ''. > >when i Try to insert the following text in Range it does not Appear correctly: > >lrange.Text = "''Test with LineBreak." & vbcrlf & " this should appear in a new Row" > >The Range has a named CellStyle applied on it. >when i open this Excel File you can see the Leading '' and the text in cell is in one line. >When i enter the cell in edit mode and press enter, the cell is diaplayed as desired. > >Thanks for your help. > >Best regards. > >Kai wAchter

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;