Ask Your Question

Calc print line to line on a partial page

asked 2017-10-20 08:47:06 +0100

milkboy gravatar image

Here is the deal, I'm Trying to save some paper and ink in the office.

I use spreadsheet to log all task, old and new. every time there is a new task, a new row at the bottom is added, and it needs to be printed. I print the whole page again, even thou, most time it only use less than the full page.

what i want is to print the line (row) that i needed on that old page. say, 1 page can hold #40 row of task. i used top half of the page to print row #01 - 20. now i want to use that paper to print row #21- 30 on the bottom unused side of the page. and the next day i want to use the rest of the page to print row #31 -#40 can it be done?

im on Version: (x64)

edit retag flag offensive close merge delete


You can make a simple experiment. Open any application, then print any single page once, re-load the paper, then print the same page second time, and see if the lines merge. Most probably you will see that there is misalignment, which is caused by imperfection of printer's paper feeding. And there's nothing a SW can do about that.

If that's OK for you, then just experiment with partial printing...

Mike Kaganski gravatar imageMike Kaganski ( 2017-10-20 09:06:21 +0100 )edit

tried that in the past.since most time i need to reprint the same page at least once a day, i becomes too muddy.

milkboy gravatar imagemilkboy ( 2017-10-23 03:38:23 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2017-10-20 12:25:09 +0100

Lupp gravatar image

updated 2017-10-20 12:27:42 +0100

(I never did such a thing, but it may be laudable.)

Defne a named cell style, say 'csNoPrint', derived from the one you are using in your task lines (most likely 'Default'). Defining the style properties do not change anything except on the tab 'Cell Protection' where you accept 'Hide when printing' under 'Print'.

In advance of printing the next squadron of task rows select all rows above the first new one, and apply 'csNoPrint' to it.

Of course you will also need to suppress the printing of old rows if a new page is needed. Do so by defining print ranges.

If the paper guide and ajustement of your printer are not precise enough, LibO cannot do anything about it.

You cannot suppress the repeated printing of 'Header' and 'Footer' this way. Use (define) a 'Page' style without these elements.

edit flag offensive delete link more


This do the trick. still need to play around to familiarize with the setting, but over all works.

milkboy gravatar imagemilkboy ( 2017-10-23 03:52:40 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-10-20 08:47:06 +0100

Seen: 48 times

Last updated: Oct 20 '17