Single Output Mode - Google Doc spacing is off on all pages after the first one

1,079 views
Skip to first unread message

Patrick Murphy

unread,
Nov 13, 2019, 8:42:10 AM11/13/19
to NV Autocrat Add-on
So I have a one page Google Doc template set up.  I have single output mode selected, I want ALL lines of data in the google sheet to create a new page int he same document (so I can mass print them).  The first page is perfect.  The subsequent pages the spacing is all off and it ends up being 2 pages. I have some Tables in the template so the data is aligned the way I want it but there is nothing pushing the tables down further.  Any thoughts why the subsequent pages would have different spacing?


AJ Wells

unread,
Nov 13, 2019, 8:59:25 AM11/13/19
to nv-autocr...@googlegroups.com
Patrick,

I don't have my data being pushed into a Google Doc, but rather a Google Slide being converted into a PDF (multiple files).  I had a problem where the formatting of background text (not the variable text, but rather, the form setup would shift when Autocrat would run.  However, if I set up the form and then converted it to a high-quality TIFF or PNG, and insert the image to a Google Slide, this has alleviated the shift issue.

Best Wishes,

A.J. Wells, MPA
Chief Financial Officer
Chief Operating Officer
Board of Education Treasurer
Powell County Schools


--
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/54ba265a-e2a8-4ff3-a6f5-49221f0b0cf5%40googlegroups.com.

Joseph Schmidt

unread,
Nov 13, 2019, 9:50:09 AM11/13/19
to nv-autocr...@googlegroups.com
Controlling spacing on single output mode is a problem.  Can you shorten the template so it doesn't come as close to filling the page?  You seem to have extra spacing that might not be needed.



On Wed, Nov 13, 2019 at 8:42 AM Patrick Murphy <patrick...@tvcs.org> wrote:
--

Patrick Murphy

unread,
Nov 13, 2019, 9:51:07 AM11/13/19
to nv-autocr...@googlegroups.com
Yes I can try to squeeze the extra spaces out.  I did it a little already but I will try some more.  

Patrick Murphy

K-12 CIAT Supervisor
The Villages Charter School
350 Tatonka Terrace
The Villages, FL 32162
Ph: 352-259-2350
Fax: 352-259-3850
Patrick...@tvcs.org

 




To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/CAPWPTOS3xeM%2B1DSYuXCA-OJiXCyaTN2YCYfUKNrJJRwvjKcyMQ%40mail.gmail.com.

Patrick Murphy

unread,
Nov 13, 2019, 9:57:48 AM11/13/19
to nv-autocr...@googlegroups.com
That seems to have helped... https://docs.google.com/document/d/1W8z8IA7wY4sgaosMzKi8Y60RTkSyQtXxJIZnZW81LQE/edit?usp=sharing

it is adding a blank row between each of my ros on the subsequent pages.  IN my main document (and page 1 of the output document) there is only one "blank" row between by data.  But in the subsequent pages there are 2 blank rows between each line.  that is strange. but that is what is pushing it to another page is the addition of the blanks rows.  Wonder why that is happening?

Patrick Murphy

K-12 CIAT Supervisor
The Villages Charter School
350 Tatonka Terrace
The Villages, FL 32162
Ph: 352-259-2350
Fax: 352-259-3850
Patrick...@tvcs.org

 



On Wed, Nov 13, 2019 at 9:50 AM Joseph Schmidt <glua...@gmail.com> wrote:
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/CAPWPTOS3xeM%2B1DSYuXCA-OJiXCyaTN2YCYfUKNrJJRwvjKcyMQ%40mail.gmail.com.

Patrick Murphy

unread,
Nov 13, 2019, 12:23:52 PM11/13/19
to nv-autocr...@googlegroups.com
Thanks. I am trying to get one document so I can mass print them at one time.

Patrick Murphy

K-12 CIAT Supervisor
The Villages Charter School
350 Tatonka Terrace
The Villages, FL 32162
Ph: 352-259-2350
Fax: 352-259-3850
Patrick...@tvcs.org

 



To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/CAD%2B118w1n5x6Cqry73rBBMaU4NSNUuZ8yvN6ApYxB4h5zV-HkQ%40mail.gmail.com.

Chris Hobbs

unread,
Nov 13, 2019, 4:40:49 PM11/13/19
to nv-autocr...@googlegroups.com
Silly question, but is there any chance your template is actually two pages? In addition to the line spacing changing, the font is changing as well. The phrase "PAY TO THE ORDER OF" is in Times New Roman on page 1 of the "better" version you shared but Overlock on the remaining pages. I can't imagine how Autocrat would/could be doing that.

