Indentation of Bulleted list in Docs from Sheets data not working correctly

[peter solvkjar]

Im trying to format a bulleted list that indents correctly in Docs from my Sheet data. If the text is long, the line wraps on in doc and extends all the way to the left - right underneath the bullet (and hence is not properly indented).

I have tried to solve this 3 ways:

1. Use the substitute formula:   =ArrayFormula(if(len(A2:A),"• "&Substitute (A2:A,", ",char(10)& "• "),)) It creates the bullets correctly, but the text on the second line goes all the way out to the left and the second bullet is tucked in under the first bullet (not aligned all the way to the left)
2. I used "hard returns" in the sheet data but no bullets. I added the bullet formatting in the Doc. This aligns the text correctly, but the second "bullet" does not actually get a "bullet"
3. I put bullets and hard returns in the sheet data. The first bullet is perfect, but the second bullet is tucked under the first and the text run out to far to the left.

I love Autocrat - but this one issue is a big headache for me, and I have struggled with it for a long time. Any help and guidance is very much appreciated. Links to files below. Thank you.

Link to the sheet: https://docs.google.com/spreadsheets/d/1AXb54Gnc7IbMby0cAp7PIs6ICrlwHMzVc7Eb1-fXPcU/edit?usp=sharing

Link to the template:  https://docs.google.com/document/d/1d1x29C8kbIOBCu_6SlBg7Fey-GO-MB64_ddoaUN8bB0/edit?usp=sharing

Link to the resulting doc:

https://docs.google.com/document/d/1ycWGsoLHOuPSQ8MKrqcWczcfX_4cUkLXBcabg8RbS7I/edit?usp=sharing

[Joseph Schmidt]

I did some work on this a long time ago.  The only way I found was to create a separate column for each item.

You have to know how many indents there will be.  See https://drive.google.com/drive/folders/1NkdPDj37BY7kz3YCQ6qwXuNwarHa2eHT?usp=sharing

Trying to force Autocrat to do something it wasn't designed to do can be frustrating.  And time consuming.

Joe Schmidt

https://www.youtube.com/c/JoeSchmidt

 GLUA...@gmail.com

New Visions Blog Entry - Joe Schmidt

--
You received this message because you are subscribed to the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-autocrat-add...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/22df97c2-7e8c-4d44-9ef3-798c530e4784n%40googlegroups.com.