From: michael.stemper@gmail.com   
      
   On 15/09/2022 13.50, Mark Bourne wrote:   
   > Michael F. Stemper wrote:   
   >> On 14/09/2022 13.45, David Catterall wrote:   
   >>> On 14/09/2022 16:34, Michael F. Stemper wrote:   
   >>>> Still won't let me capitalize "Loop Trail"   
   >>>   
   >>> By any chance, does the phrase "loop trail" (no caps) appear anywhere else   
   in the spreadsheet?   
   >>   
   >> Yeah, I've had this problem every time I've recorded this hike.   
   >> This is just the first time that I complained about it.   
   >   
   > Calc auto-completes with previous entries in the same column which match   
   what's been typed so far.   
      
   Yeah, but this wasn't auto-complete, especially not the first time   
   that I tried typing it (back in October).   
      
      The matching is case-insensitive, but when it fills in the completed text   
   it changes to the same capitalisation as the previous entry.  After it's done   
   that, you can undo (Ctrl+Z) the case matching to get what you typed.   
      
   Unfortunately, - had no effect. The decapitation (sorry)   
   happened on-the-fly when I hit .   
      
   > You might also want to go back and change those previous entries to the   
   correct capitalisation   
      
   I wasn't even able to do that with the first entry.   
      
   However, I did some more experimenting. I started by typing:   
      I didn't go to the Loop Trail   
   in that same column. It left it alone. Then, I started changing   
   a few words here and a few words there, until I got to my   
   desired text. No problem!   
      
   So I copied from that cell to the several others that should   
   have had it. No problem.   
      
   I carefully saved it and then re-opened it. Every cell referring   
   to "the Loop Trail" now had the correct capitalization. However,   
   when I started typing:   
      E pkg lot to t   
   it did an auto-complete -- without the correct capitalization.   
   It didn't mess with the correctly capitalized cells above it,   
   it just wanted to not let me type it correctly. However, since   
   I now have good examples, I can use - - to   
   copy and paste if I do that same hike again. Which I probably   
   will.   
      
   So the problem has been worked around, if not fixed.   
      
   --   
   Michael F. Stemper   
   The FAQ for rec.arts.sf.written is at   
      
   Please read it before posting.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)