https://issues.apache.org/ooo/show_bug.cgi?id=105319
Donald Payne <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #5 from Donald Payne <[email protected]> --- I agree, this is more than "trivial". I agree with sztejkat, that case-insensitive matching is better. But I would not assume anything about the cells containing Indo-European names, so I would not treat the first letter specially. People (including myself) put weird, non-language stuff into spreadsheet cells. (Sometimes by mistake, but that can be fixed.) If someone enters different cases in different cells, I would assume they meant to. How about: 1. Case-insensitive match, but 2. When user hits TAB to cycle through the options, show all the different case versions. If the user has a lot of versions of the same letters with different case, and those differences are irrelevant, they may find this annoying. OK, so they can go back and fix their data, which is probably a good thing anyway. 3. First show the version that most closely matches in case to what they have typed. So let's say above cells contain "Barbara" and "BARBARA". If user starts typing "Ba", offer to AutoInput "Barbara"; if they press TAB, show "BARBARA". Conversely, if they start typing "BA", do the opposite. 4. Regardless of the above: If user goes into Edit mode (F2) either while first entering the cell or afterwards, assume they know what they're doing and don't AutoInput at all. Currently OO Calc changes case even when I edit a cell with F2. -- You are receiving this mail because: You are on the CC list for the issue. You are the assignee for the issue. You are watching all issue changes.
