Re: [libreoffice-users][windows] Calc: Text & numbers

Dear Tom

On my system it does not work, the autoinput seems to be part of the 
default settings of the program and unfortunately does not seem to 
attribute itself to the file.

I,  turned autoinput Off - my calculator sheet works as it should, I 
then saved it and closed LO as well.

Open LO calc again, autoinput remained off (that's good), then changed 
the autoinput to the default On, then opened my calculator - and the 
problem returns"

regards

John B

-------------------------------------------------------------------------------------------------------------------------






On 29/06/2011 12:46, Tom Davies wrote:
> Hi :)
> Ahah, i think Stephen's answer is best.  You will probably need to re-save the
> document and upload the newly saved document to the right place.
> Regards from
> Tom :)
>
>
>
>
> ----- Original Message ----
>    
> > From: John B<johnb@email2.me>
> > To: users@global.libreoffice.org
> > Sent: Wed, 29 June, 2011 12:30:44
> > Subject: Re: [libreoffice-users][windows] Calc: Text&  numbers
> >
> > Dear Tom / Stephan
> >
> > I have not seen this feature before in my Lotus 123  or  in my old MS
> > Excel either, it may be that the default settings in  these are Off,
> > where as the default in LO (and OOo) is clearly On.
> >
> > I  use my "calculator" for anyone to download from my website and the
> > people  who download it, may not have the knowledge to switch it off.
> >
> > http://www.chillypepperhire.co.uk/calculator-downloads.htm - if you
> > enter the number 8 into the "Height" box you will see what I mean (once
> > you get past the open with LO and it opens in  "read only" and you have
> > to re-save it anyway- annoyance)
> >
> > I was hoping that I could just  format the cell in some way so the
> > spreadsheet could be used be anyone and  not say OMG when they
> > inadvertently enter a number and text appears (as I  did).
> >
> > I suppose the only answer is to re-design the form (unless you know  better).
> >
> > regards
> >
> > John  B
> >
> > ---------------------------------------------------------------------------------------------------------
> > -
> >
> >
> >
> >
> >
> > On  29/06/2011 11:35, Tom Davies wrote:
> >      
> > > Hi :)
> > > For most types of  auto-complete you can just tap the "Del" key or any
> > >        
> > character
> >      
> > > (not  enter) while the predicted part is still selected/bold/inverse.  If
> > >        
> > you
> >      
> > > just press enter then the program happily thinks it guessed  right.
> > >
> > > Regards from
> > > Tom  :)
> > >
> > >
> > >
> > >
> > > ----- Original Message  ----
> > >
> > >        
> > > > From: Stephan Zietsman<sziets@gmail.com>
> > > > To: users@global.libreoffice.org
> > > >   Sent: Wed, 29 June, 2011 10:09:47
> > > > Subject: Re:  [libreoffice-users][windows] Calc: Text&    numbers
> > > >
> > > > John B wrote:
> > > >
> > > >          
> > > > > this where, say,  you enter text into a cell in column  E   say at E16
> > > > >            
> the
>    
> > > > > text would be something>      8,000 btus (or 2.34kw)  Machines
> > > > >
> > > > > now  if you type in the same column above or below it,  say at E7 the
> > > > >            
> > number
> >      
> > > > > 8, the whole of  "8,000 btus (or 2.34kw)  Machines"  appears.
> > > > >
> > > > >            
> > > >   That is called "AutoInput"
> > > >
> > > >
> > > >          
> > > > > I would like to turn this  feature  off.
> > > > >
> > > > >            
> > > > On Windows it is  under:  Tools ->   Cell Content ->     AutoInput
> > > >
> > > > Regards
> > > >   Stephan
> > > >
> > > > --
> > > > Unsubscribe instructions:   E-mail to users+help@global.libreoffice.org
> > > >   In  case of problems unsubscribing, write to
> > > >          
> > postmaster@documentfoundation.org
> >      
> > > >   Posting  guidelines + more: http://wiki.documentfoundation.org/Netiquette
> > > > List   archive: http://listarchives.libreoffice.org/global/users/
> > > >   All  messages sent to this list will be publicly archived and cannot  be
> > > > deleted
> > > >
> > > >
> > > >
> > > >          
> > >
> > >
> > >
> > >
> > > No virus found in this  incoming message.
> > > Checked by AVG - www.avg.com
> > > Version: 9.0.901  / Virus Database: 271.1.1/3732 - Release Date: 06/28/11
> > >        
> > 19:34:00
> >      
> > >        
> >
> > --
> > Unsubscribe  instructions: E-mail to users+help@global.libreoffice.org
> > In  case of problems unsubscribing, write to postmaster@documentfoundation.org
> > Posting  guidelines + more: http://wiki.documentfoundation.org/Netiquette
> > List  archive: http://listarchives.libreoffice.org/global/users/
> > All  messages sent to this list will be publicly archived and cannot be
> >      
> deleted
>    
> >      
>    
>
>
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 9.0.901 / Virus Database: 271.1.1/3732 - Release Date: 06/28/11 19:34:00
>
>    


--
Unsubscribe instructions: E-mail to users+help@global.libreoffice.org
In case of problems unsubscribing, write to postmaster@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted