Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||numbers as dates|
|Component:||formatting||Assignee:||AOO issues mailing list <issues>|
|Status:||UNCONFIRMED ---||QA Contact:|
|Issue Type:||DEFECT||Latest Confirmation in:||---|
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?