> > Johnny Andersson wrote:
> >> Found this strange thing in Calc:
> >> Auto correction is ON and I set it to make the first letter in every   
> >> sentence to be capitalized.
> >> This seems to work very good, UNLESS I enter a single letter in a cell.
> >>  If I enter a single a, it will turn into an A and then back (within  
> >> maybe  0.2 s or something like that on my slow computer from 1998) to a  
> >> again.  The same thing with the whole Swedish alphabet EXCEPT s! I also  
> >> tried the  norwegian/danish � and � and they both turned into � and �  
> >> and stayed that  way.
> >
> > If the entered text is already present in the same column, the existing  
> > cell's capitalization is used (as part of AutoInput). So I suppose you  
> > have a cell "a" in the column, but no "s" (or an uppercase "S").

> No, it was an empty spreadsheet.
> I tried it again, a few seconds ago. Everything was entered into A1.  
> Before every new change in settings I closed OpenOffice and then opened it  
> again from the Start menu. I also tried to open a new spreadsheet, but the  
> result were the same.
> 
> 
> 
> Tools -> Auto Correct -> Options -> Uncheck everything.
> 
> Now the following happens when I input single letters:
> 
> a -> a
> A -> a
> s -> s
> S -> S
> 
> Or, in other words:
> 
> Enter a single letter to a cell:
> Any lowercase letter -> No change.
> Any uppercase letter except "S" -> Changes to lowercase after about 0.2 s.
> "S" -> No change, still uppercase.
> 
> Switch on "Start every sentense with Uppercase",
> enter a single letter to a cell:
> "s" -> Changes to "S".
> Any other lowercase letter -> Changes to uppercase for about 0.2 s, then  
> changes back to lowercase.
> Any uppercase letter except "S" -> Changes to lowercase after about 0.2 s.
> "S" -> No change, still uppercase.



My guess is that you have a user defined cell format that is doing this to
you.... Are you on 1.1.4 or is this one of the 2.0 prerelease version?


Rob Winchester



                
__________________________________ 
Do you Yahoo!? 
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/ 

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to