public override string ToString()
{
switch (CellType)
{
case CellType.Blank:
return("");
case CellType.Boolean:
return(BooleanCellValue ? "TRUE" : "FALSE");
case CellType.Error:
return(ErrorEval.GetText(ErrorCellValue));
case CellType.Formula:
return(CellFormula);
case CellType.Numeric:
if (DateUtil.IsCellDateFormatted(this))
{
FormatBase sdf = new SimpleDateFormat("dd-MMM-yyyy");
//sdf.setTimeZone(LocaleUtil.getUserTimeZone());
return(sdf.Format(DateCellValue));
}
return(NumericCellValue + "");
case CellType.String:
return(RichStringCellValue.ToString());
default:
return("Unknown Cell Type: " + CellType);
}
}
/// <summary>
/// Returns a string representation of the cell
/// </summary>
/// <returns>Formula cells return the formula string, rather than the formula result.
/// Dates are displayed in dd-MMM-yyyy format
/// Errors are displayed as #ERR<errIdx>
/// </returns>
public override String ToString()
{
switch (CellType)
{
case CellType.BLANK:
return("");
case CellType.BOOLEAN:
return(BooleanCellValue ? "TRUE" : "FALSE");
case CellType.ERROR:
return(ErrorEval.GetText(ErrorCellValue));
case CellType.FORMULA:
return(CellFormula);
case CellType.NUMERIC:
if (DateUtil.IsCellDateFormatted(this))
{
FormatBase sdf = new SimpleDateFormat("dd-MMM-yyyy");
return(sdf.Format(DateCellValue, CultureInfo.CurrentCulture));
}
return(NumericCellValue + "");
case CellType.STRING:
return(RichStringCellValue.ToString());
default:
return("Unknown Cell Type: " + CellType);
}
}
