Ok, this is a small one but important to some use cases Im dealing with!
If you write a canvas formula to pull text from a cell it will pull it as one huge block of text unless there is formatting in that cells text already.
BUT, and here’s the big but, the formatting in a cell is only carried over to the canvas formula if it is bolded, italicized, underlined, bulleted, etc.
What it does not recognize is paragraph spacing. So if I have 3 paragraphs of information spaced out in a text (but not bold, italicized, etc) then it will pull those 3 paragraphs as one huge hard to discern block of text ignoring the paragraph spacing I have in the cell.
Small thing, but very annoying in some of my use cases. Please fix! Thank you!
2 Likes
Anyone have a workaround for this? We are creating more and more document generators, and losing paragraph spacing when dynamically creating pages is a problem.
Hm ok I found a workaround it seems. If I change the column to a Canvas, the issue persists. However if then I go into the cell, delete the paragraph space, then hit enter to recreate it (visually looks the same), then now it gets filled in the outside page formula with the correct paragraph spacing.
Summary:
- looks like paragraph spacing works for formulas for canvas type, but not text type.
- converting a text column to a canvas column will lose formula paragraph spacing unless the paragraph spaces are recreated in the new canvas type cell.
Hello @Scott_Weir ,
edit: I hadn’t noticed that your post was from 2020… I guess I am a bit late. I was triggered by the post from @Ed_Liveikis and answered without checking the date of the original. I guess in the meantime you have figured it out yourself 
If there is no formatting, a s simple totext() will keep the paragraphs. To keep formatting and linebreaks, you need a little bit of CFL: