[Issue + Workaround] Question on using autocomplete...
Posted: Sun Dec 16, 2007 2:19 am
Hello everyone,
I think I may be having a problem with the Autocomplete feature built-in to Calc. (If what I'm about to describe is actually another feature, I'd like to know so I can search/ask for how to use that.) When I am in a spread-sheet with data already in it, and I start typing into a new cell (below other similar cells), a complete string is suggested to make data entry quicker. However, when I press "Enter" to accept the suggestion, the case of what I had started typing is not changed to match what the suggestion was implying would be matched.
Does anyone know how to set it up so that no matter what case (or lack thereof) I start typing in, when a suggestion is presented (matching data already in the spread-sheet higher up in the current column) that when I press "Enter" to accept the suggestion, the cell I am in gets changed to match the data that is already present higher up in the spread-sheet? If any of that is not clear, please let me know and I'll try to un-muddy the waters.
-David C.
I think I may be having a problem with the Autocomplete feature built-in to Calc. (If what I'm about to describe is actually another feature, I'd like to know so I can search/ask for how to use that.) When I am in a spread-sheet with data already in it, and I start typing into a new cell (below other similar cells), a complete string is suggested to make data entry quicker. However, when I press "Enter" to accept the suggestion, the case of what I had started typing is not changed to match what the suggestion was implying would be matched.
Does anyone know how to set it up so that no matter what case (or lack thereof) I start typing in, when a suggestion is presented (matching data already in the spread-sheet higher up in the current column) that when I press "Enter" to accept the suggestion, the cell I am in gets changed to match the data that is already present higher up in the spread-sheet? If any of that is not clear, please let me know and I'll try to un-muddy the waters.
-David C.