Feature 'Insert current date' (shortcut CTRL+;) inserts not only current date but also current time (full time stamp). This is different from ms excel and that breaks some formulas. Though cell is formatted as date only but you can clearly see there's time too in input line. In addition date and time is put into cell without confirmation with Enter. This is different from ms excel and disallows user to add some text after the date. Shortcut key doesn't work when editing cell. This is different from ms excel and disallows user to add some text before the date. Excel's behavior of this feature is more flexible. Workaround is to delete time afterwards (which may take more time than entering date manually) and/or add text before&after date.
Confirmed. Insert current date (Ctrl+;) and Insert current time (Ctrl+Shift+;) insert both the current Date-Time. Only format is different. It could be source of error. About the 2nd problem, Insert in Edit mode, I'm not an Excel user and can't confirm this way if entering date stamp and if this is really usefull...
I also confirm this (Version 4.3.0.4). This is especially wrong if calculating the difference between two dates. For example: 2014-08-27 minus 2014-08-26 should be 1. But, if 'Insert current date' is used, the time will be used in calculation as well. For example: 2014-08-27 14:00 minus 2014-08-26 16:00 equals 0.9166666667. This is even done if the cell formatting is set to date only. Please fix this. This is clearly a bug :) Thanks!
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.