| java.lang.Object org.jfree.date.SerialDate org.jfree.date.SpreadsheetDate
SpreadsheetDate | public class SpreadsheetDate extends SerialDate (Code) | | Represents a date using an integer, in a similar fashion to the
implementation in Microsoft Excel. The range of dates supported is
1-Jan-1900 to 31-Dec-9999.
Be aware that there is a deliberate bug in Excel that recognises the year
1900 as a leap year when in fact it is not a leap year. You can find more
information on the Microsoft website in article Q181370:
http://support.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 |
Constructor Summary | |
public | SpreadsheetDate(int day, int month, int year) Creates a new date instance. | public | SpreadsheetDate(int serial) Standard constructor - creates a new date object representing the
specified day number (which should be in the range 2 to 2958465. |
Method Summary | |
public int | compare(SerialDate other) Returns the difference (in days) between this date and the specified
'other' date.
Parameters: other - the date being compared to. | public int | compareTo(Object other) Implements the method required by the Comparable interface.
Parameters: other - the other object (usually another SerialDate). | public boolean | equals(Object object) Tests the equality of this date with an arbitrary object.
This method will return true ONLY if the object is an instance of the
SerialDate base class, and it represents the same day as this
SpreadsheetDate .
Parameters: object - the object to compare (null permitted). | public int | getDayOfMonth() Returns the day of the month. | public int | getDayOfWeek() Returns a code representing the day of the week. | public int | getMonth() Returns the month (January = 1, February = 2, March = 3). | public int | getYYYY() Returns the year (assume a valid range of 1900 to 9999). | public int | hashCode() Returns a hash code for this object instance. | public boolean | isAfter(SerialDate other) Returns true if this SerialDate represents the same date as the
specified SerialDate.
Parameters: other - the date being compared to. | public boolean | isBefore(SerialDate other) Returns true if this SerialDate represents an earlier date compared to
the specified SerialDate.
Parameters: other - the date being compared to. | public boolean | isInRange(SerialDate d1, SerialDate d2) Returns true if this
SerialDate is within the
specified range (INCLUSIVE). | public boolean | isInRange(SerialDate d1, SerialDate d2, int include) Returns true if this SerialDate is within the specified range (caller
specifies whether or not the end-points are included). | public boolean | isOn(SerialDate other) Returns true if this SerialDate represents the same date as the
specified SerialDate.
Parameters: other - the date being compared to. | public boolean | isOnOrAfter(SerialDate other) Returns true if this SerialDate represents the same date as the
specified SerialDate.
Parameters: other - the date being compared to. | public boolean | isOnOrBefore(SerialDate other) Returns true if this SerialDate represents the same date as the
specified SerialDate.
Parameters: other - the date being compared to. | public Date | toDate() Returns a java.util.Date equivalent to this date. | public int | toSerial() Returns the serial number for the date, where 1 January 1900 = 2
(this corresponds, almost, to the numbering system used in Microsoft
Excel for Windows and Lotus 1-2-3). |
SpreadsheetDate | public SpreadsheetDate(int day, int month, int year)(Code) | | Creates a new date instance.
Parameters: day - the day (in the range 1 to 28/29/30/31). Parameters: month - the month (in the range 1 to 12). Parameters: year - the year (in the range 1900 to 9999). |
SpreadsheetDate | public SpreadsheetDate(int serial)(Code) | | Standard constructor - creates a new date object representing the
specified day number (which should be in the range 2 to 2958465.
Parameters: serial - the serial number for the day (range: 2 to 2958465). |
compare | public int compare(SerialDate other)(Code) | | Returns the difference (in days) between this date and the specified
'other' date.
Parameters: other - the date being compared to. The difference (in days) between this date and the specified 'other' date. |
compareTo | public int compareTo(Object other)(Code) | | Implements the method required by the Comparable interface.
Parameters: other - the other object (usually another SerialDate). A negative integer, zero, or a positive integer as this object is less than, equal to, or greater than the specified object. |
equals | public boolean equals(Object object)(Code) | | Tests the equality of this date with an arbitrary object.
This method will return true ONLY if the object is an instance of the
SerialDate base class, and it represents the same day as this
SpreadsheetDate .
Parameters: object - the object to compare (null permitted). A boolean. |
getDayOfMonth | public int getDayOfMonth()(Code) | | Returns the day of the month.
The day of the month. |
getDayOfWeek | public int getDayOfWeek()(Code) | | Returns a code representing the day of the week.
The codes are defined in the
SerialDate class as:
SUNDAY , MONDAY , TUESDAY ,
WEDNESDAY , THURSDAY , FRIDAY , and
SATURDAY .
A code representing the day of the week. |
getMonth | public int getMonth()(Code) | | Returns the month (January = 1, February = 2, March = 3).
The month of the year. |
getYYYY | public int getYYYY()(Code) | | Returns the year (assume a valid range of 1900 to 9999).
The year. |
hashCode | public int hashCode()(Code) | | Returns a hash code for this object instance.
A hash code. |
isAfter | public boolean isAfter(SerialDate other)(Code) | | Returns true if this SerialDate represents the same date as the
specified SerialDate.
Parameters: other - the date being compared to. true if this SerialDate represents the same dateas the specified SerialDate. |
isBefore | public boolean isBefore(SerialDate other)(Code) | | Returns true if this SerialDate represents an earlier date compared to
the specified SerialDate.
Parameters: other - the date being compared to. true if this SerialDate represents an earlier datecompared to the specified SerialDate. |
isInRange | public boolean isInRange(SerialDate d1, SerialDate d2)(Code) | | Returns true if this
SerialDate is within the
specified range (INCLUSIVE). The date order of d1 and d2 is not
important.
Parameters: d1 - a boundary date for the range. Parameters: d2 - the other boundary date for the range. A boolean. |
isInRange | public boolean isInRange(SerialDate d1, SerialDate d2, int include)(Code) | | Returns true if this SerialDate is within the specified range (caller
specifies whether or not the end-points are included). The order of d1
and d2 is not important.
Parameters: d1 - one boundary date for the range. Parameters: d2 - a second boundary date for the range. Parameters: include - a code that controls whether or not the start and end dates are included in the range. true if this SerialDate is within the specified range. |
isOn | public boolean isOn(SerialDate other)(Code) | | Returns true if this SerialDate represents the same date as the
specified SerialDate.
Parameters: other - the date being compared to. true if this SerialDate represents the same date asthe specified SerialDate. |
isOnOrAfter | public boolean isOnOrAfter(SerialDate other)(Code) | | Returns true if this SerialDate represents the same date as the
specified SerialDate.
Parameters: other - the date being compared to. true if this SerialDate represents the same date asthe specified SerialDate. |
isOnOrBefore | public boolean isOnOrBefore(SerialDate other)(Code) | | Returns true if this SerialDate represents the same date as the
specified SerialDate.
Parameters: other - the date being compared to. true if this SerialDate represents the same dateas the specified SerialDate. |
toDate | public Date toDate()(Code) | | Returns a java.util.Date equivalent to this date.
The date. |
toSerial | public int toSerial()(Code) | | Returns the serial number for the date, where 1 January 1900 = 2
(this corresponds, almost, to the numbering system used in Microsoft
Excel for Windows and Lotus 1-2-3).
The serial number of this date. |
Methods inherited from org.jfree.date.SerialDate | public static SerialDate addDays(int days, SerialDate base)(Code)(Java Doc) public static SerialDate addMonths(int months, SerialDate base)(Code)(Java Doc) public static SerialDate addYears(int years, SerialDate base)(Code)(Java Doc) abstract public int compare(SerialDate other)(Code)(Java Doc) public static SerialDate createInstance(int day, int month, int yyyy)(Code)(Java Doc) public static SerialDate createInstance(int serial)(Code)(Java Doc) public static SerialDate createInstance(java.util.Date date)(Code)(Java Doc) abstract public int getDayOfMonth()(Code)(Java Doc) abstract public int getDayOfWeek()(Code)(Java Doc) public String getDescription()(Code)(Java Doc) public SerialDate getEndOfCurrentMonth(SerialDate base)(Code)(Java Doc) public static SerialDate getFollowingDayOfWeek(int targetWeekday, SerialDate base)(Code)(Java Doc) public SerialDate getFollowingDayOfWeek(int targetDOW)(Code)(Java Doc) abstract public int getMonth()(Code)(Java Doc) public static String[] getMonths()(Code)(Java Doc) public static String[] getMonths(boolean shortened)(Code)(Java Doc) public static SerialDate getNearestDayOfWeek(int targetDOW, SerialDate base)(Code)(Java Doc) public SerialDate getNearestDayOfWeek(int targetDOW)(Code)(Java Doc) public static SerialDate getPreviousDayOfWeek(int targetWeekday, SerialDate base)(Code)(Java Doc) public SerialDate getPreviousDayOfWeek(int targetDOW)(Code)(Java Doc) abstract public int getYYYY()(Code)(Java Doc) abstract public boolean isAfter(SerialDate other)(Code)(Java Doc) abstract public boolean isBefore(SerialDate other)(Code)(Java Doc) abstract public boolean isInRange(SerialDate d1, SerialDate d2)(Code)(Java Doc) abstract public boolean isInRange(SerialDate d1, SerialDate d2, int include)(Code)(Java Doc) public static boolean isLeapYear(int yyyy)(Code)(Java Doc) abstract public boolean isOn(SerialDate other)(Code)(Java Doc) abstract public boolean isOnOrAfter(SerialDate other)(Code)(Java Doc) abstract public boolean isOnOrBefore(SerialDate other)(Code)(Java Doc) public static boolean isValidMonthCode(int code)(Code)(Java Doc) public static boolean isValidWeekInMonthCode(int code)(Code)(Java Doc) public static boolean isValidWeekdayCode(int code)(Code)(Java Doc) public static int lastDayOfMonth(int month, int yyyy)(Code)(Java Doc) public static int leapYearCount(int yyyy)(Code)(Java Doc) public static int monthCodeToQuarter(int code)(Code)(Java Doc) public static String monthCodeToString(int month)(Code)(Java Doc) public static String monthCodeToString(int month, boolean shortened)(Code)(Java Doc) public static String relativeToString(int relative)(Code)(Java Doc) public void setDescription(String description)(Code)(Java Doc) public static int stringToMonthCode(String s)(Code)(Java Doc) public static int stringToWeekdayCode(String s)(Code)(Java Doc) abstract public java.util.Date toDate()(Code)(Java Doc) abstract public int toSerial()(Code)(Java Doc) public String toString()(Code)(Java Doc) public static String weekInMonthToString(int count)(Code)(Java Doc) public static String weekdayCodeToString(int weekday)(Code)(Java Doc)
|
|
|