Issue 51236 - Autocomplete does not preserve case
Summary: Autocomplete does not preserve case
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: 680m109
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
Depends on:
Reported: 2005-06-26 22:42 UTC by Andrea Pescetti
Modified: 2010-11-10 22:55 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description Andrea Pescetti 2005-06-26 22:42:01 UTC
Autocompletion in Calc suggests words previously typed in the same column.

1. Type "Fred" in cell A1.
2. Type "f" (lowercase) in cell A2.
3. A completion to "fred" (lowercase) is suggested
4. Press Enter: "fred" (lowercase) appears in A2.

Expected result: when the user accept the suggestion, change the case so that
the cell content exactly matches the chosen value (in this case, "Fred").

If I want to use the same word I typed above and I wrote that word with a
capital letter, I expect Autocomplete to change the case so that the two words
Comment 1 frank 2005-07-08 13:13:54 UTC

could not reproduce using OOo1.9.113.

maybe you have swutched off Capitalize first letter of sentence under tools
autocorrect options.

Comment 2 frank 2005-07-08 13:14:08 UTC
closed wfm
Comment 3 Andrea Pescetti 2005-07-09 13:24:17 UTC
Reopening as it is still there in a default install of m113.

The described situation ("fred" instead of "Fred") still happens, and Capitalize
first letter is checked.

By the way, it's not a matter of capitalizing the first letter. 
Here's a more insightful example (mind the case of letters):
1. Type "GNU/Linux" in cell B1.
2. Type "gn" (lowercase) in cell B2.
3. A completion to "gnU/Linux" is suggested
4. Press Enter

Actual result:   "gnU/Linux" appears in B2.
Expected result: "GNU/Linux" appears in B2.

Why do I expect "GNU/Linux" to appear? Because if I accept the autocompletion, I
expect the word to appear *exactly* as the one I had typed before, especially in
a Calc document.
Comment 4 frank 2005-07-22 16:07:36 UTC

autoinput gives you the choice to decide wether you would like it as written
before, or as your example showed as small gnU. So here colides to features.
Converting the input to the previous one with changing the capitalization would
never give you the possibility to write it in a different way.

So I close this as invalid.

Comment 5 frank 2005-07-22 16:07:54 UTC
closed invalid
Comment 6 Unknown 2010-11-10 22:55:12 UTC
Created attachment 73800