Making a gantt in open office

Hail,

Open office offers a lot of functions that let you work very well with spreadsheets.
For instance, if you want to build a gantt diagram, you just fix the cells on the columns containing the dates (initial and final dates) and then color de cell using the function:

=IF(
OR(
AND(E$1>=$B2;E$1<=$C2);
AND((E$1+12)>=$B2;
(E$1+7)<=$C2)
);
STYLE("Going");STYLE("Not going")
)

Where "Going" and "Not going" are formats that were defined using "Format-> styles and formatting".

For "Going" I set the letters to red forecolor and red background. For "Not going" I set the letters and background to White color.

B and C are the columns where the initial and final dates are placed.
Row 1 from column E to BE are set to be the initial days of each week.

If you are new to OpenOffice this may be of help.

Remember that Open Office is free software. You can download it from http://www.openoffice.org.