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

Linux Mint Developers Launched a New Project Called mint-dev-tools

Not only are the Linux Mint developers working on the operating systems, they are also making sure that third-party developers have a say in their project as well. That is why they have started to work on a new project called "mint-dev-tools," which is aimed specifically at devs, as the name implies. Read more

HTC One E9 Specs News, Rumors: New 'Cheaper' Android Flagship Appears In Live Images

After the One M9 that was announced earlier this month, it looks like there are more devices from the Taiwanese manufacturer than everyone expected. First on the list is the One M9 Plus, which is already expected to make an appearance in an April 8 event in China. Read more

Why Android 5.1 Is A Step Up From Android 5.0

One of the major modifications in Android's newest system update, revolves around the 'quick settings' menu. For those who aren't aware, sliding down the notifications bar twice(or once with two fingers), brings up a quick settings menu, within which one can toggle settings like screen brightness, WiFi, Bluetooth, a flashlight, airplane mode, auto rotate settings, location, screen casting etc. Additionally, in Android 5.0, activating a specific toggle led to it being added to the quick settings menu, the first time they're activated. In Android 5.1 however, it is possible to hide these icons with a long press. Read more