[upstream] Can't print chart independently of spreadsheet

Help -> Charts in OpenOffice.org

"To print a chart in high quality, you can export the chart to a PDF file and print that file."

So do "Select the chart -> Export as PDF -> Range -> Selection" and it works.

--

There is also an upstream bug to make this easier.

I've had another go at printing a chart. The worksheet concerned is "2010".
The chart I want to print is embedded in a worksheet that has 365+ lines
(goto line 210). I only want to print the chart, so I click on it (to
highlight it). When I go to format page/sheet/ and untick everything except
charts - the print preview shows text. Not a chart, on a single page.

However I have found today that if I highlight the chart, then paste it into
a new sheet, the chart appears on the new sheet and will print. However
formating the page still resulted in some strange responses - like text ,
not the chart, being previewed. The disadvantage of this method is that the
chart will not be updated when the new data is entered in the spreadsheet.

It would be best if the chart would print from the original sheet - but the
software does not seem to recognise the fact that I have highlighted the
chart (ie: After I click on the chart, there appears a square in each corner
and an anchor top left.

I've attached the file that is misbehaving, it might help!

Thanks for your efforts.

Ubuntu rules!

Tim.

On Fri, May 21, 2010 at 4:01 PM, Bug Watch Updater <
<email address hidden>> wrote:

> ** Changed in: openoffice
> Status: Unknown => Confirmed
>
> --
> [upstream] Can't print chart independently of spreadsheet
> https://bugs.launchpad.net/bugs/581647
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in The OpenOffice.org Suite: Confirmed
> Status in “openoffice.org” package in Ubuntu: Triaged
>
> Bug description:
> Binary package hint: openoffice.org
>
> Ubuntu 9.10 updated in 16 May 2010
>
> Having selected the chart in the spreadsheet, I expected to be able to
> print it. NO. I mucked around for half an hour trying to find how to print
> the chart. I even tried copying and pasting to a word processing document.
> Nope, didn't work either.
>
> Went to Help to find out how to print chart. Nothing there. Searched on
> chart print, print chart. paste chart. Then ran out of ideas.
>
> I don't want to print the whole spreadsheet. Just the chart.
>
> Thanks,
>
> TIm.
>
> ProblemType: Bug
> Architecture: i386
> Date: Mon May 17 19:53:58 2010
> DistroRelease: Ubuntu 9.10
> InstallationMedia: Ubuntu 9.10 "Karmic Koala" - Release i386 (20091028.5)
> Package: openoffice.org-core 1:3.1.1-5ubuntu1.1
> ProcEnviron:
> PATH=(custom, no user)
> LANG=en_AU.UTF-8
> SHELL=/bin/bash
> ProcVersionSignature: Ubuntu 2.6.31-21.59-generic-pae
> SourcePackage: openoffice.org
> Uname: Linux 2.6.31-21-generic-pae i686
> XsessionErrors:
> (gnome-settings-daemon:1464): GLib-CRITICAL **: g_propagate_error:
> assertion `src != NULL' failed
> (gnome-settings-daemon:1464): GLib-CRITICAL **: g_propagate_error:
> assertion `src != NULL' failed
> (polkit-gnome-authentication-agent-1:1501): GLib-CRITICAL **:
> g_once_init_leave: assertion `initialization_value != 0' failed
> (nautilus:1496): Eel-CRITICAL **: eel_preferences_get_boolean: assertion
> `preferences_is_initialized ()' failed
> (firefox:1593): GLib-WARNING **: g_set_prgname() called multiple times
>
> To unsubscribe from this bug, go to:
> https://bugs.launchpad.net/openoffi...

Tim Moreland, this issue is unreproducible in LibreOffice Calc via the Terminal:

cd ~/Desktop && wget -c https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/581647/+attachment/1462405/+files/3%20Rainfall%202010.xls -O inf.xls

Click the graph -> Format -> Page... -> Page tab -> change Orientation radio button to Landscape -> OK -> File -> Print -> General tab -> under Range and copies click radio button Selected cells -> Properties button -> change drop down Orientation to Landscape -> OK button and notice the print preview contains the entire graph on one page. Does this work for you? If using Lucid or Maverick feel free to perform at the Terminal:

sudo add-apt-repository ppa:libreoffice/ppa && sudo apt-get update && sudo apt-get -y upgrade && sudo apt-get -y install libreoffice-calc

Ok It works for me! But I would not have guessed that a chart is the
equivalent of a cell (!). Maybe the Print General Tab should say "selected
cells or chart".

Thanks for your response,

Ubuntu Rules.

Tim.

On 18 August 2011 09:09, Christopher M. Penalver <
<email address hidden>> wrote:

> Tim Moreland, this issue is unreproducible in LibreOffice Calc via the
> Terminal:
>
> cd ~/Desktop && wget -c
>
> https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/581647/+attachment/1462405/+files/3%20Rainfall%202010.xls
> -O<https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/581647/+attachment/1462405/+files/3%20Rainfall%202010.xls%0A-O>inf.xls
>
> Click the graph -> Format -> Page... -> Page tab -> change Orientation
> radio button to Landscape -> OK -> File -> Print -> General tab -> under
> Range and copies click radio button Selected cells -> Properties button
> -> change drop down Orientation to Landscape -> OK button and notice the
> print preview contains the entire graph on one page. Does this work for
> you? If using Lucid or Maverick feel free to perform at the Terminal:
>
> sudo add-apt-repository ppa:libreoffice/ppa && sudo apt-get update &&
> sudo apt-get -y upgrade && sudo apt-get -y install libreoffice-calc
>
> ** Also affects: libreoffice (Ubuntu)
> Importance: Undecided
> Status: New
>
> ** Changed in: libreoffice (Ubuntu)
> Status: New => Incomplete
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/581647
>
> Title:
> [upstream] Can't print chart independently of spreadsheet
>
> Status in The OpenOffice.org Suite:
> Confirmed
> Status in “libreoffice” package in Ubuntu:
> Incomplete
> Status in “openoffice.org” package in Ubuntu:
> Triaged
>
> Bug description:
> Binary package hint: openoffice.org
>
> Ubuntu 9.10 updated in 16 May 2010
>
> Having selected the chart in the spreadsheet, I expected to be able to
> print it. NO. I mucked around for half an hour trying to find how to
> print the chart. I even tried copying and pasting to a word processing
> document. Nope, didn't work either.
>
> Went to Help to find out how to print chart. Nothing there. Searched
> on chart print, print chart. paste chart. Then ran out of ideas.
>
> I don't want to print the whole spreadsheet. Just the chart.
>
> Thanks,
>
> TIm.
>
> ProblemType: Bug
> Architecture: i386
> Date: Mon May 17 19:53:58 2010
> DistroRelease: Ubuntu 9.10
> InstallationMedia: Ubuntu 9.10 "Karmic Koala" - Release i386 (20091028.5)
> Package: openoffice.org-core 1:3.1.1-5ubuntu1.1
> ProcEnviron:
> PATH=(custom, no user)
> LANG=en_AU.UTF-8
> SHELL=/bin/bash
> ProcVersionSignature: Ubuntu 2.6.31-21.59-generic-pae
> SourcePackage: openoffice.org
> Uname: Linux 2.6.31-21-generic-pae i686
> XsessionErrors:
> (gnome-settings-daemon:1464): GLib-CRITICAL **: g_propagate_error:
> assertion `src != NULL' failed
> (gnome-settings-daemon:1464): GLib-CRITICAL **: g_propagate_error:
> assertion `src != NULL' failed
> (polkit-gnome-authentication-agent-1:1501): GLib-CRITICAL **:
> g_once_init_leave: assertion `initialization_value != 0' fa...

Tim Morland, the bug task for LibreOffice is being closed due to your last comment. For future reference you can manage the status of your own bugs by clicking on the current status in the yellow line and then choosing a new status in the revealed drop down box. You can learn more about bug statuses at https://wiki.ubuntu.com/Bugs/Status. Thank you again for taking the time to report this bug and helping to make Ubuntu better. Please submit any future bugs you may find.

[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.