Paragraph spaces within a cell

I can’t work out how to get a paragraph space to show up on the app from a cell?

Does anyone know how to do this?

Thanks so much :smiley:

Are you using a rich text component?

Sorry I don’t know what you mean by a “rich text component?”

1 Like

Use CHAR(10). So in this example,

=“* Text on line 1”&CHAR(10)&”* Text on line 2”

Would give you a markdown bullet list if you add the component as rich text.i.e.

  • Text on line 1
  • Text on line 2

I’d suggest you use dillinger for creating your rich text and selecting RICH TEXT (instead of plain text) in Glide, when calling that field.

If you are typing directly in the Google Sheet you need to use CTRL-Enter to get a new line. If you want a space between those line breaks you need to put 3 spaces at the end of the line.

Then in Glide you need to select the Rich Text component, as @Jeff_Hager said, when you add that column to your detail page.

2 Likes

Just curious, but why is it 3 spaces at end of line when Markdown normally only requires 2 to invoke a break?

Thanks Jeff :slight_smile:

1 Like

I believe I heard that on here from David, but maybe 2 will work as well. Before working with Glide I never used markdown so it’s all new to me. It’s hard to see how many you actually entered, no matter how they make it to the cell, so I guess I will stick with 3 just to have an extra in case I fat fingered it. :slight_smile:

1 Like

Cheers. I’ve used Markdown for years so it’s nice to see it supported in Glide.

One thing I have noticed though is that when you construct the contents of a cell via formulas rather than pure text entry, it’s not possible to get Glide to acknowledge multiple line breaks. So although you can use multiple CHAR(10)s and even add in &" " a few times, Glide will never go further than adding one new line in the app, despite the cell in Sheets rendering as you would expect.

Not a major issue, but it’s definitely not WYSIWYG using this approach.

1 Like

I’m not sure if there is a way in Markdown to add more than one blank row between text lines. Can you show me an example of where you found that to work? I tried it in dillinger.io and could not get more than one blank row to show up no matter what. There are more than 2 spaces at the end of each one of those 3 lines separating “Test” and “Another”. However I can’t get an extra line in Glide as I can in Dillinger.io, but the behavior is the same whether I type in the text or use a formula, those extra blank (with spaces) lines don’t render as a blank line.

After a bit more fooling around I was able to get more than one blank row between rows with data by faking it out with blank headers. I could not get this to work in Glide however, either with a formula or manually typing it in. So there is a difference in the markdown engines used between the two.

1 Like