[opensuse] openoffice question
I help keep track of members in a club I belong to and use a spreadsheet to do so. For the Birthday field we only use month/day (no year) for privacy reasons. The format for the cells is MMM DD which properly shows as Jan 31 displayed in the cell. But the cell contents default to 01/31/2008 showing a year which is _not_ wanted when printing a club roster. The data is pulled data from the spreadsheet and also shows the year which is undesirable. Is this a bug that should be reported or am I just doing something wrong? -- Ken Schneider SuSe since Version 5.2, June 1998 -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Ken Schneider wrote:
I help keep track of members in a club I belong to and use a spreadsheet to do so. For the Birthday field we only use month/day (no year) for privacy reasons. The format for the cells is MMM DD which properly shows as Jan 31 displayed in the cell. But the cell contents default to 01/31/2008 showing a year which is _not_ wanted when printing a club roster.
Ken, Right-click on the column header, then click Format Cells -> Numbers -> Date. You'll find a couple of dozen options, among which will be at least two like what you want. This is in OO 2.4 here, but it's been there a long time -- at least since whatever was in suse 9.1, when I started using OO. John Perry -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
John E. Perry pecked at the keyboard and wrote:
Ken Schneider wrote:
I help keep track of members in a club I belong to and use a spreadsheet to do so. For the Birthday field we only use month/day (no year) for privacy reasons. The format for the cells is MMM DD which properly shows as Jan 31 displayed in the cell. But the cell contents default to 01/31/2008 showing a year which is _not_ wanted when printing a club roster.
Ken,
Right-click on the column header, then click Format Cells -> Numbers -> Date.
You'll find a couple of dozen options, among which will be at least two like what you want. This is in OO 2.4 here, but it's been there a long time -- at least since whatever was in suse 9.1, when I started using OO.
John Perry
This is what I have set but when you look at the actual contents of the cell the year shows and the year also prints in mail merge labels. This is with 2.3 in 10.3 and 3.0 in 11.1b3. -- Ken Schneider SuSe since Version 5.2, June 1998 -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Ken Schneider wrote:
John E. Perry pecked at the keyboard and wrote:
...
This is what I have set but when you look at the actual contents of the cell the year shows and the year also prints in mail merge labels. This is with 2.3 in 10.3 and 3.0 in 11.1b3.
I've never used mail merge, so I guess it's a bug. Yes, it displays in the formula bar, but in the column cells here it does the right thing, and when I print it (I just tried it to be sure :-), the right thing is on paper. Hope you find a way around it. jp -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
participants (2)
-
John E. Perry
-
Ken Schneider