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