You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by "VinceB." <wa...@verizon.net> on 2017/02/03 14:51:01 UTC
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-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re[2]: Caps and Lowercase-Auto-complete Problem
Posted by Vladimir Nazarov <vo...@mail.ru.INVALID>.
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
Posted by Vladimir Nazarov <vo...@mail.ru.INVALID>.
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
Posted by "VinceB." <wa...@verizon.net>.
On 2/3/2017 10:03 AM, Rory O'Farrell wrote:
> On Fri, 03 Feb 2017 09:51:01 -0500
> "VinceB." <wa...@verizon.net> 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-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Caps and Lowercase-Auto-complete Problem
Posted by Rory O'Farrell <of...@iol.ie>.
On Fri, 03 Feb 2017 09:51:01 -0500
"VinceB." <wa...@verizon.net> 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 <of...@iol.ie>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org