OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Print causing major irritation

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
PaulR
OOo Enthusiast
OOo Enthusiast


Joined: 19 Feb 2004
Posts: 108
Location: UK

PostPosted: Thu Mar 04, 2004 7:31 am    Post subject: Print causing major irritation Reply with quote

I have just spent almost two hours of my working day (and wasted probably 50 sheets of paper) trying to persuade Calc to print one page of information...

The original Excel file resaved as OOo Calc (with about 7 tabs) opens fine and appears correct in print preview and page break preview. When I ask it to print if prints one line of text from near the bottom of the sheet!

I have checked...

Page and printer set-up
Print range (defined, edited, removed etc)
Text color

When Fit to page is unchecked it prints the whole sheet on four pieces of paper. When I uncheck fit to page and set a scale size of, say, 50% the sheet looks as expected in preview but again prints just one line on paper!

I have copied and pasted all sheets into a new native OOo calc file and it does exactly the same thing.

Help! - If I have another day like today Excel will be re-installed Sad
Back to top
View user's profile Send private message
8daysaweek.co.uk
Super User
Super User


Joined: 29 Nov 2003
Posts: 2130
Location: UK

PostPosted: Thu Mar 04, 2004 8:06 am    Post subject: Reply with quote

Hello again Paul,

I can't think of anything off the top of my head. The previous offer still stands if I can help, same email address as last time Smile

BFN,
_________________
James
www.8daysaweek.co.uk - A User-Focused OOo site
Back to top
View user's profile Send private message Visit poster's website AIM Address
antonbijl
OOo Advocate
OOo Advocate


Joined: 04 Aug 2003
Posts: 291
Location: Pretoria, South Africa

PostPosted: Thu Mar 04, 2004 11:54 pm    Post subject: Reply with quote

Paul

Sounds strange, but there must be an explanation. What operating system are you using? What version of OOo? What kind of printer is it? Do you have any problems printing to this printer from other applications? Is the printer installed locally or is it on a network? Have you tried printing from another machine or to another printer?

As a workaround, I can suggest you try converting to pdf first, and then print from the pdf format. Although this is less than ideal it has provided me with a quick solution on numerous occasions in the past when struggling with printing problems such as this.

Cheers

Anton
Back to top
View user's profile Send private message
PaulR
OOo Enthusiast
OOo Enthusiast


Joined: 19 Feb 2004
Posts: 108
Location: UK

PostPosted: Fri Mar 05, 2004 12:43 am    Post subject: Reply with quote

James - thanks for the offer but this one contains data covered by the Data Protection Act so I can't send it over. Damn!

Anton - these are the answers...

Windows XP
OOo 1.1.0
Epson Stylus 640
No problems printing with other apps
Its a network printer
Not tried on other printers

I've just rebooted all machines/network and specific printer and get the same result. If I export to PDF the document appears and prints correctly in Acrobat Reader.

Just deleted print range (was set to whole sheet) and document previews as expected but again when I try to print the 7th sheet I just get one line of text!

10 minutes later....

I've found the cause of the problem if not the solution...

Cell A29 is the only cell that is being printed. It contains text that begins as follows...

Notes: The premises have...

The string "Notes:" is in bold.

If I delete the contents of A29 the sheet prints normally!

I've just created a new sheet and entered the same string but it prints normally. I can only assume that there is some sort of corruption in the contents of A29 that is causing this anomaly.

Any suggestions?

TIA
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group