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

Shortlist of open source software used at NASA lab

The offer was too good to be true. Three whole weeks at the NASA Glenn Research Center and an invitation to come back. I could scarcely believe it when I read the email. I immediately forwarded it to my parents with an addition of around 200 exclamation points. They were all for it, so I responded to my contact, Herb Schilling, with a resounding “YES!” Read more

Ten Years of GParted

The GParted team is happy to announce the tenth anniversary of GParted. The first public release of GParted was version 0.0.3 on August 26th, 2004. Over the past 10 years, much has happened. Following are some statistics: Over 300 people have contributed to GParted Many GNU/Linux distributions now include GParted Translators have worked to make GParted available in over 50 different languages GParted is used in over 220 countries around the world There have been over 17 million downloads from Sourceforge alone To mark the occasion, questions were posed, and following are responses shared by some key contributors. Read more

LinuxCon Showcases Advances in Linux, Open Source

The Linux Foundation hosted its LinuxCon North America conference from Aug. 20 to 22 in Chicago, providing attendees with insight into the latest and greatest advancement in the Linux and open-source worlds. The event kicked off with the Linux Foundation's executive director, Jim Zemlin, announcing a new Linux certification program. The two new designations are the Linux Foundation Certified System Administrator (LFCS) and Linux Foundation Certified Engineer (LFCE). During his keynote address, Zemlin also provided insight into what the Linux Foundation does and what his role is within the Linux community. The highlight for many attendees at any LinuxCon event is the opportunity to see and hear Linux creator Linus Torvalds speak. At the 2014 event, Torvalds, speaking on a Linux kernel developer panel, declared that he is still interested in seeing the Linux desktop succeed. Looking beyond just Linux, the CEO of education platform edX explained why the future of education is open and how his company has fully embraced the open-source model. An open model of collaboration is also being embraced in the automotive industry by startup Local Motors. Jay Rogers, CEO of Local Motors, explained how his company is aiming to revolutionize the automotive industry with crowdsourcing techniques. In this slide show, eWEEK looks back on some of the highlights of the LinuxCon North America 2014 event. Read more More: Linux Energy Drink: Get Energized with this Recap of LinuxCon and CloudOpen North America

Mozilla Adding Granular App Permissions to Firefox OS

Mozilla is set to add a feature to its mobile Firefox OS that will give users the ability to revoke any application’s permissions on a granular basis. Firefox OS is the open source operating system that Mozilla built for smartphones. The software runs on a variety of devices from manufacturers such as Alcatel, ZTE and LG. The devices mainly are available outside of the United States, although there’s at least one Firefox OS phone sold in the U.S. The operating system is meant to be flexible and includes many of the security and privacy features that Mozilla has built into the Firefox browser over the years, namely support for Do Not Track. Read more