Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Just wondering how to create a list with line breaks in a calculated column without using data view.

share|improve this question
add comment

5 Answers

up vote 0 down vote accepted

social.technet.microsoft.com suggests that this can be achieved with " Shift + Enter "

Worth a try?

Steve

share|improve this answer
    
This works for sure inside =CONCATENATE() –  121315 Jul 6 '12 at 12:42
add comment

I suppose it depends on what you want the business rules to be around where the line breaks should appear and in how many places (all pages, just a single view, just on the forms, etc.). You could probably do this with script added to the page(s).

share|improve this answer
add comment

I've had a play around and I'm afraid I can't see a way to do this. The only two options I can think of are:

=CONCATENATE("A","
","B")

Which outputs A B because actual new lines are ignored by the HTML rendering.

or

=CONCATENATE("A","<br/>","B")

Which outputs A<br/>B because HTML output is escaped by SharePoint.

share|improve this answer
add comment

You could use <br/> in your column to indicate a line break. Then, add a script to your page to insert that text as html so that <br/> becomes an html line break.

<script src="http://code.jquery.com/jquery-1.6.1.min.js"></script>
<script language="javascript" type="text/javascript">
  function insertLineBreaks() {
    $("table.ms-listviewtable").find("td.ms-vb2").filter(":contains(<br/>)").each(
      function(){
        $(this).html('<div>'+$(this).text()+'</div>');
      });   
  }
  _spBodyOnLoadFunctionNames.push("insertLineBreaks");
</script>
share|improve this answer
    
This looks like a solution! Can the script be inside a content editor web part or does it have to be located in the main page html? –  121315 Jul 25 '11 at 16:25
    
You should be able to put it in a Content Editor web part. –  Laurie Jul 25 '11 at 16:36
add comment

Use Char(10) as a line break character.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.