automatic empty row in the middle of calc's pages

Hello,

I need to have a empty row in the middle of each pages of a calc sheet. My probleme is : i cannot have guide line to show me the middle of the page and with the inside of the cell varing, it will be a real hassle, if i have to make jump to the next row myself.

Edit:

thank to reply me. by “each page” I mean Pagination sections that appear when you set up for printing, to show how your sheet will be divided on paper. I found an option that mark a broken line to show the end of paper sheet if it was printed. But then i lost it. But anyway because if i could do this for a few docs with no much data, with lot of docs full of data it will be hell. What is an “empty row”? → A row of empty cells for future input, because I need to fold the paper sheet in the middle.

by automatic I mean, for example, if I put data in the first 25 cells, and each cell contains 1 line of data. The 20 first row make the high part of the printed sheet, the 5 last make the low part of the printed sheet. Now if I add data to the 17th cell and this cell is about 3 lines now then cell 19th and 20th should go down to low part, automatically.

A few ambiguities needing to be resolved:

  • What do you mean by “each page”?
  • Pagination sections that appear when you set up for printing, to show how your sheet will be divided on paper.
  • Screen paging (which will of course depend on zoom setting)
  • Each sheet (tab) of a spreadsheet file
  • What is an “empty row”?
  • A blank area in the output, spacing as a visual aid, sort of a paragraph break
  • A row of empty cells for future input
  • Should the “automatic” markup of “the middle” move to the middle of your dataset as you enter additional rows?

A description of your setup (layout, purpose) would be really useful, and with an attached sample file if possible. Help us to help you!

I suppose that (with the data @gear provided) this is better done using a half-sized landscape-oriented page size, and printing two pages a sheet…

(continuing with @mikekaganski idea) …will need to set top and bottom margins to near 0, and compensate with empty lines at the top of upper page, and at the bottom of lower page.