Examples of SpreadsheetDate

org.jfree.date.SpreadsheetDate
rt.microsoft.com/support/kb/articles/Q181/3/70.asp
Excel uses the convention that 1-Jan-1900 = 1. This class uses the convention 1-Jan-1900 = 2. The result is that the day number in this class will be different to the Excel figure for January and February 1900...but then Excel adds in an extra day (29-Feb-1900 which does not actually exist!) and from that point forward the day numbers will match. @author David Gilbert

Examples of org.jfree.date.SpreadsheetDate


    /**
     * Day 38353 is 1 Jan 2005.
     */
    public void test38353() {
        final SpreadsheetDate d = new SpreadsheetDate(38353);
        assertEquals(1, d.getDayOfMonth());
        assertEquals(MonthConstants.JANUARY, d.getMonth());
        assertEquals(2005, d.getYYYY());
    }

View Full Code Here

Examples of org.jfree.date.SpreadsheetDate


    /**
     * Create a date for serial number 36584: it should be 28-Feb-2000.
     */
    public void test36584() {
        final SpreadsheetDate d = new SpreadsheetDate(36584);
        assertEquals(28, d.getDayOfMonth());
        assertEquals(MonthConstants.FEBRUARY, d.getMonth());
        assertEquals(2000, d.getYYYY());
    }

View Full Code Here

Examples of org.jfree.date.SpreadsheetDate


    /**
     * Create a date for serial number 36585: it should be 29-Feb-2000.
     */
    public void test36585() {
        final SpreadsheetDate d = new SpreadsheetDate(36585);
        assertEquals(29, d.getDayOfMonth());
        assertEquals(MonthConstants.FEBRUARY, d.getMonth());
        assertEquals(2000, d.getYYYY());
    }

View Full Code Here

Examples of org.jfree.date.SpreadsheetDate


    /**
     * Create a date for serial number 36586: it should be 1-Mar-2000.
     */
    public void test36586() {
        final SpreadsheetDate d = new SpreadsheetDate(36586);
        assertEquals(1, d.getDayOfMonth());
        assertEquals(MonthConstants.MARCH, d.getMonth());
        assertEquals(2000, d.getYYYY());
    }

View Full Code Here

Examples of org.jfree.date.SpreadsheetDate


    /**
     * Create a date for 28-Feb-1900: the serial number should be 60.
     */
    public void test28Feb1900ToSerial() {
        final SpreadsheetDate d = new SpreadsheetDate(28, MonthConstants.FEBRUARY, 1900);
        assertEquals(60, d.toSerial());
    }

View Full Code Here

Examples of org.jfree.date.SpreadsheetDate


    /**
     * Create a date for 01-Mar-1900: the serial number should be 61.
     */
    public void test01Mar1900ToSerial() {
        final SpreadsheetDate d = new SpreadsheetDate(1, MonthConstants.MARCH, 1900);
        assertEquals(61, d.toSerial());
    }

View Full Code Here

Examples of org.jfree.date.SpreadsheetDate


    /**
     * Create a date for 31-Dec-1999: the serial number should be 36525.
     */
    public void test31Dec1999ToSerial() {
        final SpreadsheetDate d = new SpreadsheetDate(31, MonthConstants.DECEMBER, 1999);
        assertEquals(36525, d.toSerial());
    }

View Full Code Here

Examples of org.jfree.date.SpreadsheetDate


    /**
     * Create a date for 1-Jan-2000: the serial number should be 36526.
     */
    public void test01Jan2000ToSerial() {
        final SpreadsheetDate d = new SpreadsheetDate(1, MonthConstants.JANUARY, 2000);
        assertEquals(36526, d.toSerial());
    }

View Full Code Here

Examples of org.jfree.date.SpreadsheetDate


    /**
     * Create a date for 31-Jan-2000: the serial number should be 36556.
     */
    public void test31Jan2000ToSerial() {
        final SpreadsheetDate d = new SpreadsheetDate(31, MonthConstants.JANUARY, 2000);
        assertEquals(36556, d.toSerial());
    }

View Full Code Here

Examples of org.jfree.date.SpreadsheetDate


    /**
     * Setup.
     */
    protected void setUp() {
        this.jan1Y1900 = new SpreadsheetDate(1, MonthConstants.JANUARY, 1900);
        this.s2 = new SpreadsheetDate(2);
    }

View Full Code Here

0 1 2 3 4 5

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.