Issue 90581 - Option to prevent auto completion of date
Summary: Option to prevent auto completion of date
Alias: None
Product: Calc
Classification: Application
Component: configuration (show other issues)
Version: OOo 2.4.1 RC2
Hardware: All All
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2008-06-10 20:39 UTC by orgopenoffice
Modified: 2014-05-03 13:57 UTC (History)
4 users (show)

See Also:
Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---

Sample Document (109.54 KB, application/x-vnd.oasis.opendocument.spreadsheet)
2013-09-28 07:29 UTC, Rainer Bielefeld
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description orgopenoffice 2008-06-10 20:39:36 UTC
My compliments for your efforts in producing a great programme.

Entering many alphanumeric strings in cells results in a routine in the 
programme changing the input into a date.
While this may be of use to some people probably most people would simply like 
what they typed to be displayed unchanged.
Would someone like to change the code so this automatic date entry could be 
disabled just as for example the paperclip thing in microsoft office can be 
turned off.

I know there are work arounds but since I and many others will never ever ever 
want any of my cell contents changed by the programme into something else, it 
would be good to be able to turn the "feature" off.

Basically my needs are very simple, I would like what I type in a cell to be 
displayed in the cell.
Comment 1 oc 2008-07-15 10:45:06 UTC
reassigning features and enhancements to user which
will be the default owner for those tasks (was introduced some time ago)
Comment 2 Rainer Bielefeld 2013-09-28 07:29:56 UTC
Created attachment 81664 [details]
Sample Document

Attached sample document shows some examples how auto date recognition leads to wrong results (headings with red background).

That needs some improvement, but there is no easy solution fulfilling all needs. I often have Spreadsheets where I would like to switch off auto date recognition for some cells and to leave it for other ones.
Comment 3 Edwin Sharp 2014-01-15 07:31:09 UTC
Description is truth.
Comment 4 Rainer Bielefeld 2014-05-03 13:57:06 UTC
*** Issue 124807 has been marked as a duplicate of this issue. ***