plebands.blogg.se

Simple openoffice spread sheet functions
Simple openoffice spread sheet functions













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.

simple openoffice spread sheet functions

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.

simple openoffice spread sheet functions

Then, in Excel, click the border of the selected cells (when your cursor changes to the hand icon) to move them.















Simple openoffice spread sheet functions