Language Selection

English French German Italian Portuguese Spanish

Office shootout: OpenOffice.org Calc vs. Microsoft Excel

Filed under
OOo

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

LibreOffice 4.4.4 Released

The Document Foundation today announced LibreOffice 4.4.4, the latest update to the 4.4 branch. Today's release brings 74 bug fixes including several crashes and import/export bugs. The announcement today also brought news of version 5.0 as well as reminders for the LibreOffice Conference in September. Read more

Watch: Mark Shuttleworth Talks About Telco and NFV Technologies

The Movilforum website had the great pleasure of interviewing Mark Shuttleworth, CEO of Canonical and founder of the world's most popular free operating system, Ubuntu Linux. Read more

Linux Kernel 4.0.7 Is a Small Release with Updated Drivers, ARM Improvements

On the last days of June, Greg Kroah-Hartman announced the availability of several maintenance releases for the Linux kernels 4.1, 4.0, 3.14, and 3.10. The seventh point release of Linux kernel 4.0 is a small one that brings mostly updated drivers. Read more

An Everyday Linux User Review Of Debian Jessie

I have now been using Debian for a few weeks and it is therefore time for me to write a review of my experience thus far. Debian has been around for what seems like forever now and it is the base for so many other Linux distributions such as Ubuntu, Mint, SolydXK and Knoppix. I think that the general consensus amongst Linux users is that Debian is stable, dependable and a good environment on which to build upon. Does that mean it is suitable for Everyone? Read more