On Wed, 03 Dec 2008 22:48:53 -0800 JOE Conner <[EMAIL PROTECTED]> dijo:
> >>> On Fri, 28 Nov 2008 16:53:03 -0800 > >>> John Jason Jordan <[EMAIL PROTECTED]> dijo: > >>>> Currently I have two Calc files (call them X and Y). Each has a section > >>>> of data in cells from A1 to H90. Following this data there is a > >>>> "legend" explaining some of the data. The legend is contained in > >>>> columns A and B and runs through row 120. In both files the print range > >>>> is defined from A1 through H120. > >>>> > >>>> When I first printed file X it printed everything through row 120. > >>>> Subsequent prints of file X print only the data through H90. For file > >>>> Y I was not able to get it to print more than H90 even the first time. > >>>> Note that the print ranges are defined through H120 in both files. > >>>> There is only one print range defined, although it also has a > >>>> definition to repeat the first row on subsequent pages (as headers). > >>>> Print Preview reliably shows it is going to print only though H90. > >>>> > >>>> How can I get it to print the last 30 rows? Why is it ignoring the > >>>> print range as defined? > >>>> > >>> Forgot to add that this is OOo 2.4.1 on Hardy x86_64. > >>> > >>> Also I get the same results when printing to HP Laserjet 4+, 4M+ > >>> (PostScript version), 5Si, and 5SiMX (PostScript version); that is, > >>> four different drivers to two different printers. The PostScript > >>> versions are genuine Adobe. > > I should add that I also discovered that if I export to PDF the export > > function does export all cells containing data - that is A1 through > > H120. As a workaround I can then print the PDF file. > > > > I suspect it is something in the print ranges that is messed up. I read > > the Help files, but as far as I can tell I am doing it correctly. I > > also tried deleting all print ranges, which I understand should then > > make it print all cells that contain data. Still no go, it prints only > > A1 - H90. There's something about those last 30 rows that makes them > > not print, but I can't figure it out. > I suspect that it is printing, except that your paper and printer do not > extend wide enough. > Did you try inserting page breaks, say after G1 perhaps, and then see if > the next page > gets printed with H1 and subsequent? (focus on cell H1 then INSERT - > MANUAL BREAK - COLUMN BREAK) > > How does this effect your printer output? Makes no difference. H1 prints on another page, but the last 30 rows do not print. If I do Print Preview it reliably shows that the last 30 rows are not going to print. If I export to PDF it does export all 120 rows. And then I can print the entire document from any PDF viewer application. So that is the workaround I have been using. As for the printer not printing wide enough, the last 30 rows are narrower than the first 90 rows. The first 90 rows print fine. I was printing to an older Laserjet with Adobe PostScript and PCL drivers. I also have a newer Laserjet, and I got the same results, even when I specified tabloid size. I printed to a Xerox Phaser 7400 DN and specified tabloid (11 inches by 17 inches) and got the same results. Trust me, the problem is not the paper size. The problem is not in the printer driver. There is something in the last 30 rows that makes them not print. They won't print to any printer with any kind or size of paper. However, they are included when I export to PDF. I'm pretty sure it's a bug. Therefore, I am wasting everyone's time here. The version of OOo is 2.4.1 on Hardy x86_64. If it were OOo 3.0 I would file a bug report, but no one's going to bother fixing a bug in 2.4.1 at this point. -- --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
