/** * Adds cells to the specified sheet which test the various date formats * * @param s */ private void writeDateFormatSheet(WritableSheet s) { WritableCellFormat wrappedText = new WritableCellFormat(WritableWorkbook.ARIAL_10_PT); wrappedText.setWrap(true); s.setColumnView(0, 20); s.setColumnView(2, 20); s.setColumnView(3, 20); s.setColumnView(4, 20); s.getSettings().setFitWidth(2); s.getSettings().setFitHeight(2); // TODO: CML - fix this with DateTime support //Calendar c = Calendar.getInstance(TimeZone.getTimeZone("GMT")); //c.set(1975, 4, 31, 15, 21, 45); //c.set(Calendar.MILLISECOND, 660); //Date date = c.getTime(); //c.set(1900, 0, 1, 0, 0, 0); //c.set(Calendar.MILLISECOND, 0); //Date date2 = c.getTime(); //c.set(1970, 0, 1, 0, 0, 0); //Date date3 = c.getTime(); //c.set(1918, 10, 11, 11, 0, 0); //Date date4 = c.getTime(); //c.set(1900, 0, 2, 0, 0, 0); //Date date5 = c.getTime(); //c.set(1901, 0, 1, 0, 0, 0); //Date date6 = c.getTime(); //c.set(1900, 4, 31, 0, 0, 0); //Date date7 = c.getTime(); //c.set(1900, 1, 1, 0, 0, 0); //Date date8 = c.getTime(); //c.set(1900, 0, 31, 0, 0, 0); //Date date9 = c.getTime(); //c.set(1900, 2, 1, 0, 0, 0); //Date date10 = c.getTime(); //c.set(1900, 1, 27, 0, 0, 0); //Date date11 = c.getTime(); //c.set(1900, 1, 28, 0, 0, 0); //Date date12 = c.getTime(); //c.set(1980, 5, 31, 12, 0, 0); //Date date13 = c.getTime(); //c.set(1066, 9, 14, 0, 0, 0); //Date date14 = c.getTime(); //// Built in date formats //SimpleDateFormat sdf = new SimpleDateFormat("dd MMM yyyy HH:mm:ss.SSS"); //sdf.setTimeZone(TimeZone.getTimeZone("GMT")); //Label l = new Label(0, 0, "All dates are " + sdf.format(date), wrappedText); //s.addCell(l); //l = new Label(0, 1, "Built in formats", // wrappedText); //s.addCell(l); //l = new Label(2, 1, "Custom formats"); //s.addCell(l); DateTime date = DateTime.UtcNow; WritableCellFormat cf1 = new WritableCellFormat(DateFormats.FORMAT1); ExcelDateTime dt = new ExcelDateTime(0, 2, date, cf1, ExcelDateTime.GMT); s.addCell(dt); cf1 = new WritableCellFormat(DateFormats.FORMAT2); dt = new ExcelDateTime(0, 3, date, cf1, ExcelDateTime.GMT); s.addCell(dt); cf1 = new WritableCellFormat(DateFormats.FORMAT3); dt = new ExcelDateTime(0, 4, date, cf1); s.addCell(dt); cf1 = new WritableCellFormat(DateFormats.FORMAT4); dt = new ExcelDateTime(0, 5, date, cf1); s.addCell(dt); cf1 = new WritableCellFormat(DateFormats.FORMAT5); dt = new ExcelDateTime(0, 6, date, cf1); s.addCell(dt); cf1 = new WritableCellFormat(DateFormats.FORMAT6); dt = new ExcelDateTime(0, 7, date, cf1); s.addCell(dt); cf1 = new WritableCellFormat(DateFormats.FORMAT7); dt = new ExcelDateTime(0, 8, date, cf1, ExcelDateTime.GMT); s.addCell(dt); cf1 = new WritableCellFormat(DateFormats.FORMAT8); dt = new ExcelDateTime(0, 9, date, cf1, ExcelDateTime.GMT); s.addCell(dt); cf1 = new WritableCellFormat(DateFormats.FORMAT9); dt = new ExcelDateTime(0, 10, date, cf1, ExcelDateTime.GMT); s.addCell(dt); cf1 = new WritableCellFormat(DateFormats.FORMAT10); dt = new ExcelDateTime(0, 11, date, cf1, ExcelDateTime.GMT); s.addCell(dt); cf1 = new WritableCellFormat(DateFormats.FORMAT11); dt = new ExcelDateTime(0, 12, date, cf1, ExcelDateTime.GMT); s.addCell(dt); cf1 = new WritableCellFormat(DateFormats.FORMAT12); dt = new ExcelDateTime(0, 13, date, cf1, ExcelDateTime.GMT); s.addCell(dt); // Custom formats DateFormat df = new DateFormat("dd MM yyyy"); cf1 = new WritableCellFormat(df); Label l = new Label(2, 2, "dd MM yyyy"); s.addCell(l); dt = new ExcelDateTime(3, 2, date, cf1, ExcelDateTime.GMT); s.addCell(dt); df = new DateFormat("dd MMM yyyy"); cf1 = new WritableCellFormat(df); l = new Label(2, 3, "dd MMM yyyy"); s.addCell(l); dt = new ExcelDateTime(3, 3, date, cf1, ExcelDateTime.GMT); s.addCell(dt); df = new DateFormat("hh:mm"); cf1 = new WritableCellFormat(df); l = new Label(2, 4, "hh:mm"); s.addCell(l); dt = new ExcelDateTime(3, 4, date, cf1, ExcelDateTime.GMT); s.addCell(dt); df = new DateFormat("hh:mm:ss"); cf1 = new WritableCellFormat(df); l = new Label(2, 5, "hh:mm:ss"); s.addCell(l); dt = new ExcelDateTime(3, 5, date, cf1, ExcelDateTime.GMT); s.addCell(dt); df = new DateFormat("H:mm:ss a"); cf1 = new WritableCellFormat(df); l = new Label(2, 5, "H:mm:ss a"); s.addCell(l); dt = new ExcelDateTime(3, 5, date, cf1, ExcelDateTime.GMT); s.addCell(dt); dt = new ExcelDateTime(4, 5, date, cf1, ExcelDateTime.GMT); // dt = new ExcelDateTime(4, 5, date13, cf1, ExcelDateTime.GMT); s.addCell(dt); df = new DateFormat("mm:ss.SSS"); cf1 = new WritableCellFormat(df); l = new Label(2, 6, "mm:ss.SSS"); s.addCell(l); dt = new ExcelDateTime(3, 6, date, cf1, ExcelDateTime.GMT); s.addCell(dt); df = new DateFormat("hh:mm:ss a"); cf1 = new WritableCellFormat(df); l = new Label(2, 7, "hh:mm:ss a"); s.addCell(l); // dt = new ExcelDateTime(4, 7, date13, cf1, ExcelDateTime.GMT); dt = new ExcelDateTime(4, 7, date, cf1, ExcelDateTime.GMT); s.addCell(dt); // Check out the zero date ie. 1 Jan 1900 // l = new Label(0, 16, "Zero date " + sdf.format(date2),wrappedText); // s.addCell(l); cf1 = new WritableCellFormat(DateFormats.FORMAT9); //dt = new ExcelDateTime(0, 17, date2, cf1, ExcelDateTime.GMT); //s.addCell(dt); // Check out the zero date + 1 ie. 2 Jan 1900 //l = new Label(3, 16, "Zero date + 1 " + sdf.format(date5), // wrappedText); //s.addCell(l); //cf1 = new WritableCellFormat(DateFormats.FORMAT9); //dt = new ExcelDateTime(3, 17, date5, cf1, ExcelDateTime.GMT); //s.addCell(dt); //// Check out the 1 Jan 1901 //l = new Label(3, 19, sdf.format(date6), // wrappedText); //s.addCell(l); //cf1 = new WritableCellFormat(DateFormats.FORMAT9); //dt = new ExcelDateTime(3, 20, date6, cf1, ExcelDateTime.GMT); //s.addCell(dt); //// Check out the 31 May 1900 //l = new Label(3, 22, sdf.format(date7), // wrappedText); //s.addCell(l); //cf1 = new WritableCellFormat(DateFormats.FORMAT9); //dt = new ExcelDateTime(3, 23, date7, cf1, ExcelDateTime.GMT); //s.addCell(dt); //// Check out 1 Feb 1900 //l = new Label(3, 25, sdf.format(date8), // wrappedText); //s.addCell(l); //cf1 = new WritableCellFormat(DateFormats.FORMAT9); //dt = new ExcelDateTime(3, 26, date8, cf1, ExcelDateTime.GMT); //s.addCell(dt); //// Check out 31 Jan 1900 //l = new Label(3, 28, sdf.format(date9), // wrappedText); //s.addCell(l); //cf1 = new WritableCellFormat(DateFormats.FORMAT9); //dt = new ExcelDateTime(3, 29, date9, cf1, ExcelDateTime.GMT); //s.addCell(dt); //// Check out 31 Jan 1900 //l = new Label(3, 28, sdf.format(date9), // wrappedText); //s.addCell(l); //cf1 = new WritableCellFormat(DateFormats.FORMAT9); //dt = new ExcelDateTime(3, 29, date9, cf1, ExcelDateTime.GMT); //s.addCell(dt); //// Check out 1 Mar 1900 //l = new Label(3, 31, sdf.format(date10), // wrappedText); //s.addCell(l); //cf1 = new WritableCellFormat(DateFormats.FORMAT9); //dt = new ExcelDateTime(3, 32, date10, cf1, ExcelDateTime.GMT); //s.addCell(dt); //// Check out 27 Feb 1900 //l = new Label(3, 34, sdf.format(date11), // wrappedText); //s.addCell(l); //cf1 = new WritableCellFormat(DateFormats.FORMAT9); //dt = new ExcelDateTime(3, 35, date11, cf1, ExcelDateTime.GMT); //s.addCell(dt); //// Check out 28 Feb 1900 //l = new Label(3, 37, sdf.format(date12), // wrappedText); //s.addCell(l); //cf1 = new WritableCellFormat(DateFormats.FORMAT9); //dt = new ExcelDateTime(3, 38, date12, cf1, ExcelDateTime.GMT); //s.addCell(dt); //// Check out the zero date ie. 1 Jan 1970 //l = new Label(0, 19, "Zero UTC date " + sdf.format(date3), // wrappedText); //s.addCell(l); //cf1 = new WritableCellFormat(DateFormats.FORMAT9); //dt = new ExcelDateTime(0, 20, date3, cf1, ExcelDateTime.GMT); //s.addCell(dt); //// Check out the WWI armistice day ie. 11 am, Nov 11, 1918 //l = new Label(0, 22, "Armistice date " + sdf.format(date4), // wrappedText); //s.addCell(l); //cf1 = new WritableCellFormat(DateFormats.FORMAT9); //dt = new ExcelDateTime(0, 23, date4, cf1, ExcelDateTime.GMT); //s.addCell(dt); //// Check out the Battle of Hastings date Oct 14th, 1066 //l = new Label(0, 25, "Battle of Hastings " + sdf.format(date14), // wrappedText); //s.addCell(l); //cf1 = new WritableCellFormat(DateFormats.FORMAT2); //dt = new ExcelDateTime(0, 26, date14, cf1, ExcelDateTime.GMT); //s.addCell(dt); }
/** * Copy constructor used for deep copying * * @param col the column * @param row the row * @param dt the date to copy */ protected ExcelDateTime(int col, int row, ExcelDateTime dt) : base(col, row, dt) { }
/** * Copy constructor used for deep copying * * @param col the column * @param row the row * @param dt the date to copy */ protected ExcelDateTime(int col,int row,ExcelDateTime dt) : base(col,row,dt) { }