Desktop Applications

Custom Fill Colors in OpenOffice.org

4

 

OpenOffice.org and the LibreOffice branch both suffer from an apparent restriction – the color palette appears to be severely limited. By default, you’re given a small palette of ~106 colors for everything from highlighting and borders to fill and font coloring.

Luckily, adding a custom color is no big deal – it just happens to be buried deep within the UI. So, color up your palette by following the steps below:

(more…)

adding services for mailto links in firefox

4

Under Windows, Firefox, unlike Internet Explorer, gives you an option for how you want to handle mailto links. The problem is, by default, you are only given options for two services: yahoo and gmail.

If you’d like to use another service, you’ll have to add it manually. This, as it turns out, is no big deal. The steps below will show you how to add Hotmail as an option for mailto links in Firefox:

(more…)

Alternating Row (or Column) Colors in Calc for OpenOffice.org or LibreOffice

2

Sometimes it improves the legibility of spreadsheets to have alternating row or column colors. Doing this manually (holding ctrl + left-clicking, then changing the background fill color of the selected cells) can be tedious and cumbersome. So, while the manual method suffices for short spans of cells, something more automated is preferred for entire documents, worksheets, or a copious number of rows or columns.

There are actually a few ways to do this in OpenOffice.org Calc (version 3.2 shown below), but the easiest method is to use Conditional Formatting. That’s the method I’ll show you below.

(more…)

Go to Top