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

Quadcopter drone packs first all-Linux APM autopilot

Erle Robotics launched a ROS-enabled, open source “Erle-brain” autopilot that runs APM directly on Linux. The device also powers an “Erle-copter” drone. Over the last year, Spanish firm Erle Robotics S.L. has been working with 3DRobotics to develop an open source BeaglePilot autopilot for drones that can run Linux on 3DR’s popular, Arduino-based APM (ArduPilot Mega) platform. The APM Linux port was developed by both companies, as well as several academic institutions. The BeagleBone-based “Erle-brain” autopilot is built into the $490-and-up Erle-copter quadcopter. Read more

Seven Tips To Get The Most From Your New Android Smartphone

With applications able to run in the background and sync as they see fit, Android can rapidly eat through your cellular data allowance if you are not careful. While it’s fine to let the data run free on wi-fi, you’ll want to restrict your data usage when out and about. Short of switching off mobile data (which defeats the purpose of a smartphone), look under the options in the Data Usage part of the settings. Here you’ll find my wallet’s favourite Android setting of ‘restrict background data’. Now when using cellular data, apps will only pull down data when they are in the foreground and you can see them doing so. If a smartphone is all about being in control, this is the option that gives you confidence. Read more

today's leftovers

Hands-on with PCLinuxOS: A terrific release

I had been thinking that a new PCLinuxOS release was due any time now, based on their quarterly release schedule. Sure enough, it has now arrived, just in time for Christmas - PCLinuxOS 2014.12. Read more Also: Santa Claus has Linux in his sack -- PCLinuxOS 2014.12 is here PCLinuxOS 2014.12 released