[Solved] Upper case letter changed to lower case

Discuss the spreadsheet application
Post Reply
User avatar
The Badger
Posts: 12
Joined: Sat Sep 28, 2013 4:40 pm

[Solved] Upper case letter changed to lower case

Post by The Badger »

Calc spreadsheet changing upper case letter to lower case - how do I solve this?
I have a spreadsheet where I save passwords, but today when I entered GPrhCr9pPY6Y in a cell, when I pressed "enter" it changed the first "P" to "p" so that it reads GprhCr9PY6Y and I cannot alter it no matter how many times I try.
Has any one a solution please?
Last edited by The Badger on Mon Jul 18, 2016 7:12 am, edited 1 time in total.
James Munroe OpenOffice 3 Windows 7 Ultimate 64-bit
ken johnson
Volunteer
Posts: 918
Joined: Sun May 31, 2009 1:35 am
Location: Sydney, Australia

Re: Upper case letter changed to lower case.

Post by ken johnson »

Go Tools>AutoCorrect Options... to bring up the AutoCorrect dialog then click the Options tab and see if Correct TWo INitial CApitals has a tick. If so remove the tick.

Ken Johnson
AOO 4.1.3 on Ms Windows 10
Help improve this forum by clicking the EDIT button on your first post then adding "[Solved]" to its heading once a solution to your problem has been provided.
User avatar
The Badger
Posts: 12
Joined: Sat Sep 28, 2013 4:40 pm

Re: Upper case letter changed to lower case.

Post by The Badger »

Thanks Ken!
Problem solved - easy when you know how.
James Munroe OpenOffice 3 Windows 7 Ultimate 64-bit
Post Reply