Hi. I've been trying to find a way to disable (as in one definite
action, not a repetitive action performed everytime its' needed) calc
from turning things like 2/2/2 into 02/02/02.
After searching I can see some answers but these are about older
versions of Lbreoffice, and I can also see some not so outdated links
that show there's a lot of disagreement between the developers/advanced
users and the regular/non-technical users. I don't want to recreate the
debate. I just want to know if things are still the same as of
Libreoffice 5 or if there are new possibilities now.
List of things I've found and tested so far without satisfaction:
Use apostrophe before data: '2/2/2
works but has to be done per each cell so doesn't really count as
disabling like I said above
Format cells as "text"
works but you have to do it before entering the data, or else
you'll lose the data, which after you apply the text format to the cell,
will be converted to another inexplicable number. Example: I type 2/2/2,
it gets converted to 02/02/02, then I change the cell's format to Text
and then I see the number 37289?... Additionally, sometimes you're
entering data on the fly, or making a sketch, and you don't really have
defined where text only data will go, etc
Disable Tools > Autoinput
doesn't help with this
Uncheck everything in autocorrect options
doesn't help either
Clear "Date acceptance patterns" box in Language settings > Languages
does not help and it goes back to what it was
So are there any methods missing in my list?
Again, I don't really want to start a debate. I just want to know if
things are the same or if they have changed.
Thanks
--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
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
- [libreoffice-users] Date/time autocorrection (update me) · Edwar Cifuentes
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.