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