Chris

To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/CACq9FjvtzN%2BTxwuRYVbtzxrkeSbUaDbsA6ma2VFbMLcNtvV15A%40mail.gmail.com.


--
Chris Hobbs
Dublin Unified School District
Director of Fiscal Services
Education That Inspires Lifelong Learning 

Patrick Murphy

unread,
Nov 14, 2019, 7:33:23 AM11/14/19
to nv-autocr...@googlegroups.com
The template is one page.  I am curious why the font changes and the extra space gets inserted too.  I noticed my template had some "headings" for some of the lines, so I removed those.  I reformatted all text to be Times New Roman.  And re-ran this morning. And the line spaces that are added are now a mix of Times New Roman and Arial size 11.  I do not have any Arial in my template.  This is really bizarre.

Here is the newest one I ran this morning. https://docs.google.com/document/d/1KAoTq22B2r1Gj4LLmjenjUhJ7p07CuwOdABbyXhSBuY/edit?usp=sharing

Page 1 is perfect. Then Pag2 and sll others have the new lines added and now some of them are Ariel.

I even reduced the side margin of my tables so they did not go all the way to the right of the page.... that didn't help.  Something happens with subsequent pages that is adding blank lines and changing the font to those new lines.

Patrick Murphy

K-12 CIAT Supervisor
The Villages Charter School
350 Tatonka Terrace
The Villages, FL 32162
Ph: 352-259-2350
Fax: 352-259-3850
Patrick...@tvcs.org

 



To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/CAH0CKy-U%2BLbCNtbcPUx9w8BeLFPVi3-za0wN6a%3DzA7UsQ%3DPbNw%40mail.gmail.com.

Chris Hobbs

unread,
Nov 14, 2019, 11:22:37 AM11/14/19
to nv-autocr...@googlegroups.com
I set up a sample job* this morning to test this out, just a simple Doc with a table to hold the fields. Tried it with and without formatting text in the spreadsheet (I had a theory that formatting the data in the Sheet would impact the Doc, but it appears Autocrat strips out any formatting from the data before merging it). 

It, of course, ran perfectly. 

Did you create the template from scratch as a Google Doc, or convert (either by uploading or copying and pasting) from a Word doc? I'm just wondering if there's some funky formatting code that's invisible to you that is affecting the output. 

If it wasn't a Doc originally, it might be worth building your template again and pointing your Autocrat job to the new file.

Beyond that I think I'm out of ideas. Sorry!

Chris



To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/CACq9Fjt_D9CHoLO6GOhiKydL%2BFg8ocWrR1Dhn%2Bb7xrG_zn%3DTOw%40mail.gmail.com.

Patrick Murphy

unread,
Nov 14, 2019, 12:17:15 PM11/14/19
to nv-autocr...@googlegroups.com
I created a brand new template from scratch.... (the original was converted from WORD).  Same issue with the brand new template.  Extra spaces are being added. Without fail, there is a new line added after each "table" in the new document that is not there in the original template.

Patrick Murphy

K-12 CIAT Supervisor
The Villages Charter School
350 Tatonka Terrace
The Villages, FL 32162
Ph: 352-259-2350
Fax: 352-259-3850
Patrick...@tvcs.org

 



To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/CAH0CKy9U9ZgSGTjzXB%2BDVWY7My3asV%3D-Ng3BB1Cs6EwexhmdnQ%40mail.gmail.com.

Clinton Steinbrunner

unread,
Jan 12, 2020, 10:49:51 AM1/12/20
to NV Autocrat Add-on
It looks like this issue never got resolved, as I am having the same issue. I have a table in a template and after the first page an extra space gets added after it on every subsequent page. I tried using columns instead (since it was just one row of two columns) and then I got an error message. It appears that autocrat can't run if there are columns in a template.

If anyone found another work around, I'd be happy to know!


On Thursday, November 14, 2019 at 12:17:15 PM UTC-5, Patrick Murphy wrote:
I created a brand new template from scratch.... (the original was converted from WORD).  Same issue with the brand new template.  Extra spaces are being added. Without fail, there is a new line added after each "table" in the new document that is not there in the original template.

Patrick Murphy

K-12 CIAT Supervisor
The Villages Charter School
350 Tatonka Terrace
The Villages, FL 32162
Ph: 352-259-2350
Fax: 352-259-3850

