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

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
>

-- 
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