{"id":4396,"date":"2013-09-22T05:02:19","date_gmt":"2013-09-21T19:02:19","guid":{"rendered":"http:\/\/www.rjmprogramming.com.au\/wordpress\/?p=4396"},"modified":"2013-09-22T05:02:19","modified_gmt":"2013-09-21T19:02:19","slug":"openoffice-csv-chart-primer-tutorial","status":"publish","type":"post","link":"https:\/\/www.rjmprogramming.com.au\/ITblog\/openoffice-csv-chart-primer-tutorial\/","title":{"rendered":"OpenOffice CSV Chart Primer Tutorial"},"content":{"rendered":"<div style=\"width: 230px\" class=\"wp-caption alignnone\"><a target=_blank href=\"http:\/\/www.rjmprogramming.com.au\/Mac\/OpenOffice\/\"><img decoding=\"async\" style=\"float:left; border: 15px solid pink;\" alt=\"OpenOffice CSV Chart Primer Tutorial\" src=\"http:\/\/www.rjmprogramming.com.au\/Mac\/OpenOffice\/OpenOffice_ImportCSV_Primer-35of.jpg\" title=\"OpenOffice CSV Chart Primer Tutorial\"  \/><\/a><p class=\"wp-caption-text\">OpenOffice CSV Chart Primer Tutorial<\/p><\/div>\n<p>Here is a tutorial that introduces you to a great suite of office automation programs called OpenOffice, by Apache Software Foundation.  OpenOffice has functionality like the Microsoft Office suite of programs, bringing the user a lot of the feel of those well loved concepts to your document creation work, and integrated into the one place.  Great, mates, huh?!<\/p>\n<blockquote><p>Apache OpenOffice (AOO) is an open-source office productivity software suite. It descends from OpenOffice.org and IBM Lotus Symphony.[5]<\/p>\n<p>Apache OpenOffice contains a word processor (Writer), a spreadsheet (Calc), a presentation application (Impress), a drawing application (Draw), a formula editor (Math), and a database management application (Base).[6]<\/p>\n<p>Apache OpenOffice&#8217;s default file format is the OpenDocument Format (ODF), an ISO\/IEC standard, which originated with OpenOffice.org. It can also read a wide variety of other file formats, with particular attention to those from Microsoft Office.<\/p>\n<p>Apache OpenOffice is developed for Linux, OS X and Windows, with ports to other operating systems. It is distributed under the Apache License.[4] The first release was version 3.4.0, on 8 May 2012.[1]<\/p><\/blockquote>\n<p>As you would imagine, such a project has many parts to it, and we will explore some over time, but, as always &#8230;<\/p>\n<ul>\n<li>Feel free to explore yourself<\/li>\n<li>Visit search engines with more specific queries about specific topics, always add &#8220;OpenOffice&#8221; in there somewhere, and arrive at specialized forums and\/or blogs and\/or official sites<\/li>\n<\/ul>\n<p><a target=_blank title='Enjoy the tutorial' href=\"http:\/\/www.rjmprogramming.com.au\/Mac\/OpenOffice\/\">Today<\/a>, we use some CSV data used previously at <a target=_blank title='PHP\/Javascript\/HTML Google Chart JSON Data Table Import of CSV Tutorial' href='http:\/\/www.rjmprogramming.com.au\/wordpress\/?p=3770'>PHP\/Javascript\/HTML Google Chart JSON Data Table Import of CSV Tutorial<\/a> to open a spreadsheet (like Microsoft Office Excel would do), and we will delimit, as required, and create a couple of charts (of interpretations of the data), which we will export to PDF and display on a local <a target=_blank title='PHP and MySql via MAMP Primer Tutorial' href='http:\/\/www.rjmprogramming.com.au\/wordpress\/?p=933'>MAMP<\/a> webserver (we are on a Mac laptop &#8230; we have shrunk to a bit of dust that you get near the bottom left of the keyboard&#8217;s &#8220;A&#8221; key (why so much there?) &#8230; <font size=\"1\">hello<\/font>).   Who could call this website <a target=_blank title='lame' href='http:\/\/lame.sourceforge.net\/'><strike>lame<\/strike><\/a> <a style=\"font-size:8px;\" target=_blank title='lame' href='http:\/\/oxforddictionaries.com\/definition\/english\/lame'><strike>lame<\/strike><\/a> <a style=\"font-size:6px;\" target=_blank title='lame' href='http:\/\/www.urbandictionary.com\/define.php?term=lame'>lame<\/a>?!!<\/p>\n<p>Link to input data file <a target=_blank href=\"http:\/\/www.rjmprogramming.com.au\/Mac\/OpenOffice\/intensity_chart.csv_GETME\" title='intensity_chart.csv'>intensity_chart.csv<\/a><br \/>\nLink to output PDF Pie Chart data file <a target=_blank href=\"http:\/\/www.rjmprogramming.com.au\/Mac\/OpenOffice\/intensity_chart_piechart.pdf\" title='intensity_chart_piechart.pdf'>intensity_chart_piechart.pdf<\/a><br \/>\nLink to output PDF Line Column chart data file <a target=_blank href=\"http:\/\/www.rjmprogramming.com.au\/Mac\/OpenOffice\/intensity_chart_linecolumn.pdf\" title='intensity_chart_linecolumn.pdf'>intensity_chart_linecolumn.pdf<\/a><br \/>\nLink to output spreadsheet saved as webpage <a target=_blank href=\"http:\/\/www.rjmprogramming.com.au\/Mac\/OpenOffice\/intensity_chart.html\" title='intensity_chart.html'>intensity_chart.html<\/a><\/p>\n<p>Link to OpenOffice information &#8230; <a target=_blank href='http:\/\/en.wikipedia.org\/wiki\/Apache_OpenOffice' title='OpenOffice information via Wikipedia'>from Wikipedia<\/a> as used by quote above.<br \/>\nLink to OpenOffice &#8220;spiritual home&#8221; &#8230; <a target=_blank href='http:\/\/www.openoffice.org\/' title='The Free and Open Productivity Suite'>via Apache Software Foundation<\/a>.\n<\/p>\n<p>If this was interesting you may be interested in <a title='Click here to see topics in which you might be interested' href='#d4396' onclick='var dv=document.getElementById(\"d4396\"); dv.innerHTML = \"&lt;iframe width=670 height=600 src=\" + \"http:\/\/www.rjmprogramming.com.au\/wordpress\/?s=Microsoft+Office#content\" + \"&gt;&lt;\/iframe&gt;\"; dv.style.display = \"block\";'>this<\/a> too.<\/p>\n<div id='d4396' style='display: none; border-left: 2px solid green; border-top: 2px solid green;'><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Here is a tutorial that introduces you to a great suite of office automation programs called OpenOffice, by Apache Software Foundation. OpenOffice has functionality like the Microsoft Office suite of programs, bringing the user a lot of the feel of &hellip; <a href=\"https:\/\/www.rjmprogramming.com.au\/ITblog\/openoffice-csv-chart-primer-tutorial\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,12,37],"tags":[199,283,292,698,881,913,944,1185,1319],"class_list":["post-4396","post","type-post","status-publish","format-standard","hentry","category-data-integration","category-elearning","category-tutorials","tag-chart","tag-csv","tag-data-integration-2","tag-line-and-column-chart","tag-openoffice","tag-pdf","tag-pie-chart","tag-spreadsheet","tag-tutorial"],"_links":{"self":[{"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/posts\/4396"}],"collection":[{"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/comments?post=4396"}],"version-history":[{"count":0,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/posts\/4396\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/media?parent=4396"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/categories?post=4396"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/tags?post=4396"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}