Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index 

Hi :)
Ouch.  I just tried downloading you new one and opened it without messing around 
with the settings at all.  Sadly it did suffer the problem you are trying to 
avoid.  I don't know if there is a macro method or something that might be 
useful so i think perhaps post it as a bug-report and see if a kind dev is able 
to help at all in the next couple of days?  There might be some way of locking 
certain cells or restricting input to a set list or something.

Good luck and apols from
Tom :)




----- Original Message ----

From: John B <johnb@email2.me>
To: users@global.libreoffice.org
Sent: Wed, 29 June, 2011 15:12:03
Subject: Re: [libreoffice-users][windows] Calc: Text & numbers

Hi Tom

Tried - as you suggested (ever hopeful)

It works of course  the way I want it, when I do download the new saved 
spreadsheet with the  autoinput turned Off . However, if I now  turn On 
the autoinput at any  point (as would be everybody elses  by default), it 
starts that  autoinput. As I originally thought, its not a function of 
the sheet itself -  so I am looking for another  answer.

thanks

John

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

On  29/06/2011 14:21, Tom Davies wrote:

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
   

     

   



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

Context

Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.