For example, Calc can’t create fill gradients, and has fewer chart types. Excel has more charting options than CalcĬalc has enough charts to display your data in a meaningful way, but if you’re after additional flourishes, your best bet is Excel. (Calc also lets you program your macros in Python, BeanShell, or JavaScript.)Ĥ. Rather than listing them here, I suggest reading Apache’s BASIC guide, which points out where VBA and OpenOffice BASIC differ. As both languages are part of the BASIC family, you shouldn’t have too much trouble familiarising yourself with one if you’re used to working with the other. Calc uses its own OpenOffice BASIC language. Calc uses a different macro programming language to ExcelĮxcel uses Microsoft’s Visual Basic for Applications (VBA) programming language. With Calc (on the left), you must always use semicolons to separate parameters (unlike Excel on the right, where you can use commas) 3. Not a big issue, just something you might have to get used to if you’re moving from Excel to Calc. In Excel, you can use both semicolons and commas. When writing formulae in Calc, you have to separate parameters using semicolons. In Calc, you must always use semicolons to separate parameters in a function

In Calc, one you’ve highlighted your selection, you can click anywhere inside to move it to another part of your spreadsheet.

In Excel, you can only move your selection by clicking its border when you see the hand cursor. Not exactly hard work, but it could be tedious if you’re in a rush. If you miss that narrow border in Excel, you have to re-select your cells and try again. This might not sound like a big difference, but if you’re moving cells frequently, it’s a real time saver. But in Calc, you simply move your cursor anywhere within the selected cells. If you click within your selected cells, you’ll deselect the group and select that single cell. Then, in Excel, click the border of the selected cells (when your cursor changes to the hand icon) to move them.

Evernote extension+firefox