[Solved] Problem I Have

Discuss the spreadsheet application

[Solved] Problem I Have

Postby fjwag3 » Wed Jan 16, 2019 8:12 pm

I need two Upper Case letters no space abbreviation in one cell, just whenever I need it, just where ever it goes. It is auto changed and makes the 2nd letter lowercase.
Must be a setting I'm missing.

Thanks in advance

FJW
Last edited by Hagar Delest on Fri Feb 01, 2019 4:30 am, edited 1 time in total.
Reason: tagged [Solved].
Open Office 2.4 on Windows 7
fjwag3
 
Posts: 7
Joined: Fri Jul 06, 2018 10:17 pm

Re: Problem I Have

Postby FJCC » Wed Jan 16, 2019 8:21 pm

Select the menu Tools -> AutoCorrect Options. On the Options tab, remove the selection from Correct Two Initial Capitals.
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7056
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Problem I Have

Postby fjwag3 » Wed Jan 16, 2019 8:25 pm

Much appreciated.

Here is another one.....sometimes I can't move to the next cell w my arrow key. Certain group of cells always seem to work, others are iffy. :shock:
Open Office 2.4 on Windows 7
fjwag3
 
Posts: 7
Joined: Fri Jul 06, 2018 10:17 pm

Re: Problem I Have

Postby FJCC » Wed Jan 16, 2019 9:11 pm

Can you upload a document showing the problem with moving into some cells? To do that, click Post Reply and look for the Upload Attachment tab just below the box where you type a response.
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7056
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Problem I Have

Postby fjwag3 » Wed Jan 16, 2019 9:28 pm

It happens randomly, no big deal. Thanks for your offer.
Open Office 2.4 on Windows 7
fjwag3
 
Posts: 7
Joined: Fri Jul 06, 2018 10:17 pm

Re: Problem I Have

Postby keme » Thu Jan 17, 2019 2:45 pm

In "edit mode" the arrow keys only navigates insertion point (text cursor) inside cell content. It won't move the cell selection until you exit the edit mode (by pressing tab, enter or F2, or clicking elsewhere in the grid).
Edit mode can be invoked by the F2 function key (toggle) and by clicking in cell content in the formula bar.
User avatar
keme
Volunteer
 
Posts: 3065
Joined: Wed Nov 28, 2007 10:27 am
Location: Egersund, Norway

Re: Problem I Have

Postby Villeroy » Thu Jan 17, 2019 9:00 pm

While in edit mode F2 toggles between text cursor movement and reference pointer mode.
Hit F2 to edit the cell. Now you are in either mode.
Hit F2 another time and you are in the other mode.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, OpenOffice 4.x & LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26395
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Problem I Have

Postby keme » Fri Jan 18, 2019 10:44 am

Quite so, Villeroy. Thanks!

Cell entry in a spreadsheet is a bit more complex than what immediately comes to mind. Cell content can be "active" (formula) or "passive" (data), and editing behaves differently for the two classes of content.

To summarize:

Formula entry
Villeroy wrote:While in edit mode F2 toggles between text cursor movement and reference pointer mode.
Hit F2 to edit the cell. Now you are in either mode.
Hit F2 another time and you are in the other mode.

Formula entries are invoked by starting the cell entry with equals sign, plus or minus.

Data entry
keme wrote:In "edit mode" the arrow keys only navigates insertion point (text cursor) inside cell content. It won't move the cell selection until you exit the edit mode (by pressing tab, enter or F2, or clicking elsewhere in the grid).
Edit mode can be invoked by the F2 function key (toggle) and by clicking in cell content in the formula bar.

Data entry (plain number/text) is invoked by starting with any character other than those mentioned above. Data entry can also be forced by preformatting the cell to interpret everything as text.
User avatar
keme
Volunteer
 
Posts: 3065
Joined: Wed Nov 28, 2007 10:27 am
Location: Egersund, Norway

Re: Problem I Have

Postby fjwag3 » Thu Jan 31, 2019 7:07 am

OK!.......Thanks All.
Open Office 2.4 on Windows 7
fjwag3
 
Posts: 7
Joined: Fri Jul 06, 2018 10:17 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 18 guests