{"id":9237,"date":"2014-08-30T05:08:07","date_gmt":"2014-08-29T19:08:07","guid":{"rendered":"http:\/\/www.rjmprogramming.com.au\/wordpress\/?p=9237"},"modified":"2020-04-13T19:36:41","modified_gmt":"2020-04-13T09:36:41","slug":"libreoffice-spreadsheet-formulae-primer-tutorial","status":"publish","type":"post","link":"https:\/\/www.rjmprogramming.com.au\/ITblog\/libreoffice-spreadsheet-formulae-primer-tutorial\/","title":{"rendered":"LibreOffice Spreadsheet Formulae Primer Tutorial"},"content":{"rendered":"<div style=\"width: 230px\" class=\"wp-caption alignnone\"><a target=_blank href=\"http:\/\/www.rjmprogramming.com.au\/Mac\/LibreOffice\/Spreadsheet\/\"><img decoding=\"async\" style=\"float:left; border: 15px solid pink;\" alt=\"LibreOffice Spreadsheet Formulae Primer Tutorial\" src=\"http:\/\/www.rjmprogramming.com.au\/Mac\/LibreOffice\/Spreadsheet\/Libre_Spreadsheet_Primer.jpg\" title=\"LibreOffice Spreadsheet Formulae Primer Tutorial\"  \/><\/a><p class=\"wp-caption-text\">LibreOffice Spreadsheet Formulae Primer Tutorial<\/p><\/div>\n<p>Here is a tutorial that introduces you to the Spreadsheet functionality of a great suite of office automation programs called <a target=_blank title='LibreOffice' href='http:\/\/www.libreoffice.org'>LibreOffice<\/a>, by The Document Foundation.  LibreOffice has functionality like the <a target=_blank title='Microsoft Office' href='http:\/\/office.microsoft.com\/'>Microsoft Office<\/a> 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.  It is very similar to the <a target=_blank title='OpenOffice' href='http:\/\/www.OpenOffice.org'>OpenOffice<\/a> suite of programs, and the first thing you may want to do is visit <a target=_blank title='LibreOffice vs OpenOffice' href='http:\/\/www.howtogeek.com\/187663\/openoffice-vs.-libreoffice-whats-the-difference-and-which-should-you-use\/'>OpenOffice vs. LibreOffice: What&#8217;s the Difference and Which Should You Use?<\/a> to compare and contrast these two great products, and\/or visit relevant OpenOffice <a target=_blank title='OpenOffice blog posts at this blog' href='http:\/\/www.rjmprogramming.com.au\/wordpress\/?tag=OpenOffice'>tutorials<\/a> presented earlier at this blog.  It&#8217;s great to have the choice of 3 brilliant alternatives?!<\/p>\n<p>Today &#8230; as far as the Squash Court Monthly Booking ($25.00 per session) spreadsheet &#8230;<\/p>\n<ul>\n<li>We use a TextWrangler <a target=_blank href=\"http:\/\/www.rjmprogramming.com.au\/Mac\/LibreOffice\/Spreadsheet\/Libre_Spreadsheet_Primer-8of.jpg\">text file<\/a>  as the basis of the design &#8230; it doesn&#8217;t have to be complete nor neat, just helpful<\/li>\n<li>Establish the heading making use of Format-><a target=_blank href=\"http:\/\/www.rjmprogramming.com.au\/Mac\/LibreOffice\/Spreadsheet\/Libre_Spreadsheet_Primer-11of.jpg\">Merge Cells<\/a><\/li>\n<li>Place in all <a target=_blank href=\"http:\/\/www.rjmprogramming.com.au\/Mac\/LibreOffice\/Spreadsheet\/Libre_Spreadsheet_Primer-14of.jpg\">headings<\/a><\/li>\n<li>Immediately specify column <a target=_blank href=\"http:\/\/www.rjmprogramming.com.au\/Mac\/LibreOffice\/Spreadsheet\/Libre_Spreadsheet_Primer-15of.jpg\">formats<\/a> where they are not left-justified string columns (which is the default)<\/li>\n<li>Establish the <a target=_blank href=\"http:\/\/www.rjmprogramming.com.au\/Mac\/LibreOffice\/Spreadsheet\/Libre_Spreadsheet_Primer-24of.jpg\">formulae<\/a> of the planned formula fields  &#8230; LibreOffice has no =Minus(K3,L3) functionality, so use <a target=_blank href=\"http:\/\/www.rjmprogramming.com.au\/Mac\/LibreOffice\/Spreadsheet\/Libre_Spreadsheet_Primer-34of.jpg\">=(K3-L3)<\/a><\/li>\n<li>Start typing in the &#8220;body&#8221; <a target=_blank href=\"http:\/\/www.rjmprogramming.com.au\/Mac\/LibreOffice\/Spreadsheet\/Libre_Spreadsheet_Primer-36of.jpg\">data<\/a> to see how user friendly it is<\/li>\n<li>Realize that the Amount column could be worked out from the Week column data, knowing the price of a squash court booking is $25.00 &#8230; so establish <a target=_blank href=\"http:\/\/www.rjmprogramming.com.au\/Mac\/LibreOffice\/Spreadsheet\/Libre_Spreadsheet_Primer-51of.jpg\">formulae<\/a> (second and on are copied via the <a target=_blank href=\"http:\/\/www.rjmprogramming.com.au\/Mac\/LibreOffice\/Spreadsheet\/Libre_Spreadsheet_Primer-54of.jpg\" title='Check out equivalent of right-click functionality at bottom right of formula cell established previously to arrive at the bottom like what you see here'>bottom right cell functionality<\/a> of the first cell you apply the formula to) to make this more user-genial &#8230; Miss Congeniality &#8230; become sad &#8230; chortle, chortle &#8230; (miss, congeniality &#8230; guess, yet again, you had to be there &#8230; <a target=_blank title='WTBHAY?' href='http:\/\/www.trulydeeply.com.au\/madly\/2010\/06\/04\/where-the-bloody-hell-are-we-now\/'>WTBHAY?<\/a>)<\/li>\n<\/ul>\n<p><a target=_blank title='Enjoy the tutorial' href=\"http:\/\/www.rjmprogramming.com.au\/Mac\/LibreOffice\/Spreadsheet\/\">Today<\/a>, we take a quick tour of LibreOffice equivalent of Microsoft Excel spreadsheet application.<\/p>\n<p>Link to LibreOffice information &#8230; <a target=_blank href='http:\/\/en.wikipedia.org\/wiki\/LibreOffice' title='LibreOffice information via Wikipedia'>from Wikipedia<\/a>.<br \/>\nLink to LibreOffice &#8220;spiritual home&#8221; &#8230; <a target=_blank href='http:\/\/www.libreoffice.org\/' title='the free office suite the community has been dreaming of for twelve years.'>via The Document Foundation<\/a>.<\/p>\n<p>Have a look at the final spreadsheet you could call <a target=_blank title='SquashCourt2July2014.xlsx' href=\"http:\/\/www.rjmprogramming.com.au\/Mac\/LibreOffice\/Spreadsheet\/SquashCourt2July2014.xlsx\">SquashCourt2July2014.xlsx<\/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='#d9237' onclick='var dv=document.getElementById(\"d9237\"); 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='d9237' 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 the Spreadsheet functionality of a great suite of office automation programs called LibreOffice, by The Document Foundation. LibreOffice has functionality like the Microsoft Office suite of programs, bringing the user a lot &hellip; <a href=\"https:\/\/www.rjmprogramming.com.au\/ITblog\/libreoffice-spreadsheet-formulae-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":[12,37],"tags":[230,455,694,1075,1185,1319],"class_list":["post-9237","post","type-post","status-publish","format-standard","hentry","category-elearning","category-tutorials","tag-column","tag-formulae","tag-libreoffice","tag-row","tag-spreadsheet","tag-tutorial"],"_links":{"self":[{"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/posts\/9237"}],"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=9237"}],"version-history":[{"count":1,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/posts\/9237\/revisions"}],"predecessor-version":[{"id":48584,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/posts\/9237\/revisions\/48584"}],"wp:attachment":[{"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/media?parent=9237"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/categories?post=9237"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/tags?post=9237"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}