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

Android Leftovers

Availability of Qt Free Edition

In my last blog posts, I explained the KDE Free Qt Foundation, which guarantees the free availability of the Qt Toolkit. Today, The Qt Company introduced a new Qt online installer that requires users to accept additional license terms. Many people have contacted me with concerns about this change. I share this concern. Even before this, I have already been concerned about the structure of the qt.io download page, since it blurs the lines between the Qt Toolkit itself and additional, proprietary products. Read more

Valve's Mods Blunder Prompts Reddit Community to Create Open Source Steam Replacement

Valve has recently gone through a major PR debacle after the company announced that it's implementing paid mods for games and Skyrim in particular. Their decision was short-lived, and it was retracted, but they have managed to incur the rage of the community. Independent developers are now working on a new game launcher that will make Steam obsolete. Read more

Biicode goes open source early after outpouring of community support

After the announcement, our community growth skyrocketed. Our investors were so impressed by the welcoming of our open source announcement that they let us go ahead with open sourcing biicode early. We worked hard to release most of it in biicode 3.0. Read more