Issue 26026 - Custom Format Mmm of Month Function Only Returns "Jan"
Summary: Custom Format Mmm of Month Function Only Returns "Jan"
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-03-01 22:47 UTC by calummurdo
Modified: 2004-03-02 11:05 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description calummurdo 2004-03-01 22:47:12 UTC 
If you put in a date e.g. 2/3/4 in A1 and then put =month(a1) in B2 you get 3 as
the answer. 
If you then right click on B2 and select Format and create a user defined format
of Mmm it returns Jan rather than Mar.
Comment 1 frank 2004-03-02 11:05:27 UTC 
Hi,

this is not a bug. Month() returns a number, in this case 3 (if locales are set
to use ddmmyy). This numbers is made to a serial date using the custom
numberformat. Zero (0) is the serial number for 30.12.1899, so 3 is the serial
date for 02.01.1900 and therefore the numberformat MMM is set to January. As you
can see this is not a bug.

Frank
Comment 2 frank 2004-03-02 11:05:45 UTC 
closed invalid