Villeroy wrote:It uses some simple assumtions when it tries to guess what you intent to enter. You can override this at any time for each single cell or many cells at once.
Falkewave wrote:Is there a way to override this "feature" when opening a file that already contains strings that Calc will assume are dates?
Falkewave wrote:As of now, Calc is automatically changing these strings as soon as the file is loaded.
Falkewave wrote:Changing the format to "Text" does nothing in this case.
Villeroy wrote:Number format "Text" (no number at all) takes all input as literal string.
Villeroy wrote:If you are working with plain text files or text-tables in the clipboard, you can specify how to interprete each field's input values. Just pick a column in the import dialog and change it from "Standard" to "Text", "US-English", "Date(YMD)", "Date(MDY)", "Date(DMY)".
Unfortunately, there is only one single feature where Calc does not give you the control: menu:Insert>External Data... where you can link a range to a html-table. None of the above methods prevents 12-03 to be imported as numeric "12th of March" or "Dec the 3rd" respectively, depending on your application locale (US style or not). It overwrites all previously existing formatting, trying to apply some of the html-tags.
|Edit: OOo 3.3 fixed the html issue. You can turn off any detection of "special numbers" such as dates|
autoformatsufferer wrote:So many people complain about this, why don't you just add an option to disable any autoformatting at all.
autoformatsufferer wrote:I suffer from this every time I use a spreadsheet. gcb's example is easily reproduced and very annoying and clearly does change the value. So many people complain about this, why don't you just add an option to disable any autoformatting at all. Even if everything I enter is assumed to be text, unless I explicitly format it as something else, it would be better than the constant wrong guesses.
This IS actually a form of Autocorrect, a god-damn annoying one,
JustPassingThru wrote:How can I tell Calc to stop "helping" me, and just take what I type as "text and text only, I mean it." for one cell only, or for a range of cells, or for one sheet, or forever (or until I change it).
Thoskk wrote:All those solutions are very inconvenient if you try to work efficiently and quick.
I do not want to pre-format every single cell in a row of 100 or more to suit the input I don't even know before.
It would be much more convenient to firstly take what the user puts in 'as is', and maybe then let him choose from some kind of dropdown menu or similar (as in excel), if he want's to keep the format or change it, and if always to do so or not.
Even worse is the fact that when I type something like 24/7 in German language setup, Calc changes it to a date format anyway - although in German language the date is written 24.7. ! That really should be changed.
I don't like MS Office programs for automatically changing many things and calling the user a stupid nerd for it. But at least, I can switch off ANY automatism in MS Office programs. Why not in OO?
TheGurkha wrote:JustPassingThru wrote:How can I tell Calc to stop "helping" me, and just take what I type as "text and text only, I mean it." for one cell only, or for a range of cells, or for one sheet, or forever (or until I change it).
As was stated above, format the cells as text before you type into them:
Highlight the cells (or the entire sheet if you want) and go to Format > Cells > Numbers Tab > select Text from the Category drop down menu.
Edit: Oops--sorry. My bad.|
You can disable the sort lists, as well as copying from previous cells, with Tools > Cell Contents > AutoInput: NO (unchecked).
teejangry wrote:I see the same behavior in OO Writer inside tables while autocorrect is turned off. This is an extremely irritating "feature" to have inside a text document.
Users browsing this forum: ahvdesign and 18 guests