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

Hi :)

Ok, can you turn it off and leave it off?  Save the document, upload it, perhaps 
change the html to point at the new version (?).  Hopefully then your website 
one should work the way you want it.  

Regards from
Tom :)





----- Original Message ----
> From: John B <johnb@email2.me>
> To: users@global.libreoffice.org
> Sent: Wed, 29 June, 2011 13:14:41
> Subject: 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
>

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