Google Spreadsheet Line Breaks

Comments

9 comments

  • Avatar
    Mike Thomas
    Hello Benjamin,

    Very interesting. Could you tell me the name of the company in your account? I wasn't able to find this Presentation based on the e-mail address used here. 

    Regards,
    Mike Thomas
    0
    Comment actions Permalink
  • Avatar
    Benjamin Jones
    My company name is Runk and Pratt and the subcompany name is Activities - LR
    0
    Comment actions Permalink
  • Avatar
    Mike Thomas
    Benjamin, thanks. I am looking into this now. 

    Regards,
    Mike Thomas
    0
    Comment actions Permalink
  • Avatar
    Benjamin Jones
    Hmmmm... Lemme try that! Thanks :)
    0
    Comment actions Permalink
  • Avatar
    Darius Aleksas
    Benjamin, just add <br> in Google sheets where you want breaks to appear. I do that all the time. Other HTML markups work as well, such as <strong> <p> and others.
    0
    Comment actions Permalink
  • Avatar
    Benjamin Jones
    Seems like that works!  My only issue is that the person that updates this spreadsheet also prints it out for our residents.  Wish there was a way that Google Sheets would automatically insert that tag.
    0
    Comment actions Permalink
  • Avatar
    Darius Aleksas
    It is not a perfect world, right ))) Try changing color for <br> to match background color. But I think alignment would still be an issue.
    0
    Comment actions Permalink
  • Avatar
    Mike Thomas
    Benjamin,

    Looking at your spreadsheet, there is a lot of spare content on the left separating breakfast, lunch, and dinner. My advice here would be to show only the range of the cells for each day. You can use a image widget or text widget to denote breakfast, lunch, dinner, or other headers at top/bottom. This may make it easier to select content as well, and provide additional flair for the Presentation.. i.e. make it more "pretty" :) 

    Regards,
    Mike Thomas
    0
    Comment actions Permalink
  • Avatar
    Benjamin Jones
    I'm only showing the cell E6, but unless I put a <br> tag in there, it ignores the line breaks.  Wish I could fix it without having to add the extra code, which I'm sure will confuse the employee performing this task ;)
    0
    Comment actions Permalink

Please sign in to leave a comment.