Language Selection

English French German Italian Portuguese Spanish

Manipulating lists in OpenOffice.org Calc

Filed under
HowTos

When asked to explain the purpose of spreadsheets, most people think of calculations first. And it's true that spreadsheets like Calcs have hundreds of different functions for performing calculations. However, probably the most common tasks in spreadsheets is manipulating lists.

Calc and other spreadsheets have few advantages over a word processor when you are just making a list. In fact, unless you have a spreadsheet template set up so that cells have word wrap and hyphenation, you might be better off using a word processor if all you have is half a dozen items on the list. However, as the number of list items creeps up into the hundreds and beyond into the lower fringes of database territory, the different ways that you can manipulate lists in spreadsheets starts to give them a distinct advantages. In Calc, searching, the printing of selected items, and, to a lesser extent, privacy can all be made easier through the use of outline group controls, filters, and customized sorts.

Full Story.

More in Tux Machines

Open Source Software: Sailing Into Friendlier Seas

Open source software is now a force drawing enterprises and developers like a magnet. The factors pulling adopters into the open source fold are changing, though. Also changing are the attitudes of software developers and corporate leaders about the viability and adaptability of open source. Open source software is increasingly important within the corporation, as a recent survey conducted by Black Duck Software and North Bridge Venture Partners found. Developers and corporate leaders now view open source software as a strategic advantage that can help companies create more secure products with better features and functionality. This helps adopters beat the competition. Read more

Linux at 23, Desktop Feedback, and GIMP 2.8.14 Released

The top story tonight is the releases of GIMP 2.8.12 and 2.8.14. Linux celebrated 23 years yesterday and the community had a bit to say about "the desktop." And finally tonight we have a couple of gaming announcements and Bruce Byfield on the KDE Visual Design Group. Read more

Tux Paint: Doing FOSS Right

Apparently, I’m not alone in thinking highly of the software, if this page of testimonials is any indication. In fact, the publication “This Old Schoolhouse” recently echoed many other reviews in their article in the June 2012 edition. In the article, Andy Harris, the Tech Homeschooler, wrote, “Tux Paint is just about the most kid-friendly program I’ve ever seen. It’s designed so the adult can set it up, and even very young children can enjoy it thoroughly. It also has sophisticated enough features for siblings and parents to enjoy.” Tux Paint is a project that does FOSS right: A wide-ranging team labors for the good of the program and consistently puts out quality software without fanfare or self-congratulation. The proof, as they say, is in the software itself: high-quality software which enjoys a high degree of acceptance with teachers and parents, to say nothing of holding the interest – and unlocking the creativity – of children. Read more

Google Chrome 37 Stable Arrives with Better Unity Integration in Ubuntu

Google Chrome 37 is now the current stable version of the Internet browser from Google. It's a release that's more focused on security than anything else, but there are a few new features. It won't feel different from the 36.x branch that users have just upgraded from, but that shouldn't be a reason not to update the software. One of the most important issues solved in Google Chrome 37 only applies for the Windows platform, which received DirectWrite support for improved font rendering. This wasn't an issue on Linux or Mac OS X, so it looks like only Windows was left behind on this issue. The developers also said that a few new apps and extension APIs have been added, and numerous changes have been made in terms of stability. Read more