Language Selection

English French German Italian Portuguese Spanish

Office shootout: Calc vs. Microsoft Excel

Filed under

I spent a couple of days testing OOo Calc and Microsoft Excel features for formatting, list-making, formulas, and formula tools. Since the range of user expertise in spreadsheets tends to be much wider than in slide shows or even word processors, I considered the programs largely from the perspective of an average user who might require a spreadsheet for home or business use.

Cell, sheet, and page formatting

Calc's and Excel's options for formatting cells are so similar that their tabs are in the same order. The main difference in options is in number formatting, where Excel offers a Special category for phone numbers, social insurance numbers, and zip codes, and Calc offers Boolean values, as well as settings for decimal places, leading zeroes, coloring negative numbers red, and the thousands separator -- values that Excel tucks away under the Excel button in the ribbon. Calc also has an option not only for text wrap within cells, but also for hyphenation, which may be useful to those who use spreadsheets primarily for making lists. Otherwise, the cell formatting options are virtually identical for format, font, border, background, and protection, differing mainly in names.

More Here

More in Tux Machines

Netrunner Rolling 2015.09 Released With New Plasma 5 And Apps Updates

Netrunner Rolling 2015.09 Released With New Plasma 5 And Apps Updates

Netrunner is  a Linux distribution that comes into two versions - Main version and Rolling release. Main version is based on Kubuntu and the Rollingrelease is based on Manjaro Linux. The new Netrunner  2015.09 has been released with a completely different look - KDE4 has been transformed to Plasma 5.2 desktop. Let's look at the complete changes in the Netrunner 2015.09 release.

GnuCash 2.6.9 Free Accounting Software Patches Serious Bug on Windows OSes

The GnuCash Project has announced the immediate availability for download of the ninth point release for all supported operating systems, including GNU/Linux, Mac OS X, and Microsoft Windows. Read more

Clonezilla Live 2.4.2-59 Arrives with Updated Debian Base

Clonezilla Live, a Linux distribution based on DRBL, Partclone, and udpcast, which allows users to do a lot of maintenance and recovery work, is now at version 2.4.2-59 and is available for download and testing. Read more