On Thu, Nov 14, 2019 at 11:22 AM Chris Hobbs <hobbs...@dublinusd.org> wrote:
I set up a sample job* this morning to test this out, just a simple Doc with a table to hold the fields. Tried it with and without formatting text in the spreadsheet (I had a theory that formatting the data in the Sheet would impact the Doc, but it appears Autocrat strips out any formatting from the data before merging it). 

It, of course, ran perfectly. 

Did you create the template from scratch as a Google Doc, or convert (either by uploading or copying and pasting) from a Word doc? I'm just wondering if there's some funky formatting code that's invisible to you that is affecting the output. 

If it wasn't a Doc originally, it might be worth building your template again and pointing your Autocrat job to the new file.

Beyond that I think I'm out of ideas. Sorry!

Chris



On Thu, Nov 14, 2019 at 4:33 AM Patrick Murphy <patric...@tvcs.org> wrote:
The template is one page.  I am curious why the font changes and the extra space gets inserted too.  I noticed my template had some "headings" for some of the lines, so I removed those.  I reformatted all text to be Times New Roman.  And re-ran this morning. And the line spaces that are added are now a mix of Times New Roman and Arial size 11.  I do not have any Arial in my template.  This is really bizarre.


Page 1 is perfect. Then Pag2 and sll others have the new lines added and now some of them are Ariel.

I even reduced the side margin of my tables so they did not go all the way to the right of the page.... that didn't help.  Something happens with subsequent pages that is adding blank lines and changing the font to those new lines.

Patrick Murphy

K-12 CIAT Supervisor
The Villages Charter School
350 Tatonka Terrace
The Villages, FL 32162
Ph: 352-259-2350
Fax: 352-259-3850

On Wed, Nov 13, 2019 at 4:40 PM Chris Hobbs <hobbs...@dublinusd.org> wrote:
Silly question, but is there any chance your template is actually two pages? In addition to the line spacing changing, the font is changing as well. The phrase "PAY TO THE ORDER OF" is in Times New Roman on page 1 of the "better" version you shared but Overlock on the remaining pages. I can't imagine how Autocrat would/could be doing that.

Chris

On Wed, Nov 13, 2019 at 6:57 AM Patrick Murphy <patric...@tvcs.org> wrote:

it is adding a blank row between each of my ros on the subsequent pages.  IN my main document (and page 1 of the output document) there is only one "blank" row between by data.  But in the subsequent pages there are 2 blank rows between each line.  that is strange. but that is what is pushing it to another page is the addition of the blanks rows.  Wonder why that is happening?

Patrick Murphy

K-12 CIAT Supervisor
The Villages Charter School
350 Tatonka Terrace
The Villages, FL 32162
Ph: 352-259-2350
Fax: 352-259-3850

On Wed, Nov 13, 2019 at 9:50 AM Joseph Schmidt <glu...@gmail.com> wrote:
Controlling spacing on single output mode is a problem.  Can you shorten the template so it doesn't come as close to filling the page?  You seem to have extra spacing that might not be needed.



On Wed, Nov 13, 2019 at 8:42 AM Patrick Murphy <patric...@tvcs.org> wrote:
So I have a one page Google Doc template set up.  I have single output mode selected, I want ALL lines of data in the google sheet to create a new page int he same document (so I can mass print them).  The first page is perfect.  The subsequent pages the spacing is all off and it ends up being 2 pages. I have some Tables in the template so the data is aligned the way I want it but there is nothing pushing the tables down further.  Any thoughts why the subsequent pages would have different spacing?


--
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-on+unsub...@googlegroups.com.

--
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-on+unsub...@googlegroups.com.

--
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-on+unsub...@googlegroups.com.


--
Chris Hobbs
Dublin Unified School District
Director of Fiscal Services
Education That Inspires Lifelong Learning 

--
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-on+unsub...@googlegroups.com.

--
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-on+unsub...@googlegroups.com.


--
Chris Hobbs
Dublin Unified School District
Director of Fiscal Services
Education That Inspires Lifelong Learning 

--
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-on+unsub...@googlegroups.com.

Matt Pyers

unread,
Jan 11, 2022, 5:39:15 PM1/11/22
to NV Autocrat Add-on
I had the same problem with the first page of my template coming out correctly but the line spacing was off for all subsequent pages.  After a few hours messing with margins, page breaks, formats, etc,  I noticed that any blank lines automatically change to arial 11 after the first page.  I adjusted my templates to use multiple arial 11 blank lines instead of one tahoma 28 (for example) for the spacing to be consistent on all docs in single output mode.
Reply all
Reply to author
Forward
0 new messages