Spreadsheet Prints Chart on Multiple Pages

[Stephen Rasku]

Binary package hint: openoffice.org

1) lsb_release -rd
Description: Ubuntu 11.10
Release: 11.10

2) apt-cache policy libreoffice-calc
libreoffice-calc:
  Installed: 1:3.4.4-0ubuntu1
  Candidate: 1:3.4.4-0ubuntu1
  Version table:
 *** 1:3.4.4-0ubuntu1 0
        500 http://us.archive.ubuntu.com/ubuntu/ oneiric-updates/main i386 Packages
        100 /var/lib/dpkg/status
     1:3.4.3-3ubuntu2 0
        500 http://us.archive.ubuntu.com/ubuntu/ oneiric/main i386 Packages

3) What is expected to happen in LibreOffice Calc via the Terminal:

cd ~/Desktop && wget -c https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/669248/+attachment/1718719/+files/Printing%20Bug.ods -O example.ods && localc -nologo example.ods

is when one attempts to print via File -> Print the entire file is printed in one page as in the Excel screenshot https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/669248/+attachment/2635295/+files/excel.png .

4) What happens instead is the chart is printed across multiple pages.

WORKAROUND: File -> Print Preview -> Format Page -> change drop down Scaling mode to Fit print range(s) on number of pages -> combo box Number of pages 1 -> OK button -> File -> Print

ProblemType: Bug
DistroRelease: Ubuntu 10.04
Package: openoffice.org-core 1:3.2.0-7ubuntu4.1
ProcVersionSignature: Ubuntu 2.6.32-25.45-generic 2.6.32.21+drm33.7
Uname: Linux 2.6.32-25-generic x86_64
NonfreeKernelModules: nvidia
Architecture: amd64
Date: Sun Oct 31 15:14:01 2010
ExecutablePath: /usr/lib/openoffice/program/soffice.bin
InstallationMedia: Ubuntu 9.10 "Karmic Koala" - Release amd64 (20091027)
ProcEnviron:
 PATH=(custom, user)
 LANG=en_CA.utf8
 SHELL=/bin/bash
SourcePackage: openoffice.org

[Dave Gilbert (ubuntu-treblig)]

Confirmed on Natty - I've had this bug before and it's quite annoying.

I think I can persuade it to work but it should do it by default.

Try the following; select File->Page Preview and then the 'Format page' button then
go to the 'Sheet' tab on the Page style dialog that appears. At the bottom of that is a
'Scaling mode', select 'Fit print range(s) on number of pages and select 1 and that
chart looks OK in the preview at that point.

It shouldn't need that amount of effort for a simple sheet like that.

[penalvch (penalvch)]

Stephen Rasku, it was noticed in the attachment:
 https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/669248/+attachment/1718719/+files/Printing%20Bug.ods

that halfway down the chart the cells in each row are have a border color that is slightly different then the rows above (very obvious switching to nightmode with Compiz or using xcalib -i -a ). As well, selecting these cells and changing to Default Format does not change the cell border. The cell border color position is correlated with this printing problem. Could you please explain how the formatting of the cells?

[Stephen Rasku (ubuntu-srasku)]

I didn't do anything deliberate to change the border colours. I just tried to recreate the problem by generating the file from scratch and I wasn't able to. Dave Gilbert's solution will repair the file so that it will print (or at least preview) properly. It doesn't get rid of the different coloured grid lines, though.

[Björn Michaelsen (bjoern-michaelsen)]

[This is an automated message.]
There are no new official OpenOffice.org releases in Ubuntu packaging anymore => Won't Fix

If the problem persists, please mark this bug as "also affects project Libreoffice" or "also affects distribution Libreoffice (Ubuntu)" if that has not happened already.

Please leave references to upstream OpenOffice.org bugs in place to allow cross pollination.

[penalvch (penalvch)]

Stephen Rasku, the issue you are reporting is an upstream one and it would be nice if somebody having it could send the bug to the developers of the software by following the instructions at http://wiki.documentfoundation.org/BugReport . If you have done so, please tell us the number of the upstream bug (or the link), so we can add a bugwatch that will inform us about its status. Thanks in advance.

[Marcus Tomlinson (marcustomlinson)]

This release of Ubuntu is no longer receiving maintenance updates. If this is still an issue on a maintained version of Ubuntu please let us know.

[Launchpad Janitor (janitor)]

[Expired for libreoffice (Ubuntu) because there has been no activity for 60 days.]

[penalvch (penalvch)]

Stephen Rasku, this is still reproducible, and has a WORKAROUND in:
Version: 6.3.2.2 (x64)
Build ID: 98b30e735bda24bc04ab42594c85f7fd8be07b9c

If this still affects you, please perform the steps requested in https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/669248/comments/8 .