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.