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 <jo...@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<szi...@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+h...@global.libreoffice.org
> >>  In  case of problems unsubscribing, write to 
>postmas...@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+h...@global.libreoffice.org
> In  case of problems unsubscribing, write to postmas...@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+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@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

Reply via email to