Issue 116771 - date format failes on input '1/2/11'
Summary: date format failes on input '1/2/11'
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 1.0.0
Hardware: Unknown Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
: 126957 (view as issue list)
Depends on:
Reported: 2011-02-02 21:35 UTC by jaooo
Modified: 2016-05-07 12:26 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.0.0
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description jaooo 2011-02-02 21:35:39 UTC

not used to your bug report system but bear with me.

tonight I attempted to make a date input into a spreadsheet already formatted as
nn:d:mm:yy. (spaces not : as shown)

I attempted as usual to enter the date as 1/2/11.

however it was formatted as 1/2 (fraction) and 11.

I understand this is not too important for myself but could be for other users.
Also it could be a warning of future errors in similarity.

2/2/11 turned out OK and attempting to reformat the cells in the column made no
difference, even after re-inputting.

screenshots wont really help in this case.. but i thought it worth reporting.

Linux debian 2.6.35-23-generic #41~lucid1-Ubuntu SMP Thu Dec 2 22:30:17 UTC 2010
i686 GNU/Linux 3.2.1 
OOO320m19 (Build:9505)
ooo-build, Ubuntu package 1:3.2.1-6ubuntu2~10.04.1
Comment 1 Marcus 2011-02-03 14:48:36 UTC
it's not a bug, it's a feature ;-)

there is an automatism to replace specific input while typing, here it's to
replace "1/2" with "½", it's the same with "1/4" or 3/4"

you can turn this off via menu "Tools - AutoCorrect Options - Replace", just
delete the line with the 1/2 item

this feature exists also in the other applications
Comment 2 Marcus 2011-02-03 14:48:50 UTC
Comment 3 jaooo 2011-02-05 16:40:22 UTC
Sorry I disagree,

If the spreadsheet cell is formatted as date then the 1/2/11 input should come
out as a date not a fraction. it actually came out as 1/2 in small type followed
immediately by /11 in normal type.

I believe this is a formatting error and may get repeated, damage date
calculations etc within a spreadsheet. please reconsider it as a possibly
serious bug.

Comment 4 Edwin Sharp 2013-05-03 14:08:08 UTC
Date is transformed to half/11 on Rev. 1476029 Win 7

Tools - AutoCorrect Options... - Replace works when half is replaced with 1/2.

The more intuitive way: Format Cells... - Numbers - Date does not work.
Comment 5 oooforum (fr) 2016-05-07 12:26:21 UTC
*** Issue 126957 has been marked as a duplicate of this issue. ***