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<[email protected]>
To: [email protected]
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<[email protected]>
To: [email protected]
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<[email protected]>
To: [email protected]
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 [email protected]
In case of problems unsubscribing, write to
[email protected]
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 [email protected]
In case of problems unsubscribing, write to
[email protected]
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 [email protected]
In case of problems unsubscribing, write to [email protected]
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 [email protected]
In case of problems unsubscribing, write to [email protected]
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
