Apache OpenOffice (AOO) Bugzilla – Issue 116771
date format failes on input '1/2/11'
Last modified: 2016-05-07 12:26:21 UTC
Hi 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 OpenOffice.org 3.2.1 OOO320m19 (Build:9505) ooo-build 3.2.1.4, Ubuntu package 1:3.2.1-6ubuntu2~10.04.1
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
closed
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. Thanks
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.
*** Issue 126957 has been marked as a duplicate of this issue. ***