You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2013/11/23 21:48:37 UTC
[Bug 123740] New: NOW function - hour missing when date format
changed
https://issues.apache.org/ooo/show_bug.cgi?id=123740
Bug ID: 123740
Issue Type: DEFECT
Summary: NOW function - hour missing when date format changed
Product: Calc
Version: 4.1.0-dev
Hardware: PC
OS: Linux64
Status: CONFIRMED
Severity: normal
Priority: P3
Component: code
Assignee: issues@openoffice.apache.org
Reporter: elish@apache.org
CC: issues@openoffice.apache.org
1) File - New - Spreadsheet
2) Format - Styles and Formatting - Cell Styles
3) right click Default - Modify...
4) Numbers - Category=Date - Format=arbitrary format - OK
5) type into cell =now()
Only date is given, hour is missing.
AOO410m1(Build:9750) - Rev. 1539999
2013-11-09_04:08:11 - Rev. 1540252
Debian
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 123740] NOW function - hour missing when date format changed
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123740
Edwin Sharp <el...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
OS|Linux64 |All
--- Comment #1 from Edwin Sharp <el...@apache.org> ---
Same for
AOO410m1(Build:9750) - Rev. 1543812
Rev.1543812
Win 7
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 123740] NOW function - hour missing when date format changed
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123740
Edwin Sharp <el...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|CONFIRMED |RESOLVED
Resolution|--- |NOT_AN_ISSUE
--- Comment #3 from Edwin Sharp <el...@apache.org> ---
You are correct.
One has to use a user-defined format code to display both date and hour in the
desired format.
Thank you.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 123740] NOW function - hour missing when date format changed
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123740
bmarcelly <ma...@club-internet.fr> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |marcelly@club-internet.fr
--- Comment #2 from bmarcelly <ma...@club-internet.fr> ---
I don't understand this report.
If you format as date, without time, of course the time is not displayed.
But the time is still stored in the cell. You can show it from another cell
that refers the first (=A1) and is formatted as time.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.