Re: Caps and Lowercase-Auto-complete Problem

[Alan Pearce]

If you don't want to change your settings you can delete the highlighted area 
which is offered and continue typing your new text. I think you can do this 
with the right arrow key or maybe the delete key, I can't check as I am not 
able to get acess into AOO at the moment.


Alan.

Alan N Pearce
Tel: 01275 856887
Mob: 07761  255688

Sent from Samsung tablet

 Original message 
From: "VinceB." <wa.two...@verizon.net> 
Date:03/02/2017  14:51  (GMT+00:00) 
To: AOO Mail List <users@openoffice.apache.org> 
Subject: Caps and Lowercase-Auto-complete Problem 


I am trying to enter a case-specific text string into a Calc cell. The 
string has both uppercase and lowercase and numerical characters.  It 
appears that Calc is remembering similar/previously entered strings and 
forces those to appear within the cell, i.e., changing a lowercase to an 
uppercase appearing as the first character, or changing a lowercase to 
an uppercase where the character is not the first nor the last character 
within the string.  The format for the cell is "Text". Clearing cell's 
all content and tried again; no go. Using the check mark with the 
desired string display in the bar does not help me.

How can I disable the auto-complete feature for this effort?

What am I doing incorrectly ?


Regards,

VinceB.




-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re[2]: Caps and Lowercase-Auto-complete Problem

[Vladimir Nazarov]

Thank you!  Translator into Russian is bad, I did not understand much, but 
something could understand.  I'll try.


С уважением Владимир.

Re[2]: Caps and Lowercase-Auto-complete Problem

[Vladimir Nazarov]

Thank you!  Translator into Russian is bad, I did not understand much, but 
something could understand.  I'll try.



С уважением Владимир.

Re: Caps and Lowercase-Auto-complete Problem

[VinceB.]

On 2/3/2017 10:03 AM, Rory O'Farrell wrote:

On Fri, 03 Feb 2017 09:51:01 -0500
"VinceB."  wrote:


I am trying to enter a case-specific text string into a Calc cell. The
string has both uppercase and lowercase and numerical characters.  It
appears that Calc is remembering similar/previously entered strings and
forces those to appear within the cell, i.e., changing a lowercase to an
uppercase appearing as the first character, or changing a lowercase to
an uppercase where the character is not the first nor the last character
within the string.  The format for the cell is "Text". Clearing cell's
all content and tried again; no go. Using the check mark with the
desired string display in the bar does not help me.

How can I disable the auto-complete feature for this effort?

What am I doing incorrectly ?


Regards,

VinceB.

Try unchecking /Tools /Cell Content /Autoinput



Thank you Rory.  Your suggestion worked and solved my problem.

I discovered that by using your suggestion, it is a control over the 
entire sheet. I thought I could apply it to only the column where I am 
entering case-sensitive text strings; so, I must reapply the /Autoinput 
tool feature afterward.


TNX again.

VinceB.


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Caps and Lowercase-Auto-complete Problem

[Rory O'Farrell]

On Fri, 03 Feb 2017 09:51:01 -0500
"VinceB."  wrote:

> 
> I am trying to enter a case-specific text string into a Calc cell. The 
> string has both uppercase and lowercase and numerical characters.  It 
> appears that Calc is remembering similar/previously entered strings and 
> forces those to appear within the cell, i.e., changing a lowercase to an 
> uppercase appearing as the first character, or changing a lowercase to 
> an uppercase where the character is not the first nor the last character 
> within the string.  The format for the cell is "Text". Clearing cell's 
> all content and tried again; no go. Using the check mark with the 
> desired string display in the bar does not help me.
> 
> How can I disable the auto-complete feature for this effort?
> 
> What am I doing incorrectly ?
> 
> 
> Regards,
> 
> VinceB.

Try unchecking /Tools /Cell Content /Autoinput


-- 
Rory O'Farrell 

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Caps and Lowercase-Auto-complete Problem

[VinceB.]

I am trying to enter a case-specific text string into a Calc cell. The 
string has both uppercase and lowercase and numerical characters.  It 
appears that Calc is remembering similar/previously entered strings and 
forces those to appear within the cell, i.e., changing a lowercase to an 
uppercase appearing as the first character, or changing a lowercase to 
an uppercase where the character is not the first nor the last character 
within the string.  The format for the cell is "Text". Clearing cell's 
all content and tried again; no go. Using the check mark with the 
desired string display in the bar does not help me.


How can I disable the auto-complete feature for this effort?

What am I doing incorrectly ?


Regards,

VinceB.




-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org