Summary: | EDITING: 'insert current date' inserts also time and immediately | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | mkobylan |
Component: | Spreadsheet | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | QA Contact: | |
Severity: | normal | ||
Priority: | medium | CC: | gerard.fargeot, hans.schmidt.5 |
Version: | 4.1.3.2 release | ||
Hardware: | Other | ||
OS: | Windows (All) | ||
Whiteboard: | |||
i915 platform: | i915 features: |
Description
mkobylan
2013-11-18 16:09:56 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... 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.