https://neowiki.neooffice.org/index.php?title=Exporting_Calc_charts_or_spreadsheets_as_images&limit=500&action=history&feed=atomExporting Calc charts or spreadsheets as images - Revision history2024-03-28T20:21:37ZRevision history for this page on the wikiMediaWiki 1.10.1https://neowiki.neooffice.org/index.php?title=Exporting_Calc_charts_or_spreadsheets_as_images&diff=16204&oldid=prevSardisson: /* Exporting spreadsheets (or portions thereof) */ remove stray leading space2010-10-18T21:13:13Z<p><span class="autocomment">Exporting spreadsheets (or portions thereof) -</span> remove stray leading space</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 21:13, 18 October 2010</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 35:</strong></td>
<td colspan="2" align="left"><strong>Line 35:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">''This method will also work for exporting a spreadsheet and its associated charts together, preserving the arrangement of the original spreadsheet.''</td><td> </td><td style="background: #eee; font-size: smaller;">''This method will also work for exporting a spreadsheet and its associated charts together, preserving the arrangement of the original spreadsheet.''</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;"> </del>{{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]]}} --></td><td>+</td><td style="background: #cfc; font-size: smaller;">{{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]]}} --></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">[[Category:NeoOffice]][[Category:Tips and Hints]]</td><td> </td><td style="background: #eee; font-size: smaller;">[[Category:NeoOffice]][[Category:Tips and Hints]]</td></tr>
</table>Sardissonhttps://neowiki.neooffice.org/index.php?title=Exporting_Calc_charts_or_spreadsheets_as_images&diff=9788&oldid=prevValterb: botlangbar -> IT2007-03-21T21:17:55Z<p>botlangbar -> IT</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 21:17, 21 March 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 35:</strong></td>
<td colspan="2" align="left"><strong>Line 35:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">''This method will also work for exporting a spreadsheet and its associated charts together, preserving the arrangement of the original spreadsheet.''</td><td> </td><td style="background: #eee; font-size: smaller;">''This method will also work for exporting a spreadsheet and its associated charts together, preserving the arrangement of the original spreadsheet.''</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"> {{botlangbarEN|[[fr:Exporter_des_diagrammes_ou_des_tableaux_de_Calc_en_format_image|Français]] [[Es:C%c3%b3mo_exportar_diagramas_y_tablas_de_Calc_a_una_imagen|Español]]}}<!-- [[de:|Deutsch]]}} --></td><td>+</td><td style="background: #cfc; font-size: smaller;"> {{botlangbarEN|[[fr:Exporter_des_diagrammes_ou_des_tableaux_de_Calc_en_format_image|Français<ins style="color: red; font-weight: bold; text-decoration: none;">]] [[It:Esportare_diagrammi_e_tabelle_di_Calc_come_immagini|Italiano</ins>]] [[Es:C%c3%b3mo_exportar_diagramas_y_tablas_de_Calc_a_una_imagen|Español]]}}<!-- [[de:|Deutsch]]}} --></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">[[Category:NeoOffice]][[Category:Tips and Hints]]</td><td> </td><td style="background: #eee; font-size: smaller;">[[Category:NeoOffice]][[Category:Tips and Hints]]</td></tr>
</table>Valterbhttps://neowiki.neooffice.org/index.php?title=Exporting_Calc_charts_or_spreadsheets_as_images&diff=9782&oldid=prevRoyFocker: /* Using NeoOffice Draw */ link to spanish version2007-03-21T14:09:50Z<p><span class="autocomment">Using NeoOffice Draw -</span> link to spanish version</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 14:09, 21 March 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 35:</strong></td>
<td colspan="2" align="left"><strong>Line 35:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">''This method will also work for exporting a spreadsheet and its associated charts together, preserving the arrangement of the original spreadsheet.''</td><td> </td><td style="background: #eee; font-size: smaller;">''This method will also work for exporting a spreadsheet and its associated charts together, preserving the arrangement of the original spreadsheet.''</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"> {{botlangbarEN|[[fr:Exporter_des_diagrammes_ou_des_tableaux_de_Calc_en_format_image|Français]]}}<!-- [[de:|Deutsch]]}} --></td><td>+</td><td style="background: #cfc; font-size: smaller;"> {{botlangbarEN|[[fr:Exporter_des_diagrammes_ou_des_tableaux_de_Calc_en_format_image|Français<ins style="color: red; font-weight: bold; text-decoration: none;">]] [[Es:C%c3%b3mo_exportar_diagramas_y_tablas_de_Calc_a_una_imagen|Español</ins>]]}}<!-- [[de:|Deutsch]]}} --></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">[[Category:NeoOffice]][[Category:Tips and Hints]]</td><td> </td><td style="background: #eee; font-size: smaller;">[[Category:NeoOffice]][[Category:Tips and Hints]]</td></tr>
</table>RoyFockerhttps://neowiki.neooffice.org/index.php?title=Exporting_Calc_charts_or_spreadsheets_as_images&diff=7442&oldid=prevJgd: botlangbar -> FR2006-12-10T15:42:50Z<p>botlangbar -> FR</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 15:42, 10 December 2006</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 35:</strong></td>
<td colspan="2" align="left"><strong>Line 35:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">''This method will also work for exporting a spreadsheet and its associated charts together, preserving the arrangement of the original spreadsheet.''</td><td> </td><td style="background: #eee; font-size: smaller;">''This method will also work for exporting a spreadsheet and its associated charts together, preserving the arrangement of the original spreadsheet.''</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;"><!-- </del>{{botlangbarEN|[[fr:|Français]] [[de:|Deutsch]]}} --></td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;"> </ins>{{botlangbarEN|[[fr:<ins style="color: red; font-weight: bold; text-decoration: none;">Exporter_des_diagrammes_ou_des_tableaux_de_Calc_en_format_image</ins>|Français]]<ins style="color: red; font-weight: bold; text-decoration: none;">}}<!-- </ins>[[de:|Deutsch]]}} --></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">[[Category:NeoOffice]][[Category:Tips and Hints]]</td><td> </td><td style="background: #eee; font-size: smaller;">[[Category:NeoOffice]][[Category:Tips and Hints]]</td></tr>
</table>Jgdhttps://neowiki.neooffice.org/index.php?title=Exporting_Calc_charts_or_spreadsheets_as_images&diff=7421&oldid=prevSardisson: change header levels2006-12-10T01:44:09Z<p>change header levels</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 01:44, 10 December 2006</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 1:</strong></td>
<td colspan="2" align="left"><strong>Line 1:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">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.</td><td> </td><td style="background: #eee; font-size: smaller;">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.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">=</del>==Exporting <del style="color: red; font-weight: bold; text-decoration: none;">Charts </del>and <del style="color: red; font-weight: bold; text-decoration: none;">Graphs=</del>==</td><td>+</td><td style="background: #cfc; font-size: smaller;">==Exporting <ins style="color: red; font-weight: bold; text-decoration: none;">charts </ins>and <ins style="color: red; font-weight: bold; text-decoration: none;">graphs</ins>==</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">To export a chart or graph as an image, follow these steps.</td><td> </td><td style="background: #eee; font-size: smaller;">To export a chart or graph as an image, follow these steps.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td colspan="2" align="left"><strong>Line 11:</strong></td>
<td colspan="2" align="left"><strong>Line 11:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"># Save your file in the desired format</td><td> </td><td style="background: #eee; font-size: smaller;"># Save your file in the desired format</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">=</del>==Exporting spreadsheets (or portions thereof)<del style="color: red; font-weight: bold; text-decoration: none;">=</del>==</td><td>+</td><td style="background: #cfc; font-size: smaller;">==Exporting spreadsheets (or portions thereof)==</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">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.</td><td> </td><td style="background: #eee; font-size: smaller;">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.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">=</del>===Using screenshots<del style="color: red; font-weight: bold; text-decoration: none;">=</del>===</td><td>+</td><td style="background: #cfc; font-size: smaller;">===Using screenshots===</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">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.</td><td> </td><td style="background: #eee; font-size: smaller;">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.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">=</del>===Using Grab<del style="color: red; font-weight: bold; text-decoration: none;">=</del>===</td><td>+</td><td style="background: #cfc; font-size: smaller;">===Using Grab===</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">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.</td><td> </td><td style="background: #eee; font-size: smaller;">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.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">=</del>===Printing to PDF<del style="color: red; font-weight: bold; text-decoration: none;">=</del>===</td><td>+</td><td style="background: #cfc; font-size: smaller;">===Printing to PDF===</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">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.</td><td> </td><td style="background: #eee; font-size: smaller;">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.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">=</del>===Using NeoOffice Draw<del style="color: red; font-weight: bold; text-decoration: none;">=</del>===</td><td>+</td><td style="background: #cfc; font-size: smaller;">===Using NeoOffice Draw===</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">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.</td><td> </td><td style="background: #eee; font-size: smaller;">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.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
</table>Sardissonhttps://neowiki.neooffice.org/index.php?title=Exporting_Calc_charts_or_spreadsheets_as_images&diff=7420&oldid=prevSardisson: initial version2006-12-10T01:42:56Z<p>initial version</p>
<p><b>New page</b></p><div>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.<br />
<br />
===Exporting Charts and Graphs===<br />
To export a chart or graph as an image, follow these steps.<br />
<br />
# Select the chart in Calc and copy<br />
# Open a new Draw document and paste<br />
# Ensure the chart is still selected in your Draw document<br />
# Choose '''Export…''' from the '''File''' menu<br />
# Ensure that the "Selection" box is checked<br />
# Save your file in the desired format<br />
<br />
===Exporting spreadsheets (or portions thereof)===<br />
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.<br />
<br />
====Using screenshots====<br />
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.<br />
<br />
====Using Grab====<br />
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.<br />
<br />
====Printing to PDF====<br />
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.<br />
<br />
====Using NeoOffice Draw====<br />
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.<br />
<br />
# Select the desired portion of the spreadsheet and copy<br />
# Open a new Draw document and paste<br />
# Ensure the new spreadsheet object is still selected in your Draw document<br />
# Choose '''Export…''' from the '''File''' menu<br />
# Ensure that the "Selection" box is checked<br />
# Save your file in the desired format<br />
<br />
''This method will also work for exporting a spreadsheet and its associated charts together, preserving the arrangement of the original spreadsheet.''<br />
<br />
<!-- {{botlangbarEN|[[fr:|Français]] [[de:|Deutsch]]}} --><br />
[[Category:NeoOffice]][[Category:Tips and Hints]]</div>Sardisson