Printing doesnt span pages.

[psyon]

I have a spreadsheet with about 100 rows, 3 columns each. When I try to sprint the sheet, it prints only the first 30-40 rows taht fit on oen page, and just keeps printing right down to the end of the sheet then stops. In order to print the whole sheet, I have to manually select ranages that fit on one sheet of paper, and print only the selection. Anyone else have this problem? Know a solution?

[David]

[Zarius]

Hi,

If I understand pyson correctly, I too have this problem with OpenOffice 1.1.2 on Linux. The problem also applies to columns, ie. if you have a spreadsheet 50 columns wide it will still only print one page with the rest of the columns disappearing off the right-hand side. The printer is set to "All", so that isn't the issue.

Placing manual row & column breaks works fine, but the problem is that it's not placing any automatic page breaks at all - which means you have to add manual breaks to every spreadsheet you want to print, not very practical.

Unfortuantely I have yet to find a solution - perhaps upgrading will fix it (due to circumstances, we're stuck with this version for a while though - using an old version of StarOffice for Calc, which prints fine for now).
_________________
Zarius Tularial. (WinXP - OOo 1.1.4, FedoraCore 4 - OOo 2.0, RHEL4 - StarOffice 7)
Quoots - a quicker way to open your documents and fill in template details in OOo. (written in OOBasic)

[uros]

Hi psyon!
I previous posts didn't solve your problem, try this:

Format > Print ranges > Print range - select "-none-"

If you have more than one sheet in a document, now other problem can occur - all sheets will be printed. To prevent that:
Tools > Options > Spreadsheet > Print - select "Print only selected sheets"

Hope it helps!
Uros

[Zarius]

Oops... there's always something one forgets to mention I should have noted that this applies to all spreadsheets, print ranges or no - even freshly created spreadsheets.

I checked all my settings again just to be sure - no print ranges, both "Print only selected sheets." and "Suppress empty pages." (just be be sure) are both off (unticked).

If pyson's comment "just keeps printing right down to the end of the sheet then stops" is the same as mine, it's not just print ranges, since "end of the sheet" is literal in this case, it completely ignores the bottom (or right) margins (set to 2cm) - top and left are fine - in fact, if you have the footer turned on, the grid prints right over the top of the footer and keeps on going to the bottom of the page.
_________________
Zarius Tularial. (WinXP - OOo 1.1.4, FedoraCore 4 - OOo 2.0, RHEL4 - StarOffice 7)
Quoots - a quicker way to open your documents and fill in template details in OOo. (written in OOBasic)

[uros]

Hi Zarius!
Sorry, I didn't pay any attention to post dates, psyon's And David's are pretty old.
About your problem - printing over bottom edge of paper. Could the reason for that be user defined paper format? I'm sure you already check that... You said there is no automatic page breaks, that brings me this idea.
Hope this will help!
Uros

[Zarius]

[uros]

Hi Zarius!

I don't have any more brilliant ideas.
I run OOo 1.1.1b without these problems, so upgrade from 1.1.2 probably won't help. Of course you can try... 1.1.5 is on mirrors.
Uros

[David]

[quote="uros"]Hi Zarius!
Sorry, I didn't pay any attention to post dates, psyon's And David's are pretty old.
/quote]

My embarassment. The computer clock had changed ...looking into that.

David.