/// <summary>
/// Format specified cell
/// </summary>
/// <param name="cell">cell to be formatted</param>
/// <param name="culture">culture for parsing</param>
/// <returns>Formatted text used to display as cell content</returns>
public string FormatCell(Cell cell, CultureInfo culture)
{
object data = cell.InnerData;
double percent = 0;
bool isFormat = false;
if (data is double)
{
percent = (double)data;
isFormat = true;
}
else if (data is DateTime dt)
{
percent = dt.ToOADate();
isFormat = true;
}
else
{
string str = Convert.ToString(data);
if (str.Length > 1 && str.EndsWith("%"))
{
// string ends with "%"
str = str.Substring(0, str.Length - 1);
isFormat = double.TryParse(str, NumberStyles.Any, culture, out percent);
percent /= 100d;
}
else
{
// string ends without "%"
isFormat = double.TryParse(str, NumberStyles.Any, culture, out percent);
}
if (isFormat)
{
cell.InnerData = percent;
}
}
if (isFormat)
{
var arg = cell.DataFormatArgs as NumberDataFormatter.INumberFormatArgs;
var format = NumberDataFormatter.FormatNumberCellAndGetPattern(cell, ref percent, arg);
return(percent.ToString(format + "%"));
}
return(null);
}
public string FormatCell(Cell cell)
{
object data = cell.InnerData;
double percent = 0;
bool isFormat = false;
short digits = 0;
string formattedText = null;
if (data is double)
{
percent = (double)data;
isFormat = true;
digits = 9;
}
else if (data is DateTime)
{
percent = ((DateTime)data - new DateTime(1900, 1, 1)).TotalDays;
isFormat = true;
digits = 0;
}
else
{
string str = Convert.ToString(data);
if (str.Length > 1 && str.EndsWith("%"))
{
// string ends with "%"
str = str.Substring(0, str.Length - 1);
isFormat = double.TryParse(str, out percent);
if (isFormat)
{
percent /= 100d;
int decimalDigits = (short)str.LastIndexOf(Thread.CurrentThread.CurrentCulture.NumberFormat.NumberDecimalSeparator);
if (decimalDigits >= 0)
{
digits = (short)(str.Length - 1 - decimalDigits);
}
}
}
else
{
// string ends without "%"
isFormat = double.TryParse(str, out percent);
if (isFormat)
{
int decimalDigits = (short)str.LastIndexOf(Thread.CurrentThread.CurrentCulture.NumberFormat.NumberDecimalSeparator);
if (decimalDigits >= 0)
{
digits = (short)(str.Length - 1 - decimalDigits);
}
}
else
{
// try convert from datetime
DateTime date = new DateTime(1900, 1, 1);
if (DateTime.TryParse(str, out date))
{
percent = (date - new DateTime(1900, 1, 1)).TotalDays;
isFormat = true;
}
}
}
if (isFormat)
{
cell.InnerData = percent;
}
}
if (isFormat)
{
//if (cell.DataFormatArgs != null && cell.DataFormatArgs is NumberDataFormatter.NumberFormatArgs)
//{
// digits = ((NumberDataFormatter.NumberFormatArgs)cell.DataFormatArgs).DecimalPlaces;
//}
//else
//{
// cell.DataFormatArgs = new NumberDataFormatter.NumberFormatArgs { DecimalPlaces = digits };
//}
//string decimalPlacePart = new string('0', digits);
//formattedText = (percent * 100).ToString("0." + decimalPlacePart) + "%";
//if (cell.InnerStyle.HAlign == ReoGridHorAlign.General)
//{
// cell.RenderHorAlign = ReoGridRenderHorAlign.Right;
//}
var format = NumberDataFormatter.FormatNumberCellAndGetPattern(cell, ref percent,
cell.DataFormatArgs as NumberDataFormatter.INumberFormatArgs);
return(percent.ToString(format + "%"));
}
return(isFormat ? formattedText : null);
}