Data Merge Layout - span two pages

[EatMoreBacon]

When using the Data Merge layout tool - can my n-up layout span two pages? At the page gutter I need a little more space between the columns than I do otherwise.

I want the merge to go row by row straight across the page break. So it would do 123 in first row on page 1, then 456 on first row on page 2, then 789 on 2nd row on page 1, etc

[walt.farrell]

You can certainly create a layout that works that way, but remember that the gutter applies both between columns and between rows, so any gutter you add for the middle of the spread will also apply to the space between the rows.

[EatMoreBacon]

but that gutter will apply to each row and column.

i want three columns on the first page then a wide gutter and then three columns on the next page

[anto]

22 hours ago, EatMoreBacon said:

So it would do 123 in first row on page 1, then 456 on first row on page 2, then 789 on 2nd row on page 1, etc

It is possible if you organize your data in LibreOffice Calc or Excel in such mode.

Use formula

=OFFSET($A$2;(ROW()-2)*N+(COLUMN()-2);0;1;1)

where N is numbers of columns you need

 

After operations described in video you can select all your data and choose Data-->Calculate --> Formula to value to leave in cells only values.

In Publisher it is very easy to do

 

 

 

[EatMoreBacon]

Ok, so basically I have to rework my spreadsheet to have all the data values for one row in my merge to be in one row in my spreadsheet.  Will seem like lots of repeat cause I'm merging about 8 values to  n and each value gets a different placement or different paragraph style in Publisher.

But it can be done!

Thanks!

[anto]

11 minutes ago, EatMoreBacon said:

different paragraph style in Publisher

You can create styles in Publisher before datamerge

 

 

[anto]

37 хвилин тому EatMoreBacon сказав:

Will seem like lots of repeat cause I'm merging about 8 values to  n

You can copy (create) 8 sheets of values in LibreOfficeCalc and apply each sheet to spread in Publisher, i.e. sheet3 to pages 5-6, sheet4 to pages 7-8.

[walt.farrell]

8 hours ago, EatMoreBacon said:

but that gutter will apply to each row and column.

i want three columns on the first page then a wide gutter and then three columns on the next page

Right. That's why you can't really do what you want with the Data Layout tool across the spread.

[anto]

11 minutes ago, walt.farrell said:

Right. That's why you can't really do what you want with the Data Layout tool across the spread.

It is possible, but part of work must be done manually.

 

 

[EatMoreBacon]

11 hours ago, anto said:

You can create styles in Publisher before datamerge

Right, but each cell in excel will only go to one style in Publisher. So if I have several different styles for each N, I will need to have the same number of cells x 6 in each row of the spreadsheet.

10 hours ago, anto said:

It is possible, but part of work must be done manually.

Thanks for that suggestion. I will have to think through my layout and decide what will work best.

 

I guess it isn't possible to display a two page spread minus the margins so that the layout tool would ignore the gutter?