[Solved] Disable auto capital letters

Discuss the spreadsheet application
Post Reply
fbax
Posts: 4
Joined: Sat Oct 10, 2009 4:37 am

[Solved] Disable auto capital letters

Post by fbax »

copy/paste the "Lorem ipsum" example text paragraph from wikipedia into a cell; use default import settings.
This resulted in all text overlapping many columns to the right.
Inside the cell; I move the cursor to just after the second comma and hit Ctrl-Enter.
When I leave cell; the first word on second line is capitalized "Sed".
Tools -> Cell Contents -> Auto Input = disable does not change this behaviour.

How can I add new lines into cell text without changing to capital letters?
Last edited by fbax on Thu Mar 24, 2022 5:42 pm, edited 3 times in total.
fbax
Posts: 4
Joined: Sat Oct 10, 2009 4:37 am

Re: disable auto capital letters?

Post by fbax »

Solved it myself. After adding new line with Ctrl-Enter,
DO NOT hit ENTER
DO NOT click another cell
DO either one of these:
a) click inside the "input line" area in the formula bar.
b) move cursor to anywhere in text on first line of cell.

Tools -> Cell Contents -> Auto Input = can be enabled/disable does not change this behaviour.

Voila! No auto capitals!
Coucherias
Posts: 2
Joined: Wed Jun 05, 2019 7:21 pm

Re: [Solved] Disable auto capital letters?

Post by Coucherias »

I was getting "S/T" in caps when I wanted "s/t". I typed "'s/t " and got what I wanted.

 Edit: 
I was getting "S/T" in caps when I wanted "s/t". I typed "'s/t " and got what I wanted.
 
Last edited by MrProgrammer on Wed Aug 07, 2024 8:57 pm, edited 1 time in total.
Reason: Show post in monospace font, for clarity
OpenOffice 4.1.5 on MacOS 10.14.5
Alex1
Volunteer
Posts: 852
Joined: Fri Feb 26, 2010 1:00 pm
Location: Netherlands, EU

Re: [Solved] Disable auto capital letters?

Post by Alex1 »

In order to avoid overlapping other columns click Format, Cells, Alignment, check Wrap text automatically, OK.
AOO 4.1.16 & LO 25.8.3 on Windows 10
Post Reply