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


    /**
     * Create a date for 31-Dec-1999: the serial number should be 36525.
     */
    public void test31Dec1999ToSerial() {
        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() {
        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() {
        SpreadsheetDate d = new SpreadsheetDate(31, MonthConstants.JANUARY, 
                2000);
        assertEquals(36556, d.toSerial());
    }

View Full Code Here

Examples of org.jfree.date.SpreadsheetDate


    /**
     * Create a date for 01-Feb-2000: the serial number should be 36557.
     */
    public void test01Feb2000ToSerial() {
        SpreadsheetDate d = new SpreadsheetDate(1, MonthConstants.FEBRUARY, 
                2000);
        assertEquals(36557, d.toSerial());
    }

View Full Code Here

Examples of org.jfree.date.SpreadsheetDate


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

View Full Code Here

Examples of org.jfree.date.SpreadsheetDate


    /**
     * Create a date for 29-Feb-2000: the serial number should be 36585.
     */
    public void test29feb2000ToSerial() {
        SpreadsheetDate d = new SpreadsheetDate(29, MonthConstants.FEBRUARY, 
                2000);
        assertEquals(36585, d.toSerial());
    }

View Full Code Here

Examples of org.jfree.date.SpreadsheetDate


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

View Full Code Here

Examples of org.jfree.date.SpreadsheetDate

    /**
     * Serialize an instance, restore it, and check for equality.
     */
    public void testSerialization() {


        final SpreadsheetDate d1 = new SpreadsheetDate(15, 4, 2000);
        SpreadsheetDate d2 = null;


        try {
            final ByteArrayOutputStream buffer = new ByteArrayOutputStream();
            final ObjectOutput out = new ObjectOutputStream(buffer);
            out.writeObject(d1);

View Full Code Here

Examples of org.jfree.date.SpreadsheetDate


    /**
     * Some checks for the getDescription() method.
     */
    public void testGetDescription() {
        SpreadsheetDate d1 = new SpreadsheetDate(15, 4, 2000);
        assertEquals(null, d1.getDescription());
        d1.setDescription("XYZ");
        assertEquals("XYZ", d1.getDescription());
    }

View Full Code Here

Examples of org.jfree.date.SpreadsheetDate


    /**
     * Some checks for the setDescription() method.
     */
    public void testSetDescription() {
        SpreadsheetDate d1 = new SpreadsheetDate(15, 4, 2000);
        assertEquals(null, d1.getDescription());
        d1.setDescription("XYZ");
        assertEquals("XYZ", d1.getDescription());
        d1.setDescription(null);
        assertEquals(null, d1.getDescription());
    }

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.