Apache OpenOffice (AOO) Bugzilla – Issue 37669
date entry in table fields resetted if format wrong
Last modified: 2013-02-07 22:35:53 UTC
Created a dbf table . tried inserting data in date field , when invalid dates are entered in correct date format with separators like 56/56/56 and saved , no error message is thrown. when i try to enter values in next record the invalid date is replaced with default date 12/30/99. when same invalid date is given without separators like 565656 and saved still no error message is thrown . but default date is replaced when i try to enter values in next field.
and when the query is run , after entering the invalid date fields , still it is displaying invalid dates . like select * from table_name; the invalid dates entry is given in attachment
correct prio to 3 see http://www.openoffice.org/scdocs/ddIssues_EnterModify.html#priority for details
hi vamshi11us, >>the invalid dates entry is given in attachment please attach the sample file, thanks. ps: from having a quick look at the dbf format i think that it supports text fields, only? This would then explain, that OOo at the same time seems to correct incorrect date fields when enterning them in OOo, but will save them in non-date-format.
Hi all, This is also the behaviour with the 1.1.x branch. I can also confirm that this is the case with date fields connected via ODBC to a mysql server. If an invalid date entry is made, no matter whether through a form or directly in a table, the invalid date is not checked, even if the option in the Control Properties is set. What OOo does however, is make the user believe that the entry is correct, and then switch it back to the OOo default start date of 1899. Confirming the behaviour. Alex
Who is "developer"? Back into pool
feature enhancement