Issue 106336 - dates' automatic formatting
Summary: dates' automatic formatting
Status: CLOSED DUPLICATE of issue 77973
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 3.1
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2009-10-27 11:36 UTC by ulliani
Modified: 2009-12-03 17:17 UTC (History)
2 users (show)

See Also:
Issue Type: FEATURE
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
spreadsheet with automatically formatted dates (7.00 KB, text/plain)
2009-10-27 11:39 UTC, ulliani
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description ulliani 2009-10-27 11:36:29 UTC
I want to enter dates in the format MM/YY (09/10 means september 2010). I first
formatted cells to be in the MM/YY format, then entered strings like 09/09 or
04/09 etc. However, these are displayed as such in the cell, but in the formula
bar they appear as 10/09/2009. How do you remove this automatic formatting? More
generally, why don't you remove ALL  auomatic formatting from OO, and let people
choose if they want the program to read their minds and do things they don't
ask? It would be nice to include in next version a preliminary option like: do
you want OO to read your mind, e.g. automatically format lists, dates, names,
common phrases or do you want it to be inert and just respond to your commands
and let you define if and what automaticities you want to use? People like me
would definitely prefer the latter. 
Gabriele
Comment 1 ulliani 2009-10-27 11:39:58 UTC
Created attachment 65674 [details]
spreadsheet with automatically formatted dates
Comment 2 Rainer Bielefeld 2009-11-27 11:06:10 UTC
@ulliani 
Do you see any difference between your needs and those in Issue 77973?
Comment 3 ulliani 2009-12-03 16:25:18 UTC
My needs are more or less the same as those in issue 77973. What I would like is
a solution :-)
Comment 4 Rainer Bielefeld 2009-12-03 17:16:11 UTC
Due to cemments  from ulliani Thu Dec 3 16:25:18 +0000 2009

*** This issue has been marked as a duplicate of 77973 ***
Comment 5 Rainer Bielefeld 2009-12-03 17:17:09 UTC
I'm afraid there won't be a quick solution :-/