Bug 198910 Date type data should be exported as Date type in Excel[1203]
Description: Date type data should be exported as Date type in Excel Build number:2.2.1.v20070806 Steps to reproduce: 1. New a report parameter p1, Date type, input value as 03/12/2007. 2. Drag it to Layout, set data binding type as Date. 3. Export the report to excel. 4. Open the excel, select the cell with the date value. 5. Select in main menu Format->Cells->Number->Date, select a format, click OK. Expected result: Format works. Actual result: Format doesn't work, check xls file and find that "<Data ss:Type="String">Mar 12, 2005</Data>". Error log:n/a
engine/org.eclipse.birt.report.engine.emitter.prototype.excel/src/org/eclipse/birt/report/engine/emitter/excel/StyleConstant.java
public static final int FONT_STYLE_PROP = 2;
    public static final int FONT_WEIGHT_PROP = 3;
    
    public static final int TEXT_LINE_THROUGH_PROP = 4;
    public static final int TEXT_UNDERLINE_PROP = 5;
    
    public static final int BACKGROUND_COLOR_PROP = 6;
    public static final int COLOR_PROP = 7;
    
    public static final int H_ALIGN_PROP = 8;
    public static final int V_ALIGN_PROP = 9;
    
    public static final int BORDER_BOTTOM_COLOR_PROP = 10;
    public static final int BORDER_BOTTOM_STYLE_PROP = 11;
    public static final int BORDER_BOTTOM_WIDTH_PROP = 12;
    
    public static final int BORDER_TOP_COLOR_PROP = 13;
    public static final int BORDER_TOP_STYLE_PROP = 14;
    public static final int BORDER_TOP_WIDTH_PROP = 15;
    
    public static final int BORDER_LEFT_COLOR_PROP = 16;
    public static final int BORDER_LEFT_STYLE_PROP = 17;
    public static final int BORDER_LEFT_WIDTH_PROP = 18;
    
    public static final int BORDER_RIGHT_COLOR_PROP = 19;
    public static final int BORDER_RIGHT_STYLE_PROP = 20;
    public static final int BORDER_RIGHT_WIDTH_PROP = 21;
	public static final String NULL = "NULL";    
}