Exporting Calc charts or spreadsheets as images

From NeoWiki

(Difference between revisions)
Jump to: navigation, search
Revision as of 01:42, 10 December 2006 (edit)
Sardisson (Talk | contribs)
(initial version)
← Previous diff
Current revision (21:13, 18 October 2010) (edit) (undo)
Sardisson (Talk | contribs)
m (Exporting spreadsheets (or portions thereof) - remove stray leading space)
 
(4 intermediate revisions not shown.)
Line 1: Line 1:
Many users need to create a chart or spreadsheet in Calc and then export it in an image format for inclusion in documents created by other applications. Unfortunately there is no simple way to do this in NeoOffice, but there are a few work-arounds that produce useful results with relatively little pain. Many users need to create a chart or spreadsheet in Calc and then export it in an image format for inclusion in documents created by other applications. Unfortunately there is no simple way to do this in NeoOffice, but there are a few work-arounds that produce useful results with relatively little pain.
-===Exporting Charts and Graphs===+==Exporting charts and graphs==
To export a chart or graph as an image, follow these steps. To export a chart or graph as an image, follow these steps.
Line 11: Line 11:
# Save your file in the desired format # Save your file in the desired format
-===Exporting spreadsheets (or portions thereof)===+==Exporting spreadsheets (or portions thereof)==
Users often want to export a portion of their spreadsheet to an image for inclusion in other non-NeoOffice documents. Microsoft Excel has a "camera" function to facilitate this, but while NeoOffice does not have this function, it is still fairly easy to achieve similar results. Users often want to export a portion of their spreadsheet to an image for inclusion in other non-NeoOffice documents. Microsoft Excel has a "camera" function to facilitate this, but while NeoOffice does not have this function, it is still fairly easy to achieve similar results.
-====Using screenshots====+===Using screenshots===
The simplest way is to use Mac OS X's built-in screenshot function and select the desired portion of the spreadsheet. '''Cmd-Shift-4''' activates the screenshot-with-selection function; simply click and drag over the desired area and then release the mouse button. The simplest way is to use Mac OS X's built-in screenshot function and select the desired portion of the spreadsheet. '''Cmd-Shift-4''' activates the screenshot-with-selection function; simply click and drag over the desired area and then release the mouse button.
-====Using Grab====+===Using Grab===
Grab (located in <tt>/Applications/Utilities</tt>) performs much the same way as the the keyboard method of taking a screenshot, except you can choose additional options and select options from menus instead of memorizing shortcuts. Grab (located in <tt>/Applications/Utilities</tt>) performs much the same way as the the keyboard method of taking a screenshot, except you can choose additional options and select options from menus instead of memorizing shortcuts.
-====Printing to PDF====+===Printing to PDF===
Another option is to print your spreadsheet to PDF and then crop the PDF in Preview and export the result in the desired image format. Another option is to print your spreadsheet to PDF and then crop the PDF in Preview and export the result in the desired image format.
-====Using NeoOffice Draw====+===Using NeoOffice Draw===
One disadvantage of the screenshot and Grab methods is that they leave all the grid lines, etc., visible. A better method is to use NeoOffice Draw in a manner similar to exporting charts above. One disadvantage of the screenshot and Grab methods is that they leave all the grid lines, etc., visible. A better method is to use NeoOffice Draw in a manner similar to exporting charts above.
Line 35: Line 35:
''This method will also work for exporting a spreadsheet and its associated charts together, preserving the arrangement of the original spreadsheet.'' ''This method will also work for exporting a spreadsheet and its associated charts together, preserving the arrangement of the original spreadsheet.''
-<!-- {{botlangbarEN|[[fr:|Français]] [[de:|Deutsch]]}} -->+{{botlangbarEN|[[fr:Exporter_des_diagrammes_ou_des_tableaux_de_Calc_en_format_image|Français]] [[It:Esportare_diagrammi_e_tabelle_di_Calc_come_immagini|Italiano]] [[Es:C%c3%b3mo_exportar_diagramas_y_tablas_de_Calc_a_una_imagen|Español]]}}<!-- [[de:|Deutsch]]}} -->
[[Category:NeoOffice]][[Category:Tips and Hints]] [[Category:NeoOffice]][[Category:Tips and Hints]]

Current revision

Many users need to create a chart or spreadsheet in Calc and then export it in an image format for inclusion in documents created by other applications. Unfortunately there is no simple way to do this in NeoOffice, but there are a few work-arounds that produce useful results with relatively little pain.

Contents

Exporting charts and graphs

To export a chart or graph as an image, follow these steps.

  1. Select the chart in Calc and copy
  2. Open a new Draw document and paste
  3. Ensure the chart is still selected in your Draw document
  4. Choose Export… from the File menu
  5. Ensure that the "Selection" box is checked
  6. Save your file in the desired format

Exporting spreadsheets (or portions thereof)

Users often want to export a portion of their spreadsheet to an image for inclusion in other non-NeoOffice documents. Microsoft Excel has a "camera" function to facilitate this, but while NeoOffice does not have this function, it is still fairly easy to achieve similar results.

Using screenshots

The simplest way is to use Mac OS X's built-in screenshot function and select the desired portion of the spreadsheet. Cmd-Shift-4 activates the screenshot-with-selection function; simply click and drag over the desired area and then release the mouse button.

Using Grab

Grab (located in /Applications/Utilities) performs much the same way as the the keyboard method of taking a screenshot, except you can choose additional options and select options from menus instead of memorizing shortcuts.

Printing to PDF

Another option is to print your spreadsheet to PDF and then crop the PDF in Preview and export the result in the desired image format.

Using NeoOffice Draw

One disadvantage of the screenshot and Grab methods is that they leave all the grid lines, etc., visible. A better method is to use NeoOffice Draw in a manner similar to exporting charts above.

  1. Select the desired portion of the spreadsheet and copy
  2. Open a new Draw document and paste
  3. Ensure the new spreadsheet object is still selected in your Draw document
  4. Choose Export… from the File menu
  5. Ensure that the "Selection" box is checked
  6. Save your file in the desired format

This method will also work for exporting a spreadsheet and its associated charts together, preserving the arrangement of the original spreadsheet.


This article in other languages: Français Italiano
Personal tools