[CentOS] Serious bug in OpenOffice.org Calc shipped with CentOS

Thu Aug 6 15:37:51 UTC 2009
Robert <kerplop at sbcglobal.net>


Niki Kovacs wrote:
> Hi,
>
> 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 
"Date" format.
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, 
Wednesday..."

For some reason, the 0th day of the week is Saturday and there is no 0/7 
ambiguity as
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"  :-)