Random capital letters changing to lower case

Discuss the spreadsheet application

Random capital letters changing to lower case

Postby sherman63 » Fri Nov 15, 2019 1:40 am

In a spread sheet certain letters input as capitals change to lower case, G is fine but D chabges to d. This has happened suddenly with no changes.
Last edited by MrProgrammer on Fri Nov 15, 2019 5:06 am, edited 1 time in total.
Reason: Moved from Beginners forum to Calc
OPen Office 4,1,7
sherman63
 
Posts: 2
Joined: Fri Nov 15, 2019 1:35 am

Re: Random capital letters changing to lower case

Postby robleyd » Fri Nov 15, 2019 3:45 am

Welcome to the forum.

See this topic which discusses the same situation
Cheers
David
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 3057
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Random capital letters changing to lower case

Postby Zizi64 » Fri Nov 15, 2019 7:25 am

- Maybe the Autoinput function is switched ON, and there is same cell content with small "d" in the specific column.

Can you upload a small, .ods type sample file here?
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.3.3; AOO4.1.6
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 8521
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Random capital letters changing to lower case

Postby sherman63 » Fri Nov 15, 2019 12:28 pm

Thanks for replying, I have the autoinput on and if I switch it off then this problem is solved but it creates other problems of input speed for the rest of the spreadsheet. Is there a way of having it off for just the one column?
OPen Office 4,1,7
sherman63
 
Posts: 2
Joined: Fri Nov 15, 2019 1:35 am

Re: Random capital letters changing to lower case

Postby robleyd » Fri Nov 15, 2019 12:36 pm

No - but you can right click in a cell and choose Selection List for a list of all values in the column; for text columns only. Alternatively you might consider a Data Validity check using a range of valid values - see the Help for that feature.
Cheers
David
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 3057
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia


Return to Calc

Who is online

Users browsing this forum: MSN [Bot] and 8 guests