[CentOS] Serious bug in OpenOffice.org Calc shipped with CentOS
kerplop at sbcglobal.net
Thu Aug 6 15:37:51 UTC 2009
Niki Kovacs wrote:
> Until now I've been a happy user of CentOS. Everything just works(tm),
> and I don't care if application versions are slightly outdated.
> Next week I have to give a series of classes for a company that recently
> made the switch to Linux. On schedule is a one-week course for Writer
> and Calc.
> And right now I discover that one crucial function of Calc, "fill
> series", doesn't work. Let's say I type "lundi" (monday) in one cell, so
> I can pull Calc's handle to fill other cells with the days of the week.
> Doing the same with "janvier" (january) does so with the names of the
> month. Well, this function is broken in OO shipped with CentOS. And I
> don't have the slightest clue as to why. Tried the same on a more recent
> version of OO in Ubuntu, and it works like a charm.
> Anyone has a solution to this? This seems like a major nuisance to me.
It's awkward and I'd hate to actually teach people to do it this way:
1. Select the column
2. Format > Cells >Numbers tab, category "User Defined".
3. In the "Format Code" space, type "NNN" .
4. Click on the green check mark. Click O.K. Your format is now a
5. At your worksheet, Highlight the cells in the "day" column. Clear the
cells to blank.
6. Edit > Fill down, date, day
7. For grins, enter a start value of 5 and an increment of -2
8. You get a column that starts off "Thursday, Tuesday, Sunday, Friday,
For some reason, the 0th day of the week is Saturday and there is no 0/7
with many other apps.
If you prefer "Fri" to "Friday" and "Wed" to "Wednesday", etc, use "NN"
for the format code.
If, you've been drinking too much and want a "," following the "Friday",
etc., use "NNNN" :-)
More information about the CentOS