How to insert a "new page" format above a cell in a LO Calc spreadsheet? [closed]

asked 2014-06-19 19:49:28 +0100

dominik.buerkle gravatar image

updated 2016-02-25 22:11:40 +0100

Alex Kemp gravatar image

Hi, I'm using Libreoffice 4.2.3.3, Gentoo official package. With Calc (German language pack), running on top of Gentoo GNU/Linux (amd64, locale de_DE.UTF-8),

I'm doing a spreadsheet that has my expenses listed and I want to print them on a monthly base; one page each month (I always print just the last page).

I kept having around 59 rows on each page so it would nicely fit on page boundaries (with header and footer turned off). But today, something has gone wrong and the page boundaries didn't fit any more, there was a whole page of offset (i.e. each page had about 63 rows). I reverted to 0.43 cm line height and deleted single (empty) rows in about five or six month's pages to make it fit the page height, again.

Problem solved, but a nicer variant (put a "new page" command in some format cell at the top of each month) is urgently required.

Any hints/tips on this, anybody?

Thanks in advance, Dominik

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2016-02-25 22:11:50.876661