MS-style autocorrect interference

Discuss the spreadsheet application
Post Reply
timtranslates
Posts: 3
Joined: Sat Dec 15, 2007 1:09 pm

MS-style autocorrect interference

Post by timtranslates »

I'm trying to create a vertical list of the months of the year, like this:

Jan
Feb
Mar
Apr
May
etc.

The problem is, when I type in certain months, Calc autocorrects them to make them all lowercase, so I get this:

Jan
feb
mar
Apr
may
Jun
Jul
Aug
Sep
oct
nov
Dec

I'm not sure why this is happening for some months and not for others. As a workaround, I was going to make them all lower case, but lo and behold, the one's that can be written in uppercase are autocorrected to upper case! In MS Office, I could use CTRL+Z to undo autocorrects, but that doesn't seem to work in Calc.

I've looked at the autocorrect settings, and I cannot figure out why it is autocorrecting "Feb" to "feb". Can anyone shed any light?

Tim
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: MS-style autocorrect interference

Post by Villeroy »

Never mind. It's just one of those bugs. Put the following formula into the first cell and drag down.
=TEXT(DATE(0;ROW($A1);1);"MMM")
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
timtranslates
Posts: 3
Joined: Sat Dec 15, 2007 1:09 pm

Re: MS-style autocorrect interference

Post by timtranslates »

Thanks for the solution (I thought there must be some kind of automated method). Only problem is, in this particularly case I actually want two lines for each month, so my list should be:

Jan

Feb

Mar

Apr

etc

If I use your formula, I get "Mar" where I want "Feb". Any automated way of doing this?
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: MS-style autocorrect interference

Post by Villeroy »

=IF(MOD(ROW($A1);2);TEXT(DATE(0;CEILING(ROW($A1)+1;1)/2;1);"MMM");"")
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Post Reply