Issue 125162

Summary: numbers as dates
Product: Calc Reporter: occurs-60189
Component: formattingAssignee: AOO issues mailing list <issues>
Status: UNCONFIRMED --- QA Contact:
Severity: Normal    
Priority: P3 Keywords: needmoreinfo
Version: 4.0.1   
Target Milestone: ---   
Hardware: PC   
OS: Windows 7   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

Description occurs-60189 2014-06-26 14:14:05 UTC
Many times when I enter a number (even a number smaller than 5 digits) in a cell formatted as number, it shows up as a date; if I then delete that entry and re-enter the same number in the same cell it shows as a number (as desired).    WHY?    I typically enter many numbers without paying much attention, then when I look back expecting to see the numbers entered, I instead see dates! That is very frustrating & requires doing double work to correct the problem. The numbers I enter are actual numbers, not formulas that produce numbers.
Comment 1 mroe 2014-10-14 13:40:59 UTC
Please describe step by step how to reproduce this issue.
It could help if you attach a sample spreadsheet where the cells have the used formatting.
Is this issue reproducible with AOO 4.1.1?