Calc and number of copies does not work

users
#1

Hi,

i have a weird behavior on Calc. When i want to print 20 times the same spreadsheet (http://prntscr.com/6srcnl) i can set 20 as number of copies, it always just print me 1 page :frowning:
what am i doing wrong ?

#2

Because you entered '1' in your screendump?

:wink:

#3

The print dialog has an option "Print current sheet only" which may be
checked.
Otherwise, the printable sheet may have a print range defined. Once you
define print ranges to exclude other ranges from printing, you've got to
define print ranges for every sheet you want to be printed.
See menu:Format>Print Ranges>Define...
menu:Format>Print Ranges>Set sets the currently selected cells.
menu:Format>Print Ranges>Remove removes all print ranges from this sheet.

#4

But, now a serious not on your question:

1) What version of Libre office are you using?

2) Which OS (and version) do you have ?

3) What kind of printer is this not working for?

#5

Now I see the screen shot. You print all pages of the selected sheets.
Either you select more sheets or you check the option to print all pages
of all sheets.
If that does not work, remove any defined print areas from all sheets.

#6

Hi :slight_smile:
Can you try printing just 1 page and only do 3 copies of it? ie a really
small test-run to see if anything obvious emerges as to why it's only
giving you 1 page.

Is the printer's memory getting overloaded or something? Do you have to
enter a code (ie some sort of office set-up or multi-user printer) to get a
print-out and do you have to do that per copy or per session or some other
weird thing like that?

One of my printers needs me to press a green tick twice otherwise it tries
to use a wrong tray (that doesn't even have paper in it). Apparently it's
fairly normal for that printer model and now i know the trick it's kinda
tolerable.

It is very weird that it's only printing 1 copy but hopefully one of us
might shake something loose about what is causing it.
Regards from
Tom :slight_smile:

#7

See the solution to this problem at the bottom of this top post (no flames please).

I have experienced the same problem recently. I'm running LO 4.3.5.2 on Windows XP using a print server to a Samsung SCX 4035FR printer printing double sided which is way more information than you need to know.

Mosr of the responses in this thread have missed the point. The problem is with the "Number of copies" and "Collate" options on the right side of the General tab of the print dialog. If you try to print two (2) COPIES only one (1) copy prints. The problem is linked to the collate option setting.

My settings on the General tab of the print dialog:

Range and copies
   Selected sheets
From which print
   Pages 1-3
Number of copies
   2
Collate
   Ticked

Solution:
Tick "Create single print jobs for collated output" on the Options tab of the print dialog.

#8

Thanks James. I think you may have answered the other half of a long standing lack of knowledge on my part.

My understanding was that if you just put a number in the "Number of Copies" box then the print job told the printer to print multiple copies. It didn't send the job multiple times and if the printer did not understand or could not cache the job for multiple copies then you just got one copy and that's why I just got one copy. I have never had much need for multiple copies of print output so have not ventured further.
I assume from your instructions the multiple copies are now concatenated and sent as one big print job.

Thanks, steve