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


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

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.