{"id":95845,"date":"2017-12-15T09:30:05","date_gmt":"2017-12-15T09:30:05","guid":{"rendered":"http:\/\/sftarticles.wpenginepowered.com\/en\/?p=95845"},"modified":"2025-07-01T23:42:50","modified_gmt":"2025-07-02T06:42:50","slug":"5-key-differences-between-excel-and-openoffice-calc","status":"publish","type":"post","link":"https:\/\/cms-articles.softonic.io\/en\/5-key-differences-between-excel-and-openoffice-calc\/","title":{"rendered":"5 key differences between Excel and OpenOffice Calc"},"content":{"rendered":"

As a free alternative to Microsoft\u2019s popular Excel, OpenOffice<\/a> Calc is a tough one to beat. But while the two spreadsheet tools share many qualities, they\u2019re not totally alike. So before deciding to splash out on Microsoft\u2019s version, or to save your pennies with Calc, have a read through these 5 key differences to pick the right one for you.<\/span><\/p>\n

1. Drag and drop is easier with Calc<\/b><\/h3>\n

If you want to move cells to another column or area of your spreadsheet, first click and drag your cursor over the cells you want to move. This step is the same for both Excel and Calc. <\/span><\/p>\n

Then, in Excel, click the border of the selected cells (when your cursor changes to the hand icon) to move them. If you click within your selected cells, you\u2019ll deselect the group and select that single cell. But in Calc, you simply move your cursor anywhere <\/span>within<\/span><\/i> the selected cells.<\/span><\/p>\n

This might not sound like a big difference, but if you\u2019re moving cells frequently, it\u2019s a real time saver. If you miss that narrow border in Excel, you have to re-select your cells and try again. Not exactly hard work, but it could be tedious if you\u2019re in a rush.<\/span><\/p>\n

\"\"
In Excel, you can only move your selection by clicking its border when you see the hand cursor.<\/figcaption><\/figure>\n
\"\"
In Calc, one you\u2019ve highlighted your selection, you can click anywhere inside to move it to another part of your spreadsheet. <\/span><\/i><\/figcaption><\/figure>\n

2. In Calc, you must always use semicolons to separate parameters in a function<\/b><\/h3>\n

When writing formulae in Calc, you have to separate parameters using semicolons. In Excel, you can use both semicolons and commas. Not a big issue, just something you might have to get used to if you\u2019re moving from Excel to Calc.<\/span><\/p>\n

\"\"
With Calc (on the left), you must always use semicolons to separate parameters (unlike Excel on the right, where you can use commas)<\/figcaption><\/figure>\n

3. Calc uses a different macro programming language to Excel<\/b><\/h3>\n

Excel uses Microsoft\u2019s Visual Basic for Applications (VBA) programming language. Calc uses its own OpenOffice BASIC language. As both languages are part of the BASIC family, you shouldn\u2019t have too much trouble familiarising yourself with one if you\u2019re used to working with the other. <\/span><\/p>\n

However, there are some differences. Rather than listing them here, I suggest reading <\/span>Apache\u2019s BASIC guide<\/span><\/a>, which points out where VBA and OpenOffice BASIC differ. (Calc also lets you program your macros in Python, BeanShell, or JavaScript.)<\/span><\/p>\n

\"\"<\/p>\n

4. Excel has more charting options than Calc<\/b><\/h3>\n

Calc has enough charts to display your data in a meaningful way, but if you\u2019re after additional flourishes, your best bet is Excel. For example, Calc can\u2019t create fill gradients, and has fewer chart types. It won\u2019t recommend charts for your specific data, either (which Excel does).<\/span><\/p>\n

\"\"
Calc won\u2019t be as pretty, but it usually gets the job done<\/figcaption><\/figure>\n

5. If you hit the delete key in Calc, you get to choose what to delete<\/b><\/h3>\n

New Calc users expecting to remove cell contents with a single stab of the \u201cdelete\u201d key are in for a surprise. Calc has incorporated a handy (or not, depending on your point of view) dialogue box that lets you choose what you want to delete \u2013 whether it\u2019s text, numbers, dates, or formulae. Excel, on the other hand, just erases the content. If you want to skip this dialogue, hit the backspace key instead.<\/span><\/p>\n

\"\"<\/p>\n

As expected, Calc and Excel are fairly evenly-matched \u2013 especially when it comes to basic functions. What small differences exist are easily overcome or tolerated, and as Calc is free, there\u2019s not much to cry over. But if you\u2019re keen on fancy graphs and extreme flexibility, Excel comes out on top. I\u2019ll let you decide if they\u2019re worth paying for. <\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

As a free alternative to Microsoft\u2019s popular Excel, OpenOffice Calc is a tough one to beat. But while the two spreadsheet tools share many qualities, they\u2019re not totally alike. So before deciding to splash out on Microsoft\u2019s version, or to save your pennies with Calc, have a read through these 5 key differences to pick … Continue reading “5 key differences between Excel and OpenOffice Calc”<\/span><\/a><\/p>\n","protected":false},"author":2040,"featured_media":95853,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","wpcf-pageviews":6},"categories":[2441],"tags":[2648],"usertag":[],"vertical":[],"content-category":[],"class_list":["post-95845","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-how-to","tag-app-subdomain-redirectionopenoffice"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/posts\/95845","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/users\/2040"}],"replies":[{"embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/comments?post=95845"}],"version-history":[{"count":1,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/posts\/95845\/revisions"}],"predecessor-version":[{"id":328400,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/posts\/95845\/revisions\/328400"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/media\/95853"}],"wp:attachment":[{"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/media?parent=95845"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/categories?post=95845"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/tags?post=95845"},{"taxonomy":"usertag","embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/usertag?post=95845"},{"taxonomy":"vertical","embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/vertical?post=95845"},{"taxonomy":"content-category","embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/content-category?post=95845"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}