Bug 71747 - EDITING: 'insert current date' inserts also time and immediately
Summary: EDITING: 'insert current date' inserts also time and immediately
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Spreadsheet (show other bugs)
Version: 4.1.3.2 release
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-11-18 16:09 UTC by mkobylan
Modified: 2014-08-27 15:20 UTC (History)
2 users (show)

See Also:
i915 platform:
i915 features:


Attachments

Description mkobylan 2013-11-18 16:09:56 UTC
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.
Comment 1 GerardF 2013-11-18 20:09:07 UTC
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...
Comment 2 hans.schmidt.5 2014-08-27 14:55:10 UTC
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